BS_REMIT_PD_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header
2	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
3	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
4	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
5	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
6	REMIT_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	Remit Sequence Key
7	PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
8	DISC_TAKEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Taken
9	ADJUSTMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Amount
10	ADJUSTMENT_REASON	Character(2)	VARCHAR2(2) NOT NULL	Adjustment Reason
11	REF_QUALIFIER_CODE	Character(2)	VARCHAR2(2) NOT NULL	Reference Qualifier Code
12	REF_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Reference
13	REF_VALUE_TO	Character(30)	VARCHAR2(30) NOT NULL	Range for Reference Value
14	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.
15	MICR_ID	Character(30)	VARCHAR2(30) NOT NULL	MICR ID
16	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp Default Value: N