PRCR_INQ_CH_VW(SQL View) |
Index Back |
|---|
| SELECT SETID , OPRID , BUSINESS_UNIT , BANK_CD , BANK_ACCT_KEY , PRCR_DOC_ID , PRCR_DOC_TYPE , CB_SELECT_PO , CURRENCY_CD , CURRENCY_CD_BASE , DOCSTAT_DATE , DESCR , STATUS_FIELD , VENDOR_ID , VENDOR_SETID , VNDR_LOC , AUC_ROUND , AUC_VERSION , NBR_UNIQUE , PROCESS_INSTANCE , FIRST FROM PS_PRCR_INQ_TMP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 5 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 6 | PRCR_DOC_ID | Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 7 | PRCR_DOC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Document Type
CNT=Contract IUR=Inter Unit Receipt MSR=MSR PMT=Payment PO=Purchase Order RCV=Receipt REQ=Requisition RFQ=Request For Quote RTV=Return To Vendor (Supplier) SSE=Strategic Sourcing Event VOU=Voucher WO=Work Order |
| 8 | CB_SELECT_PO | Character(1) | VARCHAR2(1) NOT NULL | Select PO Schedule Checkbox |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 11 | DOCSTAT_DATE | Date(10) | DATE | Document Date |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | STATUS_FIELD | Character(30) | VARCHAR2(30) NOT NULL | Payment Status |
| 14 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 15 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 16 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 17 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 18 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 19 | NBR_UNIQUE | Number(10,0) | DECIMAL(10) NOT NULL | Number to add to make unique |
| 20 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 21 | FIRST | Character(1) | VARCHAR2(1) NOT NULL | Date Initials Reference # Description 02/11/09 MRAD 1828918001 Ensured that It doesnot take long to return POSearch results in eSupplier Portal. |