Table 42823 "SL Hist. GLTran Archive"

DynamicsSLHistoricalData · Microsoft.DataMigration.SL.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
1	Acct	Text[10]	Specifies the Account that the entry has been posted to. via Page 42800 “SL Hist. GLTran Entries”
2	AppliedDate	Date	—
3	BalanceType	Text[1]	—
4	BaseCuryID	Text[4]	—
5	BatNbr	Text[10]	Specifies the Batch Number that the entry belongs to. via Page 42800 “SL Hist. GLTran Entries”
6	CpnyID	Text[10]	Specifies the Company ID that the entry belongs to. via Page 42800 “SL Hist. GLTran Entries”
7	CrAmt	Decimal	Specifies the credit amount that was posted on the entry. via Page 42800 “SL Hist. GLTran Entries”
8	Crtd_DateTime	DateTime	—
9	Crtd_Prog	Text[8]	—
10	Crtd_User	Text[10]	—
11	CuryCrAmt	Decimal	—
12	CuryDrAmt	Decimal	—
13	CuryEffDate	Date	—
14	CuryId	Text[4]	—
15	CuryMultDiv	Text[1]	—
16	CuryRate	Decimal	—
17	CuryRateType	Text[6]	—
18	DrAmt	Decimal	Specifies the debit amount that was posted on the entry. via Page 42800 “SL Hist. GLTran Entries”
19	EmployeeID	Text[10]	Specifies the Employee ID that the entry is associated with via Page 42800 “SL Hist. GLTran Entries”
20	ExtRefNbr	Text[15]	—
21	FiscYr	Text[4]	—
22	IC_Distribution	Integer	—
23	Id	Text[20]	—
24	JrnlType	Text[3]	Specifies the Journal Type that the entry belongs to. via Page 42800 “SL Hist. GLTran Entries”
25	Labor_Class_Cd	Text[4]	Specifies the Labor Class Code that the entry is associated with. via Page 42800 “SL Hist. GLTran Entries”
26	LedgerID	Text[10]	Specifies the Ledger ID that the entry is posted to. via Page 42800 “SL Hist. GLTran Entries”
27	LineId	Integer	—
28	LineNbr	Integer	—
29	LineRef	Text[5]	—
30	LUpd_DateTime	DateTime	—
31	LUpd_Prog	Text[8]	—
32	LUpd_User	Text[10]	—
33	Module	Text[2]	Specifies the Module that the entry belongs to. via Page 42800 “SL Hist. GLTran Entries”
34	NoteID	Integer	—
35	OrigAcct	Text[10]	—
36	OrigBatNbr	Text[10]	—
37	OrigCpnyID	Text[10]	Specifies the Original Company ID that the entry belongs to. via Page 42800 “SL Hist. GLTran Entries”
38	OrigSub	Text[24]	—
39	PC_Flag	Text[1]	—
40	PC_ID	Text[20]	—
41	PC_Status	Text[1]	—
42	PerEnt	Text[6]	—
43	PerPost	Text[6]	Specifies the period that the entry was posted to. via Page 42800 “SL Hist. GLTran Entries”
44	Posted	Text[1]	Specifies the entry’s Posted status. via Page 42800 “SL Hist. GLTran Entries”
45	ProjectID	Text[16]	Specifies the Project ID that the entry is associated with. via Page 42800 “SL Hist. GLTran Entries”
46	Qty	Decimal	—
47	RefNbr	Text[10]	Specifies the entry’s Reference Number via Page 42800 “SL Hist. GLTran Entries”
48	RevEntryOption	Text[1]	—
49	Rlsed	Integer	Specifies the entry’s Released status. via Page 42800 “SL Hist. GLTran Entries”
50	S4Future01	Text[30]	—
52	S4Future02	Text[30]	—
53	S4Future03	Decimal	—
54	S4Future04	Decimal	—
55	S4Future05	Decimal	—
56	S4Future06	Decimal	—
57	S4Future07	Date	—
58	S4Future08	Date	—
59	S4Future09	Integer	—
60	S4Future10	Integer	—
61	S4Future11	Text[10]	—
63	S4Future12	Text[10]	—
64	ServiceDate	Date	—
65	Sub	Text[24]	Specifies the Subaccount that the entry has been posted to. via Page 42800 “SL Hist. GLTran Entries”
66	TaskID	Text[32]	Specifies the Task ID that the entry is associated with. via Page 42800 “SL Hist. GLTran Entries”
67	TranDate	Date	Specifies the entry’s Transaction Date. via Page 42800 “SL Hist. GLTran Entries”
68	TranDesc	Text[30]	Specifies the entry’s Transaction Description. via Page 42800 “SL Hist. GLTran Entries”
69	TranType	Text[2]	Specifies the Transaction Type that the entry belongs to. via Page 42800 “SL Hist. GLTran Entries”
70	Units	Decimal	—
71	User1	Text[30]	—
73	User2	Text[30]	—
74	User3	Decimal	—
75	User4	Decimal	—
76	User5	Text[10]	—
77	User6	Text[10]	—
78	User7	Date	—
79	User8	Date	—

Keys

Key1: Module, BatNbr, LineNbr (clustered)
Key2: Acct, Module, BatNbr, LineNbr

Pages and codeunits on this table

Page 42800 “SL Hist. GLTran Entries” (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: "SL Hist. GLTran Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.