IMPLEMENTATION GUIDELINES FOR ANSI ASC X12 EDI CONVENTIONS PentaSAP ACCOUNTS PAYABLE INVOICE (810) TRANSACTION SET
FCA US INFORMATION & COMMUNICATION TECHNOLOGY MANAGEMENT ANSI ASC X12 VERSION/RELEASE 002040
FCA US - PentaSAP Accounts Payable Invoice 810 Invoice Functional Group ID=IN
Introduction: This standard provides the format and establishes the data contents of an invoice transaction set. The invoice transaction set provides for customary and established business and industry practice relative to the billing for goods and services provided.
Notes: This document applies to invoicing for indirect orders and production shipments to Non-ERS plants. Prior to 810 transmission testing or questions regarding incorrect or missing data, contact the Corporate Accounts Payable Staff. Please refer to the EDI Contact List: https://ps.extra.chrysler.com/sites/itb-ebus/Documents/EDIContactList.pdf History of Changes: 08/27/2012: Guide completed for PentaSAP, Wave 1 10/10/2012: Header - Modified EVT Qualifier Description for Element ITA05 12/11/2012: Header - Modified ST Qualifer Description for Element N104 01/21/2013: Example - Updated 02/22/2013: Header - Updated the element usage description for the N102 and N104. Detail - Updated the segment usage description for the IT1. Detail - Updated the element usage description for the IT103. Added Appendix A which includes bill to location assignements for MOPAR. 04/09/2013: Header - Removed N1~MA (Ultimate Destination Location) usage. This is not supported by PentaSAP. 06/03/2013: Header - Removed 'EA' and 'JB' from the REF01. These are not used in PentaSAP. Header - Removed PWK segment. This is not used in PentaSAP. Detail - Removed the PWK segment. This is not used in PentaSAP. Added Appendix B which contains error codes and descriptions that will be used in the 824 response generated by PentaSAP for the PentaSAP Accounts Payable 810 Invoice.
04/22/2015 V/R 002040
1
FCA US
FCA US - PentaSAP Accounts Payable Invoice 08/06/2013: Header - Modified Miniumum size of N104 from 5 to 3 08/26/2013: Includes preliminary specifications for PentaSAP, Wave 2 09/06/2013: Detail - Updated the element usage description for the REF02, Packing Slip Number. 09/11/2013: Detail - Updated the element usage description for the IT109, Purchase Order Number. 10/10/2013: Appendix B - Added Error Code 264 10/15/2013: Header - Updated Currency Code Link in CUR02 10/23/2013: Header - Added Appendix C for International bill to location names and codes used in the N1 segment. 12/02/2013: Header - Removed all references to credit card billing. This invoice will not be used for credit card billing in PentaSAP. Header - Added descriptive text in the N1 segment for supplier and ship-to locations. 01/21/2014: Detail - Changed the minimum/maximum length of IT109 from 8/10 to 7/10. 02/05/2014: Detail - Updated explanation of IT107 giving more detail regarding Part Numbers. 12/15/2014: Updated Link in above notes section. 01/21/2015: Name Change To FCA US 04/22/2015: Updated Appendix A
Heading: Page No. 5 6 8
Pos. No. 010
Seg. ID ST
Base Guide M
Name Transaction Set Header
User Status M
Max.Use 1
020
BIG
Beginning Segment for Invoice
M
M
030
NTE
Note/Special Instruction
F
Not Used
100
040
CUR
Currency
O
Must Use
1
04/22/2015 V/R 002040
2
Loop Repeat
Notes and Comments
1
FCA US
FCA US - PentaSAP Accounts Payable Invoice 11
050
REF
Reference Numbers
O
12
060
PER
Administrative Communications Contact
O
Not Used
3
070
N1
Name
O
Must Use
1
080
N2
Additional Name Information
O
Not Used
2
LOOP ID - N1 12
14
200
090
N3
Address Information
O
Not Used
2
100
N4
Geographic Location
O
Not Used
1
110
REF
Reference Numbers
O
Not Used
12
120
PER
Administrative Communications Contact
O
Not Used
3
Not Used
130
ITD
Terms of Sale/Deferred Terms of Sale
O
140
DTM
Date/Time/Period
O
150
FOB
F.O.B. Related Instructions
O
160
PID
Product/Item Description
170
MEA
Measurements
5 10
Not Used
1
O
Not Used
200
O
Not Used
40
180
PWK
Paperwork
O
Not Used
25
190
PKG
Marking, Packaging, Loading
O
Not Used
25
200
L7
Tariff Reference
O
Not Used
1
Detail: Page No.
Pos. No.
Seg. ID
15
010
IT1
Baseline Item Data (Invoice)
O
020
CUR
Currency
O
Not Used
030
IT3
Additional Item Data
O
Not Used
5
040
TXI
Tax Information
O
Not Used
10
050
CTP
Pricing Information
O
Not Used
25
060
PID
Product/Item Description
O
Not Used
1000
070
MEA
Measurements
O
Not Used
40
080
PWK
Paperwork
O
Not Used
25
18
Base Guide
Name LOOP ID - IT1
User Status
Max.Use 1
090
PKG
Marking, Packaging, Loading
O
Not Used
25
100
PO4
Item Physical Details
O
Not Used
1
110
ITD
Terms of Sale/Deferred Terms of Sale
O
Not Used
2
120
REF
Reference Numbers
O
Must Use
999999
130
PER
Administrative Communications Contact
O
Not Used
5
140
SDQ
Destination Quantity
O
Not Used
500
150
DTM
Date/Time/Period
O
Not Used
10
160
CAD
Carrier Detail
O
Not Used
999999
170
L7
Tariff Reference
O
Not Used
999999
180
ITA
Allowance, Charge or Service
O
190
TXI
Tax Information
O
Not Used
10
200
SLN
Subline Item Detail
O
Not Used
1
10 1
LOOP ID - SLN
04/22/2015 V/R 002040
Notes and Comments
1
LOOP ID - ITA 19
Loop Repeat 200000
1000
3
FCA US
FCA US - PentaSAP Accounts Payable Invoice 210
REF
Reference Numbers
O
Not Used
999999
220
PID
Product/Item Description
O
Not Used
1000
230
ITA
Allowance, Charge or Service
O
Not Used
10
LOOP ID - N1
200
240
N1
Name
O
Not Used
1
250
N2
Additional Name Information
O
Not Used
2 2
260
N3
Address Information
O
Not Used
270
N4
Geographic Location
O
Not Used
1
280
REF
Reference Numbers
O
Not Used
12
290
PER
Administrative Communications Contact
O
Not Used
3
Summary: Page No. 21
Pos. No. 010
Seg. ID TDS
Name Total Monetary Value Summary
Base Guide M
User Status M
020
TXI
Tax Information
O
Not Used
10
030
CAD
Carrier Detail
O
Not Used
1
Max.Use 1
LOOP ID - ITA
Notes and Comments
10
040
ITA
Allowance, Charge or Service
O
Not Used
1
050
TXI
Tax Information
O
Not Used
10
060
ISS
Invoice Shipment Summary
O
Not Used
5
22
070
CTT
Transaction Totals
M
M
1
23
080
SE
Transaction Set Trailer
M
M
1
04/22/2015 V/R 002040
Loop Repeat
4
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes: Semantic Notes: Comments:
Notes:
Ref. Des. ST01
ST Transaction Set Header 010 Heading Mandatory 1 To indicate the start of a transaction set and to assign a control number
1
The transaction set identifier (ST01) is intended for use by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the invoice transaction set). The transaction set control number (ST02) in this header must match the transaction set control number (SE02) in the transaction set trailer (SE).
Data Element Summary Data Element Name 143 Transaction Set Identifier Code Code uniquely identifying a Transaction Set 810
ST02
329
Base Attributes M ID 3/3
User Attributes M
M AN 4/9
M
X12.2 Invoice
Transaction Set Control Number
Identifying control number assigned by the originator for a transaction set. A unique control number assigned to each transaction set within a functional group, starting with 0001 and incrementing by 1 for each subsequent transaction set. Same as SE02.
04/22/2015 V/R 002040
5
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes: Semantic Notes: Comments: Notes:
BIG Beginning Segment for Invoice 020 Heading Mandatory 1 To indicate the beginning of an invoice transaction set and transmit identifying numbers and dates
1 BIG07 is used only to further define the type of invoice when needed. The date and time are the local date and time at the creation point of the transaction set. Example: BIG~110331~23456789~~~~~DI Data Element Summary
Ref. Des. BIG01
Data Element Name 245 Invoice Date
Base Attributes M DT 6/6
User Attributes M
Invoice Issue Date. The date the invoice was created in 'YYMMDD' format. BIG02
76
Invoice Number Identifying number assigned by issuer
M AN 1/22
M
AN 1/15
A unique FCA US supplier assigned invoice number that is not repeated within a one year period. Although the standard allows for a 22 character number, FCA US will only use and store the first 15 characters. BIG03
323
Purchase Order Date
O DT 6/6
Not Used
BIG04
324
Purchase Order Number
O AN 1/22
Not Used
BIG05
328
Release Number
O AN 1/30
Not Used
BIG06
327
Change Order Sequence Number
O AN 1/8
Not Used
BIG07
640
Transaction Type Code
O ID 2/2
Must Use
Code specifying the type of transaction CR Credit Memo CR is to be used if the original invoice over charged for the goods or services. DI
Debit Invoice DI is to be used for the original invoice.
04/22/2015 V/R 002040
6
FCA US
FCA US - PentaSAP Accounts Payable Invoice DR
Debit Memo DR is to be used if the origninal invoice under charged for the goods or services.
04/22/2015 V/R 002040
7
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes:
Semantic Notes: Comments:
Notes:
04/22/2015 V/R 002040
CUR Currency 040 Heading Optional (Must Use) 1 To specify the currency (dollars, pounds, francs, etc.) used in a transaction 1 If CUR08 is present, then CUR07 is required. 2 If CUR09 is present, then CUR07 is required. 3 If CUR11 is present, then CUR10 is required. 4 If CUR12 is present, then CUR10 is required. 5 If CUR14 is present, then CUR13 is required. 6 If CUR15 is present, then CUR13 is required. 7 If CUR17 is present, then CUR16 is required. 8 If CUR18 is present, then CUR16 is required. 9 If CUR20 is present, then CUR19 is required. 10 If CUR21 is present, then CUR19 is required. 1
Monetary values are assumed to be expressed in thecurrency of the country of the transaction originatorunless the optional CUR segment is used to specify adifferent currency. The CUR segment also permits thetransaction originator to indicate a specific exchangerate, foreign exchange location and date/time as thebasis for a currency conversion. Example 1. Assuming thecurrency of the transaction originator is U.S. dollars,the following CUR segment, when used in the heading areaof a transaction, would indicate that all monetary valuesappearing in the transaction are expressed in CanadianDollars (CAD). (In this example the exchange rate is atthe discretion of the receiver). CUR*BY*CAD* N/L Example 2. Assuming the currency of the transactionoriginator is U.S. dollars, the following CUR segment,when used in the detail area of a transaction, describesa currency conversion for that particular item from U.S.dollars to Canadian dollars. It also indicates that aspecific exchange rate, at a specified foreign exchangelocation on a given date/time be used as the basis forthe currency conversion. Notes below the diagramdescribe the meaning of the element values. CUR*BY*USD*1.20*SE*CAD*NY*007* 840821*1400 N/L A B C D A. Identifies the buyer's (BY) currency as U.S. dollars(USD). B. The multiplier (1.20) is the exchange rate factor forthe conversion. C. Identifies the seller's (SE) currency as Canadiandollars (CAD). D. Indicates the basis for the exchange rate as the NewYork Foreign Exchange (NY) and the effective date/time(007) as August 21, 1984 (840821) at 2:00 P.M. (1400). The value for this item is to be converted to Canadiandollars (CAD) at the exchange rate of 1.20, based on theNew York Foreign Exchange (NY) at 2:00 P.M. (1400) onAugust 21, 1984. The actual unit price conversion forthe item would be: The unit price value 7.50 (U.S. dollars) multiplied bythe exchange rate (1.20) equals 9.00 Canadian dollars(7.50 X 1.20 = 9.00) CUR07 through CUR21 provide forfive (5) dates/times relating to the currency conversion,i.e., effective date, expiration date, etc. This segment is mandatory. Suppliers should submit invoices with appropriate currency code as defined by their purchase orders.
8
FCA US
FCA US - PentaSAP Accounts Payable Invoice Currency code MUST be provided for PentaSAP.
Ref. Des. CUR01
Data Element Summary Data Base Element Name Attributes 98 Entity Identifier Code M ID 2/2 Code identifying an organizational entity or a physical location. SU
CUR02
100
User Attributes M
Supplier/Manufacturer
Currency Code
M ID 3/3
M
Code (Standard ISO) for country in whose currency the charges are specified An appropriate currency code should be selected from the ISO 4217 currency and funds name and code elements. The currency code submitted will be editted to ensure that the proper currency code is being used. Note: The code list for this element is maintained by the International Organization for Standardization. Follow the link: http://www.currency-iso.org/dam/downloads/table_a1.xls Additional Note: As with any website, changes to the website are possible. The path that should be followed to obtain the ISO Recommendation is subject to change without notice and may not be represented in this documentation. This path is provided to assist the trading partner. CUR03
280
Exchange Rate
O R 4/6
Not Used
CUR04
98
Entity Identifier Code
O ID 2/2
Not Used
CUR05
100
Currency Code
O ID 3/3
Not Used
CUR06
669
Currency Market/Exchange Code
O ID 3/3
Not Used
CUR07
374
Date/Time Qualifier
C ID 3/3
Not Used
CUR08
373
Date
O DT 6/6
Not Used
CUR09
337
Time
O TM 4/4
Not Used
CUR10
374
Date/Time Qualifier
C ID 3/3
Not Used
CUR11
373
Date
O DT 6/6
Not Used
CUR12
337
Time
O TM 4/4
Not
04/22/2015 V/R 002040
9
FCA US
FCA US - PentaSAP Accounts Payable Invoice Used CUR13
374
Date/Time Qualifier
C ID 3/3
Not Used
CUR14
373
Date
O DT 6/6
Not Used
CUR15
337
Time
O TM 4/4
Not Used
CUR16
374
Date/Time Qualifier
C ID 3/3
Not Used
CUR17
373
Date
O DT 6/6
Not Used
CUR18
337
Time
O TM 4/4
Not Used
CUR19
374
Date/Time Qualifier
C ID 3/3
Not Used
CUR20
373
Date
O DT 6/6
Not Used
CUR21
337
Time
O TM 4/4
Not Used
04/22/2015 V/R 002040
10
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes: Semantic Notes: Comments: Notes:
REF Reference Numbers 050 Heading Optional 12 To specify identifying numbers.
Used for DTE Energy only. The plant number ('PE' - 4 positions), department number ('DP' - 10 positions) and FCA US internal account number ('CA' 10 positions) elements must be sent together as a set. Examples: REF~PE~2452 REF~CA~0054550001 REF~DP~0024520900
Ref. Des. REF01
Data Element Summary Data Element Name 128 Reference Number Qualifier Code qualifying the Reference Number. CA
Base Attributes M ID 2/2
User Attributes M
Cost Allocation Reference For DTE Energy only. FCA US Internal Account Number.
DP
Department Number For DTE Energy only.
PE
Plant Number For DTE Energy only.
REF02
127
Reference Number
M AN 1/30
M
AN 1/16
Reference number or identification number as defined for a particular Transaction Set, or as specified by the Reference Number Qualifier. Value as qualified by REF01. REF03
352
04/22/2015 V/R 002040
Description
O AN 1/80
11
Not Used
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes: Semantic Notes: Comments:
Notes:
N1 Name 070 N1 Optional (Must Use) Heading Optional (Must Use) 1 To identify a party by type of organization, name, and code 1 At least one of N102 or N103 is required. 2 If either N103 or N104 is present, then the other is required. 1
This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party. Up to three N1 segments are used at the heading level. For direct material, the data in the N1 segments must match the data on the Material Release (830). Use 'SU' for the FCA US assigned supplier code for which the Material Release was issued. Use 'ST' for the actual ship to location specified on the Material Release. For indirect material, the data in the N1 segments must match the data on the purchase order or release (850/860). Use 'SE' for the FCA US assigned supplier code from the purchase order or release. Use 'ST' for the actual ship to location specified on the purchase order or release. Examples: N1~SU~CARO GROUP~92~74724AB N1~ST~JEFFERSON NORTH ASSEMBLY PLANT~92~04012 N1~BT~MOPAR~92~3110 N1~BT~UNITED STATES~92~CAP N1~BT~CANADA~92~CCL N1~BT~MEXICO~92~CDM N1~ST~VENEZUELA~92~08068 N1~BT~UNITED STATES~92~04522
Ref. Des. N101
Data Element Summary Data Element Name 98 Entity Identifier Code
Base Attributes M ID 2/2
User Attributes M
Code identifying an organizational entity or a physical location. BT Party to be Billed For Other Than Freight(Bill To) There are two conditions to use this code: 1. Bill to is to be used when the ship to location is a MOPAR third party packager or consignee. 2. Bill to is to be used if the shipment is an international cross border shipment
04/22/2015 V/R 002040
12
FCA US
FCA US - PentaSAP Accounts Payable Invoice
N102
93
ST
Ship To
SU
Supplier/Manufacturer
Name
M AN 1/35
M
Free-form name If N101 = 'SU', the name of the supplier or manufacturer. If N101 = 'ST', the name of the ship to location. For MOPAR third party packager or consignee, use Appendix A for bill to location names. For shipments that cross an international border (originating internationally or from the U.S.), use Appendix C for bill to location names. N103
66
Identification Code Qualifier M ID 1/2 M ID 2/2 Code designating the system/method of code structure used for Identification Code (67) 92 Assigned by Buyer
N104
67
Identification Code Code identifying a party.
C ID 2/17
ID 3/7
If N101 = 'SU' and N103 = '92', use the FCA US assigned supplier code. If N101 = 'ST' and N103 = '92', use the FCA US assigned receiving plant code or the supplier code (third party packaging only) of the actual ship to location. If N101 = 'ST', N103 = '92', N103 = 'VENEZUELA' and N104 = '08068' use '04522' for the bill to location code. For MOPAR third party packager or consignee, use Appendix A for bill to location codes. For shipments that cross an international border (originating internationally or from the U.S.), use Appendix C for bill to location codes.
04/22/2015 V/R 002040
13
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes: Semantic Notes: Comments: Notes:
DTM Date/Time/Period 140 Heading Optional 10 To specify pertinent dates and times 1 At least one of DTM02 or DTM03 is required.
One DTM segment in the heading area is mandatory to provide shipment or service date. Use the date the shipment left the supplier's premises or the service was rendered. Example: DTM~011~110731
Ref. Des. DTM01
Data Element Summary Data Base Element Name Attributes 374 Date/Time Qualifier M ID 3/3 Code specifying type of date or time, or both date and time 011
User Attributes M
Shipped The date the shipment left the supplier's premises or the service was rendered.
DTM02
373
Date
M DT 6/6
M
Date (YYMMDD) DTM03
337
Time
C TM 4/4
Not Used
DTM04
623
Time Code
O ID 2/2
Not Used
04/22/2015 V/R 002040
14
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes:
Semantic Notes: Comments:
Notes:
IT1 Baseline Item Data (Invoice) 010 IT1 Optional Detail Optional 1 To specify the basic and most frequently used line item data for the invoice and related transactions 1 If IT106 is present, then IT107 is required. 2 If IT108 is present, then IT109 is required. 3 If IT110 is present, then IT111 is required. 4 If IT112 is present, then IT113 is required. 5 If IT114 is present, then IT115 is required. 6 If IT116 is present, then IT117 is required. 7 If IT118 is present, then IT119 is required. 8 If IT120 is present, then IT121 is required. 9 If IT122 is present, then IT123 is required. 10 If IT124 is present, then IT125 is required. 1
Element 235/234 combinations should be interpreted to include products and/or services. See the Data Dictionary for a complete list of ID's. 2 IT101 is the purchase order line item identification. 3 IT106 through IT125 provides for ten (10) different product/service ID's for each item. For example: Case, Color, Drawing No., UPC No., ISBN No., Model No., SKU. There should be one IT1 segment for each item shipped or service rendered. The IT1 segment is used to identify the buyer's part number and the Purchase Order number. PentaSAP has an invoice line item limit of 200 line items. Any invoices that would exceed that limit should be split into separate 810 invoices with no more than 200 line items each. Each successive invoice must have a different invoice number (BIG02). Invoice numbers should not be duplicated. Examples: IT1~00010~110~PC~10.35~~BP~450021234~PO~017782987 IT1~00020~100~GA~5.35~~BP~02128069~PO~017782985
Ref. Des. IT101
Data Element Summary Data Element Name 350 Assigned Identification
Base Attributes O AN 1/6
User Attributes Must Use
Alphanumeric characters assigned for differentiationwithin a transaction set. Line Item Number is the exact line item number from the purchase order or purchase order change. IT102
358
04/22/2015 V/R 002040
Quantity Invoiced
M R 1/10
15
M
FCA US
FCA US - PentaSAP Accounts Payable Invoice Number of units invoiced (supplier units) The quantity being invoiced with a maximum of 4 digits to the right of the decimal point. IT103
355
Unit or Basis for Measurement Code Code identifying the basic unit of measurement.
M ID 2/2
M
The quantity of measure (data element 355) as shown on the FCA US Purchase Order. IT104
212
Unit Price
M R 1/14
M
Price per unit of product, service, commodity, etc. The unit price with a maximum of 2 digits to the right of the decimal point. IT105
639
Basis of Unit Price Code
O ID 2/2
Not Used
IT106
235
Product/Service ID Qualifier O ID 2/2 Code identifying the type/source of the descriptive number used in Product/Service ID (234) BP Buyer's Part Number
IT107
234
Product/Service ID Identifying number for a product or service
C AN 1/30
AN 8/13
FCA US part number IS MANDATORY if provided on the FCA US Purchase Order. FCA US part number IS OPTIONAL if FCA US Purchase Order does not provide a part number. IT108
235
Product/Service ID Qualifier
O ID 2/2
Must Use
Code identifying the type/source of the descriptive number used in Product/Service ID (234) PO IT109
234
Purchase Order Number
Product/Service ID
C AN 1/30
Must AN 7/10 Use
Identifying number for a product or service This is the purchase order number for the line item and is mandatory. This value should be obtained from either the BEG03 in the 850 Purchase Order or from the BCH03 in the 860 Purchase Order Change. IT110
235
Product/Service ID Qualifier
O ID 2/2
Not Used
IT111
234
Product/Service ID
C AN 1/30
Not Used
IT112
235
Product/Service ID Qualifier
O ID 2/2
Not Used
IT113
234
Product/Service ID
C AN 1/30
Not Used
IT114
235
Product/Service ID Qualifier
O ID 2/2
Not
04/22/2015 V/R 002040
16
FCA US
FCA US - PentaSAP Accounts Payable Invoice Used IT115
234
Product/Service ID
C AN 1/30
Not Used
IT116
235
Product/Service ID Qualifier
O ID 2/2
Not Used
IT117
234
Product/Service ID
C AN 1/30
Not Used
IT118
235
Product/Service ID Qualifier
O ID 2/2
Not Used
IT119
234
Product/Service ID
C AN 1/30
Not Used
IT120
235
Product/Service ID Qualifier
O ID 2/2
Not Used
IT121
234
Product/Service ID
C AN 1/30
Not Used
IT122
235
Product/Service ID Qualifier
O ID 2/2
Not Used
IT123
234
Product/Service ID
C AN 1/30
Not Used
IT124
235
Product/Service ID Qualifier
O ID 2/2
Not Used
IT125
234
Product/Service ID
C AN 1/30
Not Used
04/22/2015 V/R 002040
17
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes: Semantic Notes: Comments: Notes:
REF Reference Numbers 120 IT1 Optional Detail Optional (Must Use) 999999 To specify identifying numbers.
One REF segment is transmitted to provide the packing slip number of the shipment for matching against the material received. Although the standard allows up to 30 characters in reference numbers, FCA US processes only the first 16. Sending more than 16 characters in reference numbers may result in invoices being rejected as duplicates if the first 16 characters match a previously used reference number. Example: REF~PK~87643521 Data Element Summary
Ref. Des. REF01
Data Element Name 128 Reference Number Qualifier Code qualifying the Reference Number. PK
REF02
127
Base Attributes M ID 2/2
User Attributes M
M AN 1/30
M
Packing List Number
Reference Number
AN 1/16
Reference number or identification number as defined for a particular Transaction Set, or as specified by the Reference Number Qualifier. Packing slip number (delivery note number) for the item. For material that was delivered, the packing slip number (delivery note number) should be entered. For services that were rendered, the purchase order number should be entered as the packing slip number (delivery note number). For Tooling Purchase order invoices, packing slip number (delivery note number) is made up of the purchase order number + the purchase order line item number as one concatenated string. REF03
352
04/22/2015 V/R 002040
Description
O AN 1/80
18
Not Used
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes:
Semantic Notes: Comments: Notes:
ITA Allowance, Charge or Service 180 ITA Optional Detail Optional 1 To specify allowances, charges, or services 1 If ITA02 is present, then at least one of ITA03 or ITA13 is required. 2 At least one of ITA06 ITA07 or ITA08 is required. 3 If ITA08 is present, then ITA09 is required. 4 If ITA10 is present, then ITA11 is required. 1 If ITA07 is present with either ITA06 or ITA08, then ITA07 takes precedence. 2 ITA12 is the quantity of free goods. To specify special charges. The Allowance or Charge Total Amount element (ITA07) is in the N2 format which calls for numeric data with 2 implied decimal points. If the charge or allowance is $100.00, the amount would be transmitted as '10000' (the decimal point is not transmitted). Examples: ITA~C~~~06~PKG~~54321 (Packaging Charge) ITA~C~~~06~GST~~62350 (Canadian - Goods and Service Tax) ITA~C~~~06~FRT~~3500 (Freight Cost)
Ref. Des. ITA01
Data Element Summary Data Base User Element Name Attributes Attributes 248 Allowance or Charge Indicator M ID 1/1 M Code which indicates an allowance or charge for the service specified C
Charge
ITA02
559
Agency Qualifier Code
O ID 2/2
Not Used
ITA03
560
Special Services Code
C ID 2/10
Not Used
ITA04
331
Allowance or Charge Method of Handling Code
M ID 2/2
M
Code indicating method of handling for an allowance or charge 06 Charge to be Paid by Customer ITA05
341
04/22/2015 V/R 002040
Allowance or Charge Number
Must AN 1/4 Use The number assigned by a vendor referencing an allowance, promotion, deal or charge ETX
Federal Excise Tax
EVT
European / Non - NAFTA VAT
FRT
Freight Cost
19
O AN 1/16
FCA US
FCA US - PentaSAP Accounts Payable Invoice FTF
Fuel Tax - Federal
FTS
Fuel Tax - State
GST
Canadian - Goods and Service Tax
HMT
Hazardous Material Tax
HST
Canadian - Harmonized Sales Tax
PKG
Packaging Charge
PST
Canadian - Provincial Sales Tax
QST
Canadian - Quebec SalesTax
STX
General Sales Tax - USA
V11
Mexico - 11% VAT
V16
Mexico - 16% VAT
ITA06
359
Allowance or Charge Rate
C R 1/9
Not Used
ITA07
360
Allowance or Charge Total Amount
M N2 1/9
M
Total dollar amount for the allowance or charge The total amount of the charges or allowances that pertain to this line item. ITA08
378
Allowance/Charge Percent Qualifier
C ID 1/1
Not Used
ITA09
332
Allowance or Charge Percent
C R 1/6
Not Used
ITA10
339
Allowance or Charge Quantity
O R 1/10
Not Used
ITA11
355
Unit or Basis for Measurement Code
C ID 2/2
Not Used
ITA12
380
Quantity
O R 1/10
Not Used
ITA13
352
Description
C AN 1/80
Not Used
ITA14
150
Special Charge or Allowance Code
O ID 3/3
Not Used
04/22/2015 V/R 002040
20
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes: Semantic Notes: Comments: Notes:
TDS Total Monetary Value Summary 010 Summary Mandatory 1 To specify the total invoice discounts and amounts
1
TDS02 is required if the dollar value subject to discount is not equal to the dollar value of TDS01. To specify the total monetary value of the included invoices. The Total Invoice Amount element (TDS01) is in the N2 format which calls for numeric data with 2 implied decimal points. If the total amount is $100.00, the amount would be transmitted as '10000' (the decimal point is not transmitted). Example: TDS~347850 Data Element Summary
Ref. Des. TDS01
Data Element Name 361 Total Invoice Amount
Base Attributes M N2 1/10
User Attributes M
Amount of invoice (including charges, less allowances) before terms discount (if discount is applicable) The sum of all the extended prices and allowances and charges (see Notes, above). TDS02
390
Amount Subject to Terms Discount
C N2 1/10
Not Used
TDS03
391
Discounted Amount Due
O N2 1/10
Not Used
TDS04
362
Terms Discount Amount
O N2 1/10
Not Used
04/22/2015 V/R 002040
21
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes: Semantic Notes: Comments: Notes:
CTT Transaction Totals 070 Summary Mandatory 1 To transmit a hash total for a specific element in the transaction set 1 If CTT03 is present, then CTT04 is required. 2 If CTT05 is present, then CTT06 is required. 1
This segment is intended to provide hash totals to validate transaction completeness and correctness. Used to provide the total number of IT1 segments used in the invoice transmitted. This total is used to cross check that the complete transaction set was received. Example: CTT~4
Ref. Des. CTT01
Data Element Summary Data Element Name 354 Number of Line Items
Base Attributes M N0 1/6
User Attributes M
Total number of line items in the transaction set Total number of IT1 segments included in this transaction set. CTT02
347
Hash Total
O R 1/10
Not Used
CTT03
81
Weight
O R 1/8
Not Used
CTT04
355
Unit or Basis for Measurement Code
C ID 2/2
Not Used
CTT05
183
Volume
O R 1/8
Not Used
CTT06
355
Unit or Basis for Measurement Code
C ID 2/2
Not Used
CTT07
352
Description
O AN 1/80
Not Used
04/22/2015 V/R 002040
22
FCA US
FCA US - PentaSAP Accounts Payable Invoice Segment: Position: Loop: Level: Usage: Max Use: Purpose: Syntax Notes: Semantic Notes: Comments: Notes:
SE Transaction Set Trailer 080 Summary Mandatory 1 To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments).
1 SE is the last segment of each transaction set. The transaction set control number value (SE02) in this trailer must match the same element value in the transaction set header (ST02). Data Element Summary
Ref. Des. SE01
Data Element Name 96 Number of Included Segments
Base Attributes M N0 1/6
User Attributes M
Total number of segments included in a transaction set including ST and SE segments SE02
329
Transaction Set Control Number M AN 4/9 M Identifying control number assigned by the originator for a transaction set. Same as 'ST02'
04/22/2015 V/R 002040
23
FCA US
FCA US – PentaSAP Accounts Payable Invoice Example 1:
Invoice
EDI Format
Interpretation
ST~810~0010
Transaction Set Identifier Code = “810” (X12.2 Invoice) Transaction Set Control Number = 0010
BIG~110331~23456789~~~~~DI
Invoice Date = 03/31/11 Invoice Number = 23456789 Transaction Type Code = “DI” (Debit Invoice)
N1~SU~CARO GROUP~92~74724AB
Entity Identifier Code = “SU” (Supplier/Manufacturer) Name = CARO GROUP Identification Code Qualifier = “92” (Assigned by Buyer or Buyer's Agent) Identification Code = 74724AB
N1~ST~STERLING HEIGHTS ASSEMBLY PLANT~92~04025 Entity Identifier Code = “ST” (Ship To) Name = STERLING HEIGHTS ASSEMBLY PLANT Identification Code Qualifier = “92” (Assigned by Buyer or Buyer's Agent) Identification Code = 04025 DTM~011~110331
Date/Time Qualifier = “011” (Shipped) Date = 03/31/11
IT1~00010~150~PC~8.35~~BP~459761502~PO~017782955 Assigned Identification = 00010 Quantity Invoiced = 150 Unit or Basis for Measurement Code = PC Unit Price = 8.35 Product/Service ID Qualifier = “BP” (Buyer's Part Number) Product/Service ID = 459761502 Product/Service ID Qualifier = “PO” (Purchase Order Number) Product/Service ID = 017782955 REF~PK~34911
Reference Number Qualifier = “PK” (Packing List Number) Reference Number = 34911
ITA~C~~~06~PKG~~5000
Allowance or Charge Indicator = "C" (Charge) Allowance or Charge Method of Handling Code = "06" (Charge to be Paid by Customer) Allowance or Charge Number = “PKG” (Packaging Charge) Allowance or Charge Total Amount = 50.00
04/22/2015 V/R 002040
24
FCA US
FCA US – PentaSAP Accounts Payable Invoice Example 1:
Invoice (continued)
EDI Format
Interpretation
IT1~00020~100~EA~5.85~~BP~459763445~PO~017782987 Assigned Identification = 00020 Quantity Invoiced = 100 Unit or Basis for Measurement Code = EA Unit Price = 5.85 Product/Service ID Qualifier = “BP” (Buyer's Part Number) Product/Service ID = 459763445 Product/Service ID Qualifier = “PO” (Purchase Order Number) Product/Service ID = 017782987 REF~PK~34911
Reference Number Qualifier = “PK” (Packing List Number) Reference Number = 34911
ITA~C~~~06~FRT~~3500
Allowance or Charge Indicator = "C" (Charge) Allowance or Charge Method of Handling Code = "06" (Charge to be Paid by Customer) Allowance or Charge Number = “FRT” (Freight Cost) Allowance or Charge Total Amount = 35.00
TDS~192250
Total Invoice Amount = 1922.50
CTT~2
Number of Line Items = 2
SE~15~0010
Number of Included Segments = 15 Transaction Set Control Number = 0010
04/22/2015 V/R 002040
25
FCA US
FCA US – PentaSAP Accounts Payable Invoice Appendix A:
MOPAR Bill To Locations
Bill to Locations for Third Party Packagers:
Ship to Name
Ship to Location
Bill to Location
Kenosha
40988
3164
Ryan & Sons
60989
3167
Howard Ternes
90990
3169
Venchurs
60438
3183
Bill to Locations for Consignees:
Ship to name
Ship to Location
Bill to Location
HOLLINGSWORTH – CONSIGNM H&J CONSULT SVC-DERUST & TDM ADDED 4-29-1 EXEL INC JEFFORD BUCKLEY ATP VERSA-TECH REMOVED 4/28/2006 BOSCH BRKG WOODSPECS AISIN WORLD CORP OF AMERICA RYAN & SON ELECTRO PRIME ALMA MARTINREA INTERNATIONAL INC TEBO S.A. MICH BRAKE DIV HIGH TECH PACKAGING QUALITY METALCRAFT INC 2/06/ A-1 RECYCLING FOURSLIDES INC FOX MANUFACTURING 05/0 FLIGHT SYSTEMS TERNES BUY & HOLD NON-CO GERSTENSLAGER. CANNOT USE D MACHINING CENTER MITSUBISHI ARROW RACING ENGINES M AARON'S PARKER HANNIFEN MEXICO PRODUCTION TOOL CORP ALLIANCE
10443 10615 11116 15716 17332 18705 18898 19183 19479 20056 20551 20993 23436 24366 24902 25755 31592 32223 34746 38340 38347 39842 41885 42232 43046 43195 43198 43677 45613 46281 50012
3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124 3124
04/22/2015 V/R 002040
26
FCA US
FCA US – PentaSAP Accounts Payable Invoice Appendix A:
MOPAR Bill To Locations (continued)
Ship to name
Ship to Location
Bill to Location
WILLIAMS TECHNOLOGIES INC
50307
3124
CUMMINS MEXICO
51946
3124
INSITE INDUSTRIES
52675
3124
J & L MFG. WAS DIV.6
53372
3124
JATCO
53584
3124
DETROIT DIESEL REMANUFACTURI
54225
3124
OLD MMC PER ZLATKO 3-3-2
54547
3124
PGS PER ALONZO BR
54917
3124
KSI MACHINE & ENGINEERING BDE4
56877
3124
PUTCO FAB & HOLD GRILLE PROGRAM
57086
3124
AG MFG PER JENNEFER MOOR
57425
3124
VENCHURS
57606
3124
TRW AUTOMOTIVE ELECTRONIC PRODU
58024
3124
KUKA PER DARIN POTANAC 1-13-11
58203
3124
BLUMENTHAL MANUFACTURING CO.
58805
3124
SYNCREON – MEMPHIS
60967
3124
P2K2 COMPONENTS LLC ADDED PE
61674
3124
CENTRUM SWITCHED FROM SMART
61675
3124
MANCINI RACING
61983
3124
AUTO BUILDERS INC ADDED 2/4/2
62090
3124
REMY AUTOMOTIVE
62228
3124
DMAC IND. PER ZLATKO T.
62437
3124
ATC DRIVETRAIN ADDED P
62467
3124
AER MANUFACTURING
62803
3124
UBD
62983
3124
TEAMEC MOVE FROM AA28 T
62984
3124
KARRER & BATH PER ZLATK
63425
3124
TRW AUTOMOTIVE
64303
3124
TURBO TECHNICS LIMITED PER ZLA
64583
3124
RYAN INDUSTRIES PER A
64671
3124
DYNAMIC MFG
65819
3124
MELLING
66147
3124
OAKLEY INDUSTRY 87786 PRIOR C
71198
3124
DIESEL RECON REMAN A
77708
3124
KENOSHA ACHIEVMENT
80995
3124
DELPHI
82042
3124
NEW CENTER STAMPING
85150
3124
TERNES, HOWARD PACKAGING
90110
3124
KUKA ALTERNATE SHIP TO TOLEDO
58203A
3124
04/22/2015 V/R 002040
27
FCA US
FCA US – PentaSAP Accounts Payable Invoice Appendix B:
Error Codes and description used in the 824 Response
EDI Error Code (TED01) 185 187 189 190 212 261 263 264 606 676 709 813 816 854 874 883
04/22/2015 V/R 002040
EDI Error Message (NTE02) MISSING OR INVALID TRAN TYPE CODE MISSING CURRENCY CODE IT1 MISSING PURCHASE ORDER NUMBER IT1 INVALID PURCHASE ORDER NUMBER INVALID SHIP-TO LOCATION MISSING SHIP TO LOCATION MISSING PART NUMBER MISSING PACKING SLIP NUMBER INVALID PART NUMBER ENCOUNTERED SUPPLIER CODE MISSING OR INVALID INVALID UNIT OF MEASURE UNIT PRICE IS MISSING IT1 QUANTITY IS ZERO INVALID CURRENCY CODE INVALID CHARGE TO/BILL TO BILL TO CODE CANNOT BE BLANK
28
FCA US
FCA US – PentaSAP Accounts Payable Invoice Appendix C:
International Cross Border Shipments
Ship to Name (Ship to Name in United States) (Ship to Name In Mexico) (Ship to Name in Canada) VENEZUELA
04/22/2015 V/R 002040
Ship to Location
Bill to Name
Bill to Location
(Ship to Location Code in United States) (Ship to Location Code in Mexico) (Ship to Location Code in Canada) 08068
UNITED STATES
CAP
UNITED STATES
CAP
CANADA
CCL
UNITED STATES
04522
29
FCA US