View: Documents

RotoID: AP0025
Table: APOBL
Protocol: Flat
DLL:APOBL

Keys: 7

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

Fields: 145

Field Index Type Title Attributes Presentation
IDVEND 1 String*12 Vendor Number E A K R  Mask: %-12C
IDINVC 2 String*22 Document Number E A K R  Mask: %-22C
IDRMIT 3 String*18 Check Number E A  Mask: %-18D
IDORDERNBR 4 String*22 Order Number E A  Mask: %-22C
IDPONBR 5 String*22 PO Number E A  Mask: %-22C
DATEINVCDU 6 Date Due Date E A 
IDRMITTO 7 String*6 Remit-To Location E A  Mask: %-6N
IDTRXTYPE 8 Integer Transaction Type E A  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 9 Integer Document Type E A  List:6 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
10 = Prepayment
11 = Payment
DATEBTCH 10 Date Batch Date E A 
CNTBTCH 11 BCD*5.0 Batch Number E A 
CNTITEM 12 BCD*4.0 Entry Number E A 
IDVENDGRP 13 String*6 Group Code E A  Mask: %-6N
DESCINVC 14 String*60 Doc. Description E A 
DATEINVC 15 Date Doc. Date E A 
DATEASOF 16 Date Invoice as-of Date E A 
CODETERM 17 String*6 Terms E A  Mask: %-6N
DATEDISC 18 Date Discount Date E A 
CODECURN 19 String*3 Currency Code E A  Mask: %-3N
IDRATETYPE 20 String*2 Rate Type E A  Mask: %-2N
SWRATEOVRD 21 Integer Rate Overridden E A  List:2 entries
0 = No
1 = Yes
EXCHRATEHC 22 BCD*8.7 Exchange Rate E A 
AMTINVCHC 23 BCD*10.3 Func. Currency Invoice Amount E A 
AMTDUEHC 24 BCD*10.3 Func. Currency Amount Due E A 
AMTTXBLHC 25 BCD*10.3 Func. Currency Taxable Amount E A 
AMTNONTXHC 26 BCD*10.3 Func. Currency Non-Taxable Amt. E A 
AMTTAXHC 27 BCD*10.3 Func. Currency Tax Amount E A 
AMTDISCHC 28 BCD*10.3 Func. Currency Discount Amount E A 
AMTINVCTC 29 BCD*10.3 Vend. Currency Invoice Amount E A 
AMTDUETC 30 BCD*10.3 Vend. Currency Amount Due E A 
AMTTXBLTC 31 BCD*10.3 Vend. Currency Taxable Amount E A 
AMTNONTXTC 32 BCD*10.3 Vend. Currency Non-Taxable Amt. E A 
AMTTAXTC 33 BCD*10.3 Vend. Currency Tax Amount E A 
AMTDISCTC 34 BCD*10.3 Vend. Currency Discount Amount E A 
SWPAID 35 Integer Fully Paid E A  List:2 entries
0 = No
1 = Yes
DATELSTACT 36 Date Last Activity Date E A 
DATELSTSTM 37 Date Last Statement Date E A 
CNTTOTPAYM 38 BCD*3.0 Number of Scheduled Payments E A 
CNTLSTPAYM 39 BCD*3.0 Reserved - Last Payment Number Paid E 
CNTLSTPYST 40 BCD*3.0 Payment Number on Last Statement E A 
AMTREMIT 41 BCD*10.3 Reserved - Payment Amount E 
CNTLASTSCH 42 BCD*3.0 Last Applied Payment Seq. No. E A 
SWTAXOVRD 43 Integer Tax Amount Control E A  List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
CODETAX1 44 String*12 Tax Auth. 1 E A  Mask: %-12N
CODETAX2 45 String*12 Tax Auth. 2 E A  Mask: %-12N
CODETAX3 46 String*12 Tax Auth. 3 E A  Mask: %-12N
CODETAX4 47 String*12 Tax Auth. 4 E A  Mask: %-12N
CODETAX5 48 String*12 Tax Auth. 5 E A  Mask: %-12N
AMTBASE1HC 49 BCD*10.3 Func. Base Amount 1 E A 
AMTBASE2HC 50 BCD*10.3 Func. Base Amount 2 E A 
AMTBASE3HC 51 BCD*10.3 Func. Base Amount 3 E A 
AMTBASE4HC 52 BCD*10.3 Func. Base Amount 4 E A 
AMTBASE5HC 53 BCD*10.3 Func. Base Amount 5 E A 
AMTTAX1HC 54 BCD*10.3 Func. Tax Amount 1 E A 
AMTTAX2HC 55 BCD*10.3 Func. Tax Amount 2 E A 
AMTTAX3HC 56 BCD*10.3 Func. Tax Amount 3 E A 
AMTTAX4HC 57 BCD*10.3 Func. Tax Amount 4 E A 
AMTTAX5HC 58 BCD*10.3 Func. Tax Amount 5 E A 
AMTBASE1TC 59 BCD*10.3 Vend. Base Amount 1 E A 
AMTBASE2TC 60 BCD*10.3 Vend. Base Amount 2 E A 
AMTBASE3TC 61 BCD*10.3 Vend. Base Amount 3 E A 
AMTBASE4TC 62 BCD*10.3 Vend. Base Amount 4 E A 
AMTBASE5TC 63 BCD*10.3 Vend. Base Amount 5 E A 
AMTTAX1TC 64 BCD*10.3 Vend. Tax Amount 1 E A 
AMTTAX2TC 65 BCD*10.3 Vend. Tax Amount 2 E A 
AMTTAX3TC 66 BCD*10.3 Vend. Tax Amount 3 E A 
AMTTAX4TC 67 BCD*10.3 Vend. Tax Amount 4 E A 
AMTTAX5TC 68 BCD*10.3 Vend. Tax Amount 5 E A 
FISCYR 77 String*4 Fiscal Year E A  Mask: %04D
FISCPER 78 String*2 Fiscal Period E A  Mask: %02D
IDPREPAY 79 String*22 Prepay Invoice Number E A  Mask: %-22C
DATEBUS 80 Date Posting Date E A 
ID1099CLAS 81 String*6 1099/CPRS Code E A  Mask: %-6N
AMT1099ORG 82 BCD*10.3 1099/CPRS Original Amount E A 
AMT1099REM 83 BCD*10.3 1099/CPRS Remaining Amount E A 
RATEDATE 84 Date Rate Date E A 
RATEOP 85 Integer Rate Operator E A 
YPLASTACT 86 String*6 Last Activity Year/Period E A 
IDBANK 87 String*8 Bank Code E A  Mask: %-8N
LONGSERIAL 88 ??? Check Serial Number E A 
POSTSEQNCE 89 BCD*5.0 Posting Sequence No. E A 
SWJOB 90 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
SWRTG 91 Integer Has Retainage E A  List:2 entries
0 = No
1 = Yes
SWRTGOUT 92 Integer Retainage Outstanding E A  List:2 entries
0 = No
1 = Yes
RTGDATEDUE 93 Date Date Retainage Due E A 
RTGOAMTHC 94 BCD*10.3 Func. Curr. Orig. Rtng. Amt. E A 
RTGAMTHC 95 BCD*10.3 Func. Curr. Retainage Amount E A 
RTGOAMTTC 96 BCD*10.3 Vend. Curr. Orig. Rtng. Amt. E A 
RTGAMTTC 97 BCD*10.3 Vend. Curr. Retainage Amount E A 
RTGTERMS 98 String*6 Retainage Terms Code E A  Mask: %-6N
SWRTGRATE 99 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGAPPLYTO 100 String*22 Original Doc. No. E A  Mask: %-22C
VALUES 101 Long Optional Fields E A 
SRCEAPPL 102 String*2 Source Application E A  Mask: %-2A
SWPYSTTS 103 Integer Payment Status E A  List:3 entries
0 = Normal
1 = On Hold
2 = Forced
DATEPYSTTS 104 Date Date Payment Status Changed E A 
APVERSION 105 String*3 A/P Version Created In E A 
TYPEBTCH 106 String*2 Batch Type E A  Mask: %-2N
CNTOBLJ 107 Long Number of OBLJ Details E A 
CODECURNRC 108 String*3 Tax Reporting Currency Code E A 
RATERC 109 BCD*8.7 Tax Reporting Exchange Rate E A 
RATETYPERC 110 String*2 Tax Reporting Rate Type E A 
RATEDATERC 111 Date Tax Reporting Rate Date E A 
RATEOPRC 112 Integer Tax Reporting Rate Operator E A 
SWRATERC 113 Integer Tax Reporting Rate Override E A  List:2 entries
0 = No
1 = Yes
SWTXRTGRPT 114 Integer Report Retainage Tax E A 
CODETAXGRP 115 String*12 Tax Group E A 
TAXVERSION 116 Long Tax State Version E A 
SWTXBSECTL 117 Integer Tax Base Calculate Method E A 
SWTXCTLRC 118 Integer Tax Reporting Calculate Method E A 
TAXCLASS1 119 Integer Tax Class 1 E A 
TAXCLASS2 120 Integer Tax Class 2 E A 
TAXCLASS3 121 Integer Tax Class 3 E A 
TAXCLASS4 122 Integer Tax Class 4 E A 
TAXCLASS5 123 Integer Tax Class 5 E A 
SWTAXINCL1 124 Integer Tax Included 1 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL2 125 Integer Tax Included 2 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL3 126 Integer Tax Included 3 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL4 127 Integer Tax Included 4 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL5 128 Integer Tax Included 5 E A  List:2 entries
0 = No
1 = Yes
TXBSERT1TC 129 BCD*10.3 Tax Base 1 E A 
TXBSERT2TC 130 BCD*10.3 Tax Base 2 E A 
TXBSERT3TC 131 BCD*10.3 Tax Base 3 E A 
TXBSERT4TC 132 BCD*10.3 Tax Base 4 E A 
TXBSERT5TC 133 BCD*10.3 Tax Base 5 E A 
TXAMTRT1TC 134 BCD*10.3 Tax Amount 1 E A 
TXAMTRT2TC 135 BCD*10.3 Tax Amount 2 E A 
TXAMTRT3TC 136 BCD*10.3 Tax Amount 3 E A 
TXAMTRT4TC 137 BCD*10.3 Tax Amount 4 E A 
TXAMTRT5TC 138 BCD*10.3 Tax Amount 5 E A 
DATEFRSTBK 139 Date Earliest Backdated Activity Date E A 
DATELSTRVL 140 Date Last Revaluation Date E A 
ORATE 141 BCD*8.7 Orig. Exchange Rate E A 
ORATETYPE 142 String*2 Orig. Rate Type E A 
ORATEDATE 143 Date Orig. Rate Date E A 
ORATEOP 144 Integer Orig. Rate Operator E A 
OSWRATE 145 Integer Orig. Rate Override Flag E A  List:2 entries
0 = No
1 = Yes
IDACCTSET 146 String*6 Account Set E A  Mask: %-6N
DATEPAID 147 Date Date Paid E A 
SWNONRCVBL 148 Integer Misc. Payment Flag E A 
OAMTWHT1TC 149 BCD*10.3 Orig Est Tax Withheld Amount 1 E A 
OAMTWHT2TC 150 BCD*10.3 Orig Est Tax Withheld Amount 2 E A 
OAMTWHT3TC 151 BCD*10.3 Orig Est Tax Withheld Amount 3 E A 
OAMTWHT4TC 152 BCD*10.3 Orig Est Tax Withheld Amount 4 E A 
OAMTWHT5TC 153 BCD*10.3 Orig Est Tax Withheld Amount 5 E A 

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