BUSINESS_UNIT_RECVRECEIVER_IDRECV_LN_NBRRECV_SHIP_SEQ_NBRMATCH_CNTRL_IDMATCH_RULE_IDRECV_LOG_RULE(SQL View) |
Index Back |
|---|---|
Receiver Log Rule View |
| SELECT a.business_unit_recv , a.receiver_id , a.recv_ln_nbr , a.recv_ship_seq_nbr , a.match_cntrl_id , d.match_rule_id FROM PS_VCHR_MTCH_DETLS a , ps_ap_mtch_excptn d WHERE a.process_instance = d.process_instance AND a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND a.voucher_line_num = d.voucher_line_num |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RECV |
Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | RECV_SHIP_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 5 | MATCH_CNTRL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Match Rule |
| 6 | MATCH_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Match Rule ID |