View: Shipment Prepayments

RotoID: OE0710
Table: OESHPP
Protocol: Flat
DLL:OESHPP

Keys: 1

Title Fields

Shipment Uniquifier Key SHIUNIQ

Fields: 50

Field Index Type Title Attributes Presentation

SHIUNIQ 1 BCD*10.0 Shipment 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 
PAYMTYPE 22 Integer Payment Type E A  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
PAUTHCURR 28 String*3 Pre-auth Currency E A  Mask: %-3N
TRANIDPRE 29 String*36 Pre-auth Transaction ID E A 
TRANIDCAP 30 String*36 Capture Transaction ID E A 
TRANIDVOID 31 String*36 Void Transaction ID E A 
PAUTHAMT 32 BCD*10.3 Pre-auth Amount E A 
CHARGESTTS 33 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 34 String*12 YP Process Code E A  Mask: %-12N
BATCHDESC 70 String*60 Batch Description E A C 
RECPDESC 71 String*60 Receipt Description E A C 
BANKSPREAD 72 BCD*8.7 Bank Rate Spread E A 
IDPPD 73 String*22 Prepayment ID E A 
DAYENDNUM 74 BCD*10.0 I/C Day End Trans. Number E A 
CPTPREAUTH 77 Boolean Capture Preauthorization E A  List:2 entries
0 = No
1 = Yes
ORDUNIQ 78 BCD*10.0 Order Uniquifier E A 
PROCESSNOW 79 Integer Process On Put E A  List:3 entries
1 = Quick Charge
11 = Quick Charge (CNA2/1)
12 = Quick Charge (CNA2/2)
TRANSID 80 String*36 Transaction ID E A 
XMLSTRING 81 String*20000 XML String E A 
RESPIND 82 String*1 Response Indicator E A 
RESPCD 83 String*6 Response Code E A 
RESPMSG 84 String*32 Response Message E A 
AUTHCODE 85 String*6 Authorization Code E A 
AVSRESULT 86 String*1 AVSResult E A 
CVVRESULT 87 String*1 CVVResult E A 
TRANSDATE 88 String*22 Transaction Date E A 
VANREF 89 String*16 VANReference E A 
LAST4 90 String*16 Last 4 E A 
PMTDESC 91 String*30 Payment Description E A 
PMTTYPEID 92 String*1 Payment Type ID E A