Table: Job Payments

Table: AROBPJ
View: AR0201
Record length: 268
Flags: A R 

Keys: 1

Title  Flags  Fields
Payment Audit Key   IDCUST, IDINVC, CNTPAYMNBR, IDRMIT, DATEBUS, TRANSTYPE, CNTSEQNCE, CNTUNIQ

Fields: 28

Field  Type  Title  Presentation 
IDCUST  String*12  Customer Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
CNTPAYMNBR  BCD*3.0  Payment Number   
IDRMIT  String*24  Check/Receipt No.   
DATEBUS  Date  Business Date   
TRANSTYPE  Integer  Document Type  List: 13 entries
5=Unapplied Cash
6=Debit Note Applied To
7=Applied Debit Note
8=Credit Note Applied To
9=Applied Credit Note
10=Prepayment
11=Receipt
12=Discount
14=Adjustment
16=Gain/Loss
17=Rounding
18=Retainage
19=Refund
CNTSEQNCE  BCD*3.0  Sequence No.   
CNTUNIQ  Integer  Uniquifier   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
TRXTYPE  Integer  Transaction Type  List: 28 entries
3=Unapplied Cash - Applied
4=Unapplied Cash - Reversed
41=Debit Note Applied To
42=Applied Debit Note
43=Credit Note Applied To
44=Applied Credit Note
51=Receipt - Posted
52=Receipt - Applied
53=Receipt - Reversed
58=Prepayment - Applied
59=Prepayment - Reversed
61=Discount - Posted
63=Discount - Reversed
65=Realized Gain/Loss - Posted
67=Realized Gain/Loss - Reversed
69=Unrealized Gain/Loss
73=Refund - Posted
75=Refund - Reversed
80=Write-Off - Posted
81=Adjustment - Posted
83=Adjustment - Reversed
91=Rounding - Posted
93=Rounding - Reversed
100=Retainage - Invoiced
101=Retainage - Adjusted
102=Retainage - Revalued
103=Retainage - Gain/Loss
104=Retainage - Rounding
CONTRACT  String*16  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
CATEGORY  String*16  Category  Mask: %-16N
RESOURCE  String*24  Project/Category Resource  Mask: %-16N
TRANSNBR  Long  Transaction Number   
COSTCLASS  Integer  Cost Class  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
AMTPAYMHC  BCD*10.3  Func. Receipt Amount   
AMTPAYMTC  BCD*10.3  Cust. Receipt Amount   
IDITEM  String*16  Item Number  Mask: %-16C
UNITMEAS  String*10  Unit of Measure  Mask: %-10C
QTYINVC  BCD*10.5  Quantity   
AMTCOST  BCD*10.6  Cost   
BILLDATE  Date  Billing Date   
TXTOTRTHC  BCD*10.3  Func. Retainage Tax Invoiced   
TXTOTRTTC  BCD*10.3  Vend. Retainage Tax Invoiced   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.