ORD_DEPOSIT_VW

(SQL View)
 Index Back

Sales Order Deposit Activity

Customer Sales Order Deposit Activity

SELECT A.BUSINESS_UNIT , A.CUST_DEPOSIT_ID , A.REFUNDABLE_FLG , A.ORDER_NO , S.SETID , BILL_TO_CUST_ID , A.DEPOSIT_PCT , B.AMOUNT , C.AMOUNT , B.CURRENCY_CD , B.DEPOSIT_BU , B.RECEIPT_NBR , B.DOC_REFNUM , BI.BUSINESS_UNIT_AR , B.DEPOSIT_SEQ_NUM , B.ADD_DTTM , B.LAST_MAINT_OPRID FROM PS_ORD_DEPOSIT A , PS_ORD_DEPOSIT_ACT B , PS_ORD_DEP_BAL_VW C , PS_BUS_UNIT_TBL_OM OM , PS_BUS_UNIT_TBL_BI BI , PS_SET_CNTRL_REC S WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CUST_DEPOSIT_ID = B.CUST_DEPOSIT_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.CUST_DEPOSIT_ID = C.CUST_DEPOSIT_ID AND B.DEPOSIT_ACTION = '1' AND OM.BUSINESS_UNIT_BI = BI.BUSINESS_UNIT AND OM.BUSINESS_UNIT = B.BUSINESS_UNIT AND S.SETCNTRLVALUE = OM.BUSINESS_UNIT AND S.RECNAME = 'CUSTOMER'

  • Parent record: ORD_DEPOSIT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CUST_DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Customer Deposit ID
    3 REFUNDABLE_FLG Character(1) VARCHAR2(1) NOT NULL Deposit Refundable Flag

    Y/N Table Edit

    4 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    6 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    7 DEPOSIT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Deposit Percentage
    8 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    9 UNAPPLIED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Pending Application
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    11 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
    12 RECEIPT_NBR Character(15) VARCHAR2(15) NOT NULL Receipt Number
    13 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number
    14 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit
    15 DEPOSIT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Deposit Sequence Number
    16 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    17 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID