DR_REQUEST_TAO

(SQL Table)
Index Back

Draft Request Temp Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ID_SEQ_NUM Number(5,0) INTEGER NOT NULL Identification Sequence number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 CUSTOMER_OPTNS Character(1) VARCHAR2(1) NOT NULL Customer Criteria
C=Customer Items
N=None
P=Corporate Items
R=Remit From Items
5 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
6 FROM_DT Date(10) DATE From Date
7 DRAFT_MAX_DT Date(10) DATE To Date
8 ITEM_FROM_DT Date(10) DATE From Date
9 ITEM_TO_DT Date(10) DATE To Date
10 DRAFT_TYPE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
11 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).
12 PREAPPROVED_ONLY Character(1) VARCHAR2(1) NOT NULL Pre-approved Only

Y/N Table Edit

13 DRAFT_DUE_DT_OPT Character(1) VARCHAR2(1) NOT NULL Due Date Option
D=Default
S=Specified
14 DRAFT_DUE_DT Date(10) DATE Draft Due Date
15 DRAFT_NUM_OPTION Character(1) VARCHAR2(1) NOT NULL Auto-number Draft Ref

Y/N Table Edit

Default Value: N

16 AUTONUM_SETID Character(5) VARCHAR2(5) NOT NULL Automatic Numbering Set ID
17 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.
18 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.
19 PROCESS_COMPLETE Character(1) VARCHAR2(1) NOT NULL Process Complete

Default Value: N