| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 4 |
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
|
| 5 |
PO_STG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Uniqye key to the PO Staging table
|
| 6 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 7 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 8 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 9 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 10 |
SHIPTO_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
ShipTo SetID
|
| 11 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 12 |
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.
|
| 13 |
PRICE_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Price from Location
|
| 14 |
PRICE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Price From Vendor SetID
|
| 15 |
PRICE_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Price Vendor ID
|
| 16 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 17 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 18 |
QTY_REQ |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Requisition Quantity
|
| 19 |
QTY_REQ_SHIP |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Quantity Requested for Shipto
|
| 20 |
QTY_REQ_LINE |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Total Line Quantity requested
|
| 21 |
QTY_PRICE |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Quantity Priced
|
| 22 |
ADJ_SET_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Set Type
INC=Increment Adjustments
SUM=Sum All Adjustments
|
| 23 |
DFLT_UOM_ADJUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Default UOM Adjustment
|
| 24 |
ADJUST_ON_GENERAL |
Character(1) |
VARCHAR2(1) NOT NULL |
General Adjustment
N=No
Y=Yes
|
| 25 |
ADJUST_ON_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust When UOM Matches
N=No
Y=Yes
|
| 26 |
ADJUST_ON_SHIPTO |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust on Shipto
N=No
Y=Yes
|
| 27 |
UNIT_OF_MSRE_PRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Price Unit of Measure
|
| 28 |
SHIPTO_SETID_PRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Shipto Setid for Pricing
|
| 29 |
SHIPTO_ID_PRC |
Character(10) |
VARCHAR2(10) NOT NULL |
Price Shipto ID
|
| 30 |
FINAL_PRICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Stop Price Calculation Here
N=No
Y=Yes
|
| 31 |
HARD_PRICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hard Price
N=No
Y=Yes
|
| 32 |
IGNORE_IF_OTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Ignore If Other Adjustments
N=No
Y=Yes
|
| 33 |
ADJ_METH |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
A=Amount
P=Percentage
|
| 34 |
QTY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity to Use for Prices
L=Line Quantity
S=Schedule Quantity
|
| 35 |
PRICE_DT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date to Use for Prices
D=Due Date
P=PO Date
|
| 36 |
QTY_MIN |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Minimum Quantity
|
| 37 |
QTY_MAX |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Maximum Quantity
|
| 38 |
PRICE_CAN_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Can Be Changed on Order
N=No
Y=Yes
|
| 39 |
PO_PROCESS_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Shows the process that created the row on the stage table
CON=Contract Releases
CRT=PAR Location Replenishment
OLS=Manual / Expedite Requisitions
OMR=Order Management Referenced
PLL=Planning System
RFQ=Request for Quotation
SFL=Production/Shop Floor
SPO=Services Work Order
SRC=AutoSelect / Quick Source
WKM=Work Order Management
|
| 40 |
CNTRCT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 41 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 42 |
CNTRCT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Buying Agreement Line Nbr
|
| 43 |
LINE_PRICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Qty/Price Type
C=Current Order Quantity
Q=Quantity To Date
|
| 44 |
QTY_LINE_RELEASED |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Total Line Qty Released
|
| 45 |
USE_CNTRCT_BASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Contract Base Price
N=No
Y=Yes
|
| 46 |
ADJ_BEFORE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Supplier Pricing First
N=After Contract Adjustments
Y=Before Contract Adjustments
|
| 47 |
PRICE_PO |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Purchase Order Price
|
| 48 |
PRICE_CNTRCT_BASE |
Number(16,5) |
DECIMAL(15,5) NOT NULL |
Contract Base Price
|
| 49 |
PRICE_VNDR |
Number(16,5) |
DECIMAL(15,5) NOT NULL |
Vendor Price
|
| 50 |
PRICE_PO_START |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Starting PO PRice
|
| 51 |
PRICE_PO_CALC |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Current Calculated Price
|
| 52 |
ADJ_AMT_SUM |
Number(16,5) |
DECIMAL(15,5) NOT NULL |
Summed Adjustment Amount
|
| 53 |
ADJ_PCT_SUM |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Summed Adjustment Percent
|
| 54 |
ADJ_AMT_INC |
Number(16,5) |
DECIMAL(15,5) NOT NULL |
Incremental Adjustment Amount
|
| 55 |
ADJ_PCT_INC |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Incremental Adjustment Percent
|
| 56 |
ADJ_AMT |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Adjustment Amount
|
| 57 |
ADJ_PCT |
Signed Number(11,4) |
DECIMAL(9,4) NOT NULL |
Adjust Percentage
|
| 58 |
ASSIGN_BPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign to Blanket PO
|
| 59 |
PO_DT |
Date(10) |
DATE |
Date
|
| 60 |
DT_PRICE |
Date(10) |
DATE |
Date to use for Pricing
|
| 61 |
PRICE_ADJ_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Supp Price UOM Adjustments
|
| 62 |
PRICE_ADJ_SHIPTO |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Supp Price Shipto Adjust
|
| 63 |
CNTRCT_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Line Work Record Type
E=Existing Contract Line
L=Contract Line
O=Open Amount
T=Other Transaction
|
| 64 |
ACCEPT_ALL_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Accept Any UOM
|
| 65 |
ACCEPT_ALL_SHIPTO |
Character(1) |
VARCHAR2(1) NOT NULL |
Accept Any Ship To
|
| 66 |
ADJ_ITEM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Item Type
C=Category Specific Adjustment
L=Line Specific Adjustment Set
O=Open Item Adjustment Set
T=Template Adjustment
|
| 67 |
UNIT_OF_MSRE_CNV |
Character(3) |
VARCHAR2(3) NOT NULL |
Converted UOM
|
| 68 |
QTY_REQ_CNV |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Converted Req Quantity
|
| 69 |
QTY_REQ_SHIP_CNV |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Converted Shipto Quantity
|
| 70 |
QTY_REQ_LINE_CNV |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Converted Line Quantity
|
| 71 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 72 |
UNIT_PRC_TOL |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Unit Price Tolerance
|
| 73 |
UNIT_PRC_TOLV |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Unit Price Tolerance
|
| 74 |
PCT_UNIT_PRC_TOL |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance
|
| 75 |
PCT_UNIT_PRC_TOLV |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance
|
| 76 |
EXT_PRC_TOL |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Ext Price Tolerance
|
| 77 |
EXT_PRC_TOLV |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Ext Price Tolerance
|
| 78 |
PCT_EXT_PRC_TOL |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Ext Price Tolerance
|
| 79 |
PCT_EXT_PRC_TOLV |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Ext Price Tolerance
|
| 80 |
QTY_RECV_TOL_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Qty Rcvd Tolerance %
|
| 81 |
USE_STD_TOLERANCES |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Item Standard Tolerances
|
| 82 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 83 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 84 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 85 |
CURRENCY_CD_CNTR |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Base Currency
|
| 86 |
CURRENCY_CD_ITM |
Character(3) |
VARCHAR2(3) NOT NULL |
Item Currency Code
|
| 87 |
CUR_CONV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Conversion Exist Flag
|
| 88 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 89 |
DECIMAL_POS_BSE |
Number(2,0) |
SMALLINT NOT NULL |
Base Cur Decimal Positions
|
| 90 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 91 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 92 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 93 |
CNTRCT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Contract Rate Divider
|
| 94 |
CNTRCT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Contract Rate Multiplier
|
| 95 |
DECIMAL_POS_CNTR |
Number(1,0) |
SMALLINT NOT NULL |
Contract Cur Decimal Positions
|
| 96 |
USE_CNTRCT_RTDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Must Use Contract Rate Date
N=No
Y=Yes
|
| 97 |
CALC_EXCHNG_RT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Calculated Exchange Rate
|
| 98 |
PRICE_PO_BASE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Base price from cntr or supp
|
| 99 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 100 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 101 |
PRICING_ERR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pricing Error Flag
|
| 102 |
CNTRCT_ERR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Min/Max Error
|
| 103 |
PRICE_COMPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Complete Flag
|
| 104 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 105 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 106 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 107 |
UNIT_PRC_TOL_L |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Unit Price Tolerance - Under
|
| 108 |
PCT_UNIT_PRC_TOL_L |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance - Under
|
| 109 |
EXT_PRC_TOL_L |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Ext Price Tolerance - Under
|
| 110 |
PCT_EXT_PRC_TOL_L |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Ext Price Tolerance - Under
|
| 111 |
UNIT_PRC_TOL_LV |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Unit Price Tolerance - Under
|
| 112 |
EXT_PRC_TOL_LV |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Ext Price Tolerance - Under
|
| 113 |
PCT_UNIT_PRC_TL_LV |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance - Under
|
| 114 |
PCT_EXT_PRC_TOL_LV |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Ext Price Tolerance - Under
|