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