CUSTCPY_VAT_VW

(SQL View)
Index Back

Cust Copy VW-VAT Registration

View of VAT data on the customer record for copy function.

SELECT SETID, CUST_ID, COUNTRY, COUNTRY_2CHAR FROM PS_CUST_VAT_REG

  • Parent record: CUSTOMER
  • # 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: SP_SETID_NONVW

    2 CUST_CPY_ID Character(15) VARCHAR2(15) NOT NULL Customer Copy ID
    3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_VAT_VW

    4 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code

    Default Value: COUNTRY_TBL.COUNTRY_2CHAR

    Prompt Table: CNTRY_2CHAR_VW