# 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 | Contract | E A X | Mask: %-16C
CONTRACT | 5 | String*16 | Contract | E A X | Mask: %-16C
PROJECT | 6 | String*16 | Project | E A X | Mask: %-16N
CATEGORY | 7 | String*16 | Category | 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 | Project Type | A C X | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
CONTSTYLE | 64 | Integer | Contract 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 2009-Nov-19

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