# View: Opening Balances Detail

RotoID: PM0402
Table: PMOBD
DLL: PMOBD

## Compositions: 1

RotoID | Table | Title | DLL
--- | --- | --- | ---
PM0401 | PMOBH | Opening Balances | PMOBH

## Keys: 4

Title | Fields
--- | ---
Sequence/Line Number | SEQ, LINENO
Document Number/Line Number | DOCNUM, LINENO
Sequence/Detail Number | SEQ, DETAILNUM
Open Type/Contract/Project/Categ | OPENTYPE, CONTRACT, PROJECT, CATEGORY, RESOURCE

## Fields: 80

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SEQ | 1 | Long | Sequence | E A K R |
LINENO | 2 | Integer | Line Number | E A K R |
DOCNUM | 3 | String*16 | Document Number | E A C | Mask: %-16C
OPENTYPE | 4 | Integer | Opening Type | E A X | List: 2 entries
1 | = | Actuals
2 | = | Activity
FMTCONTNO | 5 | String*16 | Contract | E A X | Mask: %-16C
CONTRACT | 6 | String*16 | Contract | E A X | Mask: %-16C
PROJECT | 7 | String*16 | Project | E A X | Mask: %-16N
COSTREV | 8 | Integer | Actual Type | A X | List: 2 entries
1 | = | Cost
2 | = | Revenue
CATEGORY | 9 | String*16 | Category | E A X | Mask: %-16N
RESOURCE | 10 | String*24 | Resource | A X | Mask: %-24C
COSTTYPE | 11 | Integer | Cost Type | E A X | List: 7 entries
0 | = | None
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
DETAILNUM | 12 | Long | Detail Number | E A C X |
COMMENTS | 13 | String*250 | Comments | E A X |
CUSTOMER | 14 | String*12 | Customer | A C | Mask: %-12C
BILLCCY | 15 | String*3 | Customer Currency | A C | Mask: %-3N
RATETYPE | 16 | String*2 | Rate Type | A | Mask: %-2N
RATEOP | 17 | Integer | Rate Operation | A C | List: 2 entries
1 | = | Multiply
2 | = | Divide
RATEDATE | 18 | Date | Rate Date | A |
RATE | 19 | BCD*8.7 | Rate | A |
RATESPREAD | 20 | BCD*8.7 | Rate Spread | A C |
OQTY | 21 | BCD*10.5 | Original Quantity | A C |
AQTY | 22 | BCD*10.5 | Actual Quantity | A X |
OARITEM | 23 | String*16 | Original A/R Item Number | A | Mask: %-16C
OARUOM | 24 | String*10 | Original A/R Unit of Measure | A C | Mask: %-10C
OUNITCOST | 25 | BCD*10.6 | Original Unit Cost | A C |
OEXTCOSTSR | 26 | BCD*10.3 | Original Extended Cost | A |
OEXTCOSTHM | 27 | BCD*10.3 | Original Extended Cost | A C |
AEXTCOSTSR | 28 | BCD*10.3 | Actual Extended Cost | A |
AEXTCOSTHM | 29 | BCD*10.3 | Actual Extended Cost | A X |
OOHTYPE | 30 | Integer | Overhead Type | A C | List: 4 entries
0 | = | Unknown
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OOHRATE | 31 | BCD*10.6 | Overhead Rate | A C |
OOHPER | 32 | BCD*5.5 | Overhead Percentage | A C |
OOHSR | 33 | BCD*10.3 | Original Overhead Estimate | A |
OOHHM | 34 | BCD*10.3 | Original Overhead Estimate | A C |
AOHSR | 35 | BCD*10.3 | Actual Overhead | A |
AOHHM | 36 | BCD*10.3 | Actual Overhead | E A X |
OLABORTYPE | 37 | Integer | Labor Type | A C | List: 4 entries
0 | = | Unknown
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
OLABORRATE | 38 | BCD*10.6 | Labor Rate | A C |
OLABORPER | 39 | BCD*5.5 | Labor Percentage | A C |
OLABORSR | 40 | BCD*10.3 | Original Labor Amount Estimate | A |
OLABORHM | 41 | BCD*10.3 | Original Labor Amount Estimate | A C |
ALABORSR | 42 | BCD*10.3 | Actual Labor Amount | A |
ALABORHM | 43 | BCD*10.3 | Actual Labor Amount | E A X |
OTOTCOSTSR | 44 | BCD*10.3 | Original Total Cost | A |
OTOTCOSTHM | 45 | BCD*10.3 | Original Total Cost | A C |
ATOTCOSTSR | 46 | BCD*10.3 | Actual Total Cost | A |
ATOTCOSTHM | 47 | BCD*10.3 | Actual Total Cost | A C |
OBILLTYPE | 48 | Integer | Billing Type | A C | List: 4 entries
0 | = | Unknown
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
OBILLRATE | 49 | BCD*10.6 | Original Billing Rate | A C |
OBILLSR | 50 | BCD*10.3 | Original Total Revenue | A C |
OBILLHM | 51 | BCD*10.3 | Original Total Revenue | A C |
ABILLSR | 52 | BCD*10.3 | Actual Total Revenue | A X |
ABILLHM | 53 | BCD*10.3 | Actual Total Revenue | A X |
RBILLSR | 54 | BCD*10.3 | Remaining to be Billed | A X |
OPROFITSR | 55 | BCD*10.3 | Original Profit | A C |
OPROFITHM | 56 | BCD*10.3 | Original Profit | A C |
APROFITSR | 57 | BCD*10.3 | Actual Profit | A C |
APROFITHM | 58 | BCD*10.3 | Actual Profit | A C |
TARRECTSSR | 300 | BCD*10.3 | Total A/R Customer Receipts | A X |
ARRECDATE | 301 | Date | Last A/R Receipt Posting Date | A X |
TAPPAYMTS | 302 | BCD*10.3 | Total A/P Vendor Payments | A X |
APPAYDATE | 303 | Date | Last A/P Payment Posting Date | A X |
COSTDATE | 304 | Date | Last Cost Posting Date | A X |
BILLDATE | 305 | Date | Last Billings Posting Date | A X |
REVRECDATE | 306 | Date | Last Rev. Recognition Posting Da | A X |
REVESTDATE | 307 | Date | Last Revised Posting Date | A X |
LSTBILLPER | 308 | BCD*5.5 | Last Billings Percent Complete | A X |
PODATE | 309 | Date | Last Purchase Order Date | A X |
PORECDATE | 310 | Date | Last P/O Receipt Date | A X |
PORETDATE | 311 | Date | Last P/O Return Date | A X |
CONTSTYLE | 500 | Integer | Project Style | A C | List: 3 entries
0 | = | Unknown
1 | = | Standard
2 | = | Basic
PROJTYPE | 501 | Integer | Project Type | A C | List: 4 entries
0 | = | Unknown
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
REVREC | 502 | Integer | Accounting Method | A C | 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 | 503 | Integer | Invoice Type | A C | List: 3 entries
0 | = | Unknown
1 | = | Item
2 | = | Summary
REVERSED | 504 | Integer | Reversed | A C |
FUNCTION | 1000 | Integer | Function | E A X | List: 1 entries
0 | = | None
CONTDESC | 1009 | String*60 | Description | A C |
PROJDESC | 1010 | String*60 | Description | A C |
CATDESC | 1011 | String*60 | Description | A C |
RESDESC | 1012 | String*60 | Description | A C |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.