Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
2 | Buy-from Vendor No. (Buy-from Vendor No.) | Code20 |
|
NotBlank: Yes |
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 | ||
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 |
|
Editable: No |
32 | Currency Code (Currency Code) | Code10 |
|
Editable: No |
33 | Currency Factor (Currency Factor) | Decimal (0:15) | ||
37 | Invoice Disc. Code (Invoice Disc. Code) | Code20 | ||
41 | Language Code (Language Code) | Code10 |
|
|
43 | Purchaser Code (Purchaser Code) | 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 |
|
|
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 |
|
|
108 | No. Series (No. Series) | Code10 |
|
Editable: No |
112 | User ID (User ID) | Code50 |
|
|
113 | Source Code (Source Code) | 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 |
|
|
119 | VAT Base Discount % (VAT Base Discount %) | Decimal (0:5) | MaxValue: 100 | |
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
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 |
|
|
5800 | Vendor Authorization No. (Vendor Authorization No.) | Code35 | ||
6601 | Return Order No. (Return Order No.) | Code20 | ||
6602 | Return Order No. Series (Return Order No. Series) | Code10 |
|
Keys
# | Fields | ||
---|---|---|---|
0 | No. (No.) | Clustered: Yes | |
1 | Return Order No. (Return Order No.) | ||
2 | Buy-from Vendor No. (Buy-from Vendor No.) | ||
3 | Pay-to Vendor No. (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 |
Language Code (Language Code) | Language | Code (Code) |
|
1..n |
Location Code (Location Code) | Location | () |
|
1..n |
Return Order No. Series (Return Order 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 |
Payment Terms Code (Payment Terms Code) | Payment Terms | Code (Code) |
|
1..n |
Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
Responsibility Center (Responsibility Center) | Responsibility Center | Code (Code) |
|
1..n |
Purchaser Code (Purchaser Code) | Salesperson/Purchaser | Code (Code) |
|
1..n |
Ship-to Code (Ship-to Code) | Ship-to Address | Code (Code) |
|
1..n |
Shipment Method Code (Shipment Method Code) | Shipment Method | Code (Code) |
|
1..n |
Source Code (Source Code) | Source Code | 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 |
User ID (User ID) | User | User Name (User Name) |
|
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 | ||
---|---|---|---|
Certificate of Supply | Document No. (Document No.) |
|
1..n |
Item Charge Assignment (Purch) | Applies-to Doc. No. (Applies-to Doc. No.) |
|
1..n |
Posted Invt. Pick Header | Source No. (Source No.) |
|
1..n |
Posted Invt. Put-away Header | Source No. (Source No.) |
|
1..n |
Purchase Header | Last Return Shipment No. (Last Return Shipment No.) |
|
1..n |
Purchase Header Archive | Last Return Shipment No. (Last Return Shipment No.) |
|
1..n |
Registered Invt. Movement Hdr. | Source No. (Source No.) |
|
1..n |
Return Shipment Line | Document No. (Document No.) |
|
1..n |