Table: Invoice Details

Table: ARIBD
View: AR0033
Record Length: 1179

Flags: A R 

Keys: 1

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

Fields: 116

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 Tax Total
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 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
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
RTGDISTTC BCD*10.3 Retainage Distribution Amount
RTGCOGSTC BCD*10.3 Retainage COGS Amount
RTGALTBTC BCD*10.3 Retainage Alternate Base Amount
RTGINVDIST BCD*10.3 Invoiced Retainage Distribution
RTGINVCOGS BCD*10.3 Invoiced Retainage COGS
RTGINVALTB BCD*10.3 Invoiced Retainage Alternate Base
TXAMT1RC BCD*10.3 Tax Reporting Amount 1
TXAMT2RC BCD*10.3 Tax Reporting Amount 2
TXAMT3RC BCD*10.3 Tax Reporting Amount 3
TXAMT4RC BCD*10.3 Tax Reporting Amount 4
TXAMT5RC BCD*10.3 Tax Reporting Amount 5
TXTOTRC BCD*10.3 Tax Reporting Total
TXBSERT1TC BCD*10.3 Retainage Tax Base 1
TXBSERT2TC BCD*10.3 Retainage Tax Base 2
TXBSERT3TC BCD*10.3 Retainage Tax Base 3
TXBSERT4TC BCD*10.3 Retainage Tax Base 4
TXBSERT5TC BCD*10.3 Retainage Tax Base 5
TXAMTRT1TC BCD*10.3 Retainage Tax Amount 1
TXAMTRT2TC BCD*10.3 Retainage Tax Amount 2
TXAMTRT3TC BCD*10.3 Retainage Tax Amount 3
TXAMTRT4TC BCD*10.3 Retainage Tax Amount 4
TXAMTRT5TC BCD*10.3 Retainage Tax Amount 5
TXBSE1HC BCD*10.3 Func. Tax Base 1
TXBSE2HC BCD*10.3 Func. Tax Base 2
TXBSE3HC BCD*10.3 Func. Tax Base 3
TXBSE4HC BCD*10.3 Func. Tax Base 4
TXBSE5HC BCD*10.3 Func. Tax Base 5
TXAMT1HC BCD*10.3 Func. Tax Amount 1
TXAMT2HC BCD*10.3 Func. Tax Amount 2
TXAMT3HC BCD*10.3 Func. Tax Amount 3
TXAMT4HC BCD*10.3 Func. Tax Amount 4
TXAMT5HC BCD*10.3 Func. Tax Amount 5
TXAMTRT1HC BCD*10.3 Func. Retainage Tax Amount 1
TXAMTRT2HC BCD*10.3 Func. Retainage Tax Amount 2
TXAMTRT3HC BCD*10.3 Func. Retainage Tax Amount 3
TXAMTRT4HC BCD*10.3 Func. Retainage Tax Amount 4
TXAMTRT5HC BCD*10.3 Func. Retainage Tax Amount 5
DISTNETHC BCD*10.3 Func. Distribution Net of Taxes
RTGAMTHC BCD*10.3 Func. Retainage Amount
AMTCOGSHC BCD*10.3 Func. COGS Amount
AMTCOSTHC BCD*10.6 Func. Cost
AMTPRICHC BCD*10.6 Func. Price
AMTEXTNHC BCD*10.3 Func. Extended Amount w/ TIP
EDN String*30 Export Declaration Number
AMTWHT1TC BCD*10.3 Estimated Tax Withheld Amount 1
AMTWHT2TC BCD*10.3 Estimated Tax Withheld Amount 2
AMTWHT3TC BCD*10.3 Estimated Tax Withheld Amount 3
AMTWHT4TC BCD*10.3 Estimated Tax Withheld Amount 4
AMTWHT5TC BCD*10.3 Estimated Tax Withheld Amount 5

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).