File: /var/www/vhost/disk-apps/magento.bikenow.co/vendor/vertex/module-tax/etc/db_schema_whitelist.json
{
"vertex_taxrequest": {
"column": {
"request_id": true,
"request_type": true,
"quote_id": true,
"order_id": true,
"total_tax": true,
"source_path": true,
"tax_area_id": true,
"sub_total": true,
"total": true,
"lookup_result": true,
"request_date": true,
"request_xml": true,
"response_xml": true,
"response_time": true
},
"index": {
"VERTEX_TAXREQUEST_REQUEST_TYPE": true,
"VERTEX_TAXREQUEST_ORDER_ID": true
},
"constraint": {
"PRIMARY": true,
"VERTEX_TAXREQUEST_REQUEST_ID": true
}
},
"vertex_sales_creditmemo_item_invoice_text_code": {
"column": {
"item_id": true,
"invoice_text_code": true
},
"index": {
"VERTEX_SALES_CREDITMEMO_ITEM_INVOICE_TEXT_CODE_ITEM_ID": true,
"VERTEX_SALES_CREDITMEMO_ITEM_INVOICE_TEXT_CODE_INVOICE_TEXT_CODE": true
},
"constraint": {
"UNQ_4BC40DA748D7713ADA661D2DE1BCF161": true
}
},
"vertex_sales_creditmemo_item_tax_code": {
"column": {
"item_id": true,
"tax_code": true
},
"index": {
"VERTEX_SALES_CREDITMEMO_ITEM_TAX_CODE_ITEM_ID": true,
"VERTEX_SALES_CREDITMEMO_ITEM_TAX_CODE_TAX_CODE": true
},
"constraint": {
"VERTEX_SALES_CREDITMEMO_ITEM_TAX_CODE_ITEM_ID_TAX_CODE": true
}
},
"vertex_sales_creditmemo_item_vertex_tax_code": {
"column": {
"item_id": true,
"vertex_tax_code": true
},
"index": {
"VERTEX_SALES_CREDITMEMO_ITEM_VERTEX_TAX_CODE_ITEM_ID": true,
"VERTEX_SALES_CREDITMEMO_ITEM_VERTEX_TAX_CODE_VERTEX_TAX_CODE": true
},
"constraint": {
"UNQ_31D7AADB3412BC7E7C1C98D5CC3A5D46": true
}
},
"vertex_custom_option_flex_field": {
"column": {
"entity_id": true,
"option_id": true,
"website_id": true,
"flex_field": true
},
"index": {
"VERTEX_CUSTOM_OPTION_FLEX_FIELD_OPTION_ID": true,
"VERTEX_CUSTOM_OPTION_FLEX_FIELD_WEBSITE_ID": true
},
"constraint": {
"PRIMARY": true,
"VERTEX_CUSTOM_OPTION_FLEX_FIELD_OPTION_ID_WEBSITE_ID": true
}
},
"vertex_customer_code": {
"column": {
"customer_id": true,
"customer_code": true
},
"constraint": {
"PRIMARY": true
}
},
"vertex_order_invoice_status": {
"column": {
"order_id": true,
"sent_to_vertex": true
},
"constraint": {
"PRIMARY": true
}
},
"vertex_sales_order_item_invoice_text_code": {
"column": {
"item_id": true,
"invoice_text_code": true
},
"index": {
"VERTEX_SALES_ORDER_ITEM_INVOICE_TEXT_CODE_ITEM_ID": true,
"VERTEX_SALES_ORDER_ITEM_INVOICE_TEXT_CODE_INVOICE_TEXT_CODE": true
},
"constraint": {
"UNQ_96F6BE3160A4185CEA4D866018EAF6DC": true
}
},
"vertex_sales_order_item_tax_code": {
"column": {
"item_id": true,
"tax_code": true
},
"index": {
"VERTEX_SALES_ORDER_ITEM_TAX_CODE_ITEM_ID": true,
"VERTEX_SALES_ORDER_ITEM_TAX_CODE_TAX_CODE": true
},
"constraint": {
"VERTEX_SALES_ORDER_ITEM_TAX_CODE_ITEM_ID_TAX_CODE": true
}
},
"vertex_sales_order_item_vertex_tax_code": {
"column": {
"item_id": true,
"tax_code": true,
"vertex_tax_code": true
},
"index": {
"VERTEX_SALES_ORDER_ITEM_VERTEX_TAX_CODE_ITEM_ID": true,
"VERTEX_SALES_ORDER_ITEM_VERTEX_TAX_CODE_TAX_CODE": true,
"VERTEX_SALES_ORDER_ITEM_VERTEX_TAX_CODE_VERTEX_TAX_CODE": true
},
"constraint": {
"VERTEX_SALES_ORDER_ITEM_VERTEX_TAX_CODE_ITEM_ID_TAX_CODE": true,
"VERTEX_SALES_ORDER_ITEM_VERTEX_TAX_CODE_ITEM_ID_VERTEX_TAX_CODE": true
}
},
"vertex_invoice_sent": {
"column": {
"invoice_id": true,
"sent_to_vertex": true
},
"constraint": {
"PRIMARY": true
}
},
"sales_invoice": {
"column": {
"vertex_invoice_sent": true
}
},
"sales_order_address": {
"column": {
"tax_area_id": true,
"vertex_vat_country_code": true
}
},
"quote_address": {
"column": {
"tax_area_id": true
}
},
"vertex_customer_country": {
"column": {
"customer_id": true,
"customer_country": true
},
"constraint": {
"PRIMARY": true
}
},
"vertex_vat_country_code": {
"column": {
"address_id": true,
"customer_country": true
},
"constraint": {
"PRIMARY": true
}
},
"vertex_commodity_code_product": {
"column": {
"product_id": true,
"code": true,
"type": true
},
"constraint": {
"PRIMARY": true
}
},
"vertex_commodity_code_order_item": {
"column": {
"order_item_id": true,
"code": true,
"type": true
},
"constraint": {
"PRIMARY": true
}
}
}