BI_TAX_RECAL_VW (SQL View)	Index Back
Bill Tax Line RECALC View

BI_TAX_RECAL_VW

(SQL View)

Bill Tax Line RECALC View

SELECT A.BUSINESS_UNIT , A.INVOICE , A.LINE_SEQ_NUM , B.BILL_STATUS , A.TAX_CD , A.SHIP_TO_CUST_ID , A.SHIP_TO_ADDR_NUM , A.TAX_EXEMPT_FLG , A.PROCESS_INSTANCE , A.ERROR_STATUS_BI , A.LAST_UPDATE_DTTM FROM PS_BI_LINE A , PS_BI_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE = B.INVOICE AND B.INVOICE_TYPE <> 'ACR' AND A.ADJ_LINE_TYPE <> 'ACR' AND A.FINAL_TAX_FLG <> 'Y'

# 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 BILL_STATUS Character(3) VARCHAR2(3) NOT NULL Bill Status
CAN=Canceled
FNL=Finalized Bill
HLD=Hold Bill
INV=Invoiced Bill
NEW=New Bill
PND=Pending Approval
RDY=Ready to Invoice
TMP=Temporary Bill
TMR=Temporary Ready Bill

5 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

6 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

7 SHIP_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Ship To Address Sequence Num

8 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

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

10 ERROR_STATUS_BI Character(4) VARCHAR2(4) NOT NULL Error Status

11 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	BILL_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Bill Status CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill
5	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
6	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
7	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
8	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
9	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
10	ERROR_STATUS_BI	Character(4)	VARCHAR2(4) NOT NULL	Error Status
11	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.