Table 42826 "SL Hist. APDoc 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]	Account Number caption
2	AddlCost	Integer	Additional Cost caption
3	ApplyAmt	Decimal	Apply Amount caption
4	ApplyDate	DateTime	Apply Date caption
5	ApplyRefNbr	Text[10]	Apply Ref Nbr caption
6	BatNbr	Text[10]	Batch Number caption
7	BatSeq	Integer	Batch Sequence caption
8	BWAmt	Decimal	BW Amount caption
9	CashAcct	Text[10]	—
10	CashSub	Text[24]	—
11	ClearAmt	Decimal	—
12	ClearDate	DateTime	—
13	CodeType	Text[4]	—
14	CpnyID	Text[10]	—
15	Crtd_DateTime	DateTime	—
16	Crtd_Prog	Text[8]	—
17	Crtd_User	Text[10]	—
18	CurrentNbr	Integer	—
19	CuryBWAmt	Decimal	—
20	CuryDiscBal	Decimal	—
21	CuryDiscTkn	Decimal	—
22	CuryDocBal	Decimal	—
23	CuryEffDate	DateTime	CuryEffDateDate caption
24	CuryId	Text[4]	—
25	CuryMultDiv	Text[1]	—
26	CuryOrigDocAmt	Decimal	—
27	CuryPmtAmt	Decimal	—
28	CuryRate	Decimal	—
29	CuryRateType	Text[6]	—
30	CuryTaxTot00	Decimal	—
31	CuryTaxTot01	Decimal	—
32	CuryTaxTot02	Decimal	—
33	CuryTaxTot03	Decimal	—
34	CuryTxblTot00	Decimal	—
35	CuryTxblTot01	Decimal	—
36	CuryTxblTot02	Decimal	—
37	CuryTxblTot03	Decimal	—
38	Cycle	Integer	—
39	DfltDetail	Integer	—
40	DirectDeposit	Text[1]	—
41	DiscBal	Decimal	—
42	DiscDate	DateTime	—
43	DiscTkn	Decimal	—
44	Doc1099	Integer	—
45	DocBal	Decimal	—
46	DocClass	Text[1]	—
47	DocDate	DateTime	—
48	DocDesc	Text[30]	—
49	DocType	Text[2]	—
50	DueDate	DateTime	—
51	Econfirm	Text[18]	—
52	Estatus	Text[1]	—
53	ExcludeFreight	Text[1]	—
54	FreightAmt	Decimal	—
55	InstallNbr	Integer	—
56	InvcDate	DateTime	—
57	InvcNbr	Text[15]	—
58	LCCode	Text[10]	—
59	LineCntr	Integer	—
60	LUpd_DateTime	DateTime	—
61	LUpd_Prog	Text[8]	—
62	LUpd_User	Text[10]	—
63	MasterDocNbr	Text[10]	—
64	NbrCycle	Integer	—
65	NoteID	Integer	—
66	OpenDoc	Integer	—
67	OrigDocAmt	Decimal	—
68	PayDate	DateTime	—
69	PayHoldDesc	Text[30]	—
70	PC_Status	Text[1]	—
71	PerClosed	Text[6]	—
72	PerEnt	Text[6]	—
73	PerPost	Text[6]	—
74	PmtAmt	Decimal	—
75	PmtID	Text[10]	—
76	PmtMethod	Text[1]	—
77	PONbr	Text[10]	—
78	PrePay_RefNbr	Text[10]	—
79	ProjectID	Text[16]	—
80	RecordID	Integer	—
81	RefNbr	Text[10]	—
82	Retention	Integer	—
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	Selected	Integer	—
98	Status	Text[1]	—
99	Sub	Text[24]	—
100	Subcontract	Text[16]	—
101	TaxCntr00	Integer	—
102	TaxCntr01	Integer	—
103	TaxCntr02	Integer	—
104	TaxCntr03	Integer	—
105	TaxId00	Text[10]	—
106	TaxId01	Text[10]	—
107	TaxId02	Text[10]	—
108	TaxId03	Text[10]	—
109	TaxTot00	Decimal	—
110	TaxTot01	Decimal	—
111	TaxTot02	Decimal	—
112	TaxTot03	Decimal	—
113	Terms	Text[2]	—
114	TxblTot00	Decimal	—
115	TxblTot01	Decimal	—
116	TxblTot02	Decimal	—
117	TxblTot03	Decimal	—
118	User1	Text[30]	—
119	User2	Text[30]	—
120	User3	Decimal	—
121	User4	Decimal	—
122	User5	Text[10]	—
123	User6	Text[10]	—
124	User7	DateTime	—
125	User8	DateTime	—
126	VCVoidDocs	Integer	—
127	VendId	Text[15]	—
128	VendName	Text[60]	—

Keys

PK: Acct, Sub, DocType, RefNbr, RecordID (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. APDoc Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.