REQLOAD_MSG_WRK(SQL Table) |
Index Back |
---|---|
PO Requisition Load RequestDate Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LOADER_REQ_ID | Number(10,0) | DECIMAL(10) NOT NULL | Requisition Request ID |
2 | 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.
Prompt Table: PO_REQLOAD_S_VW |
3 | LOADER_BU | Character(5) | VARCHAR2(5) NOT NULL |
Requesting Loader Bus Unit
Prompt Table: PO_REQLOAD_R_VW |
4 | GROUP_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated. |
5 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table: REQUESTOR_VW |
6 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
7 | LOADER_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Loader Line Status
1=Active 2=In-process 3=Error 4=Processed 9=Canceled Default Value: 1 |
8 | PROCESS_DATE | Date(10) | DATE |
Process Date
Default Value: %date |
9 | 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. |
10 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: ITM_PURCH_VW |
11 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
12 | 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: UNITS_TBL |
13 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
14 | 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 |
15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
16 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_PO_VW |
17 | 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 |
18 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
19 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL |
Category ID
Prompt Table: ITM_CAT_VW |
20 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
21 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
22 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: GL_ACCT_BUGL_VW |
23 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
24 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_BUGL_VW |
25 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
26 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
27 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
28 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
29 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
30 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
31 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
32 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
33 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
34 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
35 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
36 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
37 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
38 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
39 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: SP_BU_PC_NONVW |
40 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
41 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
42 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
43 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
44 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
45 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
46 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
47 | CALC_PRICE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Price?
Y/N Table Edit Default Value: Y |
48 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
49 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table: PROFILE_INT_VW |
50 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
51 | CAP_NUM | Character(15) | VARCHAR2(15) NOT NULL |
Capital Acquisition Plan #
Prompt Table: CAP_VW |
52 | CAP_SEQUENCE | Number(3,0) | SMALLINT NOT NULL |
CAP Sequence
Prompt Table: CAP_DET_VW1 |
53 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
54 | FINANCIAL_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap Y=Capitalize |
55 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Cost Type
Prompt Table: COST_TYPE_TBL |
56 | ULTIMATE_USE_CD | Character(8) | VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table: SUT_USE_CD |
57 | REVISION | Character(4) | VARCHAR2(4) NOT NULL |
01/27/2000 RML Added "As of" label
Prompt Table: EN_REV_PO_VW |
58 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |