VNDR_INVOICE_E

(SQL Table)
 Index Back

Procurement Defaults

  • Parent record: VENDOR_E

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

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

    Default Value: %date

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

    Default Value: A

    6 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

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

    Default Value: K

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N