# 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 2009-Nov-19

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