Mapping Guideline for FORTRAS BORD512 to conizi manifest format
v1.2 - 2019-MAY-17Introduction
This documentation is a part of the Mapping Guideline series for conizi semantic model. The messages described here are used for communicating with conizi applications, such as Track and Trace and Order Management, and other partners connected to the conizi network.
The structure of manifest (bordero) and the content of the fields and message parts will be described in this document.
The standard of the source message format is FORTRAS and the version used here is release 100. The message format is often just referred to as REL100.
Technical Background
The conizi platform processes JSON format objects and their exact format is specified by the JSON Schema standard, version draft-06. The schema documentation can be found in a public repository on the https://github.com/conizi/semantic-model URL.
The structures of the conizi manifest and status business objects are specified by the files under model/transport/truck/groupage/forwarding folder.
The order of elements in JSON format message does not matter - as opposed to FORTRAS and XML format files.
The countries must be specified with their 2 characters long Alpha-2 ISO-3166 standard codes, which can be found here: https://en.wikipedia.org/wiki/List_of_ISO_3166_country_codes
The dates in JSON files are always in YYYY-MM-DD format as described by ISO-8601 standard.
FORTRAS BORD512 Message Structure
FORTRAS messages consist of records and each record type has a different set of fields. Each record and each field inside the records was given an id or a name. In this mapping documentation we will refer to the records and fields by their ids and names.
Please refer to Appendix 1. for the list of record ids and Appendix 2. for field names.
The FORTRAS standard allows creating custom records on row type id 99 (e.g.: D99). These records are not in the scope of this mapping documentation.
Conizi Manifest Message Overview
The conizi manifest message consists of 3 levels: manifest, consignment, position. The drawing below shows how the parts are related to each other and what is the connection between them and the FORTRAS message records.
Please also refer to Appendix 3., where a complete conizi format manifest file can be found. This is how the result of the conversion, mapping should look like in JSON format.
The schema must be referenced from each level of the message. To better understand this concept, check for the $schema tags in the Appendix 3..
The following schema references must be added for different message sections, levels:
Message section / level | schema reference |
---|---|
Root level | https://raw.githubusercontent.com/conizi/semantic-model/master/transport/truck/groupage/forwarding/manifest |
consignment | https://raw.githubusercontent.com/conizi/semantic-model/master/transport/truck/groupage/forwarding/consignment |
Mapping
In the mapping description we use the path notation to refer to source and target fields. Source field path consists of the record type and the field of that record. Eg.: A00/waybillNumber
There are some fields in the documentation starting with “x-“. These are temporary fields that are currently working, but are subject to change in the near future. These fields are not included in the schema.
Manifest Level
This is the main level of the manifest message. For each BORD512 file this is mapped only once. It contains lines with an array of consignment data.
conizi manifest field | FORTRAS BORD512 field | Description |
---|---|---|
manifestId | A00/waybillNumber | A unique identifier assigned to this cargo manifest by the shipping partner |
manifestType | A00/dataType | Type of the manifest (STD, INF, AVI) |
shippingDate | A00/waybillDate | The date on which the manifest was issued |
transportType | A00/transportType | Information about the way of production of that transport (i.e. by HUB, by direct transport, …) |
sender/ediId | header/senderId | The sender of the current record. This usually equals to the ordering party unless the record is a copy that was generated by some other component. In this case the sender can be different from the ordering party |
receiver/ediId | header/receiverId | The intended recipient of the the current record. This usually equals to the contracted party unless the record is intentionally sent to another system. |
network/product | A00/product | The product allows to distingish different processes within one network, effectively sub classing the network. |
network/networkId | Network id assigned by conizi for the given business case. | The network under which rules the consignment should be processed |
isPreAdvice | true, if A00/dataType is AVI or INF, otherwise false | Adds the possibility of sending the manifest (after saving, before approval) to e.g. a TMS |
additionalPartners | See Address Mapping | Additional partners (e.g. gateways or hubs) which are also involved in forwarding this consignment |
shippingPartner/partnerId | A00/waybillConsignorId | The partner which is sending the consignment to the receiving partner for further delivery. |
receivingPartner/partnerId | A00/waybillConsigneeId | The partner which is receiving the goods declared on the manifest from the shipping partner for further delivery. |
carrier/name | A00/freightOperator | Company responsible for the actual transport of the goods from the shipping partner to the receiving partner |
carrier/countryCode | A00/freightOperatorCountry | |
carrier/zipCode | A00/freightOperatorPostcode | |
carrier/city | A00/freightOperatorTown | |
vehicles/registration | A00/vehicleLicenseNumber[n] | Information about the vehicles used in the transport |
loadUnits | See Load Units Mapping | Load units (containers, swap bodies, …) used to transport the goods |
additionalLoadingEquipment/eurPallets | J00/numberOfEuroFlatPallets | Additional loading equipment used to securely load the goods into for the passage |
additionalLoadingEquipment/eurBoxes | J00/numberOfBoxPallets | |
lines/consignment | See Consignment Level | Lines of the manifest |
Address Mapping
Addresses are mapped from different qualifier B00 / B10 records. The main address data is coming from B00 and the contact information is added from further B10 records.
conizi manifest field | FORTRAS BORD512 field | Notes |
---|---|---|
name | B00/name1 | |
x-name2 | B00/name2 | |
x-name3 | B00/name3 | |
street | B00/streetAndStreetNumber | |
countryCode | B00/countryCode | |
zipCode | B00/postcode | |
city | B00/place | |
townArea | B00/townArea | |
reference | B00/partnerId | |
contactPerson | B10/content from B10 record, where communicationTypeQualifier = KPE | Can be more, separated by comma. |
phoneNumber | B10/content from B10 record, where communicationTypeQualifier = TEL | Can be more, separated by comma. |
emailAddress | B10/content from B10 record, where communicationTypeQualifier = EMA | Can be more, separated by comma. |
faxNumber | B10/content from B10 record, where communicationTypeQualifier = FAX | Can be more, separated by comma. |
Load Units Mapping
Under the loadUnits tag there is an array of objects for each A10/loadingUnitsNo[n]. Inside that object there is an identification tag that contains the given A10/loadingUnitsNo[n] tag and an array of seals. In the seals array each item is a code mapped from A10/leadSealNumber[m]LU[n]. Where m is the position of the current seal number and n is the position of the loading unit. In tabular format:
conizi manifest field | FORTRAS BORD512 field |
---|---|
loadingUnits[]/identification | A10/loadingUnitsNo[n] |
loadingUnits[]/seals[]/code | A10/leadSealNumber[m]LU[n] |
Consignment Level
This chapter describes the consignment level mapping. One manifest message can contain multiple consignments, each starting with B00 (address) records.
A consignment is described by these record types: B00, B10, C00, D00, D10, E00, E10, F00, G00, H00, H10 and I00.
The lines tag of the manifest contains an array of objects which has 2 members: lineNo and consignment.
The lines/lineNo field should be filled with sequentialWaybillItem of the given consignment. This value is the same for each FORTRAS record of the consignment and can be taken from any record type inside the consignment level.
The below fields are members of the object referenced by the consignment tag.
conizi manifest field | FORTRAS BORD512 field | Description |
---|---|---|
consignmentNoShippingPartner | G00/consignmentNumberSendingDepot | Unique identification for the consignment within the transport management system of the shipping partner |
consignmentNoReceivingPartner | G00/consignmentNumberReceivingDepot | Unique identification for the consignment within the transport management system of the receiving partner |
shippingDate | A00/waybillDate | The date on which the consignment was forwarded to the receiving partner. If the consignment was part of a cargo manifest, this is the date on which the manifest was issued |
manifestId | A00/waybillNumber | Unique identification for the manifest on which the shipment was loaded in the transport management system of the shipping partner. |
sender | header/senderId | The sender of the current record. This usually equals to the ordering party unless the record is a copy that was generated by some other component. In this case the sender can be different from the ordering party |
receiver | header/receiverId | The intended recipient of the the current record. This usually equals to the contracted party unless the record is intentionally sent to another system. |
orderingParty | B00/addressTypeQualifier = ORD See Address Mapping |
Person or company that ordered the transport of the consignment. Often identical to the shipper |
shippingPartner | A00/waybillConsignorId | The partner which is sending the consignment to the receiving partner for further delivery. |
receivingPartner | A00/waybillConsigneeId | The partner which is receiving the goods declared on the manifest from the shipping partner for further delivery. |
services | See Services Mapping and Text Codes | Special services which can be requested by the ordering party (or the shipping partner). |
information | See Information Mapping | General information about the consignment |
references | See References Mapping | Numbers of various sources identiyfing this consignment or references from this consignment to other business processes |
billing | See Billing Mapping | Information for invoicing and clearing |
customsInformation | See Customs Information Mapping | Used to specifiy information necessary in the customs process |
content | See Content Mapping | Describes the nature and quantity of the goods in this consignment |
Routing Mapping
Fields discussed in this chapter are all under the lines/consignment/routing path.
conizi manifest field | FORTRAS BORD512 field | Description |
---|---|---|
shipper | B00/addressTypeQualifier = SHP See Address Mapping |
The address of the party which is sending the goods. This is usually the place where the transport originated |
consignee | B00/addressTypeQualifier = CON See Address Mapping |
The address of the good’s recipient |
Services Mapping
Fields discussed in this chapter are all under the lines/consignment/services path.
The majority of the services element mapping is done from the H00 text code, see Text Codes.
conizi manifest field | FORTRAS BORD512 field | Description |
---|---|---|
notifications/generalNotificationAddress | B00/addressTypeQualifier = NOT See Address Mapping |
An address and associated contact information which should be kept in the loop |
anonymity | Neutral addresses which are shown to the shipper or consignee in order to conceal the actual shipper or recipient of the goods. | |
anonymity/neutralShipper | B00/addressTypeQualifier = NES See Address Mapping |
An address to be shown to the consignee instead of the actual shipper when delivering the goods |
anonymity/neutralConsignee | B00/addressTypeQualifier = NEC See Address Mapping |
An address to be shown to the shipper instead of the actual address the consignee when picking up the goods |
services/unloadingOptions/directDelivery | if G00/directDelivery = ‘Y’, then true | The goods are to be delivered without unloading them at the receiving partners warehouse |
Information Mapping
Fields discussed in this chapter are all under the lines/consignment/information path.
conizi manifest field | FORTRAS BORD512 field | Description |
---|---|---|
remarksGeneral | H10/text, where textQualifier = ‘000’ | Free text information |
remarksDelivery | H10/text, where textQualifier = ‘001’ | Free text information for the delivery |
remarksPickup | H10/text, where textQualifier = ‘002’ | Free text information for the pick up |
remarksInvoice | H10/text, where textQualifier = ‘003’ | Free text information for the invoice |
References Mapping
Fields discussed in this chapter are all under the lines/consignment/references path.
All of these fields are usually mapped from H00 text codes. See Text Codes.
Billing Mapping
Fields discussed in this chapter are all under the lines/consignment/billing path.
conizi manifest field | FORTRAS BORD512 field | Description |
---|---|---|
freightPayer | B00/addressTypeQualifier = INV See Address Mapping |
The party which receives the invoice (if different from the shipper). |
tariff | Use to specify a special tariff to be used for freight calculation (e.g. heavy goods, …) | |
routingOrder | Use to specify that the consignment results of a standing pickup order and specifies the partner which issued this pickup order and thus should be billed. | |
deliveryTerms | G00/deliveryTerm | Use to specify under which terms the consignment is processed and which legs are billed to whom |
logisticModel | G00/logisticsModel | Used to active special billing and clearing conditions the partners have agreed on |
Customs Information Mapping
Fields discussed in this chapter are all under the lines/consignment/customsInformation path.
conizi manifest field | FORTRAS BORD512 field |
---|---|
clearedForFreeTransitWithinEU | See Text Codes Mapping |
valueAtBorderCrossing/amount | C00/transitValue |
valueAtBorderCrossing/currency | C00/transitValueCurrency |
cityUnloading | C00/pointOfDelivery |
customsOffice | C00/customsOffice |
customsProcess | C00/customsProcedure |
customsType | C00/dutyPaymentType |
importCustomsOffice | C00/customsOfficeEntry |
parentDocumentId | C00/precedingDocumentNumber |
parentDocumentType | C00/precedingDocumentType |
routeBorder | C00/modeOfTransportToBorder |
routeInland | C00/domesticModeOfTransport |
statisticsFlag | C00/statisticsStatus |
transferType | C00/businessType |
countryConsignor | C00/consignorCountry |
countryImporter | C00/countryOfImporter |
countryLoading | C00/countryOfLoading |
countryOfOrigin | C00/countryOfOrigin |
countryUnloading | C00/destinationCountry |
documents/type | A documents tag must be created for each C00/appendix… group. C00/appendixType |
documents/number | C00/appendixNumber |
documents/date | C00/appendixDate |
Consignment Content Mapping
Fields discussed in this chapter are all under the lines/consignment/content path.
conizi manifest field | FORTRAS BORD512 field | Description |
---|---|---|
nonHazardousWaste | See Text Codes Mapping | The content has no value and is not dangerous |
loadingAids | See Text Codes Mapping | The consignment only consists of loading aids which are transported and does not contain real goods |
highValueGoods | G00/materialGroup = 002 or from See also Text Codes Mapping |
This consignment contains goods of high value which are subject to higher insure fees and a higher risk of theft |
highConsequencesDangerousGoods | See Text Codes Mapping | This consignment contains dangerous goods which must be handeled unter the terms of HCDG |
insuranceValue/amount | G00/goodsValue See also Text Codes Mapping |
Value of the goods, used for insurance purposes |
insuranceValue/currency | G00/currencyOfGoodsValue | |
volumeCubicmeter | G00/cubicMeters | Total volume of the consignment |
loadingMeter | G00/loadingMeters | Length of the area occupied on a 2.4 m wide container |
grossWeightKilogram | G00/actualConsignmentGrossWeightInKg | Weight of the consignment including all packaging |
areaPalletBays | G00/numberOfPalletLocations | Area used by the consignment in terms of standard EUR pallet bays (120 x 80 cm) |
chargeableWeightKilogram | G00/chargeableConsignmentWeightInKg | Virtual weight of the shipment used for billing purposes. Used to take the bulkiness of goods into account or to enforce minimums. |
lines | See Position Level Mapping | Lines are describing handling units of similar sizes and content for brevity |
Position Level
Fields discussed in this chapter are all under the lines/consignment/content/lines path. The lines tag contains an array of objects of which these fields are members of.
conizi manifest field | FORTRAS BORD512 field | Description |
---|---|---|
lineNo | D00/consignmentPosition | A ordinal number, ordering the line within the consignment |
handlingUnitCount | D00/numberOfPackages | The number of the items in this consignment which are handeled individually |
handlingUnitType | D00/packagingType | The type of packaging (e.g. pallet, carton box, …) ouf the outer most packaging |
innerPackageCount | D00/numberOfPackagesOnPallets | Used to specify the number of inner packages (e.g. the number of boxes on a pallet) |
innerPackageType | D00/packagingTypeOnPallets | The type of packaging of the inner packages |
content | D00/contentOfGoods | A short description of the nature of the goods contained within the packages |
refNo | D00/codeAndNumber | A reference of the ordering party relating to the goods |
volumeCubicmeter | D00/cubicMeters | Total volume of the line |
loadingMeter | D00/loadingMeters | Length of the area occupied on a 2.4 m wide container |
grossWeightKilogram | D00/actualWeight | Weight of the line including all packaging |
areaPalletBays | D00/numberOfPalletLocations | Area used by the line in terms of standard EUR pallet bays (120 x 80 cm) |
chargeableWeightKilogram | D00/chargeableWeight | Virtual weight of the line used for billing purposes. Used to take the bulkyness of goods into account or to enforce minimums. |
lengthMeter | D00/lengthInMeters | Total length of the line |
widthMeter | D00/widthInMeters | Total width of the line |
heightMeter | D00/heightInMeters | Total height of the line |
customsInformation | See Position Level Customs Information Mapping | Used to specifiy information necessary in the customs process |
barcodes | See Barcodes Mapping | Detailed information about the individual handling units |
dangerousGoods | See Dangerous Goods Information | Detailed information about dangerous goods and the danger types |
Position Level Customs Information Mapping
Fields discussed in this chapter are all under the lines/consignment/content/lines/customsInformation path.
conizi manifest field | FORTRAS BORD512 field |
---|---|
goodsNo | D10/productNumber |
processCode | D10/procedureCode |
netweightKilogram | D10/fixedLoadInKgNet |
rawWeightKilogram | D10/rawMassInKg |
countryOfOrigin | D10/countryOfOrigin |
customsValue/amount | D10/customsValue |
customsValue/currency | D10/currencyOfCustomsValue |
statisticalValue/amount | D10/statisticalValue |
statisticalValue/currency | D10/currencyOfStatisticalValue |
documents/type | A documents tag must be created for each D10/appendix… group. D10/appendixType |
documents/number | D10/appendixNumber |
documents/date | D10/appendixDate |
Barcodes Mapping
Fields discussed in this chapter are all under the lines/consignment/content/lines/barcodes path. The barcodes tag contains an array of objects of which these fields are members of. An array element must be created for each F00 record.
conizi manifest field | FORTRAS BORD512 field | Description |
---|---|---|
code | F00/barcode | Id of the handling unit, usually printed as machine readable bar code on the package |
masterBarcode | Grouping of multiple packages | |
batch | Information identifying the manufacturing batch of the goods in the unit | |
bestBefore | Information about the expiry of goods |
Dangerous Goods Information
Fields discussed in this chapter are all under the lines/consignment/content/lines/dangerousGoods path. The dangerousGoods tag contains an array of objects of which these fields are members of. An array element must be created for each E00 record.
conizi manifest field | FORTRAS BORD512 field |
---|---|
quantity | E00/numberOfPackages |
grossWeightKilogram | E00/grossWeightInKg |
unNo | E00/unNumber |
multiplier | E00/multiplier |
uniqueKey | E00/uniqueKey |
substanceName | E00/materialNameDangerousGoodsDesc |
labelMainRisk | E00/dangerousGoodsSampleMajor |
labelSubRisk1 | E00/dangerousGoodsSampleMinor1 |
labelSubRisk2 | E00/dangerousGoodsSampleMinor2 |
labelSubRisk3 | E00/dangerousGoodsSampleMinor3 |
packagingDescription | E00/descriptionOfPackaging |
netExplosiveMassKilogram | E00/netExplosiveMassInKg |
transportCategory | E00/transportClass |
limitedQuantity | E00/limitedAmount See also Text Codes. |
totalPointsADR | E00/calculatedDangerousGoodsPoints |
tunnelRestriction | E00/tunnelLimitationCode |
packagingGroup | E00/packagingGroup |
classificationCode | E00/classificationCode |
exemptedQuantity | E00/exemptQuantity |
netWeightKilogram | if E00/qualifierForLitersOrNetWeight = NGW then E00/entryForLitersOrNetWeightInKg else empty |
volumeLiter | if E00/qualifierForLitersOrNetWeight = LIT then E00/entryForLitersOrNetWeightInKg else empty |
adrRelease | E00/ggRelease |
packagingClass | E00/packagingGroupClassification |
references/fireworksBamNo | |
x-additionalTextForNAG | E00/additionalTextForNAG |
Text Codes
The H00 records in the FORTRAS manifest messages provides very flexible data transfer possibilities. Using these fields a partner can specify its own coding standard to include arbitrary information about the consignment in the message.
In FORTRAS standard H00 records belong to the consignment level and mapped into the conizi manifest message on consignment level too, with a very rare exception.
In this chapter we list the fields that can be mapped from H00 fields. The structure and the usage of H00/additionalText fields must be specified by the partner and used in the mapping to provide the necessary consignment data .
Content Fields
The conizi manifest tags are below /lines/consingment/content. This root path won’t be repeated for each item in the table.
Manifest field | Description |
---|---|
nonHazardousWaste | The content has no value and is not dangerous |
highValueGoods | This consignment contains goods of high value which are subject to higher insure fees and a higher risk of theft |
insuranceValue/amount | Value of the goods, used for insurance purposes |
lines/dangerousGoods/limitedQuantity |
Service Fields
The conizi manifest tags are below /lines/consingment/services. This root path won’t be repeated for each item in the table.
Manifest field | Description |
---|---|
packagingOptions | |
packagingOptions/return | Packaging material return |
packagingOptions/correction | Packaging correction for your Bordero from: … (Additional description) |
packagingOptions/thirdPartyDelivery | Delivery of packaging by third parties on: … (Additional description) |
packagingOptions/pickup | Package pickup |
specialRun | The transport is produced via special run (and with special fares) |
notifications | Notifications which should be sent while processing the shipment, e.g. notifications about successful delivery, advance notifications, … |
notifications/generalNotificationAddress | An address and associated contact information which should be kept in the loop |
notifications/afterDelivery | Information about successful delivery should be given to this address. See Address Mapping. |
notifications/beforeDelivery | Before a delivery is attempted the person noted here should be contacted within the given time frame. See Address Mapping. |
notifications/byDriver | The driver should call the given contact before delivery. See Address Mapping. |
timeSlotBooking | Information about time slots which need to be booked or are already booked for this consignment |
timeSlotBooking/byDeliveringPartner | A time slot must be booked by the delivering partner before making a delivery attempt. |
timeSlotBooking/preBookedTimeslot | A time slot has already been booked for the delivery of this consignment. Delivery must be attempted within this time slot. |
timeOptions | Requirements for the delivery or pickup time |
timeOptions/notAfter/date | The consignment must be delivered until the given date. |
timeOptions/notBefore/date | The consignment must not be delivered before the given date. |
timeOptions/fixedDay/date (timeFrom, timeUntil) | The consignment must be delivered at the given date (and in the given time window). |
timeOptions/fixedWeek/year, weekOfYear | The consignment must be delivered within the given week of the year. |
timeOptions/weekendSaturday/timeFrom, timeUntil | The consignment should be delivered on a Saturday |
timeOptions/nextDay/timeFrom, timeUntil | The consignment must be delivered on the next working day |
timeOptions/sameDay/timeFrom, timeUntil | The consignment must be delivered on the same day |
timeOptions/evening/timeFrom, timeUntil | The consignment must be delivered in the evening hours |
deliveryOptions | Requirements for special services or equipment for the delivery |
deliveryOptions/liftingPlatform | The consignment can only be delivered with a vehicle equipped with a lifting platform |
deliveryOptions/pointOfUseDelivery1Person | The goods must be delivered to the point of use with one man handling |
deliveryOptions/pointOfUseDelivery2Persons | The goods must be delivered to the point of use with two man handling |
deliveryOptions/shelfService | The goods must be put into the shelves at the destination |
deliveryOptions/useSpecificLastMileProvider | A given last mile provider must be used |
deliveryOptions/cashOnDelivery | The goods must only be delivered if the recipient pays the given amount |
deliveryOptions/cashOnDelivery/amount | The amount to be paid |
deliveryOptions/cashOnDelivery/currency | The currency of the given amount |
deliveryOptions/cashOnDelivery/acceptCash | Specifies if cash should be accepted (true) or rejected (false). |
deliveryOptions/cashOnDelivery/acceptCheque | Specifies if cheques should be accepted |
deliveryOptions/pickupByConsignee | The consignee will pick up the goods at the receiving partner’s warehouse. Do not perform local delivery. |
deliveryOptions/workRequest/info | The receiving partner should perform the action specified |
deliveryOptions/deliveryOnlyWithDeliveryNote | Delivery should only be performed with the delivery note. |
deliveryOptions/returnOriginalDeliveryNote | Original delivery note must be returned with the signature of the recipient to the shipping partner as paper (i.e. not in electronic form). |
deliveryOptions/digitalDeliveryNote | The delivery note has been sent by means of digital communication (and is not attached to the goods) |
deliveryOptions/deliveryNoteOnGoods | The delivery note is attached to the goods |
deliveryOptions/podOnOriginalDeliveryNote | The recipient must sign the original delivery note as proof of delivery. The signed document must be returned to the shipping partner. |
deliveryOptions/deliveryWithoutReceiptAllowed | The goods may be dropped at the designated location without a signature |
deliveryOptions/forAttentionOf | The delivery is for attention of the given company |
loadingOptions | Information about the loading of the main haul |
loadingOptions/directPickup | The goods picked up by the line haul and are not loaded by the shipping partners warehouse |
unloadingOptions | |
unloadingOptions/directDelivery | The goods are to be delivered without unloading them at the receiving partners warehouse |
unloadingOptions/alreadyReceived | The goods are already at the receicing partners warehouse, because they have been reported as surplus eaelier on |
unloadingOptions/alreadyReceived/surplusConsignmentNo | The reference number under which the surplus consignment had been reported by the receiving partner |
unloadingOptions/alreadyReceived/shippingDate | The date of the manifest which contained the surplus goods |
unloadingOptions/missingFromPreviousManifest | The goods for a consigment which already was part of another manifest and had been reported missing on that manifest |
unloadingOptions/missingFromPreviousManifest/manifestId | The manifest which first included the consignment |
unloadingOptions/missingFromPreviousManifest/shippingDate | The date of the manifest which included the consignment |
gateway | Special requirements for the handling of the goods at intermediate hubs / gateways |
gateway/priority | The consignment must be processed with priority |
handlingInstructions | Handling instructions for the goods, e.g. to prevent damage |
handlingInstructions/customsGoods | The goods are subject to customs processing and must be processed according the rules of the local authorities |
handlingInstructions/customsGoodsResubmissionDate | The resubmission date for the customs goods |
handlingInstructions/handleWithCare | The goods must be handled with care to prevent damage |
handlingInstructions/emptiesExchange | Specifies whether empties should be exchanged with the consignee |
handlingInstructions/orientation (/vertical, /horizontal) | The goods must be transported in a given orientation and may not be flipped over |
handlingInstructions/stacking (/allowed, /forbidden) | Indicated whether the goods may or may not be stacked |
handlingInstructions/temperatureRestrictions (/temperatureMinCelsius, /temperatureMaxCelsius) | Restrictions about the minimum and maximum temperature during the transport and special equipment to be used |
handlingInstructions/food/haccp | The HACCP regulations apply |
returnOfGoods | Services for the return of goods |
returnOfGoods/emptyPackaging | The packaging of the goods is taken back and disposed |
References Fields
The conizi manifest tags are below /lines/consingment/references. This root path won’t be repeated for each item in the table.
Manifest field | Description |
---|---|
returnOfPreviousConsignment | Reference to another consignment which content is return using this consignment |
returnOfPreviousConsignment/consignmentNoShippingPartner | The consignment number of the original consignment being returned |
returnOfPreviousConsignment/shippingDate | The date when the original shipment was forwarded |
returnOfPreviousConsignment/shippingPartner | The partner which originally forwarded the consignment |
forwardedFor | The partner for which the consignment was processed by the shipping partner (e.g. routing order) |
subsequentDelivery | Additional delivery to our Bordero from: … (additional text) (Shipment-no. of the dispatching and receiving partner are to be transferred additionally) |
subsequentDelivery/consignmentNoShippingPartner | The consignment number of the original consignment |
subsequentDelivery/shippingDate | The date when the original shipment was forwarded |
subsequentDelivery/shippingPartner | The partner which originally forwarded the consignment |
pickupOrder/pickupOrderNo references/pickupOrder/orderingParty |
Reference to a pickup order which resulted in this consignment |
deliveryNote | The delivery note of the shipper which describes the content of this consignment |
customerOrderNo | A reference of the shipper for this consignment |
customerOrderDate | Date when the order was placed with the shipping partner |
orderEntrySystemReference | A unque reference number from the system which was used to enter the order details |
CustomsInfo fields
The conizi manifest tags are below /customsinfo. This root path won’t be repeated for each item in the table.
Manifest field | Description |
---|---|
clearedForFreeTransitWithinEU |
Appendix 1. FORTRAS REL100 BORD512 Record References
We only include the information here that is necessary to find the fields in the originating message referenced by the mapping documentation. Describing the BORD message format in detail is outside of the scope of this documentation.
Each data record begins with a short id which declares its type. The record type ids are listed in the table with the short description of their contents.
Record type | Description |
---|---|
@@PH | Header record. Referenced as “header” in the mapping documentation. |
A00 | Consignment data head |
A10 | Loading unit |
B00 | Addresses |
B10 | Communication information |
C00 | Customs information |
D00 | Consignment positions |
D10 | Customs information for the item |
E00 | Dangerous goods record |
E10 | Additional texts for E00 |
F00 | Barcodes and references |
G00 | Consignment sums |
H00 | Text codes |
H10 | Individual texts |
I00 | Service types |
J00 | Consignment data sums |
Z00 | Control record |
@@PT | Trailer record |
Appendix 2. FORTRAS REL100 BORD512 Field References
In the following chapters each field will be identified and labeled with a unique tag, so that they can be located unambiguously inside the BORD512 format file. These tags later will be used in the mapping section as paths for the incoming data.
In the table we specify the length of the field and the place where their data begins according to the FORTRAS REL100 standard.
Repeating fields are not listed multiple times for sake of brevity. In name of these items we always denote the place of the numbering with “[n]” and “[m]” (if multiple numbering is used). Eg.: leadSealNumber1LU1, leadSealNumber1LU2, leadSealNumber1LU3, leadSealNumber1LU4 will be just described with leadSealNumber[n]LU[m]
@@PH - Header Record
|Field reference|Length|From|Notes| |—————|——|—-|—–| |recordType|4|1|fix ‘@@PH’| |type|7|5|fix ‘STAT512’| |empty|1|12|| |rowLength|4|13|0512| |empty|2|17|00| |startAddress|2|19|35| |empty|2|21|00| |internalSign|1|23|1| |empty|1|24|0| |mailboxLength|2|25|’7 ‘| |mailboxSender|x|27|’AAAAAAA’| | mailboxReceiver |||Startaddress-(Startadress+Mailbox-Length)|
Examples:
@@PHSTAT512 0512003500107 AAAAAAA BBBBBBB
@@PHSTAT512 05120044001018LONGSENDERHEADER LONGRECEIVERHEADER
A00 - Consignment Data Head
Field reference | Length | From |
---|---|---|
recordType | 3 | 1 |
dataType | 3 | 4 |
releaseVersion | 3 | 7 |
waybillNumber | 35 | 10 |
waybillDate | 8 | 45 |
transportType | 3 | 53 |
product | 3 | 56 |
codeList | 3 | 59 |
currency | 3 | 62 |
waybillConsignorId | 35 | 65 |
waybillConsigneeId | 35 | 100 |
freightOperator | 35 | 135 |
freightOperatorCountry | 3 | 170 |
freightOperatorPostcode | 9 | 173 |
freightOperatorTown | 35 | 182 |
vehicleLicenseNumber1 | 35 | 217 |
vehicleLicenseNumber2 | 35 | 252 |
routingId1 | 35 | 287 |
routingId2 | 35 | 322 |
testCode | 1 | 357 |
arrivalDate | 8 | 358 |
arrivalTime | 4 | 366 |
arrivalTimeQualifier | 3 | 370 |
trafficType2 | 3 | 373 |
driverName | 35 | 376 |
driverPhone | 20 | 411 |
A10 - Loading Unit
Field reference | Length | From | Notes |
---|---|---|---|
recordType | 3 | 1 | |
loadingUnitsNo[n] | 35 | 4 | Repeted twice, with the seal numbers |
leadSealNumber[n]LU[m] | 35 | 39 | Repeated 4 times |
B00 - Addresses
Field reference | Length | From |
---|---|---|
recordType | 3 | 1 |
sequentialWaybillItem | 3 | 4 |
addressTypeQualifier | 3 | 7 |
name1 | 35 | 10 |
streetAndStreetNumber | 35 | 45 |
countryCode | 3 | 80 |
postcode | 9 | 83 |
place | 35 | 92 |
partnerId | 35 | 127 |
name2 | 35 | 162 |
name3 | 35 | 197 |
townArea | 35 | 232 |
globalLocalizationNumber | 35 | 267 |
customsId | 35 | 302 |
B10 - Communication Information
|Field reference|Length|From| |—————|—–:|—:| |recordType|3|1| |sequentialWaybillItem|3|4| |communicationTypeQualifier|3|7| |content|256|10|
C00 - Customs Information
Field reference | Length | From | Notes |
---|---|---|---|
recordType | 3 | 1 | |
sequentialWaybillItem | 3 | 4 | |
dutyPaymentType | 3 | 7 | |
customsProcedure | 4 | 10 | |
customsOffice | 8 | 14 | |
countryOfOrigin | 3 | 22 | |
countryOfLoading | 3 | 25 | |
consignorCountry | 3 | 28 | |
destinationCountry | 3 | 31 | |
destinationLand | 3 | 34 | |
countryOfImporter | 3 | 37 | |
statisticsStatus | 3 | 40 | |
pointOfDelivery | 35 | 43 | |
transitValue | 9 | 78 | |
transitValueCurrency | 3 | 87 | |
businessType | 3 | 90 | |
modeOfTransportToBorder | 3 | 93 | |
domesticModeOfTransport | 3 | 96 | |
customsOfficeEntry | 8 | 99 | |
precedingDocumentType | 10 | 107 | |
precedingDocumentNumber | 25 | 117 | |
appendixType[n] | 6 | 142 | Repeating 3 times |
appendixNumber[n] | 20 | 148 | |
appendixDate[n] | 8 | 168 |
D00 - Consignment Positions
Field reference | Length | From |
---|---|---|
recordType | 3 | 1 |
sequentialWaybillItem | 3 | 4 |
consignmentPosition | 3 | 7 |
numberOfPackages | 4 | 10 |
packagingType | 3 | 14 |
numberOfPackagesOnPallets | 4 | 17 |
packagingTypeOnPallets | 3 | 21 |
contentOfGoods | 35 | 24 |
codeAndNumber | 35 | 59 |
actualWeight | 9 | 94 |
chargeableWeight | 9 | 103 |
lengthInMeters | 4 | 112 |
widthInMeters | 4 | 116 |
heightInMeters | 4 | 120 |
cubicMeters | 5 | 124 |
loadingMeters | 3 | 129 |
numberOfPalletLocations | 4 | 132 |
D10 - Customs Information for The Item
Field reference | Length | From | Notes |
---|---|---|---|
recordType | 3 | 1 | |
sequentialWaybillItem | 3 | 4 | |
consignmentPosition | 3 | 7 | |
productNumber | 15 | 10 | |
countryOfOrigin | 3 | 25 | |
rawMassInKg | 9 | 28 | |
fixedLoadInKgNet | 9 | 37 | |
procedureCode | 5 | 46 | |
customsValue | 11 | 51 | |
currencyOfCustomsValue | 3 | 62 | |
statisticalValue | 11 | 65 | |
currencyOfStatisticalValue | 3 | 76 | |
appendixType[n] | 6 | 79 | Repeated 4 times |
appendixNumber[n] | 20 | 85 | |
appendixDate[n] | 8 | 105 |
E00 - Dangerous Goods Record
Field reference | Length | From |
---|---|---|
recordType | 3 | 1 |
sequentialWaybillItem | 3 | 4 |
consignmentPosition | 3 | 7 |
ggRelease | 3 | 10 |
numberOfPackages | 4 | 13 |
grossWeightInKg | 9 | 17 |
unNumber | 4 | 26 |
descriptionOfPackaging | 35 | 30 |
multiplier | 4 | 65 |
ggDatabaseId | 3 | 69 |
uniqueKey | 10 | 72 |
materialNameDangerousGoodsDesc | 210 | 82 |
additionalTextForNAG | 7 | 292 |
dangerousGoodsSampleMajor | 3 | 362 |
dangerousGoodsSampleMinor1 | 3 | 365 |
dangerousGoodsSampleMinor2 | 3 | 368 |
dangerousGoodsSampleMinor3 | 3 | 371 |
packagingGroupClassification | 4 | 374 |
netExplosiveMassInKg | 9 | 378 |
transportClass | 1 | 387 |
limitedAmount | 1 | 388 |
calculatedDangerousGoodsPoints | 9 | 389 |
tunnelLimitationCode | 6 | 398 |
packagingGroup | 4 | 404 |
classificationCode | 4 | 408 |
exemptQuantity | 1 | 412 |
entryForLitersOrNetWeightInKg | 9 | 413 |
qualifierForLitersOrNetWeight | 3 | 422 |
harmfulToTheEnvironment | 1 | 425 |
E10 - Additional Texts for E00
|Field reference|Length|From|Notes| |—————|—–:|—:|—-| |recordType|3|1|| |sequentialWaybillItem|3|4|| |consignmentPosition|3|7|| |textQualifier[n]|70|10|Repeated 5 times| |text[n]|3|13||
F00 - Barcodes and References
|Field reference|Length|From|Notes| |—————|—–:|—:|—-| |recordType|3|1|| |sequentialWaybillItem|3|4|| |consignmentPosition|3|7|| |barcode|35|10|| |referenceQualifier|3|45|Repeating 5 times. Not numbered!| |referenceNumber|35|48||
G00 - Consignment Sums
|Field reference|Length|From| |—————|—–:|—:| |recordType|3|1| |sequentialWaybillItem|3|4| |consignmentNumberSendingDepot|35|7| |actualConsignmentGrossWeightInKg|9|42| |deliveryTerm|3|51| |directDelivery|1|54| |pickupDate|8|55| |pickupTimeFrom|4|63| |pickupTimeTo|4|67| |logisticsModel|6|71| |consignmentNumberReceivingDepot|35|77| |consignorIdOriginalWaybill|35|112| |consigneeIdOriginalWaybill|35|147| |materialGroup|3|182| |goodsValue|11|185| |currencyOfGoodsValue|3|196| |chargeableConsignmentWeightInKg|9|199| |cubicMeters|5|208| |loadingMeters|3|213| |numberOfPalletLocations|4|216| |numberOfAdditionalLoadingTools1|2|220| |packagingTypeForAdditionalLoadingTools1|3|222| |numberOfAdditionalLoadingTools2|2|225| |packagingTypeForAdditionalLoadingTools2|3|227| |directPickupCode|1|230| |orderDate|8|231|
H00 - Text Codes
|Field reference|Length|From|Notes| |—————|—–:|—:|—-| |recordType|3|1|| |sequentialWaybillItem|3|4|| |textCode[n]|3|7|Repeted 6 times| |additionalText[n]|35|10||
H10 - Individual Texts
|Field reference|Length|From|Notes| |—————|—–:|—:|—-| |recordType|3|1|| |sequentialWaybillItem|3|4|| |textQualifier[n]|3|7|Repeated 3 times| |text[n]|70|10||
I00 - Service Types
|Field reference|Length|From|Notes| |—————|—–:|—:|—-| |recordType|3|1|| |sequentialWaybillItem|3|4|| |serviceType[n]|3|7|Repeated 10 times| |taxCode[n]|1|10|| |amount[n]|9|19||
J00 - Consignment Data Sums
|Field reference|Length|From| |—————|—–:|—:| |recordType|3|1| |totalNumberOfConsignments|3|4| |totalNumberOfPackages|6|7| |actualGrossWeightInKg|9|13| |numberOfBoxPallets|4|22| |numberOfEuroFlatPallets|4|26| |numberOfAdditionalLoadingToolsFP|4|30| |numberOfAdditionalLoadingToolsBP|4|34| |totalsTaxable|11|38| |totalsNotTaxable|11|49| |totalsOfProductValueCOD|11|60| |totalsOfCustoms|11|71| |totalsOfImportTurnoverTax|11|82| |totalsOfValueAddedTax|11|93|
Z00 - Control Record
|Field reference|Length|From| |—————|—–:|—:| |recordType|3|1| |recordNumber|6|4| |dateOfCreation|8|10| |timeOfCreation|6|18|
@@PT - Trailer Record
Contains no data.
Appendix 3. Sample Conizi Format Manifest File
The below sample conizi format manifest message was created based on a real life sample. All the addresses, company names, ids, reference numbers were replaced with random / sample values.
This sample can be used to get a hint on how the resulting file should look like after the conversion from FORTRAS format.
{
"$schema" : "https:\/\/raw.githubusercontent.com\/conizi\/semantic-model\/master\/transport\/truck\/groupage\/forwarding\/manifest",
"manifestId": "123456",
"manifestType": "STD",
"shippingDate": "2018-08-15",
"transportType": "L",
"sender": {
"ediId": "EDDI001"
},
"receiver": {
"ediId": "EDIREC001"
},
"network": {
"networkId": "NET",
"codelist": "CL",
"product": "SY"
},
"isPreAdvice": false,
"shippingPartner": {
"partnerId": "9999"
},
"receivingPartner": {
"partnerId": "9988"
},
"carrier": {
"name": "CARRIER SPEDITION LTD",
"countryCode": "DE",
"zipCode": "989898",
"city": "BERLIN"
},
"vehicles": [{
"registration": "KGM 787"
},
{
"registration": "JTH 701"
}],
"loadUnits": [{
"identification": ".",
"seals": [{
"code": "123456789012365498"
}]
}],
"additionalLoadingEquipment": {
"eurPallets": 9,
"eurBoxes": 0
},
"lines": [{
"lineNo": 1,
"consignment": {
"$schema" : "https:\/\/raw.githubusercontent.com\/conizi\/semantic-model\/master\/transport\/truck\/groupage\/forwarding\/consignment",
"consignmentNoShippingPartner": "01234555555",
"consignmentNoReceivingPartner": "",
"shippingDate": "2019-08-15",
"sender": {
"ediId": "EDDI001"
},
"receiver": {
"ediId": "EDIREC001"
},
"shippingPartner": {
"partnerId": "9999"
},
"receivingPartner": {
"partnerId": "9988"
},
"information": {
"remarksGeneral": [
"FIX 16.08.; BIS 12 UHR; HB+HUBW.; 0172-3584781 HR. SCHMIDT"]
},
"services": {
"timeOptions": {
"nextDay": {
"timeFrom": "12:00",
"timeUntil": "12:00"
}
},
"deliveryOptions": {
"liftingPlatform": true,
"deliveryNoteOnGoods": true
}
},
"references": {
"customerOrderNo": "3216549871"
},
"billing": {
"deliveryTerms": "100"
},
"routing": {
"shipper": {
"name": "SAMPLE SHIPPER LTD",
"street": "Am Alten Bahnhof 8",
"countryCode": "DE",
"zipCode": "97332",
"city": "Volkach",
"townArea": "",
"reference": "33066"
},
"consignee": {
"name": "MUSTER CONSIGNEE GMBH",
"street": "BAHNHOF. 8",
"countryCode": "DE",
"zipCode": "97333",
"city": "Volkach",
"townArea": "",
"reference": ""
}
},
"content": {
"volumeCubicmeter": 0,
"loadingMeter": 0,
"grossWeightKilogram": 1103,
"areaPalletBays": 0,
"chargeableWeightKilogram": 0,
"insuranceValue": {
"amount": 0,
"currency": ""
},
"lines": [{
"lineNo": 1,
"handlingUnitCount": 2,
"handlingUnitType": "FP",
"innerPackageCount": 44,
"innerPackageType": "SA",
"content": "PCI PRODUKTE",
"refNo": "123456789987456321",
"volumeCubicmeter": 0,
"loadingMeter": 0,
"grossWeightKilogram": 1103,
"areaPalletBays": 0,
"chargeableWeightKilogram": 0,
"lengthMeter": 0,
"widthMeter": 0,
"heightMeter": 0,
"barcodes": [{
"code": "00123456789987456321"
},
{
"code": "00123456789987456300"
}]
},
{
"lineNo": 2,
"handlingUnitCount": 0,
"innerPackageCount": 0,
"innerPackageType": "",
"content": "PCI PRODUKTE",
"refNo": "123456789987456301",
"volumeCubicmeter": 0,
"loadingMeter": 0,
"grossWeightKilogram": 0,
"areaPalletBays": 0,
"chargeableWeightKilogram": 0,
"lengthMeter": 0,
"widthMeter": 0,
"heightMeter": 0,
"barcodes": []
}]
}
}
},
{
"lineNo": 2,
"consignment": {
"$schema" : "https:\/\/raw.githubusercontent.com\/conizi\/semantic-model\/master\/transport\/truck\/groupage\/forwarding\/consignment",
"consignmentNoShippingPartner": "0123456789987",
"consignmentNoReceivingPartner": "",
"shippingDate": "2018-08-15",
"sender": {
"ediId": "EDDI001"
},
"receiver": {
"ediId": "EDIREC001"
},
"shippingPartner": {
"partnerId": "9999"
},
"receivingPartner": {
"partnerId": "9988"
},
"information": {
"remarksGeneral": [
"WA: MO-DO 9-12 UHR + 13-14:30 UHR \/ FR 9-10:30 UHR LT 16.08.20",
"18"]
},
"services": {
"timeOptions": {
"fixedDay": {
"date": "2018-08-16"
}
},
"deliveryOptions": {
"deliveryNoteOnGoods": true
}
},
"references": {
"customerOrderNo": "321654987"
},
"billing": {
"deliveryTerms": "100"
},
"routing": {
"shipper": {
"name": "TEST SHIPPER GMBH",
"street": "MUSTERWEG 16",
"countryCode": "DE",
"zipCode": "32654",
"city": "TEST",
"townArea": "",
"reference": "33068"
},
"consignee": {
"name": "SAMPLE CONSIGNEE GMBH",
"x-name2": "",
"x-name3": "",
"street": "SAMPLE STR. 20",
"countryCode": "DE",
"zipCode": "321654",
"city": "NUERNBERG",
"townArea": "",
"reference": ""
}
},
"content": {
"volumeCubicmeter": 0,
"loadingMeter": 0,
"grossWeightKilogram": 4712,
"areaPalletBays": 0,
"chargeableWeightKilogram": 0,
"insuranceValue": {
"amount": 0,
"currency": ""
},
"lines": [{
"lineNo": 1,
"handlingUnitCount": 5,
"handlingUnitType": "FP",
"innerPackageCount": 0,
"innerPackageType": "",
"content": "PCI PRODUKTE",
"refNo": "3216549876544444",
"volumeCubicmeter": 0,
"loadingMeter": 0,
"grossWeightKilogram": 4712,
"areaPalletBays": 0,
"chargeableWeightKilogram": 0,
"lengthMeter": 0,
"widthMeter": 0,
"heightMeter": 0,
"barcodes": [{
"code": "00112255566655555588"
},
{
"code": "00112255566655555599"
},
{
"code": "00112255566655555544"
},
{
"code": "00112255566655555533"
},
{
"code": "00112255566655555522"
}]
},
{
"lineNo": 2,
"handlingUnitCount": 0,
"innerPackageCount": 0,
"innerPackageType": "",
"content": "DIVERSE WAREN",
"refNo": "321654987444",
"volumeCubicmeter": 0,
"loadingMeter": 0,
"grossWeightKilogram": 0,
"areaPalletBays": 0,
"chargeableWeightKilogram": 0,
"lengthMeter": 0,
"widthMeter": 0,
"heightMeter": 0,
"barcodes": []
}]
}
}
},
{
"lineNo": 3,
"consignment": {
"$schema" : "https:\/\/raw.githubusercontent.com\/conizi\/semantic-model\/master\/transport\/truck\/groupage\/forwarding\/consignment",
"consignmentNoShippingPartner": "0123456789888",
"consignmentNoReceivingPartner": "",
"shippingDate": "2018-08-15",
"sender": {
"ediId": "EDDI001"
},
"receiver": {
"ediId": "EDIREC"
},
"shippingPartner": {
"partnerId": "9999"
},
"receivingPartner": {
"partnerId": "9988"
},
"information": {
"remarksGeneral": [
"FIX MIT HB BIS 12 UHR 0173-9986728 HR. SCHMIDT"]
},
"services": {
"timeOptions": {
"nextDay": {
"timeFrom": "12:00",
"timeUntil": "12:00"
}
},
"deliveryOptions": {
"liftingPlatform": true,
"deliveryNoteOnGoods": true
}
},
"references": {
"customerOrderNo": "3216547888"
},
"billing": {
"deliveryTerms": "100"
},
"routing": {
"shipper": {
"name": "SAMPLE SHIPPER GMBH",
"street": "BAHNHOF 16",
"countryCode": "DE",
"zipCode": "1236549",
"city": "MUENCHEN",
"townArea": "",
"reference": "889955"
},
"consignee": {
"name": "GRUNDSCHULE",
"street": "MUSTERWEG 21",
"countryCode": "DE",
"zipCode": "90999",
"city": "FRANKFURT",
"townArea": "",
"reference": ""
}
},
"content": {
"volumeCubicmeter": 0,
"loadingMeter": 0,
"grossWeightKilogram": 2106,
"areaPalletBays": 0,
"chargeableWeightKilogram": 0,
"insuranceValue": {
"amount": 0,
"currency": ""
},
"lines": [{
"lineNo": 1,
"handlingUnitCount": 2,
"handlingUnitType": "FP",
"innerPackageCount": 84,
"innerPackageType": "SA",
"content": "PCI PRODUKTE",
"refNo": "32165498765411",
"volumeCubicmeter": 0,
"loadingMeter": 0,
"grossWeightKilogram": 2106,
"areaPalletBays": 0,
"chargeableWeightKilogram": 0,
"lengthMeter": 0,
"widthMeter": 0,
"heightMeter": 0,
"barcodes": [{
"code": "32165498765411000011"
},
{
"code": "32165498765411000012"
}]
}]
}
}
}]
}