PHYS_COUNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Physical Count
Definition: The header table for physical inventories for a location.
Table Type: ACTIVITY





Column Detail - PHYS_COUNT


Column Name Type Null? Definition
COMPLETED_DT_TM DATETIME Y The date that the count was completed.
COUNT_COMMIT_PRSNL_ID DOUBLE N The personnel that committed the count.
COUNT_TYPE_FLAG DOUBLE N Indicates if the count was created by the sheet level or by locator level.
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 last inserted or updated.
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(100) Y The user defined description associated with this count.
LOCATION_CD DOUBLE N The location that the physical count is taking place.
MANUAL_COUNT_TYPE_FLAG DOUBLE N Indicates if the manual count is for Perpetual items, Non-Perpetual items, or both.
PHYS_COUNT_ID DOUBLE N Primary Key
SORT_FIELD1 VARCHAR(12) Y Used to store the sort sequence for the count sheets.
SORT_FIELD2 VARCHAR(12) Y Used to store the sort sequence for the count sheets.
SORT_FIELD3 VARCHAR(12) Y Used to store the sort sequence for the count sheets.
SORT_FIELD4 VARCHAR(12) Y Used to store the sort sequence for the count sheets.
SORT_FIELD5 VARCHAR(12) Y Used to store the sort sequence for the count sheets.
STATUS_CD DOUBLE N The status of the count.
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.
VERIFIED_BY VARCHAR(100) Y The free-text name of the person responsible for verification.
VERIFIED_BY_ID DOUBLE N The internal ID of the person responsible for verification.



Relationship Detail - PHYS_COUNT


Child Column in PHYS_COUNT(FK) Parent Table Name Parent Column Name
Parents: COUNT_COMMIT_PRSNL_ID PRSNL PERSON_ID




Parent Column in PHYS_COUNT (PK) Child Table Name Child Column Name
Children: PHYS_COUNT_ID PHYS_COUNT_SHEET PHYS_COUNT_ID


PHYS_COUNT_SHEET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Physical Count Sheet
Definition: In the mmPhysicalCount application, the count is created. This sheet is a part of the overal required physical count, assigned to a specific personnel.
Table Type: ACTIVITY





Column Detail - PHYS_COUNT_SHEET


Column Name Type Null? Definition
ASSIGNED_DT_TM DATETIME Y The date that this specific sheet was assigned to someone.
ASSIGNED_TO VARCHAR(100) Y The free-text name of the person responsible for counting this sheet.
ASSIGNED_TO_ID DOUBLE N The ID from the prsnl table of the person responsible for counting this sheet.
COMPLETED_DT_TM DATETIME Y The date that the count for this sheet was completed.
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.
DESCRIPTION VARCHAR(100) Y A user defined description for this sheet.
PHYS_COUNT_ID DOUBLE N Foreign key to phys_count table.
SHEET_NBR DOUBLE N The sheet number. Also part of the primary key.
SHEET_STATUS_CD DOUBLE N Stores the sheet status.
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.
VERIFIED_BY VARCHAR(100) Y The free-text name of the person who verified this sheet.
VERIFIED_BY_ID DOUBLE N The ID from the prsnl table of the person who verified this sheet.



Relationship Detail - PHYS_COUNT_SHEET


Child Column in PHYS_COUNT_SHEET(FK) Parent Table Name Parent Column Name
Parents: PHYS_COUNT_ID PHYS_COUNT PHYS_COUNT_ID




Parent Column in PHYS_COUNT_SHEET (PK) Child Table Name Child Column Name
Children: PHYS_COUNT_ID PHYS_COUNT_SHEET_ITEM PHYS_COUNT_ID
SHEET_NBR PHYS_COUNT_SHEET_ITEM SHEET_NBR


PHYS_COUNT_SHEET_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Physical Count Sheet Item
Definition: Stores the items that will be counted on the physical count sheet.
Table Type: ACTIVITY





Column Detail - PHYS_COUNT_SHEET_ITEM


Column Name Type Null? Definition
ABC_CLASS_CD DOUBLE N The ABC classification for the item.
AVERAGE_COST_AMT DOUBLE N Average cost of the item while the physical count sheet is committed.
BUILD_IND DOUBLE Y Indicates whether or not the location records will need to be created.
COMMIT_IND DOUBLE N Indicates whether or not an adjustment transaction has been performed.
COUNT_QTY DOUBLE Y The quantity that was counted.
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE N Task which created this row
ITEM_ID DOUBLE N Foreign key to item_master table.
LAST_COST_AMT DOUBLE N Laswt cost of the item while the physical count sheet is committed.
LAST_COUNT_DT_TM DATETIME Y The last date that this item was counted for this sheet.
LINE_NBR DOUBLE Y The line number for this sheet.
LOCATION_CD DOUBLE N Location
LOCATOR_CD DOUBLE N The physical location where the item is kept.
MULTIPLE_IND DOUBLE Y Indicates that an item exists on more than one sheet for the same package type but different locators.
PACKAGE_TYPE_ID DOUBLE N A foreign key to the package type table. This is the package that is being counted.
PERPETUAL_IND DOUBLE N Indicates if this item is defined as Perpetual or Non-Perpetual for this count.
PHYS_COUNT_ID DOUBLE N Foreign Key
QOH_QTY DOUBLE Y The quantity-on-hand that was present when the count was started.
SHEET_NBR DOUBLE N Value that depicts the sheet the item is assigned on.
SORT_VALUE1 VARCHAR(200) Y Sort Value
SORT_VALUE2 VARCHAR(200) Y Sort Value
SORT_VALUE3 VARCHAR(200) Y Sort Value
SORT_VALUE4 VARCHAR(200) Y Sort Value
SORT_VALUE5 VARCHAR(200) Y Sort Value
SORT_VALUE_KEY1 VARCHAR(200) Y Sort Value Key
SORT_VALUE_KEY2 VARCHAR(200) Y Sort Value Key
SORT_VALUE_KEY3 VARCHAR(200) Y Sort Value Key
SORT_VALUE_KEY4 VARCHAR(200) Y Sort Value Key
SORT_VALUE_KEY5 VARCHAR(200) Y Sort Value Key
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 - PHYS_COUNT_SHEET_ITEM


Child Column in PHYS_COUNT_SHEET_ITEM(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
PHYS_COUNT_ID PHYS_COUNT_SHEET PHYS_COUNT_ID
SHEET_NBR PHYS_COUNT_SHEET SHEET_NBR