Table: Opening Balances Detail

Table: PMOBD
View: PM0402
Record length: 1006
Flags: A R 

Keys: 4

Title  Flags  Fields

Sequence/Line Number  SEQ, LINENO
Document Number/Line Number  M  DOCNUM, LINENO
Sequence/Detail Number  SEQ, DETAILNUM
Open Type/Contract/Project/Categ  D M  OPENTYPE, CONTRACT, PROJECT, CATEGORY, RESOURCE

Fields: 99

Field  Type  Title  Presentation 

SEQ  Long  Sequence   
LINENO  Integer  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DOCNUM  String*16  Document Number  Mask: %-16C
OPENTYPE  Integer  Opening Type  List: 3 entries
1=Actuals
2=Activity
3=Stored
FMTCONTNO  String*16  ^1  Mask: %-16C
CONTRACT  String*16  ^1  Mask: %-16C
PROJECT  String*16  ^2  Mask: %-16N
COSTREV  Integer  Actual Type  List: 2 entries
1=Cost
2=Revenue
CATEGORY  String*16  ^3  Mask: %-16N
RESOURCE  String*24  Resource  Mask: %-24C
COSTTYPE  Integer  Cost Type  List: 7 entries
0=None
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
DETAILNUM  Long  Detail Number   
COMMENTS  String*250  Comments   
CUSTOMER  String*12  Customer  Mask: %-12C
BILLCCY  String*3  Customer Currency  Mask: %-3N
RATETYPE  String*2  Rate Type  Mask: %-2N
RATEOP  Integer  Rate Operation  List: 2 entries
1=Multiply
2=Divide
RATEDATE  Date  Rate Date   
RATE  BCD*8.7  Rate   
RATESPREAD  BCD*8.7  Rate Spread   
OQTY  BCD*10.5  Original Quantity   
AQTY  BCD*10.5  Actual Quantity   
OARITEM  String*16  Original A/R Item Number  Mask: %-16C
OARUOM  String*10  Original A/R Unit of Measure  Mask: %-10C
OUNITCOST  BCD*10.6  Original Unit Cost   
OEXTCOSTSR  BCD*10.3  Original Extended Cost   
OEXTCOSTHM  BCD*10.3  Original Extended Cost   
AEXTCOSTSR  BCD*10.3  Actual Extended Cost   
AEXTCOSTHM  BCD*10.3  Actual Extended Cost   
OOHTYPE  Integer  Overhead Type  List: 4 entries
0=Unknown
1=None
2=Flat Rate Per Unit
5=Percentage of Cost
OOHRATE  BCD*10.6  Overhead Rate   
OOHPER  BCD*5.5  Overhead Percentage   
OOHSR  BCD*10.3  Original Overhead Estimate   
OOHHM  BCD*10.3  Original Overhead Estimate   
AOHSR  BCD*10.3  Actual Overhead   
AOHHM  BCD*10.3  Actual Overhead   
OLABORTYPE  Integer  Labor Type  List: 4 entries
0=Unknown
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   
OLABORSR  BCD*10.3  Original Labor Amount Estimate   
OLABORHM  BCD*10.3  Original Labor Amount Estimate   
ALABORSR  BCD*10.3  Actual Labor Amount   
ALABORHM  BCD*10.3  Actual Labor Amount   
OTOTCOSTSR  BCD*10.3  Original Total Cost   
OTOTCOSTHM  BCD*10.3  Original Total Cost   
ATOTCOSTSR  BCD*10.3  Actual Total Cost   
ATOTCOSTHM  BCD*10.3  Actual Total Cost   
OBILLTYPE  Integer  Billing Type  List: 4 entries
0=Unknown
2=Billable
3=No Charge
1=Non-billable
OBILLRATE  BCD*10.6  Original Billing Rate   
OBILLSR  BCD*10.3  Original Total Revenue   
OBILLHM  BCD*10.3  Original Total Revenue   
ABILLSR  BCD*10.3  Actual Total Revenue   
ABILLHM  BCD*10.3  Actual Total Revenue   
RBILLSR  BCD*10.3  Remaining to be Billed   
OPROFITSR  BCD*10.3  Original Profit   
OPROFITHM  BCD*10.3  Original Profit   
APROFITSR  BCD*10.3  Actual Profit   
APROFITHM  BCD*10.3  Actual Profit   
TARRECTSSR  BCD*10.3  Total A/R Customer Receipts   
ARRECDATE  Date  Last A/R Receipt Posting Date   
TAPPAYMTS  BCD*10.3  Total A/P Vendor Payments   
APPAYDATE  Date  Last A/P Payment Posting Date   
COSTDATE  Date  Last Cost Posting Date   
BILLDATE  Date  Last Billings Posting Date   
REVRECDATE  Date  Last Rev. Recognition Posting Date   
REVESTDATE  Date  Last Revised Posting Date   
LSTBILLPER  BCD*5.5  Last Billings Percent Complete   
PODATE  Date  Last Purchase Order Date   
PORECDATE  Date  Last P/O Receipt Date   
PORETDATE  Date  Last P/O Return Date   
PLSTPDATCP  Date  Last Canadian Payroll Posting Date   
PLSTPDATUP  Date  Last US Payroll Posting Date   
CONTSTYLE  Integer  ^2 Style  List: 3 entries
0=Unknown
1=Standard
2=Basic
PROJTYPE  Integer  ^2 Type  List: 4 entries
0=Unknown
1=Time and Materials
2=Fixed Price
3=Cost Plus
REVREC  Integer  Accounting Method  List: 8 entries
0=Unknown
1=Completed Project
2=Total Cost Percentage Complete
3=Labor Hours Percentage Complete
4=Billings and Costs
5=Project Percentage Complete
6=Category Percentage Complete
8=Accrual-Basis
INVTYPE  Integer  Invoice Type  List: 3 entries
0=Unknown
1=Item
2=Summary
REVERSED  Integer  Reversed   
STRDQTY  BCD*10.5  Stored Quantity   
STRDCOSTHM  BCD*10.3  Stored Cost   
STRDBILLSR  BCD*10.3  Stored Billable Amount   
PRECOLEDSR  BCD*10.3  Previous Completed Work   
STRDOHHM  BCD*10.3  Overhead Amount   
STRDTCSTHM  BCD*10.3  Total Stored Cost   
COHTYPE  Integer  Overhead Type   
COHRATE  BCD*10.6  Overhead Rate   
COHPER  BCD*5.5  Overhead Percentage   
USEAIA  Integer  Use AIA Report   
PREAIAPAY  BCD*10.3  Previous Certificates for Payment   
TRANSDATE  Date  Transaction Date   
FISCALYEAR  String*4  Fiscal Year   
FISCALPER  Integer  Fiscal Period   
PRESTORED  BCD*10.3  G703 Column F from Last AIA Report   
PRERETAIN  BCD*10.3  G703 Column I from Last AIA Report   
OESHPDATE  Date  Last O/E Shipment Date   
OEINVDATE  Date  Last O/E Invoice Date   

This page was generated on 2008-May-01

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