IDX AutoInc NOT NULL,
xActivity Integer NOT NULL DESCRIPTION 'link to CrewActivities.idx',
xPosition Integer NOT NULL DESCRIPTION 'link to CrewPositions.idx',
BookingState Byte DEFAULT 0 DESCRIPTION 'TShiftBookingState = (sbsIncQuote, sbsExcQuote, sbsCancelled, sbsBlackout)',
Status Byte DEFAULT 0 DESCRIPTION 'TShiftStatus = (ssUnprocessed, ssInProgress, ssPencilled, ssBooked)',
OrderStatus Byte DEFAULT 0 DESCRIPTION 'TShiftOrderStatus = (sosNone, sosPartial, sosFullfilled, sosOver)',
ShiftType Byte DEFAULT 0 DESCRIPTION 'TShiftType = (stUnknown, stNormal, stBlackout)',
Shift1Start Time DEFAULT TIME'00:00:00.000',
Shift1End Time DEFAULT TIME'00:00:00.000',
Shift2Start Time DEFAULT TIME'00:00:00.000',
Shift2End Time DEFAULT TIME'00:00:00.000',
AccommodationStatus Byte DEFAULT 0 DESCRIPTION 'TAccommodationStatus = (asNotRequired, asClientProvides, asWeProvide)',
AccommodationCharge Money DEFAULT 0E0,
ChargeRate Money DEFAULT 0E0,
ChargeMethod Integer DESCRIPTION 'link to Price_Dat.idx',
ChargeAmount Money DEFAULT 0E0,
ChargePDsAmount Money DEFAULT 0E0,
ChargeTravelAmount Money DEFAULT 0E0,
ChargeOvertimeAmount Money DEFAULT 0E0,
PayRate Money DEFAULT 0E0,
PayMethod Integer DESCRIPTION 'link to Price_Dat.idx',
PayAmount Money DEFAULT 0E0,
PayPDsAmount Money DEFAULT 0E0,
PayTravelAmount Money DEFAULT 0E0,
PayOvertimeAmount Money DEFAULT 0E0,
Notes NCLOB,
IntegrityIssues Boolean,
AccommodationDays Byte DEFAULT 2 DESCRIPTION 'TAccommodationDays = Set of TAccommodationDay;TAccommodationDay = (adBeforeShift, adOnShift, adAfterShift); So values between 1',
OrderDetails CLOB DESCRIPTION 'JSON formatted data that stores the order amounts and the shift date and times',