Diagrams


Table

Prepayment Inv. Line Buffer

DynamicsDocs.comPrepayment Inv. Line Buffer«Table 461»Prepayment Inv. Line BufferG/L Account No. [PK]Line No. [PK]AmountDescriptionGen. Bus. Posting GroupGen. Prod. Posting GroupVAT Bus. Posting GroupVAT Prod. Posting GroupVAT AmountVAT Calculation Type; [Normal VAT,Reve...VAT Base AmountAmount [ACY]VAT Amount [ACY]VAT Base Amount [ACY]VAT DifferenceVAT %VAT IdentifierGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob No. [PK]Amount Incl. VATTax Area Code [PK]Tax Liable [PK]Tax Group Code [PK]Invoice Rounding [PK]Adjustment [PK]Dimension Set ID [PK]Job Task No.«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 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 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«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 318»Tax AreaCode [PK,NN]Description«Table 321»Tax 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 1001»Job TaskJob No. [PK,NN]Job Task No. [PK,NN]DescriptionJob Task Type; [Posting,Heading,Total,...WIP-Total; [,Total,Excluded]Job Posting GroupWIP MethodSchedule [Total Cost]Schedule [Total Price]Usage [Total Cost]Usage [Total Price]Contract [Total Cost]Contract [Total Price]Contract [Invoiced Price]Contract [Invoiced Cost]Posting Date FilterPlanning Date FilterTotalingNew PageNo. of Blank LinesIndentationRecognized Sales AmountRecognized Costs AmountRecognized Sales G/L AmountRecognized Costs G/L AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeOutstanding OrdersAmt. Rcd. Not InvoicedRemaining [Total Cost]Remaining [Total Price]...<G/L Account No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><VAT Bus. Posting Group><VAT Prod. Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Job No.><Tax Area Code><Tax Group Code><Dimension Set ID><Job Task 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><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Value Code><Job No.>

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

Fields

# Name Type
1 G/L Account No. Code20
2 Line No. Integer
3 Amount Decimal
4 Description Text50
5 Gen. Bus. Posting Group Code10
6 Gen. Prod. Posting Group Code10
7 VAT Bus. Posting Group Code10
8 VAT Prod. Posting Group Code10
9 VAT Amount Decimal
10 VAT Calculation Type Option
11 VAT Base Amount Decimal
12 Amount (ACY) Decimal
13 VAT Amount (ACY) Decimal
14 VAT Base Amount (ACY) Decimal
15 VAT Difference Decimal
16 VAT % Decimal (1:1)
17 VAT Identifier Code10 Editable: No
19 Global Dimension 1 Code Code20
20 Global Dimension 2 Code Code20
21 Job No. Code20
22 Amount Incl. VAT Decimal
24 Tax Area Code Code20
25 Tax Liable Boolean
26 Tax Group Code Code10
27 Invoice Rounding Boolean
28 Adjustment Boolean
480 Dimension Set ID Integer Editable: No
1001 Job Task No. Code20

Keys

# Fields
0 G/L Account No.,Job No.,Tax Area Code,Tax Liable,Tax Group Code,Invoice Rounding,Adjustment,Line No.,Dimension Set ID Clustered: Yes
1 Adjustment

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
G/L Account No. 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
Job No. Job No. 1..n
Job Task No. Job Task Job No. 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