EMVCH_AF_LN_VW(SQL View) |
Index Back |
|---|---|
AF Invoice Line Approv. SearchAF Invoice Line Approval Search Record |
| SELECT a.business_unit , a.voucher_id , LINE.VOUCHER_LINE_NUM , DIST.DISTRIB_LINE_NUM , DIST.appr_status , a.vchr_apprvl_flg , a.cur_rt_source , DIST.txn_currency_cd , DIST.merchandise_amt , a.rt_type , a.rate_div , a.rate_mult , a.oprid , a.oprid_last_updt FROM PS_VOUCHER a , PS_EM_BUY_REG_TBL B , PS_VOUCHER_LINE LINE , PS_DISTRIB_LINE DIST , PS_BUS_UNIT_TBL_AP E WHERE a.BUSINESS_UNIT = LINE.BUSINESS_UNIT AND LINE.BUSINESS_UNIT = DIST.BUSINESS_UNIT AND a.VOUCHER_ID = LINE.VOUCHER_ID AND LINE.VOUCHER_ID = DIST.VOUCHER_ID AND LINE.VOUCHER_LINE_NUM = DIST.VOUCHER_LINE_NUM AND a.entry_status = 'P' AND a.vchr_apprvl_flg = 'W' AND a.close_status <> 'C' AND a.process_man_close <> 'Y' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.EM_USE_AP_APPROVAL = 'N' AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND E.PROCESS_LINES_FLAG = 'Y' AND ((A.VCHR_SRC IN ('SSI','EXL')) OR (A.vchr_src IN ('XML','DCM') AND EXISTS ( SELECT 'X' FROM PS_EM_AGREEMENT g , ps_set_cntrl_rec i WHERE i.setid = g.SETID AND i.setcntrlvalue = a.business_unit AND i.rec_group_id = 'EM_01' AND i.recname = 'EM_AGREEMENT' AND a.vendor_setid = g.vendor_setid AND a.vendor_id = g.vendor_id AND a.vndr_loc = g.vndr_loc))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Default Value: NEXT |
| 3 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 4 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 5 | APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved D=Denied P=Pending |
| 6 | VCHR_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework |
| 7 | CUR_RT_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables U=User Specified |
| 8 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 9 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 10 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 11 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 12 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 13 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 14 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL | Last User to Update |