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 |