Table 42829 "SL Hist. LotSerT 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	BatNbr	Text[10]	—
2	CpnyID	Text[10]	—
3	Crtd_DateTime	DateTime	—
4	Crtd_Prog	Text[8]	—
5	Crtd_User	Text[10]	—
6	CustID	Text[15]	—
7	ExpDate	Date	—
8	INTranLineID	Integer	—
9	INTranLineRef	Text[5]	—
10	InvtID	Text[30]	—
11	InvtMult	Integer	—
12	KitID	Text[30]	—
13	LineNbr	Integer	—
14	LotSerNbr	Text[25]	—
15	LotSerRef	Text[5]	—
16	LUpd_DateTime	DateTime	—
17	LUpd_Prog	Text[8]	—
18	LUpd_User	Text[10]	—
19	MfgrLotSerNbr	Text[25]	—
20	NoQtyUpdate	Integer	—
21	NoteID	Integer	—
22	ParInvtID	Text[30]	—
23	ParLotSerNbr	Text[25]	—
24	Qty	Decimal	—
25	RcptNbr	Text[10]	—
26	RecordID	Integer	—
27	RefNbr	Text[15]	—
28	Retired	Integer	—
29	Rlsed	Integer	—
30	S4Future01	Text[30]	—
31	S4Future02	Text[30]	—
32	S4Future03	Decimal	—
33	S4Future04	Decimal	—
34	S4Future05	Decimal	—
35	S4Future06	Decimal	—
36	S4Future07	Date	—
37	S4Future08	Date	—
38	S4Future09	Integer	—
39	S4Future10	Integer	—
40	S4Future11	Text[10]	—
41	S4Future12	Text[10]	—
42	ShipContCode	Text[20]	—
43	ShipmentNbr	Integer	—
44	SiteID	Text[10]	—
45	ToSiteID	Text[10]	—
46	ToWhseLoc	Text[10]	—
47	TranDate	Date	—
48	TranSrc	Text[2]	—
49	TranTime	Date	—
50	TranType	Text[2]	—
51	UnitCost	Decimal	—
52	UnitPrice	Decimal	—
53	User1	Text[30]	—
54	User2	Text[30]	—
55	User3	Decimal	—
56	User4	Decimal	—
57	User5	Text[10]	—
58	User6	Text[10]	—
59	User7	Date	—
60	User8	Date	—
61	WarrantyDate	Date	—
62	WhseLoc	Text[10]	—

Keys

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