| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_CALLER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Application Engine Caller Prog
|
| 3 |
AMT_CNTRCT_MAX |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Maximum Amount of Contract.
|
| 4 |
AMT_RELEASED |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Total Amount Released
|
| 5 |
AMT_RELSD_OPEN_ITM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amt relsd for Open Item
|
| 6 |
AUC_GROUP_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
GroupID
|
| 7 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 8 |
ADJ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Adjustment Sequence
|
| 9 |
CNTRCT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
|
| 10 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 11 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
|
| 12 |
CNTRCT_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Price Type
1=Line
2=Category
3=Header (open item)
|
| 13 |
CAT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Category Line Number
|
| 14 |
CNTRCT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Buying Agreement Line Nbr
|
| 15 |
CNTRCT_CORP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Corporate Contract Flag
N=No
Y=Yes
|
| 16 |
CNTRCT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 17 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 18 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 19 |
LINE_GRP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Group Flag
|
| 20 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 21 |
MAX_ADJ_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Adjustment Sequence
|
| 22 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 23 |
PO_DT |
Date(10) |
DATE |
Date
|
| 24 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 25 |
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
|
| 26 |
PRICE_ADJUST_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Price Adjustment Sequence
|
| 27 |
QTY_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Purchase Order Quantity
|
| 28 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
|
| 29 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 30 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 31 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 32 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 33 |
CNTRCT_PROC_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Contract Process Option
AP=Recurring Voucher
BPO=Release to Single PO Only
DST=Distributor
GN=General Contract
GRPM=Group Multi Supplier
GRPS=Group Single Supplier
MFG=Manufacturer
PADV=Prepaid Voucher w/ Advance PO
PO=Purchase Order
PPAY=Prepaid Voucher
RPOV=Recurring PO Voucher
SPP=Special Purpose
|
| 34 |
CNTRCT_ID_DST |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract ID To
|
| 35 |
SHIPTO_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
ShipTo SetID
|
| 36 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 37 |
CNTRCT_MARKUP |
Signed Number(10,4) |
DECIMAL(8,4) NOT NULL |
PO002
|
| 38 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 39 |
PRICE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Price From Vendor SetID
|
| 40 |
PRICE_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Price Vendor ID
|
| 41 |
PRICE_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Price from Location
|
| 42 |
PRICE_PO |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Purchase Order Price
|
| 43 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 44 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 45 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 46 |
DIRECT_PUR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
PO002 Manufacturer Contract
Y/N Table Edit
Default Value: N
|
| 47 |
PCHOUTPRICE_OPTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Punchout Pricing Option
AUCP=Always Use Contract Price
AUPP=Always Use Punchout Price
UPPL=Use Punchout Price if Lower
X=Not Used
Default Value: AUCP
|
| 48 |
UPN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Universal Product Number Format Type
Prompt Table:
%EDITTABLE39
|
| 49 |
UPN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Universal Product Number
Prompt Table:
%EDIT_VALUE
|
| 50 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table:
MANUFACTURER
|
| 51 |
MFG_ITM_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
Prompt Table:
%EDIT_MFGITM_ID
|
| 52 |
ITM_ID_VNDR |
Character(50) |
VARCHAR2(50) NOT NULL |
Vendor Item ID
|