DR_EFT_AET

(SQL Table)
Index Back

Draft EFT AE State Record

# 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 ID_SEQ_NUM Number(5,0) INTEGER NOT NULL Identification Sequence number
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUARED_NONVW

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

Prompt Table: DR_EFT_TYPE_VW
Set Control Field: BUSINESS_UNIT

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 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
9 FILE_NAME_SHORT Character(30) VARCHAR2(30) NOT NULL File Name
10 DR_EFT_REVIEW_FLG Character(1) VARCHAR2(1) NOT NULL Review Option
A=All Drafts
E=Errors Only

Default Value: A

11 DR_EFT_PROC_FLG Character(1) VARCHAR2(1) NOT NULL Process Option
B=Both
D=Drafts
P=Payments

Default Value: B

12 LAST_AUTO_NBR Number(18,0) DECIMAL(18) NOT NULL Last Auto-Assigned Number
13 SETID Character(5) VARCHAR2(5) NOT NULL SetID
14 DUP_CHK Character(1) VARCHAR2(1) NOT NULL Duplicate Check