Table: Job Costing Transactions

Table: ARJTR
View: AR0204
Record Length: 448

Flags: A R 

Keys: 1

Title Flags Fields

Posting Seq. / Batch / Entry TYPEBTCHPOSTSEQNCECNTBTCHCNTITEMCNTSEQENCE

Fields: 46

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 Posting 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:16 entries
1 = Posted
2 = Discount
3 = Write-Off
4 = Apply From
5 = Apply To
6 = Receipt Reversal
7 = Rounding
8 = Exchange Gain/Loss
9 = Unrealized Exchange Gain/Loss
10 = Adjustment
11 = Receipt
20 = Retainage Rounding
21 = Retainage Exchange Gain/Loss
22 = Retainage Unrealized Exchange Gain/Loss
29 = Refund
30 = Refund Reversal
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
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 Customer Cost
AMTHC BCD*10.3 Functional Amount
AMTTC BCD*10.3 Customer Amount
BILLDATE Date Billing Date
CODETAX1 String*12 Tax Auth. 1 Mask: %-12N
CODETAX2 String*12 Tax Auth. 2 Mask: %-12N
CODETAX3 String*12 Tax Auth. 3 Mask: %-12N
CODETAX4 String*12 Tax Auth. 4 Mask: %-12N
CODETAX5 String*12 Tax Auth. 5 Mask: %-12N
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 Cust. Tax Amount 1
AMTTAX2TC BCD*10.3 Cust. Tax Amount 2
AMTTAX3TC BCD*10.3 Cust. Tax Amount 3
AMTTAX4TC BCD*10.3 Cust. Tax Amount 4
AMTTAX5TC BCD*10.3 Cust. Tax Amount 5
RTGAMTHC BCD*10.3 Func. Curr. Retainage Amount
RTGAMTTC BCD*10.3 Cust. Curr. Retainage Amount
RTGDATEDUE Date Retainage Due Date