FSM Time Bill Model Reference

Note:

This reference is intended for administrators and developers who work with Time Bill model mappings and validation behavior.

The Time Bill model represents timebill. Its explicit prototype.defaults is empty. It supports NetSuite Time Bill validation, billing, and Case unbilled updates.

Standard default structure (JSON fragment):

          {
  "models/time": {
    "prototype": {
      "record": "timebill",
      "map": {
        "employee": "employee",
        "date": "date|trandate",
        "duration": "durationdecimal|hours",
        "rate": "rate",
        "billable": "isbillable",
        "item": "item.internalid|item",
        "price": "item.baseprice|",
        "memo": "memo",
        "cost": "custcol_nx_time_cost",
        "costed": "custcol_nx_time_costed",
        "billed": "custcol_nx_time_billed",
        "status": "status",
        "task": "task.internalid|casetaskevent",
        "project": "customer",
        "taskcol": "custcol_nx_task",
        "asset": "custcol_nx_asset",
        "id": "internalid"
      },
      "defaults": {}
    }
  }
} 

        

The prototype.map.pricelevel mapping is "formulatext:''|price" when Override Time Rates is enabled. Location, department, and class mappings are added when their respective features are enabled. These conditional entries are omitted from the fragment.

The following table lists the Time Bill model's mapped attributes, their purposes, and the standard NetSuite fields or mapping expressions used for each attribute.

Property	Purpose	Standard Mapping or Default
prototype.map.employee	Employee who performed the work.	"employee"
prototype.map.date	Reads the date and writes the transaction date.	"date|trandate"
prototype.map.duration	Reads decimal duration and writes hours. The model also converts an hours-and-minutes value to decimal hours.	"durationdecimal|hours"
prototype.map.task	Native event relationship.	"task.internalid|casetaskevent"
prototype.map.taskcol, prototype.map.asset	FSM Task and Asset references used by billing and costing.	"custcol_nx_task", "custcol_nx_asset"
prototype.map.project	Customer or Project entity.	"customer"
prototype.map.billable, prototype.map.rate, prototype.map.item	Billing data.	"isbillable", "rate", "item.internalid|item"
prototype.map.cost, prototype.map.costed, prototype.map.billed	Costing and processing data.	"custcol_nx_time_cost", "custcol_nx_time_costed", "custcol_nx_time_billed"

Price level mapping is present when Override Time Rates is enabled. Department, class, and location mappings depend on the corresponding NetSuite features. Billing rules can recalculate billable status and, with Multiple Prices and Override Time Rates, rate and price level. Changing a displayed field or a default doesn't prevent that recalculation.

Keep the native event link and FSM Task column distinct. Validation synchronizes the Task column for supported CRM Task relationships. Case invoicing and labor recovery use that column. For billing controls, see Configuring FSM Billing Rules. For labor-cost posting controls, see Configuring FSM Project Labor Cost Posting. The FSM Mobile times resource supplies its own article map and element defaults.

Additional Information

• FSM Time Bill Record
• Configuring FSM Billing Rules
• Configuring FSM Project Labor Cost Posting
• Configuring FSM Service Time Tracking

Related Topics

• FSM Record Model Configuration
• FSM Employee Model Reference
• FSM Invoice Model Reference
• FSM Journal Entry Model Reference
• FSM CRM Task Model Reference

General Notices