| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
ADJ_DIST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Adjusted Flag
|
| 5 |
ADJ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Adjustment Sequence
|
| 6 |
ADJ_WRK_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Adjustment Work table sequence
|
| 7 |
AE_CALLER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Application Engine Caller Prog
|
| 8 |
AE_PROGRAM |
Character(10) |
VARCHAR2(10) NOT NULL |
Application
|
| 9 |
ALL_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
All Business Units
N=Specific Business Unit
Y=All Business Units
|
| 10 |
ALL_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
All PO Flag
|
| 11 |
ALL_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
All Source Flag
|
| 12 |
BCKORD_ORG_SCHED |
Number(3,0) |
SMALLINT NOT NULL |
Original schedule number
|
| 13 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 14 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
|
| 15 |
CATEGORY_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Category Type
PSF=User Def
UNS=UN/SPSC
|
| 16 |
CHARTFIELD_PR1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Chartfield Priority 1
|
| 17 |
CHARTFIELD_PR2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Chartfield Priority 2
|
| 18 |
CHNG_CHAR_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
New Field Value
|
| 19 |
CHNG_DATE_VALUE |
Date(10) |
DATE |
New Date Value
|
| 20 |
CHNG_DTTM_VALUE |
DateTime(26) |
TIMESTAMP |
Change Date/Time Value
|
| 21 |
CHNG_NBR_VALUE |
Signed Number(30,5) |
DECIMAL(28,5) NOT NULL |
New Numeric Value
|
| 22 |
CHNG_TIME_VALUE |
Time(15) |
TIMESTAMP |
Change Time Value
|
| 23 |
CHNG_DTTM |
DateTime(26) |
TIMESTAMP |
Change Request Date/Time
|
| 24 |
CHNG_ORD_BATCH |
Number(3,0) |
SMALLINT NOT NULL |
Change Order Number
|
| 25 |
CHNG_ORD_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Change Order Sequence Number
|
| 26 |
CHNG_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor
|
| 27 |
DOC_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
ID
|
| 28 |
DOC_LINE |
Number(5,0) |
INTEGER NOT NULL |
Document Line Number
|
| 29 |
DOC_SCHED_NBR |
Number(5,0) |
INTEGER NOT NULL |
Document Schedule Number
|
| 30 |
CF_INH_OBJ |
Character(254) |
VARCHAR2(254) NOT NULL |
State Record field used to hold the concatenated Charfield Inheritance Setid/Group object.
|
| 31 |
CF_INH_OBJ1 |
Character(254) |
VARCHAR2(254) NOT NULL |
State Record field used to hold the concatenated Charfield Inheritance Setid/Group object.
|
| 32 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 33 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 34 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 35 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 36 |
DISTRIB_MTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute by
A=Amount
Q=Quantity
|
| 37 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 38 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 39 |
MAX_ADJ_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Adjustment Sequence
|
| 40 |
MESSAGE_TEXT_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Text
|
| 41 |
MISC_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
|
| 42 |
MISC_CHARGE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 43 |
MULTICURRENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Multi-Currency
|
| 44 |
OVR_BUYER_STS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Dflt Buyer's PO Sts
|
| 45 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 46 |
PO_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
PO Distribution Line Number
|
| 47 |
PO_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Purchase Order Line Number
|
| 48 |
PO_SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
PO Schedule Number
|
| 49 |
PO_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
|
| 50 |
PO_STG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Uniqye key to the PO Staging table
|
| 51 |
PO_STG_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition
|
| 52 |
PRICE_ADJUST_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Price Adjustment Sequence
|
| 53 |
PROCESSED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process
|
| 54 |
PRODUCT_FAMILY |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Family
|
| 55 |
QTY_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Purchase Order Quantity
|
| 56 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 57 |
RECNAME_UPDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Record to Update
|
| 58 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
|
| 59 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 60 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
|
| 61 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 62 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 63 |
SETID_APORT |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 64 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 65 |
USE_CURR_UR |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Current UOM Conv Rate
|
| 66 |
VAT_DFLT_WRK |
Character(2) |
VARCHAR2(2) NOT NULL |
VAT Defaulting Work
|
| 67 |
VAT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
VAT SetID
|
| 68 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 69 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 70 |
RUN_REQ_BUDGET |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Requisition Budget Check
|
| 71 |
RUN_PO_BUDGET |
Character(1) |
VARCHAR2(1) NOT NULL |
Run PO Budget Check
|
| 72 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|