EB_PND_FIL_FL

(SQL Table)
Index Back

Pending Payment Filter Record

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4 COMPONENT Character(100) VARCHAR2(100) NOT NULL Component
5 FROM_DT Date(10) DATE From Date
6 TO_DT Date(10) DATE To Date
7 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

Prompt Table: %EDITTABLE

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_SSVIETYPE_VW

9 FROM_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL From Amount
10 TO_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL To Amount
11 BAL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code - Bal Amount

Prompt Table: AR_SSVICUR_VW

12 DISPUTE_FLG Character(1) VARCHAR2(1) NOT NULL Dispute Status
N=No
Y=Yes
13 COLLECTION_FLG Character(1) VARCHAR2(1) NOT NULL Collection Status
N=No
Y=Yes
14 DEDUCT_FLAG Character(1) VARCHAR2(1) NOT NULL Deduction Flag

Prompt Table: AR_YESNO_VW

15 PYMNT_METHOD_SS Character(3) VARCHAR2(3) NOT NULL Payment method for self-service.
CC=Credit Card
DD=Direct Debit
EC=Electronic Check
PL=PayPal
16 PAY_FROM_DT Date(10) DATE Pay From Date
17 PAY_THRU_DT Date(10) DATE Pay Through Date
18 CHANGED_VALUES Character(1) VARCHAR2(1) NOT NULL Changed Values