EX_RCPT_VER_RLS(SQL Table) |
Index Back |
|---|---|
Receipt Verification CriteriaAllows user to establish rules to determine when an expense sheet's line item receipts should be verified. |
| # | 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
|
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | RECEIPT_RECVD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Receipts Received Flag
Y/N Table Edit Default Value: N |
| 5 | RCPT_VER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Verification Flag
Y/N Table Edit Default Value: N |
| 6 | RECEIPT_VER_REFINE | Character(1) | VARCHAR2(1) NOT NULL |
Refine Receipt Verification
Y/N Table Edit Default Value: N |
| 7 | SHEET_AMT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allows user to specify whether they would like to define a maximum sheet amount that requires receipt verification.
Y/N Table Edit Default Value: N |
| 8 | MAX_SHEET_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Maximum Sheet Amount |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 10 | RCPT_VER_SAMPLE | Character(1) | VARCHAR2(1) NOT NULL |
Verify Sample
Y/N Table Edit Default Value: N |
| 11 | RCPT_VER_QTY | Number(5,0) | INTEGER NOT NULL | Sheet Sample Number - Verify |