VENDOR_INVOICE

(SQL Table)
 Index Back

Procurement Defaults

Procurement Defaults

  • Parent record: VENDOR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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

    Default Value: A

    5 DUP_INVOICE_IND Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Indicator
    D=Default from Higher Level
    S=Specify at this Level

    Default Value: D

    6 DUP_INVOICE_ACTION Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Severity
    K=Reject
    R=Recycle
    W=Warning

    Default Value: K

    7 DUP_INV_NUM_FLG Character(1) VARCHAR2(1) NOT NULL Invoice Number
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    8 DUP_INV_VENDOR_NUM Character(1) VARCHAR2(1) NOT NULL Vendor ID
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    9 DUP_INV_GROSS_AMT Character(1) VARCHAR2(1) NOT NULL Gross Amount
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    10 DUP_INV_DT Character(1) VARCHAR2(1) NOT NULL Invoice Date
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    11 DUP_INV_BUS_UNIT Character(1) VARCHAR2(1) NOT NULL Business Unit
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    12 DUP_INV_COMB_CODE Number(3,0) SMALLINT NOT NULL Dupl Invoice Combination Code