BSP_REMIT_PD_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
2	ECFILEROWID	Character(3)	VARCHAR2(3) NOT NULL	Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.
3	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
4	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound
5	ECACTIONCD	Character(3)	VARCHAR2(3) NOT NULL	EC Action Code
6	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
7	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
8	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
9	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
10	REMIT_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	Remit Sequence Key
11	PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
12	DISC_TAKEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Taken
13	ADJUSTMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Amount
14	ADJUSTMENT_REASON	Character(2)	VARCHAR2(2) NOT NULL	Adjustment Reason
15	REF_QUALIFIER_CODE	Character(2)	VARCHAR2(2) NOT NULL	Reference Qualifier Code
16	REF_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Reference
17	REF_VALUE_TO	Character(30)	VARCHAR2(30) NOT NULL	Range for Reference Value
18	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.
19	MICR_ID	Character(30)	VARCHAR2(30) NOT NULL	MICR ID
20	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp