Table: Job Details

Table: AROBLJ
View: AR0200
Record length: 328
Flags: A R 

Keys: 1


Title  Flags  Fields

Cust. No./Doc. No./Line No.   IDCUST, IDINVC, CNTLINE

Fields: 30


Field  Type  Title  Presentation 

IDCUST  String*12  Customer Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
CNTLINE  BCD*3.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
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
AMTINVCTC  BCD*10.3  Cust. Currency Invoice Amount   
AMTDUETC  BCD*10.3  Cust. Currency Amount Due   
AMTINVCHC  BCD*10.3  Func. Currency Invoice Amount   
AMTDUEHC  BCD*10.3  Func. Currency Amount Due   
IDITEM  String*16  Item Number  Mask: %-16C
UNITMEAS  String*10  Unit of Measure  Mask: %-10C
QTYINVC  BCD*10.5  Quantity   
AMTCOST  BCD*10.6  Cost   
BILLDATE  Date  Billing Date   
SWDISCABL  Integer  Discountable  List: 2 entries
0=No
1=Yes
RTGDATEDUE  Date  Date Retainage Due   
RTGOAMTHC  BCD*10.3  Func. Curr. Orig. Rtng. Amt.   
RTGAMTHC  BCD*10.3  Func. Curr. Retainage Amount   
RTGOAMTTC  BCD*10.3  Cust. Curr. Orig. Rtng. Amt.   
RTGAMTTC  BCD*10.3  Cust. Curr. Retainage Amount   

This page was generated on 2003-Oct-22

Copyright © 2003 ACCPAC International, Inc. All rights reserved.