SAC_SSVN_VW

(SQL View)
 Index Back

Supplier Header Table

Supplier Header Table

SELECT SETID , %Substring(BIDDER_ID, 1, 10) , %Substring(AUC_COMPANY_NAME , 1 , 14) , %Substring(AUC_COMPANY_NAME , 1 , 10) , 0 , AUC_COMPANY_NAME , ' ' , 'E' , 'R' , 'R' , MAIN_ADDR_SEQ_NUM , MAIN_ADDR_SEQ_NUM , MAIN_ADDR_SEQ_NUM , SETID , ' ' , SETID , ' ' , SETID , ' ' , ' ' , ' ' , ' ' , 'N' , ' ' , 'Y' , ' ' , ' ' , ' ' , ' ' , ' ' , %DateNull , ' ' , 'N' , 0 , ' ' , %DateNull , ' ' , 'N' , ' ' , ' ' , ' ' , ' ' , %DateTimeNull , ' ' , %DateTimeNull FROM PS_AUC_BIDDER_HDR

  • Related Language Record: VENDOR_LANG

    • # 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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    4 VNDR_NAME_SHRT_USR Character(10) VARCHAR2(10) NOT NULL Short Vendor Name
    5 VNDR_NAME_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence Number
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    8 VENDOR_STATUS Character(1) VARCHAR2(1) NOT NULL Vendor Status
    A=Approved
    D=Denied
    E=Unapproved
    I=Inactive
    X=To Be Archived
    9 VENDOR_CLASS Character(1) VARCHAR2(1) NOT NULL Vendor Classification
    A=Attorney
    E=Employee
    H=HCM
    R=Outside Party

    Default Value: R

    10 VENDOR_PERSISTENCE Character(1) VARCHAR2(1) NOT NULL Persistence
    O=One Time
    P=Permanent
    R=Regular
    S=Single Payment Supplier

    Default Value: R

    11 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
    12 PRIM_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Invoicing Location
    13 ADDR_SEQ_NUM_ORDR Number(5,0) INTEGER NOT NULL Ordering Location
    14 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

    Default Value: VENDOR.SETID

    15 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    16 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: VENDOR.SETID

    17 CORPORATE_VENDOR Character(10) VARCHAR2(10) NOT NULL Corporate Vendor
    18 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

    Default Value: VENDOR.SETID

    Prompt Table: SETID_TBL

    19 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: CUSTOMER_FS

    20 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
    21 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number
    22 OLD_VENDOR_ID Character(15) VARCHAR2(15) NOT NULL Old Vendor ID
    23 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099

    Y/N Table Edit

    Default Value: N

    24 VAT_SW Character(1) VARCHAR2(1) NOT NULL Display VAT Flag
    H=Hide VAT checkbox
    N=Display VAT checkbox off
    Y=Display VAT checkbox on

    Y/N Table Edit

    Default Value: VENDOR_CONTROL.VAT_SW

    25 VNDR_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Open For Ordering
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    26 REMIT_LOC Character(10) VARCHAR2(10) NOT NULL Remit to Location
    27 DEFAULT_LOC Character(10) VARCHAR2(10) NOT NULL Default Location
    28 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
    29 NAME2_AC Character(40) VARCHAR2(40) NOT NULL Name 2 Alternate Char Set
    30 PRIMARY_VENDOR Character(10) VARCHAR2(10) NOT NULL Primary Supplier
    31 LAST_ACTIVITY_DT Date(10) DATE Last Activity Date
    32 WITHHOLD_LOC Character(10) VARCHAR2(10) NOT NULL Withholding Location
    33 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Default Value: N

    34 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    35 HUB_ZONE Character(1) VARCHAR2(1) NOT NULL HUB Zone
    N=No
    Y=Yes

    Y/N Table Edit

    36 EEO_CERTIF_DT Date(10) DATE EEO Certification Date
    37 HRMS_CLASS Character(1) VARCHAR2(1) NOT NULL Human Resources Classification
    D=General Deduction
    G=Garn Payee
    H=National Health Serv Provider
    I=Industrial Ins Board Provider
    M=Imp Partner Provider
    P=General Provider
    T=Tax Collector
    38 INTERUNIT_VNDR_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit Vendor
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    39 VNDR_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Vendor Affiliate

    Prompt Table: SP_BU_GL_NONVW

    40 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    41 VNDR_TIN Character(1) VARCHAR2(1) NOT NULL Vendor Tax Id Number
    42 ARCHIVED_BY Character(30) VARCHAR2(30) NOT NULL Archived By
    43 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
    44 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    45 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date