B Mapping Fields for Batch Invoice Processing in Chile

This appendix contains the following topics:

B.1 Mapping Fields in the F76H3B10 EDI Tag File – CHI - 03B Table (F76H3B1Z)

This section contains a list of required and optional fields in the F76H3B1Z table that are used for batch invoice processing for Chile.

B.1.1 Required Fields

These fields in the F76H3B1Z table are required for processing batch invoices:

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.


B.1.2 Optional Fields

These fields in the F76H3B1Z table are optional for batch invoice processing. 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.

B.2 Mapping Fields in the F76H3B15 EDI Tag File – CHI – 03B table (F76H3B5Z)

These fields in the F76H3B15 EDI Tag File – CHI – 03B table (F76H3B5Z) are required for processing batch invoices:

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.