View: Project Code

RotoID: PM0006
Table: PMPROJ
Protocol: Header
DLL:PMPROJ

Compositions: 1

RotoID Tables Title DLL
PM0509 PMPROJO Project Optional Fields PMPROJO

Keys: 1

Title Fields
Project PROJECT

Fields: 36

Field Index Type Title Attributes Presentation
PROJECT 1 String*16 ^2 E A K R  Mask: %-16N
DESC 2 String*60 Description E A 
INACTIVE 3 Integer Status E A  List:2 entries
0 = Active
1 = Inactive
DATELASTMN 4 Date Last Maintained A C 
DATEINACTV 5 Date Date Inactive A C 
PROJTYPE 6 Integer ^2 Type E A  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 7 Integer Accounting Method E A P  List:3 entries
1 = Completed Project
4 = Billings and Costs
8 = Accrual-Basis
COSTPLUSP 8 BCD*5.5 Cost Plus Percentage A X 
CLOSEBILL 9 Boolean Closed for Billings E A 
CLOSECOST 10 Boolean Closed for Cost E A 
USEDEFREV 11 Integer Revenue Type E A  List:2 entries
0 = Revenue
1 = Deferred Revenue
BILLTYPE 12 Integer Billing Type E A  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
RETAR 13 BCD*5.5 A/R Retainage Percentage E A 
RETDAYSAR 14 Integer A/R Retention Period E A 
SEGOVERRD 15 Boolean Override G/L Account Segments E A 
SEGNUM1 16 String*6 Segment 1 E A 
SEGVAL1 17 String*15 Segment Code 1 E A 
SEGNUM2 18 String*6 Segment 2 E A 
SEGVAL2 19 String*15 Segment Code 2 E A 
SEGNUM3 20 String*6 Segment 3 E A 
SEGVAL3 21 String*15 Segment Code 3 E A 
SEGNUM4 22 String*6 Segment 4 E A 
SEGVAL4 23 String*15 Segment Code 4 E A 
SEGNUM5 24 String*6 Segment 5 E A 
SEGVAL5 25 String*15 Segment Code 5 E A 
SEGNUM6 26 String*6 Segment 6 E A 
SEGVAL6 27 String*15 Segment Code 6 E A 
SEGNUM7 28 String*6 Segment 7 E A 
SEGVAL7 29 String*15 Segment Code 7 E A 
SEGNUM8 30 String*6 Segment 8 E A 
SEGVAL8 31 String*15 Segment Code 8 E A 
SEGNUM9 32 String*6 Segment 9 E A 
SEGVAL9 33 String*15 Segment Code 9 E A 
FORMCODE 34 String*6 Form Code E A  Mask: %-6N
PLCODE 35 String*16 Reserved E A 
VALUES 36 Long Optional Fields E A C 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).