UPG_EGAR_ACT

(SQL Table)
 Index Back

Customer Item Activity

Customer Item Activity

  • Parent record: ITEM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_FS

    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: CUST_BI_A2_VW

    3 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
    4 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
    5 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number
    6 ARRE_STATUS Character(1) VARCHAR2(1) NOT NULL Process status indicator for AR Commitment Control
    B=Processed by Billing
    C=Corrected online
    E=Unknown Error
    M=Unable dist to multi rev lines
    N=No effect on revenue estimate
    O=Transfered out of Bus Unit
    P=Processed successfully
    R=No item rev lines
    S=Skip process
    T=No transfer 'from' item found
    U=No revenue lines
    X=Error exists in prior activity