Table 47015 "SL Inventory"

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

Properties

Property	Value
Caption	SL Inventory
Access	Internal
DataClassification	CustomerContent
ObsoleteState	Pending
ObsoleteTag	28.0
ObsoleteReason	Replaced by table SL Inventory Buffer.

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	ABCCode	Text[2]	—
2	ApprovedVendor	Integer	—
3	AutoPODropShip	Integer	—
4	AutoPOPolicy	Text[2]	—
5	BMIDirStdCost	Decimal	—
6	BMIFOvhStdCost	Decimal	—
7	BMILastCost	Decimal	—
8	BMIPDirStdCost	Decimal	—
9	BMIPFOvhStdCost	Decimal	—
10	BMIPStdCost	Decimal	—
11	BMIPVOvhStdCost	Decimal	—
12	BMIStdCost	Decimal	—
13	BMIVOvhStdCost	Decimal	—
14	BOLCode	Text[10]	—
15	Buyer	Text[10]	—
16	ChkOrdQty	Text[1]	—
17	ClassID	Text[6]	—
18	COGSAcct	Text[10]	—
19	COGSSub	Text[24]	—
20	Color	Text[20]	—
21	CountStatus	Text[1]	—
22	Crtd_DateTime	DateTime	—
23	Crtd_Prog	Text[8]	—
24	Crtd_User	Text[10]	—
25	CuryListPrice	Decimal	—
26	CuryMinPrice	Decimal	—
27	CustomFtr	Integer	—
28	CycleID	Text[10]	—
29	Descr	Text[60]	—
30	DfltPickLoc	Text[10]	—
31	DfltPOUnit	Text[6]	—
32	DfltSalesAcct	Text[10]	—
33	DfltSalesSub	Text[24]	—
34	DfltShpnotInvAcct	Text[10]	—
35	DfltShpnotInvSub	Text[24]	—
36	DfltSite	Text[10]	—
37	DfltSOUnit	Text[6]	—
38	DfltWhseLoc	Text[10]	—
39	DirStdCost	Decimal	—
40	DiscAcct	Text[10]	—
41	DiscPrc	Text[1]	—
42	DiscSub	Text[31]	—
43	EOQ	Decimal	—
44	ExplInvoice	Integer	—
45	ExplOrder	Integer	—
46	ExplPackSlip	Integer	—
47	ExplPickList	Integer	—
48	ExplShipping	Integer	—
49	FOvhStdCost	Decimal	—
50	FrtAcct	Text[10]	—
51	FrtSub	Text[24]	—
52	GLClassID	Text[4]	—
53	InvtAcct	Text[10]	—
54	InvtID	Text[30]	—
55	InvtSub	Text[24]	—
56	InvtType	Text[1]	—
57	IRCalcPolicy	Text[1]	—
58	IRDaysSupply	Decimal	—
59	IRDemandID	Text[10]	—
60	IRFutureDate	DateTime	—
61	IRFuturePolicy	Text[1]	—
62	IRLeadTimeID	Text[10]	—
63	IRLinePtQty	Decimal	—
64	IRMinOnHand	Decimal	—
65	IRModelInvtID	Text[30]	—
66	IRRCycDays	Integer	—
67	IRSeasonEndDay	Integer	—
68	IRSeasonEndMon	Integer	—
69	IRSeasonStrtDay	Integer	—
70	IRSeasonStrtMon	Integer	—
71	IRServiceLevel	Decimal	—
72	IRSftyStkDays	Decimal	—
73	IRSftyStkPct	Decimal	—
74	IRSftyStkPolicy	Text[1]	—
75	IRSourceCode	Text[1]	—
76	IRTargetOrdMethod	Text[1]	—
77	IRTargetOrdReq	Decimal	—
78	IRTransferSiteID	Text[10]	—
79	ItemCommClassID	Text[10]	—
80	Kit	Integer	—
81	LastBookQty	Decimal	—
82	LastCost	Decimal	—
83	LastCountDate	DateTime	—
84	LastSiteID	Text[10]	—
85	LastStdCost	Decimal	—
86	LastVarAmt	Decimal	—
87	LastVarPct	Decimal	—
88	LastVarQty	Decimal	—
89	LCVarianceAcct	Text[10]	—
90	LCVarianceSub	Text[24]	—
91	LeadTime	Decimal	—
92	LinkSpecId	Integer	—
93	LotSerFxdLen	Integer	—
94	LotSerFxdTyp	Text[1]	—
95	LotSerFxdVal	Text[12]	—
96	LotSerIssMthd	Text[1]	—
97	LotSerNumLen	Integer	—
98	LotSerNumVal	Text[25]	—
99	LotSerTrack	Text[2]	—
100	LUpd_DateTime	DateTime	—
101	LUpd_Prog	Text[8]	—
102	LUpd_User	Text[10]	—
103	MaterialType	Text[10]	—
104	MaxOnHand	Decimal	—
105	MfgClassID	Text[10]	—
106	MfgLeadTime	Decimal	—
107	MinGrossProfit	Decimal	—
108	MoveClass	Text[10]	—
109	MSDS	Text[24]	—
110	NoteID	Integer	—
111	Pack	Text[6]	—
112	PDirStdCost	Decimal	—
113	PerNbr	Text[6]	—
114	PFOvhStdCost	Decimal	—
115	PPVAcct	Text[10]	—
116	PPVSub	Text[24]	—
117	PriceClassID	Text[6]	—
118	ProdMgrID	Text[10]	—
119	ProductionUnit	Text[6]	—
120	PStdCost	Decimal	—
121	PStdCostDate	DateTime	—
122	PVOvhStdCost	Decimal	—
123	ReordPt	Decimal	—
124	ReOrdPtCalc	Decimal	—
125	ReordQty	Decimal	—
126	ReOrdQtyCalc	Decimal	—
127	ReplMthd	Text[1]	—
128	RollupCost	Integer	—
129	RollupPrice	Integer	—
130	RvsdPrc	Integer	—
131	S4Future01	Text[30]	—
132	S4Future02	Text[30]	—
133	S4Future03	Decimal	—
134	S4Future04	Decimal	—
135	S4Future05	Decimal	—
136	S4Future06	Decimal	—
137	S4Future07	DateTime	—
138	S4Future08	DateTime	—
139	S4Future09	Integer	—
140	S4Future10	Integer	—
141	S4Future11	Text[10]	—
142	S4Future12	Text[10]	—
143	S4Future13	Text[10]	—
144	SafetyStk	Decimal	—
145	SafetyStkCalc	Decimal	—
146	Selected	Integer	—
147	SerAssign	Text[1]	—
148	Service	Integer	—
149	ShelfLife	Integer	—
150	Size	Text[10]	—
151	Source	Text[1]	—
152	Status	Text[1]	—
153	StdCost	Decimal	—
154	StdCostDate	DateTime	—
155	StkBasePrc	Decimal	—
156	StkItem	Integer	—
157	StkRvsdPrc	Decimal	—
158	StkTaxBasisPrc	Decimal	—
159	StkUnit	Text[6]	—
160	StkVol	Decimal	—
161	StkWt	Decimal	—
162	StkWtUnit	Text[6]	—
163	Style	Text[10]	—
164	Supplr1	Text[15]	—
165	Supplr2	Text[15]	—
166	SupplrItem1	Text[20]	—
167	SupplrItem2	Text[20]	—
168	TaskID	Text[32]	—
169	TaxCat	Text[10]	—
170	TranStatusCode	Text[2]	—
171	Turns	Decimal	—
172	UPCCode	Text[30]	—
173	UsageRate	Decimal	—
174	User1	Text[30]	—
175	User2	Text[30]	—
176	User3	Decimal	—
177	User4	Decimal	—
178	User5	Text[10]	—
179	User6	Text[10]	—
180	User7	DateTime	—
181	User8	DateTime	—
182	ValMthd	Text[1]	—
183	VOvhStdCost	Decimal	—
184	WarrantyDays	Integer	—
185	YTDUsage	Decimal	—

Keys

Key1: InvtID (clustered)

Deprecations

object: Pending 28.0 (#if not CLEANSCHEMA31), “Replaced by table SL Inventory Buffer.”

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

Across versionsobsolete pending since 28.0