ITA_BU_GL_VW

(SQL View)
 Index Back

VAT Entity for GL BU

GL Bus Units for VAT Entity

SELECT DISTINCT C.VAT_ENTITY , 'VCHR' ,D.BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_GL A , PS_BUS_UNIT_TBL_FS B , PS_VAT_ENT_BU_GL C , PS_BUS_UNIT_TBL_AP D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.BUSINESS_UNIT_GL = A.BUSINESS_UNIT UNION SELECT DISTINCT C.VAT_ENTITY , 'AR' ,D.BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_GL A , PS_BUS_UNIT_TBL_FS B , PS_VAT_ENT_BU_GL C , PS_BUS_UNIT_TBL_AR D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.BUSINESS_UNIT_GL = A.BUSINESS_UNIT UNION SELECT DISTINCT C.VAT_ENTITY , 'BILL' ,D.BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_GL A , PS_BUS_UNIT_TBL_FS B , PS_VAT_ENT_BU_GL C , PS_BUS_UNIT_TBL_BI D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.BUSINESS_UNIT_GL = A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
2 ITA_PRODUCT Character(4) VARCHAR2(4) NOT NULL Product
AR=Receivables
BILL=Billing
VCHR=Payables
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_GL_NONVW