PO_CLS_LN_SHP_V(SQL View) |
Index Back |
|---|---|
PO Set Option ViewPO Set Option View |
| SELECT l.business_unit , l.po_id , l.line_nbr , s.sched_nbr , l.amt_only_flg , l.recv_req , s.match_line_opt , p.po_rule_id , r.cls_short_set_opt FROM ps_po_line l , PS_PO_LINE_SHIP s , ps_bus_unit_tbl_pm p , ps_po_cls_sht_rule r WHERE l.business_unit =s.business_unit AND l.po_id =s.po_id AND l.line_nbr =s.line_nbr AND p.business_unit = l.business_unit AND r.po_rule_type = 'CS' AND r.po_rule_id = p.po_rule_id AND r.recv_req = l.recv_req AND r.amt_only_flg = l.amt_only_flg AND r.match_line_opt =s. match_line_opt AND l.cancel_status NOT IN ('C' , 'X') AND s.cancel_status NOT IN ('C' , 'X') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 5 | AMT_ONLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Amount Only
N=No Y=Yes |
| 6 | RECV_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional X=Do Not Y=Required |
| 7 | MATCH_LINE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS F=Full Match N=Don't Match |
| 8 | PO_RULE_ID | Character(10) | VARCHAR2(10) NOT NULL | PO Close Short Rule ID |
| 9 | CLS_SHORT_SET_OPT | Character(4) | VARCHAR2(4) NOT NULL |
Close Short Set Option
MA=Matched Amount MQ=Matched Quantity NA=Disable RA=Received Amount RMGA=Greater - Receipt/Match Amt RMGQ=Greater - Receipt/Match Qty RQ=Received Quantity RVGA=Greater - Receipt/Voucher Amt RVGQ=Greater Receipt/Voucher Qty VA=Vouchered Amount VQ=Vouchered Quantity |