Table 42804 "SL Hist. ARDoc"

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

Properties

Property	Value
DataClassification	CustomerContent
ObsoleteState	Pending
ObsoleteTag	28.0
ObsoleteReason	Replaced by table SL Hist. ARDoc Archive.

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	AcctNbr	Text[30]	—
2	AgentID	Text[10]	—
3	ApplAmt	Decimal	—
4	ApplBatNbr	Text[10]	—
5	ApplBatSeq	Integer	—
6	ASID	Integer	—
7	BankAcct	Text[10]	—
8	BankID	Text[10]	—
9	BankSub	Text[24]	—
10	BatNbr	Text[10]	—
11	BatSeq	Integer	—
12	Cleardate	DateTime	—
13	CmmnAmt	Decimal	—
14	CmmnPct	Decimal	—
15	ContractID	Text[10]	—
16	CpnyID	Text[10]	—
17	Crtd_DateTime	DateTime	—
18	Crtd_Prog	Text[8]	—
19	Crtd_User	Text[10]	—
20	CurrentNbr	Integer	—
21	CuryApplAmt	Decimal	—
22	CuryClearAmt	Decimal	—
23	CuryCmmnAmt	Decimal	—
24	CuryDiscApplAmt	Decimal	—
25	CuryDiscBal	Decimal	—
26	CuryDocBal	Decimal	—
27	CuryEffDate	DateTime	—
28	CuryId	Text[4]	—
29	CuryMultDiv	Text[1]	—
30	CuryOrigDocAmt	Decimal	—
31	CuryRate	Decimal	—
32	CuryRateType	Text[6]	—
33	CuryStmtBal	Decimal	—
34	CuryTaxTot00	Decimal	—
35	CuryTaxTot01	Decimal	—
36	CuryTaxTot02	Decimal	—
37	CuryTaxTot03	Decimal	—
38	CuryTxblTot00	Decimal	—
39	CuryTxblTot01	Decimal	—
40	CuryTxblTot02	Decimal	—
41	CuryTxblTot03	Decimal	—
42	CustId	Text[15]	—
43	CustOrdNbr	Text[25]	—
44	Cycle	Integer	—
45	DiscApplAmt	Decimal	—
46	DiscBal	Decimal	—
47	DiscDate	DateTime	—
48	DocBal	Decimal	—
49	DocClass	Text[1]	—
50	DocDate	DateTime	—
51	DocDesc	Text[30]	—
52	DocType	Text[2]	—
53	DraftIssued	Integer	—
54	DueDate	DateTime	—
55	InstallNbr	Integer	—
56	JobCntr	Integer	—
57	LineCntr	Integer	—
58	LUpd_DateTime	DateTime	—
59	LUpd_Prog	Text[8]	—
60	LUpd_User	Text[10]	—
61	MasterDocNbr	Text[10]	—
62	NbrCycle	Integer	—
67	NoPrtStmt	Integer	—
68	NoteId	Integer	—
69	OpenDoc	Integer	—
70	OrdNbr	Text[15]	—
71	OrigBankAcct	Text[10]	—
72	OrigBankSub	Text[24]	—
73	OrigCpnyID	Text[10]	—
74	OrigDocAmt	Decimal	—
75	OrigDocNbr	Text[10]	—
76	PC_Status	Text[1]	—
77	PerClosed	Text[6]	—
78	PerEnt	Text[6]	—
79	PerPost	Text[6]	—
80	PmtMethod	Text[1]	—
81	ProjectID	Text[16]	—
82	RefNbr	Text[10]	—
83	RGOLAmt	Decimal	—
84	Rlsed	Integer	—
85	S4Future01	Text[30]	—
86	S4Future02	Text[30]	—
87	S4Future03	Decimal	—
88	S4Future04	Decimal	—
89	S4Future05	Decimal	—
90	S4Future06	Decimal	—
91	S4Future07	DateTime	—
92	S4Future08	DateTime	—
93	S4Future09	Integer	—
94	S4Future10	Integer	—
95	S4Future11	Text[10]	—
96	S4Future12	Text[10]	—
97	ServiceCallID	Text[10]	—
98	ShipmentNbr	Integer	—
99	SlsperId	Text[10]	—
100	Status	Text[1]	—
101	StmtBal	Decimal	—
102	StmtDate	DateTime	—
103	TaskID	Text[32]	—
104	TaxCntr00	Integer	—
105	TaxCntr01	Integer	—
106	TaxCntr02	Integer	—
107	TaxCntr03	Integer	—
108	TaxId00	Text[10]	—
109	TaxId01	Text[10]	—
110	TaxId02	Text[10]	—
111	TaxId03	Text[10]	—
112	TaxTot00	Decimal	—
113	TaxTot01	Decimal	—
114	TaxTot02	Decimal	—
115	TaxTot03	Decimal	—
116	Terms	Text[2]	—
117	TxblTot00	Decimal	—
118	TxblTot01	Decimal	—
119	TxblTot02	Decimal	—
120	TxblTot03	Decimal	—
121	User1	Text[30]	—
122	User2	Text[30]	—
123	User3	Decimal	—
124	User4	Decimal	—
125	User5	Text[10]	—
126	User6	Text[10]	—
127	User7	DateTime	—
128	User8	DateTime	—
129	WSID	Integer	—

Keys

PK: CustId, DocType, RefNbr, BatNbr, BatSeq (clustered)

Deprecations

object: Pending 28.0 (#if not CLEANSCHEMA31), “Replaced by table SL Hist. ARDoc Archive.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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