Table: Timecard Time Audit

Table: PMTIMTA
View: PM0117
Record length: 256
Flags: A R 

Keys: 1

Title  Flags  Fields

  POSTSEQNO, LINENO

Fields: 38

Field  Type  Title  Presentation 

POSTSEQNO  Long  Posting Sequence   
LINENO  Long  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
SEQ  Long  Sequence   
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

This page was generated on 2008-May-01

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