SPA_INV_LN_HIST

(SQL Table)
 Index Back

Invoice Line History

This record tracks the history of the invoice line status changes. When an invoice line is rejected, the reason code and comments are also tracked.

  • Parent record: SPF_INVOICE_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    3 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display
    6 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
    7 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type
    8 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    9 COMMENTS Long Character CLOB Comment
    10 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp