CUST_VAT_EXCPTN

(SQL View)
 Index Back

Customer VAT Exception

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

SELECT SETID ,CUST_ID ,COUNTRY ,COUNTRY_CODE ,EFFDT ,EFF_STATUS ,VAT_EXCPTN_END_DT ,VAT_EXCPTN_TYPE ,VAT_EXCPTN_CERTIF ,LAST_MAINT_OPRID ,DATE_LAST_MAINT FROM PS_BO_VAT_EXCPTN

  • Parent record: CUSTOMER

    • # 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
    3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    4 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    7 VAT_EXCPTN_END_DT Date(10) DATE This field is used to represent the VAT exception end date
    8 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
    N=None
    S=Suspended
    X=Exonerated
    9 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
    10 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.
    11 DATE_LAST_MAINT Date(10) DATE This field determines the date of last maintenance.