# Table: Material Allocation Detail

Table: PMMTAD
View: PM0461
Record length: 719
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
|  | SEQ, LINENO
|  | MALLOCNO, LINENO
|  | MALLOCNO, DETAILNUM

## Fields: 52

Field | Type | Title | Presentation
--- | --- | --- | ---
SEQ | Long | Sequence |
LINENO | Long | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
MALLOCNO | String*16 | Material Allocation Number | Mask: %-16C
FMTCONTNO | String*16 | ^1 | Mask: %-16C
CONTRACT | String*16 | ^1 | Mask: %-16C
PROJECT | String*16 | ^2 | Mask: %-16N
CATEGORY | String*16 | ^3 | Mask: %-16N
RESOURCE | String*24 | Item Number | Mask: %-24C
DESC | String*60 | Description |
LOCATION | String*6 | Location | Mask: %-6N
COSTMETHOD | Integer | Cost Method |
STOCKITEM | Boolean | Stock Item |
UOM | String*10 | UOM |
UNFMTITEM | String*24 | Unformatted Item Number |
DETAILNUM | Long | Detail Number |
QUANTITY | BCD*10.5 | Allocated Quantity |
UNITCOST | BCD*10.6 | Unit Cost |
BILLRATE | BCD*10.6 | Billing Rate |
BILLTYPE | Integer | Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
EXTBILLSR | BCD*10.3 | Extended Billing Amount |
EXTBILLHR | BCD*10.3 | Billing Amount (Func) |
BILLCCY | String*3 | Billing Currency |
COSTCCY | String*3 | Cost Currency |
APERCENT | BCD*5.5 | Percentage Allocated |
EXTCOSTSR | BCD*10.3 | Extended Cost |
EXTCOSTHM | BCD*10.3 | Extended Allocated Cost |
TOTCOSTSR | BCD*10.3 | Total Cost(Source) |
TOTCOSTHM | BCD*10.3 | Total Cost(Func.) |
OVERHD | Integer | Reserved |
OHEADRATE | BCD*10.6 | Reserved |
HEADPER | BCD*5.5 | Reserved |
OHSR | BCD*10.3 | Stored Overhead |
OHHM | BCD*10.3 | Overhead Allocated |
COMMENTS | String*250 | Comments |
CONTSTYLE | Integer | Style |
PROJTYPE | Integer | Project Type | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
CUSTOMER | String*12 | Customer |
REVREC | Integer | Accounting Method | 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 | Invoice Type | List: 2 entries
1 | = | Item
2 | = | Summary
VALUES | Long | Optional Fields |
STRDQTY | BCD*10.5 | Stored Quantity |
STRDCOSTHM | BCD*10.3 | Extended Stored Cost |
TRANSDATE | Date | Transaction Date |
FISCALYEAR | String*4 | Fiscal Year |
FISCALPER | Integer | Fiscal Period |
CONVERSION | BCD*10.6 | Conversion |
STRDUOM | String*10 | UOM |
STRDCONVER | BCD*10.6 | Stored Conversion Factor |

This page was generated on 2008-May-01

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