POREQLN_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for REQ_LINE Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative 080408 SM F-AHAYT-B7QQ2 Added field APPR_REQ for line level reapprovals |
| # | 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 |
| 3 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Default Value: NEXT |
| 4 | LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 5 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
In process flag
Y/N Table Edit Default Value: N |
| 6 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 7 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
| 8 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 9 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: %EDIT_ITEM_ID |
| 10 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 11 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: %EDITTABLE5 |
| 12 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 13 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |
| 14 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_TBL |
| 15 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL |
Category ID
Prompt Table: ITM_CAT_VW |
| 16 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDIT_UOM |
| 17 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: MANUFACTURER |
| 18 | PRICE_REQ | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative |
| 19 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 20 | INSPECT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Required
N=No Y=Yes Y/N Table Edit Default Value: N |
| 21 | 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.
Default Value: PPO |
| 22 | SOURCE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AutoSource Status
A=Available C=Sourcing Complete E=Non-Price Error I=Sourcing In Process N=Non-Price Error P=Pricing Error Default Value: N |
| 23 | SOURCE_DATE | Date(10) | DATE NOT NULL |
Source Date
Default Value: %DATE |
| 24 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: REQ_HDR.CURRENCY_CD |
| 25 | PCT_UNIT_PRC_TOL | Number(6,2) | DECIMAL(5,2) NOT NULL | % Unit Price Tolerance |
| 26 | PCT_UNIT_PRC_TOL_L | Number(6,2) | DECIMAL(5,2) NOT NULL | % Unit Price Tolerance - Under |
| 27 | UNIT_PRC_TOL | Number(14,5) | DECIMAL(13,5) NOT NULL | Unit Price Tolerance |
| 28 | UNIT_PRC_TOL_L | Number(14,5) | DECIMAL(13,5) NOT NULL | Unit Price Tolerance - Under |
| 29 | INVENTORY_SRC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Source Flag
Y/N Table Edit Default Value: N |
| 30 | OVERRIDE_SUGG_VNDR | Character(1) | VARCHAR2(1) NOT NULL |
Override Suggested Vendor
Y/N Table Edit Default Value: Y |
| 31 | CONSOLIDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Consolidate with other Reqs
N=No Y=Yes Y/N Table Edit Default Value: N |
| 32 | ROUTING_ID | Character(10) | VARCHAR2(10) NOT NULL |
Inspection Routing ID
Prompt Table: ROUTING_HDR |
| 33 | RFQ_IND | Character(1) | VARCHAR2(1) NOT NULL |
RFQ Required
N=No Y=Yes Default Value: N |
| 34 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL |
Business Unit Base Currency
Default Value: REQ_HDR.CURRENCY_CD_BASE |
| 35 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 36 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 37 | QTY_REQ_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Requested Stand. UOM |
| 38 | PRICE_REQ_BSE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative |
| 39 | UNIT_PRC_TOL_BSE | Number(14,5) | DECIMAL(13,5) NOT NULL | Base Unit Price Tolerance |
| 40 | UNIT_PRC_TOL_BSE_L | Number(14,5) | DECIMAL(13,5) NOT NULL | Base Unit Price Tolerance |
| 41 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 42 | BUSINESS_UNIT_CP | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
%EDIT_BU_IN
|
| 43 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table:
CP_CONFIG_PO_VW
|
| 44 | CP_TEMPLATE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID Field |
| 45 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table: %EDIT_BU_IN |
| 46 | ZERO_PRICE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Zero Price Indicator
Y/N Table Edit Default Value: N |
| 47 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: VNDR_LOC_REQ_VW |
| 48 | PRICE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Price From Vendor SetID |
| 49 | PRICE_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Price Vendor ID |
| 50 | PRICE_LOC | Character(10) | VARCHAR2(10) NOT NULL | Price from Location |
| 51 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
Prompt Table: ITEM_MFG_ID_VW |
| 52 | CALC_PRICE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Price?
Y/N Table Edit Default Value: Y |
| 53 | REPLEN_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Replenish Code
01=Standard 02=Stockless |
| 54 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services Default Value: G |
| 55 | VAT_SVC_PERFRM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location |
| 56 | USER_LINE_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 57 | CUSTOM_C100_B1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 58 | CUSTOM_C100_B2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 59 | CUSTOM_C100_B3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 60 | CUSTOM_C100_B4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 61 | CUSTOM_DATE_B | Date(10) | DATE | Custom Date |
| 62 | CUSTOM_C1_B | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 63 | GPO_ID | Character(18) | VARCHAR2(18) NOT NULL | GPO ID |
| 64 | GPO_CNTRCT_NBR | Character(25) | VARCHAR2(25) NOT NULL | GPO Contract Number |
| 65 | CHANGE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Change Order Status
C=Changed U=Unchanged Default Value: U |
| 66 | CHNG_ORD_SEQ | Number(3,0) | SMALLINT NOT NULL | Change Order Sequence Number |
| 67 | CURR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Current Status
A=Approved C=Closed D=Denied H=Hold O=Open P=Pending X=Canceled Default Value: A |
| 68 | CC_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Use Procurement Card |
| 69 | AMT_ONLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Amount Only
N=No Y=Yes |
| 70 | USE_CNTRCT | Character(1) | VARCHAR2(1) NOT NULL |
Use Contract if Available
N=No Y=Yes Default Value: Y |
| 71 | APPR_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Field to indicate if approvals are required
Default Value: Y |
| 72 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 73 | PO_GROUP_ID | Character(18) | VARCHAR2(18) NOT NULL | GroupID |
| 74 | PRIMARY_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Primary Unit
N=No Y=Yes |
| 75 | UNIT_ALLOC_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Unit Allocation Qty |
| 76 | UNIT_ALLOC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unit Allocation Amt |
| 77 | DESCR254_MIXED2 | Character(254) | VARCHAR2(254) NOT NULL | Long Description |