CSH_RCPT_TND_VW

(SQL View)
Index Back

Cashier Receipt Tender View

Cashier Receipt Tender View

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.CR_CARD_DIGITS ,A.SF_DEPOSIT_ID FROM PS_CSH_OFF_RCPT_T A

# 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 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
10 SF_DEPOSIT_ID Character(10) VARCHAR2(10) NOT NULL Deposit ID