GP_GL_DATA_HST

(SQL Table)
Index Back

GP GL Transaction Interface

GL Interface Transaction for GP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
7 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
8 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
9 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
10 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
11 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
13 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.
14 PIN_CHART1_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
15 PIN_CHART2_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
16 PIN_CHART3_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value`
17 PIN_CHART4_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
18 PIN_CHART5_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
19 PIN_CHART6_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
20 PIN_CHART7_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
21 PIN_CHART8_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
22 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
23 POSTING_DATE Date(10) DATE Posting Date
24 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
25 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code