GPMX_GL_MAP

(SQL Table)
Index Back

GL Chart Field to Acct Map

GL Chart Field to Acct Map

# 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_OPR_VW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: GPMX_BU_GL_VW

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GPMX_CV1_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 1.

Y/N Table Edit

Default Value: Y

5 GPMX_CV2_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 2

Y/N Table Edit

Default Value: Y

6 GPMX_CV3_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 3.

Y/N Table Edit

Default Value: Y

7 GPMX_CV4_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 4.

Y/N Table Edit

Default Value: Y

8 GPMX_CV5_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 5.

Y/N Table Edit

Default Value: Y

9 GPMX_CV6_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 6.

Y/N Table Edit

Default Value: Y

10 GPMX_CV7_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 7.

Y/N Table Edit

Default Value: Y

11 GPMX_CV8_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 8.

Y/N Table Edit

Default Value: Y

12 GPMX_CV9_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 9.

Y/N Table Edit

Default Value: Y

13 GPMX_CV10_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 10.

Y/N Table Edit

Default Value: Y

14 GPMX_CV11_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 11.

Y/N Table Edit

Default Value: Y

15 GPMX_CV12_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 12.

Y/N Table Edit

Default Value: Y

16 GPMX_CV13_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 13.

Y/N Table Edit

Default Value: Y

17 GPMX_CV14_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 14.

Y/N Table Edit

Default Value: Y

18 GPMX_CV15_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 15.

Y/N Table Edit

Default Value: Y

19 GPMX_CV16_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 16.

Y/N Table Edit

Default Value: Y

20 GPMX_CV17_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 17.

Y/N Table Edit

Default Value: Y

21 GPMX_CV18_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 18.

Y/N Table Edit

Default Value: Y

22 GPMX_CV19_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 19.

Y/N Table Edit

Default Value: Y

23 GPMX_CV20_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 20.

Y/N Table Edit

Default Value: Y

24 GPMX_CV21_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 21.

Y/N Table Edit

Default Value: Y