BI_PCCA_VW

(SQL View)
 Index Back

Rows in BI_HDR for PC/CA

View into BI_HDR that selects any rows that are to be sent or have already been sent to the Contracts or Projects system.

SELECT BUSINESS_UNIT , INVOICE , BILL_STATUS , RANGE_SELECTION_ID , CONTRACT_NUM , PROJECT_ID , BILL_TO_CUST_ID , INVOICE_AMT_PRETAX , INVOICE_AMOUNT , BI_CURRENCY_CD , TOT_SU_TAX , TOT_VAT , ADD_DTTM , LC_ID , LOC_DOC_ID FROM PS_BI_HDR WHERE PC_DISTRIB_STATUS IN ('D', 'N') AND PROCESS_INSTANCE = 0 AND CONSOL_HDR = 'N' AND TEMPLATE_IVC_FLG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 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
4 RANGE_SELECTION_ID Character(30) VARCHAR2(30) NOT NULL Range Selection ID
5 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
7 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
8 INVOICE_AMT_PRETAX Signed Number(28,3) DECIMAL(26,3) NOT NULL Pretax Invoice Amount
9 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
10 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
11 TOT_SU_TAX Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Sales/Use Tax
12 TOT_VAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Amount
13 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
14 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
15 LOC_DOC_ID Character(30) VARCHAR2(30) NOT NULL Letter of Credit Document ID