BI_EIVC_LDSC_VW (SQL View)	Index Back
Extract table for line dis/sur

BI_EIVC_LDSC_VW

(SQL View)

Extract table for line dis/sur

SELECT PROCESS_INSTANCE ,BUSINESS_UNIT ,INVOICE ,LINE_SEQ_NUM ,DISC_SUR_LVL ,DISC_SUR_ID ,DISC_SUR_INDICATOR ,DISC_AMT , BI_CURRENCY_CD ,BASE_CURRENCY FROM PS_BI_EIVC_LDISC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

4 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence

5 DISC_SUR_LVL Number(2,0) SMALLINT NOT NULL Discount/Surcharge Level

6 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier

7 DISC_SUR_INDICATOR Character(1) VARCHAR2(1) NOT NULL Discount/Surcharge
D=Discount
I=Installment Surcharge
S=Surcharge

8 DISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the discount amount available if payment on an item is made before the discount date. The amount is manually entered or system-generated using the payment terms code. The discount date associated with this amount is specified in DISC_DT. This is the first of two possible discounts associated with an item.

9 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

10 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. "

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
4	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
5	DISC_SUR_LVL	Number(2,0)	SMALLINT NOT NULL	Discount/Surcharge Level
6	DISC_SUR_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifier
7	DISC_SUR_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Discount/Surcharge D=Discount I=Installment Surcharge S=Surcharge
8	DISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the discount amount available if payment on an item is made before the discount date. The amount is manually entered or system-generated using the payment terms code. The discount date associated with this amount is specified in DISC_DT. This is the first of two possible discounts associated with an item.
9	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
10	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. "