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 | GPDE_AL_CPAY_ENDDT | Date(10) | DATE | Current Pay End Date |
2 | GPDE_BK_XFER_NBR | 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 |