Table: Invoice Prepayments

Table: OEINPP
View: OE0278
Record Length: 375

Flags: A R 

Keys: 1

Title Flags Fields
Invoice Uniquifier Key INVUNIQ

Fields: 33

Field Type Title Presentation
INVUNIQ BCD*10.0 Invoice Uniquifier
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CUSTOMER String*12 Customer Number Mask: %-12C
CUSTDESC String*60 Customer Name
CUSTCURN String*3 Customer Currency Mask: %-3N
CRATE BCD*8.7 Cust Rate
CRATEDATE Date Cust Rate Date
CRATETYPE String*2 Cust Rate Type Mask: %-2N
CRATEOPER Integer Oper. Cust. Curn. to Func.
DOCTOTAL BCD*10.3 Document Total
DISCAVAIL BCD*10.3 Discount Available
AMOUNTDUE BCD*10.3 Amount Due
BATCHNUM BCD*5.0 Receipt Batch Number
BANKCODE String*8 Bank Code Mask: %-8N
RECPTYPE String*12 Receipt Type Mask: %-12C
CHECKNUM String*24 Check/Receipt No. Mask: %-24C
RECPDATE Date Receipt Date
RECPAMOUNT BCD*10.3 Receipt Amount
BANKCURN String*3 Bank Currency Mask: %-3N
RATETYPE String*2 Rate Type Mask: %-2N
BANKRATE BCD*8.7 Bank Rate
RATEDATE Date Rate Date
PAYMTYPE Integer Payment Type List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
PAUTHCURR String*3 Pre-auth Currency Mask: %-3N
TRANIDPRE String*36 Pre-auth Transaction ID
TRANIDCAP String*36 Capture Transaction ID
TRANIDVOID String*36 Void Transaction ID
PAUTHAMT BCD*10.3 Pre-auth Amount
CHARGESTTS Integer Credit Card Charge Status List:6 entries
0 = None
1 = Charged
2 = Voided
3 = Pending
4 = Card Declined
5 = Card Error
YPPROCCODE String*12 YP Process Code Mask: %-12N

This page was generated on 2021-Nov-24

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