Table: Project Code

Table: PMPROJ
View: PM0006
Record length: 353
Flags: A R 

Keys: 1

Title  Flags  Fields

Project  PROJECT

Fields: 40

Field  Type  Title  Presentation 

PROJECT  String*16  ^2  Mask: %-16N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DESC  String*60  Description   
INACTIVE  Integer  Status  List: 2 entries
0=Active
1=Inactive
DATELASTMN  Date  Last Maintained   
DATEINACTV  Date  Date Inactive   
PROJTYPE  Integer  ^2 Type  List: 3 entries
1=Time and Materials
2=Fixed Price
3=Cost Plus
REVREC  Integer  Accounting Method  List: 3 entries
1=Completed Project
4=Billings and Costs
8=Accrual-Basis
COSTPLUSP  BCD*5.5  Cost Plus Percentage   
CLOSEBILL  Boolean  Closed for Billings   
CLOSECOST  Boolean  Closed for Cost   
USEDEFREV  Integer  Revenue Type  List: 2 entries
0=Revenue
1=Deferred Revenue
BILLTYPE  Integer  Billing Type  List: 3 entries
2=Billable
3=No Charge
1=Non-billable
RETAR  BCD*5.5  A/R Retainage Percentage   
RETDAYSAR  Integer  A/R Retention Period   
SEGOVERRD  Boolean  Override G/L Account Segments   
SEGNUM1  String*6  Segment 1   
SEGVAL1  String*15  Segment Code 1   
SEGNUM2  String*6  Segment 2   
SEGVAL2  String*15  Segment Code 2   
SEGNUM3  String*6  Segment 3   
SEGVAL3  String*15  Segment Code 3   
SEGNUM4  String*6  Segment 4   
SEGVAL4  String*15  Segment Code 4   
SEGNUM5  String*6  Segment 5   
SEGVAL5  String*15  Segment Code 5   
SEGNUM6  String*6  Segment 6   
SEGVAL6  String*15  Segment Code 6   
SEGNUM7  String*6  Segment 7   
SEGVAL7  String*15  Segment Code 7   
SEGNUM8  String*6  Segment 8   
SEGVAL8  String*15  Segment Code 8   
SEGNUM9  String*6  Segment 9   
SEGVAL9  String*15  Segment Code 9   
FORMCODE  String*6  Form Code  Mask: %-6N
PLCODE  String*16  Reserved   
VALUES  Long  Optional Fields   

This page was generated on 2008-May-01

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