Table: Documents

Table: APOBL
View: AP0025
Record length: 1059
Flags: A R 

Keys: 7

Title  Flags  Fields

Vendor Number/Document Number  IDVEND, IDINVC
Paid/Order Number  D 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: 144

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*12  Check Number  Mask: %-12D
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  Long  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   

This page was generated on 2009-Nov-19

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