# Table: Open Document Details

Table: AROBLJ
View: AR0200
Record length: 572
Flags: A R

## Keys: 1

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

## Fields: 64

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

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.