One moment please...
 

Requests IDF

 

Request;Sourcetype
Request;Adm
Request;Delimiter
Request;Textqualifier
Request;Sheetname
Request;Startline
Request;RequestID
Request;number
Request;status
--0=open,1=Approved, 2=Rejected, 3=Processed, 4=Realized,5=Draft
Request;buildup;"0"
Request;RequestType
Request;Description
Request;Priority
Request;DateStart
--Only use when time is not required to be imported otherwise use DateTimeStart
Request;DateStartFormat
--DateTime.. always use format YYYY-MM-DDTHH:MM:SS
Request;DateTimeStart
Request;DateEnd
Request;DateEndFormat
--DateTime..always use format YYYY-MM-DDTHH:MM:SS
Request;DateTimeEnd
Request;ExpiryDate
Request;ExpiryDateFormat
Request;Entitlement
--1=statutory(wettelijk), 2=non-statutory(bovenwettelijk)
Request;WorkScheduleCal
Request;NumberOfDays
Request;NumberOfHours
Request;NumberOfHoursRealized
Request;DateTimeStartRealized
Request;DateTimeEndRealized
Request;OurRef
Request;YourRef
Request;Amount
Request;Currency
Request;AmountRealized
Request;CurrencyRealized
--Resource id
Request;Resource
Request;Account
Request;Item1
Request;Quantity1
Request;Item2
Request;Quantity2
Request;ProjectCode
Request;RequestComment
Request;SecurityLevel
Request;Document
Request;FreeText1
Request;FreeText2
Request;FreeText3
Request;FreeText4
Request;FreeText5
Request;FreeText6
Request;FreeText7
Request;FreeText8
Request;FreeText9
Request;FreeText10
Request;FreeText11
Request;FreeText12
Request;FreeText13
Request;FreeText14
Request;FreeText15
Request;FreeText16
Request;LookupFreetext16
Request;FreeText17
Request;LookupFreetext17
Request;FreeText18
Request;LookupFreetext18
Request;FreeText19
Request;LookupFreetext19
Request;FreeText20
Request;LookupFreetext20
Request;FreeText21
Request;LookupFreetext21
Request;FreeText22
Request;LookupFreetext22
Request;FreeText23
Request;LookupFreetext23
Request;FreeText24
Request;LookupFreetext24
Request;FreeText25
Request;LookupFreetext25
Request;FreeNumber1
Request;FreeNumber2
Request;FreeNumber3
Request;FreeNumber4
Request;FreeNumber5
Request;FreeNumber6
Request;FreeNumber7
Request;FreeNumber8
Request;FreeNumber9
Request;FreeNumber10
Request;FreeYesNo1
Request;FreeYesNo2
Request;FreeYesNo3
Request;FreeYesNo4
Request;FreeYesNo5
Request;FreeDate1
Request;FreeDate2
Request;FreeDate3
Request;FreeDate4
Request;FreeDate5
Request;WorkflowComment
Request;WorkflowCreatedResource
--DateTime..always use format YYYY-MM-DDTHH:MM:SS
Request;WorkflowCreatedDateTime
Request;WorkflowApprovedResource
Request;WorkflowApprovedDateTime
Request;WorkflowRealizedResource
Request;WorkflowRealizedDateTime
Request;WorkflowProcessedResource
Request;WorkflowProcessedDateTime
Request;WorkflowRejectedResource
Request;WorkflowRejectedDateTime

--Please note the following regarding the import of freefields into Synergy.
--Synergy import of guidfields. See Exact doc 03.374.379
--Free Text 1 - 15: <freetext number="1 - 15">...</freetext>
--Free GUID 1 - 10: <freetext number="16 - 25">...</freetext>
--Free Date 1 - 5: <freedate number="1 - 5">...</freedate>
--Free Amount 1 - 5: <freenumber number="1 - 5">...</freenumber>
--Free Number 1 - 5: <freenumber number="6 - 10">...</freenumber>
--Free Yes/No 1 - 5: <freeyesno number="1 - 5">...</freeyesno>


Doc id: 00.006.851