| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 3 |
APPLICATION_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Application ID
AP=Accounts Payable
AR=Accounts Receivable
EX=Expenses
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table:
SP_BUIN_NONVW
|
| 6 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BU_OM_NONVW
|
| 7 |
CALLED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Called Flag
Default Value: Y
|
| 8 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
CARRIER_ID_VW
|
| 9 |
CFG_KIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configured Kit
|
| 10 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
|
| 11 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 12 |
DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
|
| 13 |
FLAG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag1
|
| 14 |
FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag2
|
| 15 |
FROM_SCH_ARRV_DATE |
Date(10) |
DATE |
From Scheduled Arrival Date
|
| 16 |
FROM_SCH_SHIP_DATE |
Date(10) |
DATE |
From Scheduled Ship Date
|
| 17 |
FRT_ROLLUP_IND_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates to batch run how the freight will be rolled up.
1=Delivery Freight
2=Rollup Packages/Containers
3=Default from Delivery
Default Value: 1
|
| 18 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 19 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 20 |
LASTUPDDTTM |
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.
|
| 21 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 22 |
OM_SCH_NO_DMD_ROWS |
Character(1) |
VARCHAR2(1) NOT NULL |
No Demand Rows
Default Value: N
|
| 23 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 24 |
OPTIONAL_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Ship Without
|
| 25 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 26 |
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
Prompt Table:
OM_DELFR_ORD_VW
|
| 27 |
ORDER_NO_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
To Order No
Prompt Table:
OM_DELFR_ORD_VW
|
| 28 |
PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 29 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All
S=Only purge items with at least
|
| 30 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 31 |
PRODUCT_KIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Kit
|
| 32 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 33 |
QTY_PER |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Quantity
|
| 34 |
QTY_REQUESTED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested
|
| 35 |
QTY_REQUESTED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested Base
|
| 36 |
RECNAME_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 1 Name
|
| 37 |
RECNAME_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Header Record
|
| 38 |
RECNAME_LINE |
Character(15) |
VARCHAR2(15) NOT NULL |
Line Record
|
| 39 |
RECNAME_SCHEDULE |
Character(15) |
VARCHAR2(15) NOT NULL |
Schedule Record
|
| 40 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 41 |
DEL_VALIDATE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Delivery validation option
10=Validate Only
20=Validate/Assign to New
30=Validate/Auto Assign Open
40=Validate/Auto Assign All
50=Reassign/Consolidate
60=Do Not Validate
Default Value: 30
|
| 42 |
FRT_TYPE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Type Code
Prompt Table:
IN_FRT_DFLT
|
| 43 |
RESEND_FRT_RQST |
Character(1) |
VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
Y/N Table Edit
Default Value: N
|
| 44 |
RESEND_FRT_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
Y/N Table Edit
Default Value: N
|
| 45 |
RUN_FREIGHT |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Freight
Y/N Table Edit
Default Value: N
|
| 46 |
DELIV_UNIT_VOL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Delivery Unit Volume
|
| 47 |
DELIV_UNIT_WT |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Delivery Unit Weight
|
| 48 |
DELIV_UOM_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Delivery Volume UOM
|
| 49 |
DELIV_UOM_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Delivery Weight UOM
|
| 50 |
DELIV_UOM_SHIP_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship UOM for volume conversion
|
| 51 |
DELIV_UOM_SHIP_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship UOM for weight conversion
|
| 52 |
DELIV_UNIT_VOL_CNV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Unit volume conversion rate
|
| 53 |
DELIV_UNIT_WT_CNV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Unit weight conversion rate
|
| 54 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 55 |
SCHED_SHIP_DTTM |
DateTime(26) |
TIMESTAMP |
Schedule Ship Datetime
|
| 56 |
SHIP_ID_EST |
Character(10) |
VARCHAR2(10) NOT NULL |
Estimated Ship ID
|
| 57 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
CUST_SHP_A1_VW
|
| 58 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD_VW
|
| 59 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 60 |
SOURCE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Source Code
Prompt Table:
OMH_SRC_PR_VW
|
| 61 |
SQL_TABLES |
Character(254) |
VARCHAR2(254) NOT NULL |
SQL Tables
|
| 62 |
SQL_TEXT |
Character(254) |
VARCHAR2(254) NOT NULL |
SQL Text
|
| 63 |
SQL_WHERE_001 |
Character(254) |
VARCHAR2(254) NOT NULL |
|
| 64 |
SQL_WHERE_002 |
Character(254) |
VARCHAR2(254) NOT NULL |
|
| 65 |
SQL_SELECT_001 |
Character(254) |
VARCHAR2(254) NOT NULL |
|
| 66 |
SQL_SELECT_002 |
Character(254) |
VARCHAR2(254) NOT NULL |
|
| 67 |
TO_SCH_ARRV_DATE |
Date(10) |
DATE |
Prompt for schedule arrival date
|
| 68 |
TO_SCH_SHIP_DATE |
Date(10) |
DATE |
To Scheduled Ship Date
|
| 69 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 70 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|