OMBCK_VATENT2VW (SQL View)	Index Back
Omback Vat Entity by Inv BI BU

OMBCK_VATENT2VW

(SQL View)

Omback Vat Entity by Inv BI BU

SELECT BIN.BUSINESS_UNIT, BBI.BUSINESS_UNIT, BBI.BUSINESS_UNIT_GL, VEG.VAT_ENTITY FROM PS_BUS_UNIT_TBL_IN BIN, PS_BUS_UNIT_TBL_BI BBI, PS_VAT_ENT_BU_GL VEG WHERE BIN.BUSINESS_UNIT_BI = BBI.BUSINESS_UNIT AND BBI.BUSINESS_UNIT_GL = VEG.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

2 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

4 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
2	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
3	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
4	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.