BI_LINE_VAT2_VW (SQL View)	Index Back
View used in VAT Txn Loader The VAT Transaction Loader requires the Invoice Date to be in the same table as the Distribution Status. To do this requires this view which joins BI_HDR and BI_LINE.

BI_LINE_VAT2_VW

(SQL View)

View used in VAT Txn Loader

The VAT Transaction Loader requires the Invoice Date to be in the same table as the Distribution Status. To do this requires this view which joins BI_HDR and BI_LINE.

select l.business_unit, l.invoice, l.line_seq_num, l.vat_distrib_status, h.invoice_dt from ps_bi_line l, PS_BI_HDR h where h.business_unit = l.business_unit and h.invoice = l.invoice

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 VAT_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL VAT Distribution Status
D=Distributed
E=Error Flag
I=Ignored
M=Archival Entry
N=Not Distributed
P=Processed
R=Reversal Entry
U=Undefined

5 VAT_DCLRTN_DT Date(10) DATE "Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
4	VAT_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	VAT Distribution Status D=Distributed E=Error Flag I=Ignored M=Archival Entry N=Not Distributed P=Processed R=Reversal Entry U=Undefined
5	VAT_DCLRTN_DT	Date(10)	DATE	"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "