ORD_DEP_APP_VW1

(SQL View)
 Index Back

Sales Order Deposit Applied

Customer Sales Order Deposit Applied

SELECT D.BUSINESS_UNIT , D.CUST_DEPOSIT_ID , D.DEPOSIT_SEQ_NUM , D.DEPOSIT_ACTION , D.AMOUNT , D.CURRENCY_CD , D.REFUND_FEE_PCT , D.REFUND_FEE_AMT , D.REFUND_AMT , D.DEPOSIT_BU , D.RECEIPT_NBR , D.BUSINESS_UNIT_BI , D.INVOICE , D.DOC_REFNUM , D.AMOUNT_BSE , D.REFUND_FEE_AMT_BSE , D.REFUND_AMT_BSE , D.CURRENCY_CD_BASE , D.PROCESS_FLG , D.ADD_DTTM , D.LAST_MAINT_OPRID FROM %Table(ORD_DEPOSIT_ACT) D WHERE DEPOSIT_ACTION = '2'

  • 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 DEPOSIT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Deposit Sequence Number
    4 DEPOSIT_ACTION Character(1) VARCHAR2(1) NOT NULL Deposit Action
    1=Deposit Taken
    2=Deposit Applied
    3=Deposit Refunded
    5 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    7 REFUND_FEE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Refund Fee Percent
    8 REFUND_FEE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Refund Fee Amount
    9 REFUND_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Refund Amount
    10 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
    11 RECEIPT_NBR Character(15) VARCHAR2(15) NOT NULL Receipt Number
    12 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
    13 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    14 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number
    15 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    16 REFUND_FEE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Refund Fee Amount
    17 REFUND_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Refund Amount
    18 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    19 PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Processing Flag

    Y/N Table Edit

    Default Value: N

    20 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    21 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID