CSH_RCPT_L_VW

(SQL View)
 Index Back

Cashier Office Receipt Line


SELECT business_unit , cashier_office , receipt_nbr , receipt_line_nbr , target_key ,amount_sf ,currency_cd ,strm ,tax_line_nbr ,tax_row ,tax_authority_cd FROM PS_CSH_OFF_RCPT_L

  • 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 TARGET_KEY Character(10) VARCHAR2(10) NOT NULL Target Key

    Prompt Table: TARGET_KEY_TBL

    6 AMOUNT_SF Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_SF.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    8 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: SF_TERM_VW

    9 TAX_LINE_NBR Number(3,0) SMALLINT NOT NULL Tax Line Number
    10 TAX_ROW Character(1) VARCHAR2(1) NOT NULL Tax
    11 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority

    Prompt Table: TAX_AUTHORTY_VW