Table: Invoice Details

Table: ARIBD
View: AR0033
Record length: 669
Flags: A R 

Keys: 1

Title  Flags  Fields
Invoice Detail Seq. Number   CNTBTCH, CNTITEM, CNTLINE

Fields: 67

Field  Type  Title  Presentation 
CNTBTCH  BCD*5.0  Batch Number   
CNTITEM  BCD*4.0  Entry Number   
CNTLINE  BCD*3.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDINVC  String*22  Reserved   
IDITEM  String*16  Item Number  Mask: %-16C
IDDIST  String*6  Distribution Code  Mask: %-6N
TEXTDESC  String*60  Description   
SWMANLITEM  Integer  Reserved   
UNITMEAS  String*10  Unit of Measure  Mask: %-10C
QTYINVC  BCD*10.5  Quantity   
AMTCOST  BCD*10.6  Cost   
AMTPRIC  BCD*10.6  Price   
AMTEXTN  BCD*10.3  Extended Amount w/ TIP   
AMTCOGS  BCD*10.3  COGS Amount   
AMTTXBL  BCD*10.3  Extended Amount w/o TIP   
TOTTAX  BCD*10.3  Total Tax Amount   
SWMANLTX  Integer  Reserved   
BASETAX1  BCD*10.3  Tax Base 1   
BASETAX2  BCD*10.3  Tax Base 2   
BASETAX3  BCD*10.3  Tax Base 3   
BASETAX4  BCD*10.3  Tax Base 4   
BASETAX5  BCD*10.3  Tax Base 5   
TAXSTTS1  Integer  Tax Class 1   
TAXSTTS2  Integer  Tax Class 2   
TAXSTTS3  Integer  Tax Class 3   
TAXSTTS4  Integer  Tax Class 4   
TAXSTTS5  Integer  Tax Class 5   
SWTAXINCL1  Integer  Tax Included 1  List: 2 entries
0=No
1=Yes
SWTAXINCL2  Integer  Tax Included 2  List: 2 entries
0=No
1=Yes
SWTAXINCL3  Integer  Tax Included 3  List: 2 entries
0=No
1=Yes
SWTAXINCL4  Integer  Tax Included 4  List: 2 entries
0=No
1=Yes
SWTAXINCL5  Integer  Tax Included 5  List: 2 entries
0=No
1=Yes
RATETAX1  BCD*8.5  Tax Rate 1   
RATETAX2  BCD*8.5  Tax Rate 2   
RATETAX3  BCD*8.5  Tax Rate 3   
RATETAX4  BCD*8.5  Tax Rate 4   
RATETAX5  BCD*8.5  Tax Rate 5   
AMTTAX1  BCD*10.3  Tax Amount 1   
AMTTAX2  BCD*10.3  Tax Amount 2   
AMTTAX3  BCD*10.3  Tax Amount 3   
AMTTAX4  BCD*10.3  Tax Amount 4   
AMTTAX5  BCD*10.3  Tax Amount 5   
IDACCTREV  String*45  Revenue Account  Mask: %-45C
IDACCTINV  String*45  Inventory Account  Mask: %-45C
IDACCTCOGS  String*45  COGS Account  Mask: %-45C
IDJOBPROJ  String*30  Reserved   
CONTRACT  String*16  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
CATEGORY  String*16  Category  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
BILLDATE  Date  Billing Date   
SWIBT  Integer  Comment Attached  List: 2 entries
0=No
1=Yes
SWDISCABL  Integer  Discountable  List: 2 entries
0=No
1=Yes
OCNTLINE  BCD*3.0  Original Line Identifier   
RTGAMT  BCD*10.3  Retainage Amount   
RTGPERCENT  BCD*5.5  Percent Retained   
RTGDAYS  Integer  Days Retained   
RTGDATEDUE  Date  Retainage Due Date   
SWRTGDDTOV  Integer  Retainage Due Date Override  List: 2 entries
0=No
1=Yes
SWRTGAMTOV  Integer  Retainage Amount Override  List: 2 entries
0=No
1=Yes
VALUES  Long  Values   

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.