ORD_DEPOSIT

(SQL Table)
 Index Back

Sales Order Deposit

Customer Sales Order Deposit

  • Parent Record Of OM_RCPT_DCOL_VW ORDDEPACT_TEO1 ORDDEPACT_TEO2 ORDDEPACT_TEO3 ORD_DEPOSIT_ACT ORD_DEPOSIT_VW ORD_DEP_ADD_VW ORD_DEP_APP_VW ORD_DEP_APP_VW1 ORD_DEP_BAL_VW ORD_DEP_RFND_VW

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

    Prompt Table: SP_BU_OM_NONVW

    2 CUST_DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Customer Deposit ID
    3 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

    Prompt Table: CDR_BILLTO_VW
    Set Control Field: BUSINESS_UNIT

    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

    Prompt Table: ORD_HDR_VW

    5 REFUNDABLE_FLG Character(1) VARCHAR2(1) NOT NULL Deposit Refundable Flag

    Y/N Table Edit

    6 DEPOSIT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Deposit Basis Amount
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    8 DEP_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Deposit Basis Amount
    9 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    10 DEPOSIT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Deposit Percentage