View: Adjustments Audit Detail

RotoID: PM0065
Table: PMADJDA
Protocol: Flat
DLL:PMADJDA

Keys: 3

Title Fields
Seq/Line no. POSTSEQNO, LINENO
Adjustment/line no. POSTSEQNO, DETAILNUM
Seq/Detail line SEQ, POSTSEQNO, DETAILNUM

Fields: 111

Field Index Type Title Attributes Presentation
POSTSEQNO 1 Long Posting Sequence E A K R 
LINENO 2 Long Line Number E A K R 
ADJUSTNO 3 String*16 Adjustment Number E A 
ADJTYPE 4 Integer Adjustment Type E A 
SEQ 5 Long Sequence E A 
FMTCONTNO 6 String*16 Original ^1 E A 
CONTRACT 7 String*16 Original ^1 E A 
PROJECT 8 String*16 Original ^2 E A 
CATEGORY 9 String*16 Original ^3 E A 
RESOURCE 10 String*24 Original Resource E A 
ITEMNO 11 String*24 From Unformatted Item Number E A 
COSTREV 12 Integer Cost or Revenue E A 
COSTNUM 13 Long Cost No. E A 
REVNUM 14 Long Revenue No. E A 
DOCNUM 15 String*24 Document No. E A 
OBILLTYPE 16 Integer Original Billing Type E A 
OARITEM 17 String*16 Original A/R Item Number E A 
OARUOM 18 String*10 Original A/R Unit of Measure E A 
OICUOM 19 String*10 Original ^7 E A 
OQUANTITY 20 BCD*10.5 Original Quantity E A 
OUNITCOST 21 BCD*10.6 Original Unit Cost E A 
OBILLRATE 22 BCD*10.6 Original Billing Rate E A 
OEXTCOSTHM 23 BCD*10.3 Original Extended Cost E A 
OEXTCOSTSR 24 BCD*10.3 Original Extended Cost E A 
OEXTBILLSR 25 BCD*10.3 Original Extended Billing Amount E A 
OLABOR 26 Integer Original Labor Type E A 
OLABORRATE 27 BCD*10.6 Original Labor Rate E A 
OLABORPER 28 BCD*5.5 Original Labor Percentage E A 
OLABORAMT 29 BCD*10.3 Original Labor Amount E A 
OOVERHD 30 Integer Original Overhead Type E A 
OOHEADRATE 31 BCD*10.6 Original Overhead Rate E A 
OHEADPER 32 BCD*5.5 Original Overhead Percentage E A 
OOHAMT 33 BCD*10.3 Original Overhead Amount E A 
OTOTAMTHM 34 BCD*10.3 Original Total Amount E A 
OBILLCCY 35 String*3 Original Billing Currency E A 
OCONTSTYLE 36 Integer Original ^2 Style E A 
OPROJTYPE 37 Integer Original ^2 Type E A 
OCUSTOMER 38 String*12 Original Customer No. E A 
OREVREC 39 Integer Original Accounting Method E A 
OINVTYPE 40 Integer Original Invoice Type E A 
OWIPACCT 41 String*45 From WIP Account E A C 
OTRANACCT 42 String*45 From Transaction Account E A C 
OREVACCT 43 String*45 From Revenue Account E A C 
OOHACCT 44 String*45 From Overhead Account E A C 
OLABACCT 45 String*45 From Labor Account E A C 
OCVACCT 46 String*45 From Cost Variance Account E A C 
TRANSDATE 47 Date Transaction Date E A 
FISCALYEAR 48 String*4 Fiscal Year E A C 
FISCALPER 49 Integer Fiscal Period E A C 
VENDORID 50 String*12 Vendor E A 
MODULE 51 String*2 Module E A 
DOCTYPE 52 Integer Document Type E A 
TRANSTYPE 53 Integer Transaction Type E A 
COSTCCY 54 String*3 Cost Currency E A 
USERID 55 String*8 User ID E A 
DETAILNUM 56 Long Detail Number E A 
TIMETYPE 57 Integer Time Type E A 
DWIPACCT 58 String*45 To WIP Account E A C 
DTRANACCT 59 String*45 To Transaction Account E A C 
DREVACCT 60 String*45 To Revenue Account E A C 
DOHACCT 61 String*45 To Overhead Account E A C 
DLABACCT 62 String*45 To Labor Account E A C 
DCVACCT 63 String*45 To Cost Variance Account E A C 
DFMTCONTNO 64 String*16 To ^1 E A 
DCONTRACT 65 String*16 To ^1 E A 
DPROJECT 66 String*16 To ^2 E A 
DCATEGORY 67 String*16 To ^3 E A 
DCOSTTYPE 68 Integer Cost Type E A 
DRESOURCE 69 String*24 To Resource E A 
DITEMNO 70 String*24 To Unformatted Item Number E A 
DICBTYPE 71 Integer I/C Bucket Type E A 
DICDOCNUM 72 String*22 I/C Document Number E A 
DICCMETHOD 73 Integer I/C Costing Method E A 
DICDATE 74 Date I/C Transaction Date E A 
DICLOCAT 75 String*6 I/C Location E A 
DBILLTYPE 76 Integer Revised Billing Type E A 
DARITEM 77 String*16 Revised A/R Item Number E A 
DARUOM 78 String*10 Revised A/R Unit of Measure E A 
DICUOM 79 String*10 Revised ^7 E A 
DQUANTITY 80 BCD*10.5 Revised Quantity E A 
DUNITCOST 81 BCD*10.6 Revised Unit Cost E A 
DBILLRATE 82 BCD*10.6 Revised Billing Rate E A 
DEXTCOSTHM 83 BCD*10.3 Revised Extended Cost E A 
DEXTCOSTSR 84 BCD*10.3 Revised Extended Cost E A 
DEXTBILLSR 85 BCD*10.3 Revised Extended Billing Amount E A 
DLABOR 86 Integer Revised Labor Type E A 
DLABORRATE 87 BCD*10.6 Revised Labor Rate E A 
DLABORPER 88 BCD*5.5 Revised Labor Percentage E A 
DLABORAMT 89 BCD*10.3 Revised Labor Amount E A 
DOHAMT 90 BCD*10.3 Revised Overhead Amount E A 
DOVERHD 91 Integer Revised Overhead Type E A 
DOHEADRATE 92 BCD*10.6 Revised Overhead Rate E A 
DHEADPER 93 BCD*5.5 Revised Overhead Percentage E A 
DTOTAMTHM 94 BCD*10.3 Revised Total Amount E A 
DBILLCCY 95 String*3 Revised Billing Currency E A 
DCONTSTYLE 96 Integer Revised ^2 Style E A 
DPROJTYPE 97 Integer Revised ^2 Type E A 
DCUSTOMER 98 String*12 Revised Customer No. E A 
DREVREC 99 Integer Revised Accounting Method E A 
DINVTYPE 100 Integer Revised Invoice Type E A 
MANITEM 101 String*24 E A 
VALUES 102 Long Optional Fields E A C 
OEARNINGS 103 String*16 E A C 
DEARNINGS 104 String*16 E A 
OPAYTYPE 105 Integer Original Pay Type E A C 
DPAYTYPE 106 Integer Revised Pay Type E A C 
GLDDESC 107 String*60 G/L Detail Description E A 
GLDREF 108 String*60 G/L Detail Reference E A 
GLCOMMENT 109 String*250 G/L Detail Comment E A 
OSTAFFCODE 110 String*24 Original Employee No. E A 
DSTAFFCODE 111 String*24 Revised Employee No. 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).