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