GPDE_BK_PE_SBK2(SQL Table) |
Index Back |
|---|---|
PE Source Bank DfltPE Source Bank Dflt and payment type assignment |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: COMPANY_TBL.EFFDT |
| 3 | 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 |
| 4 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: SRC_BANK |