DEPOSIT_EXCEL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted. Prompt Table: SP_BUARED_NONVW
2	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
4	CONTROL_CNT	Number(6,0)	INTEGER NOT NULL	Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly
5	CONTROL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly.
6	ACCOUNTING_DT	Date(10)	DATE NOT NULL	The accounting entry construction date for a given transaction (a generic field that crosses multiple
7	FORMAT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency that controls the precision of the amount totals for a group of pending items. If CONTROL_CURRENCY is entered then the same currency code should be used here.
8	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_AR_BD_VW
9	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank Prompt Table: BANK_AR_D_VW
10	RECEIVED_DT	Date(10)	DATE NOT NULL	Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).
11	TYPE	Character(1)	VARCHAR2(1) NOT NULL	TYPE Y/N Table Edit
12	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
13	ERROR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
14	ERROR_COUNT	Number(9,0)	DECIMAL(9) NOT NULL	Error Count
15	ERROR_FLG1	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator Default Value: N
16	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
17	MESSAGE_TEXT_2	Character(100)	VARCHAR2(100) NOT NULL	Message Text
18	MESSAGE_TEXT_3	Character(100)	VARCHAR2(100) NOT NULL	Message Text
19	MESSAGE_TEXT_4	Character(100)	VARCHAR2(100) NOT NULL	Message Text
20	MESSAGE_TEXT_5	Character(100)	VARCHAR2(100) NOT NULL	Message Text