GP_BNK_FILE_HDR(SQL Table) |
Index Back |
---|---|
Bank File HeaderHeader Record for Bank File |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL |
Bank ID
Prompt Table:
GP_BNK_CD_VW
|
2 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL |
Account Number used in banking.
Prompt Table: GP_BNK_EC_ID_VW |
3 | BNK_FILE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Auto generated number when Bank File is loaded
Prompt Table: GP_BNK_FL_ID_VW |
4 | BNK_RUN_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Bank File Reconciliation Status
10=Ready 20=In Progress 30=Complete Default Value: 10 |
5 | ASOFDATE | Date(10) | DATE |
As of Date
Default Value: %date |
6 | BNK_LOAD_DTTM | DateTime(26) | TIMESTAMP |
BNK_LOAD_DTTM
Default Value: %Datetime |
7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |