TRN_CNTLTMP (SQL Table)	Index Back
Transfer Worksheet temp table This table stores the transfer worksheet dst code entered by the user on the worksheet. This is temporary until this field is added to PENDING_ITEM.

TRN_CNTLTMP

(SQL Table)

Transfer Worksheet temp table

This table stores the transfer worksheet dst code entered by the user on the worksheet. This is temporary until this field is added to PENDING_ITEM.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.

3 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.

4 DST_ID_TRAN_CTL Character(10) VARCHAR2(10) NOT NULL 10 character value used to identify the transfer worksheet control distribution code.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
3	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
4	DST_ID_TRAN_CTL	Character(10)	VARCHAR2(10) NOT NULL	10 character value used to identify the transfer worksheet control distribution code.