AR_WC_ITEMS_RS

#	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	OPRID_APPROVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
6	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.
7	ORIGIN_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the source or method of entry for a pending item group.
8	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).
9	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
10	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
11	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
12	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
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURR_CD_AR_VW
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	TRN_BU	Character(5)	VARCHAR2(5) NOT NULL	Transfer Business Unit
16	TRN_ID	Character(15)	VARCHAR2(15) NOT NULL	Transfer Worksheet ID
17	SELECTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selected Flag N=Not Selected Y=Seleted
18	DRAFT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.
19	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.
20	WS_TOTAL_WO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Write Off
21	AR_WOAPPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved Write-Off D=Denied Write-Off I=Initial P=Pending Write-Off Approval