BI_BILL_CONL_VW

(SQL View)
Index Back

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.contract_num , 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 , b.bill_to_media , b.consol_key , b.consol_invoice , a.order_no , a.po_ref , b.BI_APPROVAL_STATUS , a.project_id ,' ' ,' ' ,' ' ,%Sql(FS_CF_SPACES) 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
6 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
7 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
8 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
9 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
10 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
11 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
12 INVOICE_DT Date(10) DATE Invoice Date
13 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
14 INVOICE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
15 INVOICE_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
16 TEMPLATE_IVC_FLG Character(1) VARCHAR2(1) NOT NULL Template Invoice Flag
I=Installment Bill
N=No
R=Recurring Bill
17 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
18 CONSOL_KEY Character(22) VARCHAR2(22) NOT NULL Invoice Consolidation Key
19 CONSOL_INVOICE Character(22) VARCHAR2(22) NOT NULL Specifies the invoice identifier associated with a consolidated bill.
20 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
21 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
22 BI_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
0=Not Required
1=Initial
2=Pending
3=Approved
4=Denied
5=Canceled
23 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
24 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
25 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
26 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
27 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: %EDIT_OPER_UNIT

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

Prompt Table: %EDIT_PRODUCT

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

Prompt Table: %EDIT_FUND_CODE

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

Prompt Table: %EDIT_CLASS_FLD

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

Prompt Table: %EDIT_PROG_CODE

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

Prompt Table: %EDIT_BUD_REF

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: %EDIT_CHARTFLD1

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

Prompt Table: %EDIT_CHARTFLD2

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

Prompt Table: %EDIT_CHARTFLD3