Table 181 Posted Gen. Journal Line

Base Application, Microsoft.Finance.GeneralLedger.Journal

193 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
29Source CodeCode[10]17-29
30System-Created EntryBoolean17-29
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
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.1: 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
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
288Recipient Bank AccountCode[20]17-29
289Message to RecipientText[140]17-29
290Exported to Payment FileBoolean17-29
480Dimension Set IDInteger17-29
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
1700Deferral CodeCode[10]17-29
1701Deferral Line No.Integer17-29
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
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
6208Non-Deductible VAT Diff.Decimalnew in 22
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
8010G/L Register No.Integer17-29
8011IndentationInteger17-29