BNK_STMT_REMIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
3	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
4	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
5	REMIT_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	Remit Sequence Key
6	PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
7	DISC_TAKEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Taken
8	ADJUSTMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Amount
9	ADJUSTMENT_REASON	Character(2)	VARCHAR2(2) NOT NULL	Adjustment Reason
10	REF_QUALIFIER_CODE	Character(2)	VARCHAR2(2) NOT NULL	Reference Qualifier Code
11	REF_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Reference
12	REF_VALUE_TO	Character(30)	VARCHAR2(30) NOT NULL	Range for Reference Value
13	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
14	MICR_ID	Character(30)	VARCHAR2(30) NOT NULL	MICR ID
15	ITEM_SW	Character(1)	VARCHAR2(1) NOT NULL	A/R Item Table Item Y/N Table Edit Default Value: N
16	CUST_SW	Character(1)	VARCHAR2(1) NOT NULL	A/R Cust Table Item Y/N Table Edit Default Value: N