EX_RCPT_VR_R_VW

(SQL View)
 Index Back

Receipt Verification Criteria

Allows user to establish rules to determine when an expense sheet's line item receipts should be verified.

SELECT A.SETID , A.RECEIPT_RECVD_FLG , A.RCPT_VER_FLG , A.RECEIPT_VER_REFINE , A.MAX_SHEET_AMOUNT , A.RCPT_VER_SAMPLE , A.RCPT_VER_QTY FROM PS_EX_RCPT_VER_RLS A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EX_RCPT_VER_RLS A1 WHERE A1.SETID = A.SETID AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW
Set Control Field: BUSINESS_UNIT_GL

2 RECEIPT_RECVD_FLG Character(1) VARCHAR2(1) NOT NULL Receipts Received Flag

Y/N Table Edit

Default Value: N

3 RCPT_VER_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Verification Flag

Y/N Table Edit

Default Value: N

4 RECEIPT_VER_REFINE Character(1) VARCHAR2(1) NOT NULL Refine Receipt Verification

Y/N Table Edit

Default Value: N

5 MAX_SHEET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Maximum Sheet Amount
6 RCPT_VER_SAMPLE Character(1) VARCHAR2(1) NOT NULL Verify Sample

Y/N Table Edit

Default Value: N

7 RCPT_VER_QTY Number(5,0) INTEGER NOT NULL Sheet Sample Number - Verify