Table 42822 "SL Hist. GLSetup"

DynamicsSLHistoricalData · Microsoft.DataMigration.SL · 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	Addr1	Text[30]	—
2	Addr2	Text[30]	—
3	AllowPostOpt	Text[1]	—
4	AutoBatRpt	Integer	—
5	AutoPost	Text[1]	—
6	AutoRef	Text[1]	—
7	AutoRevOpt	Text[1]	—
8	BaseCuryId	Text[4]	—
9	BatCntrlByMod	Text[150]	—
10	BegFiscalYr	Integer	—
11	BudgetLedgerID	Text[10]	—
12	BudgetSpreadDir	Text[50]	—
13	BudgetSpreadType	Text[1]	—
14	BudgetSubSeg00	Text[1]	—
15	BudgetSubSeg01	Text[1]	—
16	BudgetSubSeg02	Text[1]	—
17	BudgetSubSeg03	Text[1]	—
18	BudgetSubSeg04	Text[1]	—
19	BudgetSubSeg05	Text[1]	—
20	BudgetSubSeg06	Text[1]	—
21	BudgetSubSeg07	Text[1]	—
22	BudgetYear	Text[4]	—
23	Central_Cash_Cntl	Integer	—
24	ChngNbrPer	Integer	—
25	City	Text[30]	—
26	COAOrder	Text[1]	—
27	Country	Text[3]	—
28	CpnyId	Text[10]	—
29	CpnyName	Text[30]	—
30	Crtd_DateTime	DateTime	—
31	Crtd_Prog	Text[8]	—
32	Crtd_User	Text[10]	—
33	EditInit	Integer	—
34	EmplId	Text[12]	—
35	Fax	Text[30]	—
36	FiscalPerEnd00	Text[4]	—
37	FiscalPerEnd01	Text[4]	—
38	FiscalPerEnd02	Text[4]	—
39	FiscalPerEnd03	Text[4]	—
40	FiscalPerEnd04	Text[4]	—
41	FiscalPerEnd05	Text[4]	—
42	FiscalPerEnd06	Text[4]	—
43	FiscalPerEnd07	Text[4]	—
44	FiscalPerEnd08	Text[4]	—
45	FiscalPerEnd09	Text[4]	—
46	FiscalPerEnd10	Text[4]	—
47	FiscalPerEnd11	Text[4]	—
48	FiscalPerEnd12	Text[4]	—
49	Init	Integer	—
50	LastBatNbr	Text[10]	—
51	LastClosePerNbr	Text[6]	—
52	LedgerID	Text[10]	—
53	LUpd_DateTime	DateTime	—
54	LUpd_Prog	Text[8]	—
55	LUpd_User	Text[10]	—
56	Master_Fed_ID	Integer	—
57	MCActive	Integer	—
58	MCuryBatRpt	Integer	—
59	ModPriorPost	Text[180]	—
60	Mult_Cpny_Db	Integer	—
61	NbrPer	Integer	—
62	NoteID	Integer	—
63	PerNbr	Text[6]	—
64	PerRetHist	Integer	—
65	PerRetModTran	Integer	—
66	PerRetTran	Integer	—
67	Phone	Text[30]	—
68	PriorYearPost	Integer	—
69	PSC	Text[4]	—
70	RetEarnAcct	Text[10]	—
71	S4Future01	Text[30]	—
72	S4Future02	Text[30]	—
73	S4Future03	Decimal	—
74	S4Future04	Decimal	—
75	S4Future05	Decimal	—
76	S4Future06	Decimal	—
77	S4Future07	DateTime	—
78	S4Future08	DateTime	—
79	S4Future09	Integer	—
80	S4Future10	Integer	—
81	S4Future11	Text[10]	—
82	S4Future12	Text[10]	—
83	SetupId	Text[2]	—
84	State	Text[3]	—
85	SubAcctSeg	Text[2]	—
86	SummPostYCntr	Integer	—
87	UpdateCA	Integer	—
88	User1	Text[30]	—
89	User2	Text[30]	—
90	User3	Decimal	—
91	User4	Decimal	—
92	User5	Text[10]	—
93	User6	Text[10]	—
94	User7	DateTime	—
95	User8	DateTime	—
96	ValidateAcctSub	Integer	—
97	ValidateAtPosting	Integer	—
98	YtdNetIncAcct	Text[10]	—
99	ZCount	Integer	—
100	Zip	Text[10]	—
101	Zp	Text[256]	—

Keys

Key1: SetupId (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 Hist. GLSetup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.