This appendix discusses:
(ARG) Mapping Fields in the Taxes - Tax Amounts by Invoice Suffix Batch Entry table (F76A19Z1) for Argentina.
(CHL and PER) Mapping Fields in the F76H3B10 EDI Tag File – CHI - 03B table (F76H3B1Z) for Chile and Peru.
(CHL and PER) Mapping Fields in the F76H3B15 EDI Tag File – CHI – 03B table (F76H3B5Z) for Chile and Peru.
See Also
Mapping Fields for Batch Invoice Processing
These fields in the Taxes - Tax Amounts by Invoice Suffix Batch Entry table (F76A19Z1) are required for processing batch invoices for Argentina:
Field Name |
Alias |
Type |
Length |
Values to Enter/Definition |
EDI - User ID |
VKEDUS |
Alpha |
10 |
Enter the user ID of the person who is running the process or the person who is receiving messages in the Employee Work Center. This field, with the EDI - Transaction Number (VKEDTN), the EDI - Batch Number (VKEDBT), and the EDI - Line Number (VKEDLN) fields, uniquely identifies an invoice. |
EDI - Transaction Number |
VKEDTN |
Alpha |
22 |
Enter the source system's document number so that the transaction can be cross-referenced. This field, with the EDI - Line number field (VKEDLN), uniquely identifies each transaction. Each new transaction number identifies a new invoice. You cannot have more than one transaction with the same number in a batch unless the line number is different. |
EDI - Line Number |
VKEDLN |
Number |
7 |
Enter the pay item number only if a transaction has multiple pay items. If a transaction has only one pay item, you can leave this field blank. This field, with the EDI - Transaction Number field (VKEDTN), identifies each pay item of the invoice. |
EDI - Transaction Action |
VKEDTC |
Alpha |
1 |
Enter A in this field. No other values are valid. A code that specifies what the system must do with the transaction during final processing. |
EDI - Transaction Type |
VKEDTR |
Alpha |
1 |
Enter I (for invoices) in this field. A code that identifies a particular kind of transaction. |
EDI - Batch Number |
VKEDBT |
Alpha |
15 |
Enter a number to group transactions for processing. This field, with the EDI - Transaction Number (FKEDTN), the EDI - USER ID (VKEDUS), and the EDI - Line Number (VKEDLN) fields, uniquely identifies a transaction within a specific batch. This field also specifies a level break and causes the assignment of a new batch number each time that the value changes. To increase performance, assign one batch number for each group of transactions that is processed at one time. |
Document Company |
VKKCO |
Alpha |
5 |
Enter the same value that is entered in the corresponding field in the F03B11Z1 table. If you leave this field blank, the system uses the value entered the corresponding field (VJKCO) in the F03B11Z1 table. |
Document Type |
VKDCT |
Alpha |
2 |
Enter the same value that is entered in the corresponding field in the F03B11Z1 table. If you leave this field blank, you must also leave the corresponding field (VJDCT) blank in the F03B11Z1 table. |
Document Suffix |
VKSFX |
Alpha |
3 |
Enter 1 in this field if the invoice has only one line. If the invoice has more than one line, enter consecutive numbers beginning with 1. |
Tax Code |
VKATXC |
Alpha |
10 |
Enter the description of the corresponding tax code. |
Company |
VKCO |
Alpha |
5 |
Enter the number of company to which the invoice belongs. This number must exist in the F0010 table and identify a reporting entity that has a complete balance sheet. |
Address Number |
VKAN8 |
Number |
8 |
Enter the address book number of the customer who is associated with the invoice transaction. The number that you enter must exist in the Address Book Master table (F0101). |
Tax Amount in National Currency |
VKATDA |
Number |
15 |
Enter the tax amount. |
Tax Rate |
VKTXR1 |
Number |
7 |
Enter the value of the tax rate. |
This section contains a list of required and optional fields in the F76H3B1Z table that are used for batch invoice processing for Chile and Peru.
These fields in the F76H3B1Z table are required for processing batch invoices for Chile and Peru:
Field Name |
Alias |
Type |
Length |
Values to Enter/Definition |
EDI — User ID |
ZTEDUS |
Alpha |
10 |
Enter the user ID of the person who is running the process or the person who is receiving messages in the Employee Work Center. This field, with the EDI - Transaction Number (ZTEDTN) and the EDI - Batch Number (ZTEDBT), uniquely identifies an invoice. |
EDI — Transaction Number |
ZTEDTN |
Alpha |
22 |
Enter the source system's document number so that the transaction can be cross-referenced. Each new transaction number identifies a new invoice. |
EDI – Batch Number |
ZTEDBT |
Alpha |
15 |
Enter a number to group transactions for processing. This field, with the EDI - Transaction Number (ZTEDTN) and the EDI - USER ID (ZTEDUS) fields, uniquely identifies a transaction within a specific batch. This field also specifies a level break and causes the assignment of a new batch number each time that the value changes. To increase performance, assign one batch number for each group of transactions that is processed at one time. |
These fields in the F76H3B1Z table are optional for batch invoice processing for Chile and Peru. You can use the fields to provide additional information about invoices:
Field Name |
Alias |
Type |
Length |
Vales to Enter/Definition |
Legal Company |
ZTH76LECO |
Alpha |
5 |
Enter the same value that is in the corresponding field (VJCO) in the F03B11Z1 table. |
Legal Document Type |
ZTH76LEDT |
Alpha |
3 |
Enter a value that corresponds to an invoice. |
Emission Serial |
ZTH76EMS |
Alpha |
4 |
Enter a value that corresponds to CB if the processing option is set to verify sequence numbers. |
Legal Number |
ZTH76LENU |
Number |
10 |
Enter the legal number. |
Printed Invoice Flag |
ZTH76IPRT |
Alpha |
1 |
Enter Y to require a value in the Printed Invoice Date field (ZTH76IDPT). Enter N to not require a date. |
Printed Invoice Date |
ZTH76IDPT |
Date |
6 |
Enter the date that the invoice was printed. |
Entered Invoice Flag in Vat Sales Subledger |
ZTH76IRPT |
Alpha |
1 |
Enter Y to require a value in the Date Invoice Reported field (ZTH76IDPR). Enter N to not require a date. |
Date Invoice Reported |
ZTH76IDPR |
Date |
6 |
Enter the date that the invoice was included in the VAT sales ledger. |
Entered Invoice Flag in the magnetic support |
ZTH76IRMA |
Alpha |
1 |
Enter Y to require a value in the Date Invoice Magnetic Reported field (ZTH76IDRM). Enter N to not require a date. |
Date Invoice Magnetic Reported |
ZTH76IDRM |
Date |
6 |
Enter the date that the invoice was reported on magnetic media. |
Transaction Originator |
ZTTORG |
Alpha |
10 |
This field should be left blank. The system updates this field when the transaction is processed. |
User ID |
ZTUSER |
Alpha |
10 |
This field should be left blank. The system updates this field when the transaction is processed. |
Program ID |
ZTPID |
Alpha |
10 |
This field should be left blank. The system updates this field when the transaction is processed. |
Date - Updated |
ZTUPMJ |
Date |
6 |
This field should be left blank. The system updates this field when the transaction is processed. |
Time - Last Updated |
VJUPMT |
Number |
6 |
This field should be left blank. The system updates this field when the transaction is processed. |
Work Station ID |
VJJOBN |
Alpha |
10 |
This field should be left blank. The system updates this field when the transaction is processed. |
These fields in the F76H3B15 EDI Tag File – CHI – 03B table (F76H3B5Z) are required for processing batch invoices for Chile and Peru:
Field Name |
Alias |
Type |
Length |
Values to Enter/Definition |
EDI – User ID |
IREDUS |
Alpha |
10 |
Enter the user ID of the person who is running the process or the person who is receiving messages in the Employee Work Center. This field, with the EDI - Transaction Number (IREDTN), the EDI - Batch Number (IREDBT), and the EDI - Line Number (IREDLN) fields, uniquely identifies an invoice. |
EDI – Transaction Number |
IREDTN |
Alpha |
22 |
Enter the source system's document number so that the transaction can be cross-referenced. This field, with the EDI - Line number field (IREDLN), uniquely identifies each transaction. Each new transaction number identifies a new invoice. You cannot have more than one transaction with the same number in a batch unless the line number is different. |
EDI – Batch Number |
IREDBT |
Alpha |
15 |
Enter a number to group transactions for processing. This field, with the EDI - Transaction Number (IREDTN), the EDI - USER ID (IREDUS), and the EDI - Line Number (IREDLN) fields, uniquely identifies a transaction within a specific batch. This field also specifies a level break and causes the assignment of a new batch number each time that the value changes. To increase performance, assign one batch number for each group of transactions that is processed at one time. |
EDI – Line Number |
IREDLN |
Number |
7 |
Enter the pay item number only if a transaction has multiple pay items. If a transaction has only one pay item, you can leave this field blank. This field, with the EDI - Transaction Number field (IREDTN), identifies each pay item of the invoice. |
Legal Company |
IRH76LECO |
Alpha |
5 |
Enter the same value that is in the corresponding field (VJCO) in the F03B11Z1 table. |
Legal Document Type |
IRH76LEDT |
Alpha |
3 |
Enter a value that corresponds to an invoice. |
Emission Serial |
IRH76EMS |
Alpha |
4 |
Enter a value that corresponds to CB if the processing option is set to verify sequence numbers. |
Legal Number |
IRH76LENU |
Number |
10 |
Enter a legal number. Note. This field is required if the processing option is set to require legal numbers. |