Data modeling of a FCR and a Warehouse Receipt

Data diagram


Data modeling of a BL, AWL, CMR, …

Data diagram


Forwarder’s Certificate of Receipt - FCR

Actors and purpose of the document

Signatory
Texte

Recipient

Purpose of the document

Format de la FIATA

Proposal of data model

Data dictionary

Name Type Mandatory / Optionnal Description

Standard JSON

{
"version":1,
"document-type":"fcr",
"document-id":12345,
"issuing-date":"2017-12-31",
"remarks":"...",
"signatory": {
    "signatory-firstname": "...",
    "signatory-name": "...",
    "signatory-title": "...",
    "signatory-company-name": "...",
    "signatory-company-tax-id": "...",
    "signatory-company-address": {
        "signatory-company-address-line-1": "...",
        "signatory-company-address-line-2": "...",
        "signatory-company-postal-code": "...",
        "signatory-company-city": "...",
        "signatory-company-country": "..."
    },
    "signatory-company-contact": {
        "signatory-company-logo-url": "...",
        "signatory-company-website": "..." ,
        "signatory-company-email-address": "...",
        "signatory-company-phone-number": "..."
    }
},
"forwarder": {
    "forwarder-name": "...",
    "forwarder-tax-id": "...",
    "forwarder-address": {
        "forwarder-address-line-1": "...",
        "forwarder-address-line-2": "...",
        "forwarder-postal-code": "...",
        "forwarder-city": "...",
        "forwarder-country": "..."
    },
    "forwarder-signatory": {
        "forwarder-signatory-firstname": "...",
        "forwarder-signatory-name": "..." ,
        "forwarder-signatory-title": "...",
        "forwarder-signatory-contact": {
            "forwarder-signatory-email-address": "...",
            "forwarder-signatory-phone-number": "..."
        }
    },
    "forwarder-contact": {
        "forwarder-logo-url": "...",
        "forwarder-website": "..." ,
        "forwarder-email-address": "...",
        "forwarder-phone-number": "..."
    }
},
"supplier": {
    "supplier-name": "...",
    "supplier-tax-id": "...",
    "supplier-address": {
        "supplier-address-line-1": "...",
        "supplier-address-line-2": "...",
        "supplier-postal-code": "...",
        "supplier-city": "...",
        "supplier-country": "..."
    },
    "supplier-contact": {
        "supplier-logo-url": "...",
        "supplier-website": "..." ,
        "supplier-email-address": "...",
        "supplier-phone-number": "..."
    }
},
"consignee": {
    "consignee-name": "...",
    "consignee-tax-id": "...",
    "consignee-address": {
        "consignee-address-line-1": "...",
        "consignee-address-line-2": "...",
        "consignee-postal-code": "...",
        "consignee-city": "...",
        "consignee-country": "..."
    },
    "consignee-contact": {
        "consignee-logo-url": "...",
        "consignee-website": "..." ,
        "consignee-email-address": "...",
        "consignee-phone-number": "..."
    }
},
"facility-administrator": {
    "facility-administrator-name": "...",
    "facility-administrator-tax-id": "...",
    "facility-administrator-address": {
        "facility-administrator-address-line-1": "...",
        "facility-administrator-address-line-2": "...",
        "facility-administrator-postal-code": "...",
        "facility-administrator-city": "...",
        "facility-administrator-country": "..."
    },
    "facility-administrator-contact": {
        "facility-administrator-logo-url": "...",
        "facility-administrator-website": "..." ,
        "facility-administrator-email-address": "...",
        "facility-administrator-phone-number": "..."
    }
},
"storage": {
    "place-of-storage": "...",
    "quantity-number": "...",
    "quantity-measure": "...",
    "description-of-the-good": "...",
    "located-at": "..."
}
}

Warehouse Receipt - WR

Actors and purpose of the document

Signatory : The warehouse keeper

Recipient : The owner of the goods/commodity and its investors (funds and banks).

Purpose of the document : This document ensure the depository, according the warehouse keeper, that a quantity of goods is present in a specific warehouse. This document enable to justify, later, the release of the goods, for a BL for example. The WR also is an important financial document because it justify the initial value of the goods, at the starting location.

Format de la FIATA

Proposal of data model

Data dictionary

Name Type Mandatory / Optionnal Description

Standard JSON

{
"version":1,
"document-type":"fwr",
"document-id":12345,
"issuing-date":"2017-12-31",
"remarks":"...",
"signatory": {
    "signatory-firstname": "...",
    "signatory-name": "...",
    "signatory-title": "...",
    "signatory-company-name": "...",
    "signatory-company-tax-id": "...",
    "signatory-company-address": {
        "signatory-company-address-line-1": "...",
        "signatory-company-address-line-2": "...",
        "signatory-company-postal-code": "...",
        "signatory-company-city": "...",
        "signatory-company-country": "..."
    },
    "signatory-company-contact": {
        "signatory-company-logo-url": "...",
        "signatory-company-website": "..." ,
        "signatory-company-email-address": "...",
        "signatory-company-phone-number": "..."
    }
},
"forwarder": {
    "forwarder-name": "...",
    "forwarder-tax-id": "...",
    "forwarder-address": {
        "forwarder-address-line-1": "...",
        "forwarder-address-line-2": "...",
        "forwarder-postal-code": "...",
        "forwarder-city": "...",
        "forwarder-country": "..."
    },
    "forwarder-signatory": {
        "forwarder-signatory-firstname": "...",
        "forwarder-signatory-name": "..." ,
        "forwarder-signatory-title": "...",
        "forwarder-signatory-contact": {
            "forwarder-signatory-email-address": "...",
            "forwarder-signatory-phone-number": "..."
        }
    },
    "forwarder-contact": {
        "forwarder-logo-url": "...",
        "forwarder-website": "..." ,
        "forwarder-email-address": "...",
        "forwarder-phone-number": "..."
    }
},
"supplier": {
    "supplier-name": "...",
    "supplier-tax-id": "...",
    "supplier-address": {
        "supplier-address-line-1": "...",
        "supplier-address-line-2": "...",
        "supplier-postal-code": "...",
        "supplier-city": "...",
        "supplier-country": "..."
    },
    "supplier-contact": {
        "supplier-logo-url": "...",
        "supplier-website": "..." ,
        "supplier-email-address": "...",
        "supplier-phone-number": "..."
    }
},
"consignee": {
    "consignee-name": "...",
    "consignee-tax-id": "...",
    "consignee-address": {
        "consignee-address-line-1": "...",
        "consignee-address-line-2": "...",
        "consignee-postal-code": "...",
        "consignee-city": "...",
        "consignee-country": "..."
    },
    "consignee-contact": {
        "consignee-logo-url": "...",
        "consignee-website": "..." ,
        "consignee-email-address": "...",
        "consignee-phone-number": "..."
    }
},
"facility-administrator": {
    "facility-administrator-name": "...",
    "facility-administrator-tax-id": "...",
    "facility-administrator-address": {
        "facility-administrator-address-line-1": "...",
        "facility-administrator-address-line-2": "...",
        "facility-administrator-postal-code": "...",
        "facility-administrator-city": "...",
        "facility-administrator-country": "..."
    },
    "facility-administrator-contact": {
        "facility-administrator-logo-url": "...",
        "facility-administrator-website": "..." ,
        "facility-administrator-email-address": "...",
        "facility-administrator-phone-number": "..."
    }
},
"storage": {
    "place-of-storage": "...",
    "quantity-number": "...",
    "quantity-measure": "...",
    "description-of-the-good": "...",
    "located-at": "..."
}
}

Air Way Bill - AWB

Actors and purpose of the document

Signatory :

Recipient :

Purpose of the document :

Format d’un AWB

Proposal of data model

Data dictionary

Name Type Mandatory / Optionnal Description

Standard JSON

{
"version":1,
"document-type":"fcr",
"document-id":12345,
"issuing-date":"2017-12-31",
"remarks":"...",
"signatory": {
    "signatory-firstname": "...",
    "signatory-name": "...",
    "signatory-title": "...",
    "signatory-company-name": "...",
    "signatory-company-tax-id": "...",
    "signatory-company-address": {
        "signatory-company-address-line-1": "...",
        "signatory-company-address-line-2": "...",
        "signatory-company-postal-code": "...",
        "signatory-company-city": "...",
        "signatory-company-country": "..."
    },
    "signatory-company-contact": {
        "signatory-company-logo-url": "...",
        "signatory-company-website": "..." ,
        "signatory-company-email-address": "...",
        "signatory-company-phone-number": "..."
    }
},
"forwarder": {
    "forwarder-name": "...",
    "forwarder-tax-id": "...",
    "forwarder-address": {
        "forwarder-address-line-1": "...",
        "forwarder-address-line-2": "...",
        "forwarder-postal-code": "...",
        "forwarder-city": "...",
        "forwarder-country": "..."
    },
    "forwarder-signatory": {
        "forwarder-signatory-firstname": "...",
        "forwarder-signatory-name": "..." ,
        "forwarder-signatory-title": "...",
        "forwarder-signatory-contact": {
            "forwarder-signatory-email-address": "...",
            "forwarder-signatory-phone-number": "..."
        }
    },
    "forwarder-contact": {
        "forwarder-logo-url": "...",
        "forwarder-website": "..." ,
        "forwarder-email-address": "...",
        "forwarder-phone-number": "..."
    }
},
"supplier": {
    "supplier-name": "...",
    "supplier-tax-id": "...",
    "supplier-address": {
        "supplier-address-line-1": "...",
        "supplier-address-line-2": "...",
        "supplier-postal-code": "...",
        "supplier-city": "...",
        "supplier-country": "..."
    },
    "supplier-contact": {
        "supplier-logo-url": "...",
        "supplier-website": "..." ,
        "supplier-email-address": "...",
        "supplier-phone-number": "..."
    }
},
"consignee": {
    "consignee-name": "...",
    "consignee-tax-id": "...",
    "consignee-address": {
        "consignee-address-line-1": "...",
        "consignee-address-line-2": "...",
        "consignee-postal-code": "...",
        "consignee-city": "...",
        "consignee-country": "..."
    },
    "consignee-contact": {
        "consignee-logo-url": "...",
        "consignee-website": "..." ,
        "consignee-email-address": "...",
        "consignee-phone-number": "..."
    }
},
"facility-administrator": {
    "facility-administrator-name": "...",
    "facility-administrator-tax-id": "...",
    "facility-administrator-address": {
        "facility-administrator-address-line-1": "...",
        "facility-administrator-address-line-2": "...",
        "facility-administrator-postal-code": "...",
        "facility-administrator-city": "...",
        "facility-administrator-country": "..."
    },
    "facility-administrator-contact": {
        "facility-administrator-logo-url": "...",
        "facility-administrator-website": "..." ,
        "facility-administrator-email-address": "...",
        "facility-administrator-phone-number": "..."
    }
},
"storage": {
    "place-of-storage": "...",
    "quantity-number": "...",
    "quantity-measure": "...",
    "description-of-the-good": "...",
    "located-at": "..."
}
}

Bill of Lading - BL

Actors and purpose of the document

Signatory
Texte

Recipient

Purpose of the document
Le BL est signé par le Capitaine d’un vaisseau maritime et l’engage sur l’embarquement d’une marchandise, d’un port à un autre.
Ce document est daté du jour de départ du navire.
Il vaut titre au porteur = c’est la personne qui détient le document original qui peut demander la restituer de la marchandise au port d’arrivée.
Il est par défaut Negociable, signifiant qu’il peut être endossé, au nom d’un autre bénéficiaire.

Format de la FIATA

Proposal of data model

Data dictionary

Name Type Mandatory / Optionnal Description

Standard JSON

{
"version":1,
"document-type":"fcr",
"document-id":12345,
"issuing-date":"2017-12-31",
"remarks":"...",
"signatory": {
    "signatory-firstname": "...",
    "signatory-name": "...",
    "signatory-title": "...",
    "signatory-company-name": "...",
    "signatory-company-tax-id": "...",
    "signatory-company-address": {
        "signatory-company-address-line-1": "...",
        "signatory-company-address-line-2": "...",
        "signatory-company-postal-code": "...",
        "signatory-company-city": "...",
        "signatory-company-country": "..."
    },
    "signatory-company-contact": {
        "signatory-company-logo-url": "...",
        "signatory-company-website": "..." ,
        "signatory-company-email-address": "...",
        "signatory-company-phone-number": "..."
    }
},
"forwarder": {
    "forwarder-name": "...",
    "forwarder-tax-id": "...",
    "forwarder-address": {
        "forwarder-address-line-1": "...",
        "forwarder-address-line-2": "...",
        "forwarder-postal-code": "...",
        "forwarder-city": "...",
        "forwarder-country": "..."
    },
    "forwarder-signatory": {
        "forwarder-signatory-firstname": "...",
        "forwarder-signatory-name": "..." ,
        "forwarder-signatory-title": "...",
        "forwarder-signatory-contact": {
            "forwarder-signatory-email-address": "...",
            "forwarder-signatory-phone-number": "..."
        }
    },
    "forwarder-contact": {
        "forwarder-logo-url": "...",
        "forwarder-website": "..." ,
        "forwarder-email-address": "...",
        "forwarder-phone-number": "..."
    }
},
"supplier": {
    "supplier-name": "...",
    "supplier-tax-id": "...",
    "supplier-address": {
        "supplier-address-line-1": "...",
        "supplier-address-line-2": "...",
        "supplier-postal-code": "...",
        "supplier-city": "...",
        "supplier-country": "..."
    },
    "supplier-contact": {
        "supplier-logo-url": "...",
        "supplier-website": "..." ,
        "supplier-email-address": "...",
        "supplier-phone-number": "..."
    }
},
"consignee": {
    "consignee-name": "...",
    "consignee-tax-id": "...",
    "consignee-address": {
        "consignee-address-line-1": "...",
        "consignee-address-line-2": "...",
        "consignee-postal-code": "...",
        "consignee-city": "...",
        "consignee-country": "..."
    },
    "consignee-contact": {
        "consignee-logo-url": "...",
        "consignee-website": "..." ,
        "consignee-email-address": "...",
        "consignee-phone-number": "..."
    }
},
"facility-administrator": {
    "facility-administrator-name": "...",
    "facility-administrator-tax-id": "...",
    "facility-administrator-address": {
        "facility-administrator-address-line-1": "...",
        "facility-administrator-address-line-2": "...",
        "facility-administrator-postal-code": "...",
        "facility-administrator-city": "...",
        "facility-administrator-country": "..."
    },
    "facility-administrator-contact": {
        "facility-administrator-logo-url": "...",
        "facility-administrator-website": "..." ,
        "facility-administrator-email-address": "...",
        "facility-administrator-phone-number": "..."
    }
},
"storage": {
    "place-of-storage": "...",
    "quantity-number": "...",
    "quantity-measure": "...",
    "description-of-the-good": "...",
    "located-at": "..."
}
}

CMR - Carriage Road

Actors and purpose of the document

Signatory
Texte

Recipient

Purpose of the document

Format de la FIATA

Proposal of data model

Data dictionary

Name Type Mandatory / Optionnal Description

Standard JSON

{
"version":1,
"document-type":"fcr",
"document-id":12345,
"issuing-date":"2017-12-31",
"remarks":"...",
"signatory": {
    "signatory-firstname": "...",
    "signatory-name": "...",
    "signatory-title": "...",
    "signatory-company-name": "...",
    "signatory-company-tax-id": "...",
    "signatory-company-address": {
        "signatory-company-address-line-1": "...",
        "signatory-company-address-line-2": "...",
        "signatory-company-postal-code": "...",
        "signatory-company-city": "...",
        "signatory-company-country": "..."
    },
    "signatory-company-contact": {
        "signatory-company-logo-url": "...",
        "signatory-company-website": "..." ,
        "signatory-company-email-address": "...",
        "signatory-company-phone-number": "..."
    }
},
"forwarder": {
    "forwarder-name": "...",
    "forwarder-tax-id": "...",
    "forwarder-address": {
        "forwarder-address-line-1": "...",
        "forwarder-address-line-2": "...",
        "forwarder-postal-code": "...",
        "forwarder-city": "...",
        "forwarder-country": "..."
    },
    "forwarder-signatory": {
        "forwarder-signatory-firstname": "...",
        "forwarder-signatory-name": "..." ,
        "forwarder-signatory-title": "...",
        "forwarder-signatory-contact": {
            "forwarder-signatory-email-address": "...",
            "forwarder-signatory-phone-number": "..."
        }
    },
    "forwarder-contact": {
        "forwarder-logo-url": "...",
        "forwarder-website": "..." ,
        "forwarder-email-address": "...",
        "forwarder-phone-number": "..."
    }
},
"supplier": {
    "supplier-name": "...",
    "supplier-tax-id": "...",
    "supplier-address": {
        "supplier-address-line-1": "...",
        "supplier-address-line-2": "...",
        "supplier-postal-code": "...",
        "supplier-city": "...",
        "supplier-country": "..."
    },
    "supplier-contact": {
        "supplier-logo-url": "...",
        "supplier-website": "..." ,
        "supplier-email-address": "...",
        "supplier-phone-number": "..."
    }
},
"consignee": {
    "consignee-name": "...",
    "consignee-tax-id": "...",
    "consignee-address": {
        "consignee-address-line-1": "...",
        "consignee-address-line-2": "...",
        "consignee-postal-code": "...",
        "consignee-city": "...",
        "consignee-country": "..."
    },
    "consignee-contact": {
        "consignee-logo-url": "...",
        "consignee-website": "..." ,
        "consignee-email-address": "...",
        "consignee-phone-number": "..."
    }
},
"facility-administrator": {
    "facility-administrator-name": "...",
    "facility-administrator-tax-id": "...",
    "facility-administrator-address": {
        "facility-administrator-address-line-1": "...",
        "facility-administrator-address-line-2": "...",
        "facility-administrator-postal-code": "...",
        "facility-administrator-city": "...",
        "facility-administrator-country": "..."
    },
    "facility-administrator-contact": {
        "facility-administrator-logo-url": "...",
        "facility-administrator-website": "..." ,
        "facility-administrator-email-address": "...",
        "facility-administrator-phone-number": "..."
    }
},
"storage": {
    "place-of-storage": "...",
    "quantity-number": "...",
    "quantity-measure": "...",
    "description-of-the-good": "...",
    "located-at": "..."
}
}

Forwarder’s Certificate of Transport - FCT

Actors and purpose of the document

Signatory
Texte

Recipient

Purpose of the document

Format de la FIATA

Proposal of data model

Data dictionary

Name Type Mandatory / Optionnal Description

Standard JSON

{
"version":1,
"document-type":"fcr",
"document-id":12345,
"issuing-date":"2017-12-31",
"remarks":"...",
"signatory": {
    "signatory-firstname": "...",
    "signatory-name": "...",
    "signatory-title": "...",
    "signatory-company-name": "...",
    "signatory-company-tax-id": "...",
    "signatory-company-address": {
        "signatory-company-address-line-1": "...",
        "signatory-company-address-line-2": "...",
        "signatory-company-postal-code": "...",
        "signatory-company-city": "...",
        "signatory-company-country": "..."
    },
    "signatory-company-contact": {
        "signatory-company-logo-url": "...",
        "signatory-company-website": "..." ,
        "signatory-company-email-address": "...",
        "signatory-company-phone-number": "..."
    }
},
"forwarder": {
    "forwarder-name": "...",
    "forwarder-tax-id": "...",
    "forwarder-address": {
        "forwarder-address-line-1": "...",
        "forwarder-address-line-2": "...",
        "forwarder-postal-code": "...",
        "forwarder-city": "...",
        "forwarder-country": "..."
    },
    "forwarder-signatory": {
        "forwarder-signatory-firstname": "...",
        "forwarder-signatory-name": "..." ,
        "forwarder-signatory-title": "...",
        "forwarder-signatory-contact": {
            "forwarder-signatory-email-address": "...",
            "forwarder-signatory-phone-number": "..."
        }
    },
    "forwarder-contact": {
        "forwarder-logo-url": "...",
        "forwarder-website": "..." ,
        "forwarder-email-address": "...",
        "forwarder-phone-number": "..."
    }
},
"supplier": {
    "supplier-name": "...",
    "supplier-tax-id": "...",
    "supplier-address": {
        "supplier-address-line-1": "...",
        "supplier-address-line-2": "...",
        "supplier-postal-code": "...",
        "supplier-city": "...",
        "supplier-country": "..."
    },
    "supplier-contact": {
        "supplier-logo-url": "...",
        "supplier-website": "..." ,
        "supplier-email-address": "...",
        "supplier-phone-number": "..."
    }
},
"consignee": {
    "consignee-name": "...",
    "consignee-tax-id": "...",
    "consignee-address": {
        "consignee-address-line-1": "...",
        "consignee-address-line-2": "...",
        "consignee-postal-code": "...",
        "consignee-city": "...",
        "consignee-country": "..."
    },
    "consignee-contact": {
        "consignee-logo-url": "...",
        "consignee-website": "..." ,
        "consignee-email-address": "...",
        "consignee-phone-number": "..."
    }
},
"facility-administrator": {
    "facility-administrator-name": "...",
    "facility-administrator-tax-id": "...",
    "facility-administrator-address": {
        "facility-administrator-address-line-1": "...",
        "facility-administrator-address-line-2": "...",
        "facility-administrator-postal-code": "...",
        "facility-administrator-city": "...",
        "facility-administrator-country": "..."
    },
    "facility-administrator-contact": {
        "facility-administrator-logo-url": "...",
        "facility-administrator-website": "..." ,
        "facility-administrator-email-address": "...",
        "facility-administrator-phone-number": "..."
    }
},
"storage": {
    "place-of-storage": "...",
    "quantity-number": "...",
    "quantity-measure": "...",
    "description-of-the-good": "...",
    "located-at": "..."
}
}

Sea Waybill - SWB

Actors and purpose of the document

Signatory
Texte

Recipient

Purpose of the document

Format de la FIATA

Proposal of data model

Data dictionary

Name Type Mandatory / Optionnal Description

Standard JSON

{
"version":1,
"document-type":"fcr",
"document-id":12345,
"issuing-date":"2017-12-31",
"remarks":"...",
"signatory": {
    "signatory-firstname": "...",
    "signatory-name": "...",
    "signatory-title": "...",
    "signatory-company-name": "...",
    "signatory-company-tax-id": "...",
    "signatory-company-address": {
        "signatory-company-address-line-1": "...",
        "signatory-company-address-line-2": "...",
        "signatory-company-postal-code": "...",
        "signatory-company-city": "...",
        "signatory-company-country": "..."
    },
    "signatory-company-contact": {
        "signatory-company-logo-url": "...",
        "signatory-company-website": "..." ,
        "signatory-company-email-address": "...",
        "signatory-company-phone-number": "..."
    }
},
"forwarder": {
    "forwarder-name": "...",
    "forwarder-tax-id": "...",
    "forwarder-address": {
        "forwarder-address-line-1": "...",
        "forwarder-address-line-2": "...",
        "forwarder-postal-code": "...",
        "forwarder-city": "...",
        "forwarder-country": "..."
    },
    "forwarder-signatory": {
        "forwarder-signatory-firstname": "...",
        "forwarder-signatory-name": "..." ,
        "forwarder-signatory-title": "...",
        "forwarder-signatory-contact": {
            "forwarder-signatory-email-address": "...",
            "forwarder-signatory-phone-number": "..."
        }
    },
    "forwarder-contact": {
        "forwarder-logo-url": "...",
        "forwarder-website": "..." ,
        "forwarder-email-address": "...",
        "forwarder-phone-number": "..."
    }
},
"supplier": {
    "supplier-name": "...",
    "supplier-tax-id": "...",
    "supplier-address": {
        "supplier-address-line-1": "...",
        "supplier-address-line-2": "...",
        "supplier-postal-code": "...",
        "supplier-city": "...",
        "supplier-country": "..."
    },
    "supplier-contact": {
        "supplier-logo-url": "...",
        "supplier-website": "..." ,
        "supplier-email-address": "...",
        "supplier-phone-number": "..."
    }
},
"consignee": {
    "consignee-name": "...",
    "consignee-tax-id": "...",
    "consignee-address": {
        "consignee-address-line-1": "...",
        "consignee-address-line-2": "...",
        "consignee-postal-code": "...",
        "consignee-city": "...",
        "consignee-country": "..."
    },
    "consignee-contact": {
        "consignee-logo-url": "...",
        "consignee-website": "..." ,
        "consignee-email-address": "...",
        "consignee-phone-number": "..."
    }
},
"facility-administrator": {
    "facility-administrator-name": "...",
    "facility-administrator-tax-id": "...",
    "facility-administrator-address": {
        "facility-administrator-address-line-1": "...",
        "facility-administrator-address-line-2": "...",
        "facility-administrator-postal-code": "...",
        "facility-administrator-city": "...",
        "facility-administrator-country": "..."
    },
    "facility-administrator-contact": {
        "facility-administrator-logo-url": "...",
        "facility-administrator-website": "..." ,
        "facility-administrator-email-address": "...",
        "facility-administrator-phone-number": "..."
    }
},
"storage": {
    "place-of-storage": "...",
    "quantity-number": "...",
    "quantity-measure": "...",
    "description-of-the-good": "...",
    "located-at": "..."
}
}

Certificate of Quantity

Actors and purpose of the document

Signatory
Texte

Recipient

Purpose of the document

Format de la FIATA

Proposal of data model

Data dictionary

Name Type Mandatory / Optionnal Description

Standard JSON

{
"version":1,
"document-type":"fcr",
"document-id":12345,
"issuing-date":"2017-12-31",
"remarks":"...",
"signatory": {
    "signatory-firstname": "...",
    "signatory-name": "...",
    "signatory-title": "...",
    "signatory-company-name": "...",
    "signatory-company-tax-id": "...",
    "signatory-company-address": {
        "signatory-company-address-line-1": "...",
        "signatory-company-address-line-2": "...",
        "signatory-company-postal-code": "...",
        "signatory-company-city": "...",
        "signatory-company-country": "..."
    },
    "signatory-company-contact": {
        "signatory-company-logo-url": "...",
        "signatory-company-website": "..." ,
        "signatory-company-email-address": "...",
        "signatory-company-phone-number": "..."
    }
},
"forwarder": {
    "forwarder-name": "...",
    "forwarder-tax-id": "...",
    "forwarder-address": {
        "forwarder-address-line-1": "...",
        "forwarder-address-line-2": "...",
        "forwarder-postal-code": "...",
        "forwarder-city": "...",
        "forwarder-country": "..."
    },
    "forwarder-signatory": {
        "forwarder-signatory-firstname": "...",
        "forwarder-signatory-name": "..." ,
        "forwarder-signatory-title": "...",
        "forwarder-signatory-contact": {
            "forwarder-signatory-email-address": "...",
            "forwarder-signatory-phone-number": "..."
        }
    },
    "forwarder-contact": {
        "forwarder-logo-url": "...",
        "forwarder-website": "..." ,
        "forwarder-email-address": "...",
        "forwarder-phone-number": "..."
    }
},
"supplier": {
    "supplier-name": "...",
    "supplier-tax-id": "...",
    "supplier-address": {
        "supplier-address-line-1": "...",
        "supplier-address-line-2": "...",
        "supplier-postal-code": "...",
        "supplier-city": "...",
        "supplier-country": "..."
    },
    "supplier-contact": {
        "supplier-logo-url": "...",
        "supplier-website": "..." ,
        "supplier-email-address": "...",
        "supplier-phone-number": "..."
    }
},
"consignee": {
    "consignee-name": "...",
    "consignee-tax-id": "...",
    "consignee-address": {
        "consignee-address-line-1": "...",
        "consignee-address-line-2": "...",
        "consignee-postal-code": "...",
        "consignee-city": "...",
        "consignee-country": "..."
    },
    "consignee-contact": {
        "consignee-logo-url": "...",
        "consignee-website": "..." ,
        "consignee-email-address": "...",
        "consignee-phone-number": "..."
    }
},
"facility-administrator": {
    "facility-administrator-name": "...",
    "facility-administrator-tax-id": "...",
    "facility-administrator-address": {
        "facility-administrator-address-line-1": "...",
        "facility-administrator-address-line-2": "...",
        "facility-administrator-postal-code": "...",
        "facility-administrator-city": "...",
        "facility-administrator-country": "..."
    },
    "facility-administrator-contact": {
        "facility-administrator-logo-url": "...",
        "facility-administrator-website": "..." ,
        "facility-administrator-email-address": "...",
        "facility-administrator-phone-number": "..."
    }
},
"storage": {
    "place-of-storage": "...",
    "quantity-number": "...",
    "quantity-measure": "...",
    "description-of-the-good": "...",
    "located-at": "..."
}
}

Certificate of Quality

Actors and purpose of the document

Signatory
Texte

Recipient

Purpose of the document

Format de la FIATA

Proposal of data model

Data dictionary

Name Type Mandatory / Optionnal Description

Standard JSON

{
"version":1,
"document-type":"fcr",
"document-id":12345,
"issuing-date":"2017-12-31",
"remarks":"...",
"signatory": {
    "signatory-firstname": "...",
    "signatory-name": "...",
    "signatory-title": "...",
    "signatory-company-name": "...",
    "signatory-company-tax-id": "...",
    "signatory-company-address": {
        "signatory-company-address-line-1": "...",
        "signatory-company-address-line-2": "...",
        "signatory-company-postal-code": "...",
        "signatory-company-city": "...",
        "signatory-company-country": "..."
    },
    "signatory-company-contact": {
        "signatory-company-logo-url": "...",
        "signatory-company-website": "..." ,
        "signatory-company-email-address": "...",
        "signatory-company-phone-number": "..."
    }
},
"forwarder": {
    "forwarder-name": "...",
    "forwarder-tax-id": "...",
    "forwarder-address": {
        "forwarder-address-line-1": "...",
        "forwarder-address-line-2": "...",
        "forwarder-postal-code": "...",
        "forwarder-city": "...",
        "forwarder-country": "..."
    },
    "forwarder-signatory": {
        "forwarder-signatory-firstname": "...",
        "forwarder-signatory-name": "..." ,
        "forwarder-signatory-title": "...",
        "forwarder-signatory-contact": {
            "forwarder-signatory-email-address": "...",
            "forwarder-signatory-phone-number": "..."
        }
    },
    "forwarder-contact": {
        "forwarder-logo-url": "...",
        "forwarder-website": "..." ,
        "forwarder-email-address": "...",
        "forwarder-phone-number": "..."
    }
},
"supplier": {
    "supplier-name": "...",
    "supplier-tax-id": "...",
    "supplier-address": {
        "supplier-address-line-1": "...",
        "supplier-address-line-2": "...",
        "supplier-postal-code": "...",
        "supplier-city": "...",
        "supplier-country": "..."
    },
    "supplier-contact": {
        "supplier-logo-url": "...",
        "supplier-website": "..." ,
        "supplier-email-address": "...",
        "supplier-phone-number": "..."
    }
},
"consignee": {
    "consignee-name": "...",
    "consignee-tax-id": "...",
    "consignee-address": {
        "consignee-address-line-1": "...",
        "consignee-address-line-2": "...",
        "consignee-postal-code": "...",
        "consignee-city": "...",
        "consignee-country": "..."
    },
    "consignee-contact": {
        "consignee-logo-url": "...",
        "consignee-website": "..." ,
        "consignee-email-address": "...",
        "consignee-phone-number": "..."
    }
},
"facility-administrator": {
    "facility-administrator-name": "...",
    "facility-administrator-tax-id": "...",
    "facility-administrator-address": {
        "facility-administrator-address-line-1": "...",
        "facility-administrator-address-line-2": "...",
        "facility-administrator-postal-code": "...",
        "facility-administrator-city": "...",
        "facility-administrator-country": "..."
    },
    "facility-administrator-contact": {
        "facility-administrator-logo-url": "...",
        "facility-administrator-website": "..." ,
        "facility-administrator-email-address": "...",
        "facility-administrator-phone-number": "..."
    }
},
"storage": {
    "place-of-storage": "...",
    "quantity-number": "...",
    "quantity-measure": "...",
    "description-of-the-good": "...",
    "located-at": "..."
}
}