GPCH_BK_XFERDTA

(SQL Table)
Index Back

Bank Tranfer Information

Bank 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