IMOS - Report Designer: Tables and Columns for Voyage P&L
Voyage P&L image is found in “Voyage PnL Drilldown” table and “Voyage PnL detail” table.
Both tables has SNAPSHOT type and Snapshot Ref Date Local. So you can find the image of past voyage PnL.
Voyage PnL Drill down contains Operations View image with following column.
Vessel Code |
Voyage No |
Seq Seaquence of lines Voyage P&L screen from top. |
Is Line Item “True” : detail lines, “False” : Aggregated line such as “Revenue” and “Freight” |
Pnl Category Categories in Voyage P&L screen, sucg as “Revenue”, “Expense”, and “Running Cost” |
Description Description in line of voyage P&L |
Estimated Amount Base : Estimated column (Only Base currency) |
Actual Amount Base : Actual column (Only Base currency) |
Posted Amount Base : Posted column (Only Base currency) |
Paid Amount Base : Paid column (Only Base currency) |
Voyage PnL detail table has details of Estimated, Actual and Posted. The lines are separated by the data type, “E” for estimate, “A” for actual and “P” for posted.
Vessel Code |
Voyage No |
Data Type “E” for estimate, “A” for actual and “P” for posted |
Seq Sequence by data type. |
Pnl Category PnL Category |
Source Bill source |
Bill Code Bill code |
Sub Code Sub code |
Account Ledger code or business rule such as “VCST: INTHC” |
Description Description |
Accounting Date Accounting date of invoice |
Amount Curr Amount in currency |
Currency Currency |
Amount Base Amount in Base currency |
Exchange Rate Exchange rate |
Rate Base Rate of the amount. The column vary on the account code or business rule, such as hire rate for hire. |
Vendor Short Name Shortname of invoice vendor |
Vendor Type Addressbook type of the vendor, such as C for charter or O for Owner |
Cargo ID |
Cargo Short Name |
Company Code |