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

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