|
SELECT DISTINCT A.WS_BU , A.WS_ID , A.OPRID , A.ASSN_OPRID , A.GROUP_TYPE , A.ORIGIN_ID , A.ENTRY_DT , A.ACCOUNTING_DT , A.POST_STATUS , A.POST_ACTION , A.BAL_STATUS , A.CURRENCY_CD , A.WS_REASON , B.CUST_ID , B.SUBCUST_QUAL1 , B.SUBCUST_QUAL2 , B.BUSINESS_UNIT , B.MICR_ID ,C.REF_QUALIFIER_CODE , C.REF_VALUE , C.REF_VALUE_TO , A.AR_SPECIALIST , A.DEDUCTION_STATUS , A.BROKER_ID , A.EXCLUDE_COLLECTION , A.EXCLUDE_DEDUCTIONS , A.EXCLUDE_DISPUTES , A.DST_ID_MAINT_CTL , A.ENTRY_TYPE , A.ENTRY_REASON FROM PS_WS_CONTROL A ,PS_WS_ID_CUST B , PS_WS_ID_ITEM C WHERE A.WS_BU= B.WS_BU AND A.WS_ID=B.WS_ID AND B.WS_BU=C.WS_BU AND B.WS_ID= C.WS_ID AND B.ID_SEQ_NUM= C.ID_SEQ_NUM AND A.POST_STATUS <>'C'
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 WS_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Worksheet Business Unit
Prompt Table:
SP_BUARWS_NONVW
|
| 2 |
WS_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Worksheet ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 4 |
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_VW
|
| 5 |
GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
|
| 6 |
ORIGIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the source or method of entry for a pending item group.
|
| 7 |
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).
|
| 8 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 9 |
WC_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
C=Complete
E=Errors
N=Not Posted
|
| 10 |
WC_POST_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled.
A=Do Not Post
G=Post Now To GL
L=Batch Standard
N=Batch Priority
P=Post Now
|
| 11 |
BAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced
O=Not Balanced
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURR_CD_AR_VW
|
| 13 |
WS_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
WS_REASON_TBL
|
| 14 |
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:
SP_IDCUST_NONVW
|
| 15 |
SUBCUST_QUAL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Prompt Table:
SUBCUST_Q1_TBL
|
| 16 |
SUBCUST_QUAL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Prompt Table:
SUBCUST_Q2_TBL
|
| 17 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUCSIT_NONVW
|
| 18 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
|
| 19 |
REF_QUALIFIER_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reference Qualifier Code
Prompt Table:
AR_FLD_REF_VW
|
| 20 |
REF_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference
Prompt Table:
%EDITTABLE
|
| 21 |
REF_VALUE_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Range for Reference Value
|
| 22 |
AR_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Accounts Recievable Specialist - person responsible for an action on an item.
Prompt Table:
AR_SPECIALIST
|
| 23 |
DEDUCTION_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Deduction Status
C=Closed
I=In Process
O=Created/Opened
W=On Worksheet
Prompt Table:
DEDUCTION_TBL
|
| 24 |
BROKER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Broker ID
Prompt Table:
CUST_BRK_A1S_VW
|
| 25 |
EXCLUDE_COLLECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Collection Items
Y/N Table Edit
|
| 26 |
EXCLUDE_DEDUCTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Deduction Items
Y/N Table Edit
|
| 27 |
EXCLUDE_DISPUTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Dispute Items
Y/N Table Edit
|
| 28 |
DST_ID_MAINT_CTL |
Character(10) |
VARCHAR2(10) NOT NULL |
10 character value used to identify the maintenance worksheet control distribution code.
Prompt Table:
DST_CODE_CTL_VW
|
| 29 |
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.
|
| 30 |
ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
|