Table 5700 Stockkeeping Unit

Base Application, Microsoft.Inventory.Location

81 fields

IdNameTypeVersions
1Item No.Code[20]17-29
2Variant CodeCode[10]17-29
3Location CodeCode[10]17-29
4DescriptionText[100]17-29
5Description 2Text[50]17-29
6Assembly BOMBoolean17-29
12Shelf No.Code[10]17-29
22Unit CostDecimal17-29
24Standard CostDecimal17-29
25Last Direct CostDecimal17-29
31Vendor No.Code[20]17-29
32Vendor Item No.Text[50]17-29
33Lead Time CalculationDateFormula17-29
34Reorder PointDecimal17-29
35Maximum InventoryDecimal17-29
36Reorder QuantityDecimal17-29
53CommentBoolean17-29
62Last Date ModifiedDate17-29
64Date FilterDate17-29
65Global Dimension 1 FilterCode[20]17-29
66Global Dimension 2 FilterCode[20]17-29
68InventoryDecimal17-29
84Qty. on Purch. OrderDecimal17-29
85Qty. on Sales OrderDecimal17-29
89Drop Shipment FilterBoolean17-29
910Assembly PolicyEnum "Assembly Policy"17-29
977Qty. on Assembly OrderDecimal17-29
978Qty. on Asm. ComponentDecimal17-29
1001Qty. on Job OrderDecimal17-29
5400Transfer-Level CodeInteger17-29
5401Lot SizeDecimal17-29
5404Rolled-up Material CostDecimalnew in 26
5405Rolled-up Capacity CostDecimalnew in 26
5407Scrap %Decimalnew in 26
5408Rolled-up Mat. Non-Invt. CostDecimalnew in 26
5410Discrete Order QuantityInteger17-29
5411Minimum Order QuantityDecimal17-29
5412Maximum Order QuantityDecimal17-29
5413Safety Stock QuantityDecimal17-29
5414Order MultipleDecimal17-29
5415Safety Lead TimeDateFormula17-29
5416Components at LocationCode[10]17-29
5417Flushing MethodEnum "Flushing Method"17-25, 27-29
5419Replenishment SystemEnum "Replenishment System"17-29
5423Bin FilterCode[20]17-29
5428Time BucketDateFormula17-29
5440Reordering PolicyEnum "Reordering Policy"17-29
5441Include InventoryBoolean17-29
5442Manufacturing PolicyEnum "Manufacturing Policy"17-29
5443Rescheduling PeriodDateFormula17-29
5444Lot Accumulation PeriodDateFormula17-29
5445Dampener PeriodDateFormula17-29
5446Dampener QuantityDecimal17-29
5447Overflow LevelDecimal17-29
5448Plan Minimal SupplyBooleannew in 24
5700Transfer-from CodeCode[10]17-29
5701Qty. in TransitDecimal17-29
5702Trans. Ord. Receipt (Qty.)Decimal17-29
5703Trans. Ord. Shipment (Qty.)Decimal17-29
7301Special Equipment CodeCode[10]17-29
7302Put-away Template CodeCode[10]17-29
7307Put-away Unit of Measure CodeCode[10]17-29
7380Phys Invt Counting Period CodeCode[10]17-29
7381Last Counting Period UpdateDate17-29
7383Last Phys. Invt. DateDate17-29
7384Use Cross-DockingBoolean17-29
7385Next Counting Start DateDate17-29
7386Next Counting End DateDate17-29
9110Qty. on Blanket Sales OrderDecimalnew in 28
9210Qty. on Blanket Purch. OrderDecimalnew in 28
99000752Single-Level Material CostDecimalnew in 27
99000753Single-Level Capacity CostDecimalnew in 27
99000754Single-Level Subcontrd. CostDecimalnew in 27
99000755Single-Level Cap. Ovhd CostDecimalnew in 27
99000756Single-Level Mfg. Ovhd CostDecimalnew in 27
99000758Rolled-up Subcontracted CostDecimalnew in 27
99000759Rolled-up Mfg. Ovhd CostDecimalnew in 27
99000760Rolled-up Cap. Overhead CostDecimalnew in 27
99000770Purch. Req. Receipt (Qty.)Decimal17-29
99000771Purch. Req. Release (Qty.)Decimal17-29
99000779Single-Lvl Mat. Non-Invt. CostDecimalnew in 27