SUBC_DATA_RM_VW

(SQL View)
Index Back

SubCust Info by RemitFrom Cust


SELECT C.REMIT_FROM_SETID, C.REMIT_FROM_CUST_ID, D.BUSINESS_UNIT, D.CUST_ID, D.SUBCUST_QUAL1, D.SUBCUST_QUAL2, C.SETID, D.BAL_AMT, D.HI_BAL_AMT, D.HI_BAL_DT, D.ITEM, D.ITEM_AMT, D.ITEM_DT, D.DEPOSIT_BU, D.DEPOSIT_ID, D.PAYMENT_SEQ_NUM, D.PAYMENT_DT, D.POST_DT, D.POSTED_PI, D.AGED_DT, D.AGED_PI, D.PAYMENT_ID, D.PAYMENT_AMT, D.ENTRY_CURRENCY, D.PAYMENT_CURRENCY, D.PROCESS_INSTANCE, D.ITEM_LINE, D.CURRENCY_CD FROM PS_CUSTOMER C, PS_SUBCUST_DATA D WHERE C.CUST_ID = D.CUST_ID AND C.SETID = (SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = D.BUSINESS_UNIT AND RECNAME = 'CUSTOMER')

  • Parent record: CUST_DATA
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REMIT_FROM_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 REMIT_FROM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Remit From Customer
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    4 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

    5 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
    6 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
    7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    8 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance
    9 HI_BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Hi Balance
    10 HI_BAL_DT Date(10) DATE Hi Balance Date
    11 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.
    12 ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    13 ITEM_DT Date(10) DATE Item Date
    14 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
    15 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
    16 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
    17 PAYMENT_DT Date(10) DATE Payment Date
    18 POST_DT Date(10) DATE The Date a transaction was Posted.
    19 POSTED_PI Number(10,0) DECIMAL(10) NOT NULL Last Post Process Instance
    20 AGED_DT Date(10) DATE Aged Date
    21 AGED_PI Number(10,0) DECIMAL(10) NOT NULL Last Aging Process Instance
    22 PAYMENT_ID Character(15) VARCHAR2(15) NOT NULL Identifies a customer payment. This is usually a check number but may be some other identifying number.
    23 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.
    24 ENTRY_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency associated with the monetary amount of a pending item.
    25 PAYMENT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
    26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    27 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
    28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code