Table: Document Sched. Payments

Table: APOBS
View: AP0026
Record Length: 293

Flags: A R 

Keys: 11

Title Flags Fields
Vendor/Doc. No./Pmt. No. IDVEND, IDINVC, CNTPAYM
Doc. No./Pmt. No. D M  IDINVC, CNTPAYM
Vendor/Order Number D M  IDVEND, IDORDRNBR, IDINVC, CNTPAYM
Vendor/PO Number D M  IDVEND, IDPONBR, IDINVC, CNTPAYM
Vendor/Due Date D M  IDVEND, DATEDUE, IDINVC, CNTPAYM
Vendor/Remaining Vend. Pmt. Amt. D M  IDVEND, AMTPYMRMTC, DATEDUE, IDINVC, CNTPAYM
Paid/Doc. No./Pmt. No. D M  SWPAID, IDINVC, CNTPAYM
Vendor/Invoice Date D M  IDVEND, DATEINVC, IDINVC, CNTPAYM
Paid/Prepayment No. D M  SWPAID, IDPREPAID
Paid/Vendor/Doc. No./Pmt. No. D M  SWPAID, IDVEND, IDINVC, CNTPAYM
Original Doc. No. D M  IDVEND, RTGAPPLYTO, IDINVC, CNTPAYM

Fields: 31

Field Type Title Presentation
IDVEND String*12 Vendor Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
CNTPAYM BCD*3.0 Payment Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
IDRMIT String*18 Check Number Mask: %-18D
DATEDUE Date Due Date
DATEDISC Date Discount Date
SWPAID Integer Fully Paid List:2 entries
0 = No
1 = Yes
AMTDUEHC BCD*10.3 Original Amount (Func.)
AMTDISCHC BCD*10.3 Original Discount (Func.)
AMTDCSRMHC BCD*10.3 Remaining Discount (Func.)
AMTPYMRMHC BCD*10.3 Remaining Amount (Func.)
AMTDUETC BCD*10.3 Original Amount
AMTDISCTC BCD*10.3 Original Discount
AMTDSCRMTC BCD*10.3 Remaining Discount
AMTPYMRMTC BCD*10.3 Remaining Amount
IDORDRNBR String*22 Order Number Mask: %-22C
IDPONBR String*22 PO Number Mask: %-22C
IDGRP String*6 Group Code Mask: %-6N
IDPREPAID String*22 Prepay Invoice Number Mask: %-22C
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
DATEINVC Date Document Date
DATEACTV Date Activation Date
DAYSTOPAY Integer Number of Days to Pay
SWJOB Integer Job Related List:2 entries
0 = No
1 = Yes
AMTPYMLMTC BCD*10.3 Payment Limit
RTGAPPLYTO String*22 Original Doc. No. Mask: %-22C

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