BI_BILL_CUSL_VW (SQL View)	Index Back
Bill Line BOL Vw

BI_BILL_CUSL_VW

(SQL View)

Bill Line BOL Vw

SELECT DISTINCT b.business_unit , b.bi_currency_cd , b.base_currency , b.currency_cd_xeu , b.bill_to_cust_id , b.bill_source_id , b.bill_status , b.bill_type_id , a.bill_of_lading , b.invoice , b.invoice_dt , b.invoice_amount , b.invoice_amt_bse , b.invoice_amt_xeu , b.template_ivc_flg FROM ps_bi_line a , PS_BI_HDR b WHERE a.business_unit = b.business_unit AND a.invoice = b.invoice

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 CURRENCY_CD_XEU Character(3) VARCHAR2(3) NOT NULL Euro Currency

5 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
Prompt Table: CUSTOMER

6 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source

7 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

8 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

9 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.

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

11 INVOICE_DT Date(10) DATE Invoice Date

12 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount

13 INVOICE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount

14 INVOICE_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount

15 TEMPLATE_IVC_FLG Character(1) VARCHAR2(1) NOT NULL Template Invoice Flag
I=Installment Bill
N=No
R=Recurring Bill

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
3	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. "
4	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency
5	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CUSTOMER
6	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
7	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
8	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier
9	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
10	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
11	INVOICE_DT	Date(10)	DATE	Invoice Date
12	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
13	INVOICE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
14	INVOICE_AMT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
15	TEMPLATE_IVC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Template Invoice Flag I=Installment Bill N=No R=Recurring Bill