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 |