Diagrams


Table

Tax Area

DynamicsDocs.comTax Area«Table 318»Tax AreaCode [PK,NN]DescriptionLast Modified Date TimeId«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 Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«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 221»Gen. Jnl. AllocationJournal Template Name [PK]Journal Batch Name [PK]Journal Line No. [PK]Line No. [PK]Account No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeAllocation QuantityAllocation %AmountGen. Posting Type; [,Purchase,Sale]Gen. Bus. Posting GroupGen. Prod. Posting GroupVAT Calculation Type; [Normal VAT,Reve...VAT AmountVAT %Account NameTax Area CodeTax LiableTax Group CodeUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupAdditional-Currency AmountDimension Set ID«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 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 316»Tax Area TranslationTax Area Code [PK,NN]Language Code [PK]Description«Table 376»G/L Account (Analysis View)No. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Account Source; [G/L Account,Cash Flow...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 ModifiedCash Flow Forecast FilterDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudgeted at DateConsol. Debit Acc.Consol. Credit Acc....<Tax Area Code><Tax Area Code><Tax Area Code><Tax Area Code><Tax Area Code><Tax Area Code><Tax Area Code><Account No.><No.><Bill-to Customer No.><Ship-to Filter><Customer No.><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 Code Code20 NotBlank: Yes
2 Description Text50
10 Last Modified Date Time DateTime Editable: No
8000 Id GUID

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Customer Tax Area Code 1..n
Deferral Post. Buffer Tax Area Code 1..n
Detailed CV Ledg. Entry Buffer Tax Area Code 1..n
FA Ledger Entry Tax Area Code 1..n
Finance Charge Memo Header Tax Area Code 1..n
G/L Account Tax Area Code 1..n
G/L Account (Analysis View) Tax Area Code 1..n
G/L Entry Tax Area Code 1..n
Gen. Jnl. Allocation Tax Area Code 1..n
Gen. Journal Line Bal. Tax Area Code 1..n
Invoice Post. Buffer Tax Area Code 1..n
Issued Fin. Charge Memo Header Tax Area Code 1..n
Issued Reminder Header Tax Area Code 1..n
Maintenance Ledger Entry Tax Area Code 1..n
Prepayment Inv. Line Buffer Tax Area Code 1..n
Purch. Cr. Memo Hdr. Tax Area Code 1..n
Purch. Cr. Memo Line Tax Area Code 1..n
Purch. Inv. Header Tax Area Code 1..n
Purch. Inv. Line Tax Area Code 1..n
Purch. Rcpt. Header Tax Area Code 1..n
Purch. Rcpt. Line Tax Area Code 1..n
Purchase Header Tax Area Code 1..n
Purchase Header Archive Tax Area Code 1..n
Purchase Line Prepayment Tax Area Code 1..n
Purchase Line Archive Prepayment Tax Area Code 1..n
Reminder Header Tax Area Code 1..n
Return Receipt Header Tax Area Code 1..n
Return Receipt Line Tax Area Code 1..n
Return Shipment Header Tax Area Code 1..n
Return Shipment Line Tax Area Code 1..n
Sales Cr.Memo Header Tax Area Code 1..n
Sales Cr.Memo Line Tax Area Code 1..n
Sales Header Archive Tax Area Code 1..n
Sales Invoice Header Tax Area Code 1..n
Sales Invoice Line Tax Area Code 1..n
Sales Line Prepayment Tax Area Code 1..n
Sales Line Archive Prepayment Tax Area Code 1..n
Sales Shipment Header Tax Area Code 1..n
Sales Shipment Line Tax Area Code 1..n
Service Cr.Memo Header Tax Area Code 1..n
Service Cr.Memo Line Tax Area Code 1..n
Service Header Tax Area Code 1..n
Service Invoice Header Tax Area Code 1..n
Service Invoice Line Tax Area Code 1..n
Service Line Tax Area Code 1..n
Service Shipment Header Tax Area Code 1..n
Service Shipment Line Tax Area Code 1..n
Ship-to Address Tax Area Code 1..n
Standard General Journal Line Bal. Tax Area Code 1..n
Tax Area Line Tax Area 1..n
Tax Area Translation Tax Area Code 1..n
VAT Entry Tax Area Code 1..n
Vendor Tax Area Code 1..n