Table: Material Usage Detail

Table: PMMATD
View: PM0051
Record length: 1259
Flags: A R 

Keys: 3

Title  Flags  Fields

Sequence/Line Number  SEQ, LINENO
Material Number/Line Number  MATERIALNO, LINENO
Sequence/Detail Number  MATERIALNO, DETAILNUM

Fields: 96

Field  Type  Title  Presentation 

SEQ  Long  Sequence   
LINENO  Long  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
MATERIALNO  String*16  Material 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
QUANTITY  BCD*10.5  Quantity   
UOM  String*10  Item Unit of Measure  Mask: %-10c
CONVERSION  BCD*10.6  Conversion   
UNITCOST  BCD*10.6  Unit Cost   
ADJUNITCST  BCD*10.5  Reserved   
ADJCOST  BCD*10.5  Reserved   
COSTSEQNUM  Long  Reserved   
COSTDATE  Date  Reserved   
ADDCOST  BCD*10.3  Additional Cost   
STOCKITEM  Boolean  Stock Item   
COSTMETHOD  Integer  Cost Method  List: 8 entries
1=Moving Average
2=FIFO
3=LIFO
4=Standard Cost
5=Most Recent Cost
6=User-specified
7=Serial
8=Lot
UNFMTITEM  String*24  Item Number   
CHKBDLZERO  Boolean  Check Below Zero   
COSTCCY  String*3  Cost Currency  Mask: %-3N
EXTCOSTSR  BCD*10.3  Extended Cost   
EXTCOSTHM  BCD*10.3  Extended Cost   
COMMENTS  String*250  Comments   
ICACCT  String*45  I/C Account  Mask: %-45C
WIPACCT  String*45  WIP/COS Account  Mask: %-45C
OHACCT  String*45  Overhead Account  Mask: %-45C
BILLTYPE  Integer  Billing Type  List: 3 entries
2=Billable
3=No Charge
1=Non-billable
FIXEDBILL  Integer  Bill Amount Based On  List: 2 entries
1=Invoice This Amount
2=Invoice Based on Exchange Rate
ESTBILLCCY  Integer  Revenue And Cost Currency  List: 3 entries
1=Revenue and Costs in Functional Currency
2=Revenue in Customer Currency
3=Revenue and Costs in Customer Currency
BILLRATE  BCD*10.6  Billing Rate   
EXTBILLSR  BCD*10.3  Extended Billing Amount   
EXTBILLHM  BCD*10.3  Reserved   
TOTCOSTSR  BCD*10.3  Total Cost   
TOTCOSTHM  BCD*10.3  Total Cost   
OVERHD  Integer  Overhead Type   
OHEADRATE  BCD*10.6  Overhead Rate   
HEADPER  BCD*5.5  Overhead Percentage   
OHSR  BCD*10.3  Overhead Amount   
OHHM  BCD*10.3  Overhead Amount   
BILLCCY  String*3  Billing Currency  Mask: %-3N
DETAILNUM  Long  Detail Number   
ARITEM  String*16  A/R Item Number  Mask: %-16C
ARUOM  String*10  A/R Unit of Measure  Mask: %-10C
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   
PROJTYPE  Integer  Project Type  List: 3 entries
1=Time and Materials
2=Fixed Price
3=Cost Plus
CONTSTYLE  Integer  Contract Style  List: 2 entries
1=Standard
2=Basic
CUSTOMER  String*12  Customer  Mask: %-12C
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   
FASDETAIL  Boolean  FAS Attached  List: 2 entries
0=No
1=Yes
FASDB  String*32  Database   
FASCMP  String*32  Company   
FASTMPL  String*25  Template   
TEXTDESC  String*80  Asset Description   
SEPQTY  Boolean  Seperate Quantities   
FASQTY  BCD*10.5  Asset Quantity   
FASUOM  String*10  Unit of Measure   
AMTHC  BCD*10.3  Amount   
EMPLOYEENO  String*60  Used By   
BINTERNAL  Boolean  Internal Usage   
CLOSESN  Boolean  Close SN   
PROID  Long  SN inter-communication ID   
POPUPSN  Integer  Popup SN   
POPUPLT  Integer  Popup LT   
CLOSELT  Boolean  Close LT   
LTSETID  Long  LT inter-communication ID   
FORCEPOPSN  Boolean  Force popup SN   
FORCEPOPLT  Boolean  Force popup LT   
GENICSEQ  Boolean  Generate IC Seq.   
PRICELIST  String*6  Price List  Mask: %-6N
CUSTCCY  String*3  Customer Currency   
SERIALQTY  Long  Number of Serials   
LOTQTY  BCD*10.4  Number of Lots   

This page was generated on 2009-Nov-19

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