Table: Invoices

Table: APIBH
View: AP0021
Record Length: 2698

Flags: A R 

Keys: 4

Title Flags Fields
Batch Number/Entry Number CNTBTCH, CNTITEM
Vendor Number/Document Number D M  ORIGCOMP, IDVEND, IDINVC
Vendor Number/Total Distributed D M  ORIGCOMP, IDVEND, AMTTOTDIST
Vendor Number/Document Date D M  ORIGCOMP, IDVEND, DATEINVC

Fields: 206

Field Type Title Presentation
CNTBTCH BCD*5.0 Batch Number
CNTITEM BCD*4.0 Entry Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
IDVEND String*12 Vendor Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
IDRMITTO String*6 Remit-To Location Mask: %-6N
TEXTTRX Integer Document Type List:4 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
IDTRX Integer Transaction Type List:5 entries
12 = Invoice - Summary Entered
13 = Invoice - Recurring Charge
22 = Debit Note - Summary Entered
32 = Credit Note - Summary Entered
40 = Interest Charge
INVCSTTS Integer Reserved
ORDRNBR String*22 Order Number Mask: %-22C
PONBR String*22 PO Number Mask: %-22C
INVCDESC String*60 Invoice Description
SWPRTINVC Integer Reserved
INVCAPPLTO String*22 Apply-to Document Mask: %-22C
IDACCTSET String*6 Account Set Mask: %-6N
DATEINVC Date Document Date
DATEASOF Date As of Date
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
CODECURN String*3 Currency Code Mask: %-3N
RATETYPE String*2 Rate Type Mask: %-2N
SWMANRTE Integer Rate Overridden List:2 entries
0 = No
1 = Yes
EXCHRATEHC BCD*8.7 Exchange Rate
ORIGRATEHC BCD*8.7 Apply-to Exchange Rate
TERMCODE String*6 Terms Mask: %-6N
SWTERMOVRD Integer Terms Overridden List:2 entries
0 = No
1 = Yes
DATEDUE Date Due Date
DATEDISC Date Discount Date
PCTDISC BCD*5.5 Discount Percentage
AMTDISCAVL BCD*10.3 Discount Amount Available
LASTLINE BCD*3.0 Number of Details
SWTAXBL Integer Taxable List:2 entries
0 = No
1 = Yes
SWCALCTX Integer Tax Amount Control List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
CODETAXGRP String*12 Tax Group Mask: %-12N
CODETAX1 String*12 Tax Authority 1
CODETAX2 String*12 Tax Authority 2
CODETAX3 String*12 Tax Authority 3
CODETAX4 String*12 Tax Authority 4
CODETAX5 String*12 Tax Authority 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
BASETAX1 BCD*10.3 Tax Base 1
BASETAX2 BCD*10.3 Tax Base 2
BASETAX3 BCD*10.3 Tax Base 3
BASETAX4 BCD*10.3 Tax Base 4
BASETAX5 BCD*10.3 Tax Base 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
AMT1099 BCD*10.3 1099/CPRS Amount
AMTDISTSET BCD*10.3 Distribution Set Amount
AMTTAXDIST BCD*10.3 Total Distributed Tax
AMTINVCTOT BCD*10.3 Document Total Before Taxes
AMTALLOCTX BCD*10.3 Distributed Allocated Taxes
CNTPAYMSCH BCD*3.0 Number of Scheduled Payments
AMTTOTDIST BCD*10.3 Distributed Total Before Taxes
AMTGROSDST BCD*10.3 Distributed Total Including Tax
IDPPD String*22 Prepayment Number
TEXTRMIT String*60 Location Name
TEXTSTE1 String*60 Address Line 1
TEXTSTE2 String*60 Address Line 2
TEXTSTE3 String*60 Address Line 3
TEXTSTE4 String*60 Address Line 4
NAMECITY String*30 City
CODESTTE String*30 State/Prov.
CODEPSTL String*20 Zip/Postal Code
CODECTRY String*30 Country
NAMECTAC String*60 Contact Name
TEXTPHON String*30 Phone Number Mask: (%-3C) %-3C-%-24C
TEXTFAX String*30 Fax Number Mask: (%-3C) %-3C-%-24C
DATERATE Date Rate Date
AMTRECTAX BCD*10.3 Recoverable Taxes
CODEPAYPPD BCD*3.0 Reserved
CODEVNDGRP String*6 Vendor Group Code Mask: %-6N
TERMSDESC String*60 Terms Description
IDDISTSET String*6 Distribution Set Mask: %-6N
ID1099CLAS String*6 1099/CPRS Code Mask: %-6N
AMTTAXTOT BCD*10.3 Tax Total
AMTGROSTOT BCD*10.3 Document Total Including Tax
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
AMTEXPTAX BCD*10.3 Expensed Separately Taxes
AMTAXTOBE BCD*10.3 Tax Amount to be Allocated
TAXOUTBAL BCD*10.3 Reserved
CODEOPER Integer Currency Code Operator List:2 entries
1 = Multiply
2 = Divide
ACCTREC1 String*45 Recoverable Account 1 Mask: %-45C
ACCTREC2 String*45 Recoverable Account 2 Mask: %-45C
ACCTREC3 String*45 Recoverable Account 3 Mask: %-45C
ACCTREC4 String*45 Recoverable Account 4 Mask: %-45C
ACCTREC5 String*45 Recoverable Account 5 Mask: %-45C
ACCTEXP1 String*45 Expense Sep. Account 1 Mask: %-45C
ACCTEXP2 String*45 Expense Sep. Account 2 Mask: %-45C
ACCTEXP3 String*45 Expense Sep. Account 3 Mask: %-45C
ACCTEXP4 String*45 Expense Sep. Account 4 Mask: %-45C
ACCTEXP5 String*45 Expense Sep. Account 5 Mask: %-45C
DRILLAPP String*2 Drill Down Application Source Mask: %-2A
DRILLTYPE Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link Number
SWJOB Integer Job Related List:2 entries
0 = No
1 = Yes
AMTRECDIST BCD*10.3 Dist. Recoverable Taxes
AMTEXPDIST BCD*10.3 Dist. Exp. Separately Taxes
ERRBATCH Long Error Batch
ERRENTRY Long Error Entry
EMAIL String*50 E-mail
CTACPHONE String*30 Contact's Phone Mask: (%-3C) %-3C-%-24C
CTACFAX String*30 Contact's Fax Mask: (%-3C) %-3C-%-24C
CTACEMAIL String*50 Contact's E-mail
AMTPPD BCD*10.3 Prepayment Amount
IDSTDINVC String*16 Recurring Payable Code Mask: %-16C
DATEPRCS Date Date Generated
AMTDSBWTAX BCD*10.3 Discount Base With Tax
AMTDSBNTAX BCD*10.3 Discount Base Without Tax
AMTDSCBASE BCD*10.3 Discount Base
SWRTGINVC Integer Retainage Invoice List:2 entries
0 = No
1 = Yes
RTGAPPLYTO String*22 Original Doc. No. Mask: %-22C
SWRTG Integer Has Retainage List:2 entries
0 = No
1 = Yes
RTGAMT BCD*10.3 Retainage Amount
RTGPERCENT BCD*5.5 Percent Retained
RTGDAYS Integer Days Retained
RTGDATEDUE Date Retainage Due Date
RTGTERMS String*6 Retainage Terms Code Mask: %-6N
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
SWRTGRATE Integer Retainage Exchange Rate List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
SWTXBSECTL Integer Tax Base Control List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
VALUES Long Optional Fields
ORIGCOMP String*6 Originator Mask: %-6N
DETAILCNT Long Number of Details
SRCEAPPL String*2 Source Application Mask: %-2A
SWHOLD Integer On Hold List:2 entries
0 = No
1 = Yes
APVERSION String*3 A/P Version Created In
TAXVERSION Long Tax State Version
SWTXRTGRPT Integer Report Retainage Tax
CODECURNRC String*3 Tax Reporting Currency Code Mask: %-3N
SWTXCTLRC Integer Tax Reporting Calculate Method List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
RATERC BCD*8.7 Tax Reporting Exchange Rate
RATETYPERC String*2 Tax Reporting Rate Type Mask: %-2N
RATEDATERC Date Tax Reporting Rate Date
RATEOPRC Integer Tax Reporting Rate Operator List:2 entries
1 = Multiply
2 = Divide
SWRATERC Integer Tax Reporting Rate Override List:2 entries
0 = No
1 = Yes
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
TXEXPRC BCD*10.3 Tax Reporting Expensed Tax
TXRECRC BCD*10.3 Tax Reporting Recoverable Tax
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
AMTGROSHC BCD*10.3 Func. Distribution w/ Tax Total
RTGAMTHC BCD*10.3 Func. Retainage Amount
AMTDISCHC BCD*10.3 Func. Discount Amount
AMT1099HC BCD*10.3 Func. 1099/CPRS Amount
AMTPPDHC BCD*10.3 Func. Prepayment Amount
AMTDUETC BCD*10.3 Amount Due
AMTDUEHC BCD*10.3 Func. Amount Due
TEXTVEN String*60 Vendor Name
ENTEREDBY String*8 Entered By
DATEBUS Date Posting Date
IDN String*30 Import Declaration Number
AMTWHT1TC BCD*10.3 Estimated Tax Withheld Amount 1
AMTWHT2TC BCD*10.3 Estimated Tax Withheld Amount 2
AMTWHT3TC BCD*10.3 Estimated Tax Withheld Amount 3
AMTWHT4TC BCD*10.3 Estimated Tax Withheld Amount 4
AMTWHT5TC BCD*10.3 Estimated Tax Withheld Amount 5
AMTCXBS1TC BCD*10.3 Reverse Charges Base 1
AMTCXBS2TC BCD*10.3 Reverse Charges Base 2
AMTCXBS3TC BCD*10.3 Reverse Charges Base 3
AMTCXBS4TC BCD*10.3 Reverse Charges Base 4
AMTCXBS5TC BCD*10.3 Reverse Charges Base 5
AMTCXTX1TC BCD*10.3 Reverse Charges Amount 1
AMTCXTX2TC BCD*10.3 Reverse Charges Amount 2
AMTCXTX3TC BCD*10.3 Reverse Charges Amount 3
AMTCXTX4TC BCD*10.3 Reverse Charges Amount 4
AMTCXTX5TC BCD*10.3 Reverse Charges Amount 5

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).