GPDE_AL_PAYMT_TYPE1=Wages and Salaries
3=Taxes
4=Social Insurance
6=Capital Accumulation
7=Direct Life Insurance
8=Garnishments
9=External Transfer
B=BVV
L=U1/Sick Leave
M=U2/Maternity Leave
V=Advance Payments
Prompt Table: GP_PIN_AC0_VW
GPDE_BKBTR_NRVW(SQL View) |
Index Back |
|---|---|
Bank Transfer Set UpBank Transfer Set Up |
| SELECT GPDE_AL_PAYMT_TYPE , PIN_NUM + 50000000 FROM PS_GPDE_BK_BNKTRN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPDE_AL_PAYMT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Payment Type
1=Wages and Salaries 3=Taxes 4=Social Insurance 6=Capital Accumulation 7=Direct Life Insurance 8=Garnishments 9=External Transfer B=BVV L=U1/Sick Leave M=U2/Maternity Leave V=Advance Payments |
| 2 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GP_PIN_AC0_VW |