DISTRIBUTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Distribution
Definition: Distribution is the parent table for distributions.
Table Type: ACTIVITY





Column Detail - DISTRIBUTION


Column Name Type Null? Definition
ATTENTION VARCHAR(100) Y Attention information.
COMMIT_DT_TM DATETIME Y Date & Time the distribution was committed.
CREATE_APPLCTX DOUBLE N The application context number from the record info block.
CREATE_DT_TM DATETIME N The date and time this row was created.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE N The registered (assigned) task number for the process that inserted the row.
DISTRIBUTION_ID DOUBLE N Primary Key
DISTRIBUTION_NBR VARCHAR(40) Y The system assigned number that appears on the distribution.
DISTRIBUTION_NBR_KEY VARCHAR(40) Y The distribution_nbr field in all uppercase.
FROM_LOCATION_CD DOUBLE N The location that will be distributing the inventory.
ISSUED_DT_TM DATETIME Y The date and time the distribution was issued.
OMF_SUCCESS_IND DOUBLE N The value of 0 or 1 indicates the success or failure of the respective OMF table update. 1 indicates update to OMF table was successful and 0 indicates failure.
STATUS_CD DOUBLE N The status of the distribution.
TO_LOCATION_CD DOUBLE N The location which will be receiving the inventory.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DISTRIBUTION




Parent Column in DISTRIBUTION (PK) Child Table Name Child Column Name
Children: DISTRIBUTION_ID DIST_LINE_ITEM_R DISTRIBUTION_ID
DIST_REQ_R DISTRIBUTION_ID
MM_TRANS_HEADER DISTRIBUTION_ID


DIST_LINE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Distribution Line Detail
Definition: Detailed information for each line item on a distribution.
Table Type: ACTIVITY





Column Detail - DIST_LINE_DETAIL


Column Name Type Null? Definition
ACTUAL_FILL_LOC_CD DOUBLE N The actual location in which the item was picked.
ACTUAL_ITEM_ID DOUBLE N The actual item that was picked for distribution.
CREATE_APPLCTX DOUBLE N The application context number from the record info block.
CREATE_DT_TM DATETIME N The date and time the row was inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE N The registered (assigned) task number for the process that inserted the row.
DISTRIBUTION_ID DOUBLE N Foreign key to the distribution table.
DIST_LINE_APPROVED_FLAG DOUBLE N To verify that the distributed QOH is approved in IN-Transit Review window.The field holds either 1 or 0. The value 1 Indicates the distributed line is approved and the value 0 indicates it is not approved.
DIST_LINE_DETAIL_ID DOUBLE N Primary Key
LINE_ITEM_ID DOUBLE N Foreign key to the line item table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DIST_LINE_DETAIL


Child Column in DIST_LINE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID DIST_LINE_ITEM_R DISTRIBUTION_ID
LINE_ITEM_ID DIST_LINE_ITEM_R LINE_ITEM_ID
ACTUAL_ITEM_ID ITEM_MASTER ITEM_ID


DIST_LINE_ITEM_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Distribution Line Item
Definition: A relationship table between the Distribution and Line Item tables.
Table Type: ACTIVITY





Column Detail - DIST_LINE_ITEM_R


Column Name Type Null? Definition
BACKORDER_IND DOUBLE Y Back order indicator
CREATE_APPLCTX DOUBLE N The application context number from the record info block.
CREATE_DT_TM DATETIME N The date and time the row was inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE N The registered (assigned) task number for the process that inserted the row.
DISTRIBUTION_ID DOUBLE N Foreign key to the distribution table.
FROM_COST_CENTER_CD DOUBLE Y The cost center that the line item is coming from.
FROM_SUB_ACCOUNT_CD DOUBLE Y The sub account that the line item is coming from.
LINE_ITEM_ID DOUBLE N Foreign key to the line_item table.
TO_COST_CENTER_CD DOUBLE Y The cost center that will be charged for this line item.
TO_SUB_ACCOUNT_CD DOUBLE Y The sub account that will be charged for this line item.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DIST_LINE_ITEM_R


Child Column in DIST_LINE_ITEM_R(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID DISTRIBUTION DISTRIBUTION_ID
LINE_ITEM_ID LINE_ITEM LINE_ITEM_ID




Parent Column in DIST_LINE_ITEM_R (PK) Child Table Name Child Column Name
Children: DISTRIBUTION_ID DIST_LINE_DETAIL DISTRIBUTION_ID
LINE_ITEM_ID DIST_LINE_DETAIL LINE_ITEM_ID


DIST_REQ_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Defines a relationship between a distribution and requisition.
Definition: Distribution / Requisition Relationship
Table Type: ACTIVITY





Column Detail - DIST_REQ_R


Column Name Type Null? Definition
DISTRIBUTION_ID DOUBLE N Unique system identifier for a distribution.
REQUISITION_ID DOUBLE N Unique system identifier for a requisition.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DIST_REQ_R


Child Column in DIST_REQ_R(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID DISTRIBUTION DISTRIBUTION_ID
REQUISITION_ID REQUISITION REQUISITION_ID


MM_APPROVAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM APPROVAL
Definition: Contains the different approval profiles.
Table Type: REFERENCE





Column Detail - MM_APPROVAL


Column Name Type Null? Definition
APPROVAL_AMOUNT DOUBLE Y Amount up to which a person can approve.
APPROVAL_LEVEL DOUBLE Y Approval level assigned to each approver depending on the allocated amount.
APPROVAL_LINE_ID DOUBLE N Primary Key
CLASS_NODE_ID DOUBLE N Foreign key to class node table.
COST_CENTER_CD DOUBLE N Cost center code value
CREATE_APPLCTX DOUBLE N The application context number from the record info block.
CREATE_DT_TM DATETIME N The date and time the row was was inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE N The registered (assigned) task number for the process that inserted the row.
DESCRIPTION VARCHAR(40) Y Approval description.
MIN_APPROVAL_AMOUNT DOUBLE Y Minimum approval amount.
MM_APPROVAL_ID DOUBLE N Group key, set of approval lines.
MM_APPROVAL_IND DOUBLE Y Set to 1 as an approval default. Set to 0 otherwise. Used to recognize a regular approval from a default one.
ORGANIZATION_ID DOUBLE N The organization that the approval is tied too. Foreign key to organization table.
PRSNL_ID DOUBLE N Foreign key, the prsnl_id of the person from the personnel table (prsnl)
SKIP_IND DOUBLE Y Indicates the corresponding user or person as the approver.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VALIDATION_IND DOUBLE Y Used to determine if a password validation is required for an approver.



Relationship Detail - MM_APPROVAL


Child Column in MM_APPROVAL(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRSNL_ID PRSNL PERSON_ID