TimeCostTransactions
Usage information for the operation TimeCostTransactions.rsd.
Columns
| Name | Type | Description |
| Timestamp [KEY] | Integer | Timestamp |
| Account | Integer | Supports webhook Guid ID of account that is linked to the project |
| AccountName | String | Name of account that is linked to the project |
| AmountFC | Double | Supports webhook Calculated amount of the transaction based on (Quantity * PriceFC) |
| Attachment | String | Supports webhook Attachment linked to the transaction (not mandatory) |
| Created | Datetime | Date and time the transaction was created |
| Creator | Integer | The Guid ID of user that created the transaction |
| CreatorFullName | String | The full name of the user that created the record |
| Currency | String | Supports webhook Currency of amount FC |
| Date | Datetime | Supports webhook Date and time the transaction was done |
| Division | Integer | Division code |
| DivisionDescription | String | Description of Division |
| Employee | Integer | Supports webhook Guid ID of the employee that is linked to the transaction |
| EndTime | Datetime | Supports webhook End time of the time transaction |
| EntryNumber | Datetime | Supports webhook Number that represents the grouping of transactions |
| ErrorText | String | Supports webhook (Only used by backgroundjobs) To determine which transaction has an error |
| HourStatus | String | Supports webhook Status of the transaction: 1 = Draft, 2 = Rejected, 10 = Submitted, 11 = Failed on approval, 14 = Processi |
| ID | Integer | Primary key |
| Item | Integer | Supports webhook Item that is linked to the transaction, which provides the time or cost information |
| ItemDescription | String | Description of the item that is linked to the transaction |
| ItemDivisable | Integer | Indicates if fractional quantities of the item can be used, for example quantity = 0.4 |
| Modified | Datetime | The date and time transaction record was modified |
| Modifier | Integer | The Guid ID of the user that modified the records |
| ModifierFullName | String | The full name of the user that modified the record |
| Notes | String | Supports webhook Notes linked to the transaction for providing additional information (not mandatory) |
| PriceFC | Integer | Supports webhook For use in AmountFC (Quantiy * Price FC) |
| Project | Integer | Supports webhook Guid ID of project that is linked to the transaction |
| ProjectAccount | Integer | Project account ID that is linked to the transaction (not mandatory) |
| ProjectAccountCode | String | Supports webhook Project account code that is linked to the transaction |
| ProjectAccountName | String | Project account name that is linked to the transaction |
| ProjectCode | String | Project code that is linked to the transaction |
| ProjectDescription | String | Project description that is linked to the transaction |
| Quantity | Double | Supports webhook Quantity of the item that is linked to the transaction |
| StartTime | Datetime | Supports webhook Start time of the time transaction |
| Subscription | Integer | Supports webhook Guid ID of subscription that is linked to the transaction |
| SubscriptionAccount | Integer | Subscription account ID that is linked to the transaction, this is to identify the referenced subscription |
| SubscriptionAccountCode | String | Subscription account code that is linked to the transaction |
| SubscriptionAccountName | String | Subscription account name that is linked to the transaction |
| SubscriptionDescription | String | Subscription description that is linked to the transaction |
| SubscriptionNumber | Integer | Subscription number that is linked to the transaction |
| Type | Integer | The type of transaction. E.g: 1 = Time, 2 = Cost |
| WBS | Integer | Supports webhook Guid ID of activity for time transaction or expense for cost transaction that is linked to project WBS |
| WBSDescription | String | Name of activity for time transaction or expense for cost transaction that is linked to project WBS (work breakdown structure) |