View: Material Returns Detail

RotoID: PM0047
Table: PMMATRD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMMATRD

Compositions: 4

RotoID Tables Title DLL
PM0046 PMMATRH Material Returns PMMATRH
PM0485 PMMATRDS Material Return Detail Serial Number PMMATRDS
PM0486 PMMATRDL Material Return Detail Lot Numbers PMMATRDL
PM0535 PMMATRDO Material Return Detail Opt. Fld PMMATRDO

Keys: 3

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

Fields: 98

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 Return 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 A 
ADJCOST 16 BCD*10.5 A 
COSTSEQNUM 17 Long A 
COSTDATE 18 Date A 
ADDCOST 19 BCD*10.3 Additional Cost A 
STOCKITEM 20 Boolean Stock Item A 
COSTMETHOD 21 Integer Cost Method A 
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:8 entries
1 = Moving Average
2 = FIFO
3 = LIFO
4 = Standard Cost
5 = Most Recent Cost
6 = User-specified
7 = Serial
8 = Lot
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 X 
OHEADRATE 40 BCD*10.6 Overhead Rate A X 
HEADPER 41 BCD*5.5 Overhead Percentage A X 
OHSR 42 BCD*10.3 Overhead Amount A X 
OHHM 43 BCD*10.3 Overhead Amount A X 
BILLCCY 44 String*3 Billing Currency A  Mask: %-3N
DETAILNUM 45 Long Detail Number E A 
ARITEM 46 String*16 A/R Item No. 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 
CLOSESN 69 Boolean Close SN A X 
PROID 70 Long SN inter-communication ID A X 
POPUPSN 71 Integer Popup SN A X 
POPUPLT 72 Integer Popup LT A X 
CLOSELT 73 Boolean Close LT A X 
LTSETID 74 Long LT inter-communication ID A X 
FORCEPOPSN 75 Boolean Force popup SN A X 
FORCEPOPLT 76 Boolean Force popup LT A X 
GENICSEQ 77 Boolean Generate IC Seq. A X 
PRICELIST 78 String*6 Price List A X  Mask: %-6N
CUSTCCY 79 String*3 Customer Currency A X 
SERIALQTY 80 Long Number of Serials A X 
LOTQTY 81 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 2022-Aug-18

© 2021 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).