]po[ Material

A "Material" represents a type of good or service that your company sells to a customer.

Materials serve as a bridge between Timesheet Tasks and the Customer's Price List.

Material Fields

• Material ID (material_id:integer references acs_objects):
  A unique Material ID. Material is a subtype of Object, so the im_materials.material_id is identical to the acs_objects.object_id.
  
  
• Material Name (material_name:text):
  A human readable name for the material. Example: "Senior Manager Consulting Hour", "Monthly Service Contract", ...
  
  
• Material Nr (material_nr:text):
  A short name for each material.
  
  
• Material Type (material_type_id:integer references im_categories):
  The type of material. Examples include "License", "Consulting Hour" and "Default".
  
  
• Material Status (material_status_id:integer references im_categories):
  Only "Active" and "Deleted" are used at the moment.
  
  
• Material UoM (material_uom_id:integer references im_categories):
  The "Unit of Measure" of the materials. You need to set "Hour" for materials of [timesheet tasks], so that logging hours against timesheet tasks is consistent.
  
  
• Description (description:text):
  Description of the material.
  
  
• Billable? (material_billable_p:char(1)):
  Is the material billable? This field is used by the [Timesheet Inovoicing Wizard] to exclude non-billable materials from invoices by default.

Data-Model

Structure of the im_materials database table:

 material_id         | integer                 | not null
 material_name       | character varying(2000) |
 material_nr         | character varying(200)  |
 material_type_id    | integer                 | not null
 material_status_id  | integer                 |
 description         | character varying(4000) |
 material_uom_id     | integer                 |
 material_billable_p | character(1)            | default 't'::bpchar
­

­