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 | Buy-from Vendor No. (Buy-from Vendor No.) | Code20 |
|
|
| 3 | No. (No.) | Code20 | ||
| 4 | Pay-to Vendor No. (Pay-to Vendor No.) | Code20 |
|
NotBlank: Yes |
| 5 | Pay-to Name (Pay-to Name) | Text50 | ||
| 6 | Pay-to Name 2 (Pay-to Name 2) | Text50 | ||
| 7 | Pay-to Address (Pay-to Address) | Text50 | ||
| 8 | Pay-to Address 2 (Pay-to Address 2) | Text50 | ||
| 9 | Pay-to City (Pay-to City) | Text30 |
|
|
| 10 | Pay-to Contact (Pay-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 120=R | |
| 20 | Posting Date (Posting Date) | Date | ||
| 21 | Expected Receipt Date (Expected Receipt 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 | Vendor Posting Group (Vendor Posting Group) | Code10 |
|
|
| 32 | Currency Code (Currency Code) | Code10 |
|
|
| 33 | Currency Factor (Currency Factor) | Decimal (0:15) | ||
| 35 | Prices Including VAT (Prices Including VAT) | Boolean | ||
| 37 | Invoice Disc. Code (Invoice Disc. Code) | Code20 | ||
| 41 | Language Code (Language Code) | Code10 |
|
|
| 43 | Purchaser Code (Purchaser Code) | Code10 |
|
|
| 45 | Order Class (Order Class) | Code10 | ||
| 46 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
| 47 | No. Printed (No. Printed) | Integer | ||
| 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 |
|
|
| 57 | Receive (Receive) | Boolean | ||
| 58 | Invoice (Invoice) | Boolean | ||
| 60 | Amount (Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
FlowField |
| 61 | Amount Including VAT (Amount Including VAT) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
| 62 | Receiving No. (Receiving No.) | Code20 | ||
| 63 | Posting No. (Posting No.) | Code20 | ||
| 64 | Last Receiving No. (Last Receiving No.) | Code20 |
|
|
| 65 | Last Posting No. (Last Posting No.) | Code20 |
|
|
| 66 | Vendor Order No. (Vendor Order No.) | Code35 | ||
| 67 | Vendor Shipment No. (Vendor Shipment No.) | Code35 | ||
| 68 | Vendor Invoice No. (Vendor Invoice No.) | Code35 | ||
| 69 | Vendor Cr. Memo No. (Vendor Cr. Memo No.) | Code35 | ||
| 70 | VAT Registration No. (VAT Registration No.) | Text20 | ||
| 72 | Sell-to Customer No. (Sell-to Customer No.) | Code20 |
|
|
| 73 | Reason Code (Reason Code) | Code10 |
|
|
| 74 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code10 |
|
|
| 76 | Transaction Type (Transaction Type) | Code10 |
|
|
| 77 | Transport Method (Transport Method) | Code10 |
|
|
| 78 | VAT Country/Region Code (VAT Country/Region Code) | Code10 |
|
|
| 79 | Buy-from Vendor Name (Buy-from Vendor Name) | Text50 | ||
| 80 | Buy-from Vendor Name 2 (Buy-from Vendor Name 2) | Text50 | ||
| 81 | Buy-from Address (Buy-from Address) | Text50 | ||
| 82 | Buy-from Address 2 (Buy-from Address 2) | Text50 | ||
| 83 | Buy-from City (Buy-from City) | Text30 |
|
|
| 84 | Buy-from Contact (Buy-from Contact) | Text50 | ||
| 85 | Pay-to Post Code (Pay-to Post Code) | Code20 |
|
|
| 86 | Pay-to County (Pay-to County) | Text30 | ||
| 87 | Pay-to Country/Region Code (Pay-to Country/Region Code) | Code10 |
|
|
| 88 | Buy-from Post Code (Buy-from Post Code) | Code20 |
|
|
| 89 | Buy-from County (Buy-from County) | Text30 | ||
| 90 | Buy-from Country/Region Code (Buy-from 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] | |
| 95 | Order Address Code (Order Address Code) | Code10 |
|
|
| 97 | Entry Point (Entry Point) | Code10 |
|
|
| 98 | Correction (Correction) | Boolean | ||
| 99 | Document Date (Document Date) | Date | ||
| 101 | Area (Area) | Code10 |
|
|
| 102 | Transaction Specification (Transaction Specification) | Code10 |
|
|
| 104 | Payment Method Code (Payment Method Code) | Code10 |
|
|
| 107 | No. Series (No. Series) | Code10 |
|
|
| 108 | Posting No. Series (Posting No. Series) | Code10 |
|
|
| 109 | Receiving No. Series (Receiving 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 |
|
|
| 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] | |
| 121 | Invoice Discount Calculation (Invoice Discount Calculation) | Option | [None,%,Amount] | |
| 122 | Invoice Discount Value (Invoice Discount Value) | Decimal | AutoFormatType: 1 | |
| 123 | Send IC Document (Send IC Document) | Boolean | ||
| 124 | IC Status (IC Status) | Option | [New,Pending,Sent] | |
| 125 | Buy-from IC Partner Code (Buy-from IC Partner Code) | Code20 |
|
Editable: No |
| 126 | Pay-to IC Partner Code (Pay-to IC Partner Code) | Code20 |
|
Editable: No |
| 129 | IC Direction (IC Direction) | Option | [Outgoing,Incoming] | |
| 130 | Prepayment No. (Prepayment No.) | Code20 | ||
| 131 | Last Prepayment No. (Last Prepayment No.) | Code20 |
|
|
| 132 | Prepmt. Cr. Memo No. (Prepmt. Cr. Memo No.) | Code20 | ||
| 133 | Last Prepmt. Cr. Memo No. (Last Prepmt. Cr. Memo No.) | Code20 |
|
|
| 134 | Prepayment % (Prepayment %) | Decimal (0:5) | MaxValue: 100 | |
| 135 | Prepayment No. Series (Prepayment No. Series) | Code10 |
|
|
| 136 | Compress Prepayment (Compress Prepayment) | Boolean | InitValue: Yes | |
| 137 | Prepayment Due Date (Prepayment Due Date) | Date | ||
| 138 | Prepmt. Cr. Memo No. Series (Prepmt. Cr. Memo No. Series) | Code10 |
|
|
| 139 | Prepmt. Posting Description (Prepmt. Posting Description) | Text50 | ||
| 142 | Prepmt. Pmt. Discount Date (Prepmt. Pmt. Discount Date) | Date | ||
| 143 | Prepmt. Payment Terms Code (Prepmt. Payment Terms Code) | Code10 |
|
|
| 144 | Prepmt. Payment Discount % (Prepmt. Payment Discount %) | Decimal (0:5) | MaxValue: 100 | |
| 145 | No. of Archived Versions (No. of Archived Versions) | Integer |
|
Editable: No FlowField |
| 151 | Purchase Quote No. (Purchase Quote No.) | Code20 |
|
Editable: No |
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 5043 | Interaction Exist (Interaction Exist) | Boolean | ||
| 5044 | Time Archived (Time Archived) | Time | ||
| 5045 | Date Archived (Date Archived) | Date | ||
| 5046 | Archived By (Archived By) | Code50 |
|
Editable: No |
| 5047 | Version No. (Version No.) | Integer | ||
| 5048 | Doc. No. Occurrence (Doc. No. Occurrence) | Integer | ||
| 5050 | Campaign No. (Campaign No.) | Code20 |
|
|
| 5052 | Buy-from Contact No. (Buy-from Contact No.) | Code20 |
|
|
| 5053 | Pay-to Contact No. (Pay-to Contact No.) | Code20 |
|
|
| 5700 | Responsibility Center (Responsibility Center) | Code10 |
|
|
| 5752 | Completely Received (Completely Received) | Boolean |
|
Editable: No FlowField |
| 5753 | Posting from Whse. Ref. (Posting from Whse. Ref.) | Integer | ||
| 5754 | Location Filter (Location Filter) | Code10 |
|
FlowFilter |
| 5790 | Requested Receipt Date (Requested Receipt Date) | Date | AccessByPermission: TableData 99000880=R | |
| 5791 | Promised Receipt Date (Promised Receipt Date) | Date | ||
| 5792 | Lead Time Calculation (Lead Time Calculation) | DateFormula | AccessByPermission: TableData 120=R | |
| 5793 | Inbound Whse. Handling Time (Inbound Whse. Handling Time) | DateFormula | AccessByPermission: TableData 14=R | |
| 5796 | Date Filter (Date Filter) | Date | FlowFilter | |
| 5800 | Vendor Authorization No. (Vendor Authorization No.) | Code35 | ||
| 5801 | Return Shipment No. (Return Shipment No.) | Code20 | ||
| 5802 | Return Shipment No. Series (Return Shipment No. Series) | Code10 |
|
|
| 5803 | Ship (Ship) | Boolean | ||
| 5804 | Last Return Shipment No. (Last Return Shipment No.) | Code20 |
|
|
| 9000 | Assigned User ID (Assigned User ID) | Code50 |
|
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Document Type,No.,Doc. No. Occurrence,Version No. (Document Type,No.,Doc. No. Occurrence,Version No.) | Clustered: Yes | |
| 1 | Document Type,Buy-from Vendor No. (Document Type,Buy-from Vendor No.) | ||
| 2 | Document Type,Pay-to Vendor No. (Document Type,Pay-to Vendor 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 |
| Pay-to Contact No. (Pay-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 |
| Sell-to Customer No. (Sell-to Customer No.) | Customer | 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 |
| Entry Point (Entry 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 |
| Pay-to IC Partner Code (Pay-to IC Partner Code) | IC Partner | Code (Code) |
|
1..n |
| Language Code (Language Code) | Language | Code (Code) |
|
1..n |
| Location Filter (Location Filter) | Location | Code (Code) |
|
1..n |
| Return Shipment No. Series (Return Shipment No. Series) | No. Series | Code (Code) |
|
1..n |
| Order Address Code (Order Address Code) | Order Address | Code (Code) |
|
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) |
|
1..n |
| Last Posting No. (Last Posting No.) | Purch. Inv. Header | No. (No.) |
|
1..n |
| Last Receiving No. (Last Receiving No.) | Purch. Rcpt. Header | No. (No.) |
|
1..n |
| Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
| Responsibility Center (Responsibility Center) | Responsibility Center | Code (Code) |
|
1..n |
| Last Return Shipment No. (Last Return Shipment No.) | Return Shipment Header | No. (No.) |
|
1..n |
| Last Prepmt. Cr. Memo No. (Last Prepmt. Cr. Memo No.) | Sales Invoice Header | No. (No.) |
|
1..n |
| Purchaser Code (Purchaser Code) | Salesperson/Purchaser | Code (Code) |
|
1..n |
| Shipment Method Code (Shipment Method Code) | Shipment Method | Code (Code) |
|
1..n |
| Tax Area Code (Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
| Transaction Specification (Transaction Specification) | Transaction Specification | Code (Code) |
|
1..n |
| Transaction Type (Transaction Type) | Transaction Type | Code (Code) |
|
1..n |
| Transport Method (Transport Method) | Transport Method | Code (Code) |
|
1..n |
| Archived By (Archived By) | User | User Name (User Name) |
|
1..n |
| Assigned User ID (Assigned User ID) | User Setup | User ID (User ID) |
|
1..n |
| VAT Bus. Posting Group (VAT Bus. Posting Group) | VAT Business Posting Group | Code (Code) |
|
1..n |
| Pay-to Vendor No. (Pay-to Vendor No.) | Vendor | No. (No.) |
|
1..n |
| Vendor Posting Group (Vendor Posting Group) | Vendor Posting Group | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Purchase Line Archive | Document No. (Document No.) |
|
1..n |