Table 5700 Stockkeeping Unit

Base Application, Microsoft.Inventory.Location

92 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
5420Scheduled Receipt (Qty.)Decimalgone after 25
5421Scheduled Need (Qty.)Decimalgone after 25
Pending, tag 18.0, obsolete since 18: Use the field 'Qty. on Component Lines' instead
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
5901Qty. on Service OrderDecimalgone after 24
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
99000750Routing No.Code[20]18 to 25
99000751Production BOM No.Code[20]18 to 25
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
99000765Planned Order Receipt (Qty.)Decimalgone after 25
99000766FP Order Receipt (Qty.)Decimalgone after 25
99000767Rel. Order Receipt (Qty.)Decimalgone after 25
99000769Planned Order Release (Qty.)Decimalgone after 25
99000770Purch. Req. Receipt (Qty.)Decimal17-29
99000771Purch. Req. Release (Qty.)Decimal17-29
99000777Qty. on Prod. OrderDecimalgone after 25
99000778Qty. on Component LinesDecimalgone after 25
99000779Single-Lvl Mat. Non-Invt. CostDecimalnew in 27