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 |