View: Equipment Detail

RotoID: PM0031
Table: PMEQIPD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMEQIPD

Compositions: 2

RotoID Tables Title DLL
PM0030 PMEQIPH Equipment PMEQIPH
PM0506 PMEQDO Equipment Detail Optional Field PMEQDO

Keys: 3

Title Fields
Sequence/Line Number SEQ, LINENO
Equipment Number/Line Number EQUIPNO, LINENO
Sequence/Detail Number SEQ, DETAILNUM

Fields: 67

Field Index Type Title Attributes Presentation
SEQ 1 Long Sequence E A K R 
LINENO 2 Long Line Number E A K R 
EQUIPNO 3 String*16 Equipment Number E A C  Mask: %-16C
FMTCONTNO 4 String*16 ^1 E A X  Mask: %-16C
CONTRACT 5 String*16 ^1 E A X  Mask: %-16C
PROJECT 6 String*16 ^2 E A X  Mask: %-16N
CATEGORY 7 String*16 ^3 E A X  Mask: %-16N
RESOURCE 8 String*24 Equipment Code E A X  Mask: %-16N
DESC 9 String*60 Description E A X 
QUANTITY 10 BCD*10.5 Quantity A X 
ARITEM 11 String*16 A/R Item Number A P X  Mask: %-16C
UOM 12 String*10 Unit of Measure A X  Mask: %-10C
UNITCOST 13 BCD*10.6 Unit Cost A X 
COSTCCY 14 String*3 Cost Currency A  Mask: %-3N
EXTCOSTSR 15 BCD*10.3 Extended Cost A X 
EXTCOSTHM 16 BCD*10.3 Extended Cost A 
OVERHD 17 Integer Overhead Type A  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 18 BCD*10.6 Overhead Rate A 
HEADPER 19 BCD*5.5 Overhead Percentage A 
OHSR 20 BCD*10.3 Overhead Amount A 
OHHM 21 BCD*10.3 Overhead Amount A 
TOTCOSTSR 22 BCD*10.3 Total Cost A 
TOTCOSTHM 23 BCD*10.3 Total Cost A 
COMMENTS 24 String*250 Comments A X 
OHACCT 25 String*45 Overhead Account A  Mask: %-45C
EQUIPACCT 26 String*45 Equipment Account A X  Mask: %-45C
WIPACCT 27 String*45 WIP/COS Account A X  Mask: %-45C
BILLTYPE 28 Integer Billing Type A X  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
FIXEDBILL 29 Integer Bill Amount Based On A  List:2 entries
1 = Invoice This Amount
2 = Invoice Based on Exchange Rate
ESTBILLCCY 30 Integer Revenue And Cost Currency A  List:3 entries
1 = Revenue and Costs in Functional Currency
2 = Revenue in Customer Currency
3 = Revenue and Costs in Customer Currency
BILLRATE 31 BCD*10.6 Billing Rate A X 
EXTBILLSR 32 BCD*10.3 Extended Billing Amount A X 
EXTBILLHM 33 BCD*10.3 Reserved A 
BILLCCY 34 String*3 Billing Currency A  Mask: %-3N
DETAILNUM 35 Long Detail Number E A 
TAUTH1 36 String*12 Tax Authority 1 A  Mask: %-12N
TAUTH2 37 String*12 Tax Authority 2 A  Mask: %-12N
TAUTH3 38 String*12 Tax Authority 3 A  Mask: %-12N
TAUTH4 39 String*12 Tax Authority 4 A  Mask: %-12N
TAUTH5 40 String*12 Tax Authority 5 A  Mask: %-12N
TCLASS1 41 Integer Tax Class 1 A X 
TCLASS2 42 Integer Tax Class 2 A X 
TCLASS3 43 Integer Tax Class 3 A X 
TCLASS4 44 Integer Tax Class 4 A X 
TCLASS5 45 Integer Tax Class 5 A X 
TINCLUDED1 46 Boolean Tax Included 1 A X 
TINCLUDED2 47 Boolean Tax Included 2 A X 
TINCLUDED3 48 Boolean Tax Included 3 A X 
TINCLUDED4 49 Boolean Tax Included 4 A X 
TINCLUDED5 50 Boolean Tax Included 5 A X 
CONTSTYLE 51 Integer ^1 Style A C X  List:2 entries
1 = Standard
2 = Basic
PROJTYPE 52 Integer ^2 Type A C X  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CUSTOMER 53 String*12 Customer A C X  Mask: %-12C
REVREC 54 Integer Accounting Method A C X  List:7 entries
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 55 Integer Invoice Type A C X  List:2 entries
1 = Item
2 = Summary
VALUES 56 Long Optional Fields E A C 
GLDDESC 57 String*60 G/L Detail Description A X 
GLDREF 58 String*60 G/L Detail Reference A X 
GLCOMMENT 59 String*250 G/L Detail Comment A X 
FUNCTION 1001 Integer Function E A C  List:2 entries
0 = None
10 = Load Optional Fields
EADESC 1003 String*60 Description A C 
WIPDESC 1004 String*60 Description A C 
ITEMDESC 1005 String*60 Description A C 
CONTDESC 1009 String*60 Description A C 
PROJDESC 1010 String*60 Description A C 
CATDESC 1011 String*60 Description A C 
HASOPT 1012 Boolean Optional Fields E A C  List:2 entries
0 = No
1 = Yes

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