# Table: Job Costing Transactions

Table: APJTR
View: AP0204
Record length: 483
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Posting Seq. / Batch / Entry |  | TYPEBTCH, POSTSEQNCE, CNTBTCH, CNTITEM, CNTSEQENCE

## Fields: 51

Field | Type | Title | Presentation
--- | --- | --- | ---
TYPEBTCH | String*2 | Batch Type |
POSTSEQNCE | BCD*5.0 | Posting Sequence No. |
CNTBTCH | BCD*5.0 | Batch Number |
CNTITEM | BCD*4.0 | Entry Number |
CNTSEQENCE | Long | Sequence No. |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DATEBUS | Date | Business Date |
DOCTYPE | Integer | Document Type | List: 9 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
5 | = | Prepayment
6 | = | Unapplied Cash
13 | = | Retainage Invoice
14 | = | Retainage Debit Note
15 | = | Retainage Credit Note
TRANSTYPE | Integer | Transaction Type | List: 14 entries
1 | = | Posted
2 | = | Discount
3 | = | Write-Off
4 | = | Apply From
5 | = | Apply To
6 | = | Payment Reversal
7 | = | Rounding
8 | = | Realized Exchange Gain/Loss
9 | = | Unrealized Exchange Gain/Loss
10 | = | Adjustment
11 | = | Payment
20 | = | Retainage Rounding
21 | = | Retainage Realized Exchange Gain/Loss
22 | = | Retainage Unrealized Exchange Gain/Loss
CONTRACT | String*16 | Contract Code | Mask: %-16C
PROJECT | String*16 | Project Code | Mask: %-16N
CATEGORY | String*16 | Category Code | 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
IDDIST | String*6 | Distribution Code | Mask: %-6N
IDGLACCT | String*45 | G/L Account | Mask: %-45C
BILLTYPE | Integer | Billing Type | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
IDITEM | String*16 | Item Number | Mask: %-16C
UNITMEAS | String*10 | Unit of Measure | Mask: %-10C
QTYINVC | BCD*10.5 | Quantity |
AMTCOSTHC | BCD*10.6 | Functional Cost |
AMTCOSTTC | BCD*10.6 | Vendor Cost |
AMTHC | BCD*10.3 | Functional Amount |
AMTTC | BCD*10.3 | Vendor Amount |
BILLDATE | Date | Billing Date |
BILLRATE | BCD*10.6 | Billing Rate |
BILLCURN | String*3 | Billing Currency | Mask: %-3N
CODETAX1 | String*12 | Tax Auth. 1 |
CODETAX2 | String*12 | Tax Auth. 2 |
CODETAX3 | String*12 | Tax Auth. 3 |
CODETAX4 | String*12 | Tax Auth. 4 |
CODETAX5 | String*12 | Tax Auth. 5 |
AMTTAX1HC | BCD*10.3 | Func. Tax Amount 1 |
AMTTAX2HC | BCD*10.3 | Func. Tax Amount 2 |
AMTTAX3HC | BCD*10.3 | Func. Tax Amount 3 |
AMTTAX4HC | BCD*10.3 | Func. Tax Amount 4 |
AMTTAX5HC | BCD*10.3 | Func. Tax Amount 5 |
AMTTAX1TC | BCD*10.3 | Vend. Tax Amount 1 |
AMTTAX2TC | BCD*10.3 | Vend. Tax Amount 2 |
AMTTAX3TC | BCD*10.3 | Vend. Tax Amount 3 |
AMTTAX4TC | BCD*10.3 | Vend. Tax Amount 4 |
AMTTAX5TC | BCD*10.3 | Vend. Tax Amount 5 |
AMTRECTXHC | BCD*10.3 | Functional Recoverable Taxes |
AMTRECTXTC | BCD*10.3 | Vendor Recoverable Taxes |
RTGAMTHC | BCD*10.3 | Func. Curr. Retainage Amount |
RTGAMTTC | BCD*10.3 | Vend. Curr. Retainage Amount |
RTGDATEDUE | Date | Retainage Due Date |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.