View: Committed Costs Audit

RotoID: PM0320
Table: PMCOCA
Protocol: Flat
DLL:PMCOCA

Keys: 4

Title Fields
Posting Seq. POSTSEQNO
Contract/Project/Category/Date CONTRACT, PROJECT, CATEGORY, TRANSDATE
Contract/Project/Category/Vendor CONTRACT, PROJECT, CATEGORY, VENDORID, TRANSDATE
Contract/Project/Category/Source CONTRACT, PROJECT, CATEGORY, MODULE, TRANSDATE

Fields: 33

Field Index Type Title Attributes Presentation
POSTSEQNO 1 Long Posting Sequence E A K R 
CONTRACT 2 String*16 ^1 E A 
PROJECT 3 String*16 ^2 E A 
CATEGORY 4 String*16 ^3 E A 
RESOURCE 5 String*24 Resource E A 
RSCNAME 6 String*60 Resource Name E A 
TRANSNUM 7 Long Transaction Number E A 
MODULE 8 String*4 Module E A 
SRCPOCOCA 9 Integer E A 
TRANSDATE 10 Date Transaction Date E A 
TRANSTYPE 11 Integer Transaction Type E A 
DOCTYPE 12 Integer Document Type E A 
DOCNUM 13 String*24 Document Number E A 
APCNTBTCH 14 BCD*5.0 Batch Number E A 
APCNTENT 15 BCD*4.0 Batch Entry Number E A 
APCNTLINE 16 BCD*3.0 Batch Line Number E A 
VENDORID 17 String*12 Vendor ID E A 
VENDORNAME 18 String*60 Vendor Name E A 
PODAYENDSQ 19 Long Day End Sequence E A 
POSEQNO 20 BCD*10.0 Sequence Key E A 
POLINENO 21 BCD*10.0 Line Number E A 
QUANTITY 22 BCD*10.5 Committed Quantity E A 
OHHM 23 BCD*10.3 Committed OverHead E A 
LABORHM 24 BCD*10.3 Committed Labor E A 
TXALLCOMHM 25 BCD*10.3 Committed Allocated Tax E A 
TXEXPCOMHM 26 BCD*10.3 Committed Expensed Tax E A 
COSTHM 27 BCD*10.3 Committed Cost E A 
TCOSTHM 28 BCD*10.3 Total Committed Cost E A 
DRILLSRCTY 29 Integer Drill Down Type E A 
DRILLDWNLK 30 BCD*10.0 Drill Down Link E A 
DRILLAPP 31 String*2 Drill Down Application E A 
ICUOM 32 String*10 I/C Unit of Measure E A 
CONVERSION 33 BCD*10.6 Conversion 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).