REQ_INQ_VW(SQL View) |
Index Back |
|---|---|
Requisition Header ViewRequisition Header View |
| SELECT A.BUSINESS_UNIT , A.REQ_ID , A.REQ_STATUS , A.HOLD_STATUS , A.REQ_DT , A.ORIGIN , A.REQUESTOR_ID , A.OPRID_ENTERED_BY , A.OPRID_MODIFIED_BY , A.OPRID_APPROVED_BY , A.ENTERED_DT , A.APPROVAL_DT , A.APPL_JRNL_ID_ENC , A.POST_DOC , A.BUDGET_HDR_STATUS , A.DST_CNTRL_ID , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.RT_TYPE , A.RATE_DIV , A.RATE_MULT , A.ACTIVITY_DATE , A.LAST_DTTM_UPDATE , B.DESCR254_MIXED , B.SYSTEM_SOURCE , B.ITM_SETID , B.INV_ITEM_ID , C.DUE_DT , C.SHIP_TO_CUST_ID , D.BUSINESS_UNIT_REQ , D.QTY_OPEN , D.QTY_REQ , D.AMT_OPEN , D.MERCHANDISE_AMT FROM PS_REQ_HDR A , PS_REQ_LINE B , PS_REQ_LINE_SHIP C , PS_REQ_LN_DISTRIB D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.REQ_ID = C.REQ_ID AND A.REQ_ID = D.REQ_ID AND B.LINE_NBR = C.LINE_NBR AND B.LINE_NBR = D.LINE_NBR AND C.SCHED_NBR = D.SCHED_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | REQ_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Req status
A=Approved C=Complete D=Denied I=Initial LA=Line Approved O=Open P=Pending Approval V=Preview X=Canceled |
| 4 | HOLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Hold From Further Processing
Y/N Table Edit |
| 5 | REQ_DT | Date(10) | DATE NOT NULL | Requisition Date |
| 6 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL |
Origin
Prompt Table: ORIGIN_PO |
| 7 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table: REQUESTOR_TBL |
| 8 | 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 |
| 9 | 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. |
| 10 | OPRID_APPROVED_BY | Character(30) | VARCHAR2(30) NOT NULL | Approved By |
| 11 | ENTERED_DT | Date(10) | DATE | Entered on |
| 12 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 13 | APPL_JRNL_ID_ENC | Character(10) | VARCHAR2(10) NOT NULL | Encumbrance |
| 14 | POST_DOC | Character(1) | VARCHAR2(1) NOT NULL | Post Document |
| 15 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid |
| 16 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Accounting Template |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 18 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 19 | 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. |
| 20 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 21 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 22 | ACTIVITY_DATE | Date(10) | DATE | Last Activity |
| 23 | 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. |
| 24 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 25 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen. |
| 26 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 27 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 28 | 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. |
| 29 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 30 | BUSINESS_UNIT_REQ | Character(5) | VARCHAR2(5) NOT NULL | Requesting Business Unit |
| 31 | QTY_OPEN | Number(16,4) | DECIMAL(15,4) NOT NULL | Open Quantity |
| 32 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
| 33 | AMT_OPEN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Open Amount |
| 34 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |