View: Open Document Details

RotoID: AR0200
Table: AROBLJ
Protocol: Flat
DLL:AROBLJ

Keys: 1

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

Fields: 66

Field Index Type Title Attributes Presentation
IDCUST 1 String*12 Customer Number E A K R  Mask: %-12C
IDINVC 2 String*22 Document Number E A K R  Mask: %-22C
CNTLINE 3 BCD*3.0 Line Number E A K R 
CONTRACT 4 String*16 Contract Code E A  Mask: %-16C
PROJECT 5 String*16 Project Code E A  Mask: %-16N
CATEGORY 6 String*16 Category Code E A  Mask: %-16N
RESOURCE 7 String*24 Project/Category Resource E A P  Mask: %-16N
TRANSNBR 8 Long Transaction Number E A 
COSTCLASS 9 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
IDDIST 10 String*6 Distribution Code E A  Mask: %-6N
IDGLACCT 11 String*45 G/L Account E A  Mask: %-45C
AMTINVCTC 12 BCD*10.3 Cust. Currency Invoice Amount E A 
AMTDUETC 13 BCD*10.3 Cust. Currency Amount Due E A 
AMTINVCHC 14 BCD*10.3 Func. Currency Invoice Amount E A 
AMTDUEHC 15 BCD*10.3 Func. Currency Amount Due E A 
IDITEM 16 String*16 Item Number E A  Mask: %-16C
UNITMEAS 17 String*10 Unit of Measure E A  Mask: %-10C
QTYINVC 18 BCD*10.5 Quantity E A 
AMTCOST 19 BCD*10.6 Cost E A 
BILLDATE 20 Date Billing Date E A 
SWDISCABL 21 Integer Discountable E A  List:2 entries
0 = No
1 = Yes
RTGDATEDUE 22 Date Date Retainage Due E A 
RTGOAMTHC 23 BCD*10.3 Func. Curr. Orig. Rtng. Amt. E A 
RTGAMTHC 24 BCD*10.3 Func. Curr. Retainage Amount E A 
RTGOAMTTC 25 BCD*10.3 Cust. Curr. Orig. Rtng. Amt. E A 
RTGAMTTC 26 BCD*10.3 Cust. Curr. Retainage Amount E A 
VALUES 27 Long Optional Fields E A 
RTGDISTTC 28 BCD*10.3 Retainage Distribution Amount E A 
RTGCOGSTC 29 BCD*10.3 Retainage COGS Amount E A 
RTGALTBTC 30 BCD*10.3 Retainage Alternate Base Amount E A 
TAXCLASS1 31 Integer Tax Class 1 E A 
TAXCLASS2 32 Integer Tax Class 2 E A 
TAXCLASS3 33 Integer Tax Class 3 E A 
TAXCLASS4 34 Integer Tax Class 4 E A 
TAXCLASS5 35 Integer Tax Class 5 E A 
SWTAXINCL1 36 Integer Tax Included 1 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL2 37 Integer Tax Included 2 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL3 38 Integer Tax Included 3 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL4 39 Integer Tax Included 4 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL5 40 Integer Tax Included 5 E A  List:2 entries
0 = No
1 = Yes
TXRATE1 41 BCD*8.5 Tax Rate 1 E A 
TXRATE2 42 BCD*8.5 Tax Rate 2 E A 
TXRATE3 43 BCD*8.5 Tax Rate 3 E A 
TXRATE4 44 BCD*8.5 Tax Rate 4 E A 
TXRATE5 45 BCD*8.5 Tax Rate 5 E A 
TXBSERT1TC 46 BCD*10.3 Cust. Retainage Tax Base 1 E A 
TXBSERT2TC 47 BCD*10.3 Cust. Retainage Tax Base 2 E A 
TXBSERT3TC 48 BCD*10.3 Cust. Retainage Tax Base 3 E A 
TXBSERT4TC 49 BCD*10.3 Cust. Retainage Tax Base 4 E A 
TXBSERT5TC 50 BCD*10.3 Cust. Retainage Tax Base 5 E A 
TXAMTRT1TC 51 BCD*10.3 Cust. Retainage Tax Amount 1 E A 
TXAMTRT2TC 52 BCD*10.3 Cust. Retainage Tax Amount 2 E A 
TXAMTRT3TC 53 BCD*10.3 Cust. Retainage Tax Amount 3 E A 
TXAMTRT4TC 54 BCD*10.3 Cust. Retainage Tax Amount 4 E A 
TXAMTRT5TC 55 BCD*10.3 Cust. Retainage Tax Amount 5 E A 
TXAMTRT1HC 56 BCD*10.3 Func. Retainage Tax Amount 1 E A 
TXAMTRT2HC 57 BCD*10.3 Func. Retainage Tax Amount 2 E A 
TXAMTRT3HC 58 BCD*10.3 Func. Retainage Tax Amount 3 E A 
TXAMTRT4HC 59 BCD*10.3 Func. Retainage Tax Amount 4 E A 
TXAMTRT5HC 60 BCD*10.3 Func. Retainage Tax Amount 5 E A 
CNTLASTSEQ 61 Long Last Applied Payment Seq. No. E A 
OAMTWHT1TC 62 BCD*10.3 Orig Est Tax Withheld Amount 1 E A 
OAMTWHT2TC 63 BCD*10.3 Orig Est Tax Withheld Amount 2 E A 
OAMTWHT3TC 64 BCD*10.3 Orig Est Tax Withheld Amount 3 E A 
OAMTWHT4TC 65 BCD*10.3 Orig Est Tax Withheld Amount 4 E A 
OAMTWHT5TC 66 BCD*10.3 Orig Est Tax Withheld Amount 5 E A 

This page was generated on 2021-Nov-24

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