DR_ITEMSQM_VW (SQL View)	Index Back
Draft Item Temp Table Contains draft items with duplicates removed.

DR_ITEMSQM_VW

(SQL View)

Draft Item Temp Table

Contains draft items with duplicates removed.

SELECT DISTINCT F1.PROCESS_INSTANCE , F1.AUTONUM_SETID , F1.DRAFT_BU , F1.CUST_ID , F1.DRAFT_DUE_DT , F1.DRAFT_APPROVAL , F1.DRAFT_CURRENCY , F1.DRAFT_TYPE , F1.DRAFT_DOC FROM PS_DR_ITEMINT_TAO F1 WHERE F1.DRAFT_FORMAT='M'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 AUTONUM_SETID Character(5) VARCHAR2(5) NOT NULL Automatic Numbering Set ID

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

4 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: CUST_SRCH_VW
Set Control Field: BUSINESS_UNIT

5 DRAFT_DUE_DT Date(10) DATE Draft Due Date

6 DRAFT_APPROVAL Character(1) VARCHAR2(1) NOT NULL "Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""."
P=Preapproved
R=Approval Required

7 DRAFT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft.

8 DRAFT_TYPE Character(10) VARCHAR2(10) NOT NULL A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).

9 DRAFT_DOC Character(1) VARCHAR2(1) NOT NULL "A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. "
C=Create Document
N=Do Not Create Document

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AUTONUM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Automatic Numbering Set ID
3	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.
4	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: CUST_SRCH_VW Set Control Field: BUSINESS_UNIT
5	DRAFT_DUE_DT	Date(10)	DATE	Draft Due Date
6	DRAFT_APPROVAL	Character(1)	VARCHAR2(1) NOT NULL	"Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""." P=Preapproved R=Approval Required
7	DRAFT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft.
8	DRAFT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).
9	DRAFT_DOC	Character(1)	VARCHAR2(1) NOT NULL	"A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. " C=Create Document N=Do Not Create Document