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