View: Cost Entries Detail

RotoID: PM0422
Table: PMCED
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMCED

Compositions: 2

RotoID Tables Title DLL
PM0420 PMCEH Cost Entries Header PMCEH
PM0423 PMCEDO Cost Entries Detail Optional Field PMCEDO

Keys: 3

Title Fields
Sequence/Line Number SEQ, LINENO
Docnum/Line Number DOCNUM, LINENO
SEQ, DETAILNUM

Fields: 84

Field Index Type Title Attributes Presentation
SEQ 1 Long Sequence E A K R 
LINENO 2 Long Line Number E A K R 
DOCNUM 3 String*24 Document Number E A C 
LINETYPE 4 Integer Line Type E A  List:7 entries
1 = Miscellaneous Cost
2 = Time
3 = Expense
4 = Equipment
5 = Material Usage
6 = Material Return
7 = Charge
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
CATEGORY 8 String*16 ^3 E A X  Mask: %-16N
RESOURCE 9 String*24 Resource E A P X  Mask: %-16N
TYPE 10 Integer Cost Class A  List:6 entries
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
CHARGECODE 11 String*16 Charge Code E A X  Mask: %-16N
DESC 12 String*60 Description E A X 
QUANTITY 13 BCD*10.5 Quantity A X 
ARITEM 14 String*16 A/R Item No. A X  Mask: %-16C
ARUOM 15 String*10 A/R Unit of Measure A X  Mask: %-10C
UNITCOST 16 BCD*10.6 Unit Cost A X 
COSTCCY 17 String*3 Cost Currency A  Mask: %-3N
EXTCOSTSR 18 BCD*10.3 Extended Cost A X 
EXTCOSTHM 19 BCD*10.3 Extended Cost (HM) A 
OVERHD 20 Integer Overhead Type A C  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 21 BCD*10.6 Overhead Rate A 
HEADPER 22 BCD*5.5 Overhead Percentage A 
OHSR 23 BCD*10.3 Overhead Amount A 
OHHM 24 BCD*10.3 Overhead Amount (HM) A 
LABOR 25 Integer Labor Type A X 
LABORRATE 26 BCD*10.6 Labor Rate A X 
LABORPER 27 BCD*5.5 Labor Percentage A X 
LABORSR 28 BCD*10.3 Transaction Labor Amount (Source) A X 
LABORHM 29 BCD*10.3 Transaction Labor Amount (Functional) A X 
TOTCOSTSR 30 BCD*10.3 Total Cost A 
TOTCOSTHM 31 BCD*10.3 Total Cost (HM) A 
COMMENTS 32 String*250 Comments A X 
TRANACCT 33 String*45 Cost Account A X  Mask: %-45C
OHACCT 34 String*45 Overhead Account A  Mask: %-45C
LABORACCT 35 String*45 Labor Account A X  Mask: %-45C
WIPACCT 36 String*45 Work in Progress Account A X  Mask: %-45C
BILLTYPE 37 Integer Billing Type A X  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
BILLRATE 38 BCD*10.6 Billing Rate A X 
EXTBILLSR 39 BCD*10.3 Billing Amount A X 
EXTBILLHM 40 BCD*10.3 Billing Amount (HM) A 
BILLCCY 41 String*3 Billing Currency A  Mask: %-3N
DETAILNUM 42 Long Detail Number E A C 
TAUTH1 43 String*12 Tax Authority 1 A  Mask: %-12N
TAUTH2 44 String*12 Tax Authority 2 A  Mask: %-12N
TAUTH3 45 String*12 Tax Authority 3 A  Mask: %-12N
TAUTH4 46 String*12 Tax Authority 4 A  Mask: %-12N
TAUTH5 47 String*12 Tax Authority 5 A  Mask: %-12N
TCLASS1 48 Integer Tax Class 1 A X 
TCLASS2 49 Integer Tax Class 2 A X 
TCLASS3 50 Integer Tax Class 3 A X 
TCLASS4 51 Integer Tax Class 4 A X 
TCLASS5 52 Integer Tax Class 5 A X 
TINCLUDED1 53 Boolean Tax Included 1 A X 
TINCLUDED2 54 Boolean Tax Included 2 A X 
TINCLUDED3 55 Boolean Tax Included 3 A X 
TINCLUDED4 56 Boolean Tax Included 4 A X 
TINCLUDED5 57 Boolean Tax Included 5 A X 
CONTSTYLE 58 Integer Contract Style A C X  List:2 entries
1 = Standard
2 = Basic
PROJTYPE 59 Integer Project Type A C X  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CUSTOMER 60 String*12 Customer A C X  Mask: %-12C
REVREC 61 Integer Revenue Rec. Type 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 62 Integer Inventory Type A C X  List:2 entries
1 = Item
2 = Summary
VALUES 63 Long Optional Fields E A C 
PAYTYPE 64 Integer Pay Type A C X 
TRANSDATE 65 Date Transaction Date A X 
EXPENSE 66 String*16 Expense A X 
EXPTYPE 67 Integer Expense Type A X 
LOCATION 68 String*6 Location A X 
ICUOM 69 String*10 I/C Unit of Measure A X  Mask: %-10c
CONVERSION 70 BCD*10.6 A X 
STOCKITEM 71 Boolean Stock Item A C X 
COSTMETHOD 72 Integer Cost Method A C X 
UNFMTITEM 73 String*24 Unformatted Item No. A C X 
GLDDESC 74 String*60 G/L Detail Description A X 
GLDREF 75 String*60 G/L Detail Reference A X 
GLCOMMENT 76 String*250 G/L Detail Comment A X 
FUNCTION 1001 Integer Function onal) E A C 
TRANDESC 1003 String*60 Description onal) A C 
WIPDESC 1004 String*60 Description onal) A C 
ITEMDESC 1005 String*60 Description onal) A C 
CONTDESC 1009 String*60 Description onal) A C 
PROJDESC 1010 String*60 Description onal) A C 
CATDESC 1011 String*60 Description onal) A C 
HASOPT 1012 Boolean Optional Fields onal) 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).