Table: Open Document Details

Table: APOBLJ
View: AP0200
Record length: 656
Flags: A R 

Keys: 1

Title  Flags  Fields

Vend. No./Doc. No./Line No.  IDVEND, IDINVC, CNTLINE

Fields: 71

Field  Type  Title  Presentation 

IDVEND  String*12  Vendor 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
BILLTYPE  Integer  Billing Type  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
AMTINVCHC  BCD*10.3  Func. Currency Invoice Amount   
AMTDUEHC  BCD*10.3  Func. Currency Amount Due   
AMTINVCTC  BCD*10.3  Vend. Currency Invoice Amount   
AMTDUETC  BCD*10.3  Vend. 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   
BILLRATE  BCD*10.6  Billing Rate   
BILLCURN  String*3  Billing Currency  Mask: %-3N
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  Vend. Curr. Orig. Rtng. Amt.   
RTGAMTTC  BCD*10.3  Vend. Curr. Retainage Amount   
VALUES  Long  Optional Fields   
RTGDISTTC  BCD*10.3  Retainage Distribution 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  Vend. Retainage Tax Base 1   
TXBSERT2TC  BCD*10.3  Vend. Retainage Tax Base 2   
TXBSERT3TC  BCD*10.3  Vend. Retainage Tax Base 3   
TXBSERT4TC  BCD*10.3  Vend. Retainage Tax Base 4   
TXBSERT5TC  BCD*10.3  Vend. Retainage Tax Base 5   
TXAMTRT1TC  BCD*10.3  Vend. Retainage Tax Amount 1   
TXAMTRT2TC  BCD*10.3  Vend. Retainage Tax Amount 2   
TXAMTRT3TC  BCD*10.3  Vend. Retainage Tax Amount 3   
TXAMTRT4TC  BCD*10.3  Vend. Retainage Tax Amount 4   
TXAMTRT5TC  BCD*10.3  Vend. 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   
TXALLRTHC  BCD*10.3  Func. Retainage Tax Allocated   
TXALLRTTC  BCD*10.3  Vend. Retainage Tax Allocated   
TXEXPRTHC  BCD*10.3  Func. Retainage Tax Expensed   
TXEXPRTTC  BCD*10.3  Vend. Retainage Tax Expensed   
TXALLACCT  String*45  Allocated Tax Account  Mask: %-45C
CNTLASTSEQ  Long  Last Applied Payment Seq. No.   

This page was generated on 2008-May-01

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