View: Timecard Time Audit

RotoID: PM0117
Table: PMTIMTA
Protocol: Flat
DLL:PMTIMTA

Keys: 1

Title Fields

POSTSEQNOLINENO

Fields: 34

Field Index Type Title Attributes Presentation

POSTSEQNO 1 Long Posting Sequence E A K R 
LINENO 2 Long Line Number E A K R 
SEQ 3 Long Sequence E A 
FMTCONTNO 4 String*16 ^1 E A  Mask: %-16C
CONTRACT 5 String*16 ^1 E A  Mask: %-16C
PROJECT 6 String*16 ^2 E A  Mask: %-16N
CATEGORY 7 String*16 ^3 E A  Mask: %-16N
HMON 8 BCD*10.2 Monday Hours E A 
HTUE 9 BCD*10.2 Tuesday Hours E A 
HWED 10 BCD*10.2 Wednesday Hours E A 
HTHU 11 BCD*10.2 Thursday Hours E A 
HFRI 12 BCD*10.2 Friday Hours E A 
HSAT 13 BCD*10.2 Saturday Hours E A 
HSUN 14 BCD*10.2 Sunday Hours E A 
HWEEK 15 BCD*10.2 Weekly Hours E A 
NLMON 16 Long Number of details - Monday E A 
NLTUE 17 Long Number of details - Tuesday E A 
NLWED 18 Long Number of details - Wednesday E A 
NLTHU 19 Long Number of details - Thursday E A 
NLFRI 20 Long Number of details - Friday E A 
NLSAT 21 Long Number of details - Saturday E A 
NLSUN 22 Long Number of details - Sunday E A 
DMON 23 Long DETAILNUM - Monday E A 
DTUE 24 Long DETAILNUM - Tuesday E A 
DWED 25 Long DETAILNUM - Wednesday E A 
DTHU 26 Long DETAILNUM - Thursday E A 
DFRI 27 Long DETAILNUM - Friday E A 
DSAT 28 Long DETAILNUM - Saturday E A 
DSUN 29 Long DETAILNUM - Sunday E A 
CONTSTYLE 30 Integer ^1 Style E A C  List:2 entries
1 = Standard
2 = Basic
PROJTYPE 31 Integer ^2 Type E A C  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CUSTOMER 32 String*12 Customer E A C  Mask: %-12C
REVREC 33 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 34 Integer Invoice Type E A C  List:2 entries
1 = Item
2 = Summary