View: Timecard Time Totals

RotoID: PM0115
Table: PMTIMET
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMTIMET

Compositions: 2

RotoID Tables Title DLL
PM0040 PMTIMEH Timecard PMTIMEH
PM0041 PMTIMED Timecard Time Detail PMTIMED

Keys: 1

Title Fields
SEQ, LINENO

Fields: 39

Field Index Type Title Attributes Presentation
SEQ 1 Long Sequence E A K R 
LINENO 2 Long Line Number E A K R 
FMTCONTNO 3 String*16 ^1 E A  Mask: %-16C
CONTRACT 4 String*16 ^1 E A  Mask: %-16C
PROJECT 5 String*16 ^2 E A  Mask: %-16N
CATEGORY 6 String*16 ^3 E A  Mask: %-16N
HMON 7 BCD*10.2 Monday Hours E A 
HTUE 8 BCD*10.2 Tuesday Hours E A 
HWED 9 BCD*10.2 Wednesday Hours E A 
HTHU 10 BCD*10.2 Thursday Hours E A 
HFRI 11 BCD*10.2 Friday Hours E A 
HSAT 12 BCD*10.2 Saturday Hours E A 
HSUN 13 BCD*10.2 Sunday Hours E A 
HWEEK 14 BCD*10.2 Weekly Hours A 
NLMON 15 Long Number of details - Monday A 
NLTUE 16 Long Number of details - Tuesday A 
NLWED 17 Long Number of details - Wednesday A 
NLTHU 18 Long Number of details - Thursday A 
NLFRI 19 Long Number of details - Friday A 
NLSAT 20 Long Number of details - Saturday A 
NLSUN 21 Long Number of details - Sunday A 
DMON 22 Long DETAILNUM - Monday A 
DTUE 23 Long DETAILNUM - Tuesday A 
DWED 24 Long DETAILNUM - Wednesday A 
DTHU 25 Long DETAILNUM - Thursday A 
DFRI 26 Long DETAILNUM - Friday A 
DSAT 27 Long DETAILNUM - Saturday A 
DSUN 28 Long DETAILNUM - Sunday A 
CONTSTYLE 29 Integer ^1 Style E A C  List:2 entries
1 = Standard
2 = Basic
PROJTYPE 30 Integer ^2 Type E A C  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CUSTOMER 31 String*12 Customer E A C  Mask: %-12C
REVREC 32 Integer Accounting Method E A C  List:7 entries
1 = Completed Project
2 = Total Cost Percentage Complete
3 = Labor Hours Percentage Complete
4 = Billings and Costs
5 = Project Percentage Complete
6 = Category Percentage Complete
8 = Accrual-Basis
INVTYPE 33 Integer Invoice Type E A C  List:2 entries
1 = Item
2 = Summary
EARNINGS 34 String*16 Earnings Code E A  Mask: %-16C
FUNCTION 1001 Integer Function E A C 
TIMED 1002 Boolean Called by PMTIMED? E A C 
CONTDESC 1009 String*60 Description A C 
PROJDESC 1010 String*60 Description A C 
CATDESC 1011 String*60 Description A C 

This page was generated on 2023-Aug-31

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