ITEM_MAINT_VW

(SQL View)
 Index Back

Item Maint Search View

Search view for Item Maintenance component

SELECT BUSINESS_UNIT , CUST_ID , ITEM , ITEM_LINE , ITEM_STATUS , CR_ANALYST , COLLECTOR , PO_REF , DOCUMENT , BILL_OF_LADING , CONTRACT_NUM FROM PS_ITEM

  • Parent record: CUST_DATA

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BUARDS_NONVW

    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_SRCH_VW
    Set Control Field: BUSINESS_UNIT

    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_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
    C=Closed
    O=Open

    Default Value: O

    6 CR_ANALYST Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.

    Default Value: CUST_OPTION.CR_ANALYST

    Prompt Table: CR_ANALYST_TBL
    Set Control Field: BUSINESS_UNIT

    7 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.

    Default Value: CUST_OPTION.COLLECTOR

    Prompt Table: COLLECTOR_TBL
    Set Control Field: BUSINESS_UNIT

    8 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

    Prompt Table: ITEM_PO_VW

    9 DOCUMENT Character(30) VARCHAR2(30) NOT NULL Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
    10 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    11 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: %EDITTABLE29