BSP_CYCLEHDR_EC (SQL Table)	Index Back
Bank Statement Staging Header Used to stage the inbound bank statement messages fro

BSP_CYCLEHDR_EC

(SQL Table)

Bank Statement Staging Header

Used to stage the inbound bank statement messages fro

Parent Record Of BSP_BKBAL_PD_EC BSP_BKBAL_SD_EC FA_STMT_HDR_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 ASOFDATE Date(10) DATE As of Date

8 ASOFTIME Time(15) TIMESTAMP As of Time

9 RECEIVER Character(20) VARCHAR2(20) NOT NULL Receiver is used in bank reconciliation

10 TRANSACTION_REF Character(16) VARCHAR2(16) NOT NULL Represents a deal transaction reference or identifier.

11 STMT_NUMBER Number(5,0) INTEGER NOT NULL A sequential number that indicates the processing queue number for a given bank statement and given ban

12 PAGE_NUMBER Number(3,0) SMALLINT NOT NULL Page Number is used in bank reconciliation

13 BSP_CYCLE_DT Date(10) DATE Date of the bank statements to import from CERG

14 BSP_CYCLE_STATUS Character(1) VARCHAR2(1) NOT NULL Status of a bank statement import. Translates are set by PeopleCode durring the staging process and durring the application load process.
000=Staging
001=Ready
002=In Process
003=Application Loaded
004=Errors Found
1=Staging
2=Ready
3=Loading
4=Complete
5=Error
Default Value: 1

15 BSP_PRCS_DT Date(10) DATE Bank Statement Process Date

16 BNK_LOAD_DTTM DateTime(26) TIMESTAMP The time and date a bank statement is loaded into the system.

17 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID

#	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	ASOFDATE	Date(10)	DATE	As of Date
8	ASOFTIME	Time(15)	TIMESTAMP	As of Time
9	RECEIVER	Character(20)	VARCHAR2(20) NOT NULL	Receiver is used in bank reconciliation
10	TRANSACTION_REF	Character(16)	VARCHAR2(16) NOT NULL	Represents a deal transaction reference or identifier.
11	STMT_NUMBER	Number(5,0)	INTEGER NOT NULL	A sequential number that indicates the processing queue number for a given bank statement and given ban
12	PAGE_NUMBER	Number(3,0)	SMALLINT NOT NULL	Page Number is used in bank reconciliation
13	BSP_CYCLE_DT	Date(10)	DATE	Date of the bank statements to import from CERG
14	BSP_CYCLE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of a bank statement import. Translates are set by PeopleCode durring the staging process and durring the application load process. 000=Staging 001=Ready 002=In Process 003=Application Loaded 004=Errors Found 1=Staging 2=Ready 3=Loading 4=Complete 5=Error Default Value: 1
15	BSP_PRCS_DT	Date(10)	DATE	Bank Statement Process Date
16	BNK_LOAD_DTTM	DateTime(26)	TIMESTAMP	The time and date a bank statement is loaded into the system.
17	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_FS.OPRID