ORG_BU_LOC_VW

(SQL View)
Index Back

Tax Loc Code View -IL


SELECT SETID , ORG_CODE , ORG_TAX_LOC_CD FROM PS_ORG_TAX_LOC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SETID_TBL

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

Prompt Table: ORG_RGSTN_DTL

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