Table 47007 "SL AcctHist"

HybridSL · Microsoft.DataMigration.SL · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	SL AcctHist
Access	Internal
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]	—
2	AnnBdgt	Decimal	—
3	AnnMemo1	Decimal	—
4	BalanceType	Text[1]	—
5	BdgtRvsnDate	DateTime	—
6	BegBal	Decimal	—
7	CpnyID	Text[10]	—
8	Crtd_DateTime	DateTime	—
9	Crtd_Prog	Text[8]	—
10	Crtd_User	Text[10]	—
11	CuryId	Text[4]	—
12	DistType	Text[8]	—
13	FiscYr	Text[4]	—
14	LastClosePerNbr	Text[6]	—
15	LedgerID	Text[10]	—
16	LUpd_DateTime	DateTime	—
17	LUpd_Prog	Text[8]	—
18	LUpd_User	Text[10]	—
19	NoteID	Integer	—
20	PtdAlloc00	Decimal	—
21	PtdAlloc01	Decimal	—
22	PtdAlloc02	Decimal	—
23	PtdAlloc03	Decimal	—
24	PtdAlloc04	Decimal	—
25	PtdAlloc05	Decimal	—
26	PtdAlloc06	Decimal	—
27	PtdAlloc07	Decimal	—
28	PtdAlloc08	Decimal	—
29	PtdAlloc09	Decimal	—
30	PtdAlloc10	Decimal	—
31	PtdAlloc11	Decimal	—
32	PtdAlloc12	Decimal	—
33	PtdBal00	Decimal	—
34	PtdBal01	Decimal	—
35	PtdBal02	Decimal	—
36	PtdBal03	Decimal	—
37	PtdBal04	Decimal	—
38	PtdBal05	Decimal	—
39	PtdBal06	Decimal	—
40	PtdBal07	Decimal	—
41	PtdBal08	Decimal	—
42	PtdBal09	Decimal	—
43	PtdBal10	Decimal	—
44	PtdBal11	Decimal	—
45	PtdBal12	Decimal	—
46	PtdCon00	Decimal	—
47	PtdCon01	Decimal	—
48	PtdCon02	Decimal	—
49	PtdCon03	Decimal	—
50	PtdCon04	Decimal	—
51	PtdCon05	Decimal	—
52	PtdCon06	Decimal	—
53	PtdCon07	Decimal	—
54	PtdCon08	Decimal	—
55	PtdCon09	Decimal	—
56	PtdCon10	Decimal	—
57	PtdCon11	Decimal	—
58	PtdCon12	Decimal	—
59	S4Future01	Text[30]	—
60	S4Future02	Text[30]	—
61	S4Future03	Decimal	—
62	S4Future04	Decimal	—
63	S4Future05	Decimal	—
64	S4Future06	Decimal	—
65	S4Future07	DateTime	—
66	S4Future08	DateTime	—
67	S4Future09	Integer	—
68	S4Future10	Integer	—
69	S4Future11	Text[10]	—
70	S4Future12	Text[10]	—
71	SpreadSheetType	Text[1]	—
72	Sub	Text[24]	—
73	User1	Text[30]	—
74	User2	Text[30]	—
75	User3	Decimal	—
76	User4	Decimal	—
77	User5	Text[10]	—
78	User6	Text[10]	—
79	User7	DateTime	—
80	User8	DateTime	—
81	YtdBal00	Decimal	—
82	YtdBal01	Decimal	—
83	YtdBal02	Decimal	—
84	YtdBal03	Decimal	—
85	YtdBal04	Decimal	—
86	YtdBal05	Decimal	—
87	YtdBal06	Decimal	—
88	YtdBal07	Decimal	—
89	YtdBal08	Decimal	—
90	YtdBal09	Decimal	—
91	YtdBal10	Decimal	—
92	YtdBal11	Decimal	—
93	YtdBal12	Decimal	—
94	YTDEstimated	Decimal	—

Keys

Key1: CpnyID, Acct, Sub, LedgerID, FiscYr (clustered)

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

Across versions

Properties

Fields

Keys

Ask your agent

Evidence 1 sources