EDI Introduction by yjg19349

VIEWS: 48 PAGES: 16

									EDI Implementation Guide

Welcome to A & A Contract Customs Brokers Ltd. Electronic Data Interchange (EDI) Implementation Guide.

While this is a technical document in nature, we want to go over the benefits to both of our companies for using EDI in the Customs Environment.

EDI Benefits

Shipments will clear through Customs faster because all data will have been transmitted electronically ahead of time.
Missing invoice issues are no longer an issue. Often we do not get all paper invoices from the carrier causing delay in Customs release.
The need for re-keying information is eliminated. Under Customs Administrative Monetary Penalty System, inaccurate information can result in a fine
to the importer.
We can provide you’re A&A invoice for charges related to the shipment, electronically allowing you to get your costing faster.

Those are just some of the key benefits to using EDI.

Keep in mind, we can accept your invoice data in many different formats - Flat File, Text, XML, whichever it may be - we will accept it.

Thank-you.

Click on tabs at the bottom of this screen for the following information -

Introduction to EDI
Information A&A Contact Technical Information
4010.810 Implementation Guide
Flat File Introduction
Flat File Specifications
Flat File Other
XML Invoice
XML Acknowledgement
A&A Contract Customs Brokers Ltd.                             004010.810 EDI Implementation Guide


A&A Contract Customs Brokers Ltd.
Information Technology Team

Contact:                            Richard Leong
                                    Phone (604) 542-7253
                                    Fax (604) 538-3994
                                    Email: rleong@aacb.com

Requirements:                       Standard                 ANSI X12
                                    Version                  4010
                                    Transaction Set          810 (Invoice)


Our EDI Information:                EDI Network:             AT&T
                                    EDI ID                   aanda4
                                    EDI ID Qualifer          zz



Your Company EDI Information:       Your EDI Network →
                                    Your EDI ID →
                                    Your EDI ID Qualifer →




Prepared by Jim Leong
 A&A Contract Customs Brokers Ltd.                                  810 Invoice                                         EDI Implementation Guide
                                                                           .

                         Data Element Summary                     ANSI Field Attributes
Segment    Segment       Data      ANSI Field Name          Req            Type     Length   Field Contents               Notes or Comments
                         Element
                                                            Mandatory
                                                            Conditional
                                                            Optional

Level: Header

BIG        Invoice / Purchase No
1020       BIG01              373 Invoice Date              M              DT       08/08    CCYYMMDD
           BIG02               76 Invoice Number            M              AN       01/20    Inv # Assigned by Sender
           BIG04              324 PO Number                 M              AN       01/20    Purchase Order No.


CUR        Currency
1040       CUR01               98 Identifer Code            M              ID       02/02    BT =Bill To Party
           CUR02              100 Currency Code             M              A2       03/03    Currency Code ie/ USD


REF        Reference Identification
1050       RFF01              128 Reference ID Qualifer     M              ID       02/03    GT = GST Reg. No        IL
                                                                                             = Sales Order No
           RFF03              352 Description               C              AN       01/20    GST No / Sales Order No


N1         Name
1070       N101                98 Identifer Code            M              ID       02/03    SF = Shipped From BT = Provide Ship From.       Send
                                                                                             Billed To       ST =   To required if not same as Bill
                                                                                             Send To                To.
           N102                93 Name                      C              AN       01/35                           Store Number Not Required


N3         Street
1090       N301               166 Address Information       M              AN       01/35    Street Address
           N302               166 Address Information - 2   O              AN       01/35    Street Address               2nd Address Line




 Prepared By Jim Leong                                                 801.004010                                                         Page 3 of 16
 A&A Contract Customs Brokers Ltd.                                 810 Invoice                                      EDI Implementation Guide
                                                                         .

                         Data Element Summary                    ANSI Field Attributes
Segment    Segment       Data      ANSI Field Name         Req          Type    Length   Field Contents                 Notes or Comments
                         Element




N4         City, State, Zip Code, Country
1100       N401                19 City Name                M            AN      01/20    City Name
           N402               156 State or Province Code   C            ID      02/02    2 Char State Code
           N403               116 Postal Code              C            AN      04/09    Zip Code
           N404                26 Country                  C            ID      02/03    Country Code


ITD        Terms of Payment / Conditions of Sales
1130       ITD01              336 Terms Type Code          O            ID      02/02    01 = Terms of Payment ZZ
                                                                                         = Conditions of Sale
           ITD12              352 Description              C            AN      01/35    Description of Terms or        ie/ 0.00/0/60
                                                                                         Condition of Sale              Brokerage & Duty Included


DTM        Shipped Date
1140       DTM01              374 Date/Time Qualifier      M            ID      03/03    011 - Date Shipped
           DTM02              373 Date                     C            DT      08/08    CCYYMMDD


FOB        F.O.B. Related Instructions
1150       FOB01              146 Shipment Method of       C            AN      02/02    PS = Paid by Seller       BP
                                  Payment                                                = Paid by Buyer
           FOB02                  Location Qualifer        O            AN      01/02    ZZ = Mutually Defined
           FOB03                   Description             O            AN      01/35    FOB Description


Level : Detail

IT1        Item Amounts
2010       IT102              358 Quantity Invoiced        M            R       01/10    Item Quantity



 Prepared By Jim Leong                                             801.004010                                                           Page 4 of 16
 A&A Contract Customs Brokers Ltd.                                810 Invoice                                       EDI Implementation Guide
                                                                        .

                         Data Element Summary                   ANSI Field Attributes
Segment    Segment       Data      ANSI Field Name        Req          Type    Length   Field Contents               Notes or Comments
                         Element
           IT103              355 Unit of Measure Code    M            ID      03/03    Unit of Measure Code
           IT104              212 Unit Price              M            R       01/14    Unit Price
           IT106              235 Product Qualifier       M            ID      02/02    VA - Vendor Qualifer
           IT107              234 Product ID              M            AN      01/18    Vendor Assigned


PID        Item Amounts
2060       PID01              349 Item Description Type   M            ID      01/01    F - Free Form Description
           PID05              352 Item Description        C            AN      01/25    Item Description


N1         Country of Origin
2240       N101                98 Identifer Code          M            ID      02/03    CT = Country of Origin
           N102                93 Name                    C            AN      02/03    US = United States           Any 2 digit International
                                                                                        CN = China             TW    Country Code.
                                                                                        = Taiwan


Level: Summary

TDS        Invoice Total
3010       TDS01              361 Total Invoice Amount    M            N2      01/15    Total Invoice Amount         Decimal is Implied


TXI        Tax Information
3020       TXI01              963 Tax Type Code           M            ID      02/02    GS = GST
           TXI02              782 Tax Amount              C            R       01/18                                 * Include Decimals


CAD        Delivery Information
3030       CAD04              140 Carrier Code            O            ID      02/04                                 Code
           CAD05              387 Carrier Name            C            AN      01/35                                 Name of Carrier
           CAD07              128 Reference ID Qualifer   O            ID      02/03    BM = Bill Lading No



 Prepared By Jim Leong                                            801.004010                                                           Page 5 of 16
 A&A Contract Customs Brokers Ltd.                                   810 Invoice                                          EDI Implementation Guide
                                                                           .

                         Data Element Summary                      ANSI Field Attributes
Segment    Segment       Data      ANSI Field Name           Req          Type    Length   Field Contents                  Notes or Comments
                         Element
           CAD08              127 Reference Identification   O            AN      36190                                    Bill of Lading No




SAC        Service, Promotion, Allowance Charges
3040       SAC01              248 Allowance/Charge Indicator M            ID      01/01    C = Charge             A=
                                                                                           Allowance
           SAC02             1300 Special Charge Code        C            AN      ID       D240 = Freight
                                                                                           C000= Defective Allowance
                                                                                           I170 = Trade (edi) Discount

           SAC05              610 Total Amount               O            N2      01/09    Freight Allowance               * decimal is implied
           SAC12              331 Chg Mthd Hdling Code       M            ID      02/02    06 = Paid by Customer     02
                                                                                           = Off Invoice

ISS        Shipping Information
3060       ISS01              382 Number of Units Shipped    C            R       01/10    Item Quantity
           ISS02              355 Unit of Measure Code       C            AN      02/02    BX = Box             PK =
                                                                                           Package          PF = Pallet

           ISS03               81 Weight                     C            R       01/10    Item Quantity
           ISS04              355 Unit of Measure Code       C            ID      03/03    LB - Pounds             OZ -
                                                                                           Ounces

CTT        No. of Line Items
3070       CTT01              354 No. of Line Items          M            N0      01/06    Total Number of IT1
                                                                                           Segments




 Prepared By Jim Leong                                               801.004010                                                                Page 6 of 16
Flat File Electronic Invoice

  We now have have an alternative way for you to transmit your commerical invoices electronically to A&A Contract Customs B
using the Ansi X12 standard. You can now send us your data in a flat file by FTP. You no longer have to send us you electron
the use of expensive translator software and the high costs of VANS.


  Once we receive this electronic data from you it wil be automatically imported into our import process. There will be no need
this information manually into our system which ensures data integrity. We will be able to process your shipments for Customs
accounting in a more efficent manner. When you are ready to test, we will provice you with a FTP site for you to transmit your d


Message Structure

Record identifer     Description                Function

IDHR                 Header Record              File Header to identify Parnter.

IIHR                 Invoice Header Record      Invoice Header - repeat for each invoice

INAD                 Name Address Record        Bill to, Send to and Sent from firm information - repeat for each
:
INAD

IOIC                 Other Invoice Info         Condition of Sale, Terms of Payment & FOB

IIDA                 Detail Items Info          Detailed Invoice information
:
IIDA

IITR                 Invoice Totals             Invoice, Gst and Freight Amounts - repeat for each invoice

ISIR                 Shipping Information       Carrier and Shipment Info
A&A Contract Customs Brokers other than
e to send us you electronic formation with



s. There will be no need for us to re-enter
ur shipments for Customs clearance and
e for you to transmit your data to.




                        Repeat to 3 times

                                              Repeat for
                                              Each Invoice


                        Repead for each
                        Invoice item
                                               Field  Field
Field                                Required Length Length Delimeter                  Data
Name                                   Field   Min    Max   Position Expected Data    Format

Header Record
                 Record _Identifer      M       4       4        1         IHDR         ID
                 Generation Date        M       8       8        2                      DT
                      Partner_ID        M       3      10        3        Your Id       ID


                        Example:             IHDR~20040301~AAA


Invoice Header Record
                 Record_Identifer       M       4       4        1         IIHR         ID
                 Invoice_Number         M       1      20        2                      AN
                    Invoice_Date        M       8       8        3                      DT
                     PO_Number          O       1      20        4                      AN
            Sales_Order_Number          O       1      20        5                      AN
                   Shipped_Date         M       8       8        6                      DT
                Invoice_Currency        M       3       3        7       USD,CAD        ID


                       Example:              IIHR~10001~20040301~PO1701~~20040301~USD


Name Address Record (loop up to 3 times)
                Record_Identifer     M          4       4        1         INAD         ID
                  Identifer_Code     M          2       2        2       SF,BT,ST       ID
                           Name      M          1      35        3                      AN
                      Address_1      M          1      35        4                      AN
                      Address_2      O          1      35        5                      AN
                             City    M          1      20        6                       A
                            State    M          2       2        7                      ID
              Zip or Postal Code     M          4       9        8                      AN
                          Country    M          2       3        9                      ID


                       Example:              INAR~SF~ABC Widget Co~123 Main St~~Blaine~WA~98002~US
                                             INAR~BT~TCS Company~120 - 176th Street~Suite 101~Surrey~BC~V3S2


Other Invoice and Conditions Record
                  Record_Identifer      M       4       4        1         IOIC         ID
                Conditions of Sale      O       1      35        2                      AN
                Terms of Payment        O       1      35        3                      AN
                 FOB_Instructions       O       1      35        4                      AN


                       Example:              IOIC~Brokerage & Duty Included~2% 15 Days net 30~PPD/Dest
Item Detail and Amounts Record
                   Record_Identifer   M      4       4       1        IIDA
                 Quantity_Invoiced    M      1      10       2
            Unit_of_Measure_Code      M      3       3       3
                         Unit_Price   M      1      14       4
                  Discount_Percent    C      1       8       5
                        Product_Id    M      1      18       6
                   Item_Description   M      1      35       7

                 Country_of_Origin    M      2       3        8
                           Weight     O      1      10        9
                 Unit_Of_Measure      O      2       2       10


                        Example:          IIDA~500~PKG~2.50~WDJ-123~Widgets~UAZ~3~LB


Invoice Totals Record
                   Record_Identifer   M      4       4       1        IITR
             Total_Invoice_Amount     M      1      14       2
                  Total_Line_Items    M      1       6       3
                      GST_Amount      C      1      14       4
                   Freight_Amount     C      1      14       5
                 Discount_Amount      C      1      14       6

                        Example:          IITR~1300.00~1~~50.00


Shipping Information Record
                  Record_Identifer    O      4       4        1       ISIR        ID
                     Carrier_Code     O      2       4        2                   AN
                    Carrier_Name      O      1      35        3                   AN
              Bill_Lading_Number      O      1      20        4                   AN
           Cargo_Control_Number       O      1      20        5                   ID
                Tracking_Number       O      1      20        6                   AN
        Number_of_Units_Shipped       O      1      10        7                   N
           Unit_of_Measure_Code       O      2       2        8                   ID
                           Weight     O      1      10        9                   N
           Unit_of_Measure_Code       O      2       3       10                   ID


                        Example:          ISIR~FDX~Fedex Express~1234567890~~~2~BX~100~LB
           Description


           IHDR = Header
           Date Edi Created
           Predefined ID provided by A&A




           IIHR = Invoice Header
           Invoice Number
           Invoice Date
           Purchase Order Number
           Sales Order Number
           Ship Date
           USD = US Dollars / CAD = Canadian Dollars


~USD




           INAD = Name & Address Info
           Provide Ship From and Bill To. Send To required if different from Bill To
           Name
           Address
           Additional Address
           City
           State / Province
           Postal Code
           US = United States / CA = Canada


aine~WA~98002~US
~Suite 101~Surrey~BC~V3S2S9~CA



           IOIC = Header
           Condition of Sale
           Terms of Payment
           FOB Instructins


ys net 30~PPD/Dest
          IIDA = Header
          Item Quantity
          PKG = Package / NMB = Number
          Price per unit
          Item Percent Discount
          Vendor Product Number
          Description of Product

          Country or State of Origin UCA = California / UWA = Washington / MX = Mexico
          Weight of item
          LB = Pounds / KG = Kilograms


AZ~3~LB



          IITR = Header
          Total Invoice Amount
          Total number of detail items
          GST Charged (NRI Clients)
          Freight Amount
          Trade Discount




          ISIR = Header
          FDX = "Fedex Express" UPS = "United Parcel Service:
          Name of Carrier
          Bill Lading No
          Cargo Control No
          Tracking No
          Item Quantity shipped
          BX = Box / PK = Package / PF = Pallet
          Item Weight
          LB = Pounds / KG = Kilograms / OZ = Ounces


~BX~100~LB
Other Specifications
 Field Delimeter       "~" or Acii Character 126
 Record Delimiter      CrLf or Character 13 & 10


Required Field         M = Mandatory
                       O = Optional
                       C = Conditional


Data Format            ID = Standard or Assigned Code
                       DT = Date format
                       A = Alphanumeric
                       N = Numeric
                       AN = AlphaNumeric
       A&A Contract Customs Brokers Ltd.                                        XML Invoice                                                    EDI Implementation Guide

                                                       Mandatory /
                                                       Conditional /   Data       Length
Field Name                     Tag Name                Optional        Type       Min/Max     Format / Description
Header Information
XML Version                                            M               String     n/a         "1.0"
XML Coding                                             M               String     n/a         "UTF-8"

Partner_Information
Partner Identifer              <Partner_Id>            M               String     1/10        Customer Client Code, Assigned by A&A.
Partner Reference              <Partner_Reference>     O               String     1/10        Sender Reference or Control Number

Invoice Application
                                                                                              One or permt invoice may be submitted in a single file. An < Invoice> tag must
Invoice Tag                    <Invoice>               M                                      preceed each invoice application.

Invoice Header
Invoice No                     <Invoice_No>            M               String     1/20        Invoice No assigned by Vendor
Invoice Date                   <Invoice_Date>          M               Date       8/8         CCYYMMDD
Purchase Order No              <Po_No>                 M               String     1/20        Purchase Order assigned by Purchaser
Sales Order No                 <Sales_Order_No>        O               String     1/20        Vendor Sales Order No
Shipped Date                   <Ship_Date>             M               Date                   CCYYMMDD
Currency                       <Currency>              M               String     3/3         Currency Code ( USD - US Dollars, CAD = Canadian Dollars)
Gst Registration No            <Gst_No>                C               String     9/15        Gst #, mandatory for Non Resident Importers


Vendor Consignee
Information
Vendor Name                    <Vendor_Name>           M               String     1/35        Seller / Vendor Information
Vendor Address 1               <Vendor_Address1>       M               String     1/35
Vendor Address 2               <Vendor_Address2>       O               String     1/35
Vendor City                    <Vendor_City>           M               String     1/20
Vendor State                   <Vendor_State>          M               String     2/2
Vendor Country                 <Vendor_Country>        M               String     2/2         Country Code. US = United States, CA = Canada
Vendor Zip Code                <Vendor_Zip>            M               String     5/9
Consignee Name                 <Consignee Name>        M               String     1/35        Ship to / Consignee Information
Consignee Address 1            <Consignee_Address_1>   M               String     1/35
Consignee Address 2            <Consignee_Address_2>   O               String     1/35
Consignee City                 <Consignee_City>        M               String     1/20
Consignee State                <Consignee_State>       M               String     2/2
Consigneer Country             <Consignee_Country>     M               String     2/2         Country Code. US = United States, CA = Canada
Consignee Zip Code             <Consignee_Zip_Code>    M               String     5/9




       Prepared by Jim Leong                                                                                                                                Page 14 of 16
       A&A Contract Customs Brokers Ltd.                                            XML Invoice                                                     EDI Implementation Guide

                                                          Mandatory /
                                                          Conditional /   Data        Length
Field Name                     Tag Name                   Optional        Type        Min/Max     Format / Description
Other Invoice Information
Terms of Payment               <Terms_Payment>            O               String      1/35        Terms of Payment
Condition of Sale              <Condition_Sale>           O               Strng       1/35        Condition of Sale - NRI's to specify if Brokerage/Duty included.
F.O.B. Instructins             <Fob_Instructions>         O               String      1/35        FOB Instructions


Invoice Details                                                                                   Header for Invoice Detail Items
Invoice Details                <Invoice_Details>          M                                       <Invoice_Detail> tag to start Invoice Details
                                                                                                  There must be one or more invoice detail items. A <Item> tag must precede
Item                           <Item>                     M                                       each product invoiced..
Product No                     <Product_No>               M               String      1/20        Vendor Product Number of Item
Part Description               <Product_Description>      M               String      1/35        Product Description
Part Quantity                  <Product_Qty>              M               Integer     1/10        include decimal if nay
Part Unit Measure              <Product_Qty_Uom>          M               String      3/3         Unit Measure Code. PKG = Package, NMB = Number
Part Unit Price                <Product_Unit_Price>       M               Dollar      1/14        Include decimal
Part Country Origin            <Product_Country_Origin>   M               String      2/3         Any 2 digit international Code. US = United States, CN = China
Part Weight                    <Product_Weight>           M               Integer     1/10        Net Weight per Unit
Part Weight Unit Measure       <Product_Weight_Uom>       M               String      2/2         Weight Unit Measure Code. LB - Pounds KG = Kilograms Oz = Ounces


Invoice Summary                                                                                   Totals, Taxes, Freight & Allowances - Include decimal
Total Invoice Amount           <Total_Invoice_Amt>        M               Integer     1/15        Total Invoice amount
Gst Charged                    <Gst_Amt>                  C               Integer     1/14        Gst Amount
Freight Charged                <Freight_Amt>              C               Integer     1/14        Freight Amount
Trade Discount                 <Trade_Discount>           C               Integer     1/14        Trade Discount
Defective Allowance            <Defective_Allowance>      C               Integer     1/14        Defective Allowance
Freight Allowance              <Freight_Allowance>        C               Integer     1/14        Freight Amount


Delivery & Shipping
Information                                                                                       Shipping information
Carrier Code                   <Carrier_Code>             O               String      2/4
Carrier Name                   <Carrier_Name>             O               String      1/35
Bill Lading Number             <Bill_Lading_No>           O               String      1/35
Tracking Number                <Tracking_No>              O               String      1/35
Number Units Shipped           <Ship_Units>               O               Integer     1/10
Shipped Units of Measure       <Ship_Units_Uom>           O               String      2/2         PK = Package, BX= Box, PF = Pallet
Shipped Weight                 <Ship_Weight>              O               Integer     1/10
Shipped Unit of Measure        <Ship_Weight_Uom>          O               String      2/2         LB = Pounds, KG = Kilograms



       Prepared by Jim Leong                                                                                                                                         Page 15 of 16
        A&A Contract Customs Brokers Ltd.                            XML Acknowledgement                                                Edi Implementation Guide



                                                        Mandatory /
                                                        Conditional / Data     Length
Field Name                 Tag Name                     Optional      Type     Min/Max Format / Description
Header Information
XML Version                                             M            String    n/a      "1.0"
XML Coding                                              M            String    n/a      "UTF-8"



Partner_Information
Partner Identifer          <Partner_Id>                 M            String    1/10     Customer Client Code, Assigned by A&A.
Partner Reference          <Partner_Reference>          O            String    1/10     Sender Reference or Control Number



Batch Information
Transactions Received      <Transactions_Received>      M            Integer   1/10     Number of Transactions received
Transactions Processed     <Transactions_Processed>     M            Integer   1/10
Transactions in Error      <Transactions_Errors>        M            Integer   1/10
Acknowledgment Reference   <Acknowledgment_Reference>   M            String    1/10     Reference or Control Number Received
Acknowledgment Date        <Acknowledgment_Date>        M            Date      8/8      CCYYMMDD
Acknowledgment Time        <Acknowledgment_Time>        M            Time      10/10    HH:MM:SS



Acknowledgments
Acknowledgment Tag         <Acknowledgments>            M                               One Acknowledgment group wil be returned for each Invoice received.
General Reference No       <General_ Reference No>      M            String    1/20     Reference No (Invoice No)
Status of Invoice          <Invoice_Status>             M            String    1/10     "NOTIFY" or "ERROR"
                                                                                        Error message will be sent if necessary. If more than one error message,
Error                      <Error>                      C            String    1/100    multiple <Error> tags will be sent.




        Prepared by Jim Leong                                                                                                                         Page 16 of 16

								
To top