Entity Definition

Logical Name : OrderDocument
Physical Name : DO_ICD_OR

A type of InventoryControlDocument that is a record of agreement made with a supplier that includes a detailed list of retail items, cost discount terms, method of shipping, delivery dates, delivery location and other pertinent terms and conditions governing the acquisition.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
InventoryControlDocumentID (FK)(PK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD Identity integer
BuyerID The BUYER_ID specifies the corporate buyer responsible for the purchase of merchandise specified in the order document. ID_BYR Identity integer
OrderTypeCode A code to denote the type of purchase order, eg close out, consignment, etc. This code relates to the UCC Purchase Order Type Code, Data Element 92. TY_ORD Code2 char(2)
OrderEventTypeCode A code that characterizes an order based on the event causing its creation. Examples include orders generated on a regular basis, orders generated as part of a promotion and orders generated for a season. TY_EV_ORD Code2 char(2)


Parent Entity Verb Phrase Child Entity
InventoryControlDocument can be a OrderDocument

Logical Views containing OrderDocument

Logical View
Logical 02100 - Item Inventory - Macro View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 07620 - Customer Order - Inventory Control View