Table: ^1 Resource ^6

Table: PMRESC
View: PM0121
Record length: 1005
Flags: A R 

Keys: 6

Title  Flags  Fields
Contract Uniquifier/Line Number  CTUNIQ, PLINENUM, CLINENUM
Contract Uniquifier/Detail Numbe  CTUNIQ, DNUM
Contract/Project/Resource/Catego  D  CONTRACT, PROJECT, RESOURCE, CATEGORY
Contract/Project/Category/Resour  D  CONTRACT, PROJECT, CATEGORY, RESOURCE
Type/Contract/Project/Resource/C  D  TYPE, CONTRACT, PROJECT, RESOURCE, CATEGORY
Type/Contract/Project/Category/R  D  TYPE, CONTRACT, PROJECT, CATEGORY, RESOURCE

Fields: 113

Field  Type  Title  Presentation 
CTUNIQ  BCD*10.0  ^1 Uniq   
PLINENUM  Long  Project Line Number   
CLINENUM  Long  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CONTRACT  String*16  ^1  Mask: %-16C
PROJECT  String*16  ^2  Mask: %-16N
DETAILNUM  Long  ^2 Detail Number   
DATELASTMN  Date  Last Maintained   
PNUM  Long  Employee Detail Number   
DNUM  Long  Detail Number   
TYPE  Integer  Cost Class  List: 6 entries
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
RESOURCE  String*24  Resource  Mask: %-16N
ITEMNO  String*24  Unformatted Item Number  Mask: %-24C
LOCATION  String*6  Location  Mask: %-6N
CONVERSION  BCD*10.6  Conversion Factor   
CATEGORY  String*16  ^3  Mask: %-16N
COMMENT  String*60  Description   
COSTTYPE  String*10  Cost Type  Mask: %-10N
BILLTYPE  Integer  Billing Type  List: 3 entries
2=Billable
3=No Charge
1=Non-billable
ORJQTY  BCD*10.5  Quantity   
CURQTY  BCD*10.5  Current Quantity Estimate   
ACTQTY  BCD*10.5  Actual Quantity   
UOM  String*10  Unit of Measure  Mask: %-10C
UNITCOST  BCD*10.6  Unit Cost   
ORJCOSTSR  BCD*10.3  Reserved   
ORJCOSTHM  BCD*10.3  Extended Cost   
CURCOSTSR  BCD*10.3  Reserved   
CURCOSTHM  BCD*10.3  Current Cost Estimate   
ACTCOSTSR  BCD*10.3  Reserved   
ACTCOSTHM  BCD*10.3  Actual Cost   
OVERHD  Integer  Overhead Type  List: 3 entries
1=None
2=Flat Rate Per Unit
5=Percentage of Cost
OHEADRATE  BCD*10.6  Overhead Rate   
HEADPER  BCD*5.5  Overhead Percentage   
ORJOHSR  BCD*10.3  Reserved   
ORJOHHM  BCD*10.3  Original Overhead Estimate   
CUROHSR  BCD*10.3  Reserved   
CUROHHM  BCD*10.3  Current Overhead Estimate   
ACTOHSR  BCD*10.3  Reserved   
ACTOHHM  BCD*10.3  Actual Overhead   
BILLRATE  BCD*10.6  Billing Rate   
COSTPLUSP  BCD*5.5  Cost Plus Percentage   
ORJBILLSR  BCD*10.3  Revenue   
ORJBILLHM  BCD*10.3  Revenue   
CURBILLSR  BCD*10.3  Current Revenue Estimate   
CURBILLHM  BCD*10.3  Current Revenue Estimate   
ACTBILLSR  BCD*10.3  Actual Revenue   
ACTBILLHM  BCD*10.3  Actual Revenue   
ARITEM  String*16  A/R Item No.  Mask: %-16C
LABOR  Integer  Labor Type  List: 3 entries
1=None
2=Flat Rate Per Labor Hour/Unit
3=Percentage of Labor Cost
LABORRATE  BCD*10.6  Labor Rate   
LABORPER  BCD*5.5  Labor Percentage   
ORJLABORSR  BCD*10.3  Reserved   
ORJLABORHM  BCD*10.3  Original Labor Amount Estimate   
CURLABORSR  BCD*10.3  Reserved   
CURLABORHM  BCD*10.3  Current Labor Amount Estimate   
ACTLABORSR  BCD*10.3  Reserved   
ACTLABORHM  BCD*10.3  Actual Labor Amount   
TORJCOSTSR  BCD*10.3  Reserved   
TORJCOSTHM  BCD*10.3  Original Total Cost   
TCURCOSTSR  BCD*10.3  Reserved   
TCURCOSTHM  BCD*10.3  Current Total Cost   
TACTCOSTSR  BCD*10.3  Reserved   
TACTCOSTHM  BCD*10.3  Actual Total Cost   
ADJUNITCST  BCD*10.6  Reserved   
COSTSEQNUM  Long  Reserved   
COSTDATE  Date  Reserved   
STOCKITEM  Boolean  Reserved   
BILLAMT  BCD*10.3  Expected Billings   
OOHTYPE  Integer  Overhead Type  List: 3 entries
1=None
2=Flat Rate Per Unit
5=Percentage of Cost
OOHRATE  BCD*10.6  Overhead Rate   
OOHPER  BCD*5.5  Overhead Percentage   
COHTYPE  Integer  Overhead Type  List: 3 entries
1=None
2=Flat Rate Per Unit
5=Percentage of Cost
COHRATE  BCD*10.6  Overhead Rate   
COHPER  BCD*5.5  Overhead Percentage   
OLABORTYPE  Integer  Labor Type  List: 3 entries
1=None
2=Flat Rate Per Labor Hour/Unit
3=Percentage of Labor Cost
OLABORRATE  BCD*10.6  Labor Rate   
OLABORPER  BCD*5.5  Labor Percentage   
CLABORTYPE  Integer  Labor Type  List: 3 entries
1=None
2=Flat Rate Per Labor Hour/Unit
3=Percentage of Labor Cost
CLABORRATE  BCD*10.6  Labor Rate   
CLABORPER  BCD*5.5  Labor Percentage   
OUNITCOST  BCD*10.6  Original Unit Cost   
OBILLRATE  BCD*10.6  Original Billing Rate   
OCOSTPLUSP  BCD*5.5  Original Cost Plus Percentage   
CUNITCOST  BCD*10.6  Current Unit Cost   
CBILLRATE  BCD*10.6  Current Billing Rate   
CCOSTPLUSP  BCD*5.5  Current Cost Plus Percentage   
ICUOM  String*10  ^7  Mask: %-10c
ODATEFROM  Date  Projected Start Date   
ODATETO  Date  Projected End Date   
CDATEFROM  Date  Current Start Date   
CDATETO  Date  Current End Date   
POQTY  BCD*10.5  Committed P/O Quantity   
POCOSTHM  BCD*10.3  Committed P/O Cost   
POOHHM  BCD*10.3  Committed P/O Overhead   
POLABORHM  BCD*10.3  Committed P/O Labor   
POTCOSTHM  BCD*10.3  Committed P/O Total Cost   
TCUNITCOST  Integer  Default Unit Cost From  List: 1 entries
0=Use Default PJC Option
TCBILLRATE  Integer  Default Billing Rate From  List: 1 entries
0=Use Default PJC Option
PAYTYPE  Integer    List: 3 entries
3=None
1=US Payroll
2=Canadian Payroll
STRDQTY  BCD*10.5  Stored Quantity   
STRDCOSTHM  BCD*10.3  Stored Cost   
STRDBILLSR  BCD*10.3  Stored Billable Amount   
PRECOLEDSR  BCD*10.3  Previous D + E   
STRDOHHM  BCD*10.3  Overhead Amount   
STRDTCSTHM  BCD*10.3  Total Stored Cost   
TXEXPCOMHM  BCD*10.3  Tax (exp) Committed (func)   
TXALLCOMHM  BCD*10.3  Tax (all) Committed (func)   
PREAIAPAY  BCD*10.3  Previous Certificates for Payment   
PRESTORED  BCD*10.3  G703 Column F from Last AIA Report   
PRERETAIN  BCD*10.3  G703 Column I from Last AIA Report   

This page was generated on 2008-May-01

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