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