View: Documents

RotoID: AP0110

Protocol: Superview
DLL:APDOCS

Keys: 6

Title Fields
Document Number IDVEND, IDINVC
Order Number IDVEND, IDORDERNBR, IDINVC
PO Number IDVEND, IDPONBR, IDINVC
Due Date IDVEND, DATEINVCDU, IDINVC
Invoice Date IDVEND, DATEINVC, IDINVC
Remaining Vend. Pmt. Amt. IDVEND, AMTDUETC, DATEINVCDU, IDINVC

Fields: 111

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:7 entries
12 = Invoice - Summary Entered
13 = Invoice - Recurring Charge
22 = Debit Note - Summary Entered
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 Last Payment Number Paid E A 
CNTLSTPYST 40 BCD*3.0 Payment Number on Last Statement E A 
AMTREMIT 41 BCD*10.3 Payment Amount Applied E A 
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 = No
1 = Yes
RTGAPPLYTO 100 String*22 Original Doc. No. E A  Mask: %-22C
PNDPAYTOTH 101 BCD*10.3 Functional Pending Payment Amount E A 
PNDDSCTOTH 102 BCD*10.3 Functional Pending Discount Amount E A 
PNDADJTOTH 103 BCD*10.3 Functional Pending Adjustment Amount E A 
PENDNGBALH 104 BCD*10.3 Functional Pending Balance E A 
PNDPAYTOT 105 BCD*10.3 Pending Payment Amount E A 
PNDDSCTOT 106 BCD*10.3 Pending Discount Amount E A 
PNDADJTOT 107 BCD*10.3 Pending Adjustment Amount E A 
PENDNGBAL 108 BCD*10.3 Pending Balance E A 
IDVENDPEND 109 String*12 Vendor No. Used to Calculate Pending Amount E A  Mask: %-12C
SWSHOWPEND 110 Integer Show Pending Amounts Switch E A  List:2 entries
0 = No
1 = Yes
VALUES 111 Long Optional Fields E A 
SRCEAPPL 112 String*2 Source Application E A  Mask: %-2A
SWPYSTTS 113 Integer Payment Status E A  List:3 entries
0 = Normal
1 = On Hold
2 = Forced
DATEPYSTTS 114 Date Date Payment Status Changed E A 
APVERSION 115 String*3 A/P Version Created In E A 
TYPEBTCH 116 String*2 Batch Type E A  Mask: %-2N
CNTOBLJ 117 Long Number of OBLJ Details E A 
AMTPYMLMTC 118 BCD*10.3 Payment Limit E A 
SWSHOWPAID 119 Integer Obsolete E A  List:2 entries
0 = No
1 = Yes

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