Appendix: (ARG, CHL, PER) Mapping Fields for Batch Invoice Processing

This appendix discusses:

See Also

Mapping Fields for Batch Invoice Processing

Click to jump to parent topic(ARG) Mapping Fields in the Taxes - Tax Amounts by Invoice Suffix Batch Entry Table (F76A19Z1) for Argentina

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.

Click to jump to parent topic(CHL and PER) Mapping Fields in the F76H3B10 EDI Tag File – CHI - 03B table (F76H3B1Z) for Chile and Peru

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.

Click to jump to top of pageClick to jump to parent topicRequired Fields

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.

Click to jump to top of pageClick to jump to parent topicOptional Fields

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.

Click to jump to parent topic(CHL and PER) Mapping Fields in the F76H3B15 EDI Tag File – CHI – 03B table (F76H3B5Z) for Chile and Peru

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.