Pinnacle File Layout – Internal Transfer & Customer Order

File Format (utilizing “H” header, “D” detail and “I” information layout):

File names should be

  • “TO” + “YYYYMMDDHHMM” + “.txt” – Internal Transfer Order File
  • “SO” + “YYYYMMDDHHMM” + “.txt” – Customer Order File

All files are to be created and posted at the same pre-decided location.

File will include a header record followed by detail records and accessorial charges, in case of an “Add” or “Edit”. If it is a delete, the record will only have a header record.

Header Record

Field / Start Position / End Position / Field Length / Text / Comments
RECTP / 1 / 1 / 1 / Record Type / “H” for the Header
B204 / 2 / 31 / 30 / Shipment Identification # / Customer order#, hopefully will define if transfer or customer order
L1101 / 32 / 61 / 30 / Reference Number / Unique Tender ID
G6201 / 62 / 63 / 2 / Date Qualifier / Tender acceptance expiry date
G6203 / 64 / 65 / 2 / Time Qualifier / Tender acceptance (must respond by)
G6205 / 66 / 67 / 2 / Time code / “ET” for Eastern
AT503 / 68 / 107 / 30 / Special Handling Description
PLD01 / 108 / 110 / 3 / Qty of Pallets Shipped / Total Pallets
NTE02 / 111 / 190 / 80 / Load Comment Description / “ZZZ” = Load Comment; “CBH” = Currency Code
N102 / 191 / 250 / 60 / Shipper Name / N101 Entity Code = “SH”
N104 / 251 / 330 / 80 / Shipper ID Code / Represents different shipment docks
N301 / 331 / 385 / 55 / Shipper Address Information / Address Line 1
N302 / 386 / 440 / 55 / Shipper Address Information / Address Line 2
N401 / 441 / 470 / 30 / Shipper City Name / City
N402 / 471 / 472 / 2 / Shipper State/Province / State/Province
N403 / 473 / 487 / 15 / Shipper Postal Code / Postal Code
N404 / 489 / 490 / 3 / Shipper Country Code / Country
G6102 / 491 / 550 / 60 / Shipper Contact Name / Contact Name
G6104 / 551 / 630 / 80 / Shipper Contact Number / Communication Number
N711 / 631 / 632 / 2 / Equipment Description Code / Type of Equipment required
N713 / 633 / 638 / 6 / Temperature Control
N715 / 639 / 642 / 5 / Equipment Length
N102 / 643 / 702 / 60 / Ship From Name / N101 Entity Code = “SF”
N104 / 703 / 782 / 80 / Ship From ID Code / Represents different shipment docks
N301 / 783 / 837 / 55 / Ship From Address Information / Address Line 1
N302 / 839 / 892 / 55 / Ship From Address Information / Address Line 2
N401 / 893 / 922 / 30 / Ship From City Name / City
N402 / 923 / 924 / 2 / Ship From State/Province / State/Province
N403 / 925 / 939 / 15 / Ship From Postal Code / Postal Code
N404 / 940 / 942 / 3 / Ship From Country Code / Country
G6101 / 943 / 944 / 2 / Contact Function Code / “CN” = Primary Contact
G6102 / 945 / 1004 / 60 / Ship From Contact Name / Contact Name
G6104 / 1005 / 1084 / 80 / Ship From Contact Number / Communication Number
G6101 / 1085 / 1086 / 2 / Contact Function Code / “A5” = Appointment Contact
G6102 / 1087 / 1146 / 60 / Ship From Contact Name / Contact Name
G6104 / 1147 / 1226 / 80 / Ship From Contact Number / Communication Number
N102 / 1227 / 1232 / 60 / Ship To Name / N101 Entity Code = “ST”
N104 / 1233 / 1312 / 80 / Ship To ID Code / Represents different shipment docks
N301 / 1313 / 1367 / 55 / Ship To Address Information / Address Line 1
N302 / 1368 / 1422 / 55 / Ship To Address Information / Address Line 2
N401 / 1423 / 1452 / 30 / Ship To City Name / City
N402 / 1453 / 1454 / 2 / Ship To State/Province / State/Province
N403 / 1455 / 1469 / 15 / Ship To Postal Code / Postal Code
N404 / 1470 / 1472 / 3 / Ship To Country Code / Country
G6101 / 1473 / 1474 / 2 / Contact Function Code / “CN” = Primary Contact
G6102 / 1475 / 1534 / 60 / Ship To Contact Name / Contact Name
G6104 / 1535 / 1614 / 80 / Ship To Contact Number / Communication Number
G6101 / 1615 / 1616 / 2 / Contact Function Code / “A5” = Appointment Contact
G6102 / 1617 / 1676 / 60 / Ship To Contact Name / Contact Name
G6104 / 1677 / 1756 / 80 / Ship To Contact Number / Communication Number
L301 / 1757 / 1766 / 10 / Weight / Total Weight of the Order
L302 / 1767 / 1768 / 2 / Weight Qualifier / G = Gross Weight
L309 / 1769 / 1776 / 8 / Volume / Total Volume of the Order
L311 / 1777 / 1783 / 7 / Landing Quantity / # of pieces
OID01 / 1784 / 1813 / 30 / Reference ID
OID02 / 1814 / 1835 / 22 / PO Number
OID04 / 1836 / 1837 / 2 / Unit/Basis for Measurement Code / “PC” = Pieces
OID05 / 1838 / 1852 / 15 / Quantity
OID06 / 1853 / 1853 / 1 / Weight Unit Code
OID07 / 1854 / 1863 / 10 / Weight
OID08 / 1864 / 1864 / 1 / Volume Unit Qualifier
OID09 / 1865 / 1872 / 8 / Volume
1873 / 1874 / 2 / Pickup Date
1875 / 1876 / 2 / Pickup Time
1877 / 1878 / 2 / Drop off Date
1879 / 1880 / 2 / Drop Off Time
1881 / 1881 / 1 / Action / A = Add; C =Change; V=Void

Note: Would like to include any SKU Data in the details, but not sure where to find the information for the SKU

1 | Page