Table: Optional Fields Detail

Table: PMOFD
View: PM0500
Record Length: 148

Flags: A R 

Keys: 1

Title Flags Fields

Optional Field Value LOCATIONOPTFIELD

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 I/C Shipments
SWICSHPD Integer I/C Shipments Details
SWICADJ Integer I/C Adjustments
SWICADJD Integer I/C 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