| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
CS_DATETM |
DateTime(26) |
TIMESTAMP |
Date Time Field
|
| 3 |
CS_RAND_KEY |
Number(5,0) |
INTEGER NOT NULL |
SCMT003 TBG 5/15/2014 Contract Workbench --field used in the new workbench
|
| 4 |
CS_SOURCE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
SCMT003 -- new field "like" Source Transaction but containing All Sources options and renamed Purchasing Contracts to Procurement Contracts as per Alexa
000=All Sources
001=Adhoc Documents
002=Procurement Contracts
003=Purchase Order Documents
004=Sourcing Event Documents
|
| 5 |
CS_SETIDBU |
Character(5) |
VARCHAR2(5) NOT NULL |
SCMT003 TBG 5/15/2014 Contract Workbench --field used in the new workbench
|
| 6 |
CS_CONTENT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Content ID
|
| 7 |
CS_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
setid for the document objects
|
| 8 |
CS_DOC_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Document ID
|
| 9 |
CS_DOCUMENT_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
|
| 10 |
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
|
| 11 |
CS_CONTENT_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
Transaction Status
|
| 12 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 13 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
|
| 14 |
CNTRCT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
|
| 15 |
CNTRCT_EXPIRE_DT |
Date(10) |
DATE |
Expire Date
|
| 16 |
CS_DOC_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Document Status
AA=Approved
AD=Denied
AP=Pending Approval
CC=Collaborated
CP=Pending Collaboration
CR=Collaborated, Pending Review
DC=Complete
DR=Draft
DS=Dispatched
EC=Pending External Collaboration
EX=Executed
PI=Pending Internal Review
|
| 17 |
CS_DOC_DESCR |
Character(60) |
VARCHAR2(60) NOT NULL |
Document Description
|
| 18 |
CS_DOC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
stores the file type -- main file, amendment, preview, throwaway
Date Initials Issue Description
==========================================
06/2007 CEL F-AHAYT-25EQ8 added the external main and amendment types
7/2008 cel Added new executive summary file type.
9/30/2008 RMK Changed values 005 and 006 to 095 and 096, and added 010 for executive summary. This change is due to the search on file type using range (001-010 for non-attachment search, and 001-096 for attachment search)
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
005=Document Attachment
006=Transaction Attachment
007=Config Selector
008=Main Signature Document
009=Amendment Signature File
010=Executive Summary
011=Exec-Sign
095=Document Attachment
096=Transaction Attachment
101=Main Document
102=Amendment Document
998=Main Document - ext collab
999=Amendment External Collab
|
| 19 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
Prompt Table:
BUYER_ACTIVE_VW
|
| 20 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
Default Value: 1
|
| 21 |
VERSION_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract version status
C=Current
D=Draft
H=History
Default Value: C
|
| 22 |
RENEWAL_DATE |
Date(10) |
DATE |
Renewal Date
|
| 23 |
MSTR_CNTRCT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Master Contract ID
Prompt Table:
CNTRCT_MSTR_VW
|
| 24 |
DRAFT_DUE_DATE |
Date(10) |
DATE |
Approval Due Date
|
| 25 |
VNDR_CNTRCT_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier Contract Ref
|
| 26 |
CS_AMENDMENT |
Number(3,0) |
SMALLINT NOT NULL |
Amendment
|
| 27 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
CS_DEPT2_VW
|
| 28 |
CS_SPONSOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Sponsor
Prompt Table:
PSOPRDEFN_VW
|
| 29 |
CS_VERSION |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Document Version
Default Value: 1
|
| 30 |
CS_IMPORT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Imported Document
|
| 31 |
CS_DOC_OWNER |
Character(30) |
VARCHAR2(30) NOT NULL |
Document Administrator
|
| 32 |
PO_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
PO Type
GEN=General
KAN=Kanban
|
| 33 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 34 |
RECV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
Default Value: N
|
| 35 |
AUC_ROUND |
Number(5,0) |
INTEGER NOT NULL |
Event Round
|
| 36 |
AUC_VERSION |
Number(5,0) |
INTEGER NOT NULL |
Event Version
|
| 37 |
AUC_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Format
F=Sell
I=RFI
R=Buy
S=Service
|
| 38 |
AUC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Type
E=Auction
S=RFx
|
| 39 |
AUC_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Event Name
|
| 40 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 41 |
CNTRCT_STYLE |
Character(10) |
VARCHAR2(10) NOT NULL |
Contract Style
|
| 42 |
CNTRCT_STYLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Style Description
|