GPDE_BK_PYEACCT(SQL Table) |
Index Back |
---|---|
Foreign Bank Account InfoForeign 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 |