CUST_EXEMPT_DTL

(SQL View)
 Index Back

Customer Tax Exempt Detail

Date Init. Issue # Description 08/14/01 JJM DI-EDWONG-17 Inverted CUST_ID, SETID in index

SELECT SETID , CUST_ID , TAX_EXEMPT_CERT , EFFDT , EFF_STATUS , TAX_EXEMPT_FLAG , EXEMPT_CATEGORY , ISSUED_DT , EXPIRATION_DT , DESCR , DESCR254 , ROW_ADDED_DTTM , ROW_LASTMANT_DTTM , ROW_LASTMANT_OPRID FROM PS_BO_EXEMPT_DTL

  • Related Language Record: CUST_EXEMPT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

    Prompt Table: CUSTOMER

    3 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 TAX_EXEMPT_FLAG Character(1) VARCHAR2(1) NOT NULL Exemption License

    Y/N Table Edit

    Default Value: N

    7 EXEMPT_CATEGORY Character(1) VARCHAR2(1) NOT NULL Tax Exempt Category
    B=Blanket
    O=Other
    S=Single Purchase
    8 ISSUED_DT Date(10) DATE Issued Date
    9 EXPIRATION_DT Date(10) DATE Expiration Date
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    12 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    13 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    14 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.