| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
|
| 2 |
FILTER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Filter Number
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
AR_SETID_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
AR Setid Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 5 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 6 |
AR_BU_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
AR Bus Unit Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 7 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUARDS_NONVW
|
| 8 |
AR_CUSTID_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
AR Customer ID Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 9 |
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.
Prompt Table:
CUST_SRCH_VW
|
| 10 |
AR_ASSNOPR_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Assigned to Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 11 |
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:
OPRID_VW2
|
| 12 |
AR_ACTCODE_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Action Code Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 13 |
ACTION_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Action Code
ALRT=Alert
CALL=Call the Customer
CRDT=Review Customer Credit Limit
DLTR=Dunning Letter
DNGD=Downgrade Credit Rating
FEBN=Follow up eBill Note
HOLD=Place Customer on Hold
OLTR=Send Other Letter
POD=Proof of Delivery
PRBK=Review Broken Promise Date
PRFO=Review Promise Date
REFR=Refer to Collection Agency
STMT=Send Statement of Account
WOFF=Write off Customer Balance
Prompt Table:
ACTION_TBL
|
| 14 |
AR_ACTSTAT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Action Status Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 15 |
ACTION_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Action Status
CAN=Cancelled
CMP=Completed
FUT=Future
NEW=New
PND=Pending
PRS=In Process
SCA=System Cancelled
SYS=System Completed
|
| 16 |
AR_OWNTYPE_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Owner Type Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 17 |
OWNER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Collection Owner Type
A=Credit Analyst
C=Collector
O=Other
R=AR Specialist
S=Sales Person
|
| 18 |
AR_SUPRVIS_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Supervisor Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 19 |
ROLEUSER_SUPR |
Character(30) |
VARCHAR2(30) NOT NULL |
Supervisor Role User
Prompt Table:
SUPR_OPRID_VW
|
| 20 |
AR_SPECIST_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Specialist Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 21 |
AR_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Accounts Recievable Specialist - person responsible for an action on an item.
Prompt Table:
AR_SPECIALIST
|
| 22 |
AR_COUNTRY_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Country Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 23 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 24 |
AR_STATE_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
State Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 25 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 26 |
AR_COND_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Condition ID Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 27 |
CONDITION_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Condition ID
ACLA=Approaching Credit Limit
ACLD=Approaching Credit Limit Exp
CCEX=Approaching CC expiration date
CCHD=Cancel Credit Hold
CFLU=Conversation Follow Up
CHLD=Credit Hold Code Exists
COLL=Collection
CPDB=Customer Promise Date Broken
CPDR=Customer Promise Date Review
DEDN=Deduction Item
DISP=Disputed Item
EBIL=eBill selection by user
ECLA=Exceeded Credit Limit
ECLD=Exceed CR Limit Expiration Dt
ETRC=Entry Type / Reason Code
KSTE=Key Statistics Exceeded
LACD=Large Amount Coming Due
ONLN=Online selection by user
RISK=Risk Score
WBDC=Welcome Back Dormant Customer
WCNC=Welcome New Customer
|
| 28 |
AR_PRIORTY_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Priority Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 29 |
PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 30 |
AR_BALANCE_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Balance Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 31 |
ANCHOR_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Principal amount of a given deal transaction denominated in the anchor currency.
|
| 32 |
AR_PASTDUE_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Past Due Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 33 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 34 |
AR_ITEMAMT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Item Amount Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 35 |
BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance - Base Currency
|
| 36 |
FROM_DUE_DT |
Date(10) |
DATE |
From Due Date
|
| 37 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 38 |
FROM_DT1 |
Date(10) |
DATE |
From Date
|
| 39 |
TO_DT1 |
Date(10) |
DATE |
To Date
|
| 40 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 41 |
TO_DUE_DT |
Date(10) |
DATE |
To Due Date
|
| 42 |
SHOW_ALL_ACTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Show All Actions
N=Highest Priority Per Customer
Y=Show All Actions
Default Value: Y
|
| 43 |
AR_CUSTGRP_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Customer Group Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 44 |
CUST_GRP_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Customer Group Type
ACCT=Accounting
ALOC=Allocation Group
BO=Backorder/Reservations
CDT=Canceled Debt Reporting
CLMB=Claimback Contract
COLL=Collection
DD=Direct Debit
DRFT=Draft
FCST=Forecasting
FRT=Freight
PBIL=Pay/Bill Management
PRC=Pricing
PRUL=Pricing Arbitration Plan
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources Of Supply
TAX=Tax
TRPT=Transportation
|
| 45 |
CUSTOMER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer Group
Prompt Table:
CUST_GROUP_TBL
|
| 46 |
AR_CUSTRGN_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Region Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 47 |
REGION_CD_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Region Code Type
ACCT=Accounting
BO=Backorder/Reservation
CDOM=Contract Domain
CNTR=Contracts
FRT=Freight
MBR=Team Member
PRC=Pricing
RPT=Reporting
RS=Resource Management
SPRS=Procurement
SSRC=Alternate Sources Of Supply
TRPT=Transportation
|
| 48 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
REGION_CD
|
| 49 |
AR_CSTTEAM_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Support Team Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 50 |
SUPPORT_TEAM_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Support Team Code
Prompt Table:
TEAM_CODE_TBL
|
| 51 |
AR_RSKSCOR_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Risk Score Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 52 |
RISK_SCORE |
Number(3,0) |
SMALLINT NOT NULL |
Risk Score used in Receivables Collections Workbench
|
| 53 |
AR_PROMAMT_SRCH_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Promise Amount Search Operator
EQ==
GT=>
GTE=>=
LIKE=Like
LT=<
LTE=<=
NE=Not =
|
| 54 |
PAY_PROMISE_AMT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Promise to Pay amount
|
| 55 |
FROM_PROMISE_DT |
Date(10) |
DATE |
From Promise Date
|
| 56 |
TO_PROMISE_DT |
Date(10) |
DATE |
To Promise Date
|