# Table: Posted Prepayments

Table: OEPPRE
View: OE0620
Record length: 321
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Apply To/Doc. No./PP. No. |  | APPLYTO, DOCNUMBER, PPNUMBER

## Fields: 31

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: 5 entries
0 | = | (None)
1 | = | Cash
2 | = | Check
3 | = | Credit Card
4 | = | Other
CCTYPE | String*12 | Credit Card Type | Mask: %-12N
CCNUMBER | Binary*32 | Credit Card Number |
CCNAME | String*60 | Credit Card Name |
CCAUTHCODE | String*20 | Authorization Code |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.