Table 5261 "G/L Account Mapping Line"

AuditFileExport · Microsoft.Finance.AuditFileExport · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	G/L Account Mapping Line
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	G/L Account Mapping Code	Code[20]	—	TableRelation Table 5260 “G/L Account Mapping Header” (G/L Account Mapping Header); not editable; NotBlank
2	G/L Account No.	Code[20]	Specifies the number of the account that is used to map the standard account or grouping code. via Page 5262 “G/L Account Mapping Subpage”	TableRelation Table 15 “G/L Account” (G/L Account); not editable; NotBlank
3	Standard Account Type	enum “Standard Account Type”	—	enum Enum 5260 “Standard Account Type”
4	Standard Account Category No.	Code[20]	Specifies the category of the standard account or grouping code that is used for mapping. via Page 5262 “G/L Account Mapping Subpage”	TableRelation Table 5262 “Standard Account Category” (“Standard Account Category”.“No.” where(“Standard Account Type” = field(“Standard Account Type”)))
5	Standard Account No.	Code[20]	Specifies the code of the standard account or grouping code that is used for mapping. via Page 5262 “G/L Account Mapping Subpage”	TableRelation Table 5263 “Standard Account” (“Standard Account”.“No.” where(Type = field(“Standard Account Type”)))
6	G/L Entries Exists	Boolean	—	not editable
50	G/L Account Name	Text[100]	Specifies the name of the account that is used to map the standard account or grouping code. via Page 5262 “G/L Account Mapping Subpage”	FlowField: lookup(“G/L Account”.Name where(“No.” = field(“G/L Account No.”)))

Keys

PK: G/L Account Mapping Code, G/L Account No. (clustered)

Relations

G/L Account Name: CalcFormula Table 15 “G/L Account”
G/L Account No.: TableRelation Table 15 “G/L Account”
G/L Account Mapping Code: TableRelation Table 5260 “G/L Account Mapping Header”
Standard Account Category No.: TableRelation Table 5262 “Standard Account Category”
Standard Account No.: TableRelation Table 5263 “Standard Account”

Pages and codeunits on this table

Page 5262 “G/L Account Mapping Subpage” (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: "G/L Account Mapping Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.