View: Categories

RotoID: PM0018
Table: PMCTG
Protocol: Header
DLL:PMCTG

Compositions: 2

RotoID Tables Title DLL
PM0475 PMCTGD Categories Detail View PMCTGD
PM0510 PMCTGO Category Optional Fields PMCTGO

Keys: 1

Title Fields
Category CATEGORY

Fields: 40

Field Index Type Title Attributes Presentation
CATEGORY 1 String*16 ^3 E A K R  Mask: %-16N
DESC 2 String*60 Description E A 
COSTTYPE 3 String*10 Cost Type E A X  Mask: %-10N
TYPE 4 Integer Cost Class E A  List:6 entries
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
INACTIVE 5 Integer Status E A  List:2 entries
0 = Active
1 = Inactive
DATELASTMN 6 Date Last Maintained A C 
DATEINACTV 7 Date Date Inactive A C 
ARITEM 8 String*16 A/R Item No. E A  Mask: %-16C
UOM 9 String*10 Unit of Measure E A  Mask: %-10C
UNITCOST 10 BCD*10.6 Unit Cost E A 
BILLRATE 11 BCD*10.6 Billing Rate E A 
OVERHD 12 Integer Overhead Type E A  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 13 BCD*10.6 Overhead Rate E A 
HEADPER 14 BCD*5.5 Overhead Percentage E A 
LABOR 15 Integer Labor Type E A  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE 16 BCD*10.6 Labor Rate E A 
LABORPER 17 BCD*5.5 Labor Percentage E A 
PERRETPAID 18 BCD*5.5 A/P Retainage Percentage E A 
RETPAIDD 19 Integer A/P Retention Period E A 
SEGOVERRD 20 Boolean Override G/L Account Segments E A 
SEGNUM1 21 String*6 Segment 1 E A 
SEGVAL1 22 String*15 Segment Code 1 E A 
SEGNUM2 23 String*6 Segment 2 E A 
SEGVAL2 24 String*15 Segment Code 2 E A 
SEGNUM3 25 String*6 Segment 3 E A 
SEGVAL3 26 String*15 Segment Code 3 E A 
SEGNUM4 27 String*6 Segment 4 E A 
SEGVAL4 28 String*15 Segment Code 4 E A 
SEGNUM5 29 String*6 Segment 5 E A 
SEGVAL5 30 String*15 Segment Code 5 E A 
SEGNUM6 31 String*6 Segment 6 E A 
SEGVAL6 32 String*15 Segment Code 6 E A 
SEGNUM7 33 String*6 Segment 7 E A 
SEGVAL7 34 String*15 Segment Code 7 E A 
SEGNUM8 35 String*6 Segment 8 E A 
SEGVAL8 36 String*15 Segment Code 8 E A 
SEGNUM9 37 String*6 Segment 9 E A 
SEGVAL9 38 String*15 Segment Code 9 E A 
PLCODE 39 String*16 Reserved E A 
VALUES 40 Long Optional Fields E A C 

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).