ARMTITLE_FL_VW (SQL View)	Index Back
Maintenance Writeoff Title Maintenance Writeoff Title

ARMTITLE_FL_VW

(SQL View)

Maintenance Writeoff Title

SELECT DISTINCT M.WS_BU , M.WS_ID , M.GROUP_SEQ_NUM , M.GROUP_TYPE , M.WS_TOTAL_WO , M.WS_TOTAL_ref , M.CURRENCY_CD , M.HDR_DETAIL5 FROM PS_ARMTWOHD_FL_VW M

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 WS_BU Character(5) VARCHAR2(5) NOT NULL Worksheet Business Unit
Default Value: OPR_DEF_TBL_AR.GROUP_BU
Prompt Table: SP_BUARWS_NONVW

2 WS_ID Character(15) VARCHAR2(15) NOT NULL Worksheet ID
Default Value: NEXT

3 GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.

4 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.

5 WS_TOTAL_WO Signed Number(28,3) DECIMAL(26,3) NOT NULL Write Off

6 WS_TOTAL_REF Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Worksheet Refunds

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURR_CD_AR_VW

8 HDR_DETAIL5 Character(50) VARCHAR2(50) NOT NULL Header Detail 5

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WS_BU	Character(5)	VARCHAR2(5) NOT NULL	Worksheet Business Unit Default Value: OPR_DEF_TBL_AR.GROUP_BU Prompt Table: SP_BUARWS_NONVW
2	WS_ID	Character(15)	VARCHAR2(15) NOT NULL	Worksheet ID Default Value: NEXT
3	GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
4	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.
5	WS_TOTAL_WO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Write Off
6	WS_TOTAL_REF	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Worksheet Refunds
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURR_CD_AR_VW
8	HDR_DETAIL5	Character(50)	VARCHAR2(50) NOT NULL	Header Detail 5