Table: Adjustments Detail

Table: PMADJD
View: PM0063
Record length: 512
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: 56


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
CONTRACT  String*16  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
CATEGORY  String*16  Category  Mask: %-16N
RESOURCE  String*24  Resource  Mask: %-16N
COSTNUM  Long  Cost No.   
REVNUM  Long  Revenue No.   
ADJTYPE  Integer  Adjustment Type  List: 2 entries
0=Transfer
1=Adjustment
CONTRACTD  String*16  Adjusted to Contract  Mask: %-16C
PROJECTD  String*16  Adjusted to Project  Mask: %-16N
CATEGORYD  String*16  Adjusted to Category  Mask: %-16N
RESOURCED  String*24  Adjusted to Resource  Mask: %-16N
TRANSDATE  Date  Transaction Date   
FMTCONTNO  String*16  Contract  Mask: %-16C
FMTCONTNOD  String*16  Adjusted to Contract  Mask: %-16C
IDCUST  String*12  Customer No.  Mask: %-12C
VENDORID  String*12  Vendor No.  Mask: %-12C
COSTTYPE  Integer  Cost Class  List: 6 entries
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
DOCNUM  String*24  Document No.  Mask: %-16C
MODULE  String*2  Source Module   
DOCTYPE  Integer  Document Type  List: 11 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
5=Prepayment
6=Unapplied Cash
7=Material Usage
8=Material Return
9=Equipment Usage
10=Timecard
11=Charges
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=Realized Exchange Gain/Loss
9=Unrealized Exchange Gain/Loss
10=Adjustment
11=Receipt/Payment
BILLTYPE  Integer  Billing Type  List: 3 entries
2=Billable
3=No Charge
1=Non-billable
ARITEM  String*16  A/R Item Number  Mask: %-16C
ARUOM  String*10  A/R Unit of Measure  Mask: %-10C
ICUOM  String*10  I/C Unit of Measure   
QUANTITY  BCD*10.5  Quantity   
UNITCOST  BCD*10.6  Unit Cost   
BILLRATE  BCD*10.6  Billing Rate   
EXTCOSTHM  BCD*10.3  Extended Cost   
EXTCOSTSR  BCD*10.3  Extended Cost   
EXTBILLSR  BCD*10.3  Extended Billing Amount   
LABOR  Integer  Labor Type   
LABORRATE  BCD*10.6  Labor Rate   
LABORPER  BCD*5.5  Labor Percentage   
LABORAMT  BCD*10.3  Labor Amount   
OHAMT  BCD*10.3  Overhead Amount   
OVERHD  Integer  Overhead Type   
OHEADRATE  BCD*10.6  Overhead Rate   
HEADPER  BCD*5.5  Overhead Percentage   
TOTAMTHM  BCD*10.3  Total Amount   
COSTCCY  String*3  Cost Currency   
BILLCCY  String*3  Billing Currency   
ICBTYPE  Integer  I/C Bucket Type  List: 3 entries
1=Offset Bucket
2=Specific Bucket
3=Prorate
ICDOCNUM  String*22  I/C Document Number   
ICCMETHOD  Integer  I/C Cost Method   
ICDATE  Date  I/C Transaction Date   
ICLOCAT  String*6  I/C Location   
USERID  String*8  User ID   
DETAILNUM  Long  Detail Number   

This page was generated on 2003-May-05

Copyright © 2003 ACCPAC International, Inc. All rights reserved.