Klasy księgowania PWT.
UWAGA – po zmianie definicji klasy księgowania PWT, na zleceniach pozostają stare konta !!!
Aby użyć nowych kont, należy utworzyć nowe zlecenie.
tak musi być, aby generator kont (RW) i menadżer kosztów (dostawy bezpośrednie) pobierały odpowiednie konta.
SELECT wa.class_code, wa.description, gc1.segment1 || '-' || gc1.segment2 || '-' || gc1.segment3 || '-' || gc1.segment4 || '-' || gc1.segment5 || '-' || gc1.segment6 || '-' || gc1.segment7 || '-' || gc1.segment8 || '-' || gc1.segment9 usługi, gc2.segment1 || '-' || gc2.segment2 || '-' || gc2.segment3 || '-' || gc2.segment4 || '-' || gc2.segment5 || '-' || gc2.segment6 || '-' || gc2.segment7 || '-' || gc2.segment8 || '-' || gc2.segment9 usługi_odchylenia, gc3.segment1 || '-' || gc3.segment2 || '-' || gc3.segment3 || '-' || gc3.segment4 || '-' || gc3.segment5 || '-' || gc3.segment6 || '-' || gc3.segment7 || '-' || gc3.segment8 || '-' || gc3.segment9 usługi_koszty_ogólne, gc4.segment1 || '-' || gc4.segment2 || '-' || gc4.segment3 || '-' || gc4.segment4 || '-' || gc4.segment5 || '-' || gc4.segment6 || '-' || gc4.segment7 || '-' || gc4.segment8 || '-' || gc4.segment9 zasoby, gc5.segment1 || '-' || gc5.segment2 || '-' || gc5.segment3 || '-' || gc5.segment4 || '-' || gc5.segment5 || '-' || gc5.segment6 || '-' || gc5.segment7 || '-' || gc5.segment8 || '-' || gc5.segment9 zasoby_odchylenia, gc6.segment1 || '-' || gc6.segment2 || '-' || gc6.segment3 || '-' || gc6.segment4 || '-' || gc6.segment5 || '-' || gc6.segment6 || '-' || gc6.segment7 || '-' || gc6.segment8 || '-' || gc6.segment9 materiały, gc7.segment1 || '-' || gc7.segment2 || '-' || gc7.segment3 || '-' || gc7.segment4 || '-' || gc7.segment5 || '-' || gc7.segment6 || '-' || gc7.segment7 || '-' || gc7.segment8 || '-' || gc7.segment9 materiały_odchylenia, gc8.segment1 || '-' || gc8.segment2 || '-' || gc8.segment3 || '-' || gc8.segment4 || '-' || gc8.segment5 || '-' || gc8.segment6 || '-' || gc8.segment7 || '-' || gc8.segment8 || '-' || gc8.segment9 koszty_ogólne, gc9.segment1 || '-' || gc9.segment2 || '-' || gc9.segment3 || '-' || gc9.segment4 || '-' || gc9.segment5 || '-' || gc9.segment6 || '-' || gc9.segment7 || '-' || gc9.segment8 || '-' || gc9.segment9 koszty_ogólne_odchylenia FROM wip.WIP_ACCOUNTING_CLASSES wa -- klasy księgowania PWT ,apps.gl_code_combinations gc1 -- konta ,apps.gl_code_combinations gc2 ,apps.gl_code_combinations gc3 ,apps.gl_code_combinations gc4 ,apps.gl_code_combinations gc5 ,apps.gl_code_combinations gc6 ,apps.gl_code_combinations gc7 ,apps.gl_code_combinations gc8 ,apps.gl_code_combinations gc9 WHERE 1 = 1 AND wa.organization_id =(SELECT organization_id FROM apps.mtl_parameters mp WHERE mp.organization_code = UPPER('&kod_magazynu')) AND wa.material_account = gc1.code_combination_id AND wa.material_variance_account = gc2.code_combination_id AND wa.material_overhead_account = gc3.code_combination_id AND wa.resource_account = gc4.code_combination_id AND wa.resource_variance_account = gc5.code_combination_id AND wa.outside_processing_account = gc6.code_combination_id AND wa.outside_proc_variance_account = gc7.code_combination_id AND wa.overhead_account = gc8.code_combination_id AND wa.overhead_variance_account = gc9.code_combination_id AND wa.disable_date IS NULL -- eliminuje konta wyłączone |