# Table: Cost Entries Detail

Table: PMCED
View: PM0422
Record length: 1002
Flags: A R

## Keys: 3

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

## Fields: 72

Field | Type | Title | Presentation
--- | --- | --- | ---
SEQ | Long | Sequence |
LINENO | Long | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DOCNUM | String*24 | Document Number |
LINETYPE | Integer | Line Type | List: 7 entries
1 | = | Miscellaneous Cost
2 | = | Time
3 | = | Expense
4 | = | Equipment
5 | = | Material Usage
6 | = | Material Return
7 | = | Charge
FMTCONTNO | String*16 | Contract | Mask: %-16C
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CATEGORY | String*16 | Category | Mask: %-16N
RESOURCE | String*24 | Resource | Mask: %-24C
TYPE | Integer | TYPE | List: 6 entries
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
CHARGECODE | String*16 | Charge Code | Mask: %-16N
DESC | String*60 | Description |
QUANTITY | BCD*10.5 | Quantity |
ARITEM | String*16 | A/R Item No. | Mask: %-16C
ARUOM | String*10 | A/R Unit of Measure | Mask: %-10C
UNITCOST | BCD*10.6 | Unit Cost |
COSTCCY | String*3 | Cost Currency | Mask: %-3N
EXTCOSTSR | BCD*10.3 | Extended Cost |
EXTCOSTHM | BCD*10.3 | Extended Cost (HM) |
OVERHD | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | BCD*10.6 | Overhead Rate |
HEADPER | BCD*5.5 | Overhead Percentage |
OHSR | BCD*10.3 | Overhead Amount |
OHHM | BCD*10.3 | Overhead Amount (HM) |
TOTCOSTSR | BCD*10.3 | Total Cost |
TOTCOSTHM | BCD*10.3 | Total Cost (HM) |
COMMENTS | String*250 | Comments |
TRANACCT | String*45 | Transaction Account | Mask: %-45C
OHACCT | String*45 | Overhead Account | Mask: %-45C
LABORACCT | String*45 | Labor Account | Mask: %-45C
WIPACCT | String*45 | Work in Progress Account | Mask: %-45C
BILLTYPE | Integer | Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
BILLRATE | BCD*10.6 | Billing Rate |
EXTBILLSR | BCD*10.3 | Billing Amount |
EXTBILLHM | BCD*10.3 | Billing Amount (HM) |
BILLCCY | String*3 | Billing Currency | Mask: %-3N
DETAILNUM | Long | Detail Number |
TAUTH1 | String*12 | Tax Authority 1 | Mask: %-12N
TAUTH2 | String*12 | Tax Authority 2 | Mask: %-12N
TAUTH3 | String*12 | Tax Authority 3 | Mask: %-12N
TAUTH4 | String*12 | Tax Authority 4 | Mask: %-12N
TAUTH5 | String*12 | Tax Authority 5 | Mask: %-12N
TCLASS1 | Integer | Tax Class 1 |
TCLASS2 | Integer | Tax Class 2 |
TCLASS3 | Integer | Tax Class 3 |
TCLASS4 | Integer | Tax Class 4 |
TCLASS5 | Integer | Tax Class 5 |
TINCLUDED1 | Boolean | Tax Included 1 |
TINCLUDED2 | Boolean | Tax Included 2 |
TINCLUDED3 | Boolean | Tax Included 3 |
TINCLUDED4 | Boolean | Tax Included 4 |
TINCLUDED5 | Boolean | Tax Included 5 |
CONTSTYLE | Integer | Contract Style | List: 2 entries
1 | = | Standard
2 | = | Basic
PROJTYPE | Integer | Project Type | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
CUSTOMER | String*12 | Customer | Mask: %-12C
REVREC | Integer | Revenue Rec. Type | 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 | Integer | Inventory Type | List: 2 entries
1 | = | Item
2 | = | Summary
VALUES | Long | Optional Fields |
PAYTYPE | Integer | Pay Type |
TRANSDATE | Date | Transaction Date |
EXPENSE | String*16 | Expense |
EXPTYPE | Integer | Expense Type |
LOCATION | String*6 | Location |
ICUOM | String*10 | I/C Unit of Measure | Mask: %-10c
CONVERSION | BCD*10.6 | CONVERSION |
STOCKITEM | Boolean | Stock Item |
COSTMETHOD | Integer | Cost Method |
UNFMTITEM | String*24 | Unformatted Item No. |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.