GPCH_BK_XFERDTA(SQL Table) |
Index Back |
|---|---|
Bank Tranfer InformationBank Tranfer Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Date(10) | DATE NOT NULL |
Current Pay End Date
Prompt Table: GPCH_RP_DATE_VW |
|
| 2 | Number(3,0) | SMALLINT NOT NULL | Transfer Sequence | |
| 3 | GPCH_BK_PYMNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bank Payment Type
D=DTA L=LSV P=Postfinance(EPO) |
| 4 | GPCH_BK_XFER_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Basis
C=Clearing Bank H=Home Bank |
| 5 | GPCH_BK_XFER_TYPE | Number(10,0) | DECIMAL(10) NOT NULL | Transfer Type |
| 6 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: SRC_BANK |
| 7 | DEP_SCHED_ID | Character(10) | VARCHAR2(10) NOT NULL |
Deposit Schedule
Prompt Table: DEP_SCHED |
| 8 | DEPOSIT_DATE | Date(10) | DATE |
Deposit Date
Default Value: %date |
| 9 | GPCH_BK_LST_UPD | Date(10) | DATE | Last Updated |
| 10 | GPCH_BK_GEN_DT | Date(10) | DATE | Generation Date |
| 11 | GPCH_BK_XFER_DT | Date(10) | DATE | File Creation Date |
| 12 | GPCH_BK_T_WAGES | Character(1) | VARCHAR2(1) NOT NULL |
Wages and Salaries
Y/N Table Edit Default Value: N |
| 13 | GPCH_BK_T_CAP_ACC | Character(1) | VARCHAR2(1) NOT NULL |
Capital Accumulation Benefits
Y/N Table Edit Default Value: N |
| 14 | GPCH_BK_T_DIR_LIFE | Character(1) | VARCHAR2(1) NOT NULL |
Direct Life Insurance
Y/N Table Edit Default Value: N |
| 15 | GPCH_BK_T_GARN | Character(1) | VARCHAR2(1) NOT NULL |
Garnishments
Y/N Table Edit Default Value: N |
| 16 | GPCH_BK_T_EXT_XFER | Character(1) | VARCHAR2(1) NOT NULL |
External Transfers
Y/N Table Edit Default Value: N |
| 17 | GPCH_BK_T_TAXES | Character(1) | VARCHAR2(1) NOT NULL |
Income Tax and Church Tax
Y/N Table Edit Default Value: N |
| 18 | GPCH_BK_T_SI | Character(1) | VARCHAR2(1) NOT NULL |
Social Insurance Contributions
Y/N Table Edit Default Value: N |
| 19 | GPCH_BK_T_ADVANCES | Character(1) | VARCHAR2(1) NOT NULL |
Advance Payments
Y/N Table Edit Default Value: N |
| 20 | GPCH_BK_T_BVV | Character(1) | VARCHAR2(1) NOT NULL |
BVV
Y/N Table Edit Default Value: N |
| 21 | GPCH_BK_T_UMLAGE | Character(1) | VARCHAR2(1) NOT NULL |
Sick and Maternity Leave
Y/N Table Edit Default Value: N |