GPDE_BK_XFERDTA(SQL Table) |
Index Back |
|---|---|
Deposit Transfer Data TableThis record contains the criteria on how to organize or store bank transfer data into physical devices ( i.e. magnetic tape, diskettes, etc.) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Date(10) | DATE | Current Pay End Date | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Transfer Sequence | |
| 3 | GPDE_BK_XFER_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Basis
C=Clearing bank H=Source Bank |
| 4 | GPDE_BK_XFER_TYPE | Number(10,0) | DECIMAL(10) NOT NULL | Transfer Type |
| 5 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: SRC_BANK |
| 6 | DEP_SCHED_ID | Character(10) | VARCHAR2(10) NOT NULL |
Deposit Schedule
Prompt Table: DEP_SCHED |
| 7 | DEPOSIT_DATE | Date(10) | DATE |
Deposit Date
Default Value: %date |
| 8 | GPDE_BK_LST_UPD | Date(10) | DATE | Last Updated |
| 9 | GPDE_BK_GEN_DT | Date(10) | DATE | Generation Date |
| 10 | GPDE_BK_XFER_DT | Date(10) | DATE | File Creation Date |
| 11 | GPDE_BK_T_WAGES | Character(1) | VARCHAR2(1) NOT NULL |
Wages and Salaries
Y/N Table Edit Default Value: N |
| 12 | GPDE_BK_T_CAP_ACC | Character(1) | VARCHAR2(1) NOT NULL |
Capital Accumulation Benefits
Y/N Table Edit Default Value: N |
| 13 | GPDE_BK_T_DIR_LIFE | Character(1) | VARCHAR2(1) NOT NULL |
Direct Life Insurance
Y/N Table Edit Default Value: N |
| 14 | GPDE_BK_T_GARN | Character(1) | VARCHAR2(1) NOT NULL |
Garnishments
Y/N Table Edit Default Value: N |
| 15 | GPDE_BK_T_EXT_XFER | Character(1) | VARCHAR2(1) NOT NULL |
External Transfers
Y/N Table Edit Default Value: N |
| 16 | GPDE_BK_T_TAXES | Character(1) | VARCHAR2(1) NOT NULL |
Income Tax and Church Tax
Y/N Table Edit Default Value: N |
| 17 | GPDE_BK_T_SI | Character(1) | VARCHAR2(1) NOT NULL |
Social Insurance Contributions
Y/N Table Edit Default Value: N |
| 18 | GPDE_BK_T_ADVANCES | Character(1) | VARCHAR2(1) NOT NULL |
Advance Payments
Y/N Table Edit Default Value: N |
| 19 | GPDE_BK_T_BVV | Character(1) | VARCHAR2(1) NOT NULL |
BVV
Y/N Table Edit Default Value: N |
| 20 | GPDE_BK_T_UMLAGE | Character(1) | VARCHAR2(1) NOT NULL |
Sick and Maternity Leave
Y/N Table Edit Default Value: N |