# View: Job Payments

RotoID: AP0201
Table: APOBPJ
DLL: APOBPJ

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Open Item Payment Schedule key | IDVEND, IDINVC, CNTPAYMNBR, IDRMIT, DATEBUS, TRANSTYPE, CNTSEQNCE, CNTUNIQ

## Fields: 27

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
IDVEND | 1 | String*12 | Vendor Number | E A K R | Mask: %-12C
IDINVC | 2 | String*22 | Document Number | E A K R | Mask: %-22C
CNTPAYMNBR | 3 | BCD*3.0 | Payment Number | E A K R |
IDRMIT | 4 | String*12 | Check Number | E A K R | Mask: %-12D
DATEBUS | 5 | Date | Business Date | E A K R |
TRANSTYPE | 6 | Integer | Document Type | E A K R | List: 10 entries
6 | = | Debit Note Applied To
7 | = | Applied Debit Note
8 | = | Credit Note Applied To
9 | = | Applied Credit Note
10 | = | Prepayment
11 | = | Payment
12 | = | Discount
14 | = | Adjustment
16 | = | Gain/Loss
18 | = | Retainage
CNTSEQNCE | 7 | BCD*3.0 | Sequence No. | E A K R |
CNTUNIQ | 8 | Integer | Uniquifier | E A K R |
TRXTYPE | 9 | Integer | Transaction Type | E A | List: 21 entries
41 | = | Debit Note Applied To
42 | = | Applied Debit Note
43 | = | Credit Note Applied To
44 | = | Applied Credit Note
58 | = | Prepayment - Applied
59 | = | Prepayment - Reversed
51 | = | Payment - Posted
52 | = | Payment - Applied
53 | = | Payment - Reversed
61 | = | Discount - Posted
63 | = | Discount - Reversed
81 | = | Adjustment - Posted
83 | = | Adjustment - Reversed
65 | = | Realized Gain/Loss - Posted
67 | = | Realized Gain/Loss - Reversed
69 | = | Unrealized Gain/Loss
100 | = | Retainage - Invoiced
101 | = | Retainage - Adjusted
102 | = | Retainage - Revalued
103 | = | Retainage - Gain/Loss
104 | = | Retainage - Rounding
CONTRACT | 10 | String*16 | Contract | E A | Mask: %-16C
PROJECT | 11 | String*16 | Project | E A | Mask: %-16N
CATEGORY | 12 | String*16 | Category | E A | Mask: %-16N
RESOURCE | 13 | String*24 | Project/Category Resource | E A P | Mask: %-16N
TRANSNBR | 14 | Long | Transaction Number | E A |
COSTCLASS | 15 | Integer | Cost Class | E A | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
BILLTYPE | 16 | Integer | Billing Type | E A | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
AMTPAYMHC | 17 | BCD*10.3 | Func. Payment Amount | E A |
AMTPAYMTC | 18 | BCD*10.3 | Vend. Payment Amount | E A |
IDITEM | 19 | String*16 | Item Number | E A | Mask: %-16C
UNITMEAS | 20 | String*10 | Unit of Measure | E A | Mask: %-10C
QTYINVC | 21 | BCD*10.5 | Quantity | E A |
AMTCOST | 22 | BCD*10.6 | Cost | E A |
BILLDATE | 23 | Date | Billing Date | E A |
BILLRATE | 24 | BCD*10.6 | Billing Rate | E A |
BILLCURN | 25 | String*3 | Billing Currency | E A | Mask: %-3N
TXTOTRTHC | 26 | BCD*10.3 | Func. Retainage Tax Invoiced | E A |
TXTOTRTTC | 27 | BCD*10.3 | Vend. Retainage Tax Invoiced | E A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.