EM_VCH_LN_VW

(SQL View)
 Index Back

Invoice Line Information

Invoice Line Information

SELECT B.business_unit , B.voucher_id , B.VOUCHER_LINE_NUM , B.DISTRIB_LINE_NUM , B.appr_status , a.vchr_apprvl_flg , a.match_status_vchr , a.cur_rt_source , B.txn_currency_cd , B.merchandise_amt , a.rt_type , a.rate_div , a.rate_mult , a.oprid , a.oprid_last_updt , a.invoice_id , a.invoice_dt , a.entered_dt , LINE.descr , a.vendor_setid , a.vendor_id , a.vndr_loc , a.address_seq_num , a.accounting_dt , a.dup_invoice_status , a.voucher_id_related , a.voucher_style , a.vchr_src , a.pymnt_terms_cd , LINE.inv_item_id , LINE.DESCR254_MIXED FROM PS_VOUCHER a , PS_EMVCH_AF_LN_VW B , PS_VOUCHER_LINE LINE WHERE a.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = LINE.BUSINESS_UNIT AND a.VOUCHER_ID = B.VOUCHER_ID AND B.VOUCHER_ID = LINE.VOUCHER_ID AND B.VOUCHER_LINE_NUM = LINE.VOUCHER_LINE_NUM

# 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 MATCH_STATUS_VCHR Character(1) VARCHAR2(1) NOT NULL Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched
8 CUR_RT_SOURCE Character(1) VARCHAR2(1) NOT NULL Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
9 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
10 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
11 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.
12 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
13 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
15 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
16 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
17 INVOICE_DT Date(10) DATE Invoice Date
18 ENTERED_DT Date(10) DATE Entered on
19 DESCR Character(30) VARCHAR2(30) NOT NULL Description
20 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
21 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
22 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
23 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
24 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
25 DUP_INVOICE_STATUS Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Status
26 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher
27 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
28 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
29 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
30 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
31 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description