GP_NRP_GLCHT_VW

(SQL View)
 Index Back

Packaging View-GL Chartfields

Packaging View for GL Chartfields Effective Dated Level

SELECT PAY_ENTITY , BUSINESS_UNIT , EFFDT ,GP_COMBO_CODE , PIN_CHART1_NUM + 50000000 , PIN_CHART2_NUM + 50000000 , PIN_CHART3_NUM + 50000000 , PIN_CHART4_NUM + 50000000 , PIN_CHART5_NUM + 50000000 , PIN_CHART6_NUM + 50000000 , PIN_CHART7_NUM + 50000000 , PIN_CHART8_NUM + 50000000 ,PIN_CHART9_NUM + 50000000 ,PIN_CHART10_NUM + 50000000 ,PIN_CHART11_NUM + 50000000 ,PIN_CHART12_NUM + 50000000 ,PIN_CHART13_NUM + 50000000 ,PIN_CHART14_NUM + 50000000 ,PIN_CHART15_NUM + 50000000 ,PIN_CHART16_NUM + 50000000 ,PIN_CHART17_NUM + 50000000 ,PIN_CHART18_NUM + 50000000 ,PIN_CHART19_NUM + 50000000 ,PIN_CHART20_NUM + 50000000 ,PIN_CHART21_NUM + 50000000 FROM PS_GP_GL_CHARTFLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GP_COMBO_CODE Character(1) VARCHAR2(1) NOT NULL Combo code Options
N=Not Used
O=Optional
R=Required

Default Value: N

5 PIN_CHART1_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

6 PIN_CHART2_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

7 PIN_CHART3_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

8 PIN_CHART4_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

9 PIN_CHART5_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

10 PIN_CHART6_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

11 PIN_CHART7_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

12 PIN_CHART8_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

13 PIN_CHART9_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

14 PIN_CHART10_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

15 PIN_CHART11_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

16 PIN_CHART12_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

17 PIN_CHART13_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

18 PIN_CHART14_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

19 PIN_CHART15_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

20 PIN_CHART16_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

21 PIN_CHART17_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

22 PIN_CHART18_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

23 PIN_CHART19_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

24 PIN_CHART20_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW

25 PIN_CHART21_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_CHART_VW