GPMY_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: BUS_UNIT_TBL_HR

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GPMY_CV1_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion Flag for Chart Field1

Y/N Table Edit

5 GPMY_CV2_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion Flag for Chart Field2

Y/N Table Edit

6 GPMY_CV3_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion Flag for Chart Field3

Y/N Table Edit

7 GPMY_CV4_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion Flag for Chart Field4

Y/N Table Edit

8 GPMY_CV5_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion Flag for Chart Field5

Y/N Table Edit

9 GPMY_CV6_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion Flag for Chart Field6

Y/N Table Edit

10 GPMY_CV7_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion Flag for Chart Field7

Y/N Table Edit

11 GPMY_CV8_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion Flag for Chart Field8

Y/N Table Edit