# 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 | 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
CATEGORY | 8 | String*16 | Category | 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 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.