AR_MAINT_HDR_VW (SQL View)	Index Back
Maint WO Header View Maintenance write-off header data

AR_MAINT_HDR_VW

(SQL View)

Maint WO Header View

Maintenance write-off header data

SELECT A.WS_BU , A.WS_ID , A.CUST_ID , B.NAME1 , A.WS_TOTAL_WO , A.WS_TOTAL_REF , A.AR_WOAPPR_STATUS , A.REQ_WO_COMMENTS , A.REQ_RF_COMMENTS FROM PS_WS_CONTROL A , PS_WS_ID_CUST B WHERE A.WS_BU = B.WS_BU AND A.WS_ID = B.WS_ID AND A.CUST_ID = B.CUST_ID AND A.AR_WOAPPR_STATUS <> 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 WS_BU Character(5) VARCHAR2(5) NOT NULL Worksheet Business Unit

2 WS_ID Character(15) VARCHAR2(15) NOT NULL Worksheet ID

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

4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

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

8 REQ_WO_COMMENTS Long Character CLOB Requestor Write-off Comments

9 REQ_RF_COMMENTS Long Character CLOB Requestor Refund Comments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WS_BU	Character(5)	VARCHAR2(5) NOT NULL	Worksheet Business Unit
2	WS_ID	Character(15)	VARCHAR2(15) NOT NULL	Worksheet ID
3	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.
4	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
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	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
8	REQ_WO_COMMENTS	Long Character	CLOB	Requestor Write-off Comments
9	REQ_RF_COMMENTS	Long Character	CLOB	Requestor Refund Comments