View: Invoice Prepayments

RotoID: OE0278
Table: OEINPP
Protocol: Flat
DLL:OEINPP

Keys: 1

Title Fields

Invoice Uniquifier Key INVUNIQ

Fields: 50

Field Index Type Title Attributes Presentation

INVUNIQ 1 BCD*10.0 Invoice Uniquifier E A K R 
CUSTOMER 2 String*12 Customer Number E A  Mask: %-12C
CUSTDESC 3 String*60 Customer Name E A 
CUSTCURN 4 String*3 Customer Currency E A  Mask: %-3N
CRATE 5 BCD*8.7 Cust Rate E A 
CRATEDATE 6 Date Cust Rate Date E A 
CRATETYPE 7 String*2 Cust Rate Type E A  Mask: %-2N
CRATEOPER 8 Integer Oper. Cust. Curn. to Func. E A 
DOCTOTAL 9 BCD*10.3 Document Total E A 
DISCAVAIL 10 BCD*10.3 Discount Available E A 
AMOUNTDUE 11 BCD*10.3 Amount Due E A 
BATCHNUM 12 BCD*5.0 Receipt Batch Number E A 
BANKCODE 13 String*8 Bank Code E A  Mask: %-8N
RECPTYPE 14 String*12 Receipt Type E A  Mask: %-12C
CHECKNUM 15 String*24 Check/Receipt No. E A  Mask: %-24C
RECPDATE 16 Date Receipt Date E A 
RECPAMOUNT 17 BCD*10.3 Receipt Amount E A 
BANKCURN 18 String*3 Bank Currency E A  Mask: %-3N
RATETYPE 19 String*2 Rate Type E A  Mask: %-2N
BANKRATE 20 BCD*8.7 Bank Rate E A 
RATEDATE 21 Date Rate Date E A 
BATCHDESC 22 String*60 Batch Description E A C 
RECPDESC 23 String*60 Receipt Description E A C 
BANKSPREAD 24 BCD*8.7 Bank Rate Spread E A 
IDPPD 25 String*22 Prepayment ID E A 
DAYENDNUM 26 BCD*10.0 I/C Day End Trans. Number E A 
PAYMTYPE 27 Integer Payment Type E A  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
PAUTHCURR 35 String*3 Pre-auth Currency E A  Mask: %-3N
TRANIDPRE 36 String*36 Pre-auth Transaction ID E A 
TRANIDCAP 37 String*36 Capture Transaction ID E A 
TRANIDVOID 38 String*36 Void Transaction ID E A 
PAUTHAMT 39 BCD*10.3 Pre-auth Amount E A 
CHARGESTTS 40 Integer Credit Card Charge Status E A  List:6 entries
0 = None
1 = Charged
2 = Voided
3 = Pending
4 = Card Declined
5 = Card Error
YPPROCCODE 41 String*12 YP Process Code E A  Mask: %-12N
CPTPREAUTH 42 Boolean Capture Preauthorization E A  List:2 entries
0 = No
1 = Yes
ORDUNIQ 43 BCD*10.0 Order Uniquifier E A 
PROCESSNOW 44 Integer Process On Put E A  List:3 entries
1 = Quick Charge
11 = Quick Charge (CNA2/1)
12 = Quick Charge (CNA2/2)
TRANSID 45 String*36 Transaction ID E A 
XMLSTRING 46 String*20000 XML String E A 
RESPIND 47 String*1 Response Indicator E A 
RESPCD 48 String*6 Response Code E A 
RESPMSG 49 String*32 Response Message E A 
AUTHCODE 50 String*6 Authorization Code E A 
AVSRESULT 51 String*1 AVSResult E A 
CVVRESULT 52 String*1 CVVResult E A 
TRANSDATE 53 String*22 Transaction Date E A 
VANREF 54 String*16 VANReference E A 
LAST4 55 String*16 Last 4 E A 
PMTDESC 56 String*30 Payment Description E A 
PMTTYPEID 57 String*1 Payment Type ID E A