EXD_BU_VW

(SQL View)

SELECT ORG_BU_TYPE ,ORG_TAX_LOC_CD ,ORG_CODE , BUSINESS_UNIT FROM PS_ORG_BU_TAX_APPL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ORG_BU_TYPE Character(2) VARCHAR2(2) NOT NULL Business Unit Type. This field will have six translate values representing the various BUs
AP=Payables
AR=Receivables
BI=Billing
IN=Inventory
OM=Order Management
PO=Purchasing

2 ORG_TAX_LOC_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code. An Organization can have multiple Tax Location Codes.

3 ORG_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code. This will be unique to an Organization.

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ORG_BU_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Business Unit Type. This field will have six translate values representing the various BUs AP=Payables AR=Receivables BI=Billing IN=Inventory OM=Order Management PO=Purchasing
2	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes.
3	ORG_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization.
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit