ORDDEPACT_TEO3

(SQL Table)
Index Back

Sales Order Deposit Activity

Customer Sales Order Deposit Activity

  • Parent record: ORD_DEPOSIT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 CUST_DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Customer Deposit ID
    4 DEPOSIT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Deposit Sequence Number
    5 DEPOSIT_ACTION Character(1) VARCHAR2(1) NOT NULL Deposit Action
    1=Deposit Taken
    2=Deposit Applied
    3=Deposit Refunded
    6 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    8 REFUND_FEE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Refund Fee Percent
    9 REFUND_FEE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Refund Fee Amount
    10 REFUND_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Refund Amount
    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 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
    14 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    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 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    20 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    21 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code