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;
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.