View: Optional Fields Detail

RotoID: PM0500
Table: PMOFD
Protocol: Detail, Ordered revisions
DLL:PMOFD

Compositions: 1

RotoID Tables Title DLL
PM0501 PMOFH Optional Fields Header PMOFH

Keys: 1

Title Fields
Optional Field Value LOCATION, OPTFIELD

Fields: 38

Field Index Type Title Attributes Presentation
LOCATION 1 Integer Location E A K R  List:32 entries
1 = Contracts
2 = Projects
3 = Categories
4 = Employees
5 = Equipment
6 = Miscellaneous Expenses
7 = Overhead Expenses
8 = Subcontractors
10 = Charge Codes
9 = Material
100 = Material Usage
101 = Material Usage Details
110 = Material Return
111 = Material Return Details
120 = Timecards
121 = Timecard Details
122 = Timecard Expenses
130 = Equipment Usage
131 = Equipment Usage Details
140 = Charges
141 = Charges Details
150 = Adjustment
151 = Adjustment Details
160 = Revenue Recognition
170 = Billing
171 = Billing Detail
181 = External Cost Transactions
190 = Reopening Projects
182 = Costs
183 = Cost Details
184 = Material Allocation
185 = Material Allocation Details
OPTFIELD 2 String*12 Optional Field E A K R  Mask: %-12N
DEFVAL 3 String*60 Default Value E A P  Mask: %-60c
TYPE 4 Integer Data Type E A C  List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH 5 Integer Length E A C 
DECIMALS 6 Integer Decimals E A C 
ALLOWNULL 7 Boolean Allow Blank E A C  List:2 entries
0 = No
1 = Yes
VALIDATE 8 Boolean Validate Optional Field E A C  List:2 entries
0 = No
1 = Yes
INITFLAG 9 Integer Init Flag E A  List:2 entries
0 = No
1 = Yes
SWICSHP 10 Integer I/C Shipments A P X 
SWICSHPD 11 Integer I/C Shipments Details A P X 
SWICADJ 12 Integer I/C Adjustments A P X 
SWICADJD 13 Integer I/C Adjustments Detail A P X 
SWPAYTC 14 Integer Payroll Timecards A P X 
SWPAYTCD 15 Integer Payroll Timecard Details A P X 
SWWIP 16 Integer Work In Progress A P X 
SWCOS 17 Integer Cost of Sales A P X 
SWPAYEXP 18 Integer Payroll Expense A P X 
SWLABOR 19 Integer Labor A P X 
SWOHEAD 20 Integer Overhead A P X 
SWEQUIP 21 Integer Equipment A P X 
SWEMPEXP 22 Integer Employee Expense A P X 
SWARINV 23 Integer Accounts Receivable Invoices A P X 
SWREV 24 Integer Revenue A P X 
SWBILL 25 Integer Billings A P X 
SWREQUIRED 26 Integer Required E A  List:2 entries
0 = No
1 = Yes
SWSET 27 Integer E A  List:2 entries
0 = No
1 = Yes
SWCOSTETRY 28 Integer Cost A P X 
DVINDEX 80 Long Default Value Index E A C 
DVIFTEXT 81 String*60 Default if a text field E A C P  Mask: %-60c
DVIFMONEY 82 BCD*10.3 Default if an amount field E A C 
DVIFNUM 83 BCD*10.0 Default if a numeric field E A C T 
DVIFLONG 84 Long Default if a long field E A C 
DVIFBOOL 85 Boolean Default if a boolean field E A C  List:2 entries
0 = No
1 = Yes
DVIFDATE 86 Date Default if a date field E A C 
DVIFTIME 87 Time Default if a time field E A C 
FDESC 88 String*60 Optional Field Description E A C 
VDESC 89 String*60 Value Description E A C 

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