# Table: Adjustments Detail

Table: PMADJD
View: PM0063
Record length: 1807
Flags: A R

## Keys: 3

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

## Fields: 123

Field | Type | Title | Presentation
--- | --- | --- | ---
SEQ | Long | Sequence |
LINENO | Long | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
ADJUSTNO | String*16 | Adjustment Number | Mask: %-16C
ADJTYPE | Integer | Adjustment Type | List: 2 entries
0 | = | Transfer
1 | = | Adjustment
FMTCONTNO | String*16 | Original ^1 | Mask: %-16C
CONTRACT | String*16 | Original ^1 | Mask: %-16C
PROJECT | String*16 | Original ^2 | Mask: %-16N
CATEGORY | String*16 | Original ^3 | Mask: %-16N
RESOURCE | String*24 | Original Resource | Mask: %-16N
ITEMNO | String*24 | From Unformatted Item Number |
COSTREV | Integer | Cost or Revenue | List: 4 entries
0 | = | None
1 | = | Cost
2 | = | Revenue
3 | = | Both
COSTNUM | Long | Cost No. |
REVNUM | Long | Revenue No. |
DOCNUM | String*24 | Document No. | Mask: %-16C
OBILLTYPE | Integer | Original Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
OARITEM | String*16 | Original A/R Item Number | Mask: %-16C
OARUOM | String*10 | Original A/R Unit of Measure | Mask: %-10C
OICUOM | String*10 | Original ^7 |
OQUANTITY | BCD*10.5 | Original Quantity |
OUNITCOST | BCD*10.6 | Original Unit Cost |
OBILLRATE | BCD*10.6 | Original Billing Rate |
OEXTCOSTHM | BCD*10.3 | Original Extended Cost |
OEXTCOSTSR | BCD*10.3 | Original Extended Cost |
OEXTBILLSR | BCD*10.3 | Original Extended Billing Amount |
OLABOR | Integer | Original Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
OLABORRATE | BCD*10.6 | Original Labor Rate |
OLABORPER | BCD*5.5 | Original Labor Percentage |
OLABORAMT | BCD*10.3 | Original Labor Amount |
OOVERHD | Integer | Original Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OOHEADRATE | BCD*10.6 | Original Overhead Rate |
OHEADPER | BCD*5.5 | Original Overhead Percentage |
OOHAMT | BCD*10.3 | Original Overhead Amount |
OTOTAMTHM | BCD*10.3 | Original Total Amount |
OBILLCCY | String*3 | Original Billing Currency |
OCONTSTYLE | Integer | Original ^2 Style | List: 2 entries
1 | = | Standard
2 | = | Basic
OPROJTYPE | Integer | Original ^2 Type | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
OCUSTOMER | String*12 | Original Customer No. | Mask: %-12C
OREVREC | Integer | Original Accounting Method | 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 | Integer | Original Invoice Type | List: 2 entries
1 | = | Item
2 | = | Summary
OWIPACCT | String*45 | From WIP Account | Mask: %-45C
OTRANACCT | String*45 | From Transaction Account | Mask: %-45C
OREVACCT | String*45 | From Revenue Account | Mask: %-45C
OOHACCT | String*45 | From Overhead Account | Mask: %-45C
OLABACCT | String*45 | From Labor Account | Mask: %-45C
OCVACCT | String*45 | From Cost Variance Account | Mask: %-45C
TRANSDATE | Date | Transaction Date |
FISCALYEAR | String*4 | Fiscal Year |
FISCALPER | Integer | Fiscal Period |
VENDORID | String*12 | Vendor | Mask: %-12C
MODULE | String*2 | Module |
DOCTYPE | Integer | Document Type | List: 7 entries
0 | = |
7 | = | Material Usage
8 | = | Material Return
9 | = | Equipment Usage
10 | = | Timecard
11 | = | Charges
24 | = | Cost
TRANSTYPE | Integer | Transaction Type | 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 | String*3 | Cost Currency |
USERID | String*8 | User ID |
DETAILNUM | Long | Detail Number |
TIMETYPE | Integer | Time Type | List: 3 entries
1 | = | N/A
2 | = | Time
3 | = | Expense
DWIPACCT | String*45 | To WIP Account | Mask: %-45C
DTRANACCT | String*45 | To Transaction Account | Mask: %-45C
DREVACCT | String*45 | To Revenue Account | Mask: %-45C
DOHACCT | String*45 | To Overhead Account | Mask: %-45C
DLABACCT | String*45 | To Labor Account | Mask: %-45C
DCVACCT | String*45 | To Cost Variance Account | Mask: %-45C
DFMTCONTNO | String*16 | Revised ^1 | Mask: %-16C
DCONTRACT | String*16 | Revised ^1 | Mask: %-16C
DPROJECT | String*16 | Revised ^2 | Mask: %-16N
DCATEGORY | String*16 | Revised ^3 | Mask: %-16N
DCOSTTYPE | Integer | Cost Type | List: 6 entries
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
DRESOURCE | String*24 | Revised Resource | Mask: %-16N
DITEMNO | String*24 | To Unformatted Item Number |
DICBTYPE | Integer | I/C Bucket Type | List: 1 entries
0 | = |
DICDOCNUM | String*22 | I/C Document Number |
DICCMETHOD | Integer | I/C Costing Method | List: 7 entries
0 | = | NA
1 | = | Moving Average
2 | = | FIFO
3 | = | LIFO
4 | = | Standard Cost
5 | = | Most Recent Cost
6 | = | User-Specified
DICDATE | Date | I/C Transaction Date |
DICLOCAT | String*6 | I/C Location |
DBILLTYPE | Integer | Revised Billing Type | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
DARITEM | String*16 | Revised A/R Item Number | Mask: %-16C
DARUOM | String*10 | Revised A/R Unit of Measure | Mask: %-10C
DICUOM | String*10 | Revised ^7 |
DQUANTITY | BCD*10.5 | Revised Quantity |
DUNITCOST | BCD*10.6 | Revised Unit Cost |
DBILLRATE | BCD*10.6 | Revised Billing Rate |
DEXTCOSTHM | BCD*10.3 | Revised Extended Cost |
DEXTCOSTSR | BCD*10.3 | Revised Extended Cost |
DEXTBILLSR | BCD*10.3 | Revised Extended Billing Amount |
DLABOR | Integer | Revised Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
DLABORRATE | BCD*10.6 | Revised Labor Rate |
DLABORPER | BCD*5.5 | Revised Labor Percentage |
DLABORAMT | BCD*10.3 | Revised Labor Amount |
DOHAMT | BCD*10.3 | Revised Overhead Amount |
DOVERHD | Integer | Revised Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
DOHEADRATE | BCD*10.6 | Revised Overhead Rate |
DHEADPER | BCD*5.5 | Revised Overhead Percentage |
DTOTAMTHM | BCD*10.3 | Revised Total Amount |
DBILLCCY | String*3 | Revised Billing Currency |
DCONTSTYLE | Integer | Revised ^2 Style | List: 2 entries
1 | = | Standard
2 | = | Basic
DPROJTYPE | Integer | Revised ^2 Type | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
DCUSTOMER | String*12 | Revised Customer No. | Mask: %-12C
DREVREC | Integer | Revised Accounting Method | 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 | Integer | Revised Invoice Type | List: 2 entries
1 | = | Item
2 | = | Summary
MANITEM | String*24 |  |
VALUES | Long | Optional Fields |
OEARNINGS | String*16 | Original Earnings Code | Mask: %-16C
DEARNINGS | String*16 | Revised Earnings Code | Mask: %-16C
OPAYTYPE | Integer | Original Pay Type | List: 3 entries
3 | = | None
1 | = | US Payroll
2 | = | Canadian Payroll
DPAYTYPE | Integer | Revised Pay Type | List: 3 entries
3 | = | None
1 | = | US Payroll
2 | = | Canadian Payroll
GLDDESC | String*60 | G/L Detail Description |
GLDREF | String*60 | G/L Detail Reference |
GLCOMMENT | String*250 | G/L Detail Comment |
CLOSESN | Boolean | Close SN |
PROID | Long | SN inter-communication ID |
POPUPSN | Integer | Popup SN |
POPUPLT | Integer | Popup LT |
CLOSELT | Boolean | Close LT |
LTSETID | Long | LT inter-communication ID |
FORCEPOPSN | Boolean | Force popup SN |
FORCEPOPLT | Boolean | Force popup LT |
GENICSEQ | Boolean | Generate IC Seq. |
OSTAFFCODE | String*24 | Original Employee No. | Mask: %-24C
DSTAFFCODE | String*24 | Revised Employee No. | Mask: %-24C

This page was generated on 2008-May-01

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