1. Tables and Views for SCM
  2. ACN_REQ_LINE_ITEM_INT

ACN_REQ_LINE_ITEM_INT

Requirement Line Items Interface table to support Bulk Import

Details

  • Schema: FUSION

  • Object owner: ACN

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

ACN_REQ_LINE_ITEM_INT_PK

REQUIREMENT_LINE_ITEM_ID

Columns

Name Datatype Length Precision Not-null Comments
REQUIREMENT_LINE_ITEM_ID NUMBER 18 Yes Requirement line item id value for the requirement line item interface table.
SCOPE VARCHAR2 30 Scope value for the requirement line item interface table.
OBJECT_ID NUMBER 18 Object id value for the requirement line item interface table.
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.
NAME VARCHAR2 400 Yes Name value for the requirement line item interface table.
REQUIREMENT_VERSION_ID NUMBER 18 Yes Requirement version id value for the requirement line item interface table.
PARENT_LINE_ITEM_ID NUMBER 18 Parent line item id value for the requirement line item interface table.
SECTION_CODE VARCHAR2 400 Section code value for the requirement line item interface table.
SECTION_NUMBER VARCHAR2 400 Section number value for the requirement line item interface table.
PRIORITY VARCHAR2 1000 Priority value for the requirement line item interface table.
FULFILLED VARCHAR2 1000 Fulfilled value for the requirement line item interface table.
ESTIMATES NUMBER 18 Estimates value for the requirement line item interface table.
CONTENT CLOB Content value for the requirement line item interface table.
DESCRIPTION VARCHAR2 1000 Description value for the requirement line item interface table.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SEQ_NO NUMBER For every record of data that will be inserted into the interface table SEQ_NO will be populated.
INTERFACE_ROW_ID NUMBER 18 INTERFACE_ROW_ID is the unique identifier for the record with in a batch.
IMPORT_STATUS_CODE VARCHAR2 1000 IMPORT_STATUS_CODE tells status of a row in the interface table.
ACTION_CODE VARCHAR2 1000 ACTION_CODE in interface table allows source system to specify a particular operation (insert, update, etc) for a row.
INTERNAL_ACTION_CODE VARCHAR2 1000 This column is created for internal use and will be populated and used by bulk import logic.
LOAD_REQUEST_ID NUMBER 18 When Data file uploaded and click on submit that time the load request Id generated.

Indexes

Index Uniqueness Tablespace Columns
ACN_REQ_LINE_ITEM_INT_U1 Unique Default REQUIREMENT_LINE_ITEM_ID