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