GP_PKG_IDPAY_ENTITYBUSINESS_UNITEFFDTN=Not Used
O=Optional
R=Required
Default Value: N
GP_NRP_GLCHT_AD(SQL Table) |
Index Back |
|---|---|
GL ChartfieldsGL Chartfields Effective Dated Level |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | GP_COMBO_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Combo code Options
N=Not Used O=Optional R=Required Default Value: N |
| 6 | PIN_CHART1_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 7 | PIN_CHART2_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 8 | PIN_CHART3_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 9 | PIN_CHART4_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 10 | PIN_CHART5_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 11 | PIN_CHART6_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 12 | PIN_CHART7_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 13 | PIN_CHART8_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 14 | PIN_CHART9_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 15 | PIN_CHART10_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 16 | PIN_CHART11_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 17 | PIN_CHART12_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 18 | PIN_CHART13_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 19 | PIN_CHART14_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 20 | PIN_CHART15_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 21 | PIN_CHART16_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 22 | PIN_CHART17_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 23 | PIN_CHART18_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 24 | PIN_CHART19_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 25 | PIN_CHART20_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 26 | PIN_CHART21_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |