EX_CNTRYFRGN_VW

(SQL View)
 Index Back

SELECT a.BUSINESS_UNIT_GL , b.COUNTRY FROM PS_EX_SHEET_HDR a ,PS_EX_SHEET_LINE b WHERE a.SHEET_ID=b.SHEET_ID AND b.VAT_TREATMENT IN ('FGE','FSE')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country