A.3 Column Properties

A.3 Column Properties

The following is not an exhaustive list of column properties. The following column properties are described to demonstrate concepts.

Domain:	PART_NUMBER
Business Name:	Inventory Part Number
Business Meaning:	Internally generated value to uniquely identify each part maintained in inventory. Numbers are assigned through a single program that is part of the inventory application (NEW_PART_NUMBER). Once assigned, a part number never changes.
Data Type:	CHARACTER
Length Boundaries:	Minimum and maximum are both 8.
Value Rules:	Character pattern requires that the first character identify the business area that owns responsibility for the part number. This must be the uppercase letter A, B, C, D, or E. The remaining seven digits are numerals from 0 to 9. All zeros are permitted.

Storage Name:	INVENTORY.PART_NUMBER
Business Meaning:	Primary key for this table
Domain Name:	PART_NUMBER
Property Rules:	UNIQUE

Storage Name:	INVENTORY_HISTORY.PART_NUMBER
Business Meaning:	Part of primary key for this table
Domain Name:	PART_NUMBER
Property Rules:	NOT NULL

Storage Name:	INVENTORY.TYPE
Business Meaning:	Identifies the type of part. The types that are described are critical manufacturing, general manufacturing, and business general operations.
Domain Name:	None
Business Name:	Inventory Type
Data Type:	CHARACTER
Length Boundaries:	1
Value Rules:	Must come from list of C, G, or O
Property Rules:	NOT NULL

Storage Name:	INVENTORY.UNIT_OF_MEASURE
Business Meaning:	Identifies unit of measure of a part in inventory. This determines the measurement of a minimum unit of the part used for ordering and supplying the part.
Domain Name:	None
Business Name:	Inventory Unit of Measure
Data Type:	CHARACTER
Length Boundaries:	1 to 3 characters
Value Rules:	Must come from list of approved unit of measures. This list is maintained in a separate table called APPROVED_UNIT_OF_MEASURES.
Property Rules:	NOT NULL

Storage Name:	INVENTORY.QUANTITY_ONHAND
Business Meaning:	The amount of a part that is currently on the shelf in the warehouse. The amount available to supply a requisition.
Domain Name:	None
Business Name:	Inventory Quantity Available
Data Type:	INTEGER
Length Boundaries:	Integer restrictions
Value Rules:	Must be in the range 0 to 100000
Property Rules:	NOT NULL

Storage Name:	INVENTORY.DO_NOT_ORDER_FLAG
Business Meaning:	This part number should not be reordered. It has been either discontinued or replaced by another part. Any inventory remaining can be requisitioned until it goes to zero.
Domain Name:	None
Business Name:	Inventory Do Not Order Flag
Data Type:	CHARACTER
Length Boundaries:	1 byte
Discrete Values:	D for do not order; blank for normal
Property Rules:	NOT NULL

Storage Name:	PURCHASE_ORDER.STATUS
Business Meaning:	Defines the current state of the order. It can be either in a state of placed, shipped, received, cancelled, or returned. Cancelled can only be used if not shipped. Returned means the product received was returned. Returns must be for all quantities received.
Domain Name:	None
Business Name:	Purchase Order Status
Data Type:	CHARACTER
Length Boundaries:	1 byte
Discrete Values:	P for placed, S for shipped, R for received, C for cancelled, and X for returned
Property Rules:	NOT NULL and not blank

Storage Name:	PURCHASE_ORDER.REASON
Business Meaning:	A text field that gives a short reason for cancelling an order or returning the parts received
Domain Name:	None
Business Name:	Purchase Order Cancel or Return Explanation
Data Type:	VARIABLE CHARACTER
Length Boundaries:	More than 5 bytes if present
Values:	Any text
Property Rules:	NULLS OK