PAY HISTORY (UPPHF) INTERFACE VARIABLES#
X_INF_VARIABLE_NAME is a fixed lexicon. Variables starting with "32" are used to define interfaces in the IDIF screen that will be created by the UPPHF program
| Saved Value | Displayed Value | Source of Data | Comments |
|---|---|---|---|
| 320001 | Execution ID (32) | From Execution ID of the UPPHF run | |
| 320002 | XML Tag (32) | Indicates this Rec#/Fld# is for XML tag. You should enter the XML tag in the XML tag field, if XML tag field is not specified, the field name is used as XML tag e.g. <Request> or </Request> as XML tag. You should use one of the following ways to define XML tags: 1) use 320002-XML tag for all Begin and End tags i.e. you specify <Request> and </Request> 2) use 320604-XML Begin tag and 320605-XML End tag. This allows you to use XML tag option to indicate if the XML tag is mandatory or optional. You must not use 320002-XML tag to mix with 320604/320605 definition | |
| 320003 | Constant Value (32) | You should specify the Constant to be used in IDIF Constant Value field | |
| 320004 | System Date/Time (32) | The current system date and time with following, select:to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') | You can use derivation expression SUBSTR to retrieve Date Only or Time Only |
| 320005 | From Pay Period (32) | This field holds the earliest pay period that have been processed from all pay headers | This can be used for Header or Trailer record |
| 320006 | To Pay Period (32) | This field holds the latest pay period that have been processed from all pay headers | This can be used for Header or Trailer record |
| 320007 | Pay Header pph_id (32) | This field holds the id of the current pay header | This can be used in the derivation expression to call some internal Wiki functions that needed the pph.id e.g. call Element function to return the value of an element: To retrieve the value of Element 'HOURS COMP TIME'. In Record# 50, Field#20, Variable Name = 'Pay Header PPH_ID', then in derivation expression: P2K_PPAMTS.SPELPAY(~,P2K_PPAMTS.SPGETPEL('HOURS COMP TIME')) |
| 320008 | Employment eem_id (32) | This field holds the id of the current employment record, from P2K_HR_EMPLOYMENTS | |
| 320009 | Identity eid_id (32) | This field holds the id of the current identity record from P2K_HR_IDENTITIES | This can be used in the derivation expression to call some internal Wiki functions that needed the EID_ID |
| 320010 | Person Code (32) | From P2K_HR_IDENTITIES, person_code | |
| 320011 | First Name (32) | From P2K_HR_IDENTITIES, first_name | |
| 320012 | Last Name (32) | From P2K_HR_IDENTITIES, last_name | |
| 320013 | First,Last Name (32) | From P2K_HR_IDENTITIES, first_name ', ' last_name | |
| 320014 | Last,First Name (32) | From P2K_HR_IDENTITIES, last_name ', ' first_name | |
| 320015 | Trial Run (32) | From parameter P_TRIAL (Trial Run) | The value of 'Y' or 'N' is always returned in P_TRIAL. If NULL is entered, P_TRIAL is set to 'N' |
| 320020 | Batch Number (32) | From P2K_PR_BATCHES, batch_number | |
| 320030 | Pay Run Number (32) | From P2K_PR_PAY_RUNS, pay_run_number | |
| 320031 | Pay Run Sequence (32) | From P2K_PR_PAY_HEADERS, pay_run_sequence | |
| 320040 | Hired Date (32) | From P2K_HR_EMPLOYMENTS, hire_date | |
| 320041 | Term Date (32) | From P2K_HR_EMPLOYMENTS, termination_date | |
| 320042 | Seniority Date (32) | From P2K_HR_EMPLOYMENTS, seniority_date | |
| 320043 | First Work Date (32) | From P2K_HR_EMPLOYMENTS, first_work_date | |
| 320044 | Last Work Date (32) | From P2K_HR_EMPLOYMENTS, last_work_date | |
| 320100 | Pay Header Stage | From P2K_PR_PAY_HEADERS, pay_header_stage | |
| 320101 | Pay Number (32) | From P2K_PR_PAY_HEADERS, pay_number | |
| 320102 | Pay Period (32) | From P2K_PR_PAY_HEADERS, pay_period | |
| 320103 | Pay Period Start (32) | From P2K_PR_PAY_PERIODS, pay_period_start_date of the pay header | |
| 320104 | Pay Period End Date (32) | From P2K_PR_PAY_PERIODS, pay_period_end_date of the pay header | |
| 320105 | Pay Issue Date (32) | From P2K_PR_PAY_HEADERS, pay_issue_date | |
| 320106 | Period Fiscal (32) | From Pay Period Fiscal of Pay Header | |
| 320107 | Period Fiscal Start (32) | From Fiscal Start Date of Pay Period Fiscal | |
| 320108 | Period Fiscal End (32) | From Fiscal End Date of Pay Period Fiscal | |
| 320109 | Issue Fiscal (32) | From Pay Issue Fiscal of Pay Header | |
| 320110 | Issue Fiscal Start (32) | From Fiscal Start Date of Pay Issue Fiscal | |
| 320111 | Issue Fiscal End (32) | From Fiscal End Date of Pay Issue Fiscal | |
| 320200 | G/L Company Code (32) | From P2K_CM_ENTITIES, GL Company Code | |
| 320201 | Entity Code (32) | From P2K_CM_ENTITIES, Entity Code | |
| 320202 | Entity Name (32) | From P2K_CM_ENTITIES, Entity Name | |
| 320203 | Payroll Code (32) | From P2K_PR_PAYROLLS, Payroll Code | |
| 320204 | Payroll Desc (32) | From P2K_PR_PAYROLLS, Payroll description | |
| 320205 | Unit Code (32) | From P2K_CM_UNITS, Unit Code | |
| 320206 | Unit Name (32) | From P2K_CM_UNIT_DETAILS, Unit Name | |
| 320207 | Group Code (32) | From P2K_CM_GROUPS,Group Code | |
| 320208 | Group Desc (32) | From P2K_CM_GROUP_DETAILS, Group Description | |
| 320209 | Department Code (32) | From Pay Header assignment Department Code on P2K_CM_DEPARTMENTS or Pay Line Department Code if exists | |
| 320210 | Department Name (32) | From Pay Header assignment Department Name on P2K_CM_DEPARTMENT_DETAILS or Pay Line Department name if exists | |
| 320211 | Job Code (32) | From Pay Header assignment Job Code on P2K_CM_JOBS or Pay Line Job Code if exists | |
| 320212 | Job Title (32) | From Pay Header assignment Job Title on P2K_CM_JOB_DETAILS or Pay Line Job Title if exists | |
| 320213 | Position Code (32) | From Pay Header assignment Position Code on P2K_CM_POSITIONS or Pay Line Position Code if exists | |
| 320214 | Position Title (32) | From Pay Header assignment Position Title on P2K_CM_POSITION_DETAILS or Pay Line Position Title if exists | |
| 320215 | Assignment Code (32) | From Pay Header assignment Code on P2K_HR_ASSIGNMENTS or Pay Line assignment Code if exists | |
| 320216 | Assignment Title (32) | From Pay Header assignment Title on P2K_HR_ASSIGNMENT_DETAILS or Pay Line assignment Code Title if exists | |
| 320217 | Pay Category Code (32) | From Pay Header pay_category_code on P2K_PR_PAY_CATEGORIES | |
| 320218 | Check Number (32) | From Pay Header Check Number on P2K_PR_CHECKS | |
| 320219 | Check Amount (32) | From Pay Header Check Amount on P2K_PR_CHECKS | |
| 320220 | User Name (32) | From Pay Header User Name on P2K_AM_USERS | |
| 320221 | Work State/Prov (32) | From Pay Header Work State/Prov on P2K_PR_PAY_HEADERS | |
| 320222 | Res State/Prov (32) | From Pay Header Residence State/Prov on P2K_PR_PAY_HEADERS | |
| 320223 | Work GEO Code (32) | From Pay Header Work Jurisdiction GEO Code on P2K_CM_TAX_JURISDICTIONS | |
| 320224 | Res GEO Code (32) | From Pay Header Residence Jurisdiction GEO Code on P2K_CM_TAX_JURISDICTIONS | |
| 320225 | Work Jurisdiction (32) | From Pay Header Work Jurisdiction on P2K_PR_PAY_HEADERS | |
| 320226 | Res Jurisdiction (32) | From Pay Header Residence Jurisdiction on P2K_PR_PAY_HEADERS | |
| 320227 | School District (32) | From Pay Header School District on P2K_PR_PAY_HEADERS | |
| 320230 | Std Wage (eas) (32) | From Pay Header Assignment Std Wage | |
| 320231 | Wage Basis (eas) (32) | From Pay Header Assignment Wage Basis | |
| 320232 | Authorization Code (32) | Authorization area is from pay header or pay line's assignment, then position, then department | |
| 320300 | PC Code (32) | The PC Code of the current pay line detail or pay amount | |
| 320301 | PC Abbrev (32) | The PC Abbreviation of the current pay line detail or pay amount | |
| 320302 | PC Amount (32) | The PC Amount of the current pay line detail or pay amount | |
| 320303 | Element Code (32) | You should specify the 'Element Code' in IDIF Constant Value | |
| 320304 | Element PC Value (32) | You should specify the 'Element Code' in IDIF Constant Value | If the PC Code of the current pay line detail or pay amount is in the element, then the PC Amount is included |
| 320305 | Element Desc (32) | You should specify the 'Element Code' in IDIF Constant Value | |
| 320306 | Element pph Value (32) | You should specify the 'Element Code' in IDIF Constant Value | this returns the Element Value of this Pay Header PPH_ID |
| 320400 | Start Date (ppl) (32) | From Pay Line Start Date on P2K_PR_PAY_LINES | |
| 320401 | Time (ppl) (32) | From Pay Line Time on P2K_PR_PAY_LINES | |
| 320402 | Time Basis (ppl) (32) | From Pay Line Time Basis on P2K_PR_PAY_LINES | |
| 320403 | Std Wage (ppl) (32) | From Pay Line Std Wage on P2K_PR_PAY_LINES | |
| 320404 | Wage Basis (ppl) (32) | From Pay Line Wage Basis on P2K_PR_PAY_LINES | |
| 320405 | Cost Center (ppl) (32) | From Pay Line Cost Center on P2K_CM_COST_CENTERS | |
| 320406 | Cost Center Desc (32) | From Pay Line Cost Center description on P2K_CM_COST_CENTERS | |
| 320407 | Work Order (ppl) (32) | From Pay Line Work Order on P2K_PR_PAY_LINES | |
| 320408 | Reference Info (ppl) (32) | From Pay Line Reference Info on P2K_PR_PAY_LINES | |
| 320409 | Tran Pointer (ppl) (32) | From Pay Line Transaction Pointer on P2K_PR_PAY_LINES | |
| 320410 | Pay Line ID (ppl_id) (32) | From Pay Line ID | |
| 320411 | Pay Line Detail (ppld_id) (32) | From Pay Line Detail ID | |
| 320500 | Wage Rate (ppld) (32) | From Pay Line Detail Wage Rate on P2K_PR_PAY_LINE_DETAILS | |
| 320501 | Rate Basis (ppld) (32) | From Pay Line Detail Rate Basis on P2K_PR_PAY_LINE_DETAILS | |
| 320502 | Tran Pointer (ppld) (32) | From Pay Line Detail Transaction Pointer on P2K_PR_PAY_LINE_DETAILS | |
| 320600 | Total Value (32) | User should specify the Rec# and Field # to be totaled in IDIF Constant Value field e.g. if Rec # 50 Field # 70 specifies the hours for each employee and need to be totaled for the trailer record, then for trailer record entry, you should specify 'Total Value' with Constant Value = 5070 | This Total Value is available for Header and Trailer records. Multiple Rec# and Field # are allowed in the Constant field e.g. [611] + [612] + [613] + [623] - [624]. This means calculate the Totals for Rec# 61 Fld# 1 + Rec# 61 Fld# 2 + Rec# 61 Fld# 3 + Rec# 62 Fld# 3 - Rec# 62 Fld# 4. Any arithmetic operator can be used: +, -, *, /Note: The Accum Option and Total Option must be set for the Rec# Fld# that are specified in this Constant field, i.e.Rec# 61 Fld# 1 etc |
| 320601 | Detail Record Count (32) | Contains the Record Count of each set of Rec# 30-69 in the interface file, i.e. one set of IDIF Record Type of 'DetailRecord', can be used as employee count e.g. if an employee's one detail record generates three different Record types with Rec# 50, 60, 65, it counts as one because it is for one detail record | This Record Count is available for Header and Trailer records |
| 320602 | All Detail Count (32) | Contains the Record Count of all Rec# 30-69 in the interface file e.g. if an employee's one detail record generates 3 different Record types with Rec# 50, 60, 65, it counts as 3 because there are 3 entries generated on interface file | This Record Count is available for Header and Trailer records |
| 320603 | User Calc (32) | Indicates this Rec#/Fld# will invoke a UserCalc. You should enter the UserCalc Name in the Constant Value field | |
| 320604 | XML Begin Tag (32) | Indicates this Rec#/Fld# is for XML Begin tag | You should enter the XML tag in the XML tag field, if XML tag field is not specified, the Field name is used as XML tag. You should specify XML tag option for this field. If XML tag option is not specified, this XML tag is an optional tag. If you use 320604-XML Begin tag to define the XML tags, you must use 320605-XML End tag to pair with the XML Begin tag. You should use one of the following ways to define XML tags:1) use 320002-XML tag for all Begin and End tags i.e. you specify <Request> and </Request> 2) use 320604-XML Begin tag and 320605-XML End tag . This allows you to use XML tag option to indicate if the XML tag is mandatory or optional. You must not use 320002-XML tag to mix with 320604/320605 definition |
| 320605 | XML End Tag (32) | Indicates this Rec#/Fld# is for XML End tag | See 320604- XML Begin tag for detail |
| 320606 | UDF (EID) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_HR_IDENTITIES (EID) | You must define the UDF on IMUF screen for P2K_HR_IDENTITIES and then enter the value on IEID screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen |
| 320607 | UDF (EEM) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_HR_EMPLOYMENTS (EEM) | You must define the UDF on IMUF screen for P2K_HR_EMPLOYMENTS and then enter the value on IEEI screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen |
| 320608 | UDF (EPS) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_HR_PERSONALS (EPS) | You must define the UDF on IMUF screen for P2K_HR_PERSONALS and then enter the value on IEPI screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen |
| 320610 | UDF (EASD) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_HR_ASSIGNMENT_DETAILS (EASD) | User must define the UDF on IMUF screen for P2K_HR_ASSIGNMENT_DETAILS and then enter the value on IEAS screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-UpdateRecord', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen. |
| 320621 | UDF (DED) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_CM_ENTITY_DETAILS (DED) | User must define the UDF on IMUF screen for P2K_CM_ENTITY_DETAILS and then enter the value on IDEN screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen |
| 320623 | UDF (DDD) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_CM_DEPARTMENT_DETAILS (EASD) | P2K_CM_DEPARTMENT_DETAILS and then enter the value on IDDP screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen |
| 320624 | UDF (DLN) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_CM_LOCATIONS (DLN) | User must define the UDF on IMUF screen for P2K_CM_LOCATIONS and then enter the value on IDLN screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen |
| 320626 | UDF (DUD) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_CM_UNIT_DETAILS (DUD) | User must define the UDF on IMUF screen for P2K_CM_UNIT_DETAILS and then enter the value on IDUN screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen |
| 320628 | UDF (DGD) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_CM_GROUP_DETAILS (DGD) | User must define the UDF on IMUF screen for P2K_CM_GROUP_DETAILS and then enter the value on IDGR screen Effective date sections. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be Inserted or Updated, you do not need to set up UDF on IMUF screen |
| 320629 | UDF (PRN) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_PR_PAY_RUNS (PRN) | User must define the UDF on IMUF screen for P2K_PR_PAY_RUNS and then enter the value on IPVP screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen |
| 320630 | UDF (PPH) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_PR_PAY_LINES (PPL) | User must define the UDF on IMUF screen for P2K_PR_PAY_LINES and then enter the value on IPPH screen. On IDIF screen, you must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type '92-Update Record', in non-Trial mode, this UDF will be inserted or updated, you do not need to set up UDF on IMUF screen |
| 320631 | UDF (PPL) (32) | ||
| 320632 | UDF (IDIF) (32) | Indicates this Rec#/Fld# contains a UDF value from P2K_CM_INTERFACE_FORMATS (DIF). | User must enter the IMUF UDF name in the Constant Value field. If this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen |
| 320650 | Statistic Amt (IEST) (65) | Indicates this Rec#/Fld# contains a Statistics value from P2K_HR_STATISTICS (EST) | User must define the Statistics Code on IDSC screen for P2K_CM_STATISTIC_COMPONENTS and then enter the value on IEST screen. On IDIF screen, you must enter the IDSC Statistics Code in the Constant Value field. On IDIF screen, you must enter the IDSC Statistics Code in the Constant Value field |
| 320651 | Employee Count | Contains the Employee Count of each set of Detail Record Type 20, 21, 22, 23, 24, 25 in the interface file, i.e. one set of IDIF Record Type of ‘Detail Record’, count as 1 towards the employee count if the same employee has not been counted. e.g. if an employee’s one detail record generates 3 different Record types with Rec# 50, 60, 65, it counts as 1 because it is for one employee; If the employee is being bypassed by the BYPASS derivation or the *SKIPREC#* derivation, this record entry will not be used in the Employee Count; This Employee Count is available for Header and Trailer records | |
| 320700 | Journal Entry ID (PJE) (32) | This field holds the id of the current Journal Entry | |
| 320701 | Distr Code (PJE) (32) | From Distribution Code on P2K_PR_JOURNAL_ENTRIES | |
| 320702 | Journal Source (PJE) (32) | From Journal Source on P2K_PR_JOURNAL_ENTRIES | |
| 320703 | G/L Post Number (PJE) (32) | From GL Post Numberon P2K_PR_JOURNAL_ENTRIES | |
| 320704 | G/L Post Seq (PJE) (32) | From GL Post Sequence on P2K_PR_JOURNAL_ENTRIES | |
| 320705 | Trial Journal (PJE) (32) | From Trial Journal on P2K_PR_JOURNAL_ENTRIES | |
| 320750 | Journal Detail ID (PJD) (32) | This field holds the id of the current Journal Detail | |
| 320751 | Pay Line ID (PJD) (32) | This field holds the PPL_ID of the current Journal Detail | |
| 320752 | Pay Detail ID (PJD) (32) | This field holds the PPLD_ID of the current Journal Detail | |
| 320753 | Pay Trans ID (PJD) (32) | This field holds the PTR_ID of the current Journal Detail | |
| 320754 | G/L Fund ID (PJD) (32) | This field holds the DGF_ID of the current Journal Detail | |
| 320755 | Time Code PTRC_ID (PJD) (32) | This field holds the PTRC_ID of the current Journal Detail | |
| 320756 | G/L Eff Date (PJD) (32) | From GL Effective Date on P2K_PR_JOURNAL_DETAILS | |
| 320757 | G/L Amount (PJD) (32) | From GL Amount on P2K_PR_JOURNAL_DETAILS | |
| 320758 | G/L Amt DR (PJD) (32) | From GL Amount if amount is positive, otherwise 0 | |
| 320759 | G/L Amt CR (PJD) (32) | From GL Amount if amount is negative,otherwise 0 | |
| 320760 | G/L Amt-Financial (PJD) (32) | From GL Amount if the DGA G/L Account Journal Type for this PJD = '01-Financial', otherwise 0 | |
| 320761 | G/L Amt-Statistical (PJD) (32) | From GL Amount if the DGA G/L Account Journal Type for this PJD = '01-Financial', otherwise 0 | |
| 320762 | G/L Amt-Time Usage (PJD) (32) | From GL Amount if the PC Usage Code for this PJD pay component = '10- Time', otherwise 0 | |
| 320763 | G/L Amt-Earn Usage (PJD) (32) | From GL Amount if the PC Usage Code for this PJD pay component = '11- Earnings', otherwise 0 | |
| 320764 | G/L Amt-Dedn Usage (PJD) (32) | From GL Amount if the PC Usage Code for this PJD pay component = '12- Deduction', otherwise 0 | |
| 320765 | G/L Amt-Ben Usage (PJD) (32) | From GL Amount if the PC Usage Code for this PJD pay component = '13- Benefit', otherwise 0 | |
| 320780 | Split Percent (PJD) (32) | From Split Percent on P2K_PR_JOURNAL_DETAILS | |
| 320781 | G/L Detail Seq (PJD) (32) | From GL Detail Sequence on P2K_PR_JOURNAL_DETAILS | |
| 320782 | Work Order (PJD) (32) | From Work Order on P2K_PR_JOURNAL_DETAILS | |
| 320783 | G/L Pointer (PJD) (32) | From GL Pointer on P2K_PR_JOURNAL_DETAILS | |
| 320800 | G/L Account ID (DGA) (32) | This field holds the id of the G/L Account of current journal entry | |
| 320801 | G/L Account Code (DGA) (32) | From GL Account Code on P2K_CM_GL_ACCOUNTS of current G/L Account | |
| 320802 | 0802 Account Type (DGA) (32) | From GL Account Type on P2K_CM_GL_ACCOUNTS of current G/L Account | |
| 320803 | Journal Type (DGA) (32) | From Journal Type on P2K_CM_GL_ACCOUNTS | |
| 320804 | 0804 Account Usage (DGA) (32) | From Account Usage on P2K_CM_GL_ACCOUNTS | |
| 320805 | 0805 Account Desc (DGA) (32) | From Account Desc on P2K_CM_GL_ACCOUNTS | |
| 320806 | Distr Mask (DGA) (32) | From Distribution Mask on P2K_CM_GL_ACCOUNTS | |
| 320807 | Affects Costing (DGA) (32) | From Affects Costing on P2K_CM_GL_ACCOUNTS | |
| 320808 | Pre Payroll (DGA) (32) | From Pre Payroll on P2K_CM_GL_ACCOUNTS | |
| 320809 | Post Payroll (DGA) (32) | From Post Payroll on P2K_CM_GL_ACCOUNTS | |
| 320810 | Retain Detail (DGA) (32) | From Retain Detail on P2K_CM_GL_ACCOUNTS | |
| 320811 | Accrued Required (DGA) (32) | From Accrued Required on P2K_CM_GL_ACCOUNTS | |
| 320812 | I/C Required (DGA) (32) | From I/C Required on P2K_CM_GL_ACCOUNTS | |
| 320813 | Posting Date Method (DGA (32) | From Posting Date Method on P2K_CM_GL_ACCOUNTS | |
| 320814 | G/L Acct Suffix (DGA) (32) | From GL Acct Suffixon P2K_CM_GL_ACCOUNTS | |
| 320815 | Acct Charge To (DGA) (32) | From Acct Charge To on P2K_CM_GL_ACCOUNTS | |
| 320900 | Pay Component ID (PPC) (32) | This field holds the id of the Pay Component of current journal detail | |
| 320901 | PC Code (PPC) (32) | From PC Code on P2K_PR_PAY_COMPONENTS | |
| 320902 | PC Abbrev (PPC) (32) | From PC Abbreviation on P2K_PR_PAY_COMPONENTS | |
| 320903 | PC Desc (PPC) (32) | From PC Description on P2K_PR_PAY_COMPONENTS | |
| 320904 | PC Action (PPC) (32) | From PC Action on P2K_PR_PAY_COMPONENTS | |
| 320905 | Store Results (PPC) (32) | From Store Results on P2K_PR_PAY_COMPONENTS | |
| 320920 | PC Usage ID (PCU) (32) | This field holds the id of the Pay Component Usage of the pay component of the current journal detail | |
| 320921 | PC Usage Code (PCU) (32) | From PC Usage Code on P2K_PR_PC_USAGES | |
| 320922 | PC Usage Type (PCU) (32) | From PC Usage Type on P2K_PR_PC_USAGES | |
| 320923 | PC Usage Desc (PCU) (32) | From PC Usage Description on P2K_PR_PC_USAGES | |
| 320924 | Unique Item (PCU) (32) | From Unique Item on P2K_PR_PC_USAGES | |
| 320925 | Mandatory (PCU) (32) | From Mandatory on P2K_PR_PC_USAGES | |
| 320926 | Legislation (PCU) (32) | From Legislation on P2K_PR_PC_USAGES | |
| 320927 | PC G/L Type (PCU) (32) | From PC GL Type on P2K_PR_PC_USAGES | |
| 321000 | Pays Per Year (PPP) (32) | ||
| 327010 | Read IMCT Custom Key (32) | Read IMCT Custom Table Key of the specified UPPHF list of Custom Table Names | |
| 327011 | Read IMCT Custom Subkey (32) | Read IMCT Custom Table Subkey of the specified UPPHF list of Custom Table Names | |
| 327012 | Read IMCT Custom Data (32) | Read IMCT Custom Table Data of the specified UPPHF list of Custom Table Names |
