EXD_SHP_LOC_VW

(SQL View)
 Index Back

Get Org Tax Loc


SELECT DISTINCT A.BUSINESS_UNIT , A.ORG_TAX_LOC_CD FROM PS_EXD_SHP_INV_HDR A WHERE A.EXD_INV_STATUS IN ('R','P') AND A.EXD_PRT_FLG = 'N' AND A.ORG_TAX_LOC_CD <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORG_TAX_LOC_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code. An Organization can have multiple Tax Location Codes.