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

Table Relations To Other Tables

Field Related Table Related Field
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
G/L Account No. (G/L Account No.) 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
Job No. (Job No.) Job No. (No.) 1..n
Job Task No. (Job Task No.) Job Task Job No. (Job No.) 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