Diagrams


Table

Sales Header Archive

DynamicsDocs.comSales Header Archive«Table 5107»Sales Header ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 5108»Sales Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupQuantity Disc. CodeShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«Table 10»Shipment MethodCode [PK,NN]Description«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line Account«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 340»Customer Discount GroupCode [PK,NN]Description«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 110»Sales Shipment HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 112»Sales Invoice HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 258»Transaction TypeCode [PK,NN]Description«Table 259»Transport MethodCode [PK,NN]Description«Table 282»Entry/Exit PointCode [PK,NN]Description«Table 285»Transaction SpecificationCode [PK,NN]Text«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Payment Processor; [,Dynamics Online]Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. Type«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 318»Tax AreaCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,E-...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY«Table 827»DO Payment Credit CardNo. [PK]Type [NN]Credit Card NumberExpiry Date [NN]Card Holder Name [NN]Customer No. [NN]Contact No. [NN]Cvc No.No. Series«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 5071»CampaignNo. [PK]DescriptionStarting DateEnding DateSalesperson CodeCommentLast Date ModifiedNo. SeriesGlobal Dimension 1 CodeGlobal Dimension 2 CodeStatus CodeTarget Contacts ContactedContacts RespondedDuration [Min.]Cost [LCY]No. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterContact FilterContact Company FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P...To-do Closed Filter...«Table 5105»Customer TemplateCode [PK,NN]DescriptionTerritory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeCustomer Posting GroupCurrency CodeCustomer Price GroupPayment Terms CodeShipment Method CodeInvoice Disc. CodeCustomer Disc. GroupCountry/Region CodePayment Method CodeGen. Bus. Posting GroupVAT Bus. Posting GroupAllow Line Disc.«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesType; [Company,Person]Company No.Company NameLookup Contact No.First NameMiddle Name...«Table 5092»OpportunityNo. [PK]DescriptionSalesperson CodeCampaign No.Contact No.Contact Company No.Sales Cycle CodeSales Document No.Creation DateStatus; [Not Started,In Progress,Won,L...Priority; [Low,Normal,High]ClosedDate ClosedNo. SeriesCommentCurrent Sales Cycle StageEstimated Value [LCY]Probability %Calcd. Current Value [LCY]Chances of Success %Completed %Contact NameContact Company NameSalesperson NameCampaign DescriptionSegment No.Estimated Closing DateSales Document Type; [,Quote,Order,Pos...No. of InteractionsWizard Step; [,1,2,3,4,5,6]Activate First Stage...«Table 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 6660»Return Receipt HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorTime Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<Sell-to Customer No.><Bill-to Customer No.><Ship-to Code><Payment Terms Code><Prepmt. Payment Terms Code><Shipment Method Code><Location Code><Location Filter><Customer Posting Group><Price Group Code><Cust./Item Disc. Gr.><Bal. Account No.><Bal. Account No.><Last Shipping No.><Last Posting No.><Last Prepayment No.><Last Prepmt. Cr. Memo No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Shipping Agent Code><Tax Area Code><VAT Bus. Posting Group><Sell-to IC Partner Code><Bill-to IC Partner Code><Credit Card No.><Archived By><Campaign No.><Sell-to Customer Template Code><Sell-to Contact No.><Bill-to Contact No.><Opportunity No.><Responsibility Center><Shipping Agent Service Code><Last Return Receipt No.><Assigned User ID><Document No.><Sell-to Customer No.><Bill-to Customer No.><No.><Location Code><Price Group Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><Tax Area Code><Prepayment Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Responsibility Center><Shipping Agent Code><Shipping Agent Service Code><Customer Disc. Group><Customer Posting Group><Customer Price Group><Payment Terms Code><Cash Flow Payment Terms Code><Shipment Method Code><Shipping Agent Code><Customer Disc. Group><Bill-to Customer No.><Payment Method Code><Location Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Customer No.><Primary Contact No.><Responsibility Center><Shipping Agent Service Code><Ship-to Filter><Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Customer No.><Shipment Method Code><Shipping Agent Code><Location Code><Tax Area Code><Shipping Agent Service Code><Ship-to Code><Ship-to Code><Ship-to Code><Payment Terms Code><Payment Terms Code><Direct Debit Pmt. Terms Code><Payment Terms Code><Payment Terms Code><Shipment Method Code><Shipment Method Code><Shipment Method Code><Shipment Method Code><Location Code><Location Code><Location Code><Location Code><Receivables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding Account><Additional Fee Account><Interest Account><Debit Curr. Appln. Rndg. Acc.><Credit Curr. Appln. Rndg. Acc.><Debit Rounding Account><Credit Rounding Account><Payment Disc. Credit Acc.><Payment Tolerance Debit Acc.><Payment Tolerance Credit Acc.><Add. Fee per Line Account><Customer Posting Group><Customer Posting Group><Customer Posting Group><Customer Posting Group><VAT Bus. Posting Gr. (Price)><Customer Price Group><Customer Price Group><Customer Price Group><Customer Price Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><Bal. Account No.><Bal. Account No.><Bal. Account No.><Receivables Account><Payables Account><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Shipping Agent Code><User ID><Tax Area Code><VAT Bus. Posting Group><Campaign No.><Sell-to Contact No.><Bill-to Contact No.><Responsibility Center><Shipping Agent Service Code><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Shipping Agent Code><User ID><Tax Area Code><VAT Bus. Posting Group><Credit Card No.><Campaign No.><Sell-to Contact No.><Bill-to Contact No.><Responsibility Center><Sales Document No.><Reason Code><Def. VAT Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Payment Method Code><Shipping Agent Code><Shipping Agent Code><Tax Area Code><VAT Bus. Posting Group><VAT Bus. Posting Group><User ID><Contact Filter><Contact Company Filter><Campaign Filter><Campaign No.><Campaign No.><Company No.><Lookup Contact No.><Contact No.><Contact Company No.><Sell-to Contact No.><Bill-to Contact No.><Responsibility Center><Sales Resp. Ctr. Filter><Purchase Resp. Ctr. Filter><Service Resp. Ctr. Filter><Approver ID><Substitute>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Document Type Option
2 Sell-to Customer No. Code20
3 No. Code20
4 Bill-to Customer No. Code20 NotBlank: Yes
5 Bill-to Name Text50
6 Bill-to Name 2 Text50
7 Bill-to Address Text50
8 Bill-to Address 2 Text50
9 Bill-to City Text30
10 Bill-to Contact Text50
11 Your Reference Text35
12 Ship-to Code Code10
13 Ship-to Name Text50
14 Ship-to Name 2 Text50
15 Ship-to Address Text50
16 Ship-to Address 2 Text50
17 Ship-to City Text30
18 Ship-to Contact Text50
19 Order Date Date
20 Posting Date Date
21 Shipment Date Date
22 Posting Description Text50
23 Payment Terms Code Code10
24 Due Date Date
25 Payment Discount % Decimal (0:5)
26 Pmt. Discount Date Date
27 Shipment Method Code Code10
28 Location Code Code10
29 Shortcut Dimension 1 Code Code20
30 Shortcut Dimension 2 Code Code20
31 Customer Posting Group Code10
32 Currency Code Code10
33 Currency Factor Decimal (0:15)
34 Price Group Code Code10
35 Prices Including VAT Boolean
37 Invoice Disc. Code Code20
40 Cust./Item Disc. Gr. Code20
41 Language Code Code10
43 Salesperson Code Code10
45 Order Class Code10
46 Comment Boolean Editable: No
FlowField
47 No. Printed Integer
51 On Hold Code3
52 Applies-to Doc. Type Option
53 Applies-to Doc. No. Code20
55 Bal. Account No. Code20
57 Ship Boolean
58 Invoice Boolean
60 Amount Decimal Editable: No
FlowField
61 Amount Including VAT Decimal Editable: No
FlowField
62 Shipping No. Code20
63 Posting No. Code20
64 Last Shipping No. Code20
65 Last Posting No. Code20
66 Prepayment No. Code20
67 Last Prepayment No. Code20
68 Prepmt. Cr. Memo No. Code20
69 Last Prepmt. Cr. Memo No. Code20
70 VAT Registration No. Text20
71 Combine Shipments Boolean
73 Reason Code Code10
74 Gen. Bus. Posting Group Code10
75 EU 3-Party Trade Boolean
76 Transaction Type Code10
77 Transport Method Code10
78 VAT Country/Region Code Code10
79 Sell-to Customer Name Text50
80 Sell-to Customer Name 2 Text50
81 Sell-to Address Text50
82 Sell-to Address 2 Text50
83 Sell-to City Text30
84 Sell-to Contact Text50
85 Bill-to Post Code Code20
86 Bill-to County Text30
87 Bill-to Country/Region Code Code10
88 Sell-to Post Code Code20
89 Sell-to County Text30
90 Sell-to Country/Region Code Code10
91 Ship-to Post Code Code20
92 Ship-to County Text30
93 Ship-to Country/Region Code Code10
94 Bal. Account Type Option
97 Exit Point Code10
98 Correction Boolean
99 Document Date Date
100 External Document No. Code35
101 Area Code10
102 Transaction Specification Code10
104 Payment Method Code Code10
105 Shipping Agent Code Code10
106 Package Tracking No. Text30
107 No. Series Code10
108 Posting No. Series Code10
109 Shipping No. Series Code10
114 Tax Area Code Code20
115 Tax Liable Boolean
116 VAT Bus. Posting Group Code10
117 Reserve Option
118 Applies-to ID Code50
119 VAT Base Discount % Decimal (0:5)
120 Status Option
121 Invoice Discount Calculation Option
122 Invoice Discount Value Decimal
123 Send IC Document Boolean
124 IC Status Option
125 Sell-to IC Partner Code Code20 Editable: No
126 Bill-to IC Partner Code Code20 Editable: No
129 IC Direction Option
130 Prepayment % Decimal (0:5)
131 Prepayment No. Series Code10
132 Compress Prepayment Boolean
133 Prepayment Due Date Date
134 Prepmt. Cr. Memo No. Series Code10
135 Prepmt. Posting Description Text50
138 Prepmt. Pmt. Discount Date Date
139 Prepmt. Payment Terms Code Code10
140 Prepmt. Payment Discount % Decimal (0:5)
145 No. of Archived Versions Integer Editable: No
FlowField
151 Sales Quote No. Code20 Editable: No
480 Dimension Set ID Integer Editable: No
827 Credit Card No. Code20
5043 Interaction Exist Boolean
5044 Time Archived Time
5045 Date Archived Date
5046 Archived By Code50 Editable: No
5047 Version No. Integer
5048 Doc. No. Occurrence Integer
5050 Campaign No. Code20
5051 Sell-to Customer Template Code Code10
5052 Sell-to Contact No. Code20
5053 Bill-to Contact No. Code20
5054 Bill-to Customer Template Code Code10
5055 Opportunity No. Code20
5700 Responsibility Center Code10
5750 Shipping Advice Option
5752 Completely Shipped Boolean Editable: No
FlowField
5753 Posting from Whse. Ref. Integer
5754 Location Filter Code10 FlowFilter
5790 Requested Delivery Date Date
5791 Promised Delivery Date Date
5792 Shipping Time DateFormula
5793 Outbound Whse. Handling Time DateFormula
5794 Shipping Agent Service Code Code10
5795 Late Order Shipping Boolean Editable: No
FlowField
5796 Date Filter Date FlowFilter
5800 Receive Boolean
5801 Return Receipt No. Code20
5802 Return Receipt No. Series Code10
5803 Last Return Receipt No. Code20
7001 Allow Line Disc. Boolean
7200 Get Shipment Used Boolean Editable: No
9000 Assigned User ID Code50

Keys

# Fields
0 Document Type,No.,Doc. No. Occurrence,Version No. Clustered: Yes
1 Document Type,Sell-to Customer No.
2 Document Type,Bill-to Customer No.

Table Relations To Other Tables

Field Related Table Related Field
Area Area Code 1..n
Bal. Account No. Bank Account No. 1..n
Campaign No. Campaign No. 1..n
Bill-to Contact No. Contact No. 1..n
Ship-to Country/Region Code Country/Region Code 1..n
Currency Code Currency Code 1..n
Bill-to Customer No. Customer No. 1..n
Cust./Item Disc. Gr. Customer Discount Group Code 1..n
Customer Posting Group Customer Posting Group Code 1..n
Price Group Code Customer Price Group Code 1..n
Sell-to Customer Template Code Customer Template Code 1..n
Credit Card No. DO Payment Credit Card No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Exit Point Entry/Exit Point Code 1..n
Bal. Account No. G/L Account No. 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Bill-to IC Partner Code IC Partner Code 1..n
Language Code Language Code 1..n
Location Filter Location Code 1..n
Return Receipt No. Series No. Series Code 1..n
Opportunity No. Opportunity No. 1..n
Payment Method Code Payment Method Code 1..n
Prepmt. Payment Terms Code Payment Terms Code 1..n
Reason Code Reason Code Code 1..n
Responsibility Center Responsibility Center Code 1..n
Last Return Receipt No. Return Receipt Header No. 1..n
Last Prepmt. Cr. Memo No. Sales Invoice Header No. 1..n
Last Shipping No. Sales Shipment Header No. 1..n
Salesperson Code Salesperson/Purchaser Code 1..n
Ship-to Code Ship-to Address Code 1..n
Shipment Method Code Shipment Method Code 1..n
Shipping Agent Code Shipping Agent Code 1..n
Shipping Agent Service Code Shipping Agent Services Code 1..n
Tax Area Code Tax Area Code 1..n
Transaction Specification Transaction Specification Code 1..n
Transaction Type Transaction Type Code 1..n
Transport Method Transport Method Code 1..n
Archived By User User Name 1..n
Assigned User ID User Setup User ID 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Sales Line Archive Document No. 1..n