Table: Posted Prepayments

Table: OEPPRE
View: OE0620
Record Length: 279

Flags: A R 

Keys: 1

Title Flags Fields

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

Fields: 30

Field Type Title Presentation

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