Table 12403 "Gen. Journal Line Archive" (RU)

RU country layer · BC29-30 · source at ea08af5e · facts from BC29

An object of the RU localization, not part of W1.

Properties

Property	Value
Caption	Gen. Journal Line Archive
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Journal Template Name	Code[10]	—	TableRelation Gen. Journal Template
2	Line No.	Integer	—
3	Account Type	Option	—	OptionCaption: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner
4	Account No.	Code[20]	—	TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Account Type” = const(“Fixed Asset”)) “Fixed Asset” else if (“Account…
5	Posting Date	Date	—
6	Document Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
7	Document No.	Code[20]	—
8	Description	Text[100]	—
10	VAT %	Decimal	—	not editable
11	Bal. Account No.	Code[20]	—	TableRelation if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account” else if (“Bal. Account Type” = const(“Fixed Asset”)) “Fixed…
12	Currency Code	Code[10]	—	TableRelation Currency
13	Amount	Decimal	—
14	Debit Amount	Decimal	—
15	Credit Amount	Decimal	—
16	Amount (LCY)	Decimal	—
17	Balance (LCY)	Decimal	—	not editable
18	Currency Factor	Decimal	—	not editable
19	Sales/Purch. (LCY)	Decimal	—
20	Profit (LCY)	Decimal	—
21	Inv. Discount (LCY)	Decimal	—
22	Bill-to/Pay-to No.	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(Vendor)) Vendor
23	Posting Group	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) “Customer Posting Group” else if (“Account Type” = const(Vendor)) “Vendor Posting Group” else if (“Account Type” = const(“Fixed Asset”)) “FA Posting Group”; not editable
24	Shortcut Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
25	Shortcut Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
26	Salespers./Purch. Code	Code[20]	—	TableRelation Salesperson/Purchaser
29	Source Code	Code[10]	—	TableRelation Source Code; not editable
30	System-Created Entry	Boolean	—	not editable
34	On Hold	Code[3]	—
35	Applies-to Doc. Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
36	Applies-to Doc. No.	Code[20]	—
38	Due Date	Date	—
39	Pmt. Discount Date	Date	—
40	Payment Discount %	Decimal	—
42	Job No.	Code[20]	—	TableRelation Job; not editable
43	Quantity	Decimal	—
44	VAT Amount	Decimal	—
45	VAT Posting	Option	—	OptionCaption: Automatic VAT Entry,Manual VAT Entry; not editable
47	Payment Terms Code	Code[10]	—	TableRelation Payment Terms
48	Applies-to ID	Code[50]	—
50	Business Unit Code	Code[20]	—	TableRelation Business Unit
51	Journal Batch Name	Code[10]	—	TableRelation “Gen. Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”))
52	Reason Code	Code[10]	—	TableRelation Reason Code
53	Recurring Method	Option	—	OptionCaption: ,F Fixed,V Variable,B Balance,RF Reversing Fixed,RV Reversing Variable,RB Reversing Balance
54	Expiration Date	Date	—
55	Recurring Frequency	DateFormula	—
57	Gen. Posting Type	Option	—	OptionCaption: ,Purchase,Sale,Settlement
58	Gen. Bus. Posting Group	Code[20]	—	TableRelation Gen. Business Posting Group
59	Gen. Prod. Posting Group	Code[20]	—	TableRelation Gen. Product Posting Group
60	VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”; not editable
61	EU 3-Party Trade	Boolean	—	not editable
62	Allow Application	Boolean	—
63	Bal. Account Type	Option	—	OptionCaption: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner
64	Bal. Gen. Posting Type	Option	—	OptionCaption: ,Purchase,Sale,Settlement
65	Bal. Gen. Bus. Posting Group	Code[20]	—	TableRelation Gen. Business Posting Group
66	Bal. Gen. Prod. Posting Group	Code[20]	—	TableRelation Gen. Product Posting Group
67	Bal. VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”; not editable
68	Bal. VAT %	Decimal	—	not editable
69	Bal. VAT Amount	Decimal	—
70	Bank Payment Type	Option	—	OptionCaption: ,Computer Check,Manual Check
71	VAT Base Amount	Decimal	—
72	Bal. VAT Base Amount	Decimal	—
73	Correction	Boolean	—
75	Check Printed	Boolean	—	not editable
76	Document Date	Date	—
77	External Document No.	Code[35]	—
78	Source Type	Option	—	OptionCaption: ,Customer,Vendor,Bank Account,Fixed Asset
79	Source No.	Code[20]	—	TableRelation if (“Source Type” = const(Customer)) Customer else if (“Source Type” = const(Vendor)) Vendor else if (“Source Type” = const(“Bank Account”)) “Bank Account” else if (“Source Type” = const(“Fixed Asset”)) “Fixed Asset”
80	Posting No. Series	Code[20]	—	TableRelation No. Series
82	Tax Area Code	Code[20]	—	TableRelation Tax Area
83	Tax Liable	Boolean	—
84	Tax Group Code	Code[20]	—	TableRelation Tax Group
85	Use Tax	Boolean	—
86	Bal. Tax Area Code	Code[20]	—	TableRelation Tax Area
87	Bal. Tax Liable	Boolean	—
88	Bal. Tax Group Code	Code[20]	—	TableRelation Tax Group
89	Bal. Use Tax	Boolean	—
90	VAT Bus. Posting Group	Code[20]	—	TableRelation VAT Business Posting Group
91	VAT Prod. Posting Group	Code[20]	—	TableRelation VAT Product Posting Group
92	Bal. VAT Bus. Posting Group	Code[20]	—	TableRelation VAT Business Posting Group
93	Bal. VAT Prod. Posting Group	Code[20]	—	TableRelation VAT Product Posting Group
95	Additional-Currency Posting	Option	—	OptionCaption: None,Amount Only,Additional-Currency Amount Only; not editable
98	FA Add.-Currency Factor	Decimal	—
99	Source Currency Code	Code[10]	—	TableRelation Currency; not editable
100	Source Currency Amount	Decimal	—	not editable
101	Source Curr. VAT Base Amount	Decimal	—	not editable
102	Source Curr. VAT Amount	Decimal	—	not editable
103	VAT Base Discount %	Decimal	—	not editable
104	VAT Amount (LCY)	Decimal	—	not editable
105	VAT Base Amount (LCY)	Decimal	—	not editable
106	Bal. VAT Amount (LCY)	Decimal	—	not editable
107	Bal. VAT Base Amount (LCY)	Decimal	—	not editable
108	Reversing Entry	Boolean	—	not editable
109	Allow Zero-Amount Posting	Boolean	—	not editable
110	Ship-to/Order Address Code	Code[10]	—	TableRelation if (“Account Type” = const(Customer)) “Ship-to Address”.Code where(“Customer No.” = field(“Bill-to/Pay-to No.”)) else if (“Account Type” = const(Vendor)) “Order Address”.Code where(“Vendor No.” = field(“Bill-to/Pay-to No.”)) else if (“Bal. Account Type” = const(Customer)) “Ship-to Address”.Code wher…
111	VAT Difference	Decimal	—	not editable
112	Bal. VAT Difference	Decimal	—	not editable
113	IC Partner Code	Code[20]	—	TableRelation IC Partner; not editable
114	IC Direction	Option	—	OptionCaption: Outgoing,Incoming
116	IC Partner G/L Acc. No.	Code[20]	—	obsolete Removed 25.0; #if not CLEANSCHEMA25; TableRelation IC G/L Account
117	IC Partner Transaction No.	Integer	—	not editable
118	Sell-to/Buy-from No.	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(Vendor)) Vendor
119	VAT Registration No.	Text[20]	—
120	Country/Region Code	Code[10]	—	TableRelation Country/Region
121	Prepayment	Boolean	—
122	Financial Void	Boolean	—	not editable
130	IC Account Type	Enum “IC Journal Account Type”	—	enum Enum 84 “IC Journal Account Type”
131	IC Account No.	Code[20]	—	TableRelation if (“IC Account Type” = const(“G/L Account”)) “IC G/L Account” where(“Account Type” = const(Posting), Blocked = const(false)) else if (“Account Type” = const(Customer), “IC Account Type” = const(“Bank Account”)) “IC Bank Account” where(“IC Partner Code” = field(“IC Partner Code”), Blocked = const(fa…
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable
1001	Job Task No.	Code[20]	—	TableRelation “Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))
1002	Job Unit Price (LCY)	Decimal	—
1003	Job Total Price (LCY)	Decimal	—
1004	Job Quantity	Decimal	—
1005	Job Unit Cost (LCY)	Decimal	—	not editable
1006	Job Line Discount %	Decimal	—
1007	Job Line Disc. Amount (LCY)	Decimal	—
1008	Job Unit Of Measure Code	Code[10]	—	TableRelation Unit of Measure
1009	Job Line Type	Option	—	OptionCaption: ,Schedule,Contract,Both Schedule and Contract
1010	Job Unit Price	Decimal	—
1011	Job Total Price	Decimal	—	not editable
1012	Job Unit Cost	Decimal	—	not editable
1013	Job Total Cost	Decimal	—	not editable
1014	Job Line Discount Amount	Decimal	—
1015	Job Line Amount	Decimal	—
1016	Job Total Cost (LCY)	Decimal	—	not editable
1017	Job Line Amount (LCY)	Decimal	—
1018	Job Currency Factor	Decimal	—
1019	Job Currency Code	Code[10]	—
5050	Campaign No.	Code[20]	—	TableRelation Campaign
5400	Prod. Order No.	Code[20]	—	not editable
5600	FA Posting Date	Date	—
5601	FA Posting Type	Option	—	OptionCaption: ,Acquisition Cost,Depreciation,Write-Down,Appreciation,Custom 1,Custom 2,Disposal,Maintenance
5602	Depreciation Book Code	Code[10]	—	TableRelation Depreciation Book
5603	Salvage Value	Decimal	—
5604	No. of Depreciation Days	Integer	—
5605	Depr. until FA Posting Date	Boolean	—
5606	Depr. Acquisition Cost	Boolean	—
5609	Maintenance Code	Code[10]	—	TableRelation Maintenance
5610	Insurance No.	Code[20]	—	TableRelation Insurance
5611	Budgeted FA No.	Code[20]	—	TableRelation Fixed Asset
5612	Duplicate in Depreciation Book	Code[10]	—	TableRelation Depreciation Book
5613	Use Duplication List	Boolean	—
5614	FA Reclassification Entry	Boolean	—
5615	FA Error Entry No.	Integer	—	TableRelation FA Ledger Entry
5616	Index Entry	Boolean	—
5802	Value Entry No.	Integer	—	TableRelation Value Entry; not editable
12400	Initial Entry No.	Integer	—
12401	Beneficiary Bank Code	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) “Customer Bank Account”.Code where(“Customer No.” = field(“Account No.”)) else if (“Account Type” = const(Vendor)) “Vendor Bank Account”.Code where(“Vendor No.” = field(“Account No.”))
12402	Payment Purpose	Text[250]	—
12403	Cash Order Including	Text[250]	—
12404	Cash Order Supplement	Text[80]	—
12405	Payment Method	Option	—	OptionCaption: ,Mail,Telegraph,Through Moscow,Clearing,Electronic
12406	Payment Date	Date	—
12407	Payment Subsequence	Text[2]	—
12408	Payment Code	Text[20]	—
12409	Payment Assignment	Text[15]	—
12410	Payment Type	Text[5]	—
12411	Debit Amount (LCY)	Decimal	—
12412	Credit Amount (LCY)	Decimal	—
12413	Prepmt. Diff.	Boolean	—	not editable
12414	Realized VAT Entry No.	Integer	—	TableRelation “Vendor Ledger Entry”.“Entry No.” where(“Document Type” = filter(Invoice \| “Credit Memo” \| “Finance Charge Memo” \| Reminder))
12415	Expression	Text[50]	—
12416	Expression Type	Option	—	OptionCaption: ,Term,Formula
12417	VAT Transaction No.	Integer	—
12418	VAT Settlement Part	Option	—	OptionCaption: ,Full,1/6,1/12,28-FL,Reverse,Ratio,Custom; not editable
12419	Unrealized VAT Entry No.	Integer	—	TableRelation “VAT Entry”.“Entry No.” where(“Unrealized Base” = filter(<> 0))
12420	Paid Amount	Decimal	—	not editable
12421	FA Location Code	Code[10]	—	TableRelation FA Location
12422	Initial VAT Entry No.	Integer	—	TableRelation if (“Account Type” = const(Vendor)) “VAT Entry”.“Entry No.” where(“Document Type” = field(“Document Type”), “Document No.” = field(“Document No.”), Type = const(Purchase), “Unrealized VAT Entry No.” = filter(<> 0), “Bill-to/Pay-to No.” = field(“Account No.”), “Prepmt. Diff.” = const(false)) else if …
12423	Object Type	Enum “Gen. Journal Source Type”	—	enum Enum 82 “Gen. Journal Source Type”
12424	Object No.	Code[20]	—	TableRelation if (“Object Type” = const(Customer)) Customer else if (“Object Type” = const(Vendor)) Vendor else if (“Object Type” = const(“Bank Account”)) “Bank Account” else if (“Object Type” = const(“Fixed Asset”)) “Fixed Asset”
12425	Prepayment Document No.	Code[20]	—
12426	Prepayment Status	Option	—	OptionCaption: ,Set,Reset
12427	Advance VAT Base Amount	Decimal	—
12428	Document Line No.	Integer	—
12429	Prepmt. Diff. Appln. Entry No.	Integer	—	not editable
12430	Employee No.	Code[20]	—	TableRelation Employee
12435	Vendor VAT Invoice No.	Code[30]	—
12436	Vendor VAT Invoice Date	Date	—
12437	Vendor VAT Invoice Rcvd Date	Date	—
12470	Vendor Receipts No.	Code[20]	—
12471	Vendor Receipts Date	Date	—
12476	FA Charge No.	Code[20]	—	TableRelation FA Charge; not editable
12480	KBK	Code[20]	—	TableRelation KBK
12481	OKATO	Code[11]	—	TableRelation OKATO
12482	Period Code	Option	—	OptionCaption: ,0,D1-payment for the first decade of month,D2-payment for the second decade of month,D3-payment for the third decade of month,MH-monthly payments,QT-quarter payment,HY-half-year payments,YR-year payments
12483	Payment Reason Code	Code[10]	—	TableRelation “Payment Order Code”.Code where(Type = const(“Payment Reason”))
12484	Reason Document No.	Code[10]	—
12485	Reason Document Date	Date	—
12486	Tax Payment Type	Code[10]	—	TableRelation “Payment Order Code”.Code where(Type = const(“Tax Payment Type”))
12487	Tax Period	Code[10]	—
12488	Reason Document Type	Option	—	OptionCaption: ,TR-Number of requirement about taxes payment from TA,RS-Number of decision about installment,OT-Number of decision about deferral,VU-Number of act of materials in court,PR-Number of decision about suspension of penalty,AP-Number of control act,AR-number of executive document; not editable
12489	Taxpayer Parameter	Option	—	OptionCaption: ,01-taxpayer (charges payer),02-tax agent,03-collector of taxes and charges,04-tax authority,05-service of officers of justice of Department of Justice of Russian Federation,06-participant of foreign-economic activity,07-tax authority,08-payer of other mandatory payments
12490	Agreement No.	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) “Customer Agreement” where(“Customer No.” = field(“Account No.”)) else if (“Account Type” = const(Vendor)) “Vendor Agreement” where(“Vendor No.” = field(“Account No.”))
12491	Depr. Period Starting Date	Date	—	TableRelation Accounting Period
12492	Payer Vendor No.	Code[20]	—	TableRelation Vendor
12493	Payer Beneficiary Bank Code	Code[20]	—	TableRelation “Vendor Bank Account”.Code where(“Vendor No.” = field(“Payer Vendor No.”))
12494	Not Add.-Currency Correction	Boolean	—
12495	Only Add.-Currency Correction	Boolean	—
12497	Include In Other VAT Ledger	Boolean	—
12498	Additional VAT Ledger Sheet	Boolean	—
12499	Corrected Document Date	Date	—
14926	Unrealized Amount	Decimal	—
14927	VAT Allocation Type	Option	—	OptionCaption: VAT,Write-Off,Charge
17201	Depr. Bonus	Boolean	—
17202	Tax. Diff. Dtld. Entry No.	Integer	—
17300	Tax Difference Code	Code[10]	—	TableRelation “Tax Difference” where(“Source Code Mandatory” = const(true))
17301	Depr. Group Elimination	Boolean	—

Keys

Key1: Journal Template Name, Journal Batch Name, Line No. (clustered)
Key2: Journal Template Name, Journal Batch Name, Posting Date, Document No.
Key3: Account Type, Account No., Applies-to Doc. Type, Applies-to Doc. No.

Procedures

LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
ShowDimensions()

Deprecations

field IC Partner G/L Acc. No.: Removed 25.0 (#if not CLEANSCHEMA25), “Replaced by IC Account No.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Gen. Journal Line Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A RU country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.