STATEMENT_IDSEQNBRBNK_ID_NBRBRANCH_IDBANK_ACCOUNT_NUM1=Update
2=Deletion
3=Correction
4=Test Only
BS_BKACT_SD_EC(SQL Table) |
Index Back |
|---|---|
Bank Account Statement HeaderBank Account Statement Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATEMENT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Statement ID for bank statements, key on Bank Statement Header |
| 2 | SEQNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 4 | BRANCH_ID |
Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 5 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 6 | GROUP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Specifies exactly how data in a group of accounts are to be processed.
1=Update 2=Deletion 3=Correction 4=Test Only |
| 7 | ASOFDATE | Date(10) | DATE | As of Date |
| 8 | ASOFTIME | Time(15) | TIMESTAMP | As of Time |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |