Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Document Type (Document Type) | Option | [Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order] | |
2 | Sell-to Customer No. (Sell-to Customer No.) | Code20 |
|
|
3 | No. (No.) | Code20 | ||
4 | Bill-to Customer No. (Bill-to Customer No.) | Code20 |
|
NotBlank: Yes |
5 | Bill-to Name (Bill-to Name) | Text50 | ||
6 | Bill-to Name 2 (Bill-to Name 2) | Text50 | ||
7 | Bill-to Address (Bill-to Address) | Text50 | ||
8 | Bill-to Address 2 (Bill-to Address 2) | Text50 | ||
9 | Bill-to City (Bill-to City) | Text30 |
|
|
10 | Bill-to Contact (Bill-to Contact) | Text50 | ||
11 | Your Reference (Your Reference) | Text35 | ||
12 | Ship-to Code (Ship-to Code) | Code10 |
|
|
13 | Ship-to Name (Ship-to Name) | Text50 | ||
14 | Ship-to Name 2 (Ship-to Name 2) | Text50 | ||
15 | Ship-to Address (Ship-to Address) | Text50 | ||
16 | Ship-to Address 2 (Ship-to Address 2) | Text50 | ||
17 | Ship-to City (Ship-to City) | Text30 |
|
|
18 | Ship-to Contact (Ship-to Contact) | Text50 | ||
19 | Order Date (Order Date) | Date | AccessByPermission: TableData 110=R | |
20 | Posting Date (Posting Date) | Date | ||
21 | Shipment Date (Shipment Date) | Date | ||
22 | Posting Description (Posting Description) | Text50 | ||
23 | Payment Terms Code (Payment Terms Code) | Code10 |
|
|
24 | Due Date (Due Date) | Date | ||
25 | Payment Discount % (Payment Discount %) | Decimal (0:5) | MaxValue: 100 | |
26 | Pmt. Discount Date (Pmt. Discount Date) | Date | ||
27 | Shipment Method Code (Shipment Method Code) | Code10 |
|
|
28 | Location Code (Location Code) | Code10 |
|
|
29 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
30 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
31 | Customer Posting Group (Customer Posting Group) | Code10 |
|
Editable: No |
32 | Currency Code (Currency Code) | Code10 |
|
|
33 | Currency Factor (Currency Factor) | Decimal (0:15) | Editable: No | |
34 | Customer Price Group (Customer Price Group) | Code10 |
|
|
35 | Prices Including VAT (Prices Including VAT) | Boolean | ||
37 | Invoice Disc. Code (Invoice Disc. Code) | Code20 | AccessByPermission: TableData 19=R | |
40 | Customer Disc. Group (Customer Disc. Group) | Code20 |
|
|
41 | Language Code (Language Code) | Code10 |
|
|
43 | Salesperson Code (Salesperson Code) | Code10 |
|
|
45 | Order Class (Order Class) | Code10 | ||
46 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
47 | No. Printed (No. Printed) | Integer | Editable: No | |
51 | On Hold (On Hold) | Code3 | ||
52 | Applies-to Doc. Type (Applies-to Doc. Type) | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
53 | Applies-to Doc. No. (Applies-to Doc. No.) | Code20 | ||
55 | Bal. Account No. (Bal. Account No.) | Code20 |
|
|
56 | Recalculate Invoice Disc. (Recalculate Invoice Disc.) | Boolean |
|
Editable: No FlowField |
57 | Ship (Ship) | Boolean | Editable: No | |
58 | Invoice (Invoice) | Boolean | ||
59 | Print Posted Documents (Print Posted Documents) | Boolean | ||
60 | Amount (Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
61 | Amount Including VAT (Amount Including VAT) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
62 | Shipping No. (Shipping No.) | Code20 | ||
63 | Posting No. (Posting No.) | Code20 | ||
64 | Last Shipping No. (Last Shipping No.) | Code20 |
|
Editable: No |
65 | Last Posting No. (Last Posting No.) | Code20 |
|
Editable: No |
66 | Prepayment No. (Prepayment No.) | Code20 | ||
67 | Last Prepayment No. (Last Prepayment No.) | Code20 |
|
|
68 | Prepmt. Cr. Memo No. (Prepmt. Cr. Memo No.) | Code20 | ||
69 | Last Prepmt. Cr. Memo No. (Last Prepmt. Cr. Memo No.) | Code20 |
|
|
70 | VAT Registration No. (VAT Registration No.) | Text20 | ||
71 | Combine Shipments (Combine Shipments) | Boolean | ||
73 | Reason Code (Reason Code) | Code10 |
|
|
74 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code10 |
|
|
75 | EU 3-Party Trade (EU 3-Party Trade) | Boolean | ||
76 | Transaction Type (Transaction Type) | Code10 |
|
|
77 | Transport Method (Transport Method) | Code10 |
|
|
78 | VAT Country/Region Code (VAT Country/Region Code) | Code10 |
|
|
79 | Sell-to Customer Name (Sell-to Customer Name) | Text50 | ||
80 | Sell-to Customer Name 2 (Sell-to Customer Name 2) | Text50 | ||
81 | Sell-to Address (Sell-to Address) | Text50 | ||
82 | Sell-to Address 2 (Sell-to Address 2) | Text50 | ||
83 | Sell-to City (Sell-to City) | Text30 |
|
|
84 | Sell-to Contact (Sell-to Contact) | Text50 | ||
85 | Bill-to Post Code (Bill-to Post Code) | Code20 |
|
|
86 | Bill-to County (Bill-to County) | Text30 | ||
87 | Bill-to Country/Region Code (Bill-to Country/Region Code) | Code10 |
|
|
88 | Sell-to Post Code (Sell-to Post Code) | Code20 |
|
|
89 | Sell-to County (Sell-to County) | Text30 | ||
90 | Sell-to Country/Region Code (Sell-to Country/Region Code) | Code10 |
|
|
91 | Ship-to Post Code (Ship-to Post Code) | Code20 |
|
|
92 | Ship-to County (Ship-to County) | Text30 | ||
93 | Ship-to Country/Region Code (Ship-to Country/Region Code) | Code10 |
|
|
94 | Bal. Account Type (Bal. Account Type) | Option | [G/L Account,Bank Account] | |
97 | Exit Point (Exit Point) | Code10 |
|
|
98 | Correction (Correction) | Boolean | ||
99 | Document Date (Document Date) | Date | ||
100 | External Document No. (External Document No.) | Code35 | ||
101 | Area (Area) | Code10 |
|
|
102 | Transaction Specification (Transaction Specification) | Code10 |
|
|
104 | Payment Method Code (Payment Method Code) | Code10 |
|
|
105 | Shipping Agent Code (Shipping Agent Code) | Code10 | AccessByPermission: TableData 5790=R
|
|
106 | Package Tracking No. (Package Tracking No.) | Text30 | ||
107 | No. Series (No. Series) | Code10 |
|
Editable: No |
108 | Posting No. Series (Posting No. Series) | Code10 |
|
|
109 | Shipping No. Series (Shipping No. Series) | Code10 |
|
|
114 | Tax Area Code (Tax Area Code) | Code20 |
|
|
115 | Tax Liable (Tax Liable) | Boolean | ||
116 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code10 |
|
|
117 | Reserve (Reserve) | Option | [Never,Optional,Always] InitValue: Optional AccessByPermission: TableData 27=R |
|
118 | Applies-to ID (Applies-to ID) | Code50 | ||
119 | VAT Base Discount % (VAT Base Discount %) | Decimal (0:5) | MaxValue: 100 | |
120 | Status (Status) | Option | [Open,Released,Pending Approval,Pending Prepayment] | Editable: No |
121 | Invoice Discount Calculation (Invoice Discount Calculation) | Option | [None,%,Amount] | Editable: No |
122 | Invoice Discount Value (Invoice Discount Value) | Decimal | AutoFormatType: 1 | Editable: No |
123 | Send IC Document (Send IC Document) | Boolean | ||
124 | IC Status (IC Status) | Option | [New,Pending,Sent] | |
125 | Sell-to IC Partner Code (Sell-to IC Partner Code) | Code20 |
|
Editable: No |
126 | Bill-to IC Partner Code (Bill-to IC Partner Code) | Code20 |
|
Editable: No |
129 | IC Direction (IC Direction) | Option | [Outgoing,Incoming] | |
130 | Prepayment % (Prepayment %) | Decimal (0:5) | MaxValue: 100 | |
131 | Prepayment No. Series (Prepayment No. Series) | Code10 |
|
|
132 | Compress Prepayment (Compress Prepayment) | Boolean | InitValue: Yes | |
133 | Prepayment Due Date (Prepayment Due Date) | Date | ||
134 | Prepmt. Cr. Memo No. Series (Prepmt. Cr. Memo No. Series) | Code10 |
|
|
135 | Prepmt. Posting Description (Prepmt. Posting Description) | Text50 | ||
138 | Prepmt. Pmt. Discount Date (Prepmt. Pmt. Discount Date) | Date | ||
139 | Prepmt. Payment Terms Code (Prepmt. Payment Terms Code) | Code10 |
|
|
140 | Prepmt. Payment Discount % (Prepmt. Payment Discount %) | Decimal (0:5) | MaxValue: 100 | |
151 | Quote No. (Quote No.) | Code20 | Editable: No | |
160 | Job Queue Status (Job Queue Status) | Option | [ ,Scheduled for Posting,Error,Posting] | Editable: No |
161 | Job Queue Entry ID (Job Queue Entry ID) | GUID | Editable: No | |
165 | Incoming Document Entry No. (Incoming Document Entry No.) | Integer |
|
|
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
825 | Authorization Required (Authorization Required) | Boolean | ||
827 | Credit Card No. (Credit Card No.) | Code20 |
|
|
1200 | Direct Debit Mandate ID (Direct Debit Mandate ID) | Code35 |
|
|
1305 | Invoice Discount Amount (Invoice Discount Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
5043 | No. of Archived Versions (No. of Archived Versions) | Integer |
|
Editable: No FlowField |
5048 | Doc. No. Occurrence (Doc. No. Occurrence) | Integer | ||
5050 | Campaign No. (Campaign No.) | Code20 |
|
|
5051 | Sell-to Customer Template Code (Sell-to Customer Template Code) | Code10 |
|
|
5052 | Sell-to Contact No. (Sell-to Contact No.) | Code20 |
|
|
5053 | Bill-to Contact No. (Bill-to Contact No.) | Code20 |
|
|
5054 | Bill-to Customer Template Code (Bill-to Customer Template Code) | Code10 |
|
|
5055 | Opportunity No. (Opportunity No.) | Code20 |
|
|
5700 | Responsibility Center (Responsibility Center) | Code10 |
|
|
5750 | Shipping Advice (Shipping Advice) | Option | [Partial,Complete] AccessByPermission: TableData 110=R |
|
5751 | Shipped Not Invoiced (Shipped Not Invoiced) | Boolean | AccessByPermission: TableData 110=R
|
Editable: No FlowField |
5752 | Completely Shipped (Completely Shipped) | Boolean |
|
Editable: No FlowField |
5753 | Posting from Whse. Ref. (Posting from Whse. Ref.) | Integer | AccessByPermission: TableData 14=R | |
5754 | Location Filter (Location Filter) | Code10 |
|
FlowFilter |
5755 | Shipped (Shipped) | Boolean | AccessByPermission: TableData 110=R
|
Editable: No FlowField |
5790 | Requested Delivery Date (Requested Delivery Date) | Date | AccessByPermission: TableData 99000880=R | |
5791 | Promised Delivery Date (Promised Delivery Date) | Date | AccessByPermission: TableData 99000880=R | |
5792 | Shipping Time (Shipping Time) | DateFormula | AccessByPermission: TableData 110=R | |
5793 | Outbound Whse. Handling Time (Outbound Whse. Handling Time) | DateFormula | AccessByPermission: TableData 7320=R | |
5794 | Shipping Agent Service Code (Shipping Agent Service Code) | Code10 |
|
|
5795 | Late Order Shipping (Late Order Shipping) | Boolean | AccessByPermission: TableData 110=R
|
Editable: No FlowField |
5796 | Date Filter (Date Filter) | Date | FlowFilter | |
5800 | Receive (Receive) | Boolean | ||
5801 | Return Receipt No. (Return Receipt No.) | Code20 | ||
5802 | Return Receipt No. Series (Return Receipt No. Series) | Code10 |
|
|
5803 | Last Return Receipt No. (Last Return Receipt No.) | Code20 |
|
Editable: No |
7001 | Allow Line Disc. (Allow Line Disc.) | Boolean | ||
7200 | Get Shipment Used (Get Shipment Used) | Boolean | Editable: No | |
9000 | Assigned User ID (Assigned User ID) | Code50 |
|
Keys
# | Fields | ||
---|---|---|---|
0 | Document Type,No. (Document Type,No.) | Clustered: Yes | |
1 | No.,Document Type (No.,Document Type) | ||
2 | Document Type,Sell-to Customer No. (Document Type,Sell-to Customer No.) | ||
3 | Document Type,Bill-to Customer No. (Document Type,Bill-to Customer No.) | ||
4 | Document Type,Combine Shipments,Bill-to Customer No.,Currency Code,EU 3-Party Trade,Dimension Set ID (Document Type,Combine Shipments,Bill-to Customer No.,Currency Code,EU 3-Party Trade,Dimension Set ID) | ||
5 | Sell-to Customer No.,External Document No. (Sell-to Customer No.,External Document No.) | ||
6 | Document Type,Sell-to Contact No. (Document Type,Sell-to Contact No.) | ||
7 | Bill-to Contact No. (Bill-to Contact No.) | ||
8 | Incoming Document Entry No. (Incoming Document Entry No.) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Area (Area) | Area | Code (Code) |
|
1..n |
Bal. Account No. (Bal. Account No.) | Bank Account | No. (No.) |
|
1..n |
Campaign No. (Campaign No.) | Campaign | No. (No.) |
|
1..n |
Bill-to Contact No. (Bill-to Contact No.) | Contact | No. (No.) |
|
1..n |
Ship-to Country/Region Code (Ship-to Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
Bill-to Customer No. (Bill-to Customer No.) | Customer | No. (No.) |
|
1..n |
Customer Disc. Group (Customer Disc. Group) | Customer Discount Group | Code (Code) |
|
1..n |
Customer Posting Group (Customer Posting Group) | Customer Posting Group | Code (Code) |
|
1..n |
Customer Price Group (Customer Price Group) | Customer Price Group | Code (Code) |
|
1..n |
Bill-to Customer Template Code (Bill-to Customer Template Code) | Customer Template | Code (Code) |
|
1..n |
Credit Card No. (Credit Card No.) | DO Payment Credit Card | No. (No.) |
|
1..n |
Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
Exit Point (Exit Point) | Entry/Exit Point | Code (Code) |
|
1..n |
Bal. Account No. (Bal. Account No.) | G/L Account | No. (No.) |
|
1..n |
Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
Bill-to IC Partner Code (Bill-to IC Partner Code) | IC Partner | Code (Code) |
|
1..n |
Incoming Document Entry No. (Incoming Document Entry No.) | Incoming Document | Entry No. (Entry No.) |
|
1..n |
Language Code (Language Code) | Language | Code (Code) |
|
1..n |
Location Filter (Location Filter) | Location | Code (Code) |
|
1..n |
Return Receipt No. Series (Return Receipt No. Series) | No. Series | Code (Code) |
|
1..n |
Opportunity No. (Opportunity No.) | Opportunity | No. (No.) |
|
1..n |
Payment Method Code (Payment Method Code) | Payment Method | Code (Code) |
|
1..n |
Prepmt. Payment Terms Code (Prepmt. Payment Terms Code) | Payment Terms | Code (Code) |
|