# Table: Optional Fields Detail

Table: PMOFD
View: PM0500
Record length: 148
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Optional Field Value |  | LOCATION, OPTFIELD

## Fields: 32

Field | Type | Title | Presentation
--- | --- | --- | ---
LOCATION | Integer | Location | 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 | String*12 | Optional Field | Mask: %-12N
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DEFVAL | String*60 | Default Value | Mask: %-60c
TYPE | Integer | Data Type | List: 7 entries
1 | = | Text
100 | = | Amount
6 | = | Number
8 | = | Integer
9 | = | Yes/No
3 | = | Date
4 | = | Time
LENGTH | Integer | Length |
DECIMALS | Integer | Decimals |
ALLOWNULL | Boolean | Allow Blank | List: 2 entries
0 | = | No
1 | = | Yes
VALIDATE | Boolean | Validate Optional Field | List: 2 entries
0 | = | No
1 | = | Yes
INITFLAG | Integer | Init Flag | List: 2 entries
0 | = | No
1 | = | Yes
SWICSHP | Integer | Inventory Control Shipments |
SWICSHPD | Integer | Inventory Control Shipments Details |
SWICADJ | Integer | Inventory Control Adjustments |
SWICADJD | Integer | Inventory Control Adjustments Detail |
SWPAYTC | Integer | Payroll Timecards |
SWPAYTCD | Integer | Payroll Timecard Details |
SWWIP | Integer | Work In Progress |
SWCOS | Integer | Cost of Sales |
SWPAYEXP | Integer | Payroll Expense |
SWLABOR | Integer | Labor |
SWOHEAD | Integer | Overhead |
SWEQUIP | Integer | Equipment |
SWEMPEXP | Integer | Employee Expense |
SWARINV | Integer | Accounts Receivable Invoices |
SWREV | Integer | Revenue |
SWBILL | Integer | Billings |
SWREQUIRED | Integer | Required | List: 2 entries
0 | = | No
1 | = | Yes
SWSET | Integer |  | List: 2 entries
0 | = | No
1 | = | Yes
SWCOSTETRY | Integer | Cost |

This page was generated on 2008-May-01

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