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

This page was generated on 2009-Nov-19

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