This appendix contains the following topics:
To receive transactions from your credit card company in a format that the system accepts, you must map the information from the credit card company to the Credit Card Transaction Interface Table (F09E150). Employees can retrieve their credit card transactions directly from table F09E150 to use on their expense reports.
|
Note: When employees apply credit card transactions to their expense reports, the system uses the information to update the Expense Report Detail table (F20112) only; the system does not update fields in the Expense Report Header table (F20111). |
These tables list each field in table F09E150 and describe the type of data expected by the system and how the field is used.
To complete a task you must provide values for fields listed in this table.
| Alias | Field Name | Type | Length | Description |
|---|---|---|---|---|
| CCTN | Credit Card Transaction Number | Alpha | 20 | A unique identifier for the credit card transaction.
You can use the transaction number assigned by the credit card company, devise your own unique key by concatenating the values of several fields, or use a next numbering routine. The system uses this field as the primary key for locating and tracking credit card expenses. By assigning a unique value for each credit card expense, you eliminate the possibility of reimbursing the expense more than once. The value that you specify should not exist in the F09E150 table. |
| EMPLOYID | Employee ID | Number | 8 | The address book number of the employee.
This field is required if the Credit Card Number field is blank. The system uses the employee ID in conjunction with the payment method specified to retrieve the credit card number from the Credit Card Information table (F0075). |
| CRCRDNUM | Credit Card Number | Alpha | 25 | The number of the employee's credit card.
This field is required if the Employee ID field is blank. The system uses the credit card number in conjunction with the payment method specified to retrieve the employee ID from the Credit Card Information table (F0075). |
| PMTMETH | Payment Method | Alpha | 3 | A user-defined code that corresponds to the payment method of the employee.
The value that you enter must exist in UDC 09E/PM. |
| TRANSTAT | Transaction Status | Alpha | 2 | A code that specifies that the transaction is available for processing.
Enter 0 (zero) for all transactions. |
| EXPDATE | Expense Date | Date | 6 | The date that the expense was incurred.
Enter the date in a format that the database accepts. |
| EXPAMT | Expense Amount | Number | 15 | The amount of the expense in the currency in which it was incurred.
Note: If you do not use multicurrency or if the amount is in the domestic currency, the expense amount should be the same as the billed amount. |
| EXPCRCD | Expense Currency Code | Alpha | 3 | The currency code of the expense amount.
The value that you specify must exist in the Currency Codes table (F0013). This field is required only if multicurrency is turned on. |
| BILLAMT | Billed Amount | Number | 15 | The billed amount of the expense in the currency of the credit card company.
Note: If you do not use multicurrency or if the amount is in the domestic currency, the billed amount should be the same as the expense amount. |
| BILLCRCD | Billed Currency Code | Alpha | 3 | The currency code of the amount billed by the credit card company.
The value that you specify must exist in the Currency Codes table (F0013). This field is required only if the multicurrency feature is active. |
This table lists the fields that are optional to complete for the credit card interface, but either are required for expense report entry or appear on one of the interactive forms that you complete to enter an expense report.
| Alias | Field Name | Type | Length | Description |
|---|---|---|---|---|
| CHRGTO | Charge To Type | Alpha | 3 | A user-defined code that indicates whether the expense is reimbursable and the entity to which it should be charged.
The value that you specify must exist in UDC 09E/CT. |
| MCU | Business Unit | Alpha | 12 | The business unit to which the expense should be charged.
If you complete this field, the Charge To Type field must contain the code that specifies business unit. The value that you specify must exist in the Business Unit Master table (F0006). |
| EXPTYPE | Expense Category | Alpha | 4 | The category that best describes the expense.
The value that you specify must exist in UDC 09E/EC. |
| CRR | Exchange Rate | Number | 15 | The exchange rate used by the credit card company if the expense was incurred in a currency different from the bill currency.
The exchange rate that you enter must correspond to the conversion method specified in the Currency Exchange Rates table (F0015) for the currency pair. If the exchange rate is not set up, the system uses the conversion method specified in the General Constants table (F0009). The system does not verify or recalculate amounts based on the exchange rate entered, but uses the exchange rate, in conjunction with the conversion method, to recalculate the billed amount if the expense amount is changed. For example, if the exchange rate provided by the credit card company was derived using the multiplier rate, and the system is set up to use a divisor rate, you must convert the rate entered to correspond to the conversion method. If you leave this field blank, the system calculates the exchange rate based on the expense and billed amounts at the time the transaction is applied to the expense report. The system does not use the exchange rate from the Currency Exchange Rates table (F0015), nor does it require that an exchange rate is set up, but it does use the exchange rate to locate the conversion method. Note: You can use the Adjust Spot Rate for Default Conversion Method function (B09E0022) to retrieve the proper conversion method and automatically convert the exchange rate accordingly. |
| DESCCHG | Description of Charge | Alpha | 45 | Text describing the expense. |
| LOCATN | Location Code | Alpha | 5 | The city, state, or country in which the expense was incurred.
The value that you enter must exist in UDC 09E/EL. If you leave this field blank, you must assign a location when you enter the expense report. |
| ADDLCMT | Additional Comment | Alpha | 60 | Text for additional information about an expense, or the reason that a preferred supplier was not used.
This field is required if a preferred supplier (as specified by the policy) was not used. |
Depending on the expense category attributes that you set up, some of these fields might appear on the Additional tab on the Edit Expense Detail Information form or on the forms used to apply the credit card expense to an expense report; otherwise, the fields reside in the database only for reporting purposes.
| Alias | Field Name | Type | Length | Definition |
|---|---|---|---|---|
| BUSPURP | Business Purpose | Alpha | 40 | Text describing the purpose for the expense report. |
| VENDCODE | Vendor Code | Alpha | 8 | A user-defined code that identifies the preferred supplier and corresponds directly to the expense category.
|
| VENDNAME | Vendor Name | Alpha | 35 | The name of the vendor from which the expense was incurred. |
| VSTREET | Street | Alpha | 40 | The street in the vendor's address where the expense was incurred. |
| VCITY | City | Alpha | 30 | The city in the vendor's address where the expense was incurred. |
| VSTATE | State | Alpha | 2 | The state in the vendor's address where the expense was incurred. |
| VZIPCODE | Zip | Alpha | 12 | The zip code (postal code) in the vendor's address where the expense was incurred. |
| VCOUNTRY | Country | Alpha | 30 | The country in the vendor's address where the expense was incurred. |
| TICKNUMB | Ticket Number | Alpha | 15 | A number assigned to the airline ticket for tracking purposes. |
| CLASSERV | Class of Service | Alpha | 15 | The type of service that corresponds to the mode of travel. For example, First Class, Business Class, Coach. |
| DESTIN1 | First Destination | Alpha | 20 | The location of the first stop in a series of stops, or the From location of a car rental agency. |
| DESTIN2 | Second Destination | Alpha | 20 | The location of the second stop in a series of stops, or the To location of a car rental agency. |
| DESTIN3 | Third Destination | Alpha | 20 | The location of the third stop in a series of stops. |
| FMDATE | From Date | Date | 6 | The beginning date in a date range that might be used to describe the period of time during which a car was rented or a room was occupied. |
| TODATE | To Date | Date | 6 | The ending date in a date range that might be used to describe the period of time during which a car was rented or a room occupied. |
| NUMBDAYS | Number of Days | Number | 3 | The number of days or nights that were expended during a stay at a hotel or for which a car was rented. |
| SBL | Subledger | Alpha | 8 | The subledger to which the expense should be charged if the field is used. |
| SBLT | Subledger Type | Alpha | 1 | A code that identifies the type of subledger.
The value that you specify must exist in UDC 00/ST. |
| TEXT1 | Text Field 001 | Alpha | 40 | Fields that the system updates, in conjunction with the expense category, when you set up expense category attributes that use fields from the data dictionary. |
| TEXT2 | Text Field 002 | Alpha | 40 | Blank |
| TEXT3 | Text Field 003 | Alpha | 40 | Blank |
| NUMERIC1 | Numeric 01 | Number | 15 | Blank |
| NUMERIC2 | Numeric 02 | Number | 15 | Blank |
| NUMERIC3 | Numeric 03 | Number | 15 | Blank |
| DATE1 | Date Field 1 | Date | 6 | Blank |
| DATE2 | Date Field 2 | Date | 6 | Blank |
| DATE3 | Date Field 3 | Date | 6 | Blank |
| TELNUMB | Telephone Number Called | Alpha | 20 | The telephone number for which charges were expensed. |
| UNITS | Units | Number | 6 | The quantity of an item, such as the number of miles. |
| RATE1 | Rate | Number | 15 | The cost per unit, such as the nightly cost for a hotel room or the amount per mile that could be reimbursed. |
This table lists the fields that the system updates. You should not complete these fields. If you do, the system overwrites the values entered. The system updates these fields in table F20112 when the credit card transaction is applied to an expense report.
| Alias | Field Name | Type | Length | Definition |
|---|---|---|---|---|
| EXRPTTYP | Expense Report Type | Alpha | 1 | The expense report type that is assigned when the employee applies the credit card transaction to their expense report. |
| EXRPTNUM | Expense Report Number | Alpha | 10 | The number that the system assigns automatically to the expense report for tracking purposes.
The system assigns the number from the Next Numbers - Automatic table (F0002). |
| DTECRT | Expense Report Date Created | Date | 6 | The date that the expense report was created. |
| ENUMBER1 | Expense Report Employee ID | Number | 8 | The employee ID for whom the expense report was created. |
| ETEXT001 | Expense Report Workstation ID | Alpha | 10 | The ID of the workstation on which the expense report was created. |
| PID | Program ID | Alpha | 10 | The program number of the program that updated the record. |
| USER | User ID | Alpha | 10 | The ID of the user that updated the record. |
| JOBN | Work Station ID | Alpha | 10 | The ID of the computer that was used to update the record. |
| UPMT | Time - Last Updated | Number | 6 | The time that the record was updated. |
| UPMJ | Date - Updated | Date | 6 | The date that the record was updated. |
This table lists the fields that have been reserved for your business needs. The JD Edwards EnterpriseOne Expense Management programs do not update these fields, nor do they map to table F20112. You can use these fields for tracking the information that you receive from the credit card company and is stored in table F09E150.
| Alias | Field Name | Type | Length |
|---|---|---|---|
| CCRPTTYP | Credit Card Co Report Type | Alpha | 25 |
| CCRPTNUM | Credit Card Co Report Number | Alpha | 25 |
| CCRPTDTE | Credit Card Co Report Date | Date | 6 |
| CCFILENO | Credit Card Co File Number | Alpha | 10 |
| CCRECIPN | Credit Card Co Recipient Number | Alpha | 10 |
| CTLID | Control Number | Alpha | 30 |
| DESC01 | Description 001 | Alpha | 45 |
| DESC02 | Description 002 | Alpha | 45 |
| DESC03 | Description 003 | Alpha | 45 |
| DESC04 | Description 004 | Alpha | 45 |
| GAMOUNT1 | Generic Amount 1 | Number | 15 |
| GAMOUNT2 | Generic Amount 2 | Number | 15 |
| GCODE1 | Generic Code_Length 5 | Alpha | 5 |
| GCODE2 | Generic Code_Length 10 | Alpha | 10 |
| GDATE1 | Generic Date 1 | Date | 6 |
| GDATE2 | Generic Date 2 | Date | 6 |
| GFLAG1 | Generic Flag 1 | Alpha | 1 |
| GFLAG2 | Generic Flag 2 | Alpha | 1 |
| GNUMBER1 | Generic Number 1 | Number | 8 |
| GNUMBER2 | Generic Number 2 | Number | 10 |
| GTEXT001 | Generic String 001 | Alpha | 40 |
| GTEXT002 | Generic String 002 | Alpha | 40 |
| ORIGNUMB | Originating Number | Alpha | 20 |
| REFNUMB | Reference Number | Alpha | 20 |
| REFDATE1 | Reference Date | Date | 6 |
| TAXAMT | Tax Amount | Number | 15 |
| TAXTYPE | Tax Type | Alpha | 15 |
This table lists the fields that are reserved by the JD Edwards system for future use. Do not use these fields for custom purposes.
| Alias | Field Name | Type | Length |
|---|---|---|---|
| EAMOUNT1 | Amount 01 | Number | 15 |
| EAMOUNT2 | Amount 02 | Number | 15 |
| ECODE1 | Code_Length 5 | Alpha | 5 |
| ECODE2 | Code_Length 10 | Alpha | 10 |
| EDATE1 | Date 1 | Date | 6 |
| EDATE2 | Date 2 | Date | 6 |
| EFLAG1 | Flag 1 | Alpha | 1 |
| EFLAG2 | Flag 2 | Alpha | 1 |
| ENUMBER2 | Number 2 | Number | 8 |
| ETEXT002 | String 002 | Alpha | 40 |
| REASON | Reason Code | Alpha | 10 |
To maintain consistency between the exchange rates used by the credit card company and those used historically in other JD Edwards EnterpriseOne financial applications, you might want the system to automatically calculate the exchange rate based on the conversion method specified by the system, instead of the conversion method used by the credit card company.
You can use the Visual C++ business function, Adjust Spot Rate for Default Conversion Method (B09E0022), to retrieve and use the conversion method for the exchange rate specified in the Credit Card Transaction Interface Table (F09E150). The business function updates the exchange rate in table F09E150 according to the conversion method specified. This business function should be called for each credit card transaction that will be processed by your custom program when the exchange rate provided by the credit card company for the transaction is greater than zero.
To use business function B09E0022, you must provide:
| Field Description | Alias | Field Type | Length | Use |
|---|---|---|---|---|
| Exchange Rate | CRR_IN | MATH_NUMERIC | 8 leading numbers, 7 trailing decimals | The exchange rate from the credit card company |
| Spot Rate Conversion Method | CRCM_IN | JCHAR | 1 | The conversion method used by the credit card company:
|
| Currency Code From | CRCD_IN | JCHAR | 3 characters terminated by a fourth NULL character | The currency code of the transaction from the credit card company |
| Currency Code To | CRDC_IN | JCHAR | 3 characters terminated by a fourth NULL character | The domestic, billed currency of the credit card company |
| Date Effective Rates | EFT_IN | JDEDATE | 6 character Julian date | The date of the credit card expense |
| Address Number | AN8_IN | MATH_NUMERIC | 8 | The address book number of the credit card company, if specified in the Exchange Rate Identifiers table (F09E114). |
| System Currency Conversion Method | CRCM_IN | JCHAR | 1 | Currency conversion method specified in the General Constants table (F0009):
|
When the business function runs, it returns this information:
| Field Description | Alias | Field Type | Length | Use |
|---|---|---|---|---|
| Adjusted Spot Rate Conversion Method | CRCM_OUT | JCHAR | 1 | The conversion method to use for the exchange rate.
The system returns this information if your custom program requires debugging. |
| Adjust Spot Rate | CRR_OUT | MATH_NUMERIC | 8 leading numbers, 7 trailing decimals | The adjusted exchange rate to account for the difference between the conversion method used by the credit card company and the JD Edwards EnterpriseOne Expense Management system.
The business function returns an adjusted exchange rate only when the currency conversion method used by the Expense Entry program is different from the currency conversion method used by the credit card company The returned adjusted exchange rate should be used by your custom program to update the Exchange Rate field (CRR) in table F09E150. |
|
Note: If you do not provide the exchange rate, the system retrieves information for the exchange rate from the Currency Exchange Rates table (F0015) when the credit card expense is applied to the expense report. The system uses the address book number, if provided, to locate a specific exchange rate for the credit card company. If the exchange rate is not set up with an address book number, the system retrieves the default exchange rate for the currency code pair. The system uses the currency conversion method specified for the currency pair to calculate an adjusted spot rate. If the exchange rate is set up for triangulation, or if the system cannot locate the exchange rate for the pair of currency codes, the system uses the currency conversion method specified in the General Constants table (F0009).However, the system does not update table F09E150 with the exchange rate used when the credit card expense is applied to the expense report. The system updates the Expense Report Detail table (F20112) only. |