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 Contract  Mask: %-16C
CONTRACT  String*16  Original Contract  Mask: %-16C
PROJECT  String*16  Original Project  Mask: %-16N
CATEGORY  String*16  Original Category  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 IC Unit of Measure   
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 Project Style  List: 2 entries
1=Standard
2=Basic
OPROJTYPE  Integer  Original Project 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 Contract  Mask: %-16C
DCONTRACT  String*16  Revised Contract  Mask: %-16C
DPROJECT  String*16  Revised Project  Mask: %-16N
DCATEGORY  String*16  Revised Category  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 IC Unit of Measure   
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 Project Style  List: 2 entries
1=Standard
2=Basic
DPROJTYPE  Integer  Revised Project 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 2009-Nov-19

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