Table 751 Standard General Journal Line

Base Application, Microsoft.Finance.GeneralLedger.Journal

76 fields

IdNameTypeVersions
1Journal Template NameCode[10]17-29
2Line No.Integer17-29
3Account TypeEnum "Gen. Journal Account Type"17-29
4Account No.Code[20]17-29
6Document TypeEnum "Gen. Journal Document Type"17-29
8DescriptionText[100]17-29
10VAT %Decimal17-29
11Bal. Account No.Code[20]17-29
12Currency CodeCode[10]17-29
13AmountDecimal17-29
14Debit AmountDecimal17-29
15Credit AmountDecimal17-29
16Amount (LCY)Decimal17-29
17Balance (LCY)Decimal17-29
18Currency FactorDecimal17-29
19Sales/Purch. (LCY)Decimal17-29
20Profit (LCY)Decimal17-29
21Inv. Discount (LCY)Decimal17-29
22Bill-to/Pay-to No.Code[20]17-29
23Posting GroupCode[20]17-29
24Shortcut Dimension 1 CodeCode[20]17-29
25Shortcut Dimension 2 CodeCode[20]17-29
26Salespers./Purch. CodeCode[20]17-29
29Source CodeCode[10]17-29
34On HoldCode[3]17-29
35Applies-to Doc. TypeEnum "Gen. Journal Document Type"17-29
40Payment Discount %Decimal17-29
42Job No.Code[20]17-29
43QuantityDecimal17-29
44VAT AmountDecimal17-29
47Payment Terms CodeCode[10]17-29
50Business Unit CodeCode[20]17-29
51Standard Journal CodeCode[10]17-29
52Reason CodeCode[10]17-29
57Gen. Posting TypeEnum "General Posting Type"17-29
58Gen. Bus. Posting GroupCode[20]17-29
59Gen. Prod. Posting GroupCode[20]17-29
60VAT Calculation TypeEnum "Tax Calculation Type"17-29
63Bal. Account TypeEnum "Gen. Journal Account Type"17-29
64Bal. Gen. Posting TypeEnum "General Posting Type"17-29
65Bal. Gen. Bus. Posting GroupCode[20]17-29
66Bal. Gen. Prod. Posting GroupCode[20]17-29
67Bal. VAT Calculation TypeEnum "Tax Calculation Type"17-29
68Bal. VAT %Decimal17-29
69Bal. VAT AmountDecimal17-29
70Bank Payment TypeEnum "Bank Payment Type"17-29
71VAT Base AmountDecimal17-29
72Bal. VAT Base AmountDecimal17-29
73CorrectionBoolean17-29
77External Document No.Code[35]new in 19
78Source TypeOption17-29
79Source No.Code[20]17-29
80Posting No. SeriesCode[20]17-29
82Tax Area CodeCode[20]17-29
83Tax LiableBoolean17-29
84Tax Group CodeCode[20]17-29
85Use TaxBoolean17-29
86Bal. Tax Area CodeCode[20]17-29
87Bal. Tax LiableBoolean17-29
88Bal. Tax Group CodeCode[20]17-29
89Bal. Use TaxBoolean17-29
90VAT Bus. Posting GroupCode[20]17-29
91VAT Prod. Posting GroupCode[20]17-29
92Bal. VAT Bus. Posting GroupCode[20]17-29
93Bal. VAT Prod. Posting GroupCode[20]17-29
110Ship-to/Order Address CodeCode[10]17-29
111VAT DifferenceDecimal17-29
112Bal. VAT DifferenceDecimal17-29
113IC Partner CodeCode[20]17-29
116IC Partner G/L Acc. No.Code[20]17-29
Removed, tag 25.0, obsolete since 22: Replaced by IC Account No.
118Sell-to/Buy-from No.Code[20]17-29
130IC Account TypeEnum "IC Journal Account Type"new in 22
131IC Account No.Code[20]new in 22
480Dimension Set IDInteger17-29
5050Campaign No.Code[20]17-29
5616Index EntryBoolean17-29