Diagrams


Table

Invoice Post. Buffer

DynamicsDocs.comInvoice Post. Buffer«Table 49»Invoice Post. BufferType; [Prepmt. Exch. Rate Difference,G...G/L Account [PK]Global Dimension 1 CodeGlobal Dimension 2 CodeJob No. [PK]AmountVAT AmountGen. Bus. Posting Group [PK]Gen. Prod. Posting Group [PK]VAT Calculation Type; [Normal VAT,Reve...VAT Base AmountSystem-Created EntryTax Area Code [PK]Tax Liable [PK]Tax Group Code [PK]QuantityUse Tax [PK]VAT Bus. Posting Group [PK]VAT Prod. Posting Group [PK]Amount [ACY]VAT Amount [ACY]VAT Base Amount [ACY]VAT DifferenceVAT %Dimension Set ID [PK]Deferral Code [PK]Deferral Line No.FA Posting DateFA Posting Type; [,Acquisition Cost,Ma...Depreciation Book CodeSalvage Value...«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 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value IDIdLast Modified Date Time«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 318»Tax AreaCode [PK,NN]DescriptionLast Modified Date TimeId«Table 321»Tax GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«Table 1700»Deferral TemplateDeferral Code [PK,NN]DescriptionDeferral Account [NN]Deferral %Calc. Method; [Straight-Line,Equal per...Start Date; [Posting Date,Beginning of...No. of PeriodsPeriod Description«Table 5611»Depreciation BookCode [PK,NN]DescriptionG/L Integration - Acq. CostG/L Integration - DepreciationG/L Integration - Write-DownG/L Integration - AppreciationG/L Integration - Custom 1G/L Integration - Custom 2G/L Integration - DisposalG/L Integration - MaintenanceDisposal Calculation Method; [Net,Gros...Use Custom 1 DepreciationAllow Depr. below ZeroUse FA Exch. Rate in Duplic.Part of Duplication ListLast Date ModifiedAllow IndexationUse Same FA+G/L Posting DatesDefault Exchange RateUse FA Ledger CheckUse Rounding in Periodic Depr.New Fiscal Year Starting DateNo. of Days in Fiscal YearAllow Changes in Depr. FieldsDefault Final Rounding AmountDefault Ending Book ValuePeriodic Depr. Date Calc.; [Last Entry...Mark Errors as CorrectionsAdd-Curr Exch Rate - Acq. CostAdd.-Curr. Exch. Rate - Depr.Add-Curr Exch Rate -Write-Down...«Table 5626»MaintenanceCode [PK,NN]Description«Table 5628»InsuranceNo. [PK]Effective DateExpiration DatePolicy No.Annual PremiumPolicy CoverageTotal Value InsuredCommentInsurance TypeLast Date ModifiedInsurance Vendor No.FA Class CodeFA Subclass CodeFA Location CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeBlockedDescriptionSearch DescriptionDate FilterNo. Series«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...<G/L Account><Global Dimension 1 Code><Global Dimension 2 Code><Job No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Dimension Set ID><Deferral Code><Depreciation Book Code><Duplicate in Depreciation Book><Maintenance Code><Insurance No.><Budgeted FA No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Default Deferral Template Code><Deferral Account><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><Component of Main Asset>

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

Fields

# Name Type
1 Type Option
2 G/L Account Code20
4 Global Dimension 1 Code Code20
5 Global Dimension 2 Code Code20
6 Job No. Code20
7 Amount Decimal
8 VAT Amount Decimal
10 Gen. Bus. Posting Group Code20
11 Gen. Prod. Posting Group Code20
12 VAT Calculation Type Option
14 VAT Base Amount Decimal
17 System-Created Entry Boolean
18 Tax Area Code Code20
19 Tax Liable Boolean
20 Tax Group Code Code20
21 Quantity Decimal (1:5)
22 Use Tax Boolean
23 VAT Bus. Posting Group Code20
24 VAT Prod. Posting Group Code20
25 Amount (ACY) Decimal
26 VAT Amount (ACY) Decimal
29 VAT Base Amount (ACY) Decimal
31 VAT Difference Decimal
32 VAT % Decimal (1:1)
480 Dimension Set ID Integer Editable: No
1700 Deferral Code Code10
1701 Deferral Line No. Integer
5600 FA Posting Date Date
5601 FA Posting Type Option
5602 Depreciation Book Code Code10
5603 Salvage Value Decimal
5605 Depr. until FA Posting Date Boolean
5606 Depr. Acquisition Cost Boolean
5609 Maintenance Code Code10
5610 Insurance No. Code20
5611 Budgeted FA No. Code20
5612 Duplicate in Depreciation Book Code10
5613 Use Duplication List Boolean
5614 Fixed Asset Line No. Integer

Keys

# Fields
0 Type,G/L Account,Gen. Bus. Posting Group,Gen. Prod. Posting Group,VAT Bus. Posting Group,VAT Prod. Posting Group,Tax Area Code,Tax Group Code,Tax Liable,Use Tax,Dimension Set ID,Job No.,Fixed Asset Line No.,Deferral Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Deferral Code Deferral Template Deferral Code 1..n
Duplicate in Depreciation Book Depreciation Book Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Budgeted FA No. Fixed Asset No. 1..n
G/L Account G/L Account No. 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Insurance No. Insurance No. 1..n
Job No. Job No. 1..n
Maintenance Code Maintenance Code 1..n
Tax Area Code Tax Area Code 1..n
Tax Group Code Tax Group Code 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field