The G/L Buffer is a field that allows manipulation of multiple variables in a [derivation expression|DERIVATION_EXPRESSION_USAGE] 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. This can be used in quite sophisticated derivations, as shown in these examples: # [Burden Code manipulation|GL BUFFER EXAMPLE 01] # [Using GL Buffer to determine bypassing|GL BUFFER EXAMPLE 02] # [Changing Dates based on Journal Source|GL BUFFER EXAMPLE 03] Note: Some of the values below will only be accessible when the IDGA ‘Retain Detail’ toggle is turned on. If the toggle is not turned on, then the G/L Accounts are posted in Summary and therefore each employee’s information will be re-set to NULL. When posting in Summary, some items such as the check number will not be populated. The substring values for GL BUFFER are as follows: ||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 ---- ![Notes|Edit:Internal.GL BUFFER] [{InsertPage page='Internal.GL BUFFER' default='Click to create a new notes page'}]