FSS_INVOICE_VW

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT , A.BUSINESS_UNIT , A.INVOICE , A.BILL_TO_CUST_ID , A.BILL_STATUS FROM PS_BI_HDR A , PS_BI_BU_FSS_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.TEMPLATE_IVC_FLG = 'N' AND A.CONSOL_BUS_UNIT = ' ' AND A.CONSOL_INVOICE = ' ' AND A.BILL_STATUS NOT IN ('INV', 'FNL', 'CAN', 'TMP', 'TMR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SL_BI_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BI_BU_FSS_VW

2 TO_BI_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BI_BU_FSS_VW

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BI_BU_FSS_VW

4 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
5 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: %EDITTABLE3

6 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

Default Value: NEW