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 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).