| # |
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 |
FILTER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Filter Number
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
AR_DEPID_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
ID Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 5 |
DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
|
| 6 |
AR_PAYMETH_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Pay Method Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 7 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
|
| 8 |
AR_PAYID_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment ID Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 9 |
PAYMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifies a customer payment. This is usually a check number but may be some other identifying number.
Prompt Table:
PAYMT_CWB_VW
|
| 10 |
AR_PAYSTAT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Status Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 11 |
PAYMENT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Status
A=Applied
B=Bounced
C=Complete
E=Identified - Express
I=Identified
J=Directly Journalled
R=Unposted Direct Journal
U=Unidentified
W=Worksheet
|
| 12 |
AR_PAYAMT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Amount Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 13 |
PAYMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a customer payment.
|
| 14 |
AR_BASEAMT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Base Amount Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 15 |
PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amt - Base Curr
|
| 16 |
AR_DRFTID_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Draft ID Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
Default Value: EQ
|
| 17 |
DRAFT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.
Prompt Table:
DRAFT_ALL_VW
|
| 18 |
AR_DRAFREF_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Draft Ref Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 19 |
DRAFT_DOC_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Draft Reference
Prompt Table:
DRAFT_CWB_VW
|
| 20 |
AR_DRAFTYP_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Draft Type Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 21 |
DRAFT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).
Prompt Table:
DR_TYPE_ENT_VW
|
| 22 |
AR_DRASTAT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Draft Status Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 23 |
DRAFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status
A=Accepted
C=Complete
D=Dishonored
E=Void
I=Identified
L=Collateral
M=Discounted
N=No Action
P=Pending
R=Remitted
T=Endorsed
|
| 24 |
AR_DDID_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Direct Debit ID Search Op
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
Default Value: EQ
|
| 25 |
DD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
Prompt Table:
DD_CONTROL_SRCH
|
| 26 |
AR_DDSTAT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
DD Status Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 27 |
DD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the stage of processing of a direct debit payment in receivables. This field is maintained by the Direct Debit generation process.
A=Accepted
C=Complete
E=Rejected
N=No Action
P=Pending
R=Remitted
Z=All
|
| 28 |
AR_ASSNOPR_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Assigned to Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 29 |
ASSN_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
Prompt Table:
PSOPRDEFN_VW
|
| 30 |
AR_BANKCD_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Bank Code Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 31 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_AR_BD_VW
|
| 32 |
AR_BANKACT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Bank Account Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 33 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
BANK_AR_D_VW
|
| 34 |
AR_BNKACTN_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Bank Account # Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 35 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table:
BANKACCT_CWB_VW
|
| 36 |
AR_BANKID_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Bank ID Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 37 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table:
BANK_ID_VW
|
| 38 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 39 |
ENTRY_DT |
Date(10) |
DATE |
Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
|
| 40 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 41 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 42 |
TO_DUE_DT |
Date(10) |
DATE |
To Due Date
|
| 43 |
TO_DT1 |
Date(10) |
DATE |
To Date
|
| 44 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
ITEM_CNTRCT_VW
|
| 45 |
CONTRACT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Contract Search Operator
EQ==
EX=Exists
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
Default Value: EQ
|
| 46 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
Prompt Table:
CA_DETAIL
|
| 47 |
CONTRACT_LINE_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Search operator
EQ==
GT=>
GTE=>=
LT=<
LTE=<=
NE=Not =
Default Value: EQ
|
| 48 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table:
CA_TYPE_TBL
|
| 49 |
CONTRACT_TYPE_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Search operator
EQ==
EX=Exists
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
Default Value: EQ
|
| 50 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPECIALST_VW
|
| 51 |
BILL_SPECIALIST_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Search operator
EQ==
EX=Exists
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
Default Value: EQ
|
| 52 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTH_EF_VW
|
| 53 |
BILL_AUTHORITY_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Search operator
EQ==
EX=Exists
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
Default Value: EQ
|
| 54 |
REF_AWD_NUMBER |
Character(25) |
VARCHAR2(25) NOT NULL |
Reference Award Number
Prompt Table:
AR_REFAWD_VW
|
| 55 |
REF_AWD_NUMBER_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Search operator
EQ==
EX=Exists
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
Default Value: EQ
|