clsImportEquipmentBookings Fields

ActivityText: Free Text

The import can directly set the approval flag. This only works, if the user loged into the interface is allowed in the project to approve equipment bookings.

ApprovalText

ContractID: Contract Identifier. This is the internal identifier (INT) not the official contract number (char20).

Identifier of the contract position (INT).This is the main (parent) category contract position. Computed, if 0

ContractPositionID: Contract position ID for the required cost type in the contract. If 0, then the HelpCostType is used

Employee: User who is responsible for the transaction. Mostly the project manager. See clsImportEmployee for the employee dimension.

EndTime: End Time (0:01 to 23:59). StartTime=NULL and EndTime=NULL means full day

EndTimeBillable: End Time (0:01 to 23:59) for billing. StartTimeBillable=NULL and EndTimeBillable=NULL means full day

EquipmentCode Used equipment Code

EquipmentFrom Equipment Start Date

Equipment End Date for repeating bookings

If ContractID is 0 the Contract is searched by the visible contract ID

HelpCostType: Used cost type. if CostTypePositionID=0 the first contract position with this CostType is used

For projects with phases, the phase ID can be searched by the phase name, if PhaseID is 0: The first matching phase with the given name will be used.

EquipmentBookingID Line ID: Given by the system. Filled after import

Memo: The Memo field can store 2 Million caracters (TEXT).

NumberOfEquipments: default=1, other numbers only for Equipment of the EquipmentType=eEquipmentMasterType.EquipmentMasterQtyNoSN = 451

PhaseID: Phase Identifier (INT). Only leaves of phases can be used, not branches.

ProjectNumber

Quantity: Number of hours used. Put 24 for one day:

QuantityBillable: Number of hours used for billing (please fill this field 1:1 with the Quanity

StartTime Time start (0:00 to 23:59)

StartTimeBillable: Time start (0:00 to 23:59) for billing