Table 47010 "SL AR_Balances"

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

Properties

Property	Value
Caption	SL AR_Balances
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	AccruedRevAgeBal00	Decimal	—
2	AccruedRevAgeBal01	Decimal	—
3	AccruedRevAgeBal02	Decimal	—
4	AccruedRevAgeBal03	Decimal	—
5	AccruedRevAgeBal04	Decimal	—
6	AccruedRevBal	Decimal	—
7	AgeBal00	Decimal	—
8	AgeBal01	Decimal	—
9	AgeBal02	Decimal	—
10	AgeBal03	Decimal	—
11	AgeBal04	Decimal	—
12	AvgDayToPay	Decimal	—
13	CpnyID	Text[10]	—
14	CrLmt	Decimal	—
15	Crtd_DateTime	DateTime	—
16	Crtd_Prog	Text[8]	—
17	Crtd_User	Text[10]	—
18	CurrBal	Decimal	—
19	CuryID	Text[4]	—
20	CuryPromoBal	Decimal	—
21	CustID	Text[15]	—
22	FutureBal	Decimal	—
23	LastActDate	DateTime	—
24	LastAgeDate	DateTime	—
25	LastFinChrgDate	DateTime	—
26	LastInvcDate	DateTime	—
27	LastStmtBal00	Decimal	—
28	LastStmtBal01	Decimal	—
29	LastStmtBal02	Decimal	—
30	LastStmtBal03	Decimal	—
31	LastStmtBal04	Decimal	—
32	LastStmtBegBal	Decimal	—
33	LastStmtDate	DateTime	—
34	LUpd_DateTime	DateTime	—
35	LUpd_Prog	Text[8]	—
36	LUpd_User	Text[10]	—
37	NbrInvcPaid	Decimal	—
38	NoteID	Integer	—
39	PaidInvcDays	Decimal	—
40	PerNbr	Text[6]	—
41	PromoBal	Decimal	—
42	S4Future01	Text[30]	—
43	S4Future02	Text[30]	—
44	S4Future03	Decimal	—
45	S4Future04	Decimal	—
46	S4Future05	Decimal	—
47	S4Future06	Decimal	—
48	S4Future07	DateTime	—
49	S4Future08	DateTime	—
50	S4Future09	Integer	—
51	S4Future10	Integer	—
52	S4Future11	Text[10]	—
53	S4Future12	Text[10]	—
54	TotOpenOrd	Decimal	—
55	TotPrePay	Decimal	—
56	TotShipped	Decimal	—
57	User1	Text[30]	—
58	User2	Text[30]	—
59	User3	Decimal	—
60	User4	Decimal	—
61	User5	Text[10]	—
62	User6	Text[10]	—
63	User7	DateTime	—
64	User8	DateTime	—

Keys

Key1: CpnyID, CustID (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 AR_Balances"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.