The G/L Buffer is a field that allows manipulation of multiple variables in a derivation expression in UPGLF. The variables, and their meaning are as described for the IDIF X_INF_VARIABLE_NAME (01).
This variable, if left alone will return a 672 byte value which is a concatenation of the values used in the generation of each record for the GL file. Using the SQL substring function SUBSTR, we can extract bits and pieces and manipulate it within the derivation expression
Start | Length | Returns |
---|---|---|
001 | 016 | gl_company_code |
017 | 002 | journal_source |
019 | 002 | journal_type |
021 | 002 | currency |
023 | 006 | fiscal_period |
029 | 011 | fiscal_start (DD-Mon-YYYY) |
040 | 011 | fiscal_end (DD-Mon-YYYY) |
051 | 050 | distribution_code |
101 | 016 | gl_account_code |
117 | 002 | gl_account_type |
119 | 016 | person_code |
135 | 004 | pay_number |
139 | 004 | pc_code |
143 | 006 | pay_period |
149 | 011 | period_start_date (DD-Mon-YYYY) |
160 | 011 | period_end_date (DD-Mon-YYYY) |
171 | 011 | pay_issue_date (DD-Mon-YYYY) |
182 | 011 | gl_as_of_date (DD-Mon-YYYY) |
193 | 030 | first_name |
223 | 030 | last_name |
253 | 016 | gl_amt |
269 | 016 | gl_amt_dr |
285 | 016 | gl_amt_cr |
301 | 010 | std_wage_rate |
311 | 016 | entity_code |
327 | 016 | department_code |
343 | 016 | position_code |
359 | 016 | job_code |
375 | 016 | payroll_code |
391 | 016 | unit_code |
407 | 016 | group_code |
423 | 010 | check_number |
433 | 010 | user_name |
443 | 010 | work_state |
453 | 010 | res_state |
463 | 010 | work_geo |
473 | 010 | res_geo |
483 | 010 | school_district |
493 | 030 | reference_info |
523 | 050 | work_order |
573 | 016 | cost_center |
599 | 030 | tran_pointer |
623 | 010 | batch_number |
633 | 010 | time_entered |
643 | 002 | time_basis |
645 | 010 | std_wage_rate |
655 | 002 | std_wage_rate_basis |
657 | 010 | wage_rate |
667 | 002 | rate_basis |
669 | 004 | pc_usage_code |
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation