LOCKBOX_RUN_LOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AR_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	A number that is assigned to draft items to ensure uniqueness of key
3	LOCKBOX_ID	Character(15)	VARCHAR2(15) NOT NULL	Lockbox ID
4	LB_FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	Name of Lockbox File
5	LOCKBOX_RUN_DT	Date(10)	DATE	Processed Date/Time
6	LOCKBOX_RUN_TIME	Character(15)	VARCHAR2(15) NOT NULL	Lockbox Run Time
7	LOCKBOX_RUN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Lockbox Run Status C=Complete D=Duplicate Found E=Errors Found N=Not Run Yet
8	LOCKBOX_TRANS_DT	Date(10)	DATE	Transmission Date/Time
9	LOCKBOX_TRANS_TIME	Character(15)	VARCHAR2(15) NOT NULL	Lockbox Transmission Time
10	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
11	ENTERED_PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Entered Pay Amount
12	ENTERED_PAY_CNT	Number(6,0)	INTEGER NOT NULL	Entered Pay Count
13	ENTERED_BATCH_CNT	Number(6,0)	INTEGER NOT NULL	Entered Deposit Count
14	CONTROL_PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
15	CONTROL_PAY_CNT	Number(6,0)	INTEGER NOT NULL	Payment Count
16	CONTROL_BATCH_CNT	Number(6,0)	INTEGER NOT NULL	Deposit Count
17	CONTROL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
18	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
19	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
20	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.