DR_CREATE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	LAST_AUTO_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Last Auto-Assigned Number
5	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.
6	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.
7	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.
8	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
9	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
10	ID_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Identification Sequence number
11	DUP_CHK	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Check Y/N Table Edit
12	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.
13	GROUP_ID_SEQ_NUM	Number(15,0)	DECIMAL(15) NOT NULL	Group ID
14	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
15	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
16	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.
17	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
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	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
20	AE_CNV_IN_FLD_NM	Character(18)	VARCHAR2(18) NOT NULL	AE input convert field
21	AE_CNV_OUT_FLD_NM	Character(18)	VARCHAR2(18) NOT NULL	AE output converion field
22	AE_CNV_JUSTIFY	Character(1)	VARCHAR2(1) NOT NULL	AE Convert Justify Indicator
23	AE_STRIP_ZERO	Character(1)	VARCHAR2(1) NOT NULL	AE Strip Zeros
24	ACTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Broadcast D=log Deletedsequence number E=Check doc seq enable option G=Generate sequence number R=Reset for 1099C Submission X=Deleted from 1099C Prep Table
25	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
26	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
27	FIELDNAME_BU_GL	Character(18)	VARCHAR2(18) NOT NULL	Business Unit GL Field Name
28	FIELDNAME_ACCTDATE	Character(18)	VARCHAR2(18) NOT NULL	Accounting Date field name
29	WHERE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Where Option B=Both N=None P=Process Instance V=By Value
30	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
31	DOC_SEQ	Character(1)	VARCHAR2(1) NOT NULL	Enable Document Sequencing
32	RETURN_CD	Character(1)	VARCHAR2(1) NOT NULL	Return Code 0=Return OK 1=Return error
33	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
34	DRAFT_CNT	Number(5,0)	INTEGER NOT NULL	Draft Count
35	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).
36	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
37	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option A=Due After Holiday B=Due Before Holiday N=Not Applicable
38	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
39	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month
40	HOLIDAY_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	This is used to identify what holiday calendar to use. This is the access field for all financials groups.
41	STTLMNT_DT_EST	Date(10)	DATE	Date in which a deal transaction is estimated to be settled with a counterparty.
42	PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
43	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