BCT_UPAR_INV_VW(SQL View) |
Index Back |
|---|---|
Update Par Location CountBCT_DTL view used to maintain Par Location Count transactions. |
| SELECT A.BUSINESS_UNIT , A.EIP_CTL_ID , A.SEQ_NBR , A.TRANSACTION_CODE , A.EIP_TRANS_SRC_SEQ , A.LAST_DTTIME , A.BCT_DET_STATUS , A.INV_CART_ID , A.INV_ITEM_ID , A.COMPARTMENT , A.COUNT_ORDER , A.CART_COUNT_QTY , A.UNIT_OF_MEASURE , A.QTY_OPTION , A.SUFFICIENT_STOCK , ' ' , ' ' , ' ' , ' ' FROM PS_BCT_DTL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 2 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 3 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | TRANSACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 5 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
| 6 | LAST_DTTIME | DateTime(26) | TIMESTAMP NOT NULL | Last Date Time |
| 7 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel |
| 8 | INV_CART_ID | Character(15) | VARCHAR2(15) NOT NULL |
Par Location ID
Prompt Table: CART_ATTRIB_INV |
| 9 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: %EDIT_CART_ITEM |
| 10 | COMPARTMENT | Character(10) | VARCHAR2(10) NOT NULL | Compartment |
| 11 | COUNT_ORDER | Signed Number(5,0) | DECIMAL(4) NOT NULL | Par Location Count Order |
| 12 | CART_COUNT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Par Location Count Quantity |
| 13 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDIT_CART_UOM |
| 14 | QTY_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
Qty Option
01=Count Qty 02=Request Qty |
| 15 | SUFFICIENT_STOCK | Character(1) | VARCHAR2(1) NOT NULL |
Sufficient Stock
N=NOT SUFFICIENT STOCK Y=SUFFICIENT STOCK |
| 16 | CART_REPLEN_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Par Replenishment Option
01=Stock 02=Stockless 03=Non-Stock 04=Not Replenished |
| 17 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 18 | ORDER_BU | Character(5) | VARCHAR2(5) NOT NULL | Par Loc Order Business Unit |
| 19 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |