# Table: Categories

Table: PMCTG
View: PM0018
Record length: 422
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Category |  | CATEGORY

## Fields: 44

Field | Type | Title | Presentation
--- | --- | --- | ---
CATEGORY | String*16 | ^3 | Mask: %-16N
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DESC | String*60 | Description |
COSTTYPE | String*10 | Cost Type | Mask: %-10N
TYPE | Integer | Cost Class | List: 6 entries
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
INACTIVE | Integer | Status | List: 2 entries
0 | = | Active
1 | = | Inactive
DATELASTMN | Date | Last Maintained |
DATEINACTV | Date | Date Inactive |
ARITEM | String*16 | A/R Item No. | Mask: %-16C
UOM | String*10 | Unit of Measure | Mask: %-10C
UNITCOST | BCD*10.6 | Unit Cost |
BILLRATE | BCD*10.6 | Billing Rate |
OVERHD | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | BCD*10.6 | Overhead Rate |
HEADPER | BCD*5.5 | Overhead Percentage |
LABOR | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | BCD*10.6 | Labor Rate |
LABORPER | BCD*5.5 | Labor Percentage |
PERRETPAID | BCD*5.5 | A/P Retainage Percentage |
RETPAIDD | Integer | A/P Retention Period |
SEGOVERRD | Boolean | Override G/L Account Segments |
SEGNUM1 | String*6 | Segment 1 |
SEGVAL1 | String*15 | Segment Code 1 |
SEGNUM2 | String*6 | Segment 2 |
SEGVAL2 | String*15 | Segment Code 2 |
SEGNUM3 | String*6 | Segment 3 |
SEGVAL3 | String*15 | Segment Code 3 |
SEGNUM4 | String*6 | Segment 4 |
SEGVAL4 | String*15 | Segment Code 4 |
SEGNUM5 | String*6 | Segment 5 |
SEGVAL5 | String*15 | Segment Code 5 |
SEGNUM6 | String*6 | Segment 6 |
SEGVAL6 | String*15 | Segment Code 6 |
SEGNUM7 | String*6 | Segment 7 |
SEGVAL7 | String*15 | Segment Code 7 |
SEGNUM8 | String*6 | Segment 8 |
SEGVAL8 | String*15 | Segment Code 8 |
SEGNUM9 | String*6 | Segment 9 |
SEGVAL9 | String*15 | Segment Code 9 |
PLCODE | String*16 | Reserved |
VALUES | Long | Optional Fields |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.