Entity Definition

Logical Name : Carrier
Physical Name : PA_CRR

An external party and subtype of Vendor that transports merchandise and/or supply items from their source to the retail store and from the retail store back to their source.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CarrierID (FK)(PK) A unique system assigned identifier for the Carrier. ID_CRR Identity integer


Parent Entity Verb Phrase Child Entity
Carrier provides CarrierService
Carrier provides ShipMethod
Carrier defines CarrierStandardParcelSize
Carrier carries goods in ReceivingDocument
Carrier may be paid or billed through CarrierAccount
Carrier ships CustomerOrderShipment
Vendor can be a Carrier

Logical Views containing Carrier

Logical View
Logical 01000 - Item Description - Macro View
Logical 02130 - Item Inventory - Receiving View
Logical 02340 - Retail Transaction - Shipping View
Logical 06310 - Party - Role View