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  Contract  Mask: %-16C
CONTRACT  String*16  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
CATEGORY  String*16  Category  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 2009-Nov-19

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