Diagrams


Table

Order Address

DynamicsDocs.comOrder Address«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 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 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 246»Requisition LineWorksheet Template Name [PK]Journal Batch Name [PK]Line No. [PK]Type; [,G/L Account,Item]No.DescriptionDescription 2QuantityVendor No.Direct Unit CostDue DateRequester IDConfirmedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyOrder DateVendor Item No.Sales Order No.Sales Order Line No.Sell-to Customer No.Ship-to CodeOrder Address CodeCurrency CodeCurrency FactorReserved QuantityDimension Set IDProd. Order No....«Table 254»VAT EntryEntry No. [PK]Gen. Bus. Posting GroupGen. Prod. Posting GroupPosting DateDocument No.Document Type; [,Payment,Invoice,Credi...Type; [,Purchase,Sale,Settlement]BaseAmountVAT Calculation Type; [Normal VAT,Reve...Bill-to/Pay-to No.EU 3-Party TradeUser IDSource CodeReason CodeClosed by Entry No.ClosedCountry/Region CodeInternal Ref. No.Transaction No.Unrealized AmountUnrealized BaseRemaining Unrealized AmountRemaining Unrealized BaseExternal Document No.No. SeriesTax Area CodeTax LiableTax Group CodeUse TaxTax Jurisdiction Code...«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 5109»Purchase Header ArchiveDocument 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 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 751»Standard General Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Account Type; [G/L Account,Customer,Ve...Account No.Document Type; [,Payment,Invoice,Credi...DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Payment Discount %Job No.QuantityVAT AmountPayment Terms Code...«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«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 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT SchemeLast Modified Date TimeId<Vendor No.><Country/Region Code><Order Address Code><Order Address Code><Order Address Code><Order Address Code><Ship-to/Order Address Code><Order Address Code><Order Address Code><Order Address Code><Ship-to/Order Address Code><Ship-to/Order Address Code><Buy-from Vendor No.><Pay-to Vendor No.><VAT Country/Region Code><Pay-to Country/Region Code><Buy-from Country/Region Code><Ship-to Country/Region Code><Last Receiving No.><Last Receiving No.><Buy-from Vendor No.><Pay-to Vendor No.><VAT Country/Region Code><Pay-to Country/Region Code><Buy-from Country/Region Code><Ship-to Country/Region Code><Last Posting No.><Last Prepayment No.><Last Posting No.><Buy-from Vendor No.><Pay-to Vendor No.><VAT Country/Region Code><Pay-to Country/Region Code><Buy-from Country/Region Code><Ship-to Country/Region Code><Last Prepmt. Cr. Memo No.><Supply From><Bill-to/Pay-to No.><Closed by Entry No.><Unrealized VAT Entry No.><Reversed by Entry No.><Reversed Entry No.><Country/Region Code><Buy-from Vendor No.><Pay-to Vendor No.><VAT Country/Region Code><Pay-to Country/Region Code><Buy-from Country/Region Code><Ship-to Country/Region Code><Last Return Shipment No.><Buy-from Vendor No.><Pay-to Vendor No.><VAT Country/Region Code><Pay-to Country/Region Code><Buy-from Country/Region Code><Ship-to Country/Region Code><Last Return Shipment No.><Buy-from Vendor No.><Pay-to Vendor No.><VAT Country/Region Code><Pay-to Country/Region Code><Buy-from Country/Region Code><Ship-to Country/Region Code><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Country/Region Code><Country/Region Code><Pay-to Vendor No.>

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

Fields

# Name Type
1 Vendor No. Code20 NotBlank: Yes
2 Code Code10 NotBlank: Yes
3 Name Text50
4 Name 2 Text50
5 Address Text50
6 Address 2 Text50
7 City Text30
8 Contact Text50
9 Phone No. Text30 [Phone No.]
10 Telex No. Text30
35 Country/Region Code Code10
54 Last Date Modified Date Editable: No
84 Fax No. Text30
85 Telex Answer Back Text20
91 Post Code Code20
92 County Text30
102 E-Mail Text80 [E-Mail]
103 Home Page Text80 [URL]

Keys

# Fields
0 Vendor No.,Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code Country/Region Code 1..n
Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Gen. Journal Line Ship-to/Order Address Code 1..n
Purch. Cr. Memo Hdr. Order Address Code 1..n
Purch. Inv. Header Order Address Code 1..n
Purch. Rcpt. Header Order Address Code 1..n
Purchase Header Order Address Code 1..n
Purchase Header Archive Order Address Code 1..n
Requisition Line Order Address Code 1..n
Return Shipment Header Order Address Code 1..n
Standard General Journal Line Ship-to/Order Address Code 1..n
VAT Entry Ship-to/Order Address Code 1..n