BI_CUST_WKS_VW

(SQL View)
Index Back

SELECT BUSINESS_UNIT , BILL_TO_CUST_ID , CONTRACT_NUM , BI_CURRENCY_CD , INVOICE , INVOICE_TYPE , BILL_STATUS , INVOICE_DT , FROM_DT , TO_DT , INVOICE_AMOUNT , PUBLIC_VOUCHER_NBR , HOLD_UNTIL_DT FROM PS_BI_HDR WHERE BILL_STATUS IN ('HLD','NEW') AND CONSOL_HDR = 'N' AND INVOICE_TYPE <> 'ACR' AND TEMPLATE_IVC_FLG = 'N' AND BI_PAID_AT_SRC <> '9'

# 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

2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUSTOMER

3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
4 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
5 ADD_TO_BILL Character(22) VARCHAR2(22) NOT NULL Add To Bill
6 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
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 INVOICE_DT Date(10) DATE Invoice Date
9 FROM_DT Date(10) DATE From Date
10 TO_DT Date(10) DATE To Date
11 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
12 PUBLIC_VOUCHER_NBR Number(6,0) INTEGER NOT NULL Public Voucher Number
13 HOLD_UNTIL_DT Date(10) DATE Hold Until Date