# View: Adjustments Detail

RotoID: PM0063
Table: PMADJD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: PMADJD

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PM0062 | PMADJH | Adjustments | PMADJH
PM0527 | PMADJDO | Adjustment Detail Optional Field | PMADJDO

## Keys: 3

Title | Fields
--- | ---
Sequence/Line Number | SEQ, LINENO
Adjustment Number/Line Number | ADJUSTNO, LINENO
Sequence/Detail Number | SEQ, DETAILNUM

## Fields: 121

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SEQ | 1 | Long | Sequence | E A K R |
LINENO | 2 | Long | Line Number | E A K R |
ADJUSTNO | 3 | String*16 | Adjustment Number | A C | Mask: %-16C
ADJTYPE | 4 | Integer | Adjustment Type | E A X | List: 2 entries
0 | = | Transfer
1 | = | Adjustment
FMTCONTNO | 5 | String*16 | Original ^1 | E A X | Mask: %-16C
CONTRACT | 6 | String*16 | Original ^1 | E A X | Mask: %-16C
PROJECT | 7 | String*16 | Original ^2 | E A X | Mask: %-16N
CATEGORY | 8 | String*16 | Original ^3 | E A X | Mask: %-16N
RESOURCE | 9 | String*24 | Original Resource | E A P X | Mask: %-16N
ITEMNO | 10 | String*24 | From Unformatted Item Number | E A X |
COSTREV | 11 | Integer | Cost or Revenue | A C | List: 4 entries
0 | = | None
1 | = | Cost
2 | = | Revenue
3 | = | Both
COSTNUM | 12 | Long | Cost No. | E A X |
REVNUM | 13 | Long | Revenue No. | E A X |
DOCNUM | 14 | String*24 | Document No. | E A X | Mask: %-16C
OBILLTYPE | 15 | Integer | Original Billing Type | A C | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
OARITEM | 16 | String*16 | Original A/R Item Number | A C | Mask: %-16C
OARUOM | 17 | String*10 | Original A/R Unit of Measure | A C | Mask: %-10C
OICUOM | 18 | String*10 | Original ^7 | A C |
OQUANTITY | 19 | BCD*10.5 | Original Quantity | A C |
OUNITCOST | 20 | BCD*10.6 | Original Unit Cost | A C |
OBILLRATE | 21 | BCD*10.6 | Original Billing Rate | A C |
OEXTCOSTHM | 22 | BCD*10.3 | Original Extended Cost | A C |
OEXTCOSTSR | 23 | BCD*10.3 | Original Extended Cost | A C |
OEXTBILLSR | 24 | BCD*10.3 | Original Extended Billing Amount | A C |
OLABOR | 25 | Integer | Original Labor Type | A C | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
OLABORRATE | 26 | BCD*10.6 | Original Labor Rate | A C |
OLABORPER | 27 | BCD*5.5 | Original Labor Percentage | A C |
OLABORAMT | 28 | BCD*10.3 | Original Labor Amount | A C |
OOVERHD | 29 | Integer | Original Overhead Type | A C | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OOHEADRATE | 30 | BCD*10.6 | Original Overhead Rate | A C |
OHEADPER | 31 | BCD*5.5 | Original Overhead Percentage | A C |
OOHAMT | 32 | BCD*10.3 | Original Overhead Amount | A C |
OTOTAMTHM | 33 | BCD*10.3 | Original Total Amount | A C |
OBILLCCY | 34 | String*3 | Original Billing Currency | A C |
OCONTSTYLE | 35 | Integer | Original ^2 Style | A C | List: 2 entries
1 | = | Standard
2 | = | Basic
OPROJTYPE | 36 | Integer | Original ^2 Type | A C | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
OCUSTOMER | 37 | String*12 | Original Customer No. | A C | Mask: %-12C
OREVREC | 38 | Integer | Original Accounting Method | A C | List: 7 entries
1 | = | Completed Project
2 | = | Total Cost Percentage Complete
3 | = | Labor Hours Percentage Complete
4 | = | Billings and Costs
5 | = | Project Percentage Complete
6 | = | Category Percentage Complete
8 | = | Accrual-Basis
OINVTYPE | 39 | Integer | Original Invoice Type | A C | List: 2 entries
1 | = | Item
2 | = | Summary
OWIPACCT | 40 | String*45 | From WIP Account | A C | Mask: %-45C
OTRANACCT | 41 | String*45 | From Transaction Account | A C | Mask: %-45C
OREVACCT | 42 | String*45 | From Revenue Account | A C | Mask: %-45C
OOHACCT | 43 | String*45 | From Overhead Account | A C | Mask: %-45C
OLABACCT | 44 | String*45 | From Labor Account | A C | Mask: %-45C
OCVACCT | 45 | String*45 | From Cost Variance Account | A C | Mask: %-45C
TRANSDATE | 46 | Date | Transaction Date | A C |
FISCALYEAR | 47 | String*4 | Fiscal Year | A C |
FISCALPER | 48 | Integer | Fiscal Period | A C |
VENDORID | 49 | String*12 | Vendor | A C | Mask: %-12C
MODULE | 50 | String*2 | Module | A C |
DOCTYPE | 51 | Integer | Document Type | A C | List: 7 entries
0 | = |
7 | = | Material Usage
8 | = | Material Return
9 | = | Equipment Usage
10 | = | Timecard
11 | = | Charges
24 | = | Cost
TRANSTYPE | 52 | Integer | Transaction Type | A C | List: 11 entries
1 | = | Posted
2 | = | Discount
3 | = | Write-off
4 | = | Apply From
5 | = | Apply To
6 | = | Payment/Receipt Reversal
7 | = | Rounding (multicurrency)
8 | = | Exchange Gain/Loss
9 | = | Unrealized Exchange Gain/Loss
10 | = | Adjustment
11 | = | Receipt/Payment
COSTCCY | 53 | String*3 | Cost Currency | A C |
USERID | 54 | String*8 | User ID | A C |
DETAILNUM | 55 | Long | Detail Number | E A X |
TIMETYPE | 56 | Integer | Time Type | E A X | List: 3 entries
1 | = | N/A
2 | = | Time
3 | = | Expense
DWIPACCT | 57 | String*45 | To WIP Account | A C | Mask: %-45C
DTRANACCT | 58 | String*45 | To Transaction Account | A C | Mask: %-45C
DREVACCT | 59 | String*45 | To Revenue Account | A C | Mask: %-45C
DOHACCT | 60 | String*45 | To Overhead Account | A C | Mask: %-45C
DLABACCT | 61 | String*45 | To Labor Account | A C | Mask: %-45C
DCVACCT | 62 | String*45 | To Cost Variance Account | A C | Mask: %-45C
DFMTCONTNO | 63 | String*16 | Revised ^1 | A X | Mask: %-16C
DCONTRACT | 64 | String*16 | Revised ^1 | E A X | Mask: %-16C
DPROJECT | 65 | String*16 | Revised ^2 | A X | Mask: %-16N
DCATEGORY | 66 | String*16 | Revised ^3 | A X | Mask: %-16N
DCOSTTYPE | 67 | Integer | Cost Type | E A X | List: 6 entries
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
DRESOURCE | 68 | String*24 | Revised Resource | A P X | Mask: %-16N
DITEMNO | 69 | String*24 | To Unformatted Item Number | E A X |
DICBTYPE | 70 | Integer | I/C Bucket Type | A P X | List: 1 entries
0 | = |
DICDOCNUM | 71 | String*22 | I/C Document Number | A X |
DICCMETHOD | 72 | Integer | I/C Costing Method | A C | List: 7 entries
0 | = | NA
1 | = | Moving Average
2 | = | FIFO
3 | = | LIFO
4 | = | Standard Cost
5 | = | Most Recent Cost
6 | = | User-Specified
DICDATE | 73 | Date | I/C Transaction Date | A X |
DICLOCAT | 74 | String*6 | I/C Location | A X |
DBILLTYPE | 75 | Integer | Revised Billing Type | A X | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
DARITEM | 76 | String*16 | Revised A/R Item Number | A X | Mask: %-16C
DARUOM | 77 | String*10 | Revised A/R Unit of Measure | A X | Mask: %-10C
DICUOM | 78 | String*10 | Revised ^7 | A X |
DQUANTITY | 79 | BCD*10.5 | Revised Quantity | A X |
DUNITCOST | 80 | BCD*10.6 | Revised Unit Cost | A X |
DBILLRATE | 81 | BCD*10.6 | Revised Billing Rate | A X |
DEXTCOSTHM | 82 | BCD*10.3 | Revised Extended Cost | A X |
DEXTCOSTSR | 83 | BCD*10.3 | Revised Extended Cost | A C |
DEXTBILLSR | 84 | BCD*10.3 | Revised Extended Billing Amount | A X |
DLABOR | 85 | Integer | Revised Labor Type | A C | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
DLABORRATE | 86 | BCD*10.6 | Revised Labor Rate | A C |
DLABORPER | 87 | BCD*5.5 | Revised Labor Percentage | A C |
DLABORAMT | 88 | BCD*10.3 | Revised Labor Amount | A C |
DOHAMT | 89 | BCD*10.3 | Revised Overhead Amount | A C |
DOVERHD | 90 | Integer | Revised Overhead Type | A C | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
DOHEADRATE | 91 | BCD*10.6 | Revised Overhead Rate | A C |
DHEADPER | 92 | BCD*5.5 | Revised Overhead Percentage | A C |
DTOTAMTHM | 93 | BCD*10.3 | Revised Total Amount | A C |
DBILLCCY | 94 | String*3 | Revised Billing Currency | A C |
DCONTSTYLE | 95 | Integer | Revised ^2 Style | A C | List: 2 entries
1 | = | Standard
2 | = | Basic
DPROJTYPE | 96 | Integer | Revised ^2 Type | A C | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
DCUSTOMER | 97 | String*12 | Revised Customer No. | A C | Mask: %-12C
DREVREC | 98 | Integer | Revised Accounting Method | A C | List: 7 entries
1 | = | Completed Project
2 | = | Total Cost Percentage Complete
3 | = | Labor Hours Percentage Complete
4 | = | Billings and Costs
5 | = | Project Percentage Complete
6 | = | Category Percentage Complete
8 | = | Accrual-Basis
DINVTYPE | 99 | Integer | Revised Invoice Type | A C | List: 2 entries
1 | = | Item
2 | = | Summary
MANITEM | 100 | String*24 |  | E A X |
VALUES | 101 | Long | Optional Fields | A C |
OEARNINGS | 102 | String*16 | Original Earnings Code | A C | Mask: %-16C
DEARNINGS | 103 | String*16 | Revised Earnings Code | A X | Mask: %-16C
OPAYTYPE | 104 | Integer | Original Pay Type | A C | List: 3 entries
3 | = | None
1 | = | US Payroll
2 | = | Canadian Payroll
DPAYTYPE | 105 | Integer | Revised Pay Type | A C | List: 3 entries
3 | = | None
1 | = | US Payroll
2 | = | Canadian Payroll
GLDDESC | 106 | String*60 | G/L Detail Description | E A X |
GLDREF | 107 | String*60 | G/L Detail Reference | E A X |
GLCOMMENT | 108 | String*250 | G/L Detail Comment | E A X |
CLOSESN | 109 | Boolean | Close SN | E A X |
PROID | 110 | Long | SN inter-communication ID | E A X |
POPUPSN | 111 | Integer | Popup SN | E A X |
POPUPLT | 112 | Integer | Popup LT | E A X |
CLOSELT | 113 | Boolean | Close LT | E A X |
LTSETID | 114 | Long | LT inter-communication ID | E A X |
FORCEPOPSN | 115 | Boolean | Force popup SN | E A X |
FORCEPOPLT | 116 | Boolean | Force popup LT | E A X |
GENICSEQ | 117 | Boolean | Generate IC Seq. | E A X |
OSTAFFCODE | 118 | String*24 | Original Employee No. | A | Mask: %-24C
DSTAFFCODE | 119 | String*24 | Revised Employee No. | A X | Mask: %-24C
HASOPT | 1001 | Boolean | Optional Fields | E A C | List: 2 entries
0 | = | No
1 | = | Yes
FUNCTION | 1002 | Integer | Function | E A C | List: 2 entries
0 | = | None
10 | = | Load Optional Fields

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.