BI_BILL_CUSJ_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.bill_source_id , b.bill_status , b.bill_type_id ,' ' ,' ' ,' ' ,' ' ,%Sql(FS_CF_SPACES) , a.project_id , 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 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
10 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
11 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
13 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: %EDIT_OPER_UNIT

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

Prompt Table: %EDIT_PRODUCT

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

Prompt Table: %EDIT_FUND_CODE

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

Prompt Table: %EDIT_CLASS_FLD

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

Prompt Table: %EDIT_PROG_CODE

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

Prompt Table: %EDIT_BUD_REF

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: %EDIT_CHARTFLD1

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

Prompt Table: %EDIT_CHARTFLD2

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

Prompt Table: %EDIT_CHARTFLD3

25 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
26 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
27 INVOICE_DT Date(10) DATE Invoice Date
28 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
29 INVOICE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
30 INVOICE_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
31 TEMPLATE_IVC_FLG Character(1) VARCHAR2(1) NOT NULL Template Invoice Flag
I=Installment Bill
N=No
R=Recurring Bill