Categories
Releases SQL

Release Request Data via SQL Native

The CM_BulkRelease class and its features are now available to extract to an SQL Native database. The SQL table name is BulkRelease.
Requested data fields are mapped as follows;

  • Request Date – dateRequested
  • Estimated Required Date – dateEstimatedRequired
  • Booking Confirmation Number – bookingConfirmation
  • Release No – code
  • Operator – myOperator
  • Freight Payer Code – freightPayerCode
  • Consignee – myConsignee
  • Total Requested – getTotalRequested
  • ISO Type – getISOCode
  • Availability Grade – getAvailabilityGrades
  • Voyage – myVoyage
  • Load Port – myLoadPort
  • PIN No – getPinNumber
  • Cargo Remarks – getCargoRemarks
  • Heavy Duty – getHeavyDuty
  • Sub-Terminal – mySubTerminal
  • Type – getTypeDescription
  • Voyage Arrival – getVoyageArrival
  • ISO Group – getISOGroup
  • Status – statusString
  • Outstanding – getTotalOutstanding
You can export this data using the Data Export Maintenance functionality under System Items.

Leave a Reply

Your email address will not be published. Required fields are marked *