# View: Adjustments Audit Detail

RotoID: PM0065
Table: PMADJDA
DLL: PMADJDA

## Compositions: 0

## Keys: 3

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

## Fields: 106

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 Contract | E A |
CONTRACT | 7 | String*16 | Original Contract | E A |
PROJECT | 8 | String*16 | Original Project | E A |
CATEGORY | 9 | String*16 | Original Category | 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 I/C Unit of Measure | 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 Project Style | E A |
OPROJTYPE | 37 | Integer | Original Project 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 Contract | E A |
DCONTRACT | 65 | String*16 | To Contract | E A |
DPROJECT | 66 | String*16 | To Project | E A |
DCATEGORY | 67 | String*16 | To Category | 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 I/C Unit of Measure | 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 Project Style | E A |
DPROJTYPE | 97 | Integer | Revised Project 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 | MANITEM | E A |
VALUES | 102 | Long | Optional Fields | E A C |
OEARNINGS | 103 | String*16 | OEARNINGS | E A C |
DEARNINGS | 104 | String*16 | DEARNINGS | E A |
OPAYTYPE | 105 | Integer | OPAYTYPE | E A C |
DPAYTYPE | 106 | Integer | DPAYTYPE | E A C |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.