Logical 02100 - Item Inventory - Macro View

Top  Previous  Next

Subject Area Concepts

The Logical 02100 - Item Inventory - Macro View subject area contains the entities relating to item movement through the back door of the store as  well as into and out of distribution centers.  All the data within this view relates primarily to the use of documents, generically referred to as Inventory Control Documents (ICDs).  These documents can be categorized into two main types:

Advisory documents, which informs the enterprise of impending deliveries or provide permission for transfers or returns; and

Transactional documents, which list the inventory items. These documents provide a contractual commitment between the Supplier and the enterprise.

The Logical 02100 subject area contains the entities that identify and describe inventory orders, receipts and transfers.  The Inventory Control Document Types for Product Movement table lists the different kinds of documentation represented in the ARTS data model.  These documents contain similar line item data, the difference being denoted by the document header. In future the documents may be merged into one InventoryControlDocument.

Inventory Control Document Types for Product Movement

Inventory Control Document Type

Description

Advisory Documents

Item Receipt Advice Documents

Freight Bill

Originated by the Carrier. Identifies the number of containers to be delivered.

Advanced Shipping Notice (ASN)

Originated by the Supplier (and typically transmitted to the Retail Store). Advises the store the number of containers to be delivered and when. Each container can normally be exploded into a listing by Item.

Packing Slip

Originated by the Supplier and accompanies the receipt. Lists by line item the receipt contents.

Order Document

Originated by the Retail Store. (or corporate office on its behalf). Lists the Items required by the store. An order occasionally results in an order confirmation being sent from the Supplier.

Return Authorization Request

Originated by the Retail Store. Requests permission to transfer Items to another Retail Store or return Items to the Supplier.

Request for Debit/Credit

Originated by the Retail Store. Requests debit or credit whenever there is an Item overage or shortage respectively.

Transaction

Receiving Document

 

Originated by the Retail Store. Contains the Items received by the Retail Store.

Transfers

Transfer In

Originated by the Retail Store. Contains the Items received by the Retail Store from a Facility.

Transfer Out

Originated by the Retail Store. Contains the Items transferred to a Facility from the Retail Store

Return to Vendor

 

Originated by the Retail Store. Contains the Items transferred to the Supplier.

Each InventoryControlDocument is made up of InventoryControlDocumentLineItems. This view has identified five different types:

ICDMerchandiseLlineItem which records the exchange in ownership of the StockItem;

ICDFreightLineItem which records the charge made to ship the StockItem to the BusinessUnit;

ICDChargeLineItem that contains any surcharges applied by the Supplier for that StockItem, for example: special handling, insurance, labeling, koshering.  These charges are normally denoted by a UCC defined code;

ICDTaxLineItem which contains any sales or excise taxes relating to the StockItem; and

ICDAllowanceLineItem that contains any special discount or incentive pertaining to that StockItem.

The ICDMerchandiseLineItem is "posted" to through the ItemInventoryJournalEntry, which in turn updates the ItemInventory to provide the current inventory on hand.  All the other line item types are similarly captured as journal entries and will be included within the cost of sales relating to that StockItem.

With the addition of supply-side taxation in the data model, the merchandise line item has gained a side-kick entity called ICDMerchandiseTaxLineItem, which in conjunction with the ICDTaxLineItem allows the sales and excise taxes paid on the supply side of the enterprise on either a per-line item or per inventory control document basis.