View: Job Costing Transactions

RotoID: AP0204
Table: APJTR
Protocol: Flat
DLL:APJTR

Keys: 1

Title Fields

Posting Seq. / Batch / Entry TYPEBTCHPOSTSEQNCECNTBTCHCNTITEMCNTSEQENCE

Fields: 47

Field Index Type Title Attributes Presentation

TYPEBTCH 1 String*2 Batch Type E A K R 
POSTSEQNCE 2 BCD*5.0 Posting Sequence No. E A K R 
CNTBTCH 3 BCD*5.0 Batch Number E A K R 
CNTITEM 4 BCD*4.0 Entry Number E A K R 
CNTSEQENCE 5 Long Sequence No. E A K R 
DATEBUS 6 Date Posting Date E A 
DOCTYPE 7 Integer Document Type E A  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 8 Integer Transaction Type E A  List:14 entries
1 = Posted
2 = Discount
3 = Write-Off
4 = Apply From
5 = Apply To
6 = Payment Reversal
7 = Rounding
8 = Exchange Gain/Loss
9 = Unrealized Exchange Gain/Loss
10 = Adjustment
11 = Payment
20 = Retainage Rounding
21 = Retainage Exchange Gain/Loss
22 = Retainage Unrealized Exchange Gain/Loss
CONTRACT 9 String*16 Contract Code E A  Mask: %-16C
PROJECT 10 String*16 Project Code E A  Mask: %-16N
CATEGORY 11 String*16 Category Code E A  Mask: %-16N
RESOURCE 12 String*24 Project/Category Resource E A P  Mask: %-16N
TRANSNBR 13 Long Transaction Number E A 
COSTCLASS 14 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
IDDIST 15 String*6 Distribution Code E A  Mask: %-6N
IDGLACCT 16 String*45 G/L Account E A  Mask: %-45C
BILLTYPE 17 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
IDITEM 18 String*16 Item Number E A  Mask: %-16C
UNITMEAS 19 String*10 Unit of Measure E A  Mask: %-10C
QTYINVC 20 BCD*10.5 Quantity E A 
AMTCOSTHC 21 BCD*10.6 Functional Cost E A 
AMTCOSTTC 22 BCD*10.6 Vendor Cost E A 
AMTHC 23 BCD*10.3 Functional Amount E A 
AMTTC 24 BCD*10.3 Vendor Amount E A 
BILLDATE 25 Date Billing Date E A 
BILLRATE 26 BCD*10.6 Billing Rate E A 
BILLCURN 27 String*3 Billing Currency E A  Mask: %-3N
CODETAX1 28 String*12 Tax Auth. 1 E A 
CODETAX2 29 String*12 Tax Auth. 2 E A 
CODETAX3 30 String*12 Tax Auth. 3 E A 
CODETAX4 31 String*12 Tax Auth. 4 E A 
CODETAX5 32 String*12 Tax Auth. 5 E A 
AMTTAX1HC 33 BCD*10.3 Func. Tax Amount 1 E A 
AMTTAX2HC 34 BCD*10.3 Func. Tax Amount 2 E A 
AMTTAX3HC 35 BCD*10.3 Func. Tax Amount 3 E A 
AMTTAX4HC 36 BCD*10.3 Func. Tax Amount 4 E A 
AMTTAX5HC 37 BCD*10.3 Func. Tax Amount 5 E A 
AMTTAX1TC 38 BCD*10.3 Vend. Tax Amount 1 E A 
AMTTAX2TC 39 BCD*10.3 Vend. Tax Amount 2 E A 
AMTTAX3TC 40 BCD*10.3 Vend. Tax Amount 3 E A 
AMTTAX4TC 41 BCD*10.3 Vend. Tax Amount 4 E A 
AMTTAX5TC 42 BCD*10.3 Vend. Tax Amount 5 E A 
AMTRECTXHC 43 BCD*10.3 Functional Recoverable Taxes E A 
AMTRECTXTC 44 BCD*10.3 Vendor Recoverable Taxes E A 
RTGAMTHC 45 BCD*10.3 Func. Curr. Retainage Amount E A 
RTGAMTTC 46 BCD*10.3 Vend. Curr. Retainage Amount E A 
RTGDATEDUE 47 Date Retainage Due Date E A