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 |