appendix b – x12 example transactions

CAT EDI Appendix B - X12 Example Transactions - 20141124.rtf

File Name: CAT EDI Appendix B - X12 Example Transactions - 20141124.rtf 1 of 23

Modified on 11/24/2014 9:29:00 AM

Last saved by John Zdanowski

Caterpillar EDI Documentation Appendix B – X12 Example Transactions

Document Owner: EDI/B2B Integration Architect

Integration Competency Center

Global Information Services

Caterpillar, Inc.



Modified on 11/24/2014 9:29:00 AM


Table of Contents

INTRODUCTION ....................................................................................................................................................... 3

CHANGE CONTROL ................................................................................................................................................ 3

GENERAL RULES FOR EUROPEAN VAT 810 INVOICE .................................................................................. 5

MANDATORY ELEMENTS FOR VAT EUROPEAN DIRECTIVE: .................................................................................. 5

MIXED RATE INVOICES ARE NOT ALLOWED:........................................................................................................... 5

CALCULATION AND ROUNDING RULES FOR VAT REPORTING: .............................................................................. 5

CALCULATION AND ROUNDING EXAMPLE: ............................................................................................................. 6

DO NOT SEND TXI*VA FOR ZERO RATE VAT: ............................................. ERROR! BOOKMARK NOT DEFINED.

VAT ID NUMBER REQUIREMENTS: ........................................................................................................................ 6

ASN AND INVOICE MATCHING REQUIREMENTS: ................................................................................................... 6

EXAMPLE 810 TRANSACTIONS ............................................................................................................................ 7

810 EXAMPLE 1 - 2 POS, 2 ITEMS (1 VAT RATE), 1 ADDITIONAL CHARGE (VAT): .......................................... 7

810 EXAMPLE 2 - 1 PO, 1 ITEM (VAT EXEMPT) .................................................................................................. 9

810 EXAMPLE 3 - 1 PO, 1 SERVICE ITEMS (NO VAT) ........................................................................................ 10

810 EXAMPLE 4 - 1 PO, 1 SERVICE ITEM (1 VAT) RECALCULATE VAT IN LOCAL CURRENCY. .................... 11

810 EXAMPLE 5 - 1 PO, 1 SERVICE ITEM – (VAT NOT APPLICABLE) SUPPLIER NOT IN EU. ........................... 12

810 EXAMPLE 6 - 1 PO, 1 SERVICE ITEM (NO VAT) LINKED TO PARTS MOVEMENT. ..................................... 13

810 EXAMPLE 7 - 1 PO, 1 SERVICE ITEM (VAT NOT APPLICABLE) NO FISCAL REP ........................................ 14

810 EXAMPLE 8 – 1 PO, 1 ITEM (VAT NOT APPLICABLE) CREDIT MEMO ....................................................... 15

810 EXAMPLE 9 - 1 PO, 1 ITEM (VAT NOT APPLICABLE) FISCAL REP ............................................................. 16

810 EXAMPLE 10 - 1 PO, 1 ITEM (VAT NOT APPLICABLE) NO PAPER INVOICE ............................................... 17

810 EXAMPLE 11 - 1 PO, 1 ITEM (VAT APPLICABLE) NO PAPER INVOICE ....................................................... 18

810 EXAMPLE 12 - 1 PO, 1 ITEM (VAT) 1 ADDITIONAL CHARGE (VAT) COMMERCIAL INFO. ...................... 19

810 EXAMPLE 13 - 1 PO, 1 ITEM (VAT EXEMPTION) ........................................................................................ 20

810 EXAMPLE 14 - 1 PO, 1 ITEM (VAT), RECALCULATED IN LOCAL CURRENCY ............................................ 21

810 EXAMPLE 15 – 5 POS, 4 ITEMS, US FACILITY AND SUPPLIER .................................................................... 22



Modified on 11/24/2014 9:29:00 AM


Introduction

This document provides additional information to Caterpillar Trading Partners and supports

Caterpillar published EDI Guidelines.

Change Control

Version

ID

Date of

Update Updated By Description of Version and Change

20120809 08/09/2012 John Zdanowski • Initial Conversion

20130409 04/09/2013 John Zdanowski • Updated 810 Invoice examples per European VAT

Directive, replacing specific REF qualifiers for country

specific legal and commercial information numbers.

• Added list of European VAT Mandatory requirements

• Added list of General VAT reporting rules.

• Added a non-European, non-VAT example.

20131024 10/24/2013 John Zdanowski • Removed 'AH' qualifier from REF01, as well as all 'AH'

verbiage from all examples, as VAT Tax Manager

determined that "Convention/Agreement Number" is not

needed for VAT compliance and can be handled via

another non-EDI mechanism. (VAT Tax Mgr).

20141124 11/24/2014 John Zdanowski • Corrected example 1, 2, 4, 11, 12, 13 and 14 to properly

reflect the VAT Tax Rate and the Additional Charge

Amount on the corresponding ITA segments.

• Clarified wording on item 7 of the “Mandatory elements

for VAT European directive” section.

• Updated examples to show how to report “Tex Exempt”

on the summary level ITA segment, when VAT does not

apply.

• Corrected ITA04 in VAT examples.

ccyymmdd •

.

.



Modified on 11/24/2014 9:29:00 AM




Modified on 11/24/2014 9:29:00 AM


General Rules for European VAT 810 Invoice

Mandatory elements for VAT European directive:

The following items are required based on VAT European Directive for EDI 810 Invoices:

1) Date of issue

2) Unique sequential invoice number

3) Full name and address of the supplier and VAT ID

4) Full name and address of the buyer and VAT ID

5) Quantity and nature of goods or services

6) Date of supply

7) Total Amount subject to VAT.

8) Rebates or discounts

9) VAT rate

10) VAT amount payable in local currency

11) Exemption or reverse charge provision

12) When a VAT Representative is involved:

a. VAT Representative VAT ID

b. VAT representative full name and address.

Mixed rate invoices are not allowed:

• Please use only 1 VAT rate per invoice. If you are supplying goods or services which are subject to

different rates of VAT, create separate invoices for each VAT rate

• You can send several invoices in the same ISA envelope, but only if all the invoices have been issued by

same VAT ID entity, and are addressed by a single VAT ID of the customer.

Calculation and Rounding rules for VAT reporting:

• Unit price can only have maximum of 5 decimal positions

• For each line item, the Quantity x Unit of Measure x Unit Price should not be rounded.

• The total result for all the lines should be rounded to 2 decimal positions.

• The VAT calculation total all lines x VAT rate should be rounded to 2 decimal positions.

• Total Invoice Amount should be multiplied by 100, as the decimal is implied at last 2 digits.



Modified on 11/24/2014 9:29:00 AM


Calculation and Rounding example:

Quantity Unit of

measure Price (max 5 decimal)

for each line : Qty x Unit of measure X unit price

(not rounded )

10 per piece 20.12345 201.2345

1 packaging 10 10

5 per piece 10.03 50.15

261.3845 total of the lines not rounded

ITA10 = 261.38 total of the lines rounded 2 decimal

ITA09 = ,21 VAT rate

54.8898 VAT Calculation

ITA07 = 5489

Total VAT - rounded 2 decimal x 100

TDS01 = 31627 total amount VAT included

VAT ID Number Requirements:

The supplier name, address and VAT ID, as well as the Caterpillar Facility name, address and

VAT ID needs to be accurately recorded in your invoice. Please pass this information in the

appropriate N1 loop ( SE, BY, IC, AG ). Caterpillar will perform detailed validation of this

information and any inaccuracies or omissions will delay payment.

ASN and Invoice Matching Requirements:

The supplier invoice will be validated against actual receipts and information sent on the EDI

856 Advance Ship Notice. Supplier must logically link the Invoice to the ASN. To create a

logical relation between the Invoice and ASN, please use the same ‘reference’ and ‘format’

information. For example, the Packing List (REF*PK*PL12345) can be tied to the

SUPPLIERS SHIPPING REFERENCE NUMBER on the invoice.



Modified on 11/24/2014 9:29:00 AM


Example 810 Transactions

This section shows various detailed sample EDI 810 Invoice Transactions. These transactions

illustrate various 810 Invoice situations and circumstances a supplier may encounter when

invoicing Caterpillar. Some of the situations illustrated include invoicing from an European

Union Supplier, invoices where VAT is being charged on the invoice, whether additional

charges apply, etc. Other examples illustrate how to invoice if fiscal representative data is

required for the supplier or customer and how to report any additional legal or commercial data

that may be required by an EU Taxing Authority. Please read and follow these examples

carefully. Please work with your internal Tax Department to fully understand what is required

by your Taxing Authority.

810 EXAMPLE 1 - 2 POs, 2 Items (1 VAT rate), 1 Additional Charge (VAT): This example illustrates how to invoice for GOODS provided to a CAT SARL facility. Caterpillar’s

Customer Fiscal Representative info is passed (N1*IC loop), and the Supplier Fiscal Representative

information is also passed (N1*AG loop). Since delivery of goods is involved, the ‘Ship From’

(N1*SF) and ‘Ship to’ (N1*ST) is sent. ---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*00507047925

*130401*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*25*130401*1200*000000001*X*003030@

ST*810*0001@

BIG*130401*1234567*****CA@

NTE*INV*FREE FORM NOTES EX# 1@

CUR*BY*EUR@

REF*PK*PL12345@

N1*SF*SUPPLIER ABCD*92*X0000X0@

N3*515 PARK LAKE@

N4*CHIVALA*MI*31450*US@

N1*ST*CATERPILLAR BELGIUM SA*92*25@

N3*1 AVENUE DES ETATS-UNIS*BP1@

N4*GOSSELIES**B-6041*BE@

N1*BY*CATERPILLAR SARL*92*25@

N3*ROUTE DE FRONTENEX 76@

N4*GENEVA**CH-1211*CH@

REF*VX*BE0466550796@

N1*IC*CATERPILLAR GROUP SERVICES SA@



REF*VX*BE0428189078@

N1*SE*SUPPLIER ABCD*92*X0000X0@

N3*444 CORN PARK*SUITE 200@

N4*CHICAGO*IL*1000*US@

REF*VX*BE0123456789@

N1*AG*SUPPLIER FISCAL REP@

N3*5 AVENUE XYZ@

N4*GRIMBERGEN**B-9412*BE@

REF*VX*BE0888888888@

ITD*08*ZZ*5**30@

DTM*011*040401@



Modified on 11/24/2014 9:29:00 AM


IT1*1*10*PC*20.12**BP*190-0499*PO*AAB 12345@

IT3*10*PC@

TXI*VA**.21@

PID*F****WIDGET@

REF*BM*BOL12345@

ITA*C*AX*PC*06***1000***1*PD**PACKAGING@

TXI*VA**.21@

IT1*1*1*PC*50.69**BP*190-0500*PO*AAB 12346@

IT3*20*PC@

TXI*VA**.21@

PID*F****TRACK@

REF*BM*BOL12345@

NTE*INV*FREE FORM NOTES - ITEM@

TDS*31689@

CAD*T****Z@

ITA*C*AX*TX*06***5500**.21*261.89*M4**VALUE ADDED TAX*750@

CTT*2@

SE*47*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 2 - 1 PO, 1 Item (VAT Exempt) In this example, VAT is not applicable, so the VAT exemption number must be sent (REF*TL). Since

this invoice involves delivery of goods, the ‘Ship From” (N1*SF loop) and ‘Ship to’ (N1*ST loop)

must be sent. The supplier must also send the paper invoice as the ‘Legal Invoice’ to the Accounts

Payable address sent on the Purchase Order.

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479RB

*040401*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*RB*040401*1200*000000001*X*003030@

ST*810*0001@

BIG*040401*1234567*****CA@


CUR*BY*EUR@

REF*PK*PL12345@

REF*TL*EXONERATION ART 39-2,1 CTVA*P.A./S 01/08/2002D.D.239.831/551.8430.1@


N3*RUE DU LOUP@





N1*BY*CATERPILLAR BELGIUM SA*92*RB@

N3*1 AV. DES ETATS-UNIS*BP1@


REF*VX*BE0401633250@


N3*AVENUE DES PONTS*BP2@

N4*BRUXELLES**B-1000*BE@

REF*VX*BE0456789123@

ITD*08*ZZ*0**60@

DTM*011*040401@

IT1*1*10*PC*20**BP*190-0499*PO*AAB 12345@

IT3*10*PC@

PID*F****WIDGET@

REF*BM*BOL12345@


TDS*21000@

CAD*T****Z@

ITA*C*AX*TX*06***000**0**M4**VAT EXEMPT*750@

CTT*1@

SE*32*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 3 - 1 PO, 1 Service Items (no VAT) This example illustrates how to send an Invoice for a Service provided to a Cat facility. Since no goods

are involved, the Ship To (N1*ST Loop) and Ship From information (N1*SF Loop) are not sent, nor the

means of transportation (CAD Segment). The Price is passed with 4 decimal places and the total

amount of the invoice is rounded to 2 decimal places. Note this invoice has 1 Purchase Order Number

and no Part Numbers.

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479RB

*040401*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*RB*040401*1200*000000001*X*003030@

ST*810*0001@

BIG*040401*1234567*****CA@


CUR*BY*EUR@

REF*TL*VAT NOT DUE@




REF*VX*BE0401633250@

N1*SE*LIEFERANT GHB*92*X0000X0@

N3*10 WITTELSBACHERPLATZ*BP2@

N4*MUNCHEN**80333*DE@

REF*VX*DE123456789@

ITD*08*ZZ*5**30@

DTM*035*040401@

IT1*1*1*PC*250.9876**PO*AAB 54321@

PID*F****CLEAN-UP@

TDS*25099@


CTT*1@

SE*20*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 4 - 1 PO, 1 Service item (1 VAT) Recalculate VAT in Local Currency. In this example, a supplier is invoicing for a Service provided to Caterpillar, so ‘Ship To’ (N1*ST loop)

and ‘Ship From’ (N1*SF) are not required, nor is the ‘Means of Transport’ (CAD segment). Even

though the supplier is invoicing in US Dollars (CUR*SE*USD), since the service is a country where the

local currency is the Euro (EUR), the supplier must send the TOTAL VAT Amount in Euro’s (Note the

EUR in the summary level TXI segment).

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479RB

*100622*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*RB*100622*1200*000000001*X*003030@

ST*810*0001@

BIG*100622*1234567*****CA@


NTE*INV*LOCAL CURRENCY IS EURO@

CUR*SE*USD@


N3*AVENUE DES ETATS-UNIS*BP1@


REF*VX*BE0401633250@

N1*SE*AMERICAN CABLE - BELGIUM*92*X0000X0@



REF*VX*BE0456789123@

ITD*08*ZZ*5**30@

DTM*035*100615@

IT1*1*1*PC*250**PO*AAB 54321@

TXI*VA**.21@

PID*F****CLEAN UP@

TDS*30250@

TXI*VA*39.75**CD*EUR@


CTT*1@

SE*23*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 5 - 1 PO, 1 Service Item – (VAT not applicable) Supplier not in EU. In this example, a Service is provided to a Cat facility by a supplier OUTSIDE of the European Community.

Since the supplier country is not a member of the European Union, EU VAT rules do not apply. Since no goods

were purchased, the ‘Ship To’ info (N1*ST Loop), ‘Ship From’ info (N1*SF Loop), and the Means of Transport

(CAD Segment) are not sent on the 810. However, since the Cat Facility is in a European Union Country, the

VAT ID of the Cat facility is sent (REF*VX in the N1*BY loop).

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479RB

*040401*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*RB*040401*1200*000000001*X*003030@

ST*810*0001@

BIG*040401*1234567*****CA@


CUR*BY*USD@




REF*VX*BE0401633250@

N1*SE*SUPPLIER US*92*X0000X0@

N3*ADAM STREET*BP2@

N4*PEORIA*IL*12345*US@

ITD*08*ZZ*5**30@

DTM*035*040401@

IT1*1*1*PC*250**PO*AAB 54321@

PID*F****CLEAN-UP@

TDS*25000@


CTT*1@

SE*19*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 6 - 1 PO, 1 Service Item (no VAT) linked to Parts Movement. The following example shows an 810 for a Service provided to Caterpillar CSARL facility 25. Since no Fiscal

Representative was involved, the IC loop is not needed. However, the Switzerland VAT number

CHE116294411TVA must be reported in the 810. This example includes an N1*ST (Shop To) loop and an

N1*SF (Ship From) loop, as well as the REF*PK and REF*BM segments because the Service is linked to a Parts

Movement.

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*00507047925

*040401*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*25*040401*1200*000000001*X*003030@

ST*810*0001@

BIG*040401*1234567*****CA@


CUR*BY*EUR@

REF*TL*VAT NOT DUE FOR SERVICES@

REF*PK*PK34567@




REF*VX*CHE116294411TVA@




REF*VX*BE0456789123@







ITD*08*ZZ*5**30@

DTM*035*040401@

DTM*011*040401@

IT1*1*1*PC*250**PO*AABS54321@

PID*F****CLEAN-UP@

REF*BM*BOL12345@

TDS*25000@


CTT*1@

SE*30*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 7 - 1 PO, 1 Service Item (VAT not applicable) no Fiscal Rep This is another example of Service provided to CSARL Cat facility 25, but without a fiscal representative (no IC

loop needed). Also, the Switzerland VAT number must also be passed. This example does not include the

N1*ST loop (Ship To) nor the N1*SF loop (Ship From), nor the REF*PK nor the REF*BM segments, since this

service is not linked to parts movement. ---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*00507047925

*040401*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*25*040401*1200*000000001*X*003030@

ST*810*0001@

BIG*040401*1234567*****CA@


CUR*BY*EUR@

REF*TL*VAT NOT DUE FOR SERVICES@




REF*VX*CHE116294411TVA @




REF*VX*BE0456789123@

ITD*08*ZZ*5**30@

DTM*035*040401@

IT1*1*1*PC*250**PO*AABS54321@

PID*F****CLEAN-UP@

TDS*25000@


CTT*1@

SE*20*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 8 – 1 PO, 1 item (VAT not applicable) Credit Memo This is an example of an 810 Credit note/memo. The Unit Price and Total Amount needs to be recorded without a

“negative’ sign. The original invoice number linked with this Credit note/memo needs to be sent in the REF*IV.

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479RB

*040401*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*RB*040401*1200*000000001*X*003030@

ST*810*0001@

BIG*040401*CR1234567*****CR@


CUR*BY*USD@

REF*IV*1234567@




REF*VX*BE0401633250@

N1*SE*SUPPLIER US*92*X0000X0@

N3*ADAM STREET*BP2@

N4*PEORIA*IL*12345*US@

ITD*08*ZZ*5**30@

DTM*035*040310@

IT1*1*1*PC*250**BP*123-4567*PO*ABB 54321@

PID*F****DRUM@

TDS*25000@


CTT*1@

SE*20*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 9 - 1 PO, 1 Item (VAT not applicable) Fiscal Rep This example illustrates an 810 transaction for goods provided to a Caterpillar facility, and since a Fiscal

Representative is used, the N1*IC loop must be used.

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479YQ

*040401*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*YQ*040401*1200*000000001*X*003030@

ST*810*0001@

BIG*040401*1234567*****CA@


CUR*BY*EUR@

REF*PK*PL12345@

REF*TL*EXONERATION ART 39-2,1 CTVA*P.A./S 01/08/2002D.D.239.831/551.8430.1@

N1*SF*OTHER SUPPLIER XYZ*92*Z0000Z0@

N3*AVENUE DES LAURIERS@

N4*CHARLEROI**B-6000*BE@

N1*ST*CATERPILLAR S.A.R.L.*92*YQ@

N3*CO CATERPILLAR GROUP SERVICES@


N1*BY*CATERPILLAR SARL*92*YQ@



REF*VX*BE0466550796@

N1*IC*CATERPILLAR GROUP SERVICES SA@

N3*AVENUE DES ETATS-UNIS BP1@


REF*VX*BE0428189078@




REF*VX*BE0456789123@

ITD*08*ZZ*5**30@

DTM*011*040401@

IT1*1*10*PC*20**BP*190-0499*PO*BABW12345@

IT3*10*PC@

PID*F****WIDGET@

REF*BM*BOM12345@


TDS*21000@

CAD*T****Z@


CTT*1@

SE*36*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 10 - 1 PO, 1 item (VAT not applicable) no Paper Invoice This is an example of an EDI 810 Invoice for goods provided to a Caterpillar facility for a European Invoice.

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479DX

*111201*0812*U*00200*123456789*0*P*\@

GS*IN*X0000X0*DX*111201*0812*000000001*X*003030@

ST*810*0001@

BIG*111201*1234567*****CA@


CUR*BY*EUR@

REF*PK*PL1234567@

REF*TL*EXONERATION VAT@

N1*SF*SUPPLIER NAME*92*X0000X0@

N3*GEORGES STRASSE 4@

N4*BERLIN**D-12681*DE@

N1*ST*PERKINS ENGINES COMPANY LIMITED*92*DX@

N3*EASTFILED@

N4*PETERBOROUGH**PE1 5NA*GB@

N1*BY*PERKINS ENGINES COMPANY LIMITED*92*DX@

N3*EASTFILED@

N4*PETERBOROUGH**PE1 5NA*GB@

REF*VX*GB661 5461 37@

N1*SE*SUPPLIER NAME*92*X0000X0@

N3*GEORGES STRASSE 4@

N4*BERLIN**D-12681*DE@

REF*VX*DE661543210@

ITD*08*ZZ*5**30@

DTM*011*111128@

IT1*1*1*PC*250**BP*190-1000*PO*AAB 54321@

PID*F****BUCKET@

TDS*25000@


CTT*1@

SE*28*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 11 - 1 PO, 1 item (VAT applicable) no Paper Invoice This 810 example illustrates an Invoice for GOODS provided to a Caterpillar facility by a European Supplier and

VAT does apply.

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479DK

*111201*0812*U*00200*123456789*0*P*\@

GS*IN*X0000X0*DK*111201*0812*000000001*X*003030@

ST*810*0001@

BIG*111201*1234567*****CA@


CUR*BY*GBP@

REF*PK*PL1234567@


N3*GEORGES KING 4@

N4*LONDON**BT14 1XL*GB@

N1*ST*CATERPILLAR (NI) LIMITED*92*DK@

N3*OLD GLENARM ROAD@

N4*LARNE**BT40 1EJ*GB@

N1*BY* CATERPILLAR (NI) LIMITED*92*DK@



REF*VX*GB254 7339 45@


N3*GEORGES KING 4@


REF*VX*GB222 3333 55@

ITD*08*ZZ*5**30@

DTM*011*111128@

IT1*1*1*PC*250**BP*190-1000*PO*AAB 54321@

TXI*VA**.20@

PID*F****BUCKET@

TDS*30000@


CTT*1@

SE*28*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 12 - 1 PO, 1 Item (VAT) 1 Additional Charge (VAT) Commercial Info. In this example, a French Supplier provides Goods to a Caterpillar European facility. Since the supplier is in

France, additional French Legal and Commercial information needs to be sent. All FRENCH suppliers are

required record their Legal and Commercial information (via multiple REF*ZZ) when invoicing Cat European

entities (not just Cat French facilities). The REF*ZZ can be used also for other countries, to record their specific

commercial and legal information numbers.

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479SD

*110819*1538*U*00200*000001092*0*P*<@

GS*IN* X0000X0*SD*110819*1538*1098*X*003030@

ST*810*5807@

BIG*110818*2112182*****CA@


CUR*SE*EUR@

REF*PK*2112424@

N1*ST*CATERPILLAR FRANCE SAS*92*SD@

N3*AVENUE AUGUSTE FERRIER*BATIMENT G20@

N4*ECHIROLLES**F-38130*FR@

N1*SF*FOURNISSEUR FRANCAIS SA*92*X0000X0@

N3*RUE DU COIN 14@

N4*LILLE**64430*FR@

N1*SE*FOURNISSEUR FRANCAIS SA*92*X0000X0@

N3*RUE DE CORN 12@

N4*BLANQUEFORT**33290*FR@

REF*VX*FR9507522270@

REF*ZZ*RCS BORDEAUX*B 507 522 270 00020@

REF*ZZ*507 522 270@

REF*ZZ*FOURNISSEUR FRANCAIS SA@

REF*ZZ*CAPITAL SOCIAL 15000000 EUR@

N1*BY*CATERPILLAR FRANCE SAS*92*SD@

N3*40 AVENUE LEON BLUM 40*BP55@

N4*GRENOBLE**F-38041*FR@

REF*VX*FR54061500245@

DTM*011*110818@

IT1*001*960*PC*2.98**PO*ABCD12345*BP*999-8888@

TXI*VA**.196@

PID*F****BACK TRACK@

REF*BM*BOL12345@

ITA*C*AX*PC*06**5.02****6*PL**EMBALLAGE@

TXI*VA**.196@

TDS*345754@

CAD*T****Z@


CTT*1@

SE*35*5807@

GE*1*1098@

IEA*1*000001092@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 13 - 1 PO, 1 Item (VAT Exemption) This example illustrates how to report a VAT exemption number on an EDI 810 Invoice, for good proviced to a

Caterpillar facility, and a supplier has not been approved to send legal invoice via EDI by VAT Taxing Authority.

A third party is sending the invoice on behalf of the supplier. The ‘Sender ID’ needs to be the ‘Supplier Code’ of

the third party. The third party invoicing ‘Supplier Code’ needs to be sent on the N1*SE loop, as well as the

name, address and VAT ID. Since this is a French Supplier, Legal and Commercial numbers need to be sent.

(Multiple REF*ZZ).

---------------------------------------------------------------------- ISA*00* *00* *ZZ*Z1234Z0 *09*005070479RB

*040401*1200*U*00200*123456789*0*P*\@

GS*IN*X0000X0*RB*040401*1200*000000001*X*003030@

ST*810*0001@

BIG*040401*1234567*****CA@


CUR*SE*EUR@

REF*PK*PL12345@

REF*TL*EXONERATION VAT@





N3*1 AV. DES ETATS-UNIS*BP1@


REF*VX*BE0401633250@

N1*SE*FOURNISSEUR FRANCAIS SA*92*X0000X0@

N3*RUE DE CORN 12@

N4*BLANQUEFORT**33290*FR@

REF*VX*FR9507522270@

REF*ZZ*RCS BORDEAUX*B 507 522 270 00020@

REF*ZZ*507 522 270@

REF*ZZ*FOURNISSEUR FRANCAIS SA@

REF*ZZ*CAPITAL SOCIAL 15000000 EUR@

N1*SF*AUTRE FOURNISSEUR*92*Y0000Y0@

N3*AVENUE FASTOCHE 1781@

N4*CALAIS**5555*FR@

ITD*08*ZZ*0**60@

DTM*011*040401@

IT1*1*10*PC*20**BP*190-0499*PO*AAB 12345@

IT3*10*PC@

PID*F****WIDGET@

REF*BM*BOL12345@


TDS*21000@

CAD*T****Z@


CTT*1@

SE*36*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 14 - 1 PO, 1 item (VAT), recalculated in Local Currency In this example, the EDI 810 transaction is for Goods ordered by a Caterpillar facility in the UK, from a European

Supplier, but the goods are to be shipped to (physical location/destination) a Caterpillar subsidiary in France. The

VAT must be recalculated in the Local Currency of the ‘Ship To’ country. In this example, the Invoiced

Currency Code is in GBP, (CUR*SE*GBP), but the VAT is recalculated in EUR, the local currency

(TXI*VA*38.53**CS*EUR@).

---------------------------------------------------------------------- ISA*00* *00* *ZZ*X0000X0 *09*005070479DK

*111201*0812*U*00200*123456789*0*P*\@

GS*IN*X0000X0*DK*111201*0812*000000001*X*003030@

ST*810*0001@

BIG*111201*1234567*****CA@


CUR*SE*GBP@

REF*PK*PL1234567@


N3*GEORGES KING 4@


N1*ST*CAT RESEARCH CENTER FRANCE*92*DK@

N3*AVENUE JAURES 19@

N4*LANQUAIN**FR-32980*FR@

N1*BY*CATERPILLAR (NI) LIMITED*92*DK@



REF*VX*GB254 7339 45@


N3*GEORGES KING 4@


REF*VX*GB222 3333 55@

ITD*08*ZZ*5**30@

DTM*011*111128@

IT1*1*1*PC*250**BP*190-1000*PO*AAB 54321@

TXI*VA**.20@

PID*F****BUCKET@

TDS*30000@

TXI*VA*38.53**CD*EUR@


CTT*1@

SE*29*0001@

GE*1*000000001@

IEA*1*123456789@



Modified on 11/24/2014 9:29:00 AM


810 EXAMPLE 15 – 5 POs, 4 items, US Facility and Supplier This is an example of a typical US Based Supplier sending an 810 Invoice to a US Caterpillar facility. The invoice

is for 5 different Purchase Orders, with 4 different Items. Since both supplier and facility are US based, no VAT

applies. ---------------------------------------------------------------------- ISA*00* *00* *ZZ*Z9999Z9 *09*00507047919

*130413*0320*U*00300*100000179*0*P*:

GS*IN*Z9999Z9*19*130413*0320*100000179*X*003030

ST*810*0001

BIG*130412*5676664**UOHB08199

REF*PK*5084505

N1*SE*CAL MFG*92*Z9999Z9

N1*ST*CATERPILLAR INC*92*DT8801

ITD*12*ZZ*0**0

DTM*011*130412

IT1*1*400*GA*29.0343**BP*0030064825

IT3*8*PC

PID*F****1E1950A 3.5 VOC CATERPILLAR YELLOW DTM URETHANE ENAMEL

TDS*1161372

CAD*T****Z


CTT*1

SE*15*0001

ST*810*0002

BIG*130412*5676663**UOB 08207

REF*PK*0



ITD*12*ZZ*0**0

DTM*011*130412

IT1*1*144*EA*4.9408**BP*0039880022

IT3*12*PC

PID*F****CAT 4C-4200 YELLOW PAINT HIGH GLOSS 12UC

TDS*71148

CAD*T****Z


CTT*1

SE*15*0002

ST*810*0003

BIG*130412*5676662**UOHB08201

REF*PK*5084507



ITD*12*ZZ*0**0

DTM*011*130412

IT1*1*50*GA*35.1248**BP*0030117948

IT3*10*PC

PID*F****EPOXY PRIMER CURING AGENT

TDS*175624

CAD*T****Z


CTT*1

SE*15*0003

ST*810*0004



Modified on 11/24/2014 9:29:00 AM


BIG*130412*5676661**UORP08117

REF*PK*0


N1*ST*CATERPILLAR INC*92*DTCZ57

ITD*12*ZZ*0**0

DTM*011*130412

IT1*1*12*EA*4.9408**BP*0039880022

IT3*1*PC

PID*F****CAT 4C-4200 YELLOW PAINT HIGH GLOSS 12UC

TDS*5929

CAD*T****Z


CTT*1

SE*15*0004

ST*810*0005

BIG*130412*5676665**UOB 08211

REF*PK*5084506



ITD*12*ZZ*0**0

DTM*011*130412

IT1*1*1000*GA*39.59344**BP*0030162359

IT3*20*PC

PID*F****R-CURE 200 PRIMER 1E2960D DAWN GRAY EPOXY FD

TDS*3959344

CAD*T****Z


CTT*1

SE*15*0005

GE*5*100000179

IEA*1*100000179

appendix b – x12 example transactions

Documents