EM_VCH_HDR_VW

(SQL View)
 Index Back

Invoice Header Information

Invoice Header Information

SELECT a.business_unit , a.voucher_id , a.appr_status , a.vchr_apprvl_flg , a.cur_rt_source , a.txn_currency_cd , a.merchandise_amt , a.rt_type , a.rate_div , a.rate_mult , a.oprid , a.oprid_last_updt , a.voucher_style , a.invoice_id , a.invoice_dt , a.entered_dt , a.due_dt , a.vendor_setid , a.vendor_id , a.vndr_loc , a.address_seq_num , a.close_status , a.entry_status , a.accounting_dt , a.business_unit_gl , a.dup_invoice_status , a.voucher_id_related , a.gross_amt , a.gross_amt_bse , a.base_currency , a.dscnt_amt , a.dscnt_amt_bse , a.dscnt_prorate_flg , a.tax_exempt , a.vchr_priority , a.vchr_src , a.usetax_amt , a.saletx_amt , a.freight_amt , a.misc_amt , a.pymnt_terms_cd , a.descr254_mixed FROM PS_VOUCHER a , PS_EMVCH_AF_HDR_VW B WHERE a.BUSINESS_UNIT = B.BUSINESS_UNIT AND a.VOUCHER_ID = B.VOUCHER_ID

# 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 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
4 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
5 CUR_RT_SOURCE Character(1) VARCHAR2(1) NOT NULL Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
6 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
7 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
8 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.
9 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
10 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
12 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
13 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
14 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
15 INVOICE_DT Date(10) DATE Invoice Date
16 ENTERED_DT Date(10) DATE Entered on
17 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
18 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
19 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
20 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
21 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
22 CLOSE_STATUS Character(1) VARCHAR2(1) NOT NULL Close Status Indicator
C=Closed
O=Open
23 ENTRY_STATUS Character(1) VARCHAR2(1) NOT NULL If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted
24 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
25 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
26 DUP_INVOICE_STATUS Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Status
27 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher
28 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
29 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
30 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
31 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
32 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
33 DSCNT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Discount
34 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
35 VCHR_PRIORITY Character(1) VARCHAR2(1) NOT NULL This is a new field reserved for Mobile Approval. Added on April 24th 2012.
H=High
L=Low
M=Medium
36 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
37 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
38 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
39 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
40 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
41 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.
42 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description