This appendix provides information about the mapping requirements for uploading exchange rates to the External Currency Exchange Rates workfile (F0015Z1) from an external source.
See Also
Uploading Exchange Rates from an External Source
Review these tables for a list of required, optional, and unused fields in the External Currency Exchange Rates workfile (F0015Z1). The field names in the workfile correspond to the field names on interactive forms.
Required Fields in the F0015Z1 Workfile
These fields are required by the External Exchange Rate Processor program (R0015Z1).
Field Name |
Alias |
Type |
Length |
Definition |
EDI - User ID |
ZEEDUS |
Alpha |
10 |
A user-defined identification number. Enter the ID of the person running the process or the person who is to receive messages in the Employee Work Center. This field, in conjunction with ZEEDBT and ZEEDTN, uniquely identifies a specific group of transactions. |
EDI - Batch Number |
ZEEDBT |
Alpha |
15 |
A number used to group transactions for processing. This field, in conjunction with ZEEDUS and ZEEDTN, uniquely identifies a specific group of transactions. |
EDI - Transaction Number |
ZEEDTN |
Alpha |
22 |
This field, in conjunction with ZEEDLN, uniquely identifies each transaction. This field, in conjunction with ZEEDUS and ZEEDBT, uniquely identifies a specific group of transactions. |
EDI - Line Number |
ZEEDLN |
Number |
7 |
This field, in conjunction with ZEEDTN, uniquely identifies each line of the transaction. |
EDI - Successfully Processed |
ZEEDSP |
Alpha |
1 |
Leave this field blank. The system completes it as follows: 0 (zero): The transaction has not been processed or was processed in error. 1: The transaction has been successfully processed. |
Currency Code From |
ZECRCD |
Alpha |
3 |
A code that specifies the from currency of the transaction. This code must exist in the F0013 table. |
Date - Effective |
ZEEFT |
Date |
6 |
The effective date of the transaction. |
Currency Conversion Rate - Multiplier |
ZECRR |
Number |
15 |
The exchange rate (multiplier) for the transaction. |
Currency Code To |
ZECRDC |
Alpha |
3 |
A code that specifies the to currency of the transaction. This code must exist in the F0013 table. |
Currency Conversion Rate - Divisor |
ZECRRD |
Number |
15 |
The exchange rate (divisor) for the transaction. |
Calculation Method |
ZECLMETH |
Character |
1 |
The method used for the exchange rate calculation. Values are: 1: Inverse. 2: No inverse. 3: Triangulation. |
Optional Fields in the F0015Z1 Workfile
These fields are optional and not required by the External Exchange Rate Processor program.
Field Name |
Alias |
Type |
Length |
Definition |
Address Number |
ZEAN8 |
Number |
8 |
The address book number of a customer or supplier, used when a contractual exchange rate is applicable. This number must exist in the F0101 table. You must create a separate batch for each customer and supplier with a contractual exchange rate. This is necessary because you review and revise rates in the F0015Z1 workfile based on batch number, and not address book number. |
Currency Conversion Y/Z |
CRCM |
Character |
1 |
The multiplier (Y) or divisor (Z) method used for exchange rate calculations. If you leave this field blank, the program uses the conversion method set up in General Accounting Constants. |
Triangulation Currency Code |
TRCR |
String |
3 |
A third currency through which amounts between two currencies are calculated. |
Currency Spot Rate |
CSR |
Character |
1 |
An option that allows you to override the exchange rate in the F0015 table when you enter a transaction. Values are: 0: Do not allow spot rate. 1: Allow spot rate. |
System-Supplied Field Values in the F0015Z1 Workfile
These audit fields contain values that are updated by the External Exchange Rate Processor program.
Field Name |
Alias |
Type |
Length |
Definition |
User ID |
ZEUSER |
String |
10 |
A user-defined number that identifies the person running the process. |
Program ID |
ZEPID |
String |
10 |
The number of the program that identifies the batch application. |
Date - Updated |
ZEUPMJ |
Date |
6 |
A date that specifies when the F0015Z1 workfile was last updated. |
Time - Last Updated |
ZEUPMT |
Number |
6 |
The time that specifies when the F0015Z1 workfile was last updated. |
Work Station ID |
ZEJOBN |
String |
10 |
The identification number of the workstation in which the F0015Z1 workfile is being updated. |
Unused Fields in the F0015Z1 Workfile
These fields are not currently used by the External Exchange Rate Processor program and should be left blank. The program ignores any values entered in these fields.
Field Name |
Alias |
Type |
Length |
EDI - Document Type |
ZEEDCT |
Alpha |
2 |
Type - Transaction |
ZETYTN |
Alpha |
8 |
EDI - Translation Format |
ZEEDFT |
Alpha |
10 |
EDI - Transmission Date |
ZEEDDT |
Date |
6 |
Direction Indicator |
ZEDRIN |
Alpha |
1 |
EDI - Detail Lines Processed |
ZEEDDL |
Number |
5 |
Trading Partner ID |
ZEPNID |
Alpha |
15 |
Transaction Action |
ZETNAC |
Alpha |
2 |
Type Record |
ZEEDTY |
Alpha |
1 |
Record Sequence |
ZEEDSQ |
Number |
2 |
EDI - Transaction Set Number |
ZEEDTS |
Alpha |
6 |
EDI - Send/Receiver Indicator |
ZEEDER |
Alpha |
1 |
EDI - Transaction Action |
ZEEDTC |
Alpha |
1 |
EDI - Transaction Type |
ZEEDTR |
Alpha |
1 |
Batch File Create G/L record |
ZEEDGL |
Alpha |
1 |
Batch File Discount Handling Flag |
ZEEDDH |
Alpha |
1 |
User Address Number |
ZEEDAN |
Number |
8 |
Currency Rate Type |
ZERTTYP |
String |
2 |