AR_DRAFT_HDR_VW (SQL View)	Index Back
Draft WO Header View Draft write-off header data

AR_DRAFT_HDR_VW

(SQL View)

Draft WO Header View

Draft write-off header data

SELECT A.DRAFT_BU , A.DRAFT_ID , A.CUST_ID , B.NAME1 , A.WO_ITEM_AMT , A.AR_WOAPPR_STATUS , A.REQ_WO_COMMENTS FROM PS_DRAFT_CONTROL A , PS_DRAFT_ID_CUST B WHERE A.DRAFT_BU = B.DRAFT_BU AND A.DRAFT_ID = B.DRAFT_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 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.

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

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 WO_ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Write Off Item

6 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

7 REQ_WO_COMMENTS Long Character CLOB Requestor Write-off Comments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	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.
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	WO_ITEM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Write Off Item
6	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
7	REQ_WO_COMMENTS	Long Character	CLOB	Requestor Write-off Comments