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

Table Relations From Other Tables

From Table From Field