Table: Reopen Worksheet Detail

Table: PMROD
View: PM0202
Record length: 486
Flags: A R 

Keys: 3

Title  Flags  Fields
  SEQ, DLINENUM
  D M  SEQ, DDETAIL
  D M  SEQ, FMTCONTNO, PROJECT

Fields: 22

Field  Type  Title  Presentation 
SEQ  Long  Sequence   
DLINENUM  Long  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DDETAIL  Long  Detail Number   
FMTCONTNO  String*16  ^1  Mask: %-16C
PROJECT  String*16  ^2  Mask: %-16N
PROJTYPE  Integer  ^2 Type  List: 3 entries
1=Time and Materials
2=Fixed Price
3=Cost Plus
ACCTMETD  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
RATE  BCD*8.7  Rate   
RATETYPE  String*2  Rate Type   
RATEDATE  Date  Rate Date   
RATEOP  Integer  Rate Operator  List: 2 entries
1=Multiply
2=Divide
CCY  String*3  Currency  Mask: %-3N
TDEBIT  BCD*10.3  Total Debits   
TCREDIT  BCD*10.3  Total Credits   
VALUES  Long  Optional Fields   
GLDDESC  String*60  G/L Detail Reference   
GLDREF  String*60  G/L Detail Description   
GLCOMMENT  String*250  G/L Detail Comment   

This page was generated on 2008-May-01

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