INST_INTERFACE_ID |
NUMBER |
|
Yes |
Instance Interface ID |
SOURCE_SYSTEM_NAME |
VARCHAR2 |
30 |
Yes |
Source System Name from CSI_INTERFACE_SOURCES |
PARALLEL_WORKER_ID |
NUMBER |
|
|
Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only. |
REPLACE_FLAG |
VARCHAR2 |
1 |
|
Flag which indicates if the item instance is replaced |
TRANSACTION_IDENTIFIER |
VARCHAR2 |
30 |
|
CSI Transaction identifier |
SOURCE_TRANSACTION_DATE |
DATE |
|
Yes |
Transaction Date that this Instance will be processed with the Open Interface. |
SOURCE_TRANSACTION_TYPE |
VARCHAR2 |
30 |
|
CSI Source transaction type |
INSTANCE_ID |
NUMBER |
|
|
Unique ID that identifies an item unit instance |
INSTANCE_NUMBER |
VARCHAR2 |
30 |
|
Functional User Key for Item Instance |
INSTANCE_DESCRIPTION |
VARCHAR2 |
240 |
|
Description of the item instance |
EXTERNAL_REFERENCE |
VARCHAR2 |
30 |
|
External reference given to item instance |
PROCESS_STATUS |
VARCHAR2 |
1 |
Yes |
Process Status for Instance. Value Values are 'R' Ready, 'E' Error, 'P' Processed |
BATCH_NAME |
VARCHAR2 |
30 |
|
Open interface batch name |
ERROR_TEXT |
VARCHAR2 |
2000 |
|
Error text for any errors that are encountered while processing each row of data. |
INVENTORY_ITEM_ID |
NUMBER |
|
|
Inventory Item Id for the instance you are interfacing |
INV_CONCATENATED_SEGMENTS |
VARCHAR2 |
250 |
|
Concatenated Segment for the instance you are interfacing |
INVENTORY_REVISION |
VARCHAR2 |
30 |
|
Inventory Revision for items that are revision controlled in Inventory |
INV_VLD_ORGANIZATION_ID |
NUMBER |
|
|
Validation Organization ID that is used for Validating the Inventory Attributes |
INV_VLD_ORGANIZATION_NAME |
VARCHAR2 |
250 |
|
Validation Organization Name that is used for Validating the Inventory Attributes |
SERIAL_NUMBER |
VARCHAR2 |
30 |
|
Serial Number for this Item Instance |
MFG_SERIAL_NUMBER_FLAG |
VARCHAR2 |
1 |
|
Manufacturer Serial Number Flag for this Instance. Valid values are Yes 'Y' or No 'N'. If this is set to Yes Install Base will validate the serial number against inventory otherwise it will not. |
LOT_NUMBER |
VARCHAR2 |
30 |
|
The Lot Number for the lot where this item will exist |
QUANTITY |
NUMBER |
|
|
Instance Quantity |
UNIT_OF_MEASURE_CODE |
VARCHAR2 |
3 |
|
Unit of Measure Code that will be used for this Instance (i.e. 'EA') |
UNIT_OF_MEASURE |
VARCHAR2 |
30 |
|
Unit of Measure that will be used for this Instance (i.e. 'Each') |
ACCOUNTING_CLASS_CODE |
VARCHAR2 |
30 |
|
Accounting Class Code |
INSTANCE_CONDITION_ID |
NUMBER |
|
|
Instance Condition ID |
INSTANCE_CONDITION |
VARCHAR2 |
30 |
|
Instance Condition Name |
INSTANCE_STATUS_ID |
NUMBER |
|
|
Instance Status ID |
INSTANCE_STATUS |
VARCHAR2 |
30 |
|
Instance Status Name |
CUSTOMER_VIEW_FLAG |
VARCHAR2 |
1 |
|
Flag that indicates if this is as per a customer definition |
MERCHANT_VIEW_FLAG |
VARCHAR2 |
1 |
|
Flag that indicates if this is as per a merchant definition |
SELLABLE_FLAG |
VARCHAR2 |
1 |
|
Flag that indicates if this instance is sellable |
SYSTEM_ID |
NUMBER |
|
|
System ID |
SYSTEM_NUMBER |
VARCHAR2 |
30 |
|
System Number |
INSTANCE_START_DATE |
DATE |
|
|
Active Start Date for this Instance |
INSTANCE_END_DATE |
DATE |
|
|
Active End Date for this Instance |
INSTANCE_TYPE_CODE |
VARCHAR2 |
30 |
|
Instance Type Code |
LOCATION_TYPE_CODE |
VARCHAR2 |
30 |
|
Location Type Code |
LOCATION_ID |
NUMBER |
|
|
Location ID |
INV_ORGANIZATION_ID |
NUMBER |
|
|
Inventory Organization ID |
INV_ORGANIZATION_CODE |
VARCHAR2 |
30 |
|
Inventory Organization Code |
INV_ORGANIZATION_NAME |
VARCHAR2 |
250 |
|
Inventory Organization Name |
INV_SUBINVENTORY_NAME |
VARCHAR2 |
250 |
|
Inventory Subinventory Name |
INV_LOCATOR_NUMBER |
VARCHAR2 |
30 |
|
Inventory Locator Number |
INV_LOCATOR_ID |
NUMBER |
|
|
Inventory Locator ID |
PROJECT_ID |
NUMBER |
|
|
Project ID |
PROJECT_NUMBER |
VARCHAR2 |
30 |
|
Project Number |
TASK_ID |
NUMBER |
|
|
Task ID |
TASK_NUMBER |
VARCHAR2 |
30 |
|
Task Number |
IN_TRANSIT_ORDER_LINE_ID |
NUMBER |
|
|
In Transit Order Line ID |
IN_TRANSIT_ORDER_LINE_NUMBER |
VARCHAR2 |
30 |
|
In Transit Order Line Number |
WIP_JOB_ID |
NUMBER |
|
|
WIP Job ID |
WIP_JOB_NAME |
VARCHAR2 |
250 |
|
WIP Job Name |
PO_ORDER_LINE_ID |
NUMBER |
|
|
Purchase Order Line ID |
PO_ORDER_LINE_NUMBER |
VARCHAR2 |
30 |
|
Purchase Order Line Number |
OE_ORDER_LINE_ID |
NUMBER |
|
|
Order Line ID |
OE_ORDER_LINE_NUMBER |
VARCHAR2 |
30 |
|
Order Line Number |
OE_RMA_LINE_ID |
NUMBER |
|
|
RMA Line Id |
OE_RMA_LINE_NUMBER |
VARCHAR2 |
30 |
|
RMA Line Number |
PO_PO_LINE_ID |
NUMBER |
|
|
Purchase Order Line ID |
PO_PO_LINE_NUMBER |
VARCHAR2 |
30 |
|
Purchase Order Line Number |
OE_PO_NUMBER |
VARCHAR2 |
50 |
|
Order Entry PO Number |
OE_AGREEMENT_ID |
NUMBER |
|
|
Order Entry Agreement ID |
INSTALL_LOCATION_TYPE_CODE |
VARCHAR2 |
30 |
|
Install Location Type Code |
INSTALL_LOCATION_ID |
NUMBER |
|
|
Install Location ID |
INSTALL_DATE |
DATE |
|
|
Install Date |
RETURN_BY_DATE |
DATE |
|
|
Return By Date |
ACTUAL_RETURN_DATE |
DATE |
|
|
Actual Return Date |
CONFIG_INST_HDR_ID |
NUMBER |
|
|
Configured item instance header id |
CONFIG_INST_REV_NUM |
NUMBER |
|
|
Configured item instance revision number |
CONFIG_INST_ITEM_ID |
NUMBER |
|
|
Configured item instance component item id |
CONFIG_VALID_STATUS |
VARCHAR2 |
30 |
|
Configured item instance status |
INSTANCE_OU_ID |
NUMBER |
|
|
Instance Organization Unit ID |
OPERATING_UNIT_NAME |
VARCHAR2 |
250 |
|
Operating Unit Name |
OPERATING_UNIT |
NUMBER |
|
|
Operating Unit Code |
OU_RELATION_TYPE |
VARCHAR2 |
30 |
|
Operating Unit Relationship Type |
OU_START_DATE |
DATE |
|
|
Operating Unit Active Start Date |
OU_END_DATE |
DATE |
|
|
Operating Unit Active End Date |
INSTANCE_CONTEXT |
VARCHAR2 |
30 |
|
Instance Flexfield Context |
LAST_UPDATE_DATE |
DATE |
|
Y |
Standard WHO column |
LAST_UPDATE_BY |
NUMBER |
15 |
Y |
Standard WHO column |
CREATION_DATE |
DATE |
|
Y |
Standard WHO column |
CREATED_BY |
NUMBER |
15 |
Y |
Standard WHO column |
LAST_UPDATE_LOGIN |
NUMBER |
15 |
|
Standard WHO column |
IP_INTERFACE_ID |
NUMBER |
|
Yes |
Instance Party Interface ID |
INST_INTERFACE_ID |
NUMBER |
|
Yes |
Instance Interface ID that will be used to link the rows in this table to its parent in CSI_INSTANCE_INTERFACE |
PARALLEL_WORKER_ID |
NUMBER |
|
|
Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only. |
ERROR_TEXT |
VARCHAR2 |
2000 |
|
Error text for any errors that are encountered while processing each row of data. |
PARTY_ID |
NUMBER |
|
|
Party ID |
PARTY_NUMBER |
VARCHAR2 |
30 |
|
Party Number |
INSTANCE_PARTY_ID |
NUMBER |
|
|
Instance Party ID |
PARTY_NAME |
VARCHAR2 |
250 |
|
Party Name |
PARTY_SOURCE_TABLE |
VARCHAR2 |
30 |
|
Party Source Table |
PARTY_RELATIONSHIP_TYPE_CODE |
VARCHAR2 |
30 |
|
Party Relationship Type Code |
PARTY_START_DATE |
DATE |
|
|
Party Active Start Date |
PARTY_END_DATE |
DATE |
|
|
Party Active End Date |
CONTACT_FLAG |
VARCHAR2 |
1 |
|
Primary Contact Flag |
CONTACT_IP_ID |
NUMBER |
|
|
Self Join Key to the Same Table (INSTANCE_PARTY_ID) |
CONTACT_PARTY_NUMBER |
VARCHAR2 |
30 |
|
Instance Party Contact Number |
CONTACT_PARTY_NAME |
VARCHAR2 |
250 |
|
Instance Party Contact Name |
CONTACT_PARTY_ID |
NUMBER |
|
|
Instance Party Contact ID |
CONTACT_PARTY_REL_TYPE |
VARCHAR2 |
30 |
|
Instance Party Contact Relationship Type |
PARTY_CONTEXT |
VARCHAR2 |
30 |
|
Party Flexfield Context |
IP_ACCOUNT1_ID |
NUMBER |
|
|
Instance Party Account Identifier |
PARTY_ACCOUNT1_NUMBER |
VARCHAR2 |
30 |
|
Party Account Number |
PARTY_ACCOUNT1_ID |
NUMBER |
|
|
Party Account ID |
ACCT1_RELATIONSHIP_TYPE_CODE |
VARCHAR2 |
30 |
|
Party Account Relationship Type Code |
PARTY_ACCT1_START_DATE |
DATE |
|
|
Party Active Start Date |
PARTY_ACCT1_END_DATE |
DATE |
|
|
Party Active End Date |
BILL_TO_ADDRESS1 |
NUMBER |
|
|
Bill to Address |
SHIP_TO_ADDRESS1 |
NUMBER |
|
|
Ship to Address |
ACCOUNT1_CONTEXT |
VARCHAR2 |
30 |
|
Party Account Flexfield Context |
IP_ACCOUNT2_ID |
NUMBER |
|
|
Instance Party Account Identifier |
PARTY_ACCOUNT2_NUMBER |
VARCHAR2 |
30 |
|
Party Account Number |
PARTY_ACCOUNT2_ID |
NUMBER |
|
|
Party Account ID |
ACCT2_RELATIONSHIP_TYPE_CODE |
VARCHAR2 |
30 |
|
Party Account Relationship Type Code |
PARTY_ACCT2_START_DATE |
DATE |
|
|
Party Account Active Start Date |
PARTY_ACCT2_END_DATE |
DATE |
|
|
Party Account Active End Date |
BILL_TO_ADDRESS2 |
NUMBER |
|
|
Bill to Address |
SHIP_TO_ADDRESS2 |
NUMBER |
|
|
Ship to Address |
ACCOUNT2_CONTEXT |
VARCHAR2 |
30 |
|
Party Account Flexfield Context |
IP_ACCOUNT3_ID |
NUMBER |
|
|
Instance Party Account Identifier |
PARTY_ACCOUNT3_NUMBER |
VARCHAR2 |
30 |
|
Party Account Number |
PARTY_ACCOUNT3_ID |
NUMBER |
|
|
Party Account ID |
ACCT3_RELATIONSHIP_TYPE_CODE |
VARCHAR2 |
30 |
|
Party Account Relationship Type Code |
PARTY_ACCT3_START_DATE |
DATE |
|
|
Party Account Active Start Date |
PARTY_ACCT3_END_DATE |
DATE |
|
|
Party Account Active End Date |
BILL_TO_ADDRESS3 |
NUMBER |
|
|
Bill to Address |
SHIP_TO_ADDRESS3 |
NUMBER |
|
|
Ship to Address |
ACCOUNT3_CONTEXT |
VARCHAR2 |
30 |
|
Party Account Flexfield Context |
LAST_UPDATE_DATE |
DATE |
|
Y |
Standard WHO column |
LAST_UPDATE_BY |
NUMBER |
15 |
Y |
Standard WHO column |
CREATION_DATE |
DATE |
|
Y |
Standard WHO column |
CREATED_BY |
NUMBER |
15 |
Y |
Standard WHO column |
LAST_UPDATE_LOGIN |
NUMBER |
15 |
|
Standard WHO column |
REL_INTERFACE_ID |
NUMBER |
|
Yes |
Relationship Interface ID |
PARALLEL_WORKER_ID |
NUMBER |
|
|
Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only. |
SUBJECT_INTERFACE_ID |
NUMBER |
|
|
Subject Interface ID |
OBJECT_INTERFACE_ID |
NUMBER |
|
|
Object Interface ID |
RELATIONSHIP_TYPE_CODE |
VARCHAR2 |
30 |
|
Relationship Type Code of this Instance to Instance Relationship (i.e. CONNECTEDTO) |
RELATIONSHIP_START_DATE |
DATE |
|
|
Active Start Date for the Instance to Instance Relationship. |
RELATIONSHIP_END_DATE |
DATE |
|
|
Active End Date for the Instance to Instance Relationship. |
POSITION_REFERENCE |
VARCHAR2 |
30 |
|
Position Reference of the Relationship |
DISPLAY_ORDER |
NUMBER |
|
|
Order in which the UI will display the relationships |
MANDATORY_FLAG |
VARCHAR2 |
1 |
|
Mandatory relationship indicator |
RELATIONSHIP_DIRECTION |
VARCHAR2 |
30 |
|
Relationship direction |
ERROR_TEXT |
VARCHAR2 |
2000 |
|
Error text for any errors that are encountered while processing each row of data. |
CONTEXT |
VARCHAR2 |
30 |
|
Standard Oracle DFF context field |
LAST_UPDATE_DATE |
DATE |
|
Y |
Standard WHO column |
LAST_UPDATE_BY |
NUMBER |
15 |
Y |
Standard WHO column |
CREATION_DATE |
DATE |
|
Y |
Standard WHO column |
CREATED_BY |
NUMBER |
15 |
Y |
Standard WHO column |
LAST_UPDATE_LOGIN |
NUMBER |
15 |
|
Standard WHO column |
IEAV_INTERFACE_ID |
NUMBER |
|
Yes |
Extended Attribute Interface ID |
INST_INTERFACE_ID |
NUMBER |
|
Yes |
Instance Interface ID that will be used to link the rows in this table to its parent in CSI_INSTANCE_INTERFACE |
PARALLEL_WORKER_ID |
NUMBER |
|
|
Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only. |
ERROR_TEXT |
VARCHAR2 |
2000 |
|
Error text for any errors that are encountered while processing each row of data. |
ATTRIBUTE_ID |
NUMBER |
|
|
Extended Attribute ID |
INV_CONCATENATED_SEGMENTS |
VARCHAR2 |
250 |
|
Concatenated Segment for the instance you are interfacing |
INVENTORY_ITEM_ID |
NUMBER |
|
|
Inventory Item Id for the instance you are interfacing |
MASTER_ORGANIZATION_ID |
NUMBER |
|
|
Master Organization Id for the instance you are interfacing |
MASTER_ORGANIZATION_NAME |
VARCHAR2 |
250 |
|
Master Organization Name for the instance you are interfacing |
ITEM_CATEGORY_CONC_SEG |
VARCHAR2 |
250 |
|
Instance Item Category for the Extended Attribute |
ITEM_CATEGORY_ID |
NUMBER |
|
|
Instance Item Category ID for the Extended Attribute |
ATTRIBUTE_CODE |
VARCHAR2 |
30 |
|
Attribute Code which this Extended Attribute is defined |
ATTRIBUTE_NAME |
VARCHAR2 |
50 |
|
Attribute Name which this Extended Attribute is defined |
ATTRIBUTE_LEVEL |
VARCHAR2 |
15 |
|
Attribute Level which this Extended Attribute is defined |
ATTRIBUTE_CATEGORY |
VARCHAR2 |
30 |
|
Attribute Category which this Extended Attribute is defined |
ATTRIBUTE_VALUE |
VARCHAR2 |
240 |
|
Attribute Value which this Extended Attribute is defined |
ATTRIBUTE_VALUE_ID |
NUMBER |
|
|
Attribute Value ID which this Extended Attribute is defined |
IEAV_START_DATE |
DATE |
|
|
Active Start Date for Interfaced Instance |
IEAV_END_DATE |
DATE |
|
|
Active End Date for Interfaced Instance |
LAST_UPDATE_DATE |
DATE |
|
Y |
Standard WHO column |
LAST_UPDATE_BY |
NUMBER |
15 |
Y |
Standard WHO column |
CREATION_DATE |
DATE |
|
Y |
Standard WHO column |
CREATED_BY |
NUMBER |
15 |
Y |
Standard WHO column |
LAST_UPDATE_LOGIN |
NUMBER |
15 |
|
Standard WHO column |