View: Invoice Details

RotoID: AR0033
Table: ARIBD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:ARIBD

Compositions: 3

RotoID Tables Title DLL
AR0032 ARIBH Invoices ARIBH
AR0031 ARIBC Invoice Batches ARIBC
AR0401 ARIBDO Invoice Detail Optional Fields ARIBDO

Keys: 1

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

Fields: 126

Field Index Type Title Attributes Presentation
CNTBTCH 1 BCD*5.0 Batch Number E A K R 
CNTITEM 2 BCD*4.0 Entry Number E A K R 
CNTLINE 3 BCD*3.0 Line Number E A K R 
IDINVC 4 String*22 Reserved E 
IDITEM 5 String*16 Item Number E A  Mask: %-16C
IDDIST 6 String*6 Distribution Code E A  Mask: %-6N
TEXTDESC 7 String*60 Description E A 
SWMANLITEM 8 Integer Reserved E 
UNITMEAS 9 String*10 Unit of Measure E A  Mask: %-10C
QTYINVC 10 BCD*10.5 Quantity E A 
AMTCOST 11 BCD*10.6 Cost E A 
AMTPRIC 12 BCD*10.6 Price E A 
AMTEXTN 13 BCD*10.3 Extended Amount w/ TIP E A 
AMTCOGS 14 BCD*10.3 COGS Amount E A 
AMTTXBL 15 BCD*10.3 Extended Amount w/o TIP E A C 
TOTTAX 16 BCD*10.3 Tax Total E A C 
SWMANLTX 17 Integer Reserved E 
BASETAX1 18 BCD*10.3 Tax Base 1 E A 
BASETAX2 19 BCD*10.3 Tax Base 2 E A 
BASETAX3 20 BCD*10.3 Tax Base 3 E A 
BASETAX4 21 BCD*10.3 Tax Base 4 E A 
BASETAX5 22 BCD*10.3 Tax Base 5 E A 
TAXSTTS1 23 Integer Tax Class 1 E A 
TAXSTTS2 24 Integer Tax Class 2 E A 
TAXSTTS3 25 Integer Tax Class 3 E A 
TAXSTTS4 26 Integer Tax Class 4 E A 
TAXSTTS5 27 Integer Tax Class 5 E A 
SWTAXINCL1 28 Integer Tax Included 1 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL2 29 Integer Tax Included 2 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL3 30 Integer Tax Included 3 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL4 31 Integer Tax Included 4 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL5 32 Integer Tax Included 5 E A  List:2 entries
0 = No
1 = Yes
RATETAX1 33 BCD*8.5 Tax Rate 1 E A C 
RATETAX2 34 BCD*8.5 Tax Rate 2 E A C 
RATETAX3 35 BCD*8.5 Tax Rate 3 E A C 
RATETAX4 36 BCD*8.5 Tax Rate 4 E A C 
RATETAX5 37 BCD*8.5 Tax Rate 5 E A C 
AMTTAX1 38 BCD*10.3 Tax Amount 1 E A 
AMTTAX2 39 BCD*10.3 Tax Amount 2 E A 
AMTTAX3 40 BCD*10.3 Tax Amount 3 E A 
AMTTAX4 41 BCD*10.3 Tax Amount 4 E A 
AMTTAX5 42 BCD*10.3 Tax Amount 5 E A 
IDACCTREV 43 String*45 Revenue Account E A  Mask: %-45C
IDACCTINV 44 String*45 Inventory Account E A  Mask: %-45C
IDACCTCOGS 45 String*45 COGS Account E A  Mask: %-45C
IDJOBPROJ 46 String*30 Reserved E 
COMMENT 47 String*250 Comments E A 
SWPRTSTMT 48 Integer Print Comment E A 
ITEMCOST 49 BCD*10.3 Item Cost E A 
CONTRACT 50 String*16 Contract Code E A  Mask: %-16C
PROJECT 51 String*16 Project Code E A  Mask: %-16N
CATEGORY 52 String*16 Category Code E A  Mask: %-16N
RESOURCE 53 String*24 Project/Category Resource E A P  Mask: %-16N
TRANSNBR 54 Long Transaction Number E A C 
COSTCLASS 55 Integer Cost Class E A C  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLDATE 56 Date Billing Date E A 
SWIBT 57 Integer Comment Attached E A C  List:2 entries
0 = No
1 = Yes
SWDISCABL 58 Integer Discountable E A  List:2 entries
0 = No
1 = Yes
OCNTLINE 59 BCD*3.0 Original Line Identifier E A 
RTGAMT 60 BCD*10.3 Retainage Amount E A 
RTGPERCENT 61 BCD*5.5 Percent Retained E A 
RTGDAYS 62 Integer Days Retained E A 
RTGDATEDUE 63 Date Retainage Due Date E A 
SWRTGDDTOV 64 Integer Retainage Due Date Override E A  List:2 entries
0 = No
1 = Yes
SWRTGAMTOV 65 Integer Retainage Amount Override E A  List:2 entries
0 = No
1 = Yes
VALUES 66 Long Values E A C 
PROCESSCMD 67 Integer Process Command Code E A C  List:1 entries
0 = Insert Optional Fields
RTGDISTTC 68 BCD*10.3 Retainage Distribution Amount E A C 
RTGCOGSTC 69 BCD*10.3 Retainage COGS Amount E A C 
RTGALTBTC 70 BCD*10.3 Retainage Alternate Base Amount E A C 
RTGINVDIST 71 BCD*10.3 Invoiced Retainage Distribution E A C 
RTGINVCOGS 72 BCD*10.3 Invoiced Retainage COGS E A C 
RTGINVALTB 73 BCD*10.3 Invoiced Retainage Alternate Base E A C 
TXAMT1RC 74 BCD*10.3 Tax Reporting Amount 1 E A 
TXAMT2RC 75 BCD*10.3 Tax Reporting Amount 2 E A 
TXAMT3RC 76 BCD*10.3 Tax Reporting Amount 3 E A 
TXAMT4RC 77 BCD*10.3 Tax Reporting Amount 4 E A 
TXAMT5RC 78 BCD*10.3 Tax Reporting Amount 5 E A 
TXTOTRC 79 BCD*10.3 Tax Reporting Total E A C 
TXBSERT1TC 80 BCD*10.3 Retainage Tax Base 1 E A 
TXBSERT2TC 81 BCD*10.3 Retainage Tax Base 2 E A 
TXBSERT3TC 82 BCD*10.3 Retainage Tax Base 3 E A 
TXBSERT4TC 83 BCD*10.3 Retainage Tax Base 4 E A 
TXBSERT5TC 84 BCD*10.3 Retainage Tax Base 5 E A 
TXAMTRT1TC 85 BCD*10.3 Retainage Tax Amount 1 E A 
TXAMTRT2TC 86 BCD*10.3 Retainage Tax Amount 2 E A 
TXAMTRT3TC 87 BCD*10.3 Retainage Tax Amount 3 E A 
TXAMTRT4TC 88 BCD*10.3 Retainage Tax Amount 4 E A 
TXAMTRT5TC 89 BCD*10.3 Retainage Tax Amount 5 E A 
TXBSE1HC 90 BCD*10.3 Func. Tax Base 1 E A C 
TXBSE2HC 91 BCD*10.3 Func. Tax Base 2 E A C 
TXBSE3HC 92 BCD*10.3 Func. Tax Base 3 E A C 
TXBSE4HC 93 BCD*10.3 Func. Tax Base 4 E A C 
TXBSE5HC 94 BCD*10.3 Func. Tax Base 5 E A C 
TXAMT1HC 95 BCD*10.3 Func. Tax Amount 1 E A C 
TXAMT2HC 96 BCD*10.3 Func. Tax Amount 2 E A C 
TXAMT3HC 97 BCD*10.3 Func. Tax Amount 3 E A C 
TXAMT4HC 98 BCD*10.3 Func. Tax Amount 4 E A C 
TXAMT5HC 99 BCD*10.3 Func. Tax Amount 5 E A C 
TXAMTRT1HC 100 BCD*10.3 Func. Retainage Tax Amount 1 E A C 
TXAMTRT2HC 101 BCD*10.3 Func. Retainage Tax Amount 2 E A C 
TXAMTRT3HC 102 BCD*10.3 Func. Retainage Tax Amount 3 E A C 
TXAMTRT4HC 103 BCD*10.3 Func. Retainage Tax Amount 4 E A C 
TXAMTRT5HC 104 BCD*10.3 Func. Retainage Tax Amount 5 E A C 
DISTNETHC 105 BCD*10.3 Func. Distribution Net of Taxes E A C 
RTGAMTHC 106 BCD*10.3 Func. Retainage Amount E A C 
AMTCOGSHC 107 BCD*10.3 Func. COGS Amount E A C 
AMTCOSTHC 108 BCD*10.6 Func. Cost E A C 
AMTPRICHC 109 BCD*10.6 Func. Price E A C 
AMTEXTNHC 110 BCD*10.3 Func. Extended Amount w/ TIP E A C 
TXTOTRTTC 111 BCD*10.3 Retainage Tax Total E A C 
TXTOTAMT1 112 BCD*10.3 Tax Amount 1 Total E A C 
TXTOTAMT2 113 BCD*10.3 Tax Amount 2 Total E A C 
TXTOTAMT3 114 BCD*10.3 Tax Amount 3 Total E A C 
TXTOTAMT4 115 BCD*10.3 Tax Amount 4 Total E A C 
TXTOTAMT5 116 BCD*10.3 Tax Amount 5 Total E A C 
RTGAMTOTC 117 BCD*10.3 Curr. Retainage Amount E A C 
RTGDISTOTC 118 BCD*10.3 Curr. Retainage Dist. Amount E A C 
RTGCOGSOTC 119 BCD*10.3 Curr. COGS Amount E A C 
RTGALTBOTC 120 BCD*10.3 Curr. Alternate Base Amount E A C 
EDN 121 String*30 Export Declaration Number E A 
AMTWHT1TC 122 BCD*10.3 Estimated Tax Withheld Amount 1 E A C 
AMTWHT2TC 123 BCD*10.3 Estimated Tax Withheld Amount 2 E A C 
AMTWHT3TC 124 BCD*10.3 Estimated Tax Withheld Amount 3 E A C 
AMTWHT4TC 125 BCD*10.3 Estimated Tax Withheld Amount 4 E A C 
AMTWHT5TC 126 BCD*10.3 Estimated Tax Withheld Amount 5 E A C 

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