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: 2 entries
2=Invoice No.
4=Order 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     
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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.