BUSINESS_UNITPrompt Table: BU_ITEM_INV_VW
RECEIVER_IDCM_TRANS_INV_VW(SQL View) |
Index Back |
|---|---|
View to get receipt infoCreated on 05/18/99 RML for CM800-9.0 LIFO/FIFO Enhancement - Movement by Receipt Line report needs to be able to select by receipt |
| select business_unit, inv_item_id, dt_timestamp, seq_nbr, receiver_id, recv_ln_nbr from PS_TRANSACTION_INV |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITEM_INV_VW |
| 3 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 4 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 6 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |