CA_CONTR_ITM_VW

(SQL View)
 Index Back

Customer Items


SELECT ITM.BUSINESS_UNIT , ITM.CUST_ID , ITM.CONTRACT_NUM , ITM.ITEM , ITM.ITEM_LINE , ITM.ITEM_STATUS , ITM.INVOICE , ITM.CR_ANALYST , ITM.COLLECTOR , ITM.PO_REF , ITM.DOCUMENT , ITM.BILL_OF_LADING , ITM.ENTRY_USE_ID FROM PS_ITEM ITM , PS_CA_CONTR_HDR CONT WHERE ITM.CONTRACT_NUM = CONT.CONTRACT_NUM

  • Parent record: CUST_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit
    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 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    4 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.
    5 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
    6 ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
    C=Closed
    O=Open
    7 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    8 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

    9 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

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

    Prompt Table: ITEM_PO_VW

    11 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.
    12 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    13 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.