View: Material Allocation Detail

RotoID: PM0465
Table: PMMTADA
Protocol: Flat
DLL:PMMTADA

Keys: 3

Title Fields
POSTSEQNO, LINENO
CONTRACT, PROJECT, CATEGORY, TRANSDATE
CONTRACT, PROJECT, TRANSDATE

Fields: 49

Field Index Type Title Attributes Presentation
POSTSEQNO 1 Long Posting Sequence E A K R 
LINENO 2 Long Line Number E A K R 
SEQ 3 Long Sequence E A 
MALLOCNO 4 String*16 Material Allocation Number E A 
FMTCONTNO 5 String*16 ^1 E A 
CONTRACT 6 String*16 ^1 E A 
PROJECT 7 String*16 ^2 E A 
CATEGORY 8 String*16 ^3 E A 
RESOURCE 9 String*24 Item Number E A 
DESC 10 String*60 Description E A 
LOCATION 11 String*6 Location E A 
COSTMETHOD 12 Integer E A 
UOM 13 String*10 Item Unit of Measure E A 
UNFMTITEM 14 String*24 E A 
DETAILNUM 15 Long Detail Number E A 
ARITEM 16 String*16 E A 
ARUOM 17 String*10 E A 
QUANTITY 18 BCD*10.5 Quantity Allocated E A 
UNITCOST 19 BCD*10.6 Unit Cost E A 
BILLRATE 20 BCD*10.6 Billing Rate E A 
BILLTYPE 21 Integer Billing Type E A 
EXTBILLSR 22 BCD*10.3 Extended Billing Amount E A 
EXTBILLHR 23 BCD*10.3 Billing Amount (Func) E A 
BILLCCY 24 String*3 Billing Currency E A 
COSTCCY 25 String*3 E A 
APERCENT 26 BCD*5.5 Allocated Percentage E A 
EXTCOSTSR 27 BCD*10.3 Extended Cost E A 
EXTCOSTHM 28 BCD*10.3 E A 
TOTCOSTSR 29 BCD*10.3 E A 
TOTCOSTHM 30 BCD*10.3 E A 
OVERHD 31 Integer Overhead Type E A 
OHEADRATE 32 BCD*10.6 Overhead Rate E A 
HEADPER 33 BCD*5.5 Overhead Percentage E A 
OHSR 34 BCD*10.3 Overhead Amount E A 
OHHM 35 BCD*10.3 Overhead Amount E A 
COMMENTS 36 String*250 Comments E A 
CONTSTYLE 37 Integer E A C 
PROJTYPE 38 Integer E A C 
CUSTOMER 39 String*12 E A C 
REVREC 40 Integer E A C 
INVTYPE 41 Integer E A C 
TRANSDATE 42 Date E A 
FISCALYEAR 43 String*4 E A 
FISCALPER 44 Integer E A 
VALUES 45 Long Optional Fields E A C 
AIAPRINT 46 Integer E A 
CONVERSION 47 BCD*10.6 Conversion E A 
STRDUOM 48 String*10 UOM E A 
STRDCONVER 49 BCD*10.6 Stored Conversion Factor E A 

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