BNK_HEADER_EC(SQL Table) |
Index Back |
|---|---|
Bank Balance Header |
| # | 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 | 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) |
| 3 | 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 |
| 4 | ECACTIONCD | Character(3) | VARCHAR2(3) NOT NULL | EC Action Code |
| 5 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 6 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 7 | LOADED_SW | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a given treasury transaction successfully has been imp
Y/N Table Edit |
| 8 | STMT_BAL_OPEN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement opening balance as submitted by the bank. |
| 9 | STMT_BAL_OPEN_DT | Date(10) | DATE | The bank statement opening balance date as submitted by the bank. |
| 10 | STMT_BAL_CLOSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement closing balance as submitted by the bank. |
| 11 | STMT_BAL_CLOSE_DT | Date(10) | DATE | The bank statement closing balance date as submitted by the bank. |
| 12 | STMT_BAL_AVAIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement available balance as submitted by the bank. |
| 13 | STMT_BAL_FWD | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement available forward balance as submitted by the bank. |
| 14 | STMT_BAL_FWD_DT | Date(10) | DATE | The bank statement available forward balance date as submitted by the bank. |