GPCH_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 | GPCH_BK_NAT_SRT_CD | Character(17) | VARCHAR2(17) NOT NULL | National Sort Code |
| 4 | GPCH_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 | GPCH_BK_INSTR_CD | Character(1) | VARCHAR2(1) NOT NULL |
Instruction Code
0=Avis 1=Telephone 2=Telex/Fax 3=Legitimacy |
| 6 | GPCH_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 | GPCH_BK_FEE_ACC_CD | Character(1) | VARCHAR2(1) NOT NULL |
Fee Account Code
0=Partition 1=Orderer 2=Contractor Default Value: 0 |
| 8 | GPCH_BK_TRNFR_CD | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Account Code
0=DEM Account 1=Euro Account 2=Currency Account Default Value: 0 |