Database Answers Container Shipping
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Container Shipping 
Back to the Data Model.
The Area being Modelled is :-
Container Shipping

Glossary of Terms
Appendix B: All services, fees and surcharges

Charge Code 	Charge Description
AMF - Transport Document Amendment Fee  The fee assessed for Transport Documents amended at the request of the shipper, consignee or their agent
BAF - Bunker Adjustment Factor  	The surcharge associated with vessel fuel cost
BAS - Basis ocean freight  	        The charge associated with ocean transport
BLF - Transport Document Issuance Fee  	The fee assessed with the issuance Transport Documents
CAF - Currency Adjustment Factor  	The charge associated with fluctuations in exchange rates
CAM - Cargo Declaration Amendment Fee  	The fee assessed amendment of cargo declarations electronically
CAP - Capatazia  	                The charge associated with specific costs at discharge or origin terminals in Brazil
Etc. ...

Business Rules have been drafted as an example :-
1. A Customer can have one or many Containers.
2. A Customer can place zero, one or many Orders.
3. An Order can consist of one  or many Containers.
4. An Order can consist of one  or many Shipment Legs.


© DataBase Answers Ltd. 2011
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map