BI_LIST_SS_VW1 (SQL View)	Index Back
Bill Hdr w INV status srch vw

BI_LIST_SS_VW1

(SQL View)

Bill Hdr w INV status srch vw

SELECT S.SETID , BILL_TO_CUST_ID , BUSINESS_UNIT , INVOICE_DT , INVOICE , DUE_DT , CONSOL_HDR , CONSOL_BUS_UNIT , CONSOL_INVOICE , PAYMENT_METHOD , INVOICE_FORM_ID , INVOICE_AMOUNT , INVOICE_AMOUNT , BI_CURRENCY_CD , BUSINESS_UNIT_OM , ORDER_NO , CONTRACT_NUM , PO_REF , PROJECT_ID FROM PS_BI_HDR H , PS_SET_CNTRL_REC S WHERE H.BILL_STATUS = 'INV' AND TEMPLATE_IVC_FLG = 'N' AND S.RECNAME = 'CUSTOMER' AND S.SETCNTRLVALUE = H.BUSINESS_UNIT AND CONSOL_BUS_UNIT = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

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

4 INVOICE_DT Date(10) DATE Invoice Date

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

6 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

7 CONSOL_HDR Character(1) VARCHAR2(1) NOT NULL Consolidated Hdr?
N=No
Y=Yes

8 CONSOL_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Specifies the Billing business unit associated with a consolidated bill.

9 CONSOL_INVOICE Character(22) VARCHAR2(22) NOT NULL Specifies the invoice identifier associated with a consolidated bill.

10 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report

11 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Form

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

13 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance

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

15 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

16 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

17 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

18 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

19 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	INVOICE_DT	Date(10)	DATE	Invoice Date
5	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
6	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
7	CONSOL_HDR	Character(1)	VARCHAR2(1) NOT NULL	Consolidated Hdr? N=No Y=Yes
8	CONSOL_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Billing business unit associated with a consolidated bill.
9	CONSOL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Specifies the invoice identifier associated with a consolidated bill.
10	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
11	INVOICE_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Form
12	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
13	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
14	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
15	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
16	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
17	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
18	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
19	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField