SPF_INVHIST_AET

(SQL Table)
 Index Back

Invoice Line History

This AETrecord is used for the mass insert of the SPA_INV_LN_HIST table to track invoice history. This table is added for performance enhancement

  • Parent record: SPF_INVOICE_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    4 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
    5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display
    7 INV_LINE_STATUS Character(4) VARCHAR2(4) NOT NULL Invoice Line Status
    1=Generated
    10=Adjusted by Ent Approver
    11=Adjusted by Enterprise
    2=Approved by Enterprise
    3=Submitted to Enterprise
    4=Denied by Enterprise
    5=Submitted to Supplier
    6=Approved by Supplier
    7=Denied by Supplier
    8=Canceled
    9=Adjusted by Supplier
    8 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
    9 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type
    10 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    11 COMMENTS Long Character CLOB Comment
    12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    13 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description