MSC_ST_PAYMENT_TERMS

Details

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

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TERM_ID	VARCHAR2	1000			This value indicates the payment term identifier.
SR_TERM_ID	VARCHAR2	1000			This indicates the source side value of the Source term id.
SR_SET_ID	NUMBER		18		Source side value of the Set identifier.
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.
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_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
SR_INSTANCE_ID	NUMBER		18		Identifier of the source system from where the data is collected.
START_DATE_ACTIVE	DATE				Start date that indicates the active status of the Payment terms.
END_DATE_ACTIVE	DATE				Date from which this record is no longer active
REFRESH_NUMBER	NUMBER				Refresh identifier populated by the collection progam
PROCESS_FLAG	NUMBER				Processing Flag indicating the status of records during pre-processing. 1- Complete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record.
RETRY_COUNT	NUMBER				Number of retries to process failed records.
ERROR_CODE	VARCHAR2	150			Error code for functional validation errors in the record
ERROR_TEXT	VARCHAR2	2000			This will describe the reason for the error if any.
SR_INSTANCE_CODE	VARCHAR2	30			Source Instance code from which data is being populated.
DELETED_FLAG	NUMBER		1		Yes/No flag indicates whether corresponding record in ODS will be deleted