ECQUEUEINSTANCEBANK_STATIN_VW(SQL View) |
Index Back |
|---|---|
Bank Status View for EDI |
| SELECT ECQUEUEINSTANCE , RECV_BANK_ID_NUM , CREATE_DATE , CURRENCY_INDEX FROM PS_BANK_STATIN_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 | CREATE_DATE | Date(10) | DATE | Creation Date |
| 4 | CURRENCY_INDEX | Character(1) | VARCHAR2(1) NOT NULL | Currency Index |