Object type: TABLE Tablespace: FUSION_TS_TX_DATA Primary Key Name Columns DOO_HEADERS_ALL_PK HEADER_ID Columns NameDatatypeLengthPrecisionNot-nullComments HEADER_ID NUMBER 18 Yes Unique identifier of the orchestration order. INTERNAL_COMMENTS VARCHAR2 4000 This is an internal column that Oracle...
ORDER_REQUEST_ID NUMBER 18 Unique identifier assigned to each sales order while loading of the sales order into interface table. Indexes IndexUniquenessTablespaceColumns DOO_ORDER_HEADERS_ALL_INT_N1 Non Unique Default INTERFACE_STATUS_CODE DOO_ORDER_HEADERS_ALL_INT_N10 Non Unique Default BATCH_ID ...
ORDER_REQUEST_ID NUMBER 18 Unique identifier assigned to each sales order while loading of the sales order into interface table. Indexes IndexUniquenessTablespaceColumns DOO_ORDER_HEADERS_ALL_INT_N1 Non Unique Default INTERFACE_STATUS_CODE DOO_ORDER_HEADERS_ALL_INT_N10 Non Unique Default BATCH_ID ...
Object type: TABLE Tablespace: INTERFACE Columns NameDatatypeLengthPrecisionNot-nullComments SOURCE_TRANSACTION_IDVARCHAR250Unique identifier of the transaction from the system that captured the transaction. AGREEMENT_NUMBERVARCHAR2150Number that uniquely identifies the sales agreement on the order header. ...