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

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.