VCS_FRCST_RESPONSE_LINE

Details

Schema: FUSION
Object owner: VCS
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
VCS_FRCST_RESPONSE_LINE_PK	RESPONSE_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RESPONSE_LINE_ID	NUMBER		18	Yes	Primary key identifying the record.
STATUS_CODE	VARCHAR2	30			Status of the record. Valid values "SUCCESS", "FAILURE".
RESPONSE_HEADER_ID	NUMBER		18	Yes	Unique identifier of the parent response header record.
ITEM_NUMBER	VARCHAR2	300			The Item Number that identifies the item that the buying organization is procuring from the supplier.
SUPPLIER_ITEM_NUMBER	VARCHAR2	300			The Supplier Item Number is the trading partner's (customer, supplier, competitor, manufacturer) identifier for an item.
INVENTORY_ITEM_ORG_CODE	VARCHAR2	300			The Inventory or Item Organization Code that is associated with the item.
SHIP_TO_ORGANIZATION_CODE	VARCHAR2	300			The Ship-To Organization Code representing the entity where the items are shipped.
SHIP_TO_PRTCPNT_ID	NUMBER		18		Internal reference to the organization to which the goods need to be shipped to.
SHIP_TO_LOCATION	VARCHAR2	300			The Ship-To Location representing the location where the items are shipped.
SHIP_TO_CUSTOMER	VARCHAR2	300			The Ship-To Customer representing the customer where the items are shipped.
INVENTORY_ITEM_ID	NUMBER		18		Unique identifier of the item used in the forecast document.
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_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.
ERROR_MESSAGE_CODE	VARCHAR2	30			Error message code to capture the reason for failure.
ERROR_MESSAGE	VARCHAR2	400			Error message to capture the reason for failure.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
INVENTORY_ITEM_ORG_ID	NUMBER		18		Unique identifier of the organization for the item used in the forecast document.
ORCH_CORRELATION_CODE	VARCHAR2	100			The Correlation ID represents the specific Item Forecast version. Commits will be made using the Correlation ID to specify which item forecast is being responded to.
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.
SHIP_FROM_PRTCPNT_ID	NUMBER		18		Internal reference to the vendor from which the goods need to be shipped
COLLAB_ENTRY_ID	NUMBER		18		Key identifying a collaboration entry.
NOTE_TO_PLANNER	VARCHAR2	1000			Note from the supplier to the collaboration planner.
NOTE_TO_SUPPLIER	VARCHAR2	1000			Note from the collaboration planner to the supplier.
UPLOAD_ROW_NUMBER	NUMBER		9		Row number of the record in upload file that failed with this validation.

Indexes

Index	Uniqueness	Tablespace	Columns
VCS_FRCST_RESPONSE_LINE_INT_N2	Non Unique	Default	SHIP_TO_PRTCPNT_ID, INVENTORY_ITEM_ID, INVENTORY_ITEM_ORG_ID
VCS_FRCST_RESPONSE_LINE_N1	Non Unique	Default	RESPONSE_HEADER_ID
VCS_FRCST_RESPONSE_LINE_U1	Unique	Default	RESPONSE_LINE_ID