GPSG_GL_MAP_AET

(SQL Table)
 Index Back

State record for GPAU_GL_MAP.

State record for AE GPAU_GL_MAP.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
4 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
7 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
8 GROUPING_CODE Character(15) VARCHAR2(15) NOT NULL Identifier (name) used to group a number of elements (earnings or deductions) that can be treated equally (posted to the same account) for GL purposes.
9 PIN_CHART1_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
10 PIN_CHART2_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
11 PIN_CHART3_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value`
12 PIN_CHART4_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
13 PIN_CHART5_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
14 PIN_CHART6_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
15 PIN_CHART7_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
16 PIN_CHART8_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
17 GPSG_CHART_VAL_1 Character(15) VARCHAR2(15) NOT NULL Stores GL transformed value for Chart Field 1.
18 GPSG_CHART_VAL_2 Character(15) VARCHAR2(15) NOT NULL Stores GL transformed value for Chart Field 2.
19 GPSG_CHART_VAL_3 Character(15) VARCHAR2(15) NOT NULL Stores GL transformed value for Chart Field 3.
20 GPSG_CHART_VAL_4 Character(15) VARCHAR2(15) NOT NULL Stores GL transformed value for Chart Field 4.
21 GPSG_CHART_VAL_5 Character(15) VARCHAR2(15) NOT NULL Stores GL transformed value for Chart Field 5.
22 GPSG_CHART_VAL_6 Character(15) VARCHAR2(15) NOT NULL Stores GL transformed value for Chart Field 6.
23 GPSG_CHART_VAL_7 Character(15) VARCHAR2(15) NOT NULL Stores GL transformed value for Chart Field 7.
24 GPSG_CHART_VAL_8 Character(15) VARCHAR2(15) NOT NULL Stores GL transformed value for Chart Field 8.
25 GPSG_CV1_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 1.

Y/N Table Edit

26 GPSG_CV2_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 2.

Y/N Table Edit

27 GPSG_CV3_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 3.

Y/N Table Edit

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

Y/N Table Edit

29 GPSG_CV5_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 5.

Y/N Table Edit

30 GPSG_CV6_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 6.

Y/N Table Edit

31 GPSG_CV7_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 7.

Y/N Table Edit

32 GPSG_CV8_TO_GL Character(1) VARCHAR2(1) NOT NULL Conversion flag for GL Chart Field 8.

Y/N Table Edit

33 PIN_CHART1_NUM Number(8,0) INTEGER NOT NULL Element number field
34 PIN_CHART2_NUM Number(8,0) INTEGER NOT NULL Element number field
35 PIN_CHART3_NUM Number(8,0) INTEGER NOT NULL Element number field
36 PIN_CHART4_NUM Number(8,0) INTEGER NOT NULL Element number field
37 PIN_CHART5_NUM Number(8,0) INTEGER NOT NULL Element number field
38 PIN_CHART6_NUM Number(8,0) INTEGER NOT NULL Element number field
39 PIN_CHART7_NUM Number(8,0) INTEGER NOT NULL Element number field
40 PIN_CHART8_NUM Number(8,0) INTEGER NOT NULL Element number field