Table 81 Gen. Journal Line

Base Application, Microsoft.Finance.GeneralLedger.Journal

215 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
5Posting DateDate17-29
6Document TypeEnum "Gen. Journal Document Type"17-29
7Document No.Code[20]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
28Pending ApprovalBooleannew in 19
29Source CodeCode[10]17-29
30System-Created EntryBoolean17-29
31Your ReferenceText[35]new in 22
34On HoldCode[3]17-29
35Applies-to Doc. TypeEnum "Gen. Journal Document Type"17-29
36Applies-to Doc. No.Code[20]17-29
38Due DateDate17-29
39Pmt. Discount DateDate17-29
40Payment Discount %Decimal17-29
42Job No.Code[20]17-29
43QuantityDecimal17-29
44VAT AmountDecimal17-29
45VAT PostingOption17-29
47Payment Terms CodeCode[10]17-29
48Applies-to IDCode[50]17-29
50Business Unit CodeCode[20]17-29
51Journal Batch NameCode[10]17-29
52Reason CodeCode[10]17-29
53Recurring MethodEnum "Gen. Journal Recurring Method"17-29
54Expiration DateDate17-29
55Recurring FrequencyDateFormula17-29
56Allocated Amt. (LCY)Decimal17-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
61EU 3-Party TradeBoolean17-29
62Allow ApplicationBoolean17-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
74Print Posted DocumentsBoolean17-29
75Check PrintedBoolean17-29
76Document DateDate17-29
77External Document No.Code[35]17-29
78Source TypeEnum "Gen. Journal Source Type"17-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
95Additional-Currency PostingOption17-29
98FA Add.-Currency FactorDecimal17-29
99Source Currency CodeCode[10]17-29
100Source Currency AmountDecimal17-29
101Source Curr. VAT Base AmountDecimal17-29
102Source Curr. VAT AmountDecimal17-29
103VAT Base Discount %Decimal17-29
104VAT Amount (LCY)Decimal17-29
105VAT Base Amount (LCY)Decimal17-29
106Bal. VAT Amount (LCY)Decimal17-29
107Bal. VAT Base Amount (LCY)Decimal17-29
108Reversing EntryBoolean17-29
109Allow Zero-Amount PostingBoolean17-29
110Ship-to/Order Address CodeCode[10]17-29
111VAT DifferenceDecimal17-29
112Bal. VAT DifferenceDecimal17-29
113IC Partner CodeCode[20]17-29
114IC DirectionEnum "IC Direction Type"17-29changed in 21
116IC Partner G/L Acc. No.Code[20]17-29
Removed, tag 25.0, obsolete since 22.0: Replaced by IC Account No.
117IC Partner Transaction No.Integer17-29
118Sell-to/Buy-from No.Code[20]17-29
119VAT Registration No.Text[20]17-29
120Country/Region CodeCode[10]17-29
121PrepaymentBoolean17-29
122Financial VoidBoolean17-29
123Copy VAT Setup to Jnl. LinesBoolean17-29
125VAT Base Before Pmt. Disc.Decimal17-29
126Orig. Pmt. Disc. PossibleDecimalnew in 20
127Orig. Pmt. Disc. Possible(LCY)Decimalnew in 20
128VAT Reporting DateDatenew in 21
129Zero Src. Curr. AmountBooleannew in 27
130IC Account TypeEnum "IC Journal Account Type"new in 22
131IC Account No.Code[20]new in 22
146Spend Request No.Code[20]new in 29
147Spend Request CloseBooleannew in 29
160Job Queue StatusEnum "Document Job Queue Status"17-29changed in 24
161Job Queue Entry IDGuid17-29
165Incoming Document Entry No.Integer17-29
170Creditor No.Code[20]17-29
171Payment ReferenceCode[50]17-29
172Payment Method CodeCode[10]17-29
173Applies-to Ext. Doc. No.Code[35]17-29
175Invoice Received DateDatenew in 22
180Keep DescriptionBooleannew in 19
288Recipient Bank AccountCode[20]17-29
289Message to RecipientText[140]17-29
290Exported to Payment FileBoolean17-29
291Has Payment Export ErrorBoolean17-29
480Dimension Set IDInteger17-29
1000Remit-to CodeCode[20]new in 21
1001Job Task No.Code[20]17-29
1002Job Unit Price (LCY)Decimal17-29
1003Job Total Price (LCY)Decimal17-29
1004Job QuantityDecimal17-29
1005Job Unit Cost (LCY)Decimal17-29
1006Job Line Discount %Decimal17-29
1007Job Line Disc. Amount (LCY)Decimal17-29
1008Job Unit Of Measure CodeCode[10]17-29
1009Job Line TypeEnum "Job Line Type"17-29changed in 18
1010Job Unit PriceDecimal17-29
1011Job Total PriceDecimal17-29
1012Job Unit CostDecimal17-29
1013Job Total CostDecimal17-29
1014Job Line Discount AmountDecimal17-29
1015Job Line AmountDecimal17-29
1016Job Total Cost (LCY)Decimal17-29
1017Job Line Amount (LCY)Decimal17-29
1018Job Currency FactorDecimal17-29
1019Job Currency CodeCode[10]17-29
1020Job Planning Line No.Integer17-29
1030Job Remaining Qty.Decimal17-29
1200Direct Debit Mandate IDCode[35]17-29
1220Data Exch. Entry No.Integer17-29
1221Payer InformationText[50]17-29
1222Transaction InformationText[100]17-29
1223Data Exch. Line No.Integer17-29
1224Applied AutomaticallyBoolean17-29
1300Linked Table IDIntegernew in 19
1301Linked System IDGuidnew in 19
1700Deferral CodeCode[10]17-29
1701Deferral Line No.Integer17-29
2676Selected Alloc. Account No.Code[20]new in 23
2677Alloc. Acc. Modified by UserBooleannew in 23
2678Allocation Account No.Code[20]new in 23
2679Alloc. Journal Line SystemIdGuidnew in 27
5050Campaign No.Code[20]17-29
5400Prod. Order No.Code[20]17-29
5600FA Posting DateDate17-29
5601FA Posting TypeEnum "Gen. Journal Line FA Posting Type"17-29
5602Depreciation Book CodeCode[10]17-29
5603Salvage ValueDecimal17-29
5604No. of Depreciation DaysInteger17-29
5605Depr. until FA Posting DateBoolean17-29
5606Depr. Acquisition CostBoolean17-29
5609Maintenance CodeCode[10]17-29
5610Insurance No.Code[20]17-29
5611Budgeted FA No.Code[20]17-29
5612Duplicate in Depreciation BookCode[10]17-29
5613Use Duplication ListBoolean17-29
5614FA Reclassification EntryBoolean17-29
5615FA Error Entry No.Integer17-29
5616Index EntryBoolean17-29
5617Source Line No.Integer17-29
5618CommentText[250]17-29
5701Check ExportedBoolean17-29
5702Check TransmittedBoolean17-29
5703Reverse Date CalculationDateFormula17-29
6200Non-Deductible VAT %Decimalnew in 22
6201Non-Deductible VAT BaseDecimalnew in 22
6202Non-Deductible VAT AmountDecimalnew in 22
6203Non-Deductible VAT Base LCYDecimalnew in 22
6204Non-Deductible VAT Amount LCYDecimalnew in 22
6205Non-Deductible VAT Base ACYDecimalnew in 22
6206Non-Deductible VAT Amount ACYDecimalnew in 22
6207FA G/L Account No.Code[20]new in 22
6208Non-Deductible VAT Diff.Decimalnew in 22
6209Bal. Non-Ded. VAT %Decimalnew in 22
6210Bal. Non-Ded. VAT BaseDecimalnew in 22
6211Bal. Non-Ded. VAT AmountDecimalnew in 22
6212Bal. Non-Ded. VAT Base LCYDecimalnew in 22
6213Bal. Non-Ded. VAT Amount LCYDecimalnew in 22
6230Non-Ded. VAT FA CostBooleannew in 25
8001Account IdGuid17-29
8002Customer IdGuid17-29
8003Applies-to Invoice IdGuid17-29
8004Contact Graph IdText[250]17-29
8005Last Modified DateTimeDateTime17-29
8006Journal Batch IdGuid17-29
8007Payment Method IdGuid17-29
8008Balance Account IdGuid17-29
8009Vendor IdGuid17-29