DOO_ORDER_SALES_CREDITS_INT

This interface table contains details of Sales Credits Information for an imported Source Sales Order.

Details

• Schema: FUSION

• Object owner: DOO

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SOURCE_TRANSACTION_SYSTEM	VARCHAR2	30			System or application that submitted the order request
SOURCE_TRANSACTION_ID	VARCHAR2	50			Unique identifier of the transaction in the system that captured the transaction.
SOURCE_TRANSACTION_LINE_ID	VARCHAR2	50			Unique identifier of the transaction line from the system that captured the transaction.
SOURCE_TRANSACTION_SCHEDULE_ID	VARCHAR2	50			Unique identifier of a schedule, shipment, or subline, as assigned by the system that captured the transaction.
SOURCE_TXN_SALES_CREDIT_ID	VARCHAR2	50			Unique identifier of the sales credit that is assigned by the system that captured the transaction.
SALES_PERSON_ID	NUMBER		18		Unique identifier of the person that sold the goods.
SALES_PERSON	VARCHAR2	360			The person that sold the goods.
LOAD_REQUEST_ID	NUMBER		18		Unique identifier of the import request.
SALES_CREDIT_TYPE_CODE	VARCHAR2	1000			Stores foreign key to point to sales credit type: revenue or nonrevenue.
SALES_CREDIT_TYPE_REFERENCE	VARCHAR2	1000			Stores reference for sales credit type code.
PERCENT	NUMBER				Value that indicates the sales credit percentage for a salesperson.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who 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.
BATCH_ID	NUMBER		18		Id of the batch as part of which this sales credit will be processed.

Indexes

Index	Uniqueness	Tablespace	Columns
DOO_ORDER_SALES_CREDITS_INT_N1	Non Unique	Default	SOURCE_TRANSACTION_ID, SOURCE_TRANSACTION_SYSTEM, LOAD_REQUEST_ID, SOURCE_TRANSACTION_LINE_ID
DOO_ORDER_SALES_CREDITS_INT_N2	Non Unique	Default	BATCH_ID
DOO_ORDER_SALES_CREDITS_INT_N3	Non Unique	Default	LOAD_REQUEST_ID