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 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).