Table 40901 "Hist. Gen. Journal Line"

DynamicsGPHistoricalData · Microsoft.DataMigration.GP.HistoricalData · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
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	Primary Key	Integer	—	AutoIncrement
2	Journal Entry No.	Code[35]	Specifies the value of the Journal Entry No. field. via Page 41001 “Hist. Gen. Journal Lines”	NotBlank
3	Source Type	enum “Hist. Source Type”	—	enum Enum 40902 “Hist. Source Type”; NotBlank
4	Account No.	Code[130]	Specifies the value of the Account No. field. via Page 41001 “Hist. Gen. Journal Lines”	TableRelation Table 40900 “Hist. G/L Account” (“Hist. G/L Account”.“No.”); NotBlank
5	Sequence No.	Integer	Specifies the value of the Sequence No. field. via Page 41001 “Hist. Gen. Journal Lines”	NotBlank
6	Closed	Boolean	Specifies the value of the Closed field. via Page 41001 “Hist. Gen. Journal Lines”	NotBlank
7	Audit Code	Text[35]	Specifies the value of the Audit Code field. via Page 41001 “Hist. Gen. Journal Lines”	NotBlank
8	Year	Integer	Specifies the value of the Year field. via Page 41001 “Hist. Gen. Journal Lines”	NotBlank
9	Date	Date	Specifies the value of the Date field. via Page 41001 “Hist. Gen. Journal Lines”	NotBlank
10	Currency Code	Code[10]	Specifies the value of the Currency Code field. via Page 41001 “Hist. Gen. Journal Lines”	NotBlank
11	Debit Amount	Decimal	Specifies the value of the Debit Amount field. via Page 41001 “Hist. Gen. Journal Lines”
12	Orig. Debit Amount	Decimal	Specifies the value of the Originating Debit Amount field. via Page 41001 “Hist. Gen. Journal Lines”
13	Credit Amount	Decimal	Specifies the value of the Credit Amount field. via Page 41001 “Hist. Gen. Journal Lines”
14	Orig. Credit Amount	Decimal	Specifies the value of the Originating Credit Amount field. via Page 41001 “Hist. Gen. Journal Lines”
15	Document Type	Text[35]	Specifies the value of the Document Type field. via Page 41001 “Hist. Gen. Journal Lines”	NotBlank
16	Orig. Document No.	Text[35]	Specifies the value of the Originating Document No. field. via Page 41001 “Hist. Gen. Journal Lines”
17	Orig. Trx. Source No.	Text[35]	Specifies the value of the Orig. Trx. Source No. field. via Page 41001 “Hist. Gen. Journal Lines”
18	Source No.	Text[35]	Specifies the value of the Source No. field. via Page 41001 “Hist. Gen. Journal Lines”
19	Source Name	Text[50]	Specifies the value of the Source Name field. via Page 41001 “Hist. Gen. Journal Lines”
20	Reference Desc.	Text[50]	Specifies the value of the Refererence Desc. field. via Page 41001 “Hist. Gen. Journal Lines”
21	Description	Text[50]	Specifies the value of the Description field. via Page 41001 “Hist. Gen. Journal Lines”
22	User	Text[50]	Specifies the value of the User field. via Page 41001 “Hist. Gen. Journal Lines”
23	Custom1	Text[50]	Specifies the value of the Custom 1 field. via Page 41001 “Hist. Gen. Journal Lines”
24	Custom2	Text[50]	Specifies the value of the Custom 2 field. via Page 41001 “Hist. Gen. Journal Lines”

Keys

PK: Primary Key (clustered)
Key2: Account No., Year, Closed
Key3: Orig. Trx. Source No.

Relations

Account No.: TableRelation Table 40900 “Hist. G/L Account”

Pages and codeunits on this table

Page 41001 “Hist. Gen. Journal Lines” (source table)

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: "Hist. Gen. Journal Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.