Multicurrency Fields Required in the F03B11Z1 Table
This table provides information about the required multicurrency fields in the F03B11Z1:
Field Name |
Alias |
Type |
Length |
Description |
---|---|---|---|---|
Currency Mode |
VJCRRM |
Alpha |
1 |
A code that indicates whether the invoice is domestic or foreign. This field is used in conjunction with the Currency Code (VJCRCD), Gross Amount (VJAG), Currency Amount (VJACR), and Exchange Rate (VJCRR) fields to calculate required amounts for the transaction. Enter D or F, depending on other information provided in the transaction. If you leave this field blank, the system determines this value based on other information provided in the transaction. The system updates this field when the invoice is processed. |
Currency Code |
VJCRCD |
Alpha |
3 |
A code that identifies the currency of the invoice. The value that you enter in this field must exist in the F0013 table. |
Currency Amount |
VJACR |
Number |
15 |
A foreign currency amount. Enter the transaction amount only if the value in the Currency Code field (VJCRCD) is different from the currency code of the company, as defined in the F0010 table. |
Exchange Rate |
VJCRR |
Number |
15 |
An amount that specifies the exchange rate for calculating the domestic or foreign amount of the invoice. If you leave this field blank, the system retrieves the exchange rate from the F0015 table. Enter an exchange rate if you want to override the exchange rate in the F0015 table or if an exchange rate does not exist. If you set the processing option in the Invoice Entry MBF Processing Options (P03B0011) to activate tolerance checking, the system validates the exchange rate that you enter. If you do not have tolerance checking activated, no validation is performed. |
Foreign Discount Available |
VJCDS |
Number |
15 |
Enter an amount, or leave this field blank if you want the system to calculate the discount based on the Payment Terms Code field (VJPTC). If the VJPTC field is blank, the system calculates the discount based on the payment term in the F03012 table. |
Foreign Taxable Amount |
VJCTXA |
Number |
15 |
The system updates this field based on information in the Tax Rate/Area (VJTXA1), Tax Explanation Code (VJEXR1), and Currency Amount (VJACR) fields. The system calculates the amount that is not provided in the record. For example, if you enter an amount in the Foreign Taxable Amount field (VJCTXA) and you leave the Currency Amount field (VJACR) blank, the system calculates the currency amount. Do not enter complete both the Currency Amount (VJACR) and Foreign Taxable Amount (VJCTXA) fields. If the Currency Mode field (VJCRRM) is D, do not complete the Foreign Taxable Amount, Foreign Non-Taxable Amount, and Foreign Tax Amount fields. Instead, use the Taxable Amount (VJATXA), Non-Taxable Amount (VJATXN), and Tax Amount (VJSTAM) fields. |
Foreign Non-Taxable Amount |
VJCTXN |
Number |
15 |
The system updates this field based on information in the Tax Rate/Area (VJTXA1), Tax Explanation Code (VJEXR1), and Currency Amount (VJACR) fields. The system calculates the amount that is not provided in the record. For example, if you enter the amount in the Foreign Taxable Amount field (VJCTXA) and you leave the Currency Amount field (VJACR) blank, the system calculates the currency amount. Do not complete both the Currency Amount (VJACR) and Foreign Taxable Amount (VJCTXA) fields. If the Currency Mode field (VJCRRM) is D, do not complete the Foreign Taxable Amount, Foreign Non-Taxable Amount, and Foreign Tax Amount fields. Instead, use the Taxable Amount (VJATXA), Non-Taxable Amount (VJATXN), and Tax Amount (VJSTAM) fields. |
Foreign Tax Amount |
VJCTAM |
Number |
15 |
The system updates this field based on information in the Tax Rate/Area (VJTXA1), Tax Explanation Code (VJEXR1), and Currency Amount (VJACR) fields. The system calculates the amount that is not provided in the record. For example, if you enter the amount in the Foreign Taxable Amount field (VJCTXA) and you leave the Currency Amount field (VJACR) blank, the system calculates the currency amount. Do not complete both the Currency Amount (VJACR) and Foreign Taxable Amount (VJCTXA) fields. If the Currency Mode field (VJCRRM) is D, do not complete the Foreign Taxable Amount, Foreign Non-Taxable Amount, and Foreign Tax Amount fields. Instead, use the Taxable Amount (VJATXA), Non-Taxable Amount (VJATXN), and Tax Amount (VJSTAM) fields. |
Domestic Entry w/Mult Currency Distr |
VJDMCD |
Alpha |
1 |
If the distribution accounts in the F0911Z1 table are for a company that has a different currency than the company in the F03B11Z1 table, enter 1 in this field and activate the Allow Multi-Currency Intercompany Transaction option in the General Accounting Constants program (P0000). If you do not allow multicurrency intercompany transactions, leave this field blank. |
Foreign Open Amount |
VJACR |
Number |
15 |
Leave this field blank. The system updates this field when the transaction is processed. |
Foreign Discount Taken |
VJDSA |
Number |
15 |
Leave this field blank. The system updates this field when a receipt is applied against an invoice that contains an amount in the Foreign Discount Available field (VJCDS). |