Table Detail Report
MM_TEMPLATE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Supply Chain Template |
Definition: | Generic header information about a group of items that will need to be counted during an inventory. |
Table Type: | REFERENCE |
Column Detail - MM_TEMPLATE
Column Name | Type | Null? | Definition |
---|---|---|---|
ADU_OP_FLAG | DOUBLE | N | The criteria to use on ADU quantity when retrieving an item. |
ADU_QTY | DOUBLE | N | The threshold ADU to be retrieved. |
CYCLE_CNT_TYPE_CD | DOUBLE | N | The type of cycle count (random/reorder/custom). |
ITEM_DISTRIBUTION_FLAG | DOUBLE | N | Method used to distribute items into logical sheets. |
ITEM_TEMPLATE_ID | DOUBLE | N | The related template that contains a list of items. |
LOCATION_CD | DOUBLE | N | The location this template was created for. |
LOOKBACK_DAYS | DOUBLE | N | Number of days the system should look back to determine whether the item has been counted in past X days. Based off the number of days defined in this column, system would determine whether the items needs to be counted or not.. |
MAX_ITEM_QTY | DOUBLE | N | Maximum number of items to be included in this count. |
MM_TEMPLATE_ID | DOUBLE | N | Unique, generated number that identifies a single row on the MM_TEMPLATE table. |
SHEET_QTY | DOUBLE | N | If item_distribution_flag = 2, this will determine the number of logical sheets created. |
TEMPLATE_NAME | VARCHAR(255) | N | The name of the inventory template. |
TEMPLATE_NAME_KEY | VARCHAR(255) | N | The alphanumeric uppercase value of template name. |
TEMPLATE_NAME_KEY_A_NLS | VARCHAR(1020) | Y | TEMPLATE_NAME_KEY_A_NLS column |
TEMPLATE_NAME_KEY_NLS | VARCHAR(512) | N | The NLS value associated with the column template_name_key. |
TEMPLATE_TYPE_CD | DOUBLE | N | The type of template that this row contains information about. |
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 - MM_TEMPLATE
Child Column in MM_TEMPLATE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOCATION_CD | LOCATION | LOCATION_CD |
ITEM_TEMPLATE_ID | MM_TEMPLATE | MM_TEMPLATE_ID |
Parent Column in MM_TEMPLATE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MM_TEMPLATE_ID | MM_CYCLE_CNT_FILTER | MM_TEMPLATE_ID |
MM_TEMPLATE | ITEM_TEMPLATE_ID | ||
MM_TEMPLATE_ITEM | MM_TEMPLATE_ID |
MM_TEMPLATE_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Supply Chain Template Item |
Definition: | An item that needs to be counted in an inventory cycle. |
Table Type: | REFERENCE |
Column Detail - MM_TEMPLATE_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
ITEM_ID | DOUBLE | N | An inventory item contained within a template. |
ITEM_SEQ | DOUBLE | N | The order of the item in the template. |
MM_TEMPLATE_ID | DOUBLE | N | The template that an item is defined for. |
MM_TEMPLATE_ITEM_ID | DOUBLE | N | Unique, generated number that identifies a single row on the MM_TEMPLATE_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 - MM_TEMPLATE_ITEM
Child Column in MM_TEMPLATE_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ITEM_ID | ITEM_DEFINITION | ITEM_ID |
MM_TEMPLATE_ID | MM_TEMPLATE | MM_TEMPLATE_ID |
MM_TRANS_IDENTIFIER_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Transaction Identifier Relationship |
Definition: | Holds the barcode information for the performed transaction. |
Table Type: | ACTIVITY |
Column Detail - MM_TRANS_IDENTIFIER_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BARCODE_TXT | VARCHAR(255) | Y | The text for the item read from the barcode. |
LOT_NUMBER_ID | DOUBLE | Y | The lot number that the trans_line is related to. |
MM_TRANS_IDENTIFIER_RELTN_ID | DOUBLE | N | Unique generated number that defines a single row on the MM_TRANS_IDENTIFIER_RELTN table. |
MM_TRANS_LINE_ID | DOUBLE | Y | The transaction line associated to this serial number, lot number, or item identifier. |
SERIAL_NBR_TXT | VARCHAR(255) | Y | Serial number of the item. |
UPDT_APPLCTX | DOUBLE | Y | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | Y | 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | Y | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - MM_TRANS_IDENTIFIER_RELTN
Child Column in MM_TRANS_IDENTIFIER_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOT_NUMBER_ID | LOT_NUMBER_INFO | LOT_NUMBER_ID |
MM_TRANS_LINE_ID | MM_TRANS_LINE | MM_TRANS_LINE_ID |
MM_XFI_COST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MM XFI COST |
Definition: | Intermediate inbound interface table for importing item cost. Data is moved from this table to ITEM_LOCATION_COST. |
Table Type: | REFERENCE |
Column Detail - MM_XFI_COST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | N | Determines the action to be taken for this row. (1-Update/Insert,...) |
BATCH_GROUP_ID | DOUBLE | Y | Grouper TRANSACTION_ID for a set of MM_XFI_COST rows in order to perform batch processing on a subset of rows. |
BATCH_REF | VARCHAR(100) | Y | User defined field to identify this particular upload batch. |
CONTRIBUTOR | VARCHAR(40) | Y | The contributor |
CONTRIBUTOR_CD | DOUBLE | N | The contributor |
COST | DOUBLE | Y | The cost of the item. |
COST_TYPE | VARCHAR(40) | Y | The cost type (Average,Last,...) |
COST_TYPE_CD | DOUBLE | N | The cost type. |
CREATE_APPLCTX | DOUBLE | Y | The application context responsible for inserting the row. |
CREATE_DT_TM | DATETIME | Y | The Date/Time this row was inserted. |
CREATE_ID | DOUBLE | N | The ID of the person responsible for inserting this row. |
CREATE_TASK | DOUBLE | Y | The task responsible for inserting this row. |
ITEM_ID | DOUBLE | N | The internal item identifier. Primary Key |
ITEM_IDENTIFIER | VARCHAR(255) | Y | The identifier that will be used to validate against (item number, upn, ndc,...) |
ITEM_IDENTIFIER_TYPE | VARCHAR(40) | Y | Identifies the type of identifier passed in. |
ITEM_IDENTIFIER_TYPE_CD | DOUBLE | N | Identifies the type of identifier passed in. |
LOCATION | VARCHAR(100) | Y | The location name to build the record for. |
LOCATION_CD | DOUBLE | N | The codevalue for the location |
LOC_VIEW | VARCHAR(100) | Y | Currently not used. |
LOC_VIEW_CD | DOUBLE | N | Currently not used. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
ORGANIZATION | VARCHAR(100) | Y | The name of the organization in which the location resides. |
ORGANIZATION_ID | DOUBLE | N | Primary key for organization |
PKG_TYPE_CONV | DOUBLE | Y | The pack factor for the package type. |
PKG_TYPE_ID | DOUBLE | N | Primary key for package type |
PKG_TYPE_UOM | VARCHAR(40) | Y | The package type unit-of-measure. |
PKG_TYPE_UOM_CD | DOUBLE | N | The code value for the unit-of-measure. |
PROCESS_FLAG | DOUBLE | N | Indicates the import status of the row. |
SEGMENT_IDENTIFIER | VARCHAR(10) | N | Identifies the type of interface -- ILC |
SEGMENT_VERSION | VARCHAR(10) | N | The interface version |
TRANSACTION_ID | DOUBLE | N | Primary Key |
UPDATE_RULE_FLAG | DOUBLE | Y | Future use. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - MM_XFI_COST
Child Column in MM_XFI_COST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ITEM_ID | ITEM_DEFINITION | ITEM_ID |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
BATCH_GROUP_ID | MM_XFI_COST | TRANSACTION_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PKG_TYPE_ID | PACKAGE_TYPE | PACKAGE_TYPE_ID |
Parent Column in MM_XFI_COST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TRANSACTION_ID | MM_XFI_COST | BATCH_GROUP_ID |
MM_XFI_COST_BATCH | BATCH_GROUP_ID |
MM_XFI_COST_BATCH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Interface CostBatch |
Definition: | Used to group a set of MM_XFI_COST rows for batch processing. |
Table Type: | ACTIVITY |
Column Detail - MM_XFI_COST_BATCH
Column Name | Type | Null? | Definition |
---|---|---|---|
BATCH_GROUP_ID | DOUBLE | N | Stores the batch_id for a set of transactions |
BATCH_PROCESS_FLAG | DOUBLE | N | Stores the status of the batch, if the batch is processed the indicator will be set to 1 else it will be 0. |
MM_XFI_COST_BATCH_ID | DOUBLE | N | Unique generated number that identifies a single row on the MM_XFI_COST_BATCH table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - MM_XFI_COST_BATCH
Child Column in MM_XFI_COST_BATCH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BATCH_GROUP_ID | MM_XFI_COST | TRANSACTION_ID |