Table: Timecard Time Totals

Table: PMTIMET
View: PM0115
Record length: 268
Flags: A R 

Keys: 1

Title  Flags  Fields

  SEQ, LINENO

Fields: 38

Field  Type  Title  Presentation 

SEQ  Long  Sequence   
LINENO  Long  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
FMTCONTNO  String*16  ^1  Mask: %-16C
CONTRACT  String*16  ^1  Mask: %-16C
PROJECT  String*16  ^2  Mask: %-16N
CATEGORY  String*16  ^3  Mask: %-16N
HMON  BCD*10.2  Monday Hours   
HTUE  BCD*10.2  Tuesday Hours   
HWED  BCD*10.2  Wednesday Hours   
HTHU  BCD*10.2  Thursday Hours   
HFRI  BCD*10.2  Friday Hours   
HSAT  BCD*10.2  Saturday Hours   
HSUN  BCD*10.2  Sunday Hours   
HWEEK  BCD*10.2  Weekly Hours   
NLMON  Long  Number of details - Monday   
NLTUE  Long  Number of details - Tuesday   
NLWED  Long  Number of details - Wednesday   
NLTHU  Long  Number of details - Thursday   
NLFRI  Long  Number of details - Friday   
NLSAT  Long  Number of details - Saturday   
NLSUN  Long  Number of details - Sunday   
DMON  Long  DETAILNUM - Monday   
DTUE  Long  DETAILNUM - Tuesday   
DWED  Long  DETAILNUM - Wednesday   
DTHU  Long  DETAILNUM - Thursday   
DFRI  Long  DETAILNUM - Friday   
DSAT  Long  DETAILNUM - Saturday   
DSUN  Long  DETAILNUM - Sunday   
CONTSTYLE  Integer  ^1 Style  List: 2 entries
1=Standard
2=Basic
PROJTYPE  Integer  ^2 Type  List: 3 entries
1=Time and Materials
2=Fixed Price
3=Cost Plus
CUSTOMER  String*12  Customer  Mask: %-12C
REVREC  Integer  Accounting Method  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  Integer  Invoice Type  List: 2 entries
1=Item
2=Summary
EARNINGS  String*16  Earnings Code  Mask: %-16C

This page was generated on 2008-May-01

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