Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: get_data_from_bc
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
get_data_from_bc.po_header
get_data_from_bc.prc_header
get_data_from_bc.pr_header
get_data_from_bc.pts_header
get_data_from_bc.so_header
get_data_from_bc.to_header
Number of tables: 6
v get_data_from_bc po_header
* Document_Type : varchar(50)
* No : varchar(50)
* Buy_from_Vendor_No : varchar(50)
* Buy_from_Vendor_Name : varchar(255)
* Posting_Description : varchar(255)
* Buy_from_Address : varchar(255)
* Buy_from_Address_2 : varchar(255)
* Buy_from_Address_3 : varchar(255)
* Buy_from_City : varchar(100)
* Buy_from_County : varchar(100)
* Buy_from_Post_Code : varchar(20)
* Buy_from_Country_Region_Code : varchar(20)
* Buy_from_Contact_No : varchar(50)
* BuyFromContactPhoneNo : varchar(50)
* BuyFromContactMobilePhoneNo : varchar(50)
* BuyFromContactEmail : varchar(150)
* Buy_from_Contact : varchar(150)
* Document_Date : date
* Invoice_Received_Date : date
* Posting_Date : date
* VAT_Reporting_Date : date
* Due_Date : date
* Vendor_Invoice_No : varchar(100)
* Your_Reference : varchar(100)
* Purchaser_Code : varchar(50)
* No_of_Archived_Versions : int(11)
* Order_Date : date
* Quote_No : varchar(100)
* Vendor_Order_No : varchar(100)
* Vendor_Shipment_No : varchar(100)
* PR_No : varchar(100)
* Order_Address_Code : varchar(50)
* Responsibility_Center : varchar(50)
* Assigned_User_ID : varchar(50)
* Status : varchar(50)
* Job_Queue_Status : varchar(20)
* Language_Code : varchar(20)
* Format_Region : varchar(20)
* PurchaseOrderLinkedToEdoc : tinyint(1)
* No_Faktur_Pajak : varchar(50)
* Tax_Certificate_SAG : varchar(255)
* Note_Line : text
* Note_General : text
* Signature_Name : varchar(150)
* Currency_Code : varchar(20)
* EU_3rd_Party_Trade : tinyint(1)
* Expected_Receipt_Date : date
* Prices_Including_VAT : tinyint(1)
* VAT_Bus_Posting_Group : varchar(50)
* WHT_Business_Posting_Group : varchar(50)
* Vendor_Posting_Group : varchar(50)
* Payment_Terms_Code : varchar(50)
* Payment_Method_Code : varchar(50)
* Shortcut_Dimension_1_Code : varchar(50)
* Shortcut_Dimension_2_Code : varchar(50)
* Payment_Discount_Percent : decimal(10,2)
* Pmt_Discount_Date : date
* Journal_Templ_Name : varchar(50)
* Tax_Liable : tinyint(1)
* Tax_Area_Code : varchar(50)
* Shipment_Method_Code : varchar(50)
* Payment_Reference : varchar(100)
* Creditor_No : varchar(50)
* On_Hold : varchar(50)
* Inbound_Whse_Handling_Time : varchar(50)
* Lead_Time_Calculation : varchar(50)
* Requested_Receipt_Date : date
* Promised_Receipt_Date : date
* ShippingOptionWithLocation : varchar(50)
* Sell_to_Customer_No : varchar(50)
* Ship_to_Code : varchar(50)
* Location_Code : varchar(50)
* Ship_to_Name : varchar(150)
* Ship_to_Name_2 : varchar(150)
* Ship_to_Address : varchar(255)
* Ship_to_Address_2 : varchar(255)
* Ship_to_Address_3 : varchar(255)
* Ship_to_City : varchar(100)
* Ship_to_County : varchar(100)
* Ship_to_Post_Code : varchar(20)
* Ship_to_Country_Region_Code : varchar(20)
* PIC : varchar(100)
* Ship_to_Phone_No : varchar(50)
* Ship_to_Contact : varchar(150)
* PayToOptions : varchar(100)
* Pay_to_Name : varchar(150)
* Pay_to_Address : varchar(255)
* Pay_to_Address_2 : varchar(255)
* Pay_to_Address_3 : varchar(255)
* Pay_to_City : varchar(100)
* Pay_to_County : varchar(100)
* Pay_to_Post_Code : varchar(20)
* Pay_to_Country_Region_Code : varchar(20)
* Pay_to_Contact_No : varchar(50)
* Pay_to_Contact : varchar(150)
* PayToContactPhoneNo : varchar(50)
* PayToContactMobilePhoneNo : varchar(50)
* PayToContactEmail : varchar(150)
* Remit_to_Code : varchar(50)
* Remit_to_Name : varchar(150)
* Remit_to_Address : varchar(255)
* Remit_to_Address_2 : varchar(255)
* Remit_to_City : varchar(100)
* Remit_to_County : varchar(100)
* Remit_to_Post_Code : varchar(20)
* Remit_to_Country_Region_Code : varchar(20)
* Remit_to_Contact : varchar(150)
* Transaction_Specification : varchar(100)
* Transaction_Type : varchar(50)
* Transport_Method : varchar(50)
* Entry_Point : varchar(50)
* Area : varchar(50)
* Applicable_For_Serv_Decl : tinyint(1)
* Prepayment_Percent : decimal(10,2)
* Compress_Prepayment : tinyint(1)
* Prepmt_Payment_Terms_Code : varchar(50)
* Prepayment_Due_Date : date
* Prepmt_Payment_Discount_Percent : decimal(10,2)
* Prepmt_Pmt_Discount_Date : date
* Vendor_Cr_Memo_No : varchar(100)
* odata_etag : varchar(255)
v get_data_from_bc prc_header
* odata_etag : varchar(255)
* No : varchar(50)
* Buy_from_Vendor_No : varchar(50)
* Buy_from_Contact_No : varchar(50)
* BuyFromContactPhoneNo : varchar(50)
* BuyFromContactMobilePhoneNo : varchar(50)
* BuyFromContactEmail : varchar(150)
* Buy_from_Vendor_Name : varchar(255)
* Buy_from_Address : text
* Buy_from_Address_2 : varchar(255)
* Buy_from_City : varchar(100)
* Buy_from_County : varchar(100)
* Buy_from_Post_Code : varchar(20)
* Buy_from_Country_Region_Code : varchar(20)
* Buy_from_Contact : varchar(150)
* No_Printed : int(11)
* Posting_Date : date
* Document_Date : date
* Requested_Receipt_Date : date
* Promised_Receipt_Date : date
* Quote_No : varchar(100)
* Order_No : varchar(100)
* Vendor_Order_No : varchar(100)
* Vendor_Shipment_No : varchar(100)
* Order_Address_Code : varchar(50)
* Purchaser_Code : varchar(50)
* Responsibility_Center : varchar(50)
* Pay_to_Vendor_No : varchar(50)
* Pay_to_Contact_no : varchar(50)
* PayToContactPhoneNo : varchar(50)
* PayToContactMobilePhoneNo : varchar(50)
* PayToContactEmail : varchar(150)
* Pay_to_Name : varchar(255)
* Pay_to_Address : text
* Pay_to_Address_2 : varchar(255)
* Pay_to_City : varchar(100)
* Pay_to_County : varchar(100)
* Pay_to_Post_Code : varchar(20)
* Pay_to_Country_Region_Code : varchar(20)
* Pay_to_Contact : varchar(150)
* Shortcut_Dimension_1_Code : varchar(50)
* Shortcut_Dimension_2_Code : varchar(50)
* Ship_to_Name : varchar(150)
* Ship_to_Name_2 : varchar(150)
* Ship_to_Address : text
* Ship_to_Address_2 : varchar(255)
* Ship_to_City : varchar(100)
* Ship_to_County : varchar(100)
* Ship_to_Post_Code : varchar(20)
* Ship_to_Country_Region_Code : varchar(20)
* Ship_to_Phone_No : varchar(50)
* Ship_to_Contact : varchar(150)
* Location_Code : varchar(50)
* Inbound_Whse_Handling_Time : varchar(50)
* Shipment_Method_Code : varchar(50)
* Lead_Time_Calculation : varchar(50)
* Expected_Receipt_Date : date
v get_data_from_bc pr_header
* odata_etag : varchar(255)
* No : varchar(50)
* Keperluan : varchar(255)
* Requisition_Date : date
* Required_Date : date
* Finished_Date : date
* Shortcut_Dimension_1 : varchar(50)
* Shortcut_Dimension_2 : varchar(50)
* Shortcut_Dimension_3 : varchar(50)
* Status : varchar(50)
* PO_Created : tinyint(1)
* PO_Archived : tinyint(1)
* Requested_By : varchar(100)
* Close_Reason : varchar(255)
* Additional_Notes : text
* No_PR_Sebelumnya : varchar(50)
* Kategori_Code : varchar(50)
v get_data_from_bc pts_header
* odata_etag : varchar(255)
* No : varchar(50)
* Transfer_from_Code : varchar(50)
* Transfer_to_Code : varchar(50)
* Direct_Transfer : tinyint(1)
* In_Transit_Code : varchar(50)
* Transfer_Order_No : varchar(50)
* Transfer_Order_Date : date
* Posting_Date : date
* Shortcut_Dimension_1_Code : varchar(50)
* Shortcut_Dimension_2_Code : varchar(50)
* Prod_Order_No : varchar(50)
* Demand_Order_No : varchar(50)
* Warna : varchar(50)
* Note : text
* External_Document_No : varchar(100)
* Shipment_Date : date
* Shipment_Method_Code : varchar(50)
* Shipping_Agent_Code : varchar(50)
* Shipping_Agent_Service_Code : varchar(50)
* Receipt_Date : date
* Transfer_from_Name : varchar(150)
* Transfer_from_Name_2 : varchar(150)
* Transfer_from_Address : text
* Transfer_from_Address_2 : varchar(255)
* Transfer_from_City : varchar(100)
* Transfer_from_County : varchar(100)
* Transfer_from_Post_Code : varchar(20)
* Trsf_from_Country_Region_Code : varchar(20)
* Transfer_from_Contact : varchar(150)
* Transfer_to_Name : varchar(150)
* Transfer_to_Name_2 : varchar(150)
* Transfer_to_Address : text
* Transfer_to_Address_2 : varchar(255)
* Transfer_to_City : varchar(100)
* Transfer_to_County : varchar(100)
* Transfer_to_Post_Code : varchar(20)
* Trsf_to_Country_Region_Code : varchar(20)
* Transfer_to_Contact : varchar(150)
* Transaction_Type : varchar(50)
* Transaction_Specification : varchar(100)
* Transport_Method : varchar(50)
* Area : varchar(50)
* Entry_Exit_Point : varchar(50)
* Partner_VAT_ID : varchar(50)
v get_data_from_bc so_header
* odata_etag : varchar(255)
* Document_Type : varchar(50)
* No : varchar(50)
* Sell_to_Customer_No : varchar(50)
* Sell_to_Customer_Name : varchar(255)
* Quote_No : varchar(100)
* Posting_Description : varchar(255)
* Sell_to_Address : text
* Sell_to_Address_2 : varchar(255)
* Sell_to_Address_3 : varchar(255)
* Sell_to_City : varchar(100)
* Sell_to_County : varchar(100)
* Sell_to_Post_Code : varchar(20)
* Sell_to_Country_Region_Code : varchar(20)
* Sell_to_Contact_No : varchar(50)
* Sell_to_Phone_No : varchar(50)
* SellToMobilePhoneNo : varchar(50)
* Sell_to_E_Mail : varchar(150)
* Sell_to_Contact : varchar(150)
* No_of_Archived_Versions : int(11)
* Document_Date : date
* Posting_Date : date
* VAT_Reporting_Date : date
* Order_Date : date
* Due_Date : date
* Requested_Delivery_Date : date
* Promised_Delivery_Date : date
* External_Document_No : varchar(100)
* Discount_Option : varchar(150)
* Uang_Muka : decimal(18,2)
* Your_Reference : varchar(100)
* ShpfyOrderNo : varchar(100)
* ShpfyShopify_Risk_Level : varchar(50)
* Salesperson_Code : varchar(50)
* Campaign_No : varchar(50)
* Opportunity_No : varchar(50)
* Responsibility_Center : varchar(50)
* Assigned_User_ID : varchar(50)
* Job_Queue_Status : varchar(20)
* Status : varchar(50)
* DPP_Lain_Amount_SAG : decimal(18,2)
* Contract_Amount : decimal(18,2)
* WorkDescription : text
* Proforma_Amount_Created : decimal(18,2)
* Sales_Proforma_Amount_Paid : decimal(18,2)
* Currency_Code : varchar(20)
* Company_Bank_Account_Code : varchar(50)
* Prices_Including_VAT : tinyint(1)
* VAT_Country_Region_Code : varchar(20)
* VAT_Registration_No : varchar(50)
* Gen_Bus_Posting_Group : varchar(50)
* VAT_Bus_Posting_Group : varchar(50)
* WHT_Business_Posting_Group : varchar(50)
* Customer_Posting_Group : varchar(50)
* Payment_Terms_Code : varchar(50)
* Payment_Method_Code : varchar(50)
* EU_3_Party_Trade : tinyint(1)
* SelectedPayments : varchar(150)
* Shortcut_Dimension_1_Code : varchar(50)
* Shortcut_Dimension_2_Code : varchar(50)
* BAST_1 : date
* BAST_2 : date
* Use_Proforma_Invoice : tinyint(1)
* Payment_Discount_Percent : decimal(10,2)
* Pmt_Discount_Date : date
* Journal_Templ_Name : varchar(50)
* Direct_Debit_Mandate_ID : varchar(50)
* ShippingOptions : varchar(100)
* Ship_to_Code : varchar(50)
* Ship_to_Name : varchar(150)
* Ship_to_Name_2 : varchar(150)
* Ship_to_Address : text
* Ship_to_Address_2 : varchar(255)
* Ship_to_Address_3 : varchar(255)
* Ship_to_City : varchar(100)
* Ship_to_County : varchar(100)
* Ship_to_Post_Code : varchar(20)
* Ship_to_Country_Region_Code : varchar(20)
* Ship_to_Phone_No : varchar(50)
* Ship_to_Contact : varchar(150)
* Shipment_Method_Code : varchar(50)
* Shipping_Agent_Code : varchar(50)
* Shipping_Agent_Service_Code : varchar(50)
* Package_Tracking_No : varchar(100)
* BillToOptions : varchar(100)
* Bill_to_Name : varchar(150)
* Bill_to_Address : text
* Bill_to_Address_2 : varchar(255)
* Bill_to_Address_3 : varchar(255)
* Bill_to_City : varchar(100)
* Bill_to_County : varchar(100)
* Bill_to_Post_Code : varchar(20)
* Bill_to_Country_Region_Code : varchar(20)
* Bill_to_Contact_No : varchar(50)
* Bill_to_Contact : varchar(150)
* BillToContactPhoneNo : varchar(50)
* BillToContactMobilePhoneNo : varchar(50)
* BillToContactEmail : varchar(150)
* Location_Code : varchar(50)
* Shipment_Date : date
* Waktu_Pengiriman : varchar(50)
* Shipping_Advice : varchar(50)
* Outbound_Whse_Handling_Time : varchar(50)
* Shipping_Time : varchar(50)
* Late_Order_Shipping : tinyint(1)
* Combine_Shipments : tinyint(1)
* Completely_Shipped : tinyint(1)
* Transaction_Specification : varchar(100)
* Transaction_Type : varchar(50)
* Transport_Method : varchar(50)
* Exit_Point : varchar(50)
* Area : varchar(50)
* Applicable_For_Serv_Decl : tinyint(1)
* Language_Code : varchar(20)
* Format_Region : varchar(20)
* Prepayment_Percent : decimal(10,2)
* Compress_Prepayment : tinyint(1)
* Prepmt_Payment_Terms_Code : varchar(50)
* Prepayment_Due_Date : date
* Prepmt_Payment_Discount_Percent : decimal(10,2)
* Prepmt_Pmt_Discount_Date : date
* Date_Filter : varchar(50)
* Location_Filter : varchar(50)
v get_data_from_bc to_header
* odata_etag : varchar(255)
* No : varchar(50)
* Transfer_from_Code : varchar(50)
* Transfer_to_Code : varchar(50)
* Direct_Transfer : tinyint(1)
* In_Transit_Code : varchar(50)
* Posting_Date : date
* Shortcut_Dimension_1_Code : varchar(50)
* Shortcut_Dimension_2_Code : varchar(50)
* Assigned_User_ID : varchar(50)
* Status : varchar(50)
* Note : text
* Prod_Order_No : varchar(50)
* Demand_Order_No : varchar(50)
* Warna : varchar(50)
* External_Document_No : varchar(100)
* Shipment_Date : date
* Outbound_Whse_Handling_Time : varchar(50)
* Shipment_Method_Code : varchar(50)
* Shipping_Agent_Code : varchar(50)
* Shipping_Agent_Service_Code : varchar(50)
* Shipping_Time : varchar(50)
* Shipping_Advice : varchar(50)
* Receipt_Date : date
* Transfer_from_Name : varchar(150)
* Transfer_from_Name_2 : varchar(150)
* Transfer_from_Address : text
* Transfer_from_Address_2 : varchar(255)
* Transfer_from_City : varchar(100)
* Transfer_from_County : varchar(100)
* Transfer_from_Post_Code : varchar(20)
* Trsf_from_Country_Region_Code : varchar(20)
* Transfer_from_Contact : varchar(150)
* Transfer_to_Name : varchar(150)
* Transfer_to_Name_2 : varchar(150)
* Transfer_to_Address : text
* Transfer_to_Address_2 : varchar(255)
* Transfer_to_City : varchar(100)
* Transfer_to_County : varchar(100)
* Transfer_to_Post_Code : varchar(20)
* Trsf_to_Country_Region_Code : varchar(20)
* Transfer_to_Contact : varchar(150)
* Inbound_Whse_Handling_Time : varchar(50)
* Transaction_Type : varchar(50)
* Transaction_Specification : varchar(100)
* Transport_Method : varchar(50)
* Area : varchar(50)
* Entry_Exit_Point : varchar(50)
* Partner_VAT_ID : varchar(50)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship