Diagrams


Table

Purchase Header

DynamicsDocs.comPurchase Header«Table 38»Purchase HeaderDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting Group...«Table 121»Purch. Rcpt. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Qty. Rcd. Not InvoicedQuantity InvoicedOrder No....«Table 123»Purch. Inv. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Receipt No....«Table 125»Purch. Cr. Memo LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Pay-to Vendor No....«Table 37»Sales LineDocument 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 GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«Table 39»Purchase LineDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 Code...«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 5110»Purchase Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 5765»Warehouse RequestSource Type [PK]Source Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No. [PK]Source Document; [,Sales Order,,,Sales...Document Status; [Open,Released]Location Code [PK]Shipment Method CodeShipping Agent CodeShipping Advice; [Partial,Complete]Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment DateType; [Inbound,Outbound] [PK]Put-away / Pick No.Completely Handled«Table 5805»Item Charge Assignment (Purch)Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Document Line No. [PK]Line No. [PK]Item Charge No. [NN]Item No.DescriptionQty. to AssignQty. AssignedUnit CostAmount to AssignApplies-to Doc. Type; [Quote,Order,Inv...Applies-to Doc. No.Applies-to Doc. Line No.Applies-to Doc. Line Amount«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«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 93»Vendor Posting GroupCode [PK,NN]Payables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding 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.«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/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....«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 120»Purch. Rcpt. HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency Code...«Table 122»Purch. Inv. HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency Code...«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 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 224»Order AddressVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Country/Region CodeLast Date ModifiedFax No.Telex Answer BackPost CodeCountyE-MailHome Page«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.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. Type«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,Em...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY«Table 124»Purch. Cr. Memo Hdr.Buy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency CodeCurrency Factor...«Table 130»Incoming DocumentEntry No. [PK]DescriptionCreated Date-TimeCreated By User IDCreated By User NameReleasedReleased Date-TimeReleased By User IDReleased By User NameLast Date-Time ModifiedLast Modified By User IDLast Modified By User NamePostedPosted Date-TimeDocument Type; [Journal,Sales Invoice,...Document No.Posting DateStatus; [New,Released,Rejected,Posted,...URL1URL2URL3URL4Vendor NameVendor VAT Registration No.Vendor IBANDocument DateVendor Bank Branch No.Vendor Bank Account No.Vendor No.Data Exchange TypeOCR Data Corrected...«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 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. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...«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 6650»Return Shipment HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency CodeCurrency Factor...«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 AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<Buy-from Vendor No.><Pay-to Vendor No.><Ship-to Code><Payment Terms Code><Prepmt. Payment Terms Code><Shipment Method Code><Location Code><Location Filter><Vendor Posting Group><Bal. Account No.><Bal. Account No.><Last Receiving No.><Last Posting No.><Last Prepayment No.><Sell-to Customer No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Order Address Code><Entry Point><Transaction Specification><Payment Method Code><Tax Area Code><VAT Bus. Posting Group><Buy-from IC Partner Code><Pay-to IC Partner Code><Last Prepmt. Cr. Memo No.><Incoming Document Entry No.><Campaign No.><Buy-from Contact No.><Pay-to Contact No.><Responsibility Center><Last Return Shipment No.><Assigned User ID><Blanket Order No.><Blanket Order No.><Blanket Order No.><Purchase Order No.><Special Order Purchase No.><Document No.><Blanket Order No.><Purchase Order No.><Special Order Purchase No.><Blanket Order No.><Source No.><Document No.><Applies-to Doc. No.><Buy-from Vendor No.><Pay-to Vendor No.><Document No.><No.><Location Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Entry Point><Transaction Specification><Tax Area Code><VAT Bus. Posting Group><Blanket Order Line No.><Responsibility Center><Applies-to Doc. Line No.><Buy-from Vendor No.><Pay-to Vendor No.><Document No.><No.><Location Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Entry Point><Transaction Specification><Tax Area Code><VAT Bus. Posting Group><Blanket Order Line No.><IC Partner Code><Responsibility Center><Buy-from Vendor No.><Pay-to Vendor No.><Document No.><No.><Location Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Entry Point><Transaction Specification><Tax Area Code><VAT Bus. Posting Group><Blanket Order Line No.><IC Partner Code><Responsibility Center><Sell-to Customer No.><Bill-to Customer No.><Location Code><Purch. Order Line No.><Special Order Purch. Line No.><Sales Order Line No.><Special Order Sales Line No.><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Blanket Order Line No.><Exit Point><Transaction Specification><Tax Area Code><Prepayment Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Responsibility Center><Blanket Order Line No.><Sales Order Line No.><Special Order Sales Line No.><Buy-from Vendor No.><Pay-to Vendor No.><Location Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Blanket Order Line No.><Entry Point><Transaction Specification><Tax Area Code><Prepayment Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Responsibility Center><Purch. Order Line No.><Special Order Purch. Line No.><Blanket Order Line No.><Document Line No.><Applies-to Doc. Line No.><Sell-to Customer No.><Bill-to Customer No.><No.><Location 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><Buy-from Vendor No.><Pay-to Vendor No.><No.><Location Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Entry Point><Transaction Specification><Tax Area Code><Prepayment Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Responsibility Center><Location Code><Destination No.><Shipment Method Code><Destination No.><Destination No.><Applies-to Doc. No.><Applies-to Doc. No.><Vendor Posting Group><Payment Terms Code><Cash Flow Payment Terms Code><Shipment Method Code><Pay-to Vendor No.><Payment Method Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Vendor No.><Primary Contact No.><Responsibility Center><Location Code><Buy-from Vendor No.><Pay-to Vendor No.><Buy-from Vendor No.><Pay-to Vendor No.><Buy-from Vendor No.><Pay-to Vendor No.><Vendor No.><Vendor No.><Buy-from Vendor No.><Pay-to Vendor No.><Customer No.><Ship-to Filter><Shipment Method Code><Location Code><Tax Area Code><Ship-to Code><Ship-to Code><Ship-to Code><Ship-to Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Cash Flow Payment Terms Code><Direct Debit Pmt. Terms Code><Payment Terms Code><Shipment Method Code><Shipment Method Code><Shipment Method Code><Shipment Method Code><Shipment Method Code><Location Code><Location Code><Location Code><Location Code><Location Code><Location Code><Payables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding 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.><Vendor Posting Group><Vendor Posting Group><Vendor Posting Group><Vendor Posting Group><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><Bal. Account No.><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.><Bal. Account No.><Sell-to Customer No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Order Address Code><Entry Point><Transaction Specification><Payment Method Code><Tax Area Code><VAT Bus. Posting Group><Campaign No.><Buy-from Contact No.><Pay-to Contact no.><Responsibility Center><Sell-to Customer No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Order Address Code><Entry Point><Transaction Specification><Payment Method Code><Tax Area Code><VAT Bus. Posting Group><Campaign No.><Buy-from Contact No.><Pay-to Contact No.><Responsibility Center><Bill-to Customer No.><Payment Method Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Customer No.><Primary Contact No.><Responsibility Center><Sell-to Customer No.><Sell-to Customer No.><Reason Code><Reason Code><Def. VAT Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Transaction Type><Transaction Type><Transport Method><Transport Method><Order Address Code><Order Address Code><Entry Point><Entry Point><Transaction Specification><Transaction Specification><Payment Method Code><Payment Method Code><Tax Area Code><Tax Area Code><VAT Bus. Posting Group><VAT Bus. Posting Group><Campaign No.><Buy-from Contact No.><Pay-to Contact No.><Responsibility Center><Contact Filter><Contact Company Filter><Campaign Filter><Campaign No.><Company No.><Lookup Contact No.><Buy-from Contact No.><Pay-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 (Document Type) Option
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
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)
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
30 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
31 Vendor Posting Group (Vendor Posting Group) Code10 Editable: No
32 Currency Code (Currency Code) Code10
33 Currency Factor (Currency Factor) Decimal (0:15) Editable: No
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 Editable: No
51 On Hold (On Hold) Code3
52 Applies-to Doc. Type (Applies-to Doc. Type) Option
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 Receive (Receive) Boolean
58 Invoice (Invoice) Boolean
59 Print Posted Documents (Print Posted Documents) Boolean
60 Amount (Amount) Decimal Editable: No
FlowField
61 Amount Including VAT (Amount Including VAT) Decimal Editable: No
FlowField
62 Receiving No. (Receiving No.) Code20
63 Posting No. (Posting No.) Code20
64 Last Receiving No. (Last Receiving No.) Code20 Editable: No
65 Last Posting No. (Last Posting No.) Code20 Editable: No
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
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 Editable: No
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)
120 Status (Status) Option Editable: No
121 Invoice Discount Calculation (Invoice Discount Calculation) Option Editable: No
122 Invoice Discount Value (Invoice Discount Value) Decimal Editable: No
123 Send IC Document (Send IC Document) Boolean
124 IC Status (IC Status) Option
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
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)
135 Prepayment No. Series (Prepayment No. Series) Code10
136 Compress Prepayment (Compress Prepayment) Boolean
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)
151 Quote No. (Quote No.) Code20 Editable: No
160 Job Queue Status (Job Queue Status) Option Editable: No
161 Job Queue Entry ID (Job Queue Entry ID) GUID Editable: No
165 Incoming Document Entry No. (Incoming Document Entry No.) Integer
170 Creditor No. (Creditor No.) Code20 [Numeric:Yes]
171 Payment Reference (Payment Reference) Code50 [Numeric:Yes]
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
1305 Invoice Discount Amount (Invoice Discount Amount) Decimal 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
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
5791 Promised Receipt Date (Promised Receipt Date) Date
5792 Lead Time Calculation (Lead Time Calculation) DateFormula
5793 Inbound Whse. Handling Time (Inbound Whse. Handling Time) DateFormula
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 Editable: No
9000 Assigned User ID (Assigned User ID) Code50
9001 Pending Approvals (Pending Approvals) Integer FlowField

Keys

# Fields
0 Document Type,No. (Document Type,No.) Clustered: Yes
1 No.,Document Type (No.,Document Type)
2 Document Type,Buy-from Vendor No. (Document Type,Buy-from Vendor No.)
3 Document Type,Pay-to Vendor No. (Document Type,Pay-to Vendor No.)
4 Buy-from Vendor No. (Buy-from Vendor No.)
5 Incoming Document Entry No. (Incoming Document Entry No.)
6 Document Date (Document Date)

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
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 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 Prepmt. Cr. Memo No. (Last Prepmt. Cr. Memo No.) Purch. Cr. Memo Hdr. No. (No.) 1..n
Last Prepayment No. (Last Prepayment 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
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
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
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
Cash Flow Forecast Entry Source No. (Source No.) 1..n
Item Charge Assignment (Purch) Applies-to Doc. No. (Applies-to Doc. No.) 1..n
Overdue Approval Entry Document No. (Document No.) 1..n
Purch. Cr. Memo Line Blanket Order No. (Blanket Order No.) 1..n
Purch. Inv. Line Blanket Order No. (Blanket Order No.) 1..n
Purch. Rcpt. Line Blanket Order No. (Blanket Order No.) 1..n
Purchase Line Blanket Order No. (Blanket Order No.) 1..n
Purchase Line Archive Blanket Order No. (Blanket Order No.) 1..n
Sales Line Special Order Purchase No. (Special Order Purchase No.) 1..n
Sales Line Archive Special Order Purchase No. (Special Order Purchase No.) 1..n
Warehouse Request Source No. (Source No.) 1..n