Mapping to the Credit Card Transaction Interface Table

Appendix: Mapping to the Credit Card Transaction Interface Table

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).

Mapping Credit Card Transaction Information

These tables list each field in table F09E150 and describe the type of data expected by the system and how the field is used.

Required Fields

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.

Optional Fields That Appear on Forms

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. See Mapping Credit Card Transaction Information.
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.

Optional Fields for Reporting Purposes

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. If the expense category is AIR, the value that you enter must exist in UDC 09E/PA. If the expense category is HTL, the value that you enter must exist in UDC 09E/PH. If the expense category is CAR, the value that you enter must exist in UDC 09E/PC. If you have set up a preferred supplier for an additional expense category, the value that you enter must exist in UDC 09E/PS.
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.

Fields Updated by the System

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.

Fields Reserved for Clients

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

Fields Reserved for Future Use by the JD Edwards System

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

Adjust Spot Rate for Default Conversion Method

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: Y for multiplier Z for divisor
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): Y for multiplier Z for divisor

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.

Field Description

Alias

Field Type

Length

Use

Adjusted Spot Rate Conversion Method

CRCM_OUT

JCHAR

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.