GPDE_BK_XFERDTA

(SQL Table)
Index Back

Deposit Transfer Data Table

This 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