Table: Documents

Table: APOBL
View: AP0025
Record Length: 1119

Flags: A R 

Keys: 7

Title Flags Fields
Vendor Number/Document Number IDVEND, IDINVC
Paid/Order Number M  SWPAID, IDORDERNBR, IDVEND, IDINVC
Paid/PO Number D M  SWPAID, IDPONBR, IDVEND, IDINVC
Due Date D M  DATEINVCDU, IDVEND, IDINVC
Paid/Vendor Number D M  SWPAID, IDVEND, IDPREPAY
Vendor Number/Invoice Date D M  IDVEND, DATEINVC
Retainage Outstanding/Vendor Num D M  SWRTGOUT, IDVEND, IDINVC

Fields: 149

Field Type Title Presentation
IDVEND String*12 Vendor Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
IDRMIT String*18 Check Number Mask: %-18D
IDORDERNBR String*22 Order Number Mask: %-22C
IDPONBR String*22 PO Number Mask: %-22C
DATEINVCDU Date Due Date
IDRMITTO String*6 Remit-To Location Mask: %-6N
IDTRXTYPE Integer Transaction Type List:8 entries
12 = Invoice - Summary Entered
13 = Invoice - Recurring Charge
22 = Debit Note - Summary Entered
26 = Debit Note - Advance Credit Claim
32 = Credit Note - Summary Entered
40 = Interest Charge
50 = Prepayment - Posted
51 = Payment - Posted
TXTTRXTYPE Integer Document Type List:6 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
10 = Prepayment
11 = Payment
DATEBTCH Date Batch Date
CNTBTCH BCD*5.0 Batch Number
CNTITEM BCD*4.0 Entry Number
IDVENDGRP String*6 Group Code Mask: %-6N
DESCINVC String*60 Doc. Description
DATEINVC Date Doc. Date
DATEASOF Date Invoice as-of Date
CODETERM String*6 Terms Mask: %-6N
DATEDISC Date Discount Date
CODECURN String*3 Currency Code Mask: %-3N
IDRATETYPE String*2 Rate Type Mask: %-2N
SWRATEOVRD Integer Rate Overridden List:2 entries
0 = No
1 = Yes
EXCHRATEHC BCD*8.7 Exchange Rate
AMTINVCHC BCD*10.3 Func. Currency Invoice Amount
AMTDUEHC BCD*10.3 Func. Currency Amount Due
AMTTXBLHC BCD*10.3 Func. Currency Taxable Amount
AMTNONTXHC BCD*10.3 Func. Currency Non-Taxable Amt.
AMTTAXHC BCD*10.3 Func. Currency Tax Amount
AMTDISCHC BCD*10.3 Func. Currency Discount Amount
AMTINVCTC BCD*10.3 Vend. Currency Invoice Amount
AMTDUETC BCD*10.3 Vend. Currency Amount Due
AMTTXBLTC BCD*10.3 Vend. Currency Taxable Amount
AMTNONTXTC BCD*10.3 Vend. Currency Non-Taxable Amt.
AMTTAXTC BCD*10.3 Vend. Currency Tax Amount
AMTDISCTC BCD*10.3 Vend. Currency Discount Amount
SWPAID Integer Fully Paid List:2 entries
0 = No
1 = Yes
DATELSTACT Date Last Activity Date
DATELSTSTM Date Last Statement Date
CNTTOTPAYM BCD*3.0 Number of Scheduled Payments
CNTLSTPAYM BCD*3.0 Reserved - Last Payment Number Paid
CNTLSTPYST BCD*3.0 Payment Number on Last Statement
AMTREMIT BCD*10.3 Reserved - Payment Amount
CNTLASTSCH BCD*3.0 Last Applied Payment Seq. No.
SWTAXOVRD Integer Tax Amount Control List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
CODETAX1 String*12 Tax Auth. 1 Mask: %-12N
CODETAX2 String*12 Tax Auth. 2 Mask: %-12N
CODETAX3 String*12 Tax Auth. 3 Mask: %-12N
CODETAX4 String*12 Tax Auth. 4 Mask: %-12N
CODETAX5 String*12 Tax Auth. 5 Mask: %-12N
AMTBASE1HC BCD*10.3 Func. Base Amount 1
AMTBASE2HC BCD*10.3 Func. Base Amount 2
AMTBASE3HC BCD*10.3 Func. Base Amount 3
AMTBASE4HC BCD*10.3 Func. Base Amount 4
AMTBASE5HC BCD*10.3 Func. Base Amount 5
AMTTAX1HC BCD*10.3 Func. Tax Amount 1
AMTTAX2HC BCD*10.3 Func. Tax Amount 2
AMTTAX3HC BCD*10.3 Func. Tax Amount 3
AMTTAX4HC BCD*10.3 Func. Tax Amount 4
AMTTAX5HC BCD*10.3 Func. Tax Amount 5
AMTBASE1TC BCD*10.3 Vend. Base Amount 1
AMTBASE2TC BCD*10.3 Vend. Base Amount 2
AMTBASE3TC BCD*10.3 Vend. Base Amount 3
AMTBASE4TC BCD*10.3 Vend. Base Amount 4
AMTBASE5TC BCD*10.3 Vend. Base Amount 5
AMTTAX1TC BCD*10.3 Vend. Tax Amount 1
AMTTAX2TC BCD*10.3 Vend. Tax Amount 2
AMTTAX3TC BCD*10.3 Vend. Tax Amount 3
AMTTAX4TC BCD*10.3 Vend. Tax Amount 4
AMTTAX5TC BCD*10.3 Vend. Tax Amount 5
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
IDPREPAY String*22 Prepay Invoice Number Mask: %-22C
DATEBUS Date Posting Date
ID1099CLAS String*6 1099/CPRS Code Mask: %-6N
AMT1099ORG BCD*10.3 1099/CPRS Original Amount
AMT1099REM BCD*10.3 1099/CPRS Remaining Amount
RATEDATE Date Rate Date
RATEOP Integer Rate Operator
YPLASTACT String*6 Last Activity Year/Period
IDBANK String*8 Bank Code Mask: %-8N
LONGSERIAL ??? Check Serial Number
POSTSEQNCE BCD*5.0 Posting Sequence No.
SWJOB Integer Job Related List:2 entries
0 = No
1 = Yes
SWRTG Integer Has Retainage List:2 entries
0 = No
1 = Yes
SWRTGOUT Integer Retainage Outstanding 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
RTGTERMS String*6 Retainage Terms Code Mask: %-6N
SWRTGRATE Integer Retainage Exchange Rate List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGAPPLYTO String*22 Original Doc. No. Mask: %-22C
VALUES Long Optional Fields
SRCEAPPL String*2 Source Application Mask: %-2A
SWPYSTTS Integer Payment Status List:3 entries
0 = Normal
1 = On Hold
2 = Forced
DATEPYSTTS Date Date Payment Status Changed
APVERSION String*3 A/P Version Created In
TYPEBTCH String*2 Batch Type Mask: %-2N
CNTOBLJ Long Number of OBLJ Details
CODECURNRC String*3 Tax Reporting Currency Code
RATERC BCD*8.7 Tax Reporting Exchange Rate
RATETYPERC String*2 Tax Reporting Rate Type
RATEDATERC Date Tax Reporting Rate Date
RATEOPRC Integer Tax Reporting Rate Operator
SWRATERC Integer Tax Reporting Rate Override List:2 entries
0 = No
1 = Yes
SWTXRTGRPT Integer Report Retainage Tax
CODETAXGRP String*12 Tax Group
TAXVERSION Long Tax State Version
SWTXBSECTL Integer Tax Base Calculate Method
SWTXCTLRC Integer Tax Reporting Calculate Method
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
TXBSERT1TC BCD*10.3 Tax Base 1
TXBSERT2TC BCD*10.3 Tax Base 2
TXBSERT3TC BCD*10.3 Tax Base 3
TXBSERT4TC BCD*10.3 Tax Base 4
TXBSERT5TC BCD*10.3 Tax Base 5
TXAMTRT1TC BCD*10.3 Tax Amount 1
TXAMTRT2TC BCD*10.3 Tax Amount 2
TXAMTRT3TC BCD*10.3 Tax Amount 3
TXAMTRT4TC BCD*10.3 Tax Amount 4
TXAMTRT5TC BCD*10.3 Tax Amount 5
DATEFRSTBK Date Earliest Backdated Activity Date
DATELSTRVL Date Last Revaluation Date
ORATE BCD*8.7 Orig. Exchange Rate
ORATETYPE String*2 Orig. Rate Type
ORATEDATE Date Orig. Rate Date
ORATEOP Integer Orig. Rate Operator
OSWRATE Integer Orig. Rate Override Flag List:2 entries
0 = No
1 = Yes
IDACCTSET String*6 Account Set Mask: %-6N
DATEPAID Date Date Paid
SWNONRCVBL Integer Misc. Payment Flag
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

This page was generated on 2023-Aug-31

© 2023 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).