This page (revision-12) was last changed on 26-Nov-2021 10:22 by khiggs

This page was created on 26-Nov-2021 10:22 by RForbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
12 26-Nov-2021 10:22 26 KB khiggs to previous
11 26-Nov-2021 10:22 26 KB khiggs to previous | to last
10 26-Nov-2021 10:22 26 KB rforbes to previous | to last
9 26-Nov-2021 10:22 24 KB rforbes to previous | to last
8 26-Nov-2021 10:22 24 KB RForbes to previous | to last
7 26-Nov-2021 10:22 24 KB JEscott to previous | to last
6 26-Nov-2021 10:22 24 KB JEscott to previous | to last
5 26-Nov-2021 10:22 23 KB JEscott to previous | to last
4 26-Nov-2021 10:22 21 KB JEscott to previous | to last
3 26-Nov-2021 10:22 15 KB JEscott to previous | to last
2 26-Nov-2021 10:22 10 KB JEscott to previous | to last
1 26-Nov-2021 10:22 6 KB RForbes to last

Page References

Incoming links Outgoing links
X_INF_VARIABLE_NAME (32)
X_INF_VARIABLE_NAME (32)

Version management

Difference between version and

At line 1 changed one line
!!!GL INTERFACE VARIABLES
!!!PAY HISTORY (UPPHF) INTERFACE VARIABLES
At line 13 changed one line
| 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 [{$applicationname}] 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'))
| 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 Personality 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'))
At line 15 changed one line
| 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 [{$applicationname}] functions that needed the [EID_ID]
| 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 Personality functions that needed the [EID_ID]
At line 79 changed 17 lines
| 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 |
| 320401 | Time (ppl) (32) | From Pay Line Time|
| 320402 | Time Basis (ppl) (32) |From Pay Line Time Basis |
| 320403 | Std Wage (ppl) (32) | From Pay Line Std Wage|
| 320404 | Wage Basis (ppl) (32) |From Pay Line Wage Basis |
| 320405 | Cost Center (ppl) (32) |From Pay Line Cost Center |
| 320406 | Cost Center Desc (32) | From Pay Line Cost Center description|
| 320407 | Work Order (ppl) (32) | From Pay Line Work Order|
| 320408 | Reference Info (ppl) (32) |From Pay Line Reference Info |
| 320409 | Tran Pointer (ppl) (32) | From Pay Line Transaction Pointer|
| 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|
| 320501 | Rate Basis (ppld) (32) | From Pay Line Detail Rate Basis|
| 320502 | Tran Pointer (ppld) (32) | From Pay Line Detail Transaction Pointer|
| 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
| 320306 | Element pph Value (32) | You should specify the '[Element Code|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|START_DATE] on [P2K_PR_PAY_LINES] |
| 320401 | Time (ppl) (32) | From Pay Line [Time|TIME_ENTERED] on [P2K_PR_PAY_LINES]|
| 320402 | Time Basis (ppl) (32) |From Pay Line [Time Basis|TIME_BASIS] on [P2K_PR_PAY_LINES] |
| 320403 | Std Wage (ppl) (32) | From Pay Line [Std Wage|STD_WAGE_RATE] on [P2K_PR_PAY_LINES]|
| 320404 | Wage Basis (ppl) (32) |From Pay Line [Wage Basis|STD_WAGE_RATE_BASIS] on [P2K_PR_PAY_LINES] |
| 320405 | Cost Center (ppl) (32) |From Pay Line [Cost Center|COST_CENTER_CODE] on [P2K_CM_COST_CENTERS] |
| 320406 | Cost Center Desc (32) | From Pay Line [Cost Center description|DESCRIPTION] on [P2K_CM_COST_CENTERS]|
| 320407 | Work Order (ppl) (32) | From Pay Line [Work Order|WORK_ORDER] on [P2K_PR_PAY_LINES]|
| 320408 | Reference Info (ppl) (32) |From Pay Line [Reference Info|REFERENCE_INFO] on [P2K_PR_PAY_LINES] |
| 320409 | Tran Pointer (ppl) (32) | From Pay Line [Transaction Pointer|TRANSACTION_POINTER] on [P2K_PR_PAY_LINES]|
| 320410 | Pay Line ID (ppl_id) (32) |From [Pay Line ID|PPL_ID] |
| 320411 | Pay Line Detail (ppld_id) (32) |From [Pay Line Detail ID|PPLD_ID] |
| 320500 | Wage Rate (ppld) (32) | From Pay Line Detail [Wage Rate|WAGE_RATE] on [P2K_PR_PAY_LINE_DETAILS]|
| 320501 | Rate Basis (ppld) (32) | From Pay Line Detail [Rate Basis|RATE_BASIS] on [P2K_PR_PAY_LINE_DETAILS]|
| 320502 | Tran Pointer (ppld) (32) | From Pay Line Detail [Transaction Pointer|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
At line 113 added one line
| 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
At line 114 changed 7 lines
| 320700 | Journal Entry ID (PJE) (32) | This field holds the id of the current Journal Entry|
| 320701 | Distr Code (PJE) (32) | From Journal Entry Distribution Code|
| 320702 | Journal Source (PJE) (32) | From Journal Entry Journal Source|
| 320703 | G/L Post Number (PJE) (32) | From Journal Entry GL Post Number|
| 320704 | G/L Post Seq (PJE) (32) | From Journal Entry GL Post Sequence|
| 320705 | Trial Journal (PJE) (32) | From Journal Entry Trial Journal|
| 320750 | Journal Detail ID (PJD) (32) |This field holds the id of the current Journal Detail |
| 320651 | Employee Count (32) |Contains Total Count of unique employees in the file across Detail Record Types 'Detail Record' and 'Detail Level 1'. Available for Header and Trailer records| If an employee appears in Detail Record at Rec# 45 and can also be found in 3 additional Detail Record Types with Rec# 50, 60, 65, the employee record will only be counted as 1. 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.|
| 320700 | Journal Entry ID (PJE) (32) | This field holds the [id|PJE_ID] of the current Journal Entry|
| 320701 | Distr Code (PJE) (32) | From [Distribution Code|DISTRIBUTION_CODE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320702 | Journal Source (PJE) (32) | From [Journal Source|JOURNAL_SOURCE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320703 | G/L Post Number (PJE) (32) | From [GL Post Number|GLPOST_NUMBER]on [P2K_PR_JOURNAL_ENTRIES]|
| 320704 | G/L Post Seq (PJE) (32) | From [GL Post Sequence|GLPOST_SEQUENCE] on [P2K_PR_JOURNAL_ENTRIES]|
| 320705 | Trial Journal (PJE) (32) | From [Trial Journal|TRIAL_JOURNAL] on [P2K_PR_JOURNAL_ENTRIES]|
| 320750 | Journal Detail ID (PJD) (32) |This field holds the [id|PJD_ID] of the current Journal Detail |
At line 126 changed 44 lines
| 320756 | G/L Eff Date (PJD) (32) | From Journal Detail GL Effective Date|
| 320757 | G/L Amount (PJD) (32) | From Journal Detail GL Amount|
| 320758 | G/L Amt DR (PJD) (32) | From Journal Detail GL Amount if amount is positive, otherwise 0|
| 320759 | G/L Amt CR (PJD) (32) | From Journal Detail GL Amount if amount is negative,otherwise 0|
| 320760 | G/L Amt-Financial (PJD) (32) | From Journal Detail 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 Journal Detail 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 Journal Detail 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 Journal Detail 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 Journal Detail 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 Journal Detail GL Amount if the PC Usage Code for this PJD pay component = '13- Benefit', otherwise 0|
| 320780 | Split Percent (PJD) (32) | From Journal Detail Split Percent|
| 320781 | G/L Detail Seq (PJD) (32) |From Journal Detail GL Detail Sequence |
| 320782 | Work Order (PJD) (32) | From Journal Detail Work Order|
| 320783 | G/L Pointer (PJD) (32) |From Journal Detail GL Pointer |
| 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 of current G/L Account|
| 320802 | 0802 Account Type (DGA) (32) | From GL Account Type of current G/L Account|
| 320803 | Journal Type (DGA) (32) | From GL Account Journal Type|
| 320804 | 0804 Account Usage (DGA) (32) |From GL Account - Account Usage |
| 320805 | 0805 Account Desc (DGA) (32) | From GL Account - Account Desc|
| 320806 | Distr Mask (DGA) (32) | From GL Account - Distribution Mask|
| 320807 | Affects Costing (DGA) (32) |From GL Account - Affects Costing toggle |
| 320808 | Pre Payroll (DGA) (32) | From GL Account - Pre Payroll toggle|
| 320809 | Post Payroll (DGA) (32) |From GL Account - Post Payroll toggle |
| 320810 | Retain Detail (DGA) (32) |From GL Account - Retain Detail toggle |
| 320811 | Accrued Required (DGA) (32) |From GL Account - Accrued Required toggle |
| 320812 | I/C Required (DGA) (32) | From GL Account - I/C Required toggle|
| 320813 | Posting Date Method (DGA (32) |From GL Account - Posting Date Method |
| 320814 | G/L Acct Suffix (DGA) (32) | From GL Account - GL Acct Suffix|
| 320815 | Acct Charge To (DGA) (32) | From GL Account - Acct Charge To|
| 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 Pay Component PC Code|
| 320902 | PC Abbrev (PPC) (32) |From Pay Component PC Abbreviation |
| 320903 | PC Desc (PPC) (32) | From Pay Component PC Description|
| 320904 | PC Action (PPC) (32) |From Pay Component PC Action |
| 320905 | Store Results (PPC) (32) |From Pay Component Store Results |
| 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 - PC Usage Code|
| 320922 | PC Usage Type (PCU) (32) | From PC Usage - PC Usage Type|
| 320923 | PC Usage Desc (PCU) (32) | From PC Usage - PC Usage Description|
| 320924 | Unique Item (PCU) (32) | From PC Usage - Unique Item|
| 320925 | Mandatory (PCU) (32) | From PC Usage - Mandatory|
| 320926 | Legislation (PCU) (32) |From PC Usage - Legislation |
| 320927 | PC G/L Type (PCU) (32) |From PC Usage - PC GL Type |
| 320756 | G/L Eff Date (PJD) (32) | From [GL Effective Date|GL_EFFECTIVE_DATE] on [P2K_PR_JOURNAL_DETAILS]|
| 320757 | G/L Amount (PJD) (32) | From [GL Amount|GL_AMOUNT] on [P2K_PR_JOURNAL_DETAILS]|
| 320758 | G/L Amt DR (PJD) (32) | From [GL Amount|GL_AMOUNT] if amount is positive, otherwise 0|
| 320759 | G/L Amt CR (PJD) (32) | From [GL Amount|GL_AMOUNT] if amount is negative,otherwise 0|
| 320760 | G/L Amt-Financial (PJD) (32) | From [GL Amount|GL_AMOUNT] if the DGA [G/L Account Journal Type|JOURNAL_TYPE] for this PJD = '01-Financial', otherwise 0|
| 320761 | G/L Amt-Statistical (PJD) (32) | From [GL Amount|GL_AMOUNT] if the DGA [G/L Account Journal Type|JOURNAL_TYPE] for this PJD = '01-Financial', otherwise 0|
| 320762 | G/L Amt-Time Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '10- Time', otherwise 0|
| 320763 | G/L Amt-Earn Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '11- Earnings', otherwise 0|
| 320764 | G/L Amt-Dedn Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '12- Deduction', otherwise 0|
| 320765 | G/L Amt-Ben Usage (PJD) (32) | From [GL Amount|GL_AMOUNT] if the [PC Usage Code|PC_USAGE_CODE] for this PJD pay component = '13- Benefit', otherwise 0|
| 320780 | Split Percent (PJD) (32) | From [Split Percent|SPLIT_PERCENT] on [P2K_PR_JOURNAL_DETAILS]|
| 320781 | G/L Detail Seq (PJD) (32) |From [GL Detail Sequence|GL_DETAIL_SEQUENCE] on [P2K_PR_JOURNAL_DETAILS] |
| 320782 | Work Order (PJD) (32) | From [Work Order|WORK_ORDER] on [P2K_PR_JOURNAL_DETAILS]|
| 320783 | G/L Pointer (PJD) (32) |From [GL Pointer|GL_POINTER] on [P2K_PR_JOURNAL_DETAILS] |
| 320800 | G/L Account ID (DGA) (32) |This field holds the [id|DGA_ID] of the G/L Account of current journal entry |
| 320801 | G/L Account Code (DGA) (32) | From [GL Account Code|GL_ACCOUNT_CODE] on [P2K_CM_GL_ACCOUNTS] of current G/L Account|
| 320802 | 0802 Account Type (DGA) (32) | From [GL Account Type|ACCOUNT_TYPE] on [P2K_CM_GL_ACCOUNTS] of current G/L Account|
| 320803 | Journal Type (DGA) (32) | From [Journal Type|JOURNAL_TYPE] on [P2K_CM_GL_ACCOUNTS]|
| 320804 | 0804 Account Usage (DGA) (32) |From [Account Usage|ACCOUNT_USAGE] on [P2K_CM_GL_ACCOUNTS] |
| 320805 | 0805 Account Desc (DGA) (32) | From [Account Desc|DESCRIPTION] on [P2K_CM_GL_ACCOUNTS]|
| 320806 | Distr Mask (DGA) (32) | From [Distribution Mask|DISTRIBUTION_MASK] on [P2K_CM_GL_ACCOUNTS]|
| 320807 | Affects Costing (DGA) (32) |From [Affects Costing|AFFECTS_COSTING] on [P2K_CM_GL_ACCOUNTS] |
| 320808 | Pre Payroll (DGA) (32) | From [Pre Payroll|PRE_PAYROLL] on [P2K_CM_GL_ACCOUNTS]|
| 320809 | Post Payroll (DGA) (32) |From [Post Payroll|POST_PAYROLL] on [P2K_CM_GL_ACCOUNTS] |
| 320810 | Retain Detail (DGA) (32) |From [Retain Detail|RETAIN_DETAIL] on [P2K_CM_GL_ACCOUNTS] |
| 320811 | Accrued Required (DGA) (32) |From [Accrued Required|ACCRUAL_REQUIRED] on [P2K_CM_GL_ACCOUNTS] |
| 320812 | I/C Required (DGA) (32) | From [I/C Required|INTERCOMPANY_REQUIRED] on [P2K_CM_GL_ACCOUNTS]|
| 320813 | Posting Date Method (DGA (32) |From [Posting Date Method|POSTING_DATE_METHOD] on [P2K_CM_GL_ACCOUNTS] |
| 320814 | G/L Acct Suffix (DGA) (32) | From [GL Acct Suffix|GL_ACCOUNT_SUFX]on [P2K_CM_GL_ACCOUNTS]|
| 320815 | Acct Charge To (DGA) (32) | From [Acct Charge To|ACCOUNT_CHARGE_TO] on [P2K_CM_GL_ACCOUNTS]|
| 320900 | Pay Component ID (PPC) (32) |This field holds the [id|PPC_ID] of the Pay Component of current journal detail |
| 320901 | PC Code (PPC) (32) | From [PC Code|PC_CODE] on [P2K_PR_PAY_COMPONENTS]|
| 320902 | PC Abbrev (PPC) (32) |From [PC Abbreviation|PC_ABBREVIATION] on [P2K_PR_PAY_COMPONENTS] |
| 320903 | PC Desc (PPC) (32) | From [PC Description|DESCRIPTION] on [P2K_PR_PAY_COMPONENTS]|
| 320904 | PC Action (PPC) (32) |From [PC Action|PC_ACTION] on [P2K_PR_PAY_COMPONENTS] |
| 320905 | Store Results (PPC) (32) |From [Store Results|STORE_RESULTS] on [P2K_PR_PAY_COMPONENTS] |
| 320920 | PC Usage ID (PCU) (32) | This field holds the [id|PCU_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|PC_USAGE_CODE] on [P2K_PR_PC_USAGES]|
| 320922 | PC Usage Type (PCU) (32) | From [PC Usage Type|PC_USAGE_TYPE] on [P2K_PR_PC_USAGES]|
| 320923 | PC Usage Desc (PCU) (32) | From [PC Usage Description|DESCRIPTION] on [P2K_PR_PC_USAGES]|
| 320924 | Unique Item (PCU) (32) | From [Unique Item|UNIQUE_ITEM] on [P2K_PR_PC_USAGES]|
| 320925 | Mandatory (PCU) (32) | From [Mandatory|MANDATORY] on [P2K_PR_PC_USAGES]|
| 320926 | Legislation (PCU) (32) |From [Legislation|LEGISLATION] on [P2K_PR_PC_USAGES] |
| 320927 | PC G/L Type (PCU) (32) |From [PC GL Type|PC_GL_TYPE] on [P2K_PR_PC_USAGES] |
At line 173 added 4 lines
| 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
At line 178 added 4 lines
----
![Notes|Edit:Internal.X_INF_VARIABLE_NAME (32)]
[{InsertPage page='Internal.X_INF_VARIABLE_NAME (32)' default='Click to create a new notes page'}]
This page (revision-12) was last changed on 26-Nov-2021 10:22 by khiggsTop