ECQUEUEINSTANCERECV_BANK_ID_NUMDRAWEE_BRANCH_IDDRAWEE_ACCT_NUMBANK_STATIN3_VW(SQL View) |
Index Back |
|---|---|
Prompt tbl for BANK_ANS_STAT |
| SELECT ECQUEUEINSTANCE , RECV_BANK_ID_NUM , DRAWEE_BRANCH_ID , DRAWEE_ACCT_NUM FROM PS_BANK_STATIN3_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 | RECV_BANK_ID_NUM |
Character(5) | VARCHAR2(5) NOT NULL | Bank ID |
| 3 | DRAWEE_BRANCH_ID |
Character(5) | VARCHAR2(5) NOT NULL | Drawee Branch ID |
| 4 | DRAWEE_ACCT_NUM |
Character(11) | VARCHAR2(11) NOT NULL | Drawee Account Number |