Where are the diagrams?

Table 38 Purchase HeaderSetup BC Server URL to get a link to the data

CaptionML: ENU=Purchase Header
DataCaptionFields: No.,Buy-from Vendor Name
LookupPageID: Page53

Fields

#	Name ・Caption	Type
1 PK	Document Type	Option	CaptionML ENU=Document Type OptionCaptionML ENU=Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order OptionString [Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order]
3 PK	No.	Code20	CaptionML ENU=No.
2	Buy-from Vendor No.	Code20	TableRelation Vendor Refers To Vendor CaptionML ENU=Buy-from Vendor No.
4	Pay-to Vendor No.	Code20	NotBlank TableRelation Vendor Refers To Vendor CaptionML ENU=Pay-to Vendor No.
5	Pay-to Name	Text50	CaptionML ENU=Pay-to Name
6	Pay-to Name 2	Text50	CaptionML ENU=Pay-to Name 2
7	Pay-to Address	Text50	CaptionML ENU=Pay-to Address
8	Pay-to Address 2	Text50	CaptionML ENU=Pay-to Address 2
9	Pay-to City	Text30	TableRelation Validate IF (Pay-to Country/Region Code=CONST()) "Post Code".City ELSE IF (Pay-to Country/Region Code=FILTER(<>'')) "Post Code".City WHERE (Country/Region Code=FIELD(Pay-to Country/Region Code)); Refers To Post Code CaptionML ENU=Pay-to City
10	Pay-to Contact	Text50	CaptionML ENU=Pay-to Contact
11	Your Reference	Text35	CaptionML ENU=Your Reference
12	Ship-to Code	Code10	TableRelation "Ship-to Address".Code WHERE (Customer No.=FIELD(Sell-to Customer No.)) Refers To Ship-to Address CaptionML ENU=Ship-to Code
13	Ship-to Name	Text50	CaptionML ENU=Ship-to Name
14	Ship-to Name 2	Text50	CaptionML ENU=Ship-to Name 2
15	Ship-to Address	Text50	CaptionML ENU=Ship-to Address
16	Ship-to Address 2	Text50	CaptionML ENU=Ship-to Address 2
17	Ship-to City	Text30	TableRelation Validate IF (Ship-to Country/Region Code=CONST()) "Post Code".City ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code".City WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); Refers To Post Code CaptionML ENU=Ship-to City
18	Ship-to Contact	Text50	CaptionML ENU=Ship-to Contact
19	Order Date	Date	CaptionML ENU=Order Date AccessByPermission TableData 120=R
20	Posting Date	Date	CaptionML ENU=Posting Date
21	Expected Receipt Date	Date	CaptionML ENU=Expected Receipt Date
22	Posting Description	Text50	CaptionML ENU=Posting Description
23	Payment Terms Code	Code10	TableRelation "Payment Terms" Refers To Payment Terms CaptionML ENU=Payment Terms Code
24	Due Date	Date	CaptionML ENU=Due Date
25	Payment Discount %	Decimal	CaptionML ENU=Payment Discount % DecimalPlaces 0:5 MinValue 0 MaxValue 100
26	Pmt. Discount Date	Date	CaptionML ENU=Pmt. Discount Date
27	Shipment Method Code	Code10	TableRelation "Shipment Method" Refers To Shipment Method CaptionML ENU=Shipment Method Code
28	Location Code	Code10	TableRelation Location WHERE (Use As In-Transit=CONST(No)) Refers To Location CaptionML ENU=Location Code
29	Shortcut Dimension 1 Code	Code20	TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(1), Blocked=CONST(No)); Refers To Dimension Value CaptionClass '1,2,1' CaptionML ENU=Shortcut Dimension 1 Code
30	Shortcut Dimension 2 Code	Code20	TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(2), Blocked=CONST(No)); Refers To Dimension Value CaptionClass '1,2,2' CaptionML ENU=Shortcut Dimension 2 Code
31	Vendor Posting Group	Code10	NotEditable TableRelation "Vendor Posting Group" Refers To Vendor Posting Group CaptionML ENU=Vendor Posting Group
32	Currency Code	Code10	TableRelation Currency Refers To Currency CaptionML ENU=Currency Code
33	Currency Factor	Decimal	NotEditable CaptionML ENU=Currency Factor DecimalPlaces 0:15 MinValue 0
35	Prices Including VAT	Boolean	CaptionML ENU=Prices Including VAT
37	Invoice Disc. Code	Code20	CaptionML ENU=Invoice Disc. Code
41	Language Code	Code10	TableRelation Language Refers To Language CaptionML ENU=Language Code
43	Purchaser Code	Code10	TableRelation Salesperson/Purchaser Refers To Salesperson/Purchaser CaptionML ENU=Purchaser Code
45	Order Class	Code10	CaptionML ENU=Order Class
46	Comment	Boolean	NotEditableFlowField CalcFormula Exist("Purch. Comment Line" WHERE (Document Type=FIELD(Document Type), No.=FIELD(No.), Document Line No.=CONST(0))); CaptionML ENU=Comment
47	No. Printed	Integer	NotEditable CaptionML ENU=No. Printed
51	On Hold	Code3	CaptionML ENU=On Hold
52	Applies-to Doc. Type	Option	CaptionML ENU=Applies-to Doc. Type OptionCaptionML ENU=" ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund" OptionString [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund]
53	Applies-to Doc. No.	Code20	CaptionML ENU=Applies-to Doc. No.
55	Bal. Account No.	Code20	TableRelation IF (Bal. Account Type=CONST(G/L Account)) "G/L Account" ELSE IF (Bal. Account Type=CONST(Bank Account)) "Bank Account"; Refers To G/L Account Bank Account CaptionML ENU=Bal. Account No.
56	Recalculate Invoice Disc.	Boolean	NotEditableFlowField CalcFormula Exist("Purchase Line" WHERE (Document Type=FIELD(Document Type), Document No.=FIELD(No.), Recalculate Invoice Disc.=CONST(Yes))); CaptionML ENU=Recalculate Invoice Disc.
57	Receive	Boolean	CaptionML ENU=Receive
58	Invoice	Boolean	CaptionML ENU=Invoice
59	Print Posted Documents	Boolean	CaptionML ENU=Print Posted Documents
60	Amount	Decimal	NotEditableFlowField CalcFormula Sum("Purchase Line".Amount WHERE (Document Type=FIELD(Document Type), Document No.=FIELD(No.))); CaptionML ENU=Amount AutoFormatType 1 AutoFormatExpr "Currency Code"
61	Amount Including VAT	Decimal	NotEditableFlowField CalcFormula Sum("Purchase Line"."Amount Including VAT" WHERE (Document Type=FIELD(Document Type), Document No.=FIELD(No.))); CaptionML ENU=Amount Including VAT AutoFormatType 1 AutoFormatExpr "Currency Code"
62	Receiving No.	Code20	CaptionML ENU=Receiving No.
63	Posting No.	Code20	CaptionML ENU=Posting No.
64	Last Receiving No.	Code20	NotEditable TableRelation "Purch. Rcpt. Header" Refers To Purch. Rcpt. Header CaptionML ENU=Last Receiving No.
65	Last Posting No.	Code20	NotEditable TableRelation "Purch. Inv. Header" Refers To Purch. Inv. Header CaptionML ENU=Last Posting No.
66	Vendor Order No.	Code35	CaptionML ENU=Vendor Order No.
67	Vendor Shipment No.	Code35	CaptionML ENU=Vendor Shipment No.
68	Vendor Invoice No.	Code35	CaptionML ENU=Vendor Invoice No.
69	Vendor Cr. Memo No.	Code35	CaptionML ENU=Vendor Cr. Memo No.
70	VAT Registration No.	Text20	CaptionML ENU=VAT Registration No.
72	Sell-to Customer No.	Code20	TableRelation Customer Refers To Customer CaptionML ENU=Sell-to Customer No.
73	Reason Code	Code10	TableRelation "Reason Code" Refers To Reason Code CaptionML ENU=Reason Code
74	Gen. Bus. Posting Group	Code10	TableRelation "Gen. Business Posting Group" Refers To Gen. Business Posting Group CaptionML ENU=Gen. Bus. Posting Group
76	Transaction Type	Code10	TableRelation "Transaction Type" Refers To Transaction Type CaptionML ENU=Transaction Type
77	Transport Method	Code10	TableRelation "Transport Method" Refers To Transport Method CaptionML ENU=Transport Method
78	VAT Country/Region Code	Code10	TableRelation Country/Region Refers To Country/Region CaptionML ENU=VAT Country/Region Code
79	Buy-from Vendor Name	Text50	CaptionML ENU=Buy-from Vendor Name
80	Buy-from Vendor Name 2	Text50	CaptionML ENU=Buy-from Vendor Name 2
81	Buy-from Address	Text50	CaptionML ENU=Buy-from Address
82	Buy-from Address 2	Text50	CaptionML ENU=Buy-from Address 2
83	Buy-from City	Text30	TableRelation Validate IF (Buy-from Country/Region Code=CONST()) "Post Code".City ELSE IF (Buy-from Country/Region Code=FILTER(<>'')) "Post Code".City WHERE (Country/Region Code=FIELD(Buy-from Country/Region Code)); Refers To Post Code CaptionML ENU=Buy-from City
84	Buy-from Contact	Text50	CaptionML ENU=Buy-from Contact
85	Pay-to Post Code	Code20	TableRelation Validate IF (Pay-to Country/Region Code=CONST()) "Post Code" ELSE IF (Pay-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Pay-to Country/Region Code)); Refers To Post Code CaptionML ENU=Pay-to Post Code
86	Pay-to County	Text30	CaptionML ENU=Pay-to County
87	Pay-to Country/Region Code	Code10	TableRelation Country/Region Refers To Country/Region CaptionML ENU=Pay-to Country/Region Code
88	Buy-from Post Code	Code20	TableRelation Validate IF (Buy-from Country/Region Code=CONST()) "Post Code" ELSE IF (Buy-from Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Buy-from Country/Region Code)); Refers To Post Code CaptionML ENU=Buy-from Post Code
89	Buy-from County	Text30	CaptionML ENU=Buy-from County
90	Buy-from Country/Region Code	Code10	TableRelation Country/Region Refers To Country/Region CaptionML ENU=Buy-from Country/Region Code
91	Ship-to Post Code	Code20	TableRelation Validate IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); Refers To Post Code CaptionML ENU=Ship-to Post Code
92	Ship-to County	Text30	CaptionML ENU=Ship-to County
93	Ship-to Country/Region Code	Code10	TableRelation Country/Region Refers To Country/Region CaptionML ENU=Ship-to Country/Region Code
94	Bal. Account Type	Option	CaptionML ENU=Bal. Account Type OptionCaptionML ENU=G/L Account,Bank Account OptionString [G/L Account,Bank Account]
95	Order Address Code	Code10	TableRelation "Order Address".Code WHERE (Vendor No.=FIELD(Buy-from Vendor No.)) Refers To Order Address CaptionML ENU=Order Address Code
97	Entry Point	Code10	TableRelation "Entry/Exit Point" Refers To Entry/Exit Point CaptionML ENU=Entry Point
98	Correction	Boolean	CaptionML ENU=Correction
99	Document Date	Date	CaptionML ENU=Document Date
101	Area	Code10	TableRelation Area Refers To Area CaptionML ENU=Area
102	Transaction Specification	Code10	TableRelation "Transaction Specification" Refers To Transaction Specification CaptionML ENU=Transaction Specification
104	Payment Method Code	Code10	TableRelation "Payment Method" Refers To Payment Method CaptionML ENU=Payment Method Code
107	No. Series	Code10	NotEditable TableRelation "No. Series" Refers To No. Series CaptionML ENU=No. Series
108	Posting No. Series	Code10	TableRelation "No. Series" Refers To No. Series CaptionML ENU=Posting No. Series
109	Receiving No. Series	Code10	TableRelation "No. Series" Refers To No. Series CaptionML ENU=Receiving No. Series
114	Tax Area Code	Code20	TableRelation "Tax Area" Refers To Tax Area CaptionML ENU=Tax Area Code
115	Tax Liable	Boolean	CaptionML ENU=Tax Liable
116	VAT Bus. Posting Group	Code10	TableRelation "VAT Business Posting Group" Refers To VAT Business Posting Group CaptionML ENU=VAT Bus. Posting Group
118	Applies-to ID	Code50	CaptionML ENU=Applies-to ID
119	VAT Base Discount %	Decimal	CaptionML ENU=VAT Base Discount % DecimalPlaces 0:5 MinValue 0 MaxValue 100
120	Status	Option	NotEditable CaptionML ENU=Status OptionCaptionML ENU=Open,Released,Pending Approval,Pending Prepayment OptionString [Open,Released,Pending Approval,Pending Prepayment]
121	Invoice Discount Calculation	Option	NotEditable CaptionML ENU=Invoice Discount Calculation OptionCaptionML ENU=None,%,Amount OptionString [None,%,Amount]
122	Invoice Discount Value	Decimal	NotEditable CaptionML ENU=Invoice Discount Value AutoFormatType 1
123	Send IC Document	Boolean	CaptionML ENU=Send IC Document
124	IC Status	Option	CaptionML ENU=IC Status OptionCaptionML ENU=New,Pending,Sent OptionString [New,Pending,Sent]
125	Buy-from IC Partner Code	Code20	NotEditable TableRelation "IC Partner" Refers To IC Partner CaptionML ENU=Buy-from IC Partner Code
126	Pay-to IC Partner Code	Code20	NotEditable TableRelation "IC Partner" Refers To IC Partner CaptionML ENU=Pay-to IC Partner Code
129	IC Direction	Option	CaptionML ENU=IC Direction OptionCaptionML ENU=Outgoing,Incoming OptionString [Outgoing,Incoming]
130	Prepayment No.	Code20	CaptionML ENU=Prepayment No.
131	Last Prepayment No.	Code20	TableRelation "Purch. Inv. Header" Refers To Purch. Inv. Header CaptionML ENU=Last Prepayment No.
132	Prepmt. Cr. Memo No.	Code20	CaptionML ENU=Prepmt. Cr. Memo No.
133	Last Prepmt. Cr. Memo No.	Code20	TableRelation "Purch. Cr. Memo Hdr." Refers To Purch. Cr. Memo Hdr. CaptionML ENU=Last Prepmt. Cr. Memo No.
134	Prepayment %	Decimal	CaptionML ENU=Prepayment % DecimalPlaces 0:5 MinValue 0 MaxValue 100
135	Prepayment No. Series	Code10	TableRelation "No. Series" Refers To No. Series CaptionML ENU=Prepayment No. Series
136	Compress Prepayment	Boolean	CaptionML ENU=Compress Prepayment InitValue Yes
137	Prepayment Due Date	Date	CaptionML ENU=Prepayment Due Date
138	Prepmt. Cr. Memo No. Series	Code10	TableRelation "No. Series" Refers To No. Series CaptionML ENU=Prepmt. Cr. Memo No. Series
139	Prepmt. Posting Description	Text50	CaptionML ENU=Prepmt. Posting Description
142	Prepmt. Pmt. Discount Date	Date	CaptionML ENU=Prepmt. Pmt. Discount Date
143	Prepmt. Payment Terms Code	Code10	TableRelation "Payment Terms" Refers To Payment Terms CaptionML ENU=Prepmt. Payment Terms Code
144	Prepmt. Payment Discount %	Decimal	CaptionML ENU=Prepmt. Payment Discount % DecimalPlaces 0:5 MinValue 0 MaxValue 100
151	Quote No.	Code20	NotEditable CaptionML ENU=Quote No.
160	Job Queue Status	Option	NotEditable CaptionML ENU=Job Queue Status OptionCaptionML ENU=" ,Scheduled for Posting,Error,Posting" OptionString [ ,Scheduled for Posting,Error,Posting]
161	Job Queue Entry ID	GUID	NotEditable CaptionML ENU=Job Queue Entry ID
165	Incoming Document Entry No.	Integer	TableRelation "Incoming Document" Refers To Incoming Document CaptionML ENU=Incoming Document Entry No.
170	Creditor No.	Code20	Numeric CaptionML ENU=Creditor No.
171	Payment Reference	Code50	Numeric CaptionML ENU=Payment Reference
480	Dimension Set ID	Integer	NotEditable TableRelation "Dimension Set Entry" Refers To CaptionML ENU=Dimension Set ID
1305	Invoice Discount Amount	Decimal	NotEditableFlowField CalcFormula Sum("Purchase Line"."Inv. Discount Amount" WHERE (Document No.=FIELD(No.), Document Type=FIELD(Document Type))); CaptionML ENU=Invoice Discount Amount AutoFormatType 1
5043	No. of Archived Versions	Integer	NotEditableFlowField CalcFormula Max("Purchase Header Archive"."Version No." WHERE (Document Type=FIELD(Document Type), No.=FIELD(No.), Doc. No. Occurrence=FIELD(Doc. No. Occurrence))); CaptionML ENU=No. of Archived Versions
5048	Doc. No. Occurrence	Integer	CaptionML ENU=Doc. No. Occurrence
5050	Campaign No.	Code20	TableRelation Campaign Refers To Campaign CaptionML ENU=Campaign No.
5052	Buy-from Contact No.	Code20	TableRelation Contact Refers To Contact CaptionML ENU=Buy-from Contact No.
5053	Pay-to Contact No.	Code20	TableRelation Contact Refers To Contact CaptionML ENU=Pay-to Contact No.
5700	Responsibility Center	Code10	TableRelation "Responsibility Center" Refers To Responsibility Center CaptionML ENU=Responsibility Center
5752	Completely Received	Boolean	NotEditableFlowField CalcFormula Min("Purchase Line"."Completely Received" WHERE (Document Type=FIELD(Document Type), Document No.=FIELD(No.), Type=FILTER(<>' '), Location Code=FIELD(Location Filter))); CaptionML ENU=Completely Received
5753	Posting from Whse. Ref.	Integer	CaptionML ENU=Posting from Whse. Ref. AccessByPermission TableData 14=R
5754	Location Filter	Code10	FlowFilter TableRelation Location Refers To Location CaptionML ENU=Location Filter
5790	Requested Receipt Date	Date	CaptionML ENU=Requested Receipt Date AccessByPermission TableData 99000880=R
5791	Promised Receipt Date	Date	CaptionML ENU=Promised Receipt Date
5792	Lead Time Calculation	DateFormula	CaptionML ENU=Lead Time Calculation AccessByPermission TableData 120=R
5793	Inbound Whse. Handling Time	DateFormula	CaptionML ENU=Inbound Whse. Handling Time AccessByPermission TableData 14=R
5796	Date Filter	Date	FlowFilter CaptionML ENU=Date Filter
5800	Vendor Authorization No.	Code35	CaptionML ENU=Vendor Authorization No.
5801	Return Shipment No.	Code20	CaptionML ENU=Return Shipment No.
5802	Return Shipment No. Series	Code10	TableRelation "No. Series" Refers To No. Series CaptionML ENU=Return Shipment No. Series
5803	Ship	Boolean	CaptionML ENU=Ship
5804	Last Return Shipment No.	Code20	NotEditable TableRelation "Return Shipment Header" Refers To Return Shipment Header CaptionML ENU=Last Return Shipment No.
9000	Assigned User ID	Code50	TableRelation "User Setup" Refers To User Setup CaptionML ENU=Assigned User ID
9001	Pending Approvals	Integer	FlowField CalcFormula Count("Approval Entry" WHERE (Table ID=CONST(38), Document Type=FIELD(Document Type), Document No.=FIELD(No.), Status=FILTER(Open\|Created))); CaptionML ENU=Pending Approvals

Keys

Name	Fields
0	Document Type No.	Clustered
1	No. Document Type
2	Document Type Buy-from Vendor No.
3	Document Type Pay-to Vendor No.
4	Buy-from Vendor No.
5	Incoming Document Entry No.

Refers To

From Field	To Table	To Field
Area	Area	Code	TableRelation Area n:1
Bal. Account No.	Bank Account	No.	TableRelation IF (Bal. Account Type=CONST(G/L Account)) "G/L Account" ELSE IF (Bal. Account Type=CONST(Bank Account)) "Bank Account"; n:1
Campaign No.	Campaign	No.	TableRelation Campaign n:1
Buy-from Contact No.	Contact	No.	TableRelation Contact n:1
Pay-to Contact No.	Contact	No.	TableRelation Contact n:1
VAT Country/Region Code	Country/Region	Code	TableRelation Country/Region n:1
Pay-to Country/Region Code	Country/Region	Code	TableRelation Country/Region n:1
Buy-from Country/Region Code	Country/Region	Code	TableRelation Country/Region n:1
Ship-to Country/Region Code	Country/Region	Code	TableRelation Country/Region n:1
Currency Code	Currency	Code	TableRelation Currency n:1
Sell-to Customer No.	Customer	No.	TableRelation Customer n:1
Shortcut Dimension 1 Code	Dimension Value	Code	TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(1), Blocked=CONST(No)); 1:1
Shortcut Dimension 2 Code	Dimension Value	Code	TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(2), Blocked=CONST(No)); 1:1
Entry Point	Entry/Exit Point	Code	TableRelation "Entry/Exit Point" n:1
Bal. Account No.	G/L Account	No.	TableRelation IF (Bal. Account Type=CONST(G/L Account)) "G/L Account" ELSE IF (Bal. Account Type=CONST(Bank Account)) "Bank Account"; n:1
Gen. Bus. Posting Group	Gen. Business Posting Group	Code	TableRelation "Gen. Business Posting Group" n:1
Buy-from IC Partner Code	IC Partner	Code	TableRelation "IC Partner" n:1
Pay-to IC Partner Code	IC Partner	Code	TableRelation "IC Partner" n:1
Incoming Document Entry No.	Incoming Document	Entry No.	TableRelation "Incoming Document" n:1
Language Code	Language	Code	TableRelation Language n:1
Location Code	Location	Code	TableRelation Location WHERE (Use As In-Transit=CONST(No)) 1:1
Location Filter	Location	Code	TableRelation Location n:1
No. Series	No. Series	Code	TableRelation "No. Series" n:1
Posting No. Series	No. Series	Code	TableRelation "No. Series" n:1
Receiving No. Series	No. Series	Code	TableRelation "No. Series" n:1
Prepayment No. Series	No. Series	Code	TableRelation "No. Series" n:1
Prepmt. Cr. Memo No. Series	No. Series	Code	TableRelation "No. Series" n:1
Return Shipment No. Series	No. Series	Code	TableRelation "No. Series" n:1
Order Address Code	Order Address	Code	TableRelation "Order Address".Code WHERE (Vendor No.=FIELD(Buy-from Vendor No.)) n:1
Payment Method Code	Payment Method	Code	TableRelation "Payment Method" n:1
Payment Terms Code	Payment Terms	Code	TableRelation "Payment Terms" n:1
Prepmt. Payment Terms Code	Payment Terms	Code	TableRelation "Payment Terms" n:1
Pay-to City	Post Code	City	TableRelation IF (Pay-to Country/Region Code=CONST()) "Post Code".City ELSE IF (Pay-to Country/Region Code=FILTER(<>'')) "Post Code".City WHERE (Country/Region Code=FIELD(Pay-to Country/Region Code)); n:1
Ship-to City	Post Code	City	TableRelation IF (Ship-to Country/Region Code=CONST()) "Post Code".City ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code".City WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); n:1
Buy-from City	Post Code	City	TableRelation IF (Buy-from Country/Region Code=CONST()) "Post Code".City ELSE IF (Buy-from Country/Region Code=FILTER(<>'')) "Post Code".City WHERE (Country/Region Code=FIELD(Buy-from Country/Region Code)); n:1
Pay-to Post Code	Post Code	Code	TableRelation IF (Pay-to Country/Region Code=CONST()) "Post Code" ELSE IF (Pay-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Pay-to Country/Region Code)); n:1
Buy-from Post Code	Post Code	Code	TableRelation IF (Buy-from Country/Region Code=CONST()) "Post Code" ELSE IF (Buy-from Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Buy-from Country/Region Code)); n:1
Ship-to Post Code	Post Code	Code	TableRelation IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); n:1
Last Prepmt. Cr. Memo No.	Purch. Cr. Memo Hdr.	No.	TableRelation "Purch. Cr. Memo Hdr." n:1
Last Posting No.	Purch. Inv. Header	No.	TableRelation "Purch. Inv. Header" n:1
Last Prepayment No.	Purch. Inv. Header	No.	TableRelation "Purch. Inv. Header" n:1
Last Receiving No.	Purch. Rcpt. Header	No.	TableRelation "Purch. Rcpt. Header" n:1
Reason Code	Reason Code	Code	TableRelation "Reason Code" n:1
Responsibility Center	Responsibility Center	Code	TableRelation "Responsibility Center" n:1
Last Return Shipment No.	Return Shipment Header	No.	TableRelation "Return Shipment Header" n:1
Purchaser Code	Salesperson/Purchaser	Code	TableRelation Salesperson/Purchaser n:1
Ship-to Code	Ship-to Address	Code	TableRelation "Ship-to Address".Code WHERE (Customer No.=FIELD(Sell-to Customer No.)) n:1
Shipment Method Code	Shipment Method	Code	TableRelation "Shipment Method" n:1
Tax Area Code	Tax Area	Code	TableRelation "Tax Area" n:1
Transaction Specification	Transaction Specification	Code	TableRelation "Transaction Specification" n:1
Transaction Type	Transaction Type	Code	TableRelation "Transaction Type" n:1
Transport Method	Transport Method	Code	TableRelation "Transport Method" n:1
Assigned User ID	User Setup	User ID	TableRelation "User Setup" n:1
VAT Bus. Posting Group	VAT Business Posting Group	Code	TableRelation "VAT Business Posting Group" n:1
Buy-from Vendor No.	Vendor	No.	TableRelation Vendor n:1
Pay-to Vendor No.	Vendor	No.	TableRelation Vendor n:1
Vendor Posting Group	Vendor Posting Group	Code	TableRelation "Vendor Posting Group" n:1

Referenced By

From Table	From Field	To Field
Cash Flow Forecast Entry	Source No.	No.	1:1
Cash Flow Worksheet Line	Source No.	No.	1:1
Item Charge Assignment (Purch)	Document No.	No.	1:n
Item Charge Assignment (Purch)	Applies-to Doc. No.	No.	1:1
Overdue Approval Entry	Document No.	No.	1:n
Purch. Cr. Memo Line	Blanket Order No.	No.	1:1
Purch. Inv. Line	Blanket Order No.	No.	1:1
Purch. Rcpt. Line	Blanket Order No.	No.	1:1
Purchase Header Archive	Purchase Quote No.	No.	1:1
Purchase Line	Document No.	No.	1:n
Purchase Line	Blanket Order No.	No.	1:1
Purchase Line Archive	Blanket Order No.	No.	1:1
Requisition Line	Ref. Order No.	No.	1:1
Sales Line	Purchase Order No.	No.	1:1
Sales Line	Special Order Purchase No.	No.	1:1
Sales Line Archive	Purchase Order No.	No.	1:1
Sales Line Archive	Special Order Purchase No.	No.	1:1
Warehouse Request	Source No.	No.	1:1