CSH_OFFRCT_T_VW

(SQL View)
 Index Back

Cashier Office Receipt Tender


SELECT A.BUSINESS_UNIT ,A.CASHIER_OFFICE ,A.RECEIPT_NBR ,A.RECEIPT_LINE_NBR ,A.TENDER_KEY ,A.AMOUNT_SF ,A.CURRENCY_CD ,A.CHECK_NUM_SF ,A.THIRD_PARTY ,A.CR_CARD_ISSUER ,A.CR_CARD_NBR ,A.CR_CARD_TYPE ,A.CR_CARD_EXP_DT ,A.CR_CARD_FNAME ,A.CR_CARD_LNAME ,A.FED_RSRV_BANK_ID ,A.SSF_BNK_ACCT_NUM ,A.BANK_ACCT_TYP ,A.BANK_ACCT_NAME ,A.CHANGE_FLAG ,A.CUR_RT_TYPE ,A.RATE_MULT ,A.RATE_DIV ,A.ORIGNL_CURRENCY_CD ,A.ORIGNL_ITEM_AMT ,A.SF_DEPOSIT_ID ,A.TRACER_NBR FROM PS_CSH_OFF_RCPT_T A

  • Parent record: CSH_OFF_RECEIPT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
    3 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
    4 RECEIPT_LINE_NBR Number(3,0) SMALLINT NOT NULL Receipt Line Number
    5 TENDER_KEY Character(10) VARCHAR2(10) NOT NULL Tender Key
    6 AMOUNT_SF Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    8 CHECK_NUM_SF Character(30) VARCHAR2(30) NOT NULL Check Nbr
    9 THIRD_PARTY Character(30) VARCHAR2(30) NOT NULL Third Party Check Name
    10 CR_CARD_ISSUER Character(20) VARCHAR2(20) NOT NULL Credit Card Issuer
    11 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL Credit Card Number
    12 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type
    13 CR_CARD_EXP_DT Date(10) DATE Expiration Date
    14 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
    15 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
    16 FED_RSRV_BANK_ID Character(10) VARCHAR2(10) NOT NULL Federal Reserve Bank ID
    17 SSF_BNK_ACCT_NUM Character(44) VARCHAR2(44) NOT NULL Bank Account Number
    18 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
    C=Checking
    S=Savings
    19 BANK_ACCT_NAME Character(30) VARCHAR2(30) NOT NULL Bank Account Holder Name
    20 CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag
    21 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    22 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    23 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    24 ORIGNL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    25 ORIGNL_ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
    26 SF_DEPOSIT_ID Character(10) VARCHAR2(10) NOT NULL Deposit ID
    27 TRACER_NBR Character(30) VARCHAR2(30) NOT NULL Tracer Number