Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Stop Sending Invoices - Excel by adc11023

VIEWS: 7 PAGES: 4

Stop Sending Invoices document sample

More Info
									Transaction Set 210, Version 4010 (last update 05/10/2006)
Reference Ele ID Name                                M=Mandatory     Fixed Type Comments
                                                     C=Conditional   Values
                                                      O=Optional

ST Transaction Set Header
ST01         143 Transaction Set ID Code                  M           210   ID
ST02         329 Transaction Set Control Number           M                 AN

B3 Beginning Segment for Carrier Documents
B301        147 Shipment Qualifier                        O                 ID

B302           76   Invoice Number                        M                 AN   Carrier's Invoice/FreightBill Number

B304         146    Shipment Method of Payment            M           TP    ID   Hardcode "TP"

B306         373    Invoice Date                          M                 DT   YYYYMMDD

B307         193    Net Amount Due                        M                 N2   Total amount of FB

B311         140    Standard Carrier Alpha Code           M                 ID   Carrier SCAC

B312         373    Payment Due Date                      O                 DT   YYYYMMDD


C3 Currency
C301        100     Currency Code                        M/Z                ID   freight bill currency - typically "USD"

N9 Reference Identification
N901        128 Reference Identification Qualifier        M                 ID   "OL" = original Freight Bill

N902         127    Reference Identification              M                 AN   Load ID from the B2-04 in the EDI 204 Load
                                                                                 tender

H3 Special Handling Instructions
H301         152 Special Handling Code                    M                 ID   LTT = Less than Truckload Service
                                                                                 TLS = Truckload Service

LOOP ID 0100 - Not Used

LOOP ID 0200 - Used for NOF Only

LOOP ID 0250 - Not Used

LOOP ID 0300 - Not Used

LOOP ID 0305 - Not Used

LOOP ID 0310 - Not Used

LOOP ID 0320 - Not Used

LOOP ID 0400




                                                                                                                      Page 1
Transaction Set 210, Version 4010 (last update 05/10/2006)
Reference Ele ID Name                                 M=Mandatory       Fixed Type Comments
                                                      C=Conditional     Values
                                                       O=Optional
LX - Assigned Number
LX01         554 Assigned Number                             M                  NO     loop sequence number

N9 Reference Identification * if unable to send this element in this location, we can handle it with a post process.
N901        128 Reference Identification Qualifier          M              PO ID       PO = Voucher PO Number

N902         127   Reference Identification                  M                  AN     Load ID - same as the N9-02 in the header of
                                                                                       this specification

L5 Description, Marks and Numbers *L5 segment is not mandatory, but all 4 elements are IF the L5 is sent
L501               Lading Line item Number             M                          Used to match up L0, L5 and L7
L503          22 Commodity Code                        M                    AN
L504          23 Commodity Code qualifier              M             N      ID    N = NMFC (Constant)
L505         103 Packing Code                          M                    AN    PC = Pieces
                                                                                  PL = Pallets
                                                                                  MX = Mixed

L0 Line Item - Quanity and Weight (This segment is mandatory only when L108 element is "400" - otherwise it is ignored)
L001          213 Lading Line Item number                 M                 No    Used to match the weight with the freight calss
                                                                                  in L707
L004           81 Weight                                  M                 R     the weight per the freight class matched in L707

L005         187   Packing Code                              M             G    ID     G = gross weight

L1 Rate and Charges
L101              Lading Line item number                    O                  R      sequential item number
L102          60 Freight rate                                M                  R      Freight Rate ($/permile, $/pound, etc.)
L103              Rate/value qualifier                       M            OR           Hardcode "OR" meaning "Other"
L104          58 Charge                                      M                  N2     Total amount for Detail Line Item
L106         117 Prepaid Amount (Discount)                   N                         The discount amount (LTL) - send as negative
                                                                                       number
L108         150   Special Charge or Allowance               M                  ID     For Miles use LHS
                   Code                                                                For Minimum Charge (TL) use LHS
                                                                                       For Minimum Charge (LTL) use AMC
                                                                                       For Flat Rate (TL) use FFR
                                                                                       For Base/Flat Rate (LTL) use 400
                                                                                       For Discount (LTL) use DSC
                                                                                       For Weight Use 400
                                                                                       For Stop Off Use DEL
                                                                                       For Fuel Surcharge (TL) use FUE
                                                                                       For Fuel Surcharge (LTL) use 405
                                                                                       For Scale/Weight & Inspections use SCL
                                                                                       For Unloading use UNL
                                                                                       For Detention use DEM
                                                                                       For Dead Head Mileage Charge use DMC
                                                                                       For Dead Head Fuel Surcharge use ZZZ
                                                                                       (Mutually Defined)
                                                                                       For Team Charges use EXD
                                                                                       For Empty Repositioning use EMT
                                                                                       For any Other or Miscellaneous charges, use
                                                                                       MSG
L111          16   Charge Method of Payment                  M                  AN     P=Prepaid, E = Collect
L117         220   Billed/Rated-as Quantity                  M                  R      The charged units
L118         221   Billed/Rated-as Qualifier                 M            NU    ID     hardcode "NU" or "PU" = per unit




                                                                                                                        Page 2
Transaction Set 210, Version 4010 (last update 05/10/2006)
Reference Ele ID Name                                M=Mandatory     Fixed Type Comments
                                                     C=Conditional  Values
                                                      O=Optional
L7 Tariff Reference (This segment is mandatory only when L108 element is "400" otherwise ignored)
L701          213 Lading Line item number                 M                  R     Used to match up the weight code in L004

L707         59   Freight Class Code                       M                 AN     If sending class 77.5 or other with a decimal, we
                                                                                    require "77.5" not "775" or "77"

END Loop 400

SE Transaction Set Trailer
SE01         96 Number of Included Sets                    M                 N0
SE02        329 Transaction Set Control Number             M                 AN




                                                                                                                       Page 3
When to send 210 Freight Bills

210 should only be sent after the 214 for all pickups have been sent and preferred to be sent after the load is

Hard copy (paper) invoices should still be sent for: (Do NOT send EDI for these)
     Rebills
     Balance Dues
     Volume
     Quotes
     Air shipments ( if any )
     Time critical
     Guaranteed delivery shipments
     Detention Bills
     and invoices with Bad Load ID numbers
           A valid Load ID (B2-04 on tender, N9-02 on freight bill, B10-02 on ship status) has the following
                 always 7 digits
                 Generally starts with a "2"
                 contains only numbers - no alpha
                 can be found on the paper BOL if not captured from the EDI tender

All hard copy invoices sent should have the standard backup attached. (same as currently doing)

Do NOT send hard copy (paper) invoices for any bills that go EDI.

Need contact name and email address of someone to receive any copies of invoices that are out of tolerance.

210 Freight Bill Questions

Are 997s required?

Will you only be sending one batch per day (preferred) and if so, what time will it typically be sent?

What control number will you start with?

Do you use PC-Miler for milage calculations? What version?

								
To top