Table: Invoice Details

Table: APIBD
View: AP0022
Record length: 1443
Flags: A R 

Keys: 1

Title  Flags  Fields

Batch Number / Entry Number  CNTBTCH, CNTITEM, CNTLINE

Fields: 155

Field  Type  Title  Presentation 

CNTBTCH  BCD*5.0  Batch Number   
CNTITEM  BCD*4.0  Entry Number   
CNTLINE  BCD*3.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDDIST  String*6  Distribution Code  Mask: %-6N
TEXTDESC  String*60  Distribution Description   
SWMANLDIST  Integer  Reserved   
AMTTOTTAX  BCD*10.3  Tax Total   
SWMANLTX  Integer  Manual Tax Entry  List: 2 entries
0=No
1=Yes
BASETAX1  BCD*10.3  Base Tax 1   
BASETAX2  BCD*10.3  Base Tax 2   
BASETAX3  BCD*10.3  Base Tax 3   
BASETAX4  BCD*10.3  Base Tax 4   
BASETAX5  BCD*10.3  Base Tax 5   
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 Inclusive 1  List: 2 entries
0=No
1=Yes
SWTAXINCL2  Integer  Tax Inclusive 2  List: 2 entries
0=No
1=Yes
SWTAXINCL3  Integer  Tax Inclusive 3  List: 2 entries
0=No
1=Yes
SWTAXINCL4  Integer  Tax Inclusive 4  List: 2 entries
0=No
1=Yes
SWTAXINCL5  Integer  Tax Inclusive 5  List: 2 entries
0=No
1=Yes
RATETAX1  BCD*8.5  Tax Rate 1   
RATETAX2  BCD*8.5  Tax Rate 2   
RATETAX3  BCD*8.5  Tax Rate 3   
RATETAX4  BCD*8.5  Tax Rate 4   
RATETAX5  BCD*8.5  Tax Rate 5   
AMTTAX1  BCD*10.3  Tax Amount 1   
AMTTAX2  BCD*10.3  Tax Amount 2   
AMTTAX3  BCD*10.3  Tax Amount 3   
AMTTAX4  BCD*10.3  Tax Amount 4   
AMTTAX5  BCD*10.3  Tax Amount 5   
IDGLACCT  String*45  G/L Account  Mask: %-45C
IDACCTTAX  String*45  Retainage Allocated Tax Account  Mask: %-45C
ID1099CLAS  String*6  Reserved   
AMTDIST  BCD*10.3  Distributed Amount   
AMTDISTNET  BCD*10.3  Distributed Amount Before Taxes   
AMTINCLTAX  BCD*10.3  Tax Amount Included in Price   
AMTGLDIST  BCD*10.3  G/L Distributed Amount   
AMTTAXREC1  BCD*10.3  Recoverable Tax Amount 1   
AMTTAXREC2  BCD*10.3  Recoverable Tax Amount 2   
AMTTAXREC3  BCD*10.3  Recoverable Tax Amount 3   
AMTTAXREC4  BCD*10.3  Recoverable Tax Amount 4   
AMTTAXREC5  BCD*10.3  Recoverable Tax Amount 5   
AMTTAXEXP1  BCD*10.3  Expense Sep. Tax Amount 1   
AMTTAXEXP2  BCD*10.3  Expense Sep. Tax Amount 2   
AMTTAXEXP3  BCD*10.3  Expense Sep. Tax Amount 3   
AMTTAXEXP4  BCD*10.3  Expense Sep. Tax Amount 4   
AMTTAXEXP5  BCD*10.3  Expense Sep. Tax Amount 5   
AMTTAXTOBE  BCD*10.3  Tax Allocated Total   
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
BILLTYPE  Integer  Billing Type  List: 1 entries
0=
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
SWIBT  Integer  Comment Attached  List: 2 entries
0=No
1=Yes
SWDISCABL  Integer  Discountable  List: 2 entries
0=No
1=Yes
OCNTLINE  BCD*3.0  Original Line Identifier   
RTGAMT  BCD*10.3  Retainage Amount   
RTGPERCENT  BCD*5.5  Percent Retained   
RTGDAYS  Integer  Days Retained   
RTGDATEDUE  Date  Retainage Due Date   
SWRTGDDTOV  Integer  Retainage Due Date Override  List: 2 entries
0=No
1=Yes
SWRTGAMTOV  Integer  Retainage Amount Override  List: 2 entries
0=No
1=Yes
VALUES  Long  Optional Fields   
DESCOMP  String*6  Destination  Mask: %-6N
ROUTE  Integer  Route No.   
RTGDISTTC  BCD*10.3  Retainage Distribution Amount   
RTGINVDIST  BCD*10.3  Invoiced Retainage Distribution   
TXAMT1RC  BCD*10.3  Tax Reporting Amount 1   
TXAMT2RC  BCD*10.3  Tax Reporting Amount 2   
TXAMT3RC  BCD*10.3  Tax Reporting Amount 3   
TXAMT4RC  BCD*10.3  Tax Reporting Amount 4   
TXAMT5RC  BCD*10.3  Tax Reporting Amount 5   
TXTOTRC  BCD*10.3  Tax Reporting Total   
TXALLRC  BCD*10.3  Tax Reporting Allocated Tax   
TXEXP1RC  BCD*10.3  Tax Reporting Expensed Tax 1   
TXEXP2RC  BCD*10.3  Tax Reporting Expensed Tax 2   
TXEXP3RC  BCD*10.3  Tax Reporting Expensed Tax 3   
TXEXP4RC  BCD*10.3  Tax Reporting Expensed Tax 4   
TXEXP5RC  BCD*10.3  Tax Reporting Expensed Tax 5   
TXREC1RC  BCD*10.3  Tax Reporting Recoverable Tax 1   
TXREC2RC  BCD*10.3  Tax Reporting Recoverable Tax 2   
TXREC3RC  BCD*10.3  Tax Reporting Recoverable Tax 3   
TXREC4RC  BCD*10.3  Tax Reporting Recoverable Tax 4   
TXREC5RC  BCD*10.3  Tax Reporting Recoverable Tax 5   
TXBSERT1TC  BCD*10.3  Retainage Tax Base 1   
TXBSERT2TC  BCD*10.3  Retainage Tax Base 2   
TXBSERT3TC  BCD*10.3  Retainage Tax Base 3   
TXBSERT4TC  BCD*10.3  Retainage Tax Base 4   
TXBSERT5TC  BCD*10.3  Retainage Tax Base 5   
TXAMTRT1TC  BCD*10.3  Retainage Tax Amount 1   
TXAMTRT2TC  BCD*10.3  Retainage Tax Amount 2   
TXAMTRT3TC  BCD*10.3  Retainage Tax Amount 3   
TXAMTRT4TC  BCD*10.3  Retainage Tax Amount 4   
TXAMTRT5TC  BCD*10.3  Retainage Tax Amount 5   
TXBSE1HC  BCD*10.3  Func. Tax Base 1   
TXBSE2HC  BCD*10.3  Func. Tax Base 2   
TXBSE3HC  BCD*10.3  Func. Tax Base 3   
TXBSE4HC  BCD*10.3  Func. Tax Base 4   
TXBSE5HC  BCD*10.3  Func. Tax Base 5   
TXAMT1HC  BCD*10.3  Func. Tax Amount 1   
TXAMT2HC  BCD*10.3  Func. Tax Amount 2   
TXAMT3HC  BCD*10.3  Func. Tax Amount 3   
TXAMT4HC  BCD*10.3  Func. Tax Amount 4   
TXAMT5HC  BCD*10.3  Func. 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   
TXREC1HC  BCD*10.3  Func. Tax Recoverable Amount 1   
TXREC2HC  BCD*10.3  Func. Tax Recoverable Amount 2   
TXREC3HC  BCD*10.3  Func. Tax Recoverable Amount 3   
TXREC4HC  BCD*10.3  Func. Tax Recoverable Amount 4   
TXREC5HC  BCD*10.3  Func. Tax Recoverable Amount 5   
TXEXP1HC  BCD*10.3  Func. Tax Expense Sep. Amount 1   
TXEXP2HC  BCD*10.3  Func. Tax Expense Sep. Amount 2   
TXEXP3HC  BCD*10.3  Func. Tax Expense Sep. Amount 3   
TXEXP4HC  BCD*10.3  Func. Tax Expense Sep. Amount 4   
TXEXP5HC  BCD*10.3  Func. Tax Expense Sep. Amount 5   
TXALLHC  BCD*10.3  Func. Tax Allocated Total   
TXALL1HC  BCD*10.3  Func. Tax Allocated Amount 1   
TXALL2HC  BCD*10.3  Func. Tax Allocated Amount 2   
TXALL3HC  BCD*10.3  Func. Tax Allocated Amount 3   
TXALL4HC  BCD*10.3  Func. Tax Allocated Amount 4   
TXALL5HC  BCD*10.3  Func. Tax Allocated Amount 5   
TXALL1TC  BCD*10.3  Tax Allocated Amount 1   
TXALL2TC  BCD*10.3  Tax Allocated Amount 2   
TXALL3TC  BCD*10.3  Tax Allocated Amount 3   
TXALL4TC  BCD*10.3  Tax Allocated Amount 4   
TXALL5TC  BCD*10.3  Tax Allocated Amount 5   
AMTCOSTHC  BCD*10.6  Func. Cost   
AMTDISTHC  BCD*10.3  Func. Distributed Amount   
DISTNETHC  BCD*10.3  Func. Distribution Net of Taxes   
RTGAMTHC  BCD*10.3  Func. Retainage Amount   
TXALLRTHC  BCD*10.3  Func. Retainage Tax Allocated   
TXALLRTTC  BCD*10.3  Retainage Tax Allocated   
TXEXPRTHC  BCD*10.3  Func. Retainage Tax Expensed   
TXEXPRTTC  BCD*10.3  Retainage Tax Expensed   
SWFAS  Integer  Fixed Asset  List: 2 entries
0=No
1=Yes

This page was generated on 2009-Nov-19

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