REQ_IDREQ_LINE_NBRREQ_SCHED_NBRREQ_DISTRIB_NBRMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
REQ_VCHR_XREF(SQL View) |
Index Back |
|---|
| SELECT a.business_unit , a.req_id , a.line_nbr , a.sched_nbr , a.distrib_line_num , b.business_unit , b.voucher_id , b.voucher_line_num , b.inv_item_id , b.qty_vchr , b.unit_of_measure , b.merchandise_amt , b.currency_cd FROM PS_REQ_PO_INQ_VW A , PS_VOUCHER_LINE B WHERE a.business_unit = b.business_unit_po AND a.po_id = b.po_id AND a.po_line_nbr = b.line_nbr AND a.po_sched_nbr = b.sched_nbr |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_REQ | Character(5) | VARCHAR2(5) NOT NULL | Requesting Business Unit |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | REQ_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
| 4 | REQ_SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
| 5 | REQ_DISTRIB_NBR |
Number(5,0) | INTEGER NOT NULL | Requisition Distrib Number |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 8 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 9 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 10 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 11 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 12 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |