DRAFT_CTL_SI_VW (SQL View)	Index Back
Draft Control - SetID Key

DRAFT_CTL_SI_VW

(SQL View)

Draft Control - SetID Key

SELECT P.SETID, DRAFT_BU, DRAFT_ID, DRAFT_BU, DRAFT_STATUS, CUST_ID, DRAFT_AMT, DRAFT_CNT, DRAFT_DUE_DT, DRAFT_DUE_DATE2, CREATE_DATE, PROCESS_INSTANCE, DRAFT_APPROVAL, DRAFT_CURRENCY, DRAFT_DOC, MICR_ID, ENTRY_USE_ID, ENTRY_TYPE, GROUP_ID, ITM_MULTIPLIER, CREATE_PEND_ITEMS, HOLD_SW, DISCOUNT_DRAFT, DRAFT_AMT_BASE, CURRENCY_CD FROM PS_DRAFT_CONTROL A, PS_SET_CNTRL_REC P WHERE P.SETCNTRLVALUE = A.DRAFT_BU AND P.RECNAME = 'CUSTOMER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

5 DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
A=Accepted
C=Complete
D=Dishonored
E=Void
I=Identified
L=Collateral
M=Discounted
N=No Action
P=Pending
R=Remitted
T=Endorsed

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

7 DRAFT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a draft payment. This field is maintained by the Draft Creation process.

8 DRAFT_CNT Number(5,0) INTEGER NOT NULL Draft Count

9 DRAFT_DUE_DT Date(10) DATE Draft Due Date

10 DRAFT_DUE_DATE2 Date(10) DATE Draft Due Date

11 CREATE_DATE Date(10) DATE Creation Date

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

13 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

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

15 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

16 MICR_ID Character(30) VARCHAR2(30) NOT NULL MICR ID

17 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.

18 ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.

19 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.

20 ITM_MULTIPLIER Signed Number(2,0) DECIMAL(1) NOT NULL Posting Item Multiplier

21 CREATE_PEND_ITEMS Character(1) VARCHAR2(1) NOT NULL Create Pending Items
A=Do Not Post
L=Batch Standard
N=Batch Priority

22 HOLD_SW Character(1) VARCHAR2(1) NOT NULL Hold Switch
N=No Hold
Y=On Hold
Y/N Table Edit

23 DISCOUNT_DRAFT Character(1) VARCHAR2(1) NOT NULL Discount Draft
Y/N Table Edit

24 DRAFT_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a draft payment in the business unit's base currency. This field is maintained by the Draft Creation process.

25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	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.
4	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.
5	DRAFT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Draft Status A=Accepted C=Complete D=Dishonored E=Void I=Identified L=Collateral M=Discounted N=No Action P=Pending R=Remitted T=Endorsed
6	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.
7	DRAFT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a draft payment. This field is maintained by the Draft Creation process.
8	DRAFT_CNT	Number(5,0)	INTEGER NOT NULL	Draft Count
9	DRAFT_DUE_DT	Date(10)	DATE	Draft Due Date
10	DRAFT_DUE_DATE2	Date(10)	DATE	Draft Due Date
11	CREATE_DATE	Date(10)	DATE	Creation Date
12	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
13	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
14	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.
15	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
16	MICR_ID	Character(30)	VARCHAR2(30) NOT NULL	MICR ID
17	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
18	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
19	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
20	ITM_MULTIPLIER	Signed Number(2,0)	DECIMAL(1) NOT NULL	Posting Item Multiplier
21	CREATE_PEND_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Create Pending Items A=Do Not Post L=Batch Standard N=Batch Priority
22	HOLD_SW	Character(1)	VARCHAR2(1) NOT NULL	Hold Switch N=No Hold Y=On Hold Y/N Table Edit
23	DISCOUNT_DRAFT	Character(1)	VARCHAR2(1) NOT NULL	Discount Draft Y/N Table Edit
24	DRAFT_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a draft payment in the business unit's base currency. This field is maintained by the Draft Creation process.
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code