Table 12144 "GL Book Entry" (IT)

IT country layer · Microsoft.Finance.GeneralLedger.Ledger · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	GL Book Entry
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	Entry No.	Integer	—	not editable
3	G/L Account No.	Code[20]	—	TableRelation G/L Account; not editable
4	Posting Date	Date	—	not editable
5	Document Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”; not editable
6	Document No.	Code[20]	—	not editable
7	Description	Text[100]	—	FlowField: lookup(“G/L Entry”.Description where(“Transaction No.” = field(“Transaction No.”), “G/L Account No.” = field(“G/L Account No.”), “Document No.” = field(“Document No.”), Positive = field(Positive), “Source Type” = field(“Source Type”), “Source No.” = field(“Source No.”))); not editable
17	Amount	Decimal	—	FlowField: sum(“G/L Entry”.Amount where(“Transaction No.” = field(“Transaction No.”), “G/L Account No.” = field(“G/L Account No.”), “Document No.” = field(“Document No.”), Positive = field(Positive), “Source Type” = field(“Source Type”), “Source No.” = field(“Source No.”), “Posting Date” = field(“Posting Date”…; not editable
52	Transaction No.	Integer	—	not editable
53	Debit Amount	Decimal	—	FlowField: sum(“G/L Entry”.“Debit Amount” where(“Transaction No.” = field(“Transaction No.”), “G/L Account No.” = field(“G/L Account No.”), “Document No.” = field(“Document No.”), Positive = field(Positive), “Source Type” = field(“Source Type”), “Source No.” = field(“Source No.”), “Posting Date” = field(“Posti…; not editable
54	Credit Amount	Decimal	—	FlowField: sum(“G/L Entry”.“Credit Amount” where(“Transaction No.” = field(“Transaction No.”), “G/L Account No.” = field(“G/L Account No.”), “Document No.” = field(“Document No.”), Positive = field(Positive), “Source Type” = field(“Source Type”), “Source No.” = field(“Source No.”), “Posting Date” = field(“Post…; not editable
55	Document Date	Date	—	not editable
56	External Document No.	Code[35]	—	not editable
57	Source Type	Enum “Gen. Journal Source Type”	—	enum Enum 82 “Gen. Journal Source Type”; not editable
58	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” else if (“Source Type” = const(Employee)) Employee; not editable
60	Additional-Currency Amount	Decimal	—	FlowField: sum(“G/L Entry”.“Additional-Currency Amount” where(“Transaction No.” = field(“Transaction No.”), “G/L Account No.” = field(“G/L Account No.”), “Document No.” = field(“Document No.”), Positive = field(Positive), “Source Type” = field(“Source Type”), “Source No.” = field(“Source No.”))); not editable
70	Official Date	Date	—	not editable
71	Progressive No.	Integer	—	not editable
72	Positive	Boolean	—	not editable

Keys

Key1: Entry No. (clustered)
Key2: Document No., Posting Date
Key3: Transaction No., G/L Account No., Document No., Positive, Source Type, Source No.
Key4: Official Date
Key5: Posting Date, Transaction No., Entry No.
Key6: Progressive No.
Key7: G/L Account No., Posting Date
Key8: Progressive No., Official Date

Procedures

1 local procedures, no public ones.

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: "GL Book Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

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