C360_BI_BILL_VW

(SQL View)
 Index Back

BI bill status vw


SELECT h.business_unit , h.invoice ,rec.setid , h.bill_to_cust_id , h.invoice_dt , h.accounting_dt , %DatePart(h.add_dttm) , h.bi_currency_cd , h.bill_status , h.invoice_amount , h.invoice_type , h.bill_to_cust_id , h.bill_source_id , h.bill_type_id , h.billing_frequency , h.billing_specialist , h.contract_num , h.project_id , h.gen_ar_item_flg , h.gen_ap_vchr_flg , h.ap_created_dt , h.ar_entry_created , h.gl_entry_created , h.ar_lvl , h.business_unit_to , h.consol_hdr , %Sql(EOEW_FUNCLIB_DATE_MONTH_UPD, h.invoice_dt) , %Sql(EOEW_FUNCLIB_DATE_YEAR_UPD, h.invoice_dt) , %Sql(C360_FUNCLIB_DATE_YYYYMM , h.invoice_dt) FROM PS_BI_HDR h , ps_set_cntrl_rec rec WHERE (BILL_STATUS NOT IN ('CAN', 'TMP', 'TMR') OR ((BILL_STATUS = 'TMP' OR BILL_STATUS = 'TMR') AND (PC_DISTRIB_STATUS <> 'I')) ) AND CONSOL_HDR <> 'Y' AND TEMPLATE_IVC_FLG = 'N' AND rec.setcntrlvalue=h.business_unit AND rec.recname='CUSTOMER' AND rec.rec_group_id='FS_23'

# 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

Prompt Table: SP_BU_BI_NONVW

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

Default Value: NEXT

Prompt Table: BI_HDR_IVC_VW

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
5 INVOICE_DT Date(10) DATE Invoice Date
6 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
7 DATE_ADDED Date(10) DATE Date Added
8 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
9 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
10 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
11 INVOICE_TYPE Character(3) VARCHAR2(3) NOT NULL Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
12 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUST_BI_A2_VW

13 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source
14 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
15 BILLING_FREQUENCY Character(3) VARCHAR2(3) NOT NULL Billing Frequency
INS=Installment
ONC=Once
REC=Recurring
16 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist
17 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
18 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
19 GEN_AR_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL Generate AR Open Item
20 GEN_AP_VCHR_FLG Character(1) VARCHAR2(1) NOT NULL Generate AP Voucher
21 AP_CREATED_DT Date(10) DATE AP Voucher Created Date
22 AR_ENTRY_CREATED Character(1) VARCHAR2(1) NOT NULL AR Accounting Entry Created
23 GL_ENTRY_CREATED Character(1) VARCHAR2(1) NOT NULL GL Accounting Entry Created
24 AR_LVL Character(1) VARCHAR2(1) NOT NULL AR Level
H=Header is AR Open Item
L=Bill Line is AR Open Item
N=No AR Open Items
25 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
26 CONSOL_HDR Character(1) VARCHAR2(1) NOT NULL Consolidated Hdr?
N=No
Y=Yes
27 MONTH1 Character(2) VARCHAR2(2) NOT NULL Month
28 YEAR1 Character(4) VARCHAR2(4) NOT NULL Year 1
29 C360_PERIOD Character(8) VARCHAR2(8) NOT NULL Period