Table: Open Document Details

Table: AROBLJ
View: AR0200
Record Length: 626

Flags: A R 

Keys: 1

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

Fields: 70

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
VALUES Long Optional Fields
RTGDISTTC BCD*10.3 Retainage Distribution Amount
RTGCOGSTC BCD*10.3 Retainage COGS Amount
RTGALTBTC BCD*10.3 Retainage Alternate Base Amount
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 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
TXRATE1 BCD*8.5 Tax Rate 1
TXRATE2 BCD*8.5 Tax Rate 2
TXRATE3 BCD*8.5 Tax Rate 3
TXRATE4 BCD*8.5 Tax Rate 4
TXRATE5 BCD*8.5 Tax Rate 5
TXBSERT1TC BCD*10.3 Cust. Retainage Tax Base 1
TXBSERT2TC BCD*10.3 Cust. Retainage Tax Base 2
TXBSERT3TC BCD*10.3 Cust. Retainage Tax Base 3
TXBSERT4TC BCD*10.3 Cust. Retainage Tax Base 4
TXBSERT5TC BCD*10.3 Cust. Retainage Tax Base 5
TXAMTRT1TC BCD*10.3 Cust. Retainage Tax Amount 1
TXAMTRT2TC BCD*10.3 Cust. Retainage Tax Amount 2
TXAMTRT3TC BCD*10.3 Cust. Retainage Tax Amount 3
TXAMTRT4TC BCD*10.3 Cust. Retainage Tax Amount 4
TXAMTRT5TC BCD*10.3 Cust. Retainage 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
CNTLASTSEQ Long Last Applied Payment Seq. No.
OAMTWHT1TC BCD*10.3 Orig Est Tax Withheld Amount 1
OAMTWHT2TC BCD*10.3 Orig Est Tax Withheld Amount 2
OAMTWHT3TC BCD*10.3 Orig Est Tax Withheld Amount 3
OAMTWHT4TC BCD*10.3 Orig Est Tax Withheld Amount 4
OAMTWHT5TC BCD*10.3 Orig Est Tax Withheld Amount 5

This page was generated on 2023-Aug-31

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