# View: Open Document Details

RotoID: AP0200
Table: APOBLJ
Protocol: Flat
DLL: APOBLJ

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Vend. No./Doc. No./Line No. | IDVEND, IDINVC, CNTLINE

## Fields: 67

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
IDVEND | 1 | String*12 | Vendor 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
BILLTYPE | 12 | Integer | Billing Type | E A | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
AMTINVCHC | 13 | BCD*10.3 | Func. Currency Invoice Amount | E A |
AMTDUEHC | 14 | BCD*10.3 | Func. Currency Amount Due | E A |
AMTINVCTC | 15 | BCD*10.3 | Vend. Currency Invoice Amount | E A |
AMTDUETC | 16 | BCD*10.3 | Vend. Currency Amount Due | E A |
IDITEM | 17 | String*16 | Item Number | E A | Mask: %-16C
UNITMEAS | 18 | String*10 | Unit of Measure | E A | Mask: %-10C
QTYINVC | 19 | BCD*10.5 | Quantity | E A |
AMTCOST | 20 | BCD*10.6 | Cost | E A |
BILLDATE | 21 | Date | Billing Date | E A |
BILLRATE | 22 | BCD*10.6 | Billing Rate | E A |
BILLCURN | 23 | String*3 | Billing Currency | E A | Mask: %-3N
SWDISCABL | 24 | Integer | Discountable | E A | List: 2 entries
0 | = | No
1 | = | Yes
RTGDATEDUE | 25 | Date | Date Retainage Due | E A |
RTGOAMTHC | 26 | BCD*10.3 | Func. Curr. Orig. Rtng. Amt. | E A |
RTGAMTHC | 27 | BCD*10.3 | Func. Curr. Retainage Amount | E A |
RTGOAMTTC | 28 | BCD*10.3 | Vend. Curr. Orig. Rtng. Amt. | E A |
RTGAMTTC | 29 | BCD*10.3 | Vend. Curr. Retainage Amount | E A |
VALUES | 30 | Long | Optional Fields | E A |
RTGDISTTC | 31 | BCD*10.3 | Retainage Distribution Amount | E A |
TAXCLASS1 | 32 | Integer | Tax Class 1 | E A |
TAXCLASS2 | 33 | Integer | Tax Class 2 | E A |
TAXCLASS3 | 34 | Integer | Tax Class 3 | E A |
TAXCLASS4 | 35 | Integer | Tax Class 4 | E A |
TAXCLASS5 | 36 | Integer | Tax Class 5 | E A |
SWTAXINCL1 | 37 | Integer | Tax Included 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | 38 | Integer | Tax Included 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | 39 | Integer | Tax Included 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | 40 | Integer | Tax Included 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | 41 | Integer | Tax Included 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TXRATE1 | 42 | BCD*8.5 | Tax Rate 1 | E A |
TXRATE2 | 43 | BCD*8.5 | Tax Rate 2 | E A |
TXRATE3 | 44 | BCD*8.5 | Tax Rate 3 | E A |
TXRATE4 | 45 | BCD*8.5 | Tax Rate 4 | E A |
TXRATE5 | 46 | BCD*8.5 | Tax Rate 5 | E A |
TXBSERT1TC | 47 | BCD*10.3 | Vend. Retainage Tax Base 1 | E A |
TXBSERT2TC | 48 | BCD*10.3 | Vend. Retainage Tax Base 2 | E A |
TXBSERT3TC | 49 | BCD*10.3 | Vend. Retainage Tax Base 3 | E A |
TXBSERT4TC | 50 | BCD*10.3 | Vend. Retainage Tax Base 4 | E A |
TXBSERT5TC | 51 | BCD*10.3 | Vend. Retainage Tax Base 5 | E A |
TXAMTRT1TC | 52 | BCD*10.3 | Vend. Retainage Tax Amount 1 | E A |
TXAMTRT2TC | 53 | BCD*10.3 | Vend. Retainage Tax Amount 2 | E A |
TXAMTRT3TC | 54 | BCD*10.3 | Vend. Retainage Tax Amount 3 | E A |
TXAMTRT4TC | 55 | BCD*10.3 | Vend. Retainage Tax Amount 4 | E A |
TXAMTRT5TC | 56 | BCD*10.3 | Vend. Retainage Tax Amount 5 | E A |
TXAMTRT1HC | 57 | BCD*10.3 | Func. Retainage Tax Amount 1 | E A |
TXAMTRT2HC | 58 | BCD*10.3 | Func. Retainage Tax Amount 2 | E A |
TXAMTRT3HC | 59 | BCD*10.3 | Func. Retainage Tax Amount 3 | E A |
TXAMTRT4HC | 60 | BCD*10.3 | Func. Retainage Tax Amount 4 | E A |
TXAMTRT5HC | 61 | BCD*10.3 | Func. Retainage Tax Amount 5 | E A |
TXALLRTHC | 62 | BCD*10.3 | Func. Retainage Tax Allocated | E A |
TXALLRTTC | 63 | BCD*10.3 | Vend. Retainage Tax Allocated | E A |
TXEXPRTHC | 64 | BCD*10.3 | Func. Retainage Tax Expensed | E A |
TXEXPRTTC | 65 | BCD*10.3 | Vend. Retainage Tax Expensed | E A |
TXALLACCT | 66 | String*45 | Allocated Tax Account | E A | Mask: %-45C
CNTLASTSEQ | 67 | Long | Last Applied Payment Seq. No. | E A |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.