BS_BACT_PD_EC_S(SQL Table) |
Index Back |
---|---|
BTF:Bank Acct Statement HeaderBank Account Statement Header |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TEST_CASE | Character(30) | VARCHAR2(30) NOT NULL | BTF Test Case |
2 | STATEMENT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Statement ID for bank statements, key on Bank Statement Header |
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 |