View: Material Usage Detail

RotoID: PM0051
Table: PMMATD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMMATD

Compositions: 4

RotoID Tables Title DLL
PM0050 PMMATH Material Usage PMMATH
PM0483 PMMATDS Material Usage Detail Serial Numbers PMMATDS
PM0484 PMMATDL Material Usage Detail Lot Numbers PMMATDL
PM0537 PMMATDO Material Usage Detail Opt. Field PMMATDO

Keys: 3

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

Fields: 109

Field Index Type Title Attributes Presentation
SEQ 1 Long Sequence E A K R 
LINENO 2 Long Line Number E A K R 
MATERIALNO 3 String*16 Material Number E A C  Mask: %-16C
FMTCONTNO 4 String*16 ^1 E A X  Mask: %-16C
CONTRACT 5 String*16 ^1 E A X  Mask: %-16C
PROJECT 6 String*16 ^2 E A X  Mask: %-16N
CATEGORY 7 String*16 ^3 E A X  Mask: %-16N
RESOURCE 8 String*24 Item Number E A X  Mask: %-24C
DESC 9 String*60 Description E A X 
LOCATION 10 String*6 Location A X  Mask: %-6N
QUANTITY 11 BCD*10.5 Quantity A X 
UOM 12 String*10 Item Unit of Measure A X  Mask: %-10c
CONVERSION 13 BCD*10.6 Conversion A 
UNITCOST 14 BCD*10.6 Unit Cost A X 
ADJUNITCST 15 BCD*10.5 Reserved A 
ADJCOST 16 BCD*10.5 Reserved A 
COSTSEQNUM 17 Long Reserved A 
COSTDATE 18 Date Reserved A 
ADDCOST 19 BCD*10.3 Additional Cost A 
STOCKITEM 20 Boolean Stock Item A 
COSTMETHOD 21 Integer Cost Method A  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 22 String*24 Item Number A X 
CHKBDLZERO 23 Boolean Check Below Zero A 
COSTCCY 24 String*3 Cost Currency A  Mask: %-3N
EXTCOSTSR 25 BCD*10.3 Extended Cost A X 
EXTCOSTHM 26 BCD*10.3 Extended Cost A 
COMMENTS 27 String*250 Comments A X 
ICACCT 28 String*45 I/C Account A  Mask: %-45C
WIPACCT 29 String*45 WIP/COS Account A X  Mask: %-45C
OHACCT 30 String*45 Overhead Account A X  Mask: %-45C
BILLTYPE 31 Integer Billing Type A X  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
FIXEDBILL 32 Integer Bill Amount Based On A  List:2 entries
1 = Invoice This Amount
2 = Invoice Based on Exchange Rate
ESTBILLCCY 33 Integer Revenue And Cost Currency A  List:3 entries
1 = Revenue and Costs in Functional Currency
2 = Revenue in Customer Currency
3 = Revenue and Costs in Customer Currency
BILLRATE 34 BCD*10.6 Billing Rate A X 
EXTBILLSR 35 BCD*10.3 Extended Billing Amount A X 
EXTBILLHM 36 BCD*10.3 Reserved A 
TOTCOSTSR 37 BCD*10.3 Total Cost A 
TOTCOSTHM 38 BCD*10.3 Total Cost A 
OVERHD 39 Integer Overhead Type A 
OHEADRATE 40 BCD*10.6 Overhead Rate A 
HEADPER 41 BCD*5.5 Overhead Percentage A 
OHSR 42 BCD*10.3 Overhead Amount A 
OHHM 43 BCD*10.3 Overhead Amount A 
BILLCCY 44 String*3 Billing Currency A  Mask: %-3N
DETAILNUM 45 Long Detail Number E A 
ARITEM 46 String*16 A/R Item Number A X  Mask: %-16C
ARUOM 47 String*10 A/R Unit of Measure A X  Mask: %-10C
TAUTH1 48 String*12 Tax Authority 1 A  Mask: %-12N
TAUTH2 49 String*12 Tax Authority 2 A  Mask: %-12N
TAUTH3 50 String*12 Tax Authority 3 A  Mask: %-12N
TAUTH4 51 String*12 Tax Authority 4 A  Mask: %-12N
TAUTH5 52 String*12 Tax Authority 5 A  Mask: %-12N
TCLASS1 53 Integer Tax Class 1 A X 
TCLASS2 54 Integer Tax Class 2 A X 
TCLASS3 55 Integer Tax Class 3 A X 
TCLASS4 56 Integer Tax Class 4 A X 
TCLASS5 57 Integer Tax Class 5 A X 
TINCLUDED1 58 Boolean Tax Included 1 A X 
TINCLUDED2 59 Boolean Tax Included 2 A X 
TINCLUDED3 60 Boolean Tax Included 3 A X 
TINCLUDED4 61 Boolean Tax Included 4 A X 
TINCLUDED5 62 Boolean Tax Included 5 A X 
PROJTYPE 63 Integer ^2 Type A C X  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CONTSTYLE 64 Integer ^1 Style A C X  List:2 entries
1 = Standard
2 = Basic
CUSTOMER 65 String*12 Customer A C X  Mask: %-12C
REVREC 66 Integer Accounting Method 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 67 Integer Invoice Type A C X  List:2 entries
1 = Item
2 = Summary
VALUES 68 Long Optional Fields A C X 
FASDETAIL 69 Boolean FAS Attached A X  List:2 entries
0 = No
1 = Yes
FASDB 70 String*32 Database A 
FASCMP 71 String*32 Company A 
FASTMPL 72 String*25 Template A X 
TEXTDESC 73 String*80 Asset Description A X 
SEPQTY 74 Boolean Seperate Quantities A X 
FASQTY 75 BCD*10.5 Asset Quantity A X 
FASUOM 76 String*10 Unit of Measure A X 
AMTHC 77 BCD*10.3 Amount A X 
EMPLOYEENO 78 String*60 Used By A X 
BINTERNAL 79 Boolean Internal Usage A 
CLOSESN 80 Boolean Close SN A X 
PROID 81 Long SN inter-communication ID A X 
POPUPSN 82 Integer Popup SN A X 
POPUPLT 83 Integer Popup LT A X 
CLOSELT 84 Boolean Close LT A X 
LTSETID 85 Long LT inter-communication ID A X 
FORCEPOPSN 86 Boolean Force popup SN A X 
FORCEPOPLT 87 Boolean Force popup LT A X 
GENICSEQ 88 Boolean Generate IC Seq. A X 
PRICELIST 89 String*6 Price List A X  Mask: %-6N
CUSTCCY 90 String*3 Customer Currency A X 
SERIALQTY 91 Long Number of Serials A X 
LOTQTY 92 BCD*10.4 Number of Lots A X 
PROCESSCMD 1012 Integer Process Command A C X  List:7 entries
0 = None
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-Allocate Serials
24 = Auto_Allocate Lots
25 = Clear Serials
26 = Clear Lots
XGENALCQTY 1013 BCD*10.4 Serial/Lot Quantity to process A C X 
XLOTMAKQTY 1014 BCD*10.4 Number of Lots to Generate A C X 
XPERLOTQTY 1015 BCD*10.4 Quantity per Lot A C X 
SALLOCFROM 1016 String*40 Allocate serial from A C X 
LALLOCFROM 1017 String*40 Allocate lot from A C X 
METERHWND 1018 Long Meter handle A C X 
FUNCTION 1001 Integer Function E A C  List:2 entries
0 = None
10 = Load Optional Fields
ICDESC 1003 String*60 Description A C 
WIPDESC 1004 String*60 Description A C 
LOCDESC 1006 String*60 Description A C 
ARDESC 1005 String*60 Description A C 
OHDESC 1007 String*60 Description A C 
HASOPT 1011 Boolean Optional Fields E A C  List:2 entries
0 = No
1 = Yes
CONTDESC 1008 String*60 Description A C 
PROJDESC 1009 String*60 Description A C 
CATDESC 1010 String*60 Description A C 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).