View: Options

RotoID: PM0020
Table: PMOPT3
Protocol: Flat
DLL:PMOPT3

Keys: 1

Title Fields
Dummy DUMMY

Fields: 71

Field Index Type Title Attributes Presentation
DUMMY 1 Integer Dummy E A K R 
DATELASTMN 2 Date Last Maintained A C 
DEFCONT 3 Integer Default Contract Style E A  List:2 entries
1 = Standard
2 = Basic
APDARBTH 4 Integer Automatically Post A/R Batches from PJC E A  List:3 entries
0 = Adding to an Existing Batch
2 = Creating a New Batch
1 = Creating and Posting a New Batch
ARDESCFLD 5 Integer A/R Invoice Description Field E A  List:8 entries
1 = Type-Worksheet Number-Document Number
2 = Contract-Project-Category
4 = Description
5 = Reference
6 = Detail Description
7 = Contract Description
8 = Project Description
9 = Category Description
ARCOMFLD 6 Integer A/R Invoice Comment Field E A  List:10 entries
1 = Type-Worksheet Number-Document Number
2 = Contract-Project-Category
3 = Comment
4 = Description
5 = Reference
6 = Detail Description
7 = Contract Description
8 = Project Description
9 = Category Description
10 = Contract Comment
CHRGUNIQ 7 Long Next Charge Uniq E A 
EQIPUNIQ 8 Long Next Equipment Usage Uniq E A 
CHNGUNIQ 9 Long Next Change Order Uniq E A 
CARDUNIQ 10 Long Next Timecard Uniq E A 
STKAUNIQ 11 Long Next Material Usage Uniq E A 
STKRUNIQ 12 Long Next Material Return Uniq E A 
RRUNIQ 13 Long Next RR Uniq E A 
ADJUNIQ 14 Long Next Adjustment Uniq E A 
BBSEQ 15 Long Next Billing Worksheet Seq E A 
ERRSEQ 16 Long Error Sequence E A 
NUMCONTS 17 Long Number of Contracts E A 
PLCODE 18 String*16 Reserved E A 
RRMETHOD 19 Integer Percentage Complete Method E A  List:2 entries
1 = Clear Billings and WIP During Revenue Recognition
0 = Clear Billings and WIP During Project Close
BUDAUDIT 20 Boolean Keep Audit Log for Budgets E A 
BUDSEQ 21 Long Budget Audit Sequence (PMBUDA) E A 
BUDUNIQ 22 Long Budget Sequence (PMBUDH) E A 
STATESEQ 23 Long State File Sequence E A 
OBSEQ 24 Long Opening Balance E A 
OBDOCNUML 25 BCD*2.0 Opening Balance Document Length E A 
OBPREFIX 26 String*6 Opening Balance Prefix E A 
OBNEXTNUM 27 String*16 Next Opening Balance Doc Num E A  Mask: %-16D
URSEQ 28 Long Update Retainage E A 
URDOCNUML 29 BCD*2.0 Update Retainage Document Length E A 
URPREFIX 30 String*6 Update Retainage Prefix E A 
URNEXTNUM 31 String*16 Next Update Retainage Doc Num E A  Mask: %-16D
TCUCBASPAY 32 Integer A  List:1 entries
1 = Payroll
TCUCSTDPAY 33 Integer A  List:1 entries
1 = Payroll
TCUCBASPJC 34 Integer E A  List:2 entries
2 = PJC Employee Setup
6 = Category
TCUCSTDPJC 35 Integer E A  List:2 entries
2 = PJC Employee Setup
6 = Resource Category
TCBRBASPAY 36 Integer E A  List:2 entries
2 = PJC Employee Setup
6 = Category
TCBRSTDPAY 37 Integer E A  List:2 entries
2 = PJC Employee Setup
6 = Resource Category
TCBRBASPJC 38 Integer E A  List:2 entries
2 = PJC Employee Setup
6 = Category
TCBRSTDPJC 39 Integer E A  List:2 entries
2 = PJC Employee Setup
6 = Resource Category
EQUCBAS 40 Integer E A  List:2 entries
2 = PJC Equipment Setup
6 = Category
EQUCSTD 41 Integer E A  List:2 entries
2 = PJC Equipment Setup
6 = Resource Category
EQBRBAS 42 Integer E A  List:2 entries
2 = PJC Equipment Setup
6 = Category
EQBRSTD 43 Integer E A  List:2 entries
2 = PJC Equipment Setup
6 = Resource Category
SCUCBAS 44 Integer E A  List:2 entries
2 = PJC Subcontractor Setup
6 = Category
SCUCSTD 45 Integer E A  List:2 entries
2 = PJC Subcontractor Setup
6 = Resource Category
SCBRBAS 46 Integer E A  List:2 entries
2 = PJC Subcontractor Setup
6 = Category
SCBRSTD 47 Integer E A  List:2 entries
2 = PJC Subcontractor Setup
6 = Resource Category
OBPOSTSEQ 48 Long Opening Balances E A 
URPOSTSEQ 49 Long Update Retainage E A 
CESEQ 50 Long Costs E A 
CEDOCNUML 51 BCD*2.0 Costs Document Length E A 
CEPREFIX 52 String*6 Costs Prefix E A 
CENEXTNUM 53 String*16 Next Costs Doc Num E A  Mask: %-16D
CEPOSTSEQ 54 Long Costs E A 
CEGLSEQ 55 BCD*10.0 Costs E A 
ROSEQ 56 Long Reopening Projects E A 
RODOCNUML 57 BCD*2.0 Reopening Project Document Length E A 
ROPREFIX 58 String*6 Reopening Project Prefix E A 
RONEXTNUM 59 String*16 Next Reopening Project Doc Num E A  Mask: %-16D
ROPOSTSEQ 60 Long Reopen Projects E A 
ROGLSEQ 61 BCD*10.0 Reopen Projects E A 
MTALSEQ 62 Long Material Allocation E A 
MTALDOCNOL 63 BCD*2.0 Material Allocation Document Length E A 
MTALPREFIX 64 String*6 Material Allocation Prefix E A 
MTALNEXTNO 65 String*16 Next Material Allocation Doc Num E A  Mask: %-16D
MTALPSTSEQ 66 Long Material Allocation E A 
COMCSTPSEQ 67 Long Committed Cost E A 
USEBUDGET 68 Boolean Update Budgets E A 
USEEXPACCT 69 Boolean Use Expense Accounts E A 
RECOGCOST 70 Boolean Only Recognize Costs When Billed E A 
DATEDEF 71 Integer Default Posting Date E A  List:2 entries
1 = Document/Transaction Date
2 = Session Date

This page was generated on 2023-Aug-31

© 2023 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).