View: Opening Balances Detail

RotoID: PM0402
Table: PMOBD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMOBD

Compositions: 1

RotoID Tables 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: 100

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:3 entries
1 = Actuals
2 = Activity
3 = Stored
FMTCONTNO 5 String*16 ^1 E A X  Mask: %-16C
CONTRACT 6 String*16 ^1 E A X  Mask: %-16C
PROJECT 7 String*16 ^2 E A X  Mask: %-16N
COSTREV 8 Integer Actual Type A X  List:2 entries
1 = Cost
2 = Revenue
CATEGORY 9 String*16 ^3 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 Date 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 
PLSTPDATCP 312 Date Last Canadian Payroll Posting Date A X 
PLSTPDATUP 313 Date Last US Payroll Posting Date A X 
CONTSTYLE 500 Integer ^2 Style A C  List:3 entries
0 = Unknown
1 = Standard
2 = Basic
PROJTYPE 501 Integer ^2 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 
STRDQTY 600 BCD*10.5 Stored Quantity A X 
STRDCOSTHM 601 BCD*10.3 Stored Cost A X 
STRDBILLSR 602 BCD*10.3 Stored Billable Amount A X 
PRECOLEDSR 603 BCD*10.3 Previous Completed Work A X 
STRDOHHM 604 BCD*10.3 Overhead Amount A X 
STRDTCSTHM 605 BCD*10.3 Total Stored Cost A 
COHTYPE 606 Integer Overhead Type A C 
COHRATE 607 BCD*10.6 Overhead Rate A C 
COHPER 608 BCD*5.5 Overhead Percentage A C 
USEAIA 609 Integer Use AIA Report E A X 
PREAIAPAY 610 BCD*10.3 Previous Certificates for Payment E A X 
TRANSDATE 611 Date Transaction Date E A X 
FISCALYEAR 612 String*4 Fiscal Year E A X 
FISCALPER 613 Integer Fiscal Period E A X 
PRESTORED 614 BCD*10.3 G703 Column F from Last AIA Report E A X 
PRERETAIN 615 BCD*10.3 G703 Column I from Last AIA Report E A X 
OESHPDATE 616 Date Last O/E Shipment Date A X 
OEINVDATE 617 Date Last O/E Invoice Date A X 
FUNCTION 1000 Integer Function E A X  List:1 entries
0 = None
CONTDESC 1009 String*60 Description rt A C 
PROJDESC 1010 String*60 Description rt A C 
CATDESC 1011 String*60 Description rt A C 
RESDESC 1012 String*60 Description rt A C 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).