BUSINESS_UNITA=Amount
Q=Quantity
RECV_LN_PRDN_FS(SQL View) |
Index Back |
|---|---|
Receipt Schedule View02/23/99 ej R-SDAVIE-OA4LN: BUSINESS_UNIT_IN added to be used later for capturing SUBCONTRACTOR PPV. 10/2/03 RC: use MERCH_AMT_BSE(receipt transaction amt is the base currency) instaed of PRICE_PO. |
| SELECT BUSINESS_UNIT , BUSINESS_UNIT_IN , PRODUCTION_ID , OP_SEQUENCE , PO_ID , PRICE_PO_BSE , DISTRIB_MTHD_FLG , MERCHANDISE_AMT , QTY_SH_ACCPT_SUOM , QTY_SH_ACCPT_VUOM FROM PS_RECV_LN_SHIP WHERE REJECT_ACTION <> 'R' AND RECV_SHIP_STATUS <> 'X' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 5 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 6 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
| 7 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |
| 8 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 9 | QTY_SH_ACCPT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Accepted Quantity |
| 10 | QTY_SH_ACCPT_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Accept QTY in Supplier UOM |