| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
NUM_OF_DAYS |
Number(5,0) |
INTEGER NOT NULL |
Payments in Last (Days)
Default Value: 365
|
| 3 |
PAYMENT_STATUS_SS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Applied
C=Yes
R=No
|
| 4 |
AR_SSREVPAY_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort payments by
D=Received
I=Payment ID
M=Pay Amount
S=Pay Status
Default Value: D
|
| 5 |
SORT_ORDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending
D=Descending
Default Value: D
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 7 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
AR_SS_RTYPE_VW
|
| 8 |
ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Prompt Table:
AR_SSTYPE_VW
|
| 9 |
ITEM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Status
C=Closed
O=Open
|
| 10 |
DISPUTE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dispute Status
N=No
Y=Yes
|
| 11 |
COLLECTION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Collection Status
N=No
Y=Yes
|
| 12 |
ITEM_SORT_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort items by
B=Amount
C=Collection Status
D=Dispute Status
I=Invoice
S=Invoice Status
T=Type
U=Due Date
Y=Currency
Default Value: I
|
| 13 |
ITEM_SORT_ORDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending
D=Descending
Default Value: A
|
| 14 |
NUM_OF_DAYS_I |
Number(5,0) |
INTEGER NOT NULL |
Items Due in Last (Days)
Default Value: 0
|
| 15 |
DEDUCT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction Flag
Prompt Table:
AR_YESNO_VW
|
| 16 |
PYMNT_HISTORY_SS |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment method for self-service (Payment History search)
CC=Credit Card
CHK=Check
DD=Direct Debit
EC=Electronic Check
PL=PayPal
|