S.no.

Field Name

Logic

1

Inspection needed every

If Equipment Type:

1. Portable Tank, then Inspection needed every = “2.5”

2. Chassis, then Inspection needed every =“1”

3. IBC, then Inspection needed every = “5”

4. Pressure Vessel, then Inspection needed every =“5”

2

Next pressure valve test date 

Next pressure valve test date  = Last Pressure Valve test date + 1 Year 

3

Rep. Val

Rep Val. = Stated Val. - (Stated Val. x Dep% x Age)

4

Adj Rep Val.

If Rep. Val. >= max dep, then Adj Rep Val = Rep. Val

Else Adj Rep Val = max dep value

5

Age

If Asset Type = Leased, then Age = Decimal value(Current Date - MFG Date)/365.25. 

ElseIf Asset Type = Owned, then Age = (Current Date - MFG Date)/365.25)

ElseIf Asset Type = NVOCC, Age = Blank

6

No. of Years on lease

If Asset Type = Owned. Field is blank

Else, (Current Date - Lease on Hire Date)/365.25 → Give number up to 2 decimal value

7

Transports Class 8 Goods

If the Product field is empty, then keep the field blank.

If the Product field has value, then if Hazard class = 8, then Transports Class 8 Goods = “Yes”. Else, “No”

Will be Triggered - Whenever the product against the asset is changed

8

NVOCC Return Date

If Status = Active, then keep the field empty

Else, Mention the date on which the Status was market InActive