EX_RCPT_REQ_EXC(SQL Table) |
Index Back |
|---|---|
Specific Receipt Required RuleSetup for specific combinations of Expense Type & Payment Type that require receipts to be provided in the expense line. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | EXPENSE_TYPE |
Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 3 | EXPEND_MTHD |
Character(3) | VARCHAR2(3) NOT NULL | Payment Type |
| 4 | MIN_RCPT_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Minimum Receipt Amount |
| 5 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 6 | EX_RCPT_REQ_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Identifies whether an expense line requires a receipt or not for a particular combination of expense type and payment type.
C=No Except CC Feed E=Yes Except CC Feed N=Never Y=Always |
| 7 | COMMENT_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Comments Required
Y/N Table Edit Default Value: N |
| 8 | EE_NORCPT_COMMENT | Character(60) | VARCHAR2(60) NOT NULL | No Receipt Comment |
| 9 | EX_ENFORCE_RCPT | Character(1) | VARCHAR2(1) NOT NULL |
Enforce Receipt
Y/N Table Edit Default Value: N |
| 10 | EX_NO_RCPT_REASON | Character(10) | VARCHAR2(10) NOT NULL |
No Receipt Reason
Prompt Table:
REASON_RCPT_VW
|