SCR_LOC_ID_DFT

(SQL Table)
 Index Back

SCR Loc ID Numbers Draft

Supplier Change Request Draft Table. This table will store the user changes for approval and update.

  • Parent record: VENDOR_LOC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID
    2 SCR_SEQ_NUM Number(5,0) INTEGER NOT NULL Update Sequence Number
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    6 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    7 SCR_EFFDT Date(10) DATE Approved Changes Take Effect
    8 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
    9 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number
    10 STD_ID_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    11 CREDIT_FLG Character(1) VARCHAR2(1) NOT NULL Credit Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    12 SCR_CHG_EFF_WHEN Character(1) VARCHAR2(1) NOT NULL Change Effective
    I=Approval Date
    S=Future Date
    13 SCR_CHNG_TYPE Character(1) VARCHAR2(1) NOT NULL Request for Change Type
    A=Add
    D=Delete
    I=Inactivate
    U=Update
    14 SCR_STDID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
    ACN=Company Number - Australia
    BEI=BEI Identifier
    BUS=Business Types
    CCM=Municipal Reg Number - Brazil
    CGC=Comp Tax Reg Number - Brazil
    CID=Company Identification Number
    CPF=Ind Tax Reg Number - Brazil
    CRI=Creditor Identification
    DB=DUNS Number (With Edit)
    DNS=DUNS Number (No Edit)
    DOD=DODAAC Code
    DP4=DUNS+4 Suffix
    EIN=Employer ID Number
    FIC=Fiscal ID - Company - Italy
    FII=Fiscal ID - Indiv - Italy
    GLN=Global Location Number
    IE=State Reg Number - Brazil
    LER=Legal Entity Registration Num
    NIC=NIC Number - France
    NIF=Fiscal ID Number - Spain
    PSC=Public Service Codes
    SBA=SBA Business Types
    SRN=SIREN Number - France
    SRT=SIRET Number - France
    SSN=Social Security Number
    TIN=Tax Identification Number
    W2=W2 Identification Number
    15 ERR_MSG_NBR Number(5,0) INTEGER NOT NULL Service Purchase Error Number
    16 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
    C=Cancel
    E=Error
    M=Message
    W=Warning
    17 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    18 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    19 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    20 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    21 SCR_REMOVE Character(1) VARCHAR2(1) NOT NULL Remove Contact