BI_BILL_SRCH_VW

(SQL View)
 Index Back

Bill Search Header VW


SELECT a.business_unit , a.bill_to_cust_id , a.bill_source_id , a.bill_status , a.bill_type_id , a.contract_num , a.po_ref , a.bill_of_lading , a.order_no ,' ' ,' ' ,' ' ,' ' ,%Sql(FS_CF_SPACES) , a.project_id , a.invoice , a.invoice_dt , a.bi_currency_cd , a.base_currency , a.currency_cd_xeu , a.invoice_amount , a.invoice_amt_bse , a.invoice_amt_xeu , a.consol_key , a.consol_invoice , a.template_ivc_flg , a.bill_to_media , a.consol_hdr , a.bi_approval_status , a.createoprid FROM PS_BI_HDR a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

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

Prompt Table: CUSTOMER

3 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
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 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
6 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
7 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
8 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
9 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
10 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
11 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
12 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
14 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: %EDIT_OPER_UNIT

15 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: %EDIT_PRODUCT

16 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: %EDIT_FUND_CODE

17 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: %EDIT_CLASS_FLD

18 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: %EDIT_PROG_CODE

19 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: %EDIT_BUD_REF

20 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

21 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

22 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

23 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: %EDIT_CHARTFLD1

24 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: %EDIT_CHARTFLD2

25 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: %EDIT_CHARTFLD3

26 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
27 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
28 INVOICE_DT Date(10) DATE Invoice Date
29 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
30 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. "
31 CURRENCY_CD_XEU Character(3) VARCHAR2(3) NOT NULL Euro Currency
32 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
33 INVOICE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
34 INVOICE_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
35 CONSOL_KEY Character(22) VARCHAR2(22) NOT NULL Invoice Consolidation Key
36 CONSOL_INVOICE Character(22) VARCHAR2(22) NOT NULL Specifies the invoice identifier associated with a consolidated bill.
37 TEMPLATE_IVC_FLG Character(1) VARCHAR2(1) NOT NULL Template Invoice Flag
I=Installment Bill
N=No
R=Recurring Bill
38 BILL_TO_MEDIA Character(1) VARCHAR2(1) NOT NULL Bill To Media
A=Email Invoice as Attachment
E=EDI
H=Federal Highway File
N=Email Notification
P=Print Copy
X=Electronic Invoice File
39 CONSOL_HDR Character(1) VARCHAR2(1) NOT NULL Consolidated Hdr?
N=No
Y=Yes
40 BI_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
0=Not Required
1=Initial
2=Pending
3=Approved
4=Denied
5=Canceled
41 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID