Constraints On Dates (feature)

From UG

Revision as of 20:34, 11 January 2010 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 20:47, 11 January 2010 (edit) (undo) Alex (Talk | contribs) (→User Interface and Functionality) Newer edit →
Line 27:		Line 27:
	<pre>		<pre>
-	--- AIR
-	[I] [COLLECTION EVENT] (Est / Act) Pick-up date:	+	*** AIR ***
-	[M] [DEPARTURE EVENT ] (Est / Act) Airport of Departure:	+	[I] [----------------] (     Act) Created on Date
		+	[I] [----------------] (      Act) Notification Date
		+	[I] [----------------] (      Act) Authorized on
-	[M] [----------------] (Est / Act) Trans-shipment Airport:	+	[I] [COLLECTION EVENT] (Est / Act) Pick-up date
-	[M] [ARRIVAL EVENT   ] (Est / Act) Airport of Discharge:	+	[M] [DEPARTURE EVENT ] (Est / Act) Airport of Departure
-	[I] [----------------] (     Act) Customs Status Date:	+	[M] [----------------] (Est / Act) Trans-shipment Airport
-	[I] [----------------] (     Act) FDA Status Date:	+	[M] [ARRIVAL EVENT  ] (Est / Act) Airport of Discharge
-	[I] [DELIVERY EVENT  ] (Est / Act) Delivery Date:	+	[I] [----------------] (      Act) Customs Status Date
		+	[I] [----------------] (      Act) FDA Status Date
		+
		+	[I] [DELIVERY EVENT  ] (Est / Act) Delivery Date
		+
		+	*** LCL/FCL ***
		+
		+	[I] [----------------] (      Act) Created on Date
		+	[I] [----------------] (      Act) Notification Date
		+	[I] [----------------] (      Act) Authorized on
		+
		+	[I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container 1
		+	[I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container 2 (FCL only)
		+	...
		+	[I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container N (FCL only)
		+
		+	[M] [DEPARTURE EVENT ] (Est / Act) Origin Terminal
		+	[M] [--------------- ] (Est / Act) Port Of Loading
		+	[M] [----------------] (Est / Act) Port Of Trans-shipment
		+	[M] [----------------] (Est / Act) Port Of Discharge
		+	[M] [ARRIVAL EVENT  ] (Est / Act) Destination Terminal
		+
		+	[I] [----------------] (      Act) Customs Status Date
		+	[I] [----------------] (      Act) FDA Status Date
		+
		+	[I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container 1
		+	[I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container 2 (FCL only)
		+	...
		+	[I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container N (FCL only)
	</pre>		</pre>

---

Revision as of 20:47, 11 January 2010

Contents 1 Parent Mantis 2 Business Need 3 Requirements 4 Technical Specification 4.1 Summary 4.2 User Interface and Functionality 4.2.1 Actual Date can not be a future date 4.3 Entities and Attributes 4.4 Special Cases and Misc 4.5 Look And Feel 4.6 Figures 4.6.1 Figure: XXX 5 History 6 Non Critical Bugs and RFC 7 DB

Parent Mantis

tbd

Business Need

We have a number of constraints / validation rules that we need to enforce for dates.

Requirements

All detailed requirements have been translated into specifications - see below.

Technical Specification

Summary

List of constraints on dates:

• # Order Constraint based on shipment's path
• # Order Constraint based on pre-conditions
• # Actual Date can not be a future date Constraint

User Interface and Functionality

Overview of dates and their properties:

*** AIR ***

[I] [----------------] (      Act) Created on Date
[I] [----------------] (      Act) Notification Date
[I] [----------------] (      Act) Authorized on

[I] [COLLECTION EVENT] (Est / Act) Pick-up date 

[M] [DEPARTURE EVENT ] (Est / Act) Airport of Departure 

[M] [----------------] (Est / Act) Trans-shipment Airport 

[M] [ARRIVAL EVENT   ] (Est / Act) Airport of Discharge 

[I] [----------------] (      Act) Customs Status Date 
[I] [----------------] (      Act) FDA Status Date 

[I] [DELIVERY EVENT  ] (Est / Act) Delivery Date 

*** LCL/FCL ***

[I] [----------------] (      Act) Created on Date
[I] [----------------] (      Act) Notification Date
[I] [----------------] (      Act) Authorized on

[I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container 1 
[I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container 2 (FCL only)
... 
[I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container N (FCL only)

[M] [DEPARTURE EVENT ] (Est / Act) Origin Terminal
[M] [--------------- ] (Est / Act) Port Of Loading
[M] [----------------] (Est / Act) Port Of Trans-shipment
[M] [----------------] (Est / Act) Port Of Discharge
[M] [ARRIVAL EVENT   ] (Est / Act) Destination Terminal

[I] [----------------] (      Act) Customs Status Date 
[I] [----------------] (      Act) FDA Status Date 

[I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container 1 
[I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container 2 (FCL only) 
...
[I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container N (FCL only) 

Actual Date can not be a future date

List of actual dates in the system:

UNDEF:

• Gentab.Actual export pickup

Truck-Dom:

• Gentab.Actual export pickup
• Gentab.Actual Delivery

Truck-Air:

• Gentab.Actual export pickup
• Gentab.Actual Delivery

Truck-Ocn:

• Conttab.Containers.ContainerX.Actual collection
• Conttab.Containers.ContainerX.Actual Delivery

AIR:

Gentab:

• Actual export pickup

Exptab:

• Airport of Departure. ATD
• Trans-shipment Airport.ATD
• Airport Of Destination. ATD

ImpTab:

• Actual Delivery Date

LCL:

Gentab:

• Actual export pickup

Exptab:

• Origin Terminal ATD
• Port Of Loading ATD
• Port Of Trans-shipment ATA
• Port Of Discharge ATA
• Destination Terminal ATA

ImpTab:

• Actual Delivery Date

FCL:

Conttab.Containers:

• ContainerX.Actual collection
• ContainerX.Actual Delivery

Exptab:

• Origin Terminal ATD
• Port Of Loading ATD
• Port Of Trans-shipment ATA
• Port Of Discharge ATA
• Destination Terminal ATA

Entities and Attributes

Special Cases and Misc

Look And Feel

Figures

Figure: XXX

History

Non Critical Bugs and RFC

DB