220 - Project/activity time transaction

To Host

If the system is set up with ''Only make host transactions for approved transactions'', this is done in ''Set-up>Project>Project Setup'', and the registrations are set up to be send to approval, the host transactions is generated when the project registration is approved. Otherwise the host transactions is generated when the project registration is made.

FieldDescriptionData TypeMandatoryComment
1Project idText

2Activity idText

3Employee noText

4Added timeTime duration

5Activity time typeText

6Activity used timeTime duration

7Activity actual dateDate

8Registration dateDate

9Registration timeTime

10Extra infoText

The extra info contains data in the form:

''quest1=answ1;quest2=answ2; ... ;questN=answN''

Where questN is the question ID and answN is the answer

To get a specific field value used the formula function "NAMEDVAL" Ex: NAMEDVAL("DEPT:",#10)

11Employee initialsText

12Piece workText

Only used with the Application module ''Project:Piecework''.

13Period profileText

14Info-1Text

From employee

15Info-2Text

From employee

16Info-3Text

From employee

17Info-4Text

From employee

18Info-5Text

From employee

19Ref 1Text

From project

20Ref 2Text

From project

21Ref 3Text

From project

22Registration typeText

See Note 1

23Registration idText

24Registration valueDecimal number

See Note 1

25Registration timeTime duration

See Note 1

26Registration posted valueDecimal number

See Note 1

27Registration posted timeTime duration

See Note 1

28Activity account IDText

29Category idText

From employee

30Start timeDate and time

Project registration start date and time

31End timeDate and time

Project registration end date and time

32Division idText

Division id for the project registration

33CorrectionInteger

34Unique IDText

Notes

IdText
1The field ''Supplement type'' indicate the type of supplement:
* 0: Supplement is a value for Number Supplement.
* 1: Supplement is time for Time Supplement.
* -1: Supplement is a value for expense registration with addenda ID

When the ''Supplement type'' is ''Value'' then the actual value entered by the user is stored in the field ''Supplement value''. The value that was posted according to the rules on the account associated with the supplement, is stored in the field ''Supplement posted value''.

When the ''Supplement type'' is ''Time'' then the actual time duration entered by the user is stored in the field ''Supplement time''. The time duration that was posted according to the rules on the account associated with the supplement, is stored in the field ''Supplement posted time''.