PO_STGPRG_TMP(SQL Table) |
Index Back |
|---|
| # | 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 | CNTRCT_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 5 | PO_DT |
Date(10) | DATE | Date |
| 6 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 8 | REQ_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
| 9 | REQ_SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
| 10 | REQ_DISTRIB_NBR |
Number(5,0) | INTEGER NOT NULL | Requisition Distrib Number |
| 11 | BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 12 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 13 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 14 | 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 |
| 15 | QTY_OPEN_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Open Standard UOM |
| 16 | QTY_OPEN | Number(16,4) | DECIMAL(15,4) NOT NULL | Open Quantity |
| 17 | RELEASE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Release Type
P=Purchase Order V=Voucher |