D09E0025 - Validate Expense Detail Line
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cExpenseReportType | EXRPTTYP | char | OPT | NONE |
A user defined code (09E/RT) that describes the expenses on the report. Examples of expense report types include travel and
| ||||
szExpenseReportNumber | EXRPTNUM | char | OPT | NONE |
A number that uniquely identifies an expense report. | ||||
mnEmployeeID | EMPLOYID | MATH_NUMERIC | OPT | NONE |
The address book number of the employee for whom the expense report is submitted. | ||||
szOriginalWorkStationId | WRKSTNID | char | OPT | NONE |
The identification number of the workstation on which the expense report was entered. | ||||
mnLineNumberGeneral | LIN | MATH_NUMERIC | OPT | NONE |
To move rapidly through a long list of journal entries, enter a line number. The system shifts the information on that line to the top of the
| ||||
jdDateCreated | DTECRT | JDEDATE | OPT | NONE |
The date on which the expense report was created. | ||||
cRecordType | RECTYPE | char | OPT | NONE |
A value that indicates the type of record in the Expense Report Detail table (F20112). The system assigns the value of the record type
| ||||
mnLineNumberDetail | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szExpenseCategory | EXPTYPE | char | OPT | NONE |
A user defined code (09E/EC) that categorizes expenses. Expense categories include airfare, meals, hotel, and car rental. | ||||
jdExpenseDate | EXPDATE | JDEDATE | OPT | NONE |
The date on which the expense was incurred. The system returns an error if the date that you enter for the expense is not within the
| ||||
szPaymentMethod | PMTMETH | char | OPT | NONE |
A user defined code (09E/PM) that indicates how an employee paid an expense. For example, the employee might have used a credit
| ||||
szChargeTo | CHRGTO | char | OPT | NONE |
A user defined code (09E/CT) that specifies whether an expense is billable and to whom it is billable. Choose one of the following values
| ||||
szExpenseCurrency | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szReimbursementCurrency | REIMCRCY | char | OPT | NONE |
The currency in which the expense report will be reimbursed.
If the reimbursement method is from the Accounts Payable system (1, 2 or 3),
| ||||
mnReceiptLabel | RCPTLBL | MATH_NUMERIC | OPT | NONE |
A number that corresponds to the expense item line number that the system assigns for you to use to identify the physical receipt that
| ||||
szBusinessUnit | MCU0 | char | OPT | NONE |
An alphanumeric field that identifies a separate entity within a business for which you want to track costs. For example, a business unit might
| ||||
mnExchangeRate | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
mnQuanity | UNITS | MATH_NUMERIC | OPT | NONE |
The number of items expensed at a specific rate. | ||||
mnRate | RATE1 | MATH_NUMERIC | OPT | NONE |
The price at which the expense was incurred for a specific unit of measure. For example, the rate might be the cost of a hotel room per night
| ||||
szCurrencyCodeTo | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
mnReimbursementAmount | EXPDAMT | MATH_NUMERIC | OPT | NONE |
The amount of the expense in the employee's reimbursement currency. | ||||
mnExpenseAmount | EXPFAMT | MATH_NUMERIC | OPT | NONE |
The amount of the expense in the currency in which the expense was incurred. This amount should correspond to the amount on the receipt. | ||||
szPolicy | POLICY | char | OPT | NONE |
The name of an expense policy. The expense policy determines the expense categories that are available for reimbursement and
| ||||
cBillableFlag | BILLBLE | char | OPT | NONE |
A code that specifies whether the tax rate area applies to billable expenses (expenses billed directly to the client). Valid values
| ||||
szExpenseStatus | EXPSTAT | char | OPT | NONE |
The current status of the expense. The system uses this status to determine what information should be included in the workflow message if
| ||||
szLocation | LOCATN | char | OPT | NONE |
A user defined code (09E/EL) that indicates where the expense was incurred. The system uses location information to determine the policy
| ||||
jdExpenseReportDate | EXRPTDTE | JDEDATE | OPT | NONE |
The last day that expenses can be included on the expense report. Allowable dates are defined in the processing options of the Expense
| ||||
mnPOAllowableExpDays | ERNUMDAY | MATH_NUMERIC | OPT | NONE |
The number days allowed to enter an expense report. | ||||
cErrorFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnOrderNo | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szSubsidiary | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szCostType | OBJ | char | OPT | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szReimbursementMethod | REIMMETH | char | OPT | NONE |
A user defined code (09E/RM) that specifies whether to reimburse the employee or the employee's credit card company, and whether the
| ||||
cCurrencyMode | MULTIPL | char | OPT | NONE |
An option that specifies whether the expenses on the report are in the employee's reimbursement currency (single) or in multiple currencies.
| ||||
szEmpReimbersementCurr | REIMCRCY | char | OPT | NONE |
The currency in which the expense report will be reimbursed.
If the reimbursement method is from the Accounts Payable system (1, 2 or 3),
| ||||
szExchangeRateID | EXRTID | char | OPT | NONE |
A value that specifies the exchange rate to use for expenses incurred in a foreign currency. | ||||
mnCreditCardAB | CCAN8 | MATH_NUMERIC | OPT | NONE |
The address book number of the credit card company. You must set up and address book record for each credit card company that you
| ||||
szTypeOfData | TYDA | char | OPT | NONE |
A code that specifies the type of reimbursement for the expense report. Valid values are:
10
Expenses are reimbursed to the employee
| ||||
cPOExchRateOverride | EXRTOV | char | OPT | NONE |
An indicator that determines whether a user will be allowed to override the default exchange rate for multicurrency expense reports.
1
| ||||
mnPOExchRateTolerance | MATH03 | MATH_NUMERIC | OPT | NONE |
- - - Bad Performance Low Value. | ||||
szTaxArea | TXA1 | char | OPT | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
szTaxExplanationCode | EXR1 | char | OPT | NONE |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
mnReimbursableAmount | REIMAMT | MATH_NUMERIC | OPT | NONE |
The amount of an expense item that is reimbursed to the employee. | ||||
mnReimbursementTotal | REIMBTOT | MATH_NUMERIC | OPT | NONE |
The sum of the expenses entered on the expense report that will be paid to the employee. | ||||
mnCCReimbursementAmt | CCREAMT | MATH_NUMERIC | OPT | NONE |
The sum of expenses entered on the expense report that will be paid directly to the credit card company. | ||||
mnTotalExpenses | TOTEXP | MATH_NUMERIC | OPT | NONE |
The sum of all expenses entered on the expense report. | ||||
szSubledger | SBL | char | OPT | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | OPT | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
szAdditionalComments | ADDLCMT | char | OPT | NONE |
A free form text field to enter information about an expense. This field is required for expense categories that are set up in a policy that uses
| ||||
szAlternateVendor | ALTVEND | char | OPT | NONE |
The name of the vendor that was used instead of the preferred vendor. | ||||
szHomeCurrency | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szHotelChain | HOTELCH | char | OPT | NONE |
A user defined code (09E/PH) that identifies the name of the hotel where the expense was incurred. | ||||
mnNumberOfNights_2 | NUMNITES | MATH_NUMERIC | OPT | NONE |
The number of nights the employee stayed at the hotel. | ||||
szHotelLocation | HOTELLOC | char | OPT | NONE |
The location of the hotel where the expense was incurred. | ||||
szAirline | AIRLINE | char | OPT | NONE |
The name of the airline that issued the ticket. | ||||
szAirlineTicketNumber | TICKNUM | char | OPT | NONE |
The reference number on the airline ticket. | ||||
szAirlineTicketStatus | TICKSTA | char | OPT | NONE |
A user defined code (09E/TS) that indicates the status of the airline ticket that is being expensed. Assigning a ticket status allows a
| ||||
szCarRentalVendor | CARVEND | char | OPT | NONE |
A user defined code (09E/PC) that identifies the car rental agency used by the employee. | ||||
szTripDescription | TRIPDES | char | OPT | NONE |
A brief description of the trip associated with the expense.
This field resides in the Expense Report Detail table (F20112) and can be
| ||||
mnNumberOfCompanyEmployees | NUMCOEMP | MATH_NUMERIC | OPT | NONE |
The number of company employees who attended the event being expensed. | ||||
mnNumberOfNonCompanyEmploy | NUMNCOEM | MATH_NUMERIC | OPT | NONE |
The number of guests, excluding employees, who attended the event being expensed. | ||||
szSchoolName | SCHLNAM | char | OPT | NONE |
The name of the education center for which the expense was incurred. | ||||
szCourseNumber | CRSNUM | char | OPT | NONE |
The number of the course for which the employee is requesting reimbursement. | ||||
szCourseTitle | CRSTITL | char | OPT | NONE |
The title of the course for which the employee is requesting reimbursement. | ||||
szFacilityName | FCLTYNM | char | OPT | NONE |
The name of the health club or institution for which the expense was incurred. | ||||
szPreferredSupplier9 | PREFSUPP | char | OPT | NONE |
A user defined code (09E/PS) that specifies the vendors with whom your company has negotiated preferential pricing or some other
| ||||
mnTaxRate | TXR1 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
szBusinessPurpose | BUSPURP | char | OPT | NONE |
The business reason for incurring the expenses on the expense report. The system automatically stores the last ten business purposes
| ||||
szFinalGrade | FNLGRD | char | OPT | NONE |
The final grade received for the class. | ||||
mnNumeric1 | NUMERIC1 | MATH_NUMERIC | OPT | NONE |
A field to store user-defined information in a numeric format. | ||||
mnNumeric2 | NUMERIC2 | MATH_NUMERIC | OPT | NONE |
A field to store user-defined information in a numeric format. | ||||
mnNumeric3 | NUMERIC3 | MATH_NUMERIC | OPT | NONE |
A field to store user-defined information in a numeric format. | ||||
szText1 | TEXT1 | char | OPT | NONE |
A field to store user-defined information in an alphanumeric format. | ||||
szText2 | TEXT2 | char | OPT | NONE |
A field to store user-defined information in an alphanumeric format. | ||||
szText3 | TEXT3 | char | OPT | NONE |
A field to store user-defined information in an alphanumeric format. | ||||
jdDate1 | DATE1 | JDEDATE | OPT | NONE |
A field to store user-defined information in a date format. | ||||
jdDate2 | DATE2 | JDEDATE | OPT | NONE |
A field to store user defined-information in a date format. | ||||
jdDate3 | DATE3 | JDEDATE | OPT | NONE |
A field to store user defined-information in a date format. | ||||
cSystemCurrencyPrecessing | CRYR | char | OPT | NONE |
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use:
Codes are:
N Do not
| ||||
szCountry | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
| ||||
mnSavedLineNumberGeneral | LIN | MATH_NUMERIC | OPT | NONE |
To move rapidly through a long list of journal entries, enter a line number. The system shifts the information on that line to the top of the
| ||||
mnEmpCurrReimbAmt | EXPDAMT | MATH_NUMERIC | OPT | NONE |
The amount of the expense in the employee's reimbursement currency. | ||||
szChargeToCode | VC02A | char | OPT | NONE |
A generic field that is used as a work field. | ||||
szPaymentMtdCode | VC02A | char | OPT | NONE |
A generic field that is used as a work field. | ||||
szPerDiemExpenseCategory | PDIEMCAT | char | OPT | NONE |
A user defined code (09E/EC) that categorizes expenses. Expense categories include airfare, meals, hotel, and car rental. | ||||
mnPerDiemExpCatDailyAllowance | DLYALLOW | MATH_NUMERIC | OPT | NONE |
The amount that an employee is allowed to spend per day on an expense item. | ||||
cPerDiemExpCatHardEdit | HEDIT | char | OPT | NONE |
A value that specifies whether the system issues a warning or error message to the employee when the expense amount exceeds the daily
| ||||
cPOPolicyPerDiemValidation | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
None |
None |