MSC_ST_PAYMENT_TERMS

Details

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

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SR_INSTANCE_CODE	VARCHAR2	30			Source application instance code
TERM_ID	NUMBER				This value indicates the payment term identifier.
SR_TERM_ID	VARCHAR2	1000			This indicates the source side value of the source term id.
START_DATE_ACTIVE	DATE				Start date from when the Payment term is active
END_DATE_ACTIVE	DATE				End date till when the Payment term is active
LANGUAGE	VARCHAR2	4		Yes	Indicates the code of the language into which the contents of the translatable columns are translated.
NAME	VARCHAR2	15			The column indicates the current payment term name.
DESCRIPTION	VARCHAR2	240			Description of the payment term
LOAD_REQUEST_ID	NUMBER				contains request id of job that loaded the data
REFRESH_NUMBER	NUMBER				Collection cycle id in which the record is inserted or updated
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.
ERROR_TEXT	VARCHAR2	2000			If PROCESS_FLAG is equal to 2 or 3 for a record, then this will describe the reason for the error
ERROR_CODE	VARCHAR2	150			Error code for functional validation errors in the record
RETRY_COUNT	NUMBER				Retry count. Used during planning collection when the record fails to get loaded into ODS.
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.
DELETED_FLAG	NUMBER		1		Yes/No flag indicates whether corresponding record in ODS will be deleted