Data Dictionary
CRM
Customer relationship management source, replicated nightly into the lakehouse.
2 context items
dbo
customer
One row per customer account.
2 context items
customer_id
customer_name
vat_number
credit_limit
created_at
customer_address
Postal and visiting addresses per customer.
2 context items
address_id
customer_id
country_code
postal_code
customer_local_exception
Local overrides on customer master data.
exception_id
customer_id
reason_code
queryinsights
masterdata
Central master data warehouse for items, facilities and parties.
1 context items
dbo
item
Sellable and stockable items.
item_id
item_name
abc_class
status
item_facility
Item settings per facility.
item_id
facility_id
lead_time_days
facility
Warehouses, terminals and quays.
2 context items
facility_id
facility_name
quay_code
company_structure
Legal and organisational hierarchy.
1 context items
division_id
parent_division_id
company_code
_rsc
metagem-test-datasets
Sandbox datasets used for testing audit flows.
dbo
invoice_sample
Sampled invoices used in validity checks.
1 context items
invoice_id
amount
currency
issued_on
INSEE Sirene / Annuaire des entreprises
French national business register (open data): legal units and their establishments, keyed by SIREN / SIRET.
public
unite_legale
Legal units keyed by SIREN.
siren
denomination
date_creation
etablissement
Establishments keyed by SIRET.
siret
siren
code_postal
U4C 4.5 JI 004 Adding Charges to Customer Orders v2.1.docx
/knowledge-graph/ntc-unite-academy · 35 elements · ingested 2026-08-31
U4C 4.1 JI 005 Customer Assortments v2.0.docx
/knowledge-graph/ntc-unite-academy · 50 elements · ingested 2026-08-31
U4C 4.5 JI 007 Print Order Confirmation v3.docx
/knowledge-graph/ntc-unite-academy · 26 elements · ingested 2026-08-31
SAL CD_4.1 - Adding and editing customers.docx
/knowledge-graph/ntc-unite-academy · 192 elements · ingested 2026-08-31
SAL 4 1 JI 002 Check Customer Data v1.3.docx
/knowledge-graph/ntc-unite-academy · 163 elements · ingested 2026-08-31
Unite BBP_4.1 Adding-editing customer.docx
/knowledge-graph/ntc-unite-academy · 27 elements · ingested 2026-08-31
U4C 4.5 JI 013 Charge only Orders v2.0.docx
/knowledge-graph/ntc-unite-academy · 25 elements · ingested 2026-08-31
Unite BBP_4.5 Customer Order Entry.docx
/knowledge-graph/ntc-unite-academy · 30 elements · ingested 2026-08-31
OECD — Tax Identification Numbers, France
registry://oecd-tin · 9 elements · ingested 2026-09-09
Port Regulations - General Terms v7.pdf
/knowledge-graph/port-regulations · 118 elements · ingested 2026-09-02
3 context items
Drone Operations Handbook v3.docx
/knowledge-graph/drone-operations · 44 elements · ingested 2026-09-04
1 context items
Terminal Handbook - Cleaning & Handling v2.docx
/knowledge-graph/terminal-handbook · 76 elements · ingested 2026-08-15
2 context items
IMDG substance register export 2026-08.xlsx
registry://imdg-substances · 212 elements · ingested 2026-08-27