| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 5 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
Default Value: NEXT
|
| 6 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 7 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 8 |
EIP_TRANS_SRC |
Character(30) |
VARCHAR2(30) NOT NULL |
08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)
|
| 9 |
BCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction status in the stage table
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Confirmed
Default Value: 0
|
| 10 |
BCT_DET_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
Default Value: 0
|
| 11 |
TRANS_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Program
|
| 12 |
TRANSACTION_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
|
| 13 |
ALL_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
All Business Units
N=Specific Business Unit
Y=All Business Units
|
| 14 |
VMI_OM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
OM Business Unit Related to VMI
|
| 15 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 16 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 17 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 18 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
MST_ITM_PRPT_VW
|
| 19 |
INV_LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lot ID
Prompt Table:
LOT_CONTROL_INV
|
| 20 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 21 |
STAGED_DATE |
Date(10) |
DATE |
Staged Date
Prompt Table:
STAGED_DT2IN_VW
|
| 22 |
CONTAINER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Container ID
Prompt Table:
CNTR_ID_INV
|
| 23 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 24 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
STOR_AREA_VW2
|
| 25 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
STOR_LEV1_VW2
|
| 26 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
STOR_LEV2_VW2
|
| 27 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
STOR_LEV3_VW2
|
| 28 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
STOR_LEV4_VW2
|
| 29 |
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:
INV_STCK_UOM_VW
|
| 30 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
Prompt Table:
UNITS_TBL
|
| 31 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 32 |
QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity
|
| 33 |
QTY_AVAIL |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Available
|
| 34 |
QTY_AVAIL_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Available Std
|
| 35 |
QTY_ALLOCATED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Allocated quantity
|
| 36 |
QTY_ALLOC_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity allocation
|
| 37 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 38 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 39 |
NON_OWN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes
|
| 40 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
|
| 41 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
N=No
Y=Yes
|
| 42 |
LAST_TRANSACT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Transaction
|
| 43 |
TRANSACTION_GROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
|
| 44 |
FIFO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
|
| 45 |
LOT_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Lot Control
N=N
Y=Y
|
| 46 |
LOT_CONTROL_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Lot Control Field Processing
|
| 47 |
SERIAL_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Serial Control
N=N
Y=Y
|
| 48 |
CONTAINER_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Container Control
|
| 49 |
STAGED_DATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Staged Date Control
N=Staged Date Tracking OFF
Y=Staged Date Tracking ON
|
| 50 |
ADJUST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV
|
| 51 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
|
| 52 |
NON_COST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Cost
|
| 53 |
COSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process
N=Transaction is Not Costed
P=Qualified for Purging
X=Transaction Won't be Costed
Y=Transaction is Costed
|
| 54 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 55 |
CFG_COST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Costing
|
| 56 |
AVERAGE_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Average Purchase Price
|
| 57 |
DFLT_ACTUAL_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Default Actual Cost
|
| 58 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
|
| 59 |
CONSIGNED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Consigned Flag
|
| 60 |
VMI_INVOICE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VMI Invoice Flag
I=Invoiced
Y=Available To Invoice
|
| 61 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 62 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 63 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 64 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 65 |
ALLOW_NEG_INV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Negative Inventory
|
| 66 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 67 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 68 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 69 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 70 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 71 |
TSE_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
TSE Field Name
|
| 72 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 73 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 74 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 75 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 76 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 77 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 78 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 79 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 80 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 81 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 82 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 83 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 84 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 85 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 86 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 87 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 88 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 89 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 90 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 91 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 92 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|