BI_BILL_CONJ_VW

(SQL View)
 Index Back

Bill Line Project 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 ,' ' ,' ' ,' ' ,%Sql(FS_CF_SPACES) , a.project_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 , b.bill_to_media , b.consol_key , b.consol_invoice , a.order_no , a.po_ref , b.BI_APPROVAL_STATUS 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 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
8 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
10 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: %EDIT_OPER_UNIT

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

Prompt Table: %EDIT_PRODUCT

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

Prompt Table: %EDIT_FUND_CODE

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

Prompt Table: %EDIT_CLASS_FLD

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

Prompt Table: %EDIT_PROG_CODE

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

Prompt Table: %EDIT_BUD_REF

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: %EDIT_CHARTFLD1

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

Prompt Table: %EDIT_CHARTFLD2

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

Prompt Table: %EDIT_CHARTFLD3

22 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
23 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
24 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
25 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
26 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
27 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
28 INVOICE_DT Date(10) DATE Invoice Date
29 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
30 INVOICE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
31 INVOICE_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
32 TEMPLATE_IVC_FLG Character(1) VARCHAR2(1) NOT NULL Template Invoice Flag
I=Installment Bill
N=No
R=Recurring Bill
33 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
34 CONSOL_KEY Character(22) VARCHAR2(22) NOT NULL Invoice Consolidation Key
35 CONSOL_INVOICE Character(22) VARCHAR2(22) NOT NULL Specifies the invoice identifier associated with a consolidated bill.
36 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
37 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
38 BI_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
0=Not Required
1=Initial
2=Pending
3=Approved
4=Denied
5=Canceled