GPNZ_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 | SEQ_NUM5 | Number(5,0) | INTEGER 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 | GPNZ_CHART_VAL_1 | Character(15) | VARCHAR2(15) NOT NULL | Stores GL transformed value for Chart Field 1. |
18 | GPNZ_CHART_VAL_2 | Character(15) | VARCHAR2(15) NOT NULL | Stores GL transformed value for Chart Field 2. |
19 | GPNZ_CHART_VAL_3 | Character(15) | VARCHAR2(15) NOT NULL | Stores GL transformed value for Chart Field 3. |
20 | GPNZ_CHART_VAL_4 | Character(15) | VARCHAR2(15) NOT NULL | Stores GL transformed value for Chart Field 4. |
21 | GPNZ_CHART_VAL_5 | Character(15) | VARCHAR2(15) NOT NULL | Stores GL transformed value for Chart Field 5. |
22 | GPNZ_CHART_VAL_6 | Character(15) | VARCHAR2(15) NOT NULL | Stores GL transformed value for Chart Field 6. |
23 | GPNZ_CHART_VAL_7 | Character(15) | VARCHAR2(15) NOT NULL | Stores GL transformed value for Chart Field 7. |
24 | GPNZ_CHART_VAL_8 | Character(15) | VARCHAR2(15) NOT NULL | Stores GL transformed value for Chart Field 8. |
25 | GPNZ_CV1_TO_GL | Character(1) | VARCHAR2(1) NOT NULL |
Conversion flag for GL Chart Field 1.
Y/N Table Edit |
26 | GPNZ_CV2_TO_GL | Character(1) | VARCHAR2(1) NOT NULL |
Conversion flag for GL Chart Field 2.
Y/N Table Edit |
27 | GPNZ_CV3_TO_GL | Character(1) | VARCHAR2(1) NOT NULL |
Conversion flag for GL Chart Field 3.
Y/N Table Edit |
28 | GPNZ_CV4_TO_GL | Character(1) | VARCHAR2(1) NOT NULL |
Conversion flag for GL Chart Field 4.
Y/N Table Edit |
29 | GPNZ_CV5_TO_GL | Character(1) | VARCHAR2(1) NOT NULL |
Conversion flag for GL Chart Field 5.
Y/N Table Edit |
30 | GPNZ_CV6_TO_GL | Character(1) | VARCHAR2(1) NOT NULL |
Conversion flag for GL Chart Field 6.
Y/N Table Edit |
31 | GPNZ_CV7_TO_GL | Character(1) | VARCHAR2(1) NOT NULL |
Conversion flag for GL Chart Field 7.
Y/N Table Edit |
32 | GPNZ_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 |