View: Equipment Audit Detail

RotoID: PM0033
Table: PMEQPDA
Protocol: Flat
DLL:PMEQIPDA

Keys: 3

Title Fields
Posting Sequence/Line Number POSTSEQNO, LINENO
Posting Sequence/Detail Number POSTSEQNO, DETAILNUM
Sequence/Posting Sequence/Detail SEQ, POSTSEQNO, DETAILNUM

Fields: 60

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 
EQUIPNO 4 String*16 Equipment 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 Equipment Code E A 
DESC 10 String*60 Description E A 
QUANTITY 11 BCD*10.5 Quantity E A 
ARITEM 12 String*16 A/R Item No. E A 
UOM 13 String*10 Unit of Measure E A 
UNITCOST 14 BCD*10.6 Unit Cost E A 
COSTCCY 15 String*3 Cost Currency E A 
EXTCOSTSR 16 BCD*10.3 Extended Cost E A 
EXTCOSTHM 17 BCD*10.3 Extended Cost E A 
OHACCT 18 String*45 Overhead Account E A 
OVERHD 19 Integer Overhead Type E A 
OHEADRATE 20 BCD*10.6 Overhead Rate E A 
HEADPER 21 BCD*5.5 Overhead Percentage E A 
OHSR 22 BCD*10.3 Transaction Overhead Amount E A 
OHHM 23 BCD*10.3 Transaction Overhead Amount E A 
TOTCOSTSR 24 BCD*10.3 Total Cost E A 
TOTCOSTHM 25 BCD*10.3 Total Cost E A 
COMMENTS 26 String*250 Comments E A 
EQUIPACCT 27 String*45 Equipment Account E A 
WIPACCT 28 String*45 Work in Progress Account E A 
BILLTYPE 29 Integer Billing Type E A 
FIXEDBILL 30 Integer Bill Amount Based On E A 
ESTBILLCCY 31 Integer Revenue And Cost Currency E A 
BILLRATE 32 BCD*10.6 Billing Rate E A 
EXTBILLSR 33 BCD*10.3 Extended Billing Amount E A 
EXTBILLHM 34 BCD*10.3 Reserved E A 
BILLCCY 35 String*3 Billing Currency E A 
DETAILNUM 36 Long Detail Number E A 
TAUTH1 37 String*12 Tax Authority 1 E A 
TAUTH2 38 String*12 Tax Authority 2 E A 
TAUTH3 39 String*12 Tax Authority 3 E A 
TAUTH4 40 String*12 Tax Authority 4 E A 
TAUTH5 41 String*12 Tax Authority 5 E A 
TCLASS1 42 Integer Tax Class 1 E A 
TCLASS2 43 Integer Tax Class 2 E A 
TCLASS3 44 Integer Tax Class 3 E A 
TCLASS4 45 Integer Tax Class 4 E A 
TCLASS5 46 Integer Tax Class 5 E A 
TINCLUDED1 47 Boolean Tax Included 1 E A 
TINCLUDED2 48 Boolean Tax Included 2 E A 
TINCLUDED3 49 Boolean Tax Included 3 E A 
TINCLUDED4 50 Boolean Tax Included 4 E A 
TINCLUDED5 51 Boolean Tax Included 5 E A 
PROJTYPE 52 Integer ^2 Type E A 
CONTSTYLE 53 Integer ^1 Style E A C 
CUSTOMER 54 String*12 Customer E A C 
REVREC 55 Integer Accounting Method E A C 
INVTYPE 56 Integer Invoice Type E A C 
VALUES 57 Long Optional Fields E A C 
GLDDESC 58 String*60 G/L Detail Description E A 
GLDREF 59 String*60 G/L Detail Reference E A 
GLCOMMENT 60 String*250 G/L Detail Comment E A 

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