Table 4091 "GP GLTransactions"

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

Properties

Property	Value
Extensible	false

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	Id	Integer	Id Number caption	AutoIncrement; DataClassification CustomerContent
2	ACTINDX	Integer	Account Index caption	DataClassification CustomerContent
4	YEAR1	Integer	Year caption	DataClassification CustomerContent
5	PERIODID	Integer	Fiscal Period caption	DataClassification CustomerContent
6	DEBITAMT	Decimal	Debit Amount caption	DataClassification CustomerContent
7	CRDTAMNT	Decimal	Credit Amount caption	DataClassification CustomerContent
8	PERDBLNC	Decimal	Period Balance caption	DataClassification CustomerContent
9	MNACSGMT	Integer	Main account segment caption	DataClassification SystemMetadata
10	ACTNUMBR_1	Code[20]	Account Segment 1 caption	DataClassification CustomerContent
11	ACTNUMBR_2	Code[20]	Account Segment 2 caption	DataClassification CustomerContent
12	ACTNUMBR_3	Code[20]	Account Segment 3 caption	DataClassification CustomerContent
13	ACTNUMBR_4	Code[20]	Account Segment 4 caption	DataClassification CustomerContent
14	ACTNUMBR_5	Code[20]	Account Segment 5 caption	DataClassification CustomerContent
15	ACTNUMBR_6	Code[20]	Account Segment 6 caption	DataClassification CustomerContent
16	ACTNUMBR_7	Code[20]	Account Segment 7 caption	DataClassification CustomerContent
17	ACTNUMBR_8	Code[20]	Account Segment 8 caption	DataClassification CustomerContent

Keys

Key1: Id (clustered)
TrxKey: YEAR1, PERIODID, ACTINDX
KeyActIndx: ACTINDX

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