Table: Job Costing Transactions

Table: APJTR
View: AP0204
Record Length: 483

Flags: A R 

Keys: 1

Title Flags Fields

Posting Seq. / Batch / Entry TYPEBTCHPOSTSEQNCECNTBTCHCNTITEMCNTSEQENCE

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 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: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 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