TD_CHKTRACE_SQL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 TD_CHECKBOOK_ID Character(10) VARCHAR2(10) NOT NULL Promotions Management Checkbook ID

3 COLUMNNUM Number(3,0) SMALLINT NOT NULL Column Number

4 ROW_NUM Number(3,0) SMALLINT NOT NULL Row Number

5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

6 SQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	TD_CHECKBOOK_ID	Character(10)	VARCHAR2(10) NOT NULL	Promotions Management Checkbook ID
3	COLUMNNUM	Number(3,0)	SMALLINT NOT NULL	Column Number
4	ROW_NUM	Number(3,0)	SMALLINT NOT NULL	Row Number
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	SQL_STMT	Long Character(8192)	CLOB	An internal work field that contains SQL text that is to be utilized in treasury application processing.