PORFQHDR_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for RFQ_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 3 | RFQ_ID | Character(10) | VARCHAR2(10) NOT NULL |
RFQ ID
Default Value: NEXT |
| 4 | RFQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
RFQ Status
A=Approved C=Closed H=On Hold O=Open X=Canceled Default Value: OPR_DEF_TBL_PM.RFQ_STATUS |
| 5 | RFQ_REF | Character(30) | VARCHAR2(30) NOT NULL | RFQ Reference |
| 6 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Origin
Default Value: OPR_DEF_TBL_PM.ORIGIN Prompt Table: ORIGIN_PO |
| 7 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_ACTIVE_VW |
| 8 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Default Value: BUS_UNIT_OPT_PM.PYMNT_TERMS_CD Prompt Table: PYMT_TR_EFF_VW |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 10 | 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.
Default Value: BUS_UNIT_TBL_PM.RT_TYPE Prompt Table: RT_TYPE_TBL |
| 11 | RATE_DATE | Date(10) | DATE | Exchange Rate Date |
| 12 | REQUEST_DATE | Date(10) | DATE |
Requested
Default Value: %date |
| 13 | DTTM_OPENED | DateTime(26) | TIMESTAMP NOT NULL |
Date Time RFQ is Opened
Default Value: %date |
| 14 | DTTM_CLOSED | DateTime(26) | TIMESTAMP | Date Time RFQ is Closed |
| 15 | ADVERTISED_DT | Date(10) | DATE | RFQ Advertised Date |
| 16 | OPRID_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes |
| 17 | OPRID_APPROVED_BY | Character(30) | VARCHAR2(30) NOT NULL | Approved By |
| 18 | ENTERED_DT | Date(10) | DATE | Entered on |
| 19 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 20 | BILL_LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Billing Location
Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION Prompt Table: LOCATION_TBL |
| 21 | OPRID_MODIFIED_BY | Character(30) | VARCHAR2(30) NOT NULL | Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase. |
| 22 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 23 | USER_HDR_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 24 | CUSTOM_C100_A1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 25 | CUSTOM_C100_A2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 26 | CUSTOM_C100_A3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 27 | CUSTOM_C100_A4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 28 | CUSTOM_DATE_A | Date(10) | DATE | Custom Date |
| 29 | CUSTOM_C1_A | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 30 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |