1. Tables and Views for SCM
  2. INV_ITEM_LOC_DEF_LINES_INT

INV_ITEM_LOC_DEF_LINES_INT

INV_ITEM_LOC_DEF_LINES_INT serves as an interface where all line defaults entered are validated under a header default through a scheduler job and defaults are posted to INV_ITEM_LOC_DEFAULTS Table.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

INV_ITEM_LOC_DEF_LINES_INT_PK

TXN_DEFAULTS_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
TXN_DEFAULTS_LINE_ID NUMBER 18 Yes This is the primary key for identifying the item transaction default interface lines.
TXN_DEFAULTS_HEADER_ID NUMBER 18 Yes This is the primary key for identifying item transaction defaults interface header.
BATCH_ID NUMBER 18 This indicates the batch in which the record has been loaded into the table.
ORGANIZATION_ID NUMBER 18 This identifies the inventory organization ID.
ORGANIZATION_CODE VARCHAR2 18 This identifies the inventory organization code.
ORGANIZATION_NAME VARCHAR2 240 This identifies the inventory organization name.
INVENTORY_ITEM_ID NUMBER 18 This identifies the inventory item ID.
ITEM_NUMBER VARCHAR2 300 This identifies the inventory item number.
DEFAULT_TYPE VARCHAR2 30 Code that indicates the default type.
DEFAULT_TYPE_MEANING VARCHAR2 80 Meaning that indicates the default type.
SUB_DEFAULT VARCHAR2 11 This identifies both Subinventory and Locator defaults. It will be populated with 11 zeroes for Subinventory defaults and Subinventory code for Locator defaults.
OLD_SUBINVENTORY_CODE VARCHAR2 10 This is name of the existing subinventory.
OLD_LOCATOR_ID NUMBER 18 This identifies the existing item locator.
OLD_LOCATOR_NAME VARCHAR2 240 This is name of the existing locator which is a contatenation of the various segments of the locator KFF.
NEW_SUBINVENTORY_CODE VARCHAR2 10 This is name of the subinventory.
NEW_LOCATOR_ID NUMBER 18 This identifies the item locator.
NEW_LOCATOR_NAME VARCHAR2 240 This is name of the locator which is a contatenation of the various segments of the locator KFF.
STATUS_CODE VARCHAR2 18 This indicates the status of lines.
ERROR_CODE VARCHAR2 240 This indicates the code for error after processing.
ERROR_EXPLANATION VARCHAR2 240 This provides the meaning of the error after processing.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table Foreign Table Foreign Key Column
INV_ITEM_LOC_DEF_LINES_INT inv_item_loc_def_headers_int TXN_DEFAULTS_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
INV_ITEM_LOC_DEF_LINES_INT_U1 Unique Default TXN_DEFAULTS_LINE_ID
INV_ITEM_LOC_DEF_LINES_INT_U2 Unique Default TXN_DEFAULTS_HEADER_ID, TXN_DEFAULTS_LINE_ID