IMP_BO_EXEMPT_V

(SQL View)
 Index Back

IMP_BO_EXEMPT_VW

CDH INTERFACE TABLE - IMP_BO_EXEMPT_VW JOINING PS_BO_EXEMPT AND PS_BO_EXEMPT_DTL

SELECT A.BO_ID , A.SETID , A.CUST_ID , A.TAX_EXEMPT_CERT , A.ISSUING_AUTHORITY , A.AUTHORITY_TYPE , B.EFFDT , B.EFF_STATUS , B.TAX_EXEMPT_FLAG , B.EXEMPT_CATEGORY , B.ISSUED_DT , B.EXPIRATION_DT , B.DESCR , B.DESCR254 FROM PS_BO_EXEMPT A , PS_BO_EXEMPT_DTL B WHERE A.BO_ID = B.BO_ID AND A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND A.TAX_EXEMPT_CERT = B.TAX_EXEMPT_CERT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
4 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
5 ISSUING_AUTHORITY Character(22) VARCHAR2(22) NOT NULL Issuing Authority
6 AUTHORITY_TYPE Character(1) VARCHAR2(1) NOT NULL Authority Type
E=European Community
F=Federal
L=Local
O=Other
S=State
T=Transportation
7 EFFDT Date(10) DATE Effective Date

Default Value: %date

8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
9 TAX_EXEMPT_FLAG Character(1) VARCHAR2(1) NOT NULL Exemption License
10 EXEMPT_CATEGORY Character(1) VARCHAR2(1) NOT NULL Tax Exempt Category
B=Blanket
O=Other
S=Single Purchase
11 ISSUED_DT Date(10) DATE Issued Date
12 EXPIRATION_DT Date(10) DATE Expiration Date
13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
14 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254