GPDE_BK_PYEACCT

(SQL Table)
Index Back

Foreign Bank Account Info

Foreign Bank Account Info

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: PYE_BANKACCT.EMPLID

2 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID

Default Value: PYE_BANKACCT.ACCOUNT_ID

3 GPDE_BK_NAT_SRT_CD Character(17) VARCHAR2(17) NOT NULL National Sort Code
4 GPDE_BK_EXEC_CD Character(1) VARCHAR2(1) NOT NULL Execution Code
0=Standard (SWIFT/Letter)
1=Urgent (SWIFT/Telex)
2=Check
3=Check to Order

Default Value: 0

5 GPDE_BK_INSTR_CD Character(1) VARCHAR2(1) NOT NULL Instruction Code
0=Avis
1=Telephone
2=Telex/Fax
3=Legitimacy
6 GPDE_BK_FEE_PMT_CD Character(1) VARCHAR2(1) NOT NULL Fee Payment Code
0=DEM Account
1=Euro Account
2=Currency Account

Default Value: 1

7 GPDE_BK_FEE_ACC_CD Character(1) VARCHAR2(1) NOT NULL Fee Account Code
0=Partition
1=Orderer
2=Contractor

Default Value: 0

8 GPDE_BK_TRNFR_CD Character(1) VARCHAR2(1) NOT NULL Transfer Account Code
0=DEM Account
1=Euro Account
2=Currency Account

Default Value: 0