Table 42824 "SL Hist. APTran 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]	Specifies the Account that the entry has been posted to. via Page 42802 “SL Hist. APTran Entries”
2	AcctDist	Integer	—
3	AlternateID	Text[30]	—
4	Applied_PPRefNbr	Text[10]	—
5	BatNbr	Text[10]	Specifies the Batch Number that the entry belongs to. via Page 42802 “SL Hist. APTran Entries”
6	BOMLineRef	Text[5]	—
7	BoxNbr	Text[2]	—
8	Component	Text[30]	—
9	CostType	Text[8]	—
10	CostTypeWO	Text[2]	—
11	CpnyID	Text[10]	Specifies the Company ID that the entry belongs to. via Page 42802 “SL Hist. APTran Entries”
12	Crtd_DateTime	DateTime	—
13	Crtd_Prog	Text[8]	—
14	Crtd_User	Text[10]	—
15	CuryId	Text[4]	—
16	CuryMultDiv	Text[1]	—
17	CuryPOExtPrice	Decimal	—
18	CuryPOUnitPrice	Decimal	—
19	CuryPPV	Decimal	—
20	CuryRate	Decimal	—
21	CuryTaxAmt00	Decimal	—
22	CuryTaxAmt01	Decimal	—
23	CuryTaxAmt02	Decimal	—
24	CuryTaxAmt03	Decimal	—
25	CuryTranAmt	Decimal	—
26	CuryTxblAmt00	Decimal	—
27	CuryTxblAmt01	Decimal	—
28	CuryTxblAmt02	Decimal	—
29	CuryTxblAmt03	Decimal	—
30	CuryUnitPrice	Decimal	—
31	DrCr	Text[1]	—
32	Employee	Text[10]	—
33	EmployeeID	Text[10]	—
34	Excpt	Integer	—
35	ExtRefNbr	Text[15]	—
36	FiscYr	Text[4]	—
37	InstallNbr	Integer	—
38	InvcTypeID	Text[10]	—
39	InvtID	Text[30]	—
40	JobRate	Decimal	—
41	JrnlType	Text[3]	—
42	Labor_Class_Cd	Text[4]	—
43	LCCode	Text[10]	—
44	LineId	Integer	—
45	LineNbr	Integer	—
46	LineRef	Text[5]	—
47	LineType	Text[1]	—
48	LUpd_DateTime	DateTime	—
49	LUpd_Prog	Text[8]	—
50	LUpd_User	Text[10]	—
51	MasterDocNbr	Text[10]	—
52	NoteID	Integer	—
53	PC_Flag	Text[1]	—
54	PC_ID	Text[20]	—
55	PC_Status	Text[1]	—
56	PerEnt	Text[6]	—
57	PerPost	Text[6]	Specifies the period that the entry was posted to. via Page 42802 “SL Hist. APTran Entries”
58	PmtMethod	Text[1]	—
59	POExtPrice	Decimal	—
60	POLineRef	Text[5]	—
61	PONbr	Text[10]	—
62	POQty	Decimal	—
63	POUnitPrice	Decimal	—
64	PPV	Decimal	—
65	ProjectID	Text[16]	Specifies the Project ID that the entry is associated with. via Page 42802 “SL Hist. APTran Entries”
66	Qty	Decimal	Specifies the quantity that was posted on the entry. via Page 42802 “SL Hist. APTran Entries”
67	QtyVar	Decimal	—
68	RcptLineRef	Text[5]	—
69	RcptNbr	Text[10]	—
70	RcptQty	Decimal	—
71	RecordID	Integer	—
72	RefNbr	Text[10]	Specifies the entry’s Reference Number via Page 42802 “SL Hist. APTran Entries”
73	Rlsed	Integer	Specifies the entry’s Released status. via Page 42802 “SL Hist. APTran Entries”
74	S4Future01	Text[30]	—
75	S4Future02	Text[30]	—
76	S4Future03	Decimal	—
77	S4Future04	Decimal	—
78	S4Future05	Decimal	—
79	S4Future06	Decimal	—
80	S4Future07	Date	—
81	S4Future08	Date	—
82	S4Future09	Integer	—
83	S4Future10	Integer	—
84	S4Future11	Text[10]	—
85	S4Future12	Text[10]	—
86	ServiceDate	Date	—
87	SiteId	Text[10]	—
88	SoLineRef	Text[5]	—
89	SOOrdNbr	Text[15]	—
90	SOTypeID	Text[4]	—
91	Sub	Text[24]	Specifies the Subaccount that the entry has been posted to. via Page 42802 “SL Hist. APTran Entries”
92	TaskID	Text[32]	Specifies the Task ID that the entry is associated with. via Page 42802 “SL Hist. APTran Entries”
93	TaxAmt00	Decimal	—
94	TaxAmt01	Decimal	—
95	TaxAmt02	Decimal	—
96	TaxAmt03	Decimal	—
97	TaxCalced	Text[1]	—
98	TaxCat	Text[10]	—
99	TaxId00	Text[10]	—
100	TaxId01	Text[10]	—
101	TaxId02	Text[10]	—
102	TaxId03	Text[10]	—
103	TaxIdDflt	Text[10]	—
104	TranAmt	Decimal	Specifies the Transaction Amount that was posted on the entry. via Page 42802 “SL Hist. APTran Entries”
105	TranClass	Text[1]	—
106	TranDate	Date	Specifies the entry’s Transaction Date. via Page 42802 “SL Hist. APTran Entries”
107	TranDesc	Text[30]	Specifies the entry’s Transaction Description. via Page 42802 “SL Hist. APTran Entries”
108	trantype	Text[2]	Specifies the Transaction Type that the entry belongs to. via Page 42802 “SL Hist. APTran Entries”
109	TxblAmt00	Decimal	—
110	TxblAmt01	Decimal	—
111	TxblAmt02	Decimal	—
112	TxblAmt03	Decimal	—
113	UnitDesc	Text[10]	—
114	UnitPrice	Decimal	Specifies the Unit Price that was posted on the entry. via Page 42802 “SL Hist. APTran Entries”
115	User1	Text[30]	—
116	User2	Text[30]	—
117	User3	Decimal	—
118	User4	Decimal	—
119	User5	Text[10]	—
120	User6	Text[10]	—
121	User7	Date	—
122	User8	Date	—
123	VendId	Text[15]	Specifies the Vendor ID that the entry is associated with. via Page 42802 “SL Hist. APTran Entries”
124	WONbr	Text[10]	—
125	WOStepNbr	Text[5]	—

Keys

PK: BatNbr, Acct, Sub, RefNbr, RecordID (clustered)
Key2: VendId, BatNbr, Acct, Sub, RefNbr

Pages and codeunits on this table

Page 42802 “SL Hist. APTran Entries” (source table)

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