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

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

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
34 26-Nov-2021 10:22 21 KB JAiken to previous
33 26-Nov-2021 10:22 21 KB JEscott to previous | to last
32 26-Nov-2021 10:22 21 KB JEscott to previous | to last
31 26-Nov-2021 10:22 21 KB JEscott to previous | to last
30 26-Nov-2021 10:22 21 KB JEscott to previous | to last
29 26-Nov-2021 10:22 21 KB JEscott to previous | to last
28 26-Nov-2021 10:22 21 KB JEscott to previous | to last
27 26-Nov-2021 10:22 21 KB JEscott to previous | to last
26 26-Nov-2021 10:22 21 KB JEscott to previous | to last
25 26-Nov-2021 10:22 21 KB JEscott to previous | to last
24 26-Nov-2021 10:22 21 KB JEscott to previous | to last
23 26-Nov-2021 10:22 21 KB JEscott to previous | to last
22 26-Nov-2021 10:22 21 KB JEscott to previous | to last
21 26-Nov-2021 10:22 21 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
GENERAL LEDGER ACCOUNTS
GENERAL LEDGER ACCOUNTS

Version management

Difference between version and

At line 343 added 18 lines
||GL SUFFIX TYPE ||IDGA ACCOUNT SUFFIX INFORMATION
|01 – Entity| - From pay Header Payroll, retrieves Entity den_id\\- All other suffix information is not used
|02 – Unit| - From Pay Header Payroll, retrieves Entity den_id\\- Then retrieves Pay Header Unit dun_id\\- All other suffix information is not used
|03 – Group|- From Pay Header Payroll, retrieves Entity den_id\\- Then retrieves Pay Header Unit dun_id and Group dgr_id\\- All other suffix information is not used
|10 – Canada Province|- From Pay Header Work State/Prov, retrieves dsp_id\\- All other suffix information must not exist
|20 – US Work State|- From Pay Header Work State/Prov, retrieves dsp_id\\- All other suffix information must not exist
|21 – US Work County |- From Pay Header Work State/Prov, retrieves dsp_id\\- Then use Pay Header Work Jurisdiction, retrieves the County dcn_id of this tax\\jurisdiction\\ SELECT dtx.dcn_id\\ INTO v_dga_dcn_id\\ FROM p2k_cm_tax_jurisdictions dtx\\ WHERE dtx.id = p2k_ppgl.k_pph.dtX_id_wo \\-All other suffix information is not used
|22 – US Work GEO |- From Pay Header Work State/Prov, retrieves dsp_id\\- Then use Pay Header Work Jurisdiction, retrieves dtx_id\\- All other suffix information is not used
|23 – US Res State|- From Pay Header Home State/Prov, retrieves dsp_id\\- All other suffix information is not used
|24 – US Res County | From Pay Header Home State/Prov, retrieves dsp_id\\= Then use Pay Header Home Jurisdiction, retireves the County dcn_id of this tax\\jurisdiction\\ SELECT dtx.dcn_id\\ INTO v_dga_dcn_id\\ FROM p2k_cm_tax_jurisdictions dtx\\ WHERE dtx.id = p2k_ppgl.k_pph.dtx_id_home\\- All other suffix information is not used
|25 – US RES GEO|- From Pay Header Home State/Prov, retrieves dsp_id\\- Then use Pay Header Home Jurisdiction, retrieves dtx_id\\- All other suffix information is not used
|26 – US School District |- From Pay Header Home State/Prov, retrieves dsp_id\\- Then use Pay Header School District, retireves dsd_id\\- All other suffix information is not used
|30 – Assignment Type|- If processing for a Pay Line, then use the Pay Line Assignment to retrieve the\\Assignment Type, otherwise use the primary Assignment to retrieve the Assignment\\Type\\- All other suffix information is not used
After the appropriate suffix information is derived, then [UPLG]/[UPGL] uses the GL Account Code from [IPPC] along with the suffix information and retrieves an entry from [IDGA] that matches the suffix information.
If [IDGA] does not have an entry that matches the suffix information, then the default GL Account entry is used.
This page (revision-34) was last changed on 26-Nov-2021 10:22 by JAikenTop