| Name |
Type |
DBType |
Nullable |
| Order_Header_Id |
Int64 |
NUMBER (10) |
False |
| Order_No |
String |
VARCHAR2 (20) |
False |
| Order |
String |
VARCHAR2 (100) |
False |
| Create_User |
String |
VARCHAR2 (30) |
False |
| Create_Date |
DateTime |
DATE (7) |
False |
| Modify_User |
String |
VARCHAR2 (30) |
False |
| Modify_Date |
DateTime |
DATE (7) |
False |
| C4552_Status |
Int32 |
NUMBER (8) |
False |
| Status |
String |
VARCHAR2 (100) |
False |
| C4553_Order_Type |
Int32 |
NUMBER (8) |
False |
| Order_Type |
String |
VARCHAR2 (100) |
False |
| Title |
String |
VARCHAR2 (100) |
False |
| Currency |
String |
VARCHAR2 (3) |
False |
| Order_Date |
DateTime |
DATE (7) |
False |
| Offer_Due_Date |
DateTime |
DATE (7) |
True |
| Pricing_Date |
DateTime |
DATE (7) |
False |
| Vat_Date |
DateTime |
DATE (7) |
False |
| C3305_Sales_Area |
Int64 |
NUMBER (10) |
True |
| Sales_Area |
String |
VARCHAR2 (100) |
True |
| Visit_Date |
DateTime |
DATE (7) |
True |
| Project_Id |
Int64 |
NUMBER (10) |
True |
| Project |
String |
VARCHAR2 (100) |
True |
| Sales_Reference |
String |
VARCHAR2 (101) |
True |
| Latitude |
Decimal |
NUMBER (10, 7) |
True |
| Longitude |
Decimal |
NUMBER (10, 7) |
True |
| C4562_Branch |
Int64 |
NUMBER (10) |
False |
| Branch |
String |
VARCHAR2 (100) |
False |
| Order_Location_Bp_Adr_Id |
Int64 |
NUMBER (10) |
False |
| Order_Location |
String |
VARCHAR2 (100) |
False |
| Sales_Channel |
String |
VARCHAR2 (3) |
False |
| Date_Start |
DateTime |
DATE (7) |
True |
| Date_Finish |
DateTime |
DATE (7) |
True |
| C27_Payment_Terms |
Int32 |
NUMBER (8) |
False |
| Payment_Terms |
String |
VARCHAR2 (100) |
True |
| Company_No |
Int32 |
NUMBER (6) |
False |
| Order_Nr_Link |
String |
VARCHAR2 (20) |
True |
| Order_Header_Id_Link |
Int64 |
NUMBER (10) |
True |
| Customer_Company_Id |
Int64 |
NUMBER (10) |
False |
| Customer_Id |
Int64 |
NUMBER (10) |
False |
| Customer_Invoice_Bp_Addr_Id |
Int64 |
NUMBER (10) |
False |
| Customer_Id_Invoice |
Int64 |
NUMBER (10) |
True |
| Invoice_Mailing_Bp_Adr_Id |
Int64 |
NUMBER (10) |
False |
| Your_reference |
String |
VARCHAR2 (200) |
True |
| Internal_Comment |
String |
VARCHAR2 (2000) |
True |
| External_Comment |
String |
VARCHAR2 (2000) |
True |
| Billing_Comment |
String |
VARCHAR2 (2000) |
True |
| Amount_Billed_Excl_Order_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Amount_Billed_Incl_Order_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Amount_Billed_Excl_BS_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Amount_Billed_Incl_BS_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Amount_Open_Excl_Order_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Amount_Open_Incl_Order_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Amount_Open_Excl_BS_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Amount_Open_Incl_BS_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Total_Amount_Excl_Order_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Total_Amount_Incl_Order_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Total_Amount_Excl_BS_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Total_Amount_Incl_BS_Curr |
Decimal |
NUMBER (16, 2) |
False |
| Flat_Rate_Amount_Excl_Ord_Curr |
Decimal |
NUMBER (16, 2) |
True |
| C124_Vat_System |
Int64 |
NUMBER (10) |
False |
| Vat_Order_Indicator_Id |
Int64 |
NUMBER (10) |
True |
| Export_bool |
Int32 |
NUMBER (1) |
False |
| C17_Language |
Int32 |
NUMBER (8) |
False |
| C6953_Processing_Status |
Int32 |
NUMBER (8) |
True |
| C6954_Service_Type |
Int32 |
NUMBER (8) |
True |
| C6955_Order_Label |
Int32 |
NUMBER (8) |
True |
| Job_Date_By_Arrangement_bool |
Int32 |
NUMBER (1) |
False |
| Opening_Text |
String |
VARCHAR2 (2000) |
True |
| Closing_Text |
String |
VARCHAR2 (2000) |
True |
| Rate |
Decimal |
NUMBER (14, 6) |
False |
| Is_Suborder_bool |
Int32 |
NUMBER (1) |
False |
| Surcharge_Model_Id |
Int64 |
NUMBER (10) |
True |
| Billing_Type |
String |
VARCHAR2 (6) |
False |
| Version_no |
Int32 |
NUMBER (3) |
True |
| Default_Report_Dispatch |
String |
VARCHAR2 (500) |
True |
| Collective_Invoicing_bool |
Int32 |
NUMBER (1) |
False |