View: Posted Prepayments

RotoID: OE0620
Table: OEPPRE
Protocol: Flat
DLL:OEPPRE

Compositions: 3

RotoID Tables Title DLL

OE0520 OEORDHOEORDH1 Orders OEORDH
OE0420 OEINVH Invoices OEINVH
OE0692 OESHIH Shipments OESHIH

Keys: 1

Title Fields

Apply To/Doc. No./PP. No. APPLYTODOCNUMBERPPNUMBER

Fields: 26

Field Index Type Title Attributes Presentation

APPLYTO 1 Integer Apply To E A K R  List:3 entries
2 = Invoice No.
4 = Order No.
9 = Shipment No.
DOCNUMBER 2 String*22 Document Number E A K R 
PPNUMBER 3 Integer Prepayment Number E A K R 
REBATCHNUM 4 BCD*5.0 Receipt Batch Number E A 
BANKCODE 5 String*8 Bank Code E A  Mask: %-8N
BANKRECTYP 6 String*12 Receipt Type E A  Mask: %-12C
CHECKDATE 7 Date Check Date E A 
CHKFISCYR 8 String*4 Check Fiscal Year E A  Mask: %-4d
CHKFISCPER 9 Integer Check Fiscal Period E A 
CHECKNUM 10 String*24 Check Number E A 
PAYMENT 11 BCD*10.3 Payment in Customer Currency E A 
INVPAYDISC 12 BCD*10.3 Payment Discount E A 
BANKPAYMNT 13 BCD*10.3 Payment in Bank Currency E A 
PAHOMECURR 14 String*3 Payment Home Currency E A  Mask: %-3N
PARATETYPE 15 String*2 Payment Rate Type E A  Mask: %-2N
PASOURCURR 16 String*3 Payment Source Currency E A  Mask: %-3N
PARATEDATE 17 Date Payment Rate Date E A 
PARATE 18 BCD*8.7 Payment Rate E A 
PASPREAD 19 BCD*8.7 Payment Spread E A 
PADATEMTCH 20 Integer Payment Rate Date Matching E A 
PARATEREP 21 Integer Payment Rate Operator E A 
IDPPD 22 String*22 Prepayment ID E A 
PAYMTYPE 23 Integer Payment Type E A  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
TRANIDPRE 28 String*36 Pre-auth Transaction ID E A 
TRANIDCAP 29 String*36 Capture Transaction ID E A 
PAUTHAMT 30 BCD*10.3 Pre-auth amount E A