Uses the Component:PartsInventoryLineType
The Line component represents the detail information related to the Parts inventory transaction. At least one Line is required for each Header
Table 6.9. Fields and Components
| Name | Description | Occurrence | Type | Data Type | User Notes |
|---|---|---|---|---|---|
| ItemID |
Deprecated: Use ItemID from PartsProductItem | 0..1 | Field | udt:IdentifierType | |
| QuantityOnHand |
Deprecated: Use PartQuantityGroup below. The quantity of part currently in inventory. | 0..1 | Field | sqdt:QuantityType | |
| QuantitySold |
Deprecated: Use PartQuantityGroup below. Quantity of part sold since last inventory. | 0..1 | Field | sqdt:QuantityType | |
| QuantityOfLostSale |
Deprecated: Use PartQuantityGroup below. Potential quantity of sales lost due to non-inventory since last inventory. | 0..1 | Field | sqdt:QuantityType | |
| PartClassCode |
Gifts, literature, keys, regular parts Inventory Class code (if any) used in DMS system. | 0..1 | Field | udt:CodeType | |
| QuantityOnOrder |
Deprecated: Use PartQuantityGroup below. Quantity of all outstanding orders not received into inventory. | 0..1 | Field | sqdt:QuantityType | |
| QuantityReOrderPoint |
Deprecated: Use PartQuantityGroup below. Quantity that triggers dealer's reordering of part. | 0..1 | Field | sqdt:QuantityType | |
| QuantityTwelveMonthSales |
Deprecated: Use PartQuantityGroup below. Quantity sold over last 12 months (rolling). | 0..1 | Field | sqdt:QuantityType | |
| BinLocation |
Dealer specific location of part. | 0..* | Field | udt:TextType | |
| QuantityTwelveMonthLostSales |
Deprecated: Use PartQuantityGroup below. Quantity of lost sales over last 12 months (rolling). | 0..1 | Field | sqdt:QuantityType | |
| BackOrderQuantity |
Deprecated: Use PartQuantityGroup below. Quantity of part on back order | 0..1 | Field | sqdt:QuantityType | |
| QuantityOfReturn |
Deprecated: Use PartQuantityGroup below. Quantity of part returned since last inventory. | 0..1 | Field | sqdt:QuantityType | |
| QuantityReserved |
Deprecated: Use PartQuantityGroup below. Quantity of part reserved for service. | 0..1 | Field | sqdt:QuantityType | |
| UnitPriceAmount |
UnitPrice | 0..1 | Field | udt:AmountType | |
| CorePriceAmount |
The Core Price of the given part | 0..1 | Field | udt:AmountType | |
| QuantityDealerPartStocking |
Deprecated: Use PartQuantityGroup below. Dealer defined quantity that is to be stocked above the manufacturer recommended stocking level of the part. | 0..1 | Field | sqdt:QuantityType | |
| MonthsNoSaleNumeric |
The number of months that a part has gone without a recorded sale - calculated on a calendar month basis. | 0..1 | Field | udt:NumericType | |
| QuantityAvailable |
Deprecated: Use PartQuantityGroup below. The quantity the dealer has available for release from inventory. It is traditionally defined as Quantity On Hand minus reserved or encumbered parts. | 0..1 | Field | sqdt:QuantityType | |
| ReplenishmentCode |
Alphanumeric code that signals manufacturer application if replenishment for the part is controlled by manufacturer (value 2) or by DMS (value 3). | 0..1 | Field | udt:CodeType | |
| LastSoldDate |
Last date this item was sold. | 0..1 | Field | udt:DateType | |
| QuantityUserMin |
Deprecated: Use PartQuantityGroup below. User-defined minimum stocking quantity for a part. | 0..1 | Field | sqdt:QuantityType | |
| QuantityUserMax |
Deprecated: Use PartQuantityGroup below. User-defined maximum stocking quantity for a part to be held in inventory. | 0..1 | Field | sqdt:QuantityType | |
| PartSourceCode |
Indicates the source of the part (e.g. M - Manufacturer) | 0..* | Field | udt:CodeType | |
| StockingStatusCode |
Code indicating if this is a normally stocked part for this dealer. | 0..1 | Field | udt:CodeType | |
| SystemSetupDate |
Date the part was first added to the dealer's inventory file. | 0..1 | Field | udt:DateType | |
| QuantityBestStockingLevel |
Deprecated: Use PartQuantityGroup below. The optimal quantity of a part to keep on-hand based on dealer specified parameters. | 0..1 | Field | sqdt:QuantityType | |
| AverageWeeklyUsageQuantity |
Deprecated: Use PartQuantityGroup below. The average weekly usage of a part as calculated by the dealer's DMS. | 0..1 | Field | sqdt:QuantityType | |
| Status | 0..* | Field | MinimumAcknowledgementStatusType | ||
| PartsProductItem |
The business information common to all parts. | 0..1 | Component | PartsProductItemType | |
| PartsForecasting |
The Parts Forecasting component is used for reporting of data values for forecasting algorithms. | 0..1 | Component | PartsForecastingType | |
| DealerParty |
Represents a Dealer | 0..1 | Component | PartyABIEType | |
| FreeFormTextGroup |
This component allows for the free form entry of notes and text descriptions. Detailed data should use one of the existing fields or submit a modification request back to STAR to capture the appropriate data. | 0..1 | Component | FreeFormTextGroupType | |
| OrderQuantityReceived |
Deprecated: Use PartQuantityGroup below. Quantity of parts on an order that was received into inventory. Value should be month to date receipts for the calendar month. | 0..1 | Field | sqdt:QuantityType | |
| LastReceiptDate |
Date the part number was last received into the DMS system. This date represents the last receipt date, not the entry/create date. | 0..1 | Field | udt:DateType | |
| DateOfLastOrder |
Date the part number was last ordered by the DMS system. This date represents the last order date for all order types regardless of open or closed orders. If Last Receipt date is not available. | 0..1 | Field | udt:DateType | |
| LastPhysicalInventoryDate |
Date the part was last physically counted/inventoried | 0..1 | Field | udt:DateType | |
| LastReceiptQuantity |
Deprecated: Use PartQuantityGroup below. The last receipt quantity. Not month to date, but the last receipt quantity for the part number. | 0..1 | Field | sqdt:QuantityType | |
| PartCostAmount |
The cost the dealer paid for the part | 0..1 | Field | udt:AmountType | |
| MinimumOrderQuantity |
Deprecated: Use PartQuantityGroup below. The number of items the dealer must order for the order to be processed. | 0..1 | Field | sqdt:QuantityType | |
| AveragePriceCost |
The average "quantity on hand" cost the dealer paid for the part | 0..1 | Field | udt:AmountType | |
| QuantityBinning |
Deprecated: Use PartQuantityGroup below. Quantity of part binning. | 0..1 | Field | udt:QuantityType | |
| QuantityInTransit |
Deprecated: Use PartQuantityGroup below. Quantity of part in transit. | 0..1 | Field | udt:QuantityType | |
| NumberOfPicks |
Deprecated: Use PartQuantityGroup below. Number of picks of a part since last inventory. | 0..1 | Field | udt:QuantityType | |
| FixedOrderQuantity |
Deprecated: Use PartQuantityGroup below. Fixed order quantity that the dealer orders when the reorder level is reached. | 0..1 | Field | udt:QuantityType | |
| PartParameters |
Part Parameters | 0..* | Component | PartParametersType | |
| QuantityAdjustmentDaily |
Deprecated: Use PartQuantityGroup below. Part quantity adjustments that is being removed from or added to the part inventory excluding sales or purchases for the day. | 0..1 | Field | udt:QuantityType | |
| QuantityAdjustmentDailyDescription |
Part adjustment type description that indicates why an adjustment was made. Example: loss, other, scrap. | 0..1 | Field | udt:TextType | |
| CustomerReservedQuantity |
Deprecated: Use PartQuantityGroup below. Part inventory quantity reserved for customers. | 0..1 | Field | udt:QuantityType | |
| ShipmentReservedQuantity |
Deprecated: Use PartQuantityGroup below. Part inventory quantity reserved for shipment. | 0..1 | Field | udt:QuantityType | |
| SpecialOrderQuantity |
Deprecated: Use PartQuantityGroup below. Part inventory quantity reserved for special orders. | 0..1 | Field | udt:QuantityType | |
| PartQuantityGroup |
This group is used to describe all of the quantity types in the PartsInventoryLine. | 0..* | Component | PartQuantityGroupType |
The XML Sample provided here is an approximation of the generated XML for this component. Not all of the fields are required for implementation.
Example 6.9. PartsInventoryLine
<PartsInventoryLine>
<ItemID>......</ItemID> [0..1]
<QuantityOnHand>......</QuantityOnHand> [0..1]
<QuantitySold>......</QuantitySold> [0..1]
<QuantityOfLostSale>......</QuantityOfLostSale> [0..1]
<PartClassCode>......</PartClassCode> [0..1]
<QuantityOnOrder>......</QuantityOnOrder> [0..1]
<QuantityReOrderPoint>......</QuantityReOrderPoint> [0..1]
<QuantityTwelveMonthSales>......</QuantityTwelveMonthSales> [0..1]
<BinLocation>......</BinLocation> [0..*]
<QuantityTwelveMonthLostSales>......</QuantityTwelveMonthLostSales> [0..1]
<BackOrderQuantity>......</BackOrderQuantity> [0..1]
<QuantityOfReturn>......</QuantityOfReturn> [0..1]
<QuantityReserved>......</QuantityReserved> [0..1]
<UnitPriceAmount>......</UnitPriceAmount> [0..1]
<CorePriceAmount>......</CorePriceAmount> [0..1]
<QuantityDealerPartStocking>......</QuantityDealerPartStocking> [0..1]
<MonthsNoSaleNumeric>......</MonthsNoSaleNumeric> [0..1]
<QuantityAvailable>......</QuantityAvailable> [0..1]
<ReplenishmentCode>......</ReplenishmentCode> [0..1]
<LastSoldDate>......</LastSoldDate> [0..1]
<QuantityUserMin>......</QuantityUserMin> [0..1]
<QuantityUserMax>......</QuantityUserMax> [0..1]
<PartSourceCode>......</PartSourceCode> [0..*]
<StockingStatusCode>......</StockingStatusCode> [0..1]
<SystemSetupDate>......</SystemSetupDate> [0..1]
<QuantityBestStockingLevel>......</QuantityBestStockingLevel> [0..1]
<AverageWeeklyUsageQuantity>......</AverageWeeklyUsageQuantity> [0..1]
<Status>......</Status> [0..*]
<PartsProductItem>......</PartsProductItem> [0..1]
<PartsForecasting>......</PartsForecasting> [0..1]
<DealerParty>......</DealerParty> [0..1]
<FreeFormTextGroup>......</FreeFormTextGroup> [0..1]
<OrderQuantityReceived>......</OrderQuantityReceived> [0..1]
<LastReceiptDate>......</LastReceiptDate> [0..1]
<DateOfLastOrder>......</DateOfLastOrder> [0..1]
<LastPhysicalInventoryDate>......</LastPhysicalInventoryDate> [0..1]
<LastReceiptQuantity>......</LastReceiptQuantity> [0..1]
<PartCostAmount>......</PartCostAmount> [0..1]
<MinimumOrderQuantity>......</MinimumOrderQuantity> [0..1]
<AveragePriceCost>......</AveragePriceCost> [0..1]
<QuantityBinning>......</QuantityBinning> [0..1]
<QuantityInTransit>......</QuantityInTransit> [0..1]
<NumberOfPicks>......</NumberOfPicks> [0..1]
<FixedOrderQuantity>......</FixedOrderQuantity> [0..1]
<PartParameters>......</PartParameters> [0..*]
<QuantityAdjustmentDaily>......</QuantityAdjustmentDaily> [0..1]
<QuantityAdjustmentDailyDescription>......</QuantityAdjustmentDailyDescription> [0..1]
<CustomerReservedQuantity>......</CustomerReservedQuantity> [0..1]
<ShipmentReservedQuantity>......</ShipmentReservedQuantity> [0..1]
<SpecialOrderQuantity>......</SpecialOrderQuantity> [0..1]
<PartQuantityGroup>......</PartQuantityGroup> [0..*]
</PartsInventoryLine>