GPCH_BK_XFERDTA(SQL Table) |
Index Back |
---|---|
Bank Tranfer InformationBank Tranfer Information |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPCH_AL_CPAY_ENDDT | Date(10) | DATE NOT NULL |
Current Pay End Date
Prompt Table: GPCH_RP_DATE_VW |
2 | GPCH_BK_XFER_NBR | 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 |