po_header
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| Document_Type | varchar(50) | Yes | NULL | |||
| No (Primary) | varchar(50) | No | ||||
| Buy_from_Vendor_No | varchar(50) | Yes | NULL | |||
| Buy_from_Vendor_Name | varchar(255) | Yes | NULL | |||
| Posting_Description | varchar(255) | Yes | NULL | |||
| Buy_from_Address | varchar(255) | Yes | NULL | |||
| Buy_from_Address_2 | varchar(255) | Yes | NULL | |||
| Buy_from_Address_3 | varchar(255) | Yes | NULL | |||
| Buy_from_City | varchar(100) | Yes | NULL | |||
| Buy_from_County | varchar(100) | Yes | NULL | |||
| Buy_from_Post_Code | varchar(20) | Yes | NULL | |||
| Buy_from_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Buy_from_Contact_No | varchar(50) | Yes | NULL | |||
| BuyFromContactPhoneNo | varchar(50) | Yes | NULL | |||
| BuyFromContactMobilePhoneNo | varchar(50) | Yes | NULL | |||
| BuyFromContactEmail | varchar(150) | Yes | NULL | |||
| Buy_from_Contact | varchar(150) | Yes | NULL | |||
| Document_Date | date | Yes | NULL | |||
| Invoice_Received_Date | date | Yes | NULL | |||
| Posting_Date | date | Yes | NULL | |||
| VAT_Reporting_Date | date | Yes | NULL | |||
| Due_Date | date | Yes | NULL | |||
| Vendor_Invoice_No | varchar(100) | Yes | NULL | |||
| Your_Reference | varchar(100) | Yes | NULL | |||
| Purchaser_Code | varchar(50) | Yes | NULL | |||
| No_of_Archived_Versions | int(11) | Yes | NULL | |||
| Order_Date | date | Yes | NULL | |||
| Quote_No | varchar(100) | Yes | NULL | |||
| Vendor_Order_No | varchar(100) | Yes | NULL | |||
| Vendor_Shipment_No | varchar(100) | Yes | NULL | |||
| PR_No | varchar(100) | Yes | NULL | |||
| Order_Address_Code | varchar(50) | Yes | NULL | |||
| Responsibility_Center | varchar(50) | Yes | NULL | |||
| Assigned_User_ID | varchar(50) | Yes | NULL | |||
| Status | varchar(50) | Yes | NULL | |||
| Job_Queue_Status | varchar(20) | Yes | NULL | |||
| Language_Code | varchar(20) | Yes | NULL | |||
| Format_Region | varchar(20) | Yes | NULL | |||
| PurchaseOrderLinkedToEdoc | tinyint(1) | Yes | NULL | |||
| No_Faktur_Pajak | varchar(50) | Yes | NULL | |||
| Tax_Certificate_SAG | varchar(255) | No | ||||
| Note_Line | text | Yes | NULL | |||
| Note_General | text | Yes | NULL | |||
| Signature_Name | varchar(150) | Yes | NULL | |||
| Currency_Code | varchar(20) | Yes | NULL | |||
| EU_3rd_Party_Trade | tinyint(1) | Yes | NULL | |||
| Expected_Receipt_Date | date | Yes | NULL | |||
| Prices_Including_VAT | tinyint(1) | Yes | NULL | |||
| VAT_Bus_Posting_Group | varchar(50) | Yes | NULL | |||
| WHT_Business_Posting_Group | varchar(50) | Yes | NULL | |||
| Vendor_Posting_Group | varchar(50) | Yes | NULL | |||
| Payment_Terms_Code | varchar(50) | Yes | NULL | |||
| Payment_Method_Code | varchar(50) | Yes | NULL | |||
| Shortcut_Dimension_1_Code | varchar(50) | Yes | NULL | |||
| Shortcut_Dimension_2_Code | varchar(50) | Yes | NULL | |||
| Payment_Discount_Percent | decimal(10,2) | Yes | NULL | |||
| Pmt_Discount_Date | date | Yes | NULL | |||
| Journal_Templ_Name | varchar(50) | Yes | NULL | |||
| Tax_Liable | tinyint(1) | Yes | NULL | |||
| Tax_Area_Code | varchar(50) | Yes | NULL | |||
| Shipment_Method_Code | varchar(50) | Yes | NULL | |||
| Payment_Reference | varchar(100) | Yes | NULL | |||
| Creditor_No | varchar(50) | Yes | NULL | |||
| On_Hold | varchar(50) | Yes | NULL | |||
| Inbound_Whse_Handling_Time | varchar(50) | Yes | NULL | |||
| Lead_Time_Calculation | varchar(50) | Yes | NULL | |||
| Requested_Receipt_Date | date | Yes | NULL | |||
| Promised_Receipt_Date | date | Yes | NULL | |||
| ShippingOptionWithLocation | varchar(50) | Yes | NULL | |||
| Sell_to_Customer_No | varchar(50) | Yes | NULL | |||
| Ship_to_Code | varchar(50) | Yes | NULL | |||
| Location_Code | varchar(50) | Yes | NULL | |||
| Ship_to_Name | varchar(150) | Yes | NULL | |||
| Ship_to_Name_2 | varchar(150) | Yes | NULL | |||
| Ship_to_Address | varchar(255) | Yes | NULL | |||
| Ship_to_Address_2 | varchar(255) | Yes | NULL | |||
| Ship_to_Address_3 | varchar(255) | Yes | NULL | |||
| Ship_to_City | varchar(100) | Yes | NULL | |||
| Ship_to_County | varchar(100) | Yes | NULL | |||
| Ship_to_Post_Code | varchar(20) | Yes | NULL | |||
| Ship_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| PIC | varchar(100) | Yes | NULL | |||
| Ship_to_Phone_No | varchar(50) | Yes | NULL | |||
| Ship_to_Contact | varchar(150) | Yes | NULL | |||
| PayToOptions | varchar(100) | Yes | NULL | |||
| Pay_to_Name | varchar(150) | Yes | NULL | |||
| Pay_to_Address | varchar(255) | Yes | NULL | |||
| Pay_to_Address_2 | varchar(255) | Yes | NULL | |||
| Pay_to_Address_3 | varchar(255) | Yes | NULL | |||
| Pay_to_City | varchar(100) | Yes | NULL | |||
| Pay_to_County | varchar(100) | Yes | NULL | |||
| Pay_to_Post_Code | varchar(20) | Yes | NULL | |||
| Pay_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Pay_to_Contact_No | varchar(50) | Yes | NULL | |||
| Pay_to_Contact | varchar(150) | Yes | NULL | |||
| PayToContactPhoneNo | varchar(50) | Yes | NULL | |||
| PayToContactMobilePhoneNo | varchar(50) | Yes | NULL | |||
| PayToContactEmail | varchar(150) | Yes | NULL | |||
| Remit_to_Code | varchar(50) | Yes | NULL | |||
| Remit_to_Name | varchar(150) | Yes | NULL | |||
| Remit_to_Address | varchar(255) | Yes | NULL | |||
| Remit_to_Address_2 | varchar(255) | Yes | NULL | |||
| Remit_to_City | varchar(100) | Yes | NULL | |||
| Remit_to_County | varchar(100) | Yes | NULL | |||
| Remit_to_Post_Code | varchar(20) | Yes | NULL | |||
| Remit_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Remit_to_Contact | varchar(150) | Yes | NULL | |||
| Transaction_Specification | varchar(100) | Yes | NULL | |||
| Transaction_Type | varchar(50) | Yes | NULL | |||
| Transport_Method | varchar(50) | Yes | NULL | |||
| Entry_Point | varchar(50) | Yes | NULL | |||
| Area | varchar(50) | Yes | NULL | |||
| Applicable_For_Serv_Decl | tinyint(1) | Yes | NULL | |||
| Prepayment_Percent | decimal(10,2) | Yes | NULL | |||
| Compress_Prepayment | tinyint(1) | Yes | NULL | |||
| Prepmt_Payment_Terms_Code | varchar(50) | Yes | NULL | |||
| Prepayment_Due_Date | date | Yes | NULL | |||
| Prepmt_Payment_Discount_Percent | decimal(10,2) | Yes | NULL | |||
| Prepmt_Pmt_Discount_Date | date | Yes | NULL | |||
| Vendor_Cr_Memo_No | varchar(100) | Yes | NULL | |||
| odata_etag | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | No | 11611 | A | No |
prc_header
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| odata_etag | varchar(255) | Yes | NULL | |||
| No (Primary) | varchar(50) | No | ||||
| Buy_from_Vendor_No | varchar(50) | Yes | NULL | |||
| Buy_from_Contact_No | varchar(50) | Yes | NULL | |||
| BuyFromContactPhoneNo | varchar(50) | Yes | NULL | |||
| BuyFromContactMobilePhoneNo | varchar(50) | Yes | NULL | |||
| BuyFromContactEmail | varchar(150) | Yes | NULL | |||
| Buy_from_Vendor_Name | varchar(255) | Yes | NULL | |||
| Buy_from_Address | text | Yes | NULL | |||
| Buy_from_Address_2 | varchar(255) | Yes | NULL | |||
| Buy_from_City | varchar(100) | Yes | NULL | |||
| Buy_from_County | varchar(100) | Yes | NULL | |||
| Buy_from_Post_Code | varchar(20) | Yes | NULL | |||
| Buy_from_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Buy_from_Contact | varchar(150) | Yes | NULL | |||
| No_Printed | int(11) | Yes | NULL | |||
| Posting_Date | date | Yes | NULL | |||
| Document_Date | date | Yes | NULL | |||
| Requested_Receipt_Date | date | Yes | NULL | |||
| Promised_Receipt_Date | date | Yes | NULL | |||
| Quote_No | varchar(100) | Yes | NULL | |||
| Order_No | varchar(100) | Yes | NULL | |||
| Vendor_Order_No | varchar(100) | Yes | NULL | |||
| Vendor_Shipment_No | varchar(100) | Yes | NULL | |||
| Order_Address_Code | varchar(50) | Yes | NULL | |||
| Purchaser_Code | varchar(50) | Yes | NULL | |||
| Responsibility_Center | varchar(50) | Yes | NULL | |||
| Pay_to_Vendor_No | varchar(50) | Yes | NULL | |||
| Pay_to_Contact_no | varchar(50) | Yes | NULL | |||
| PayToContactPhoneNo | varchar(50) | Yes | NULL | |||
| PayToContactMobilePhoneNo | varchar(50) | Yes | NULL | |||
| PayToContactEmail | varchar(150) | Yes | NULL | |||
| Pay_to_Name | varchar(255) | Yes | NULL | |||
| Pay_to_Address | text | Yes | NULL | |||
| Pay_to_Address_2 | varchar(255) | Yes | NULL | |||
| Pay_to_City | varchar(100) | Yes | NULL | |||
| Pay_to_County | varchar(100) | Yes | NULL | |||
| Pay_to_Post_Code | varchar(20) | Yes | NULL | |||
| Pay_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Pay_to_Contact | varchar(150) | Yes | NULL | |||
| Shortcut_Dimension_1_Code | varchar(50) | Yes | NULL | |||
| Shortcut_Dimension_2_Code | varchar(50) | Yes | NULL | |||
| Ship_to_Name | varchar(150) | Yes | NULL | |||
| Ship_to_Name_2 | varchar(150) | Yes | NULL | |||
| Ship_to_Address | text | Yes | NULL | |||
| Ship_to_Address_2 | varchar(255) | Yes | NULL | |||
| Ship_to_City | varchar(100) | Yes | NULL | |||
| Ship_to_County | varchar(100) | Yes | NULL | |||
| Ship_to_Post_Code | varchar(20) | Yes | NULL | |||
| Ship_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Ship_to_Phone_No | varchar(50) | Yes | NULL | |||
| Ship_to_Contact | varchar(150) | Yes | NULL | |||
| Location_Code | varchar(50) | Yes | NULL | |||
| Inbound_Whse_Handling_Time | varchar(50) | Yes | NULL | |||
| Shipment_Method_Code | varchar(50) | Yes | NULL | |||
| Lead_Time_Calculation | varchar(50) | Yes | NULL | |||
| Expected_Receipt_Date | date | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | No | 19126 | A | No |
pr_header
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| odata_etag | varchar(255) | Yes | NULL | |||
| No (Primary) | varchar(50) | No | ||||
| Keperluan | varchar(255) | Yes | NULL | |||
| Requisition_Date | date | Yes | NULL | |||
| Required_Date | date | Yes | NULL | |||
| Finished_Date | date | Yes | NULL | |||
| Shortcut_Dimension_1 | varchar(50) | Yes | NULL | |||
| Shortcut_Dimension_2 | varchar(50) | Yes | NULL | |||
| Shortcut_Dimension_3 | varchar(50) | Yes | NULL | |||
| Status | varchar(50) | Yes | NULL | |||
| PO_Created | tinyint(1) | Yes | NULL | |||
| PO_Archived | tinyint(1) | Yes | NULL | |||
| Requested_By | varchar(100) | Yes | NULL | |||
| Close_Reason | varchar(255) | Yes | NULL | |||
| Additional_Notes | text | Yes | NULL | |||
| No_PR_Sebelumnya | varchar(50) | Yes | NULL | |||
| Kategori_Code | varchar(50) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | No | 8777 | A | No |
pts_header
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| odata_etag | varchar(255) | Yes | NULL | |||
| No (Primary) | varchar(50) | No | ||||
| Transfer_from_Code | varchar(50) | Yes | NULL | |||
| Transfer_to_Code | varchar(50) | Yes | NULL | |||
| Direct_Transfer | tinyint(1) | Yes | NULL | |||
| In_Transit_Code | varchar(50) | Yes | NULL | |||
| Transfer_Order_No | varchar(50) | Yes | NULL | |||
| Transfer_Order_Date | date | Yes | NULL | |||
| Posting_Date | date | Yes | NULL | |||
| Shortcut_Dimension_1_Code | varchar(50) | Yes | NULL | |||
| Shortcut_Dimension_2_Code | varchar(50) | Yes | NULL | |||
| Prod_Order_No | varchar(50) | Yes | NULL | |||
| Demand_Order_No | varchar(50) | Yes | NULL | |||
| Warna | varchar(50) | Yes | NULL | |||
| Note | text | Yes | NULL | |||
| External_Document_No | varchar(100) | Yes | NULL | |||
| Shipment_Date | date | Yes | NULL | |||
| Shipment_Method_Code | varchar(50) | Yes | NULL | |||
| Shipping_Agent_Code | varchar(50) | Yes | NULL | |||
| Shipping_Agent_Service_Code | varchar(50) | Yes | NULL | |||
| Receipt_Date | date | Yes | NULL | |||
| Transfer_from_Name | varchar(150) | Yes | NULL | |||
| Transfer_from_Name_2 | varchar(150) | Yes | NULL | |||
| Transfer_from_Address | text | Yes | NULL | |||
| Transfer_from_Address_2 | varchar(255) | Yes | NULL | |||
| Transfer_from_City | varchar(100) | Yes | NULL | |||
| Transfer_from_County | varchar(100) | Yes | NULL | |||
| Transfer_from_Post_Code | varchar(20) | Yes | NULL | |||
| Trsf_from_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Transfer_from_Contact | varchar(150) | Yes | NULL | |||
| Transfer_to_Name | varchar(150) | Yes | NULL | |||
| Transfer_to_Name_2 | varchar(150) | Yes | NULL | |||
| Transfer_to_Address | text | Yes | NULL | |||
| Transfer_to_Address_2 | varchar(255) | Yes | NULL | |||
| Transfer_to_City | varchar(100) | Yes | NULL | |||
| Transfer_to_County | varchar(100) | Yes | NULL | |||
| Transfer_to_Post_Code | varchar(20) | Yes | NULL | |||
| Trsf_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Transfer_to_Contact | varchar(150) | Yes | NULL | |||
| Transaction_Type | varchar(50) | Yes | NULL | |||
| Transaction_Specification | varchar(100) | Yes | NULL | |||
| Transport_Method | varchar(50) | Yes | NULL | |||
| Area | varchar(50) | Yes | NULL | |||
| Entry_Exit_Point | varchar(50) | Yes | NULL | |||
| Partner_VAT_ID | varchar(50) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | No | 14367 | A | No |
so_header
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| odata_etag | varchar(255) | Yes | NULL | |||
| Document_Type | varchar(50) | Yes | NULL | |||
| No (Primary) | varchar(50) | No | ||||
| Sell_to_Customer_No | varchar(50) | Yes | NULL | |||
| Sell_to_Customer_Name | varchar(255) | Yes | NULL | |||
| Quote_No | varchar(100) | Yes | NULL | |||
| Posting_Description | varchar(255) | Yes | NULL | |||
| Sell_to_Address | text | Yes | NULL | |||
| Sell_to_Address_2 | varchar(255) | Yes | NULL | |||
| Sell_to_Address_3 | varchar(255) | Yes | NULL | |||
| Sell_to_City | varchar(100) | Yes | NULL | |||
| Sell_to_County | varchar(100) | Yes | NULL | |||
| Sell_to_Post_Code | varchar(20) | Yes | NULL | |||
| Sell_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Sell_to_Contact_No | varchar(50) | Yes | NULL | |||
| Sell_to_Phone_No | varchar(50) | Yes | NULL | |||
| SellToMobilePhoneNo | varchar(50) | Yes | NULL | |||
| Sell_to_E_Mail | varchar(150) | Yes | NULL | |||
| Sell_to_Contact | varchar(150) | Yes | NULL | |||
| No_of_Archived_Versions | int(11) | Yes | NULL | |||
| Document_Date | date | Yes | NULL | |||
| Posting_Date | date | Yes | NULL | |||
| VAT_Reporting_Date | date | Yes | NULL | |||
| Order_Date | date | Yes | NULL | |||
| Due_Date | date | Yes | NULL | |||
| Requested_Delivery_Date | date | Yes | NULL | |||
| Promised_Delivery_Date | date | Yes | NULL | |||
| External_Document_No | varchar(100) | Yes | NULL | |||
| Discount_Option | varchar(150) | Yes | NULL | |||
| Uang_Muka | decimal(18,2) | Yes | NULL | |||
| Your_Reference | varchar(100) | Yes | NULL | |||
| ShpfyOrderNo | varchar(100) | Yes | NULL | |||
| ShpfyShopify_Risk_Level | varchar(50) | Yes | NULL | |||
| Salesperson_Code | varchar(50) | Yes | NULL | |||
| Campaign_No | varchar(50) | Yes | NULL | |||
| Opportunity_No | varchar(50) | Yes | NULL | |||
| Responsibility_Center | varchar(50) | Yes | NULL | |||
| Assigned_User_ID | varchar(50) | Yes | NULL | |||
| Job_Queue_Status | varchar(20) | Yes | NULL | |||
| Status | varchar(50) | Yes | NULL | |||
| DPP_Lain_Amount_SAG | decimal(18,2) | Yes | NULL | |||
| Contract_Amount | decimal(18,2) | Yes | NULL | |||
| WorkDescription | text | Yes | NULL | |||
| Proforma_Amount_Created | decimal(18,2) | Yes | NULL | |||
| Sales_Proforma_Amount_Paid | decimal(18,2) | Yes | NULL | |||
| Currency_Code | varchar(20) | Yes | NULL | |||
| Company_Bank_Account_Code | varchar(50) | Yes | NULL | |||
| Prices_Including_VAT | tinyint(1) | Yes | NULL | |||
| VAT_Country_Region_Code | varchar(20) | Yes | NULL | |||
| VAT_Registration_No | varchar(50) | Yes | NULL | |||
| Gen_Bus_Posting_Group | varchar(50) | Yes | NULL | |||
| VAT_Bus_Posting_Group | varchar(50) | Yes | NULL | |||
| WHT_Business_Posting_Group | varchar(50) | Yes | NULL | |||
| Customer_Posting_Group | varchar(50) | Yes | NULL | |||
| Payment_Terms_Code | varchar(50) | Yes | NULL | |||
| Payment_Method_Code | varchar(50) | Yes | NULL | |||
| EU_3_Party_Trade | tinyint(1) | Yes | NULL | |||
| SelectedPayments | varchar(150) | Yes | NULL | |||
| Shortcut_Dimension_1_Code | varchar(50) | Yes | NULL | |||
| Shortcut_Dimension_2_Code | varchar(50) | Yes | NULL | |||
| BAST_1 | date | Yes | NULL | |||
| BAST_2 | date | Yes | NULL | |||
| Use_Proforma_Invoice | tinyint(1) | Yes | NULL | |||
| Payment_Discount_Percent | decimal(10,2) | Yes | NULL | |||
| Pmt_Discount_Date | date | Yes | NULL | |||
| Journal_Templ_Name | varchar(50) | Yes | NULL | |||
| Direct_Debit_Mandate_ID | varchar(50) | Yes | NULL | |||
| ShippingOptions | varchar(100) | Yes | NULL | |||
| Ship_to_Code | varchar(50) | Yes | NULL | |||
| Ship_to_Name | varchar(150) | Yes | NULL | |||
| Ship_to_Name_2 | varchar(150) | Yes | NULL | |||
| Ship_to_Address | text | Yes | NULL | |||
| Ship_to_Address_2 | varchar(255) | Yes | NULL | |||
| Ship_to_Address_3 | varchar(255) | Yes | NULL | |||
| Ship_to_City | varchar(100) | Yes | NULL | |||
| Ship_to_County | varchar(100) | Yes | NULL | |||
| Ship_to_Post_Code | varchar(20) | Yes | NULL | |||
| Ship_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Ship_to_Phone_No | varchar(50) | Yes | NULL | |||
| Ship_to_Contact | varchar(150) | Yes | NULL | |||
| Shipment_Method_Code | varchar(50) | Yes | NULL | |||
| Shipping_Agent_Code | varchar(50) | Yes | NULL | |||
| Shipping_Agent_Service_Code | varchar(50) | Yes | NULL | |||
| Package_Tracking_No | varchar(100) | Yes | NULL | |||
| BillToOptions | varchar(100) | Yes | NULL | |||
| Bill_to_Name | varchar(150) | Yes | NULL | |||
| Bill_to_Address | text | Yes | NULL | |||
| Bill_to_Address_2 | varchar(255) | Yes | NULL | |||
| Bill_to_Address_3 | varchar(255) | Yes | NULL | |||
| Bill_to_City | varchar(100) | Yes | NULL | |||
| Bill_to_County | varchar(100) | Yes | NULL | |||
| Bill_to_Post_Code | varchar(20) | Yes | NULL | |||
| Bill_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Bill_to_Contact_No | varchar(50) | Yes | NULL | |||
| Bill_to_Contact | varchar(150) | Yes | NULL | |||
| BillToContactPhoneNo | varchar(50) | Yes | NULL | |||
| BillToContactMobilePhoneNo | varchar(50) | Yes | NULL | |||
| BillToContactEmail | varchar(150) | Yes | NULL | |||
| Location_Code | varchar(50) | Yes | NULL | |||
| Shipment_Date | date | Yes | NULL | |||
| Waktu_Pengiriman | varchar(50) | Yes | NULL | |||
| Shipping_Advice | varchar(50) | Yes | NULL | |||
| Outbound_Whse_Handling_Time | varchar(50) | Yes | NULL | |||
| Shipping_Time | varchar(50) | Yes | NULL | |||
| Late_Order_Shipping | tinyint(1) | Yes | NULL | |||
| Combine_Shipments | tinyint(1) | Yes | NULL | |||
| Completely_Shipped | tinyint(1) | Yes | NULL | |||
| Transaction_Specification | varchar(100) | Yes | NULL | |||
| Transaction_Type | varchar(50) | Yes | NULL | |||
| Transport_Method | varchar(50) | Yes | NULL | |||
| Exit_Point | varchar(50) | Yes | NULL | |||
| Area | varchar(50) | Yes | NULL | |||
| Applicable_For_Serv_Decl | tinyint(1) | Yes | NULL | |||
| Language_Code | varchar(20) | Yes | NULL | |||
| Format_Region | varchar(20) | Yes | NULL | |||
| Prepayment_Percent | decimal(10,2) | Yes | NULL | |||
| Compress_Prepayment | tinyint(1) | Yes | NULL | |||
| Prepmt_Payment_Terms_Code | varchar(50) | Yes | NULL | |||
| Prepayment_Due_Date | date | Yes | NULL | |||
| Prepmt_Payment_Discount_Percent | decimal(10,2) | Yes | NULL | |||
| Prepmt_Pmt_Discount_Date | date | Yes | NULL | |||
| Date_Filter | varchar(50) | Yes | NULL | |||
| Location_Filter | varchar(50) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | No | 19183 | A | No |
to_header
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| odata_etag | varchar(255) | Yes | NULL | |||
| No (Primary) | varchar(50) | No | ||||
| Transfer_from_Code | varchar(50) | Yes | NULL | |||
| Transfer_to_Code | varchar(50) | Yes | NULL | |||
| Direct_Transfer | tinyint(1) | Yes | NULL | |||
| In_Transit_Code | varchar(50) | Yes | NULL | |||
| Posting_Date | date | Yes | NULL | |||
| Shortcut_Dimension_1_Code | varchar(50) | Yes | NULL | |||
| Shortcut_Dimension_2_Code | varchar(50) | Yes | NULL | |||
| Assigned_User_ID | varchar(50) | Yes | NULL | |||
| Status | varchar(50) | Yes | NULL | |||
| Note | text | Yes | NULL | |||
| Prod_Order_No | varchar(50) | Yes | NULL | |||
| Demand_Order_No | varchar(50) | Yes | NULL | |||
| Warna | varchar(50) | Yes | NULL | |||
| External_Document_No | varchar(100) | Yes | NULL | |||
| Shipment_Date | date | Yes | NULL | |||
| Outbound_Whse_Handling_Time | varchar(50) | Yes | NULL | |||
| Shipment_Method_Code | varchar(50) | Yes | NULL | |||
| Shipping_Agent_Code | varchar(50) | Yes | NULL | |||
| Shipping_Agent_Service_Code | varchar(50) | Yes | NULL | |||
| Shipping_Time | varchar(50) | Yes | NULL | |||
| Shipping_Advice | varchar(50) | Yes | NULL | |||
| Receipt_Date | date | Yes | NULL | |||
| Transfer_from_Name | varchar(150) | Yes | NULL | |||
| Transfer_from_Name_2 | varchar(150) | Yes | NULL | |||
| Transfer_from_Address | text | Yes | NULL | |||
| Transfer_from_Address_2 | varchar(255) | Yes | NULL | |||
| Transfer_from_City | varchar(100) | Yes | NULL | |||
| Transfer_from_County | varchar(100) | Yes | NULL | |||
| Transfer_from_Post_Code | varchar(20) | Yes | NULL | |||
| Trsf_from_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Transfer_from_Contact | varchar(150) | Yes | NULL | |||
| Transfer_to_Name | varchar(150) | Yes | NULL | |||
| Transfer_to_Name_2 | varchar(150) | Yes | NULL | |||
| Transfer_to_Address | text | Yes | NULL | |||
| Transfer_to_Address_2 | varchar(255) | Yes | NULL | |||
| Transfer_to_City | varchar(100) | Yes | NULL | |||
| Transfer_to_County | varchar(100) | Yes | NULL | |||
| Transfer_to_Post_Code | varchar(20) | Yes | NULL | |||
| Trsf_to_Country_Region_Code | varchar(20) | Yes | NULL | |||
| Transfer_to_Contact | varchar(150) | Yes | NULL | |||
| Inbound_Whse_Handling_Time | varchar(50) | Yes | NULL | |||
| Transaction_Type | varchar(50) | Yes | NULL | |||
| Transaction_Specification | varchar(100) | Yes | NULL | |||
| Transport_Method | varchar(50) | Yes | NULL | |||
| Area | varchar(50) | Yes | NULL | |||
| Entry_Exit_Point | varchar(50) | Yes | NULL | |||
| Partner_VAT_ID | varchar(50) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | No | 23002 | A | No |