BI_EIVC_HDSC_VW (SQL View)	Index Back
Extract for Header Dis/Sur

BI_EIVC_HDSC_VW

(SQL View)

Extract for Header Dis/Sur

SELECT A.PROCESS_INSTANCE ,A.BUSINESS_UNIT ,A.INVOICE ,A.LINE_SEQ_NUM ,A.IDENTIFIER_TBL ,A.IDENTIFIER , A.BI_CURRENCY_CD ,A.BASE_CURRENCY ,A.PERCENTAGE ,A.AMOUNT ,A.VAT_AMT ,B.VAT_APPLICABILITY FROM PS_BI_EIVC_HDISC A , PS_BI_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE = B.INVOICE AND A.LINE_SEQ_NUM = B.LINE_SEQ_NUM

# 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 IDENTIFIER_TBL Character(3) VARCHAR2(3) NOT NULL Table Identifier
A=Asset ID
CON=Contracts
D=Discount Table
G=Generic Identifier
ID=PS/Billing Charge Id
ITM=PS/Inventory Item ID
LAB=Labor type
PDA=Product Alias
PRD=PS/Product Id
PRM=PS/Promotion Code
S=Surcharge Table
SVC=Service
UPC=UPC
UPN=Universal Item ID

6 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier

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

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

9 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

10 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

11 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.

12 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated

#	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	IDENTIFIER_TBL	Character(3)	VARCHAR2(3) NOT NULL	Table Identifier A=Asset ID CON=Contracts D=Discount Table G=Generic Identifier ID=PS/Billing Charge Id ITM=PS/Inventory Item ID LAB=Labor type PDA=Product Alias PRD=PS/Product Id PRM=PS/Promotion Code S=Surcharge Table SVC=Service UPC=UPC UPN=Universal Item ID
6	IDENTIFIER	Character(18)	VARCHAR2(18) NOT NULL	Identifier
7	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
8	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. "
9	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
10	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
11	VAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
12	VAT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible. E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated