BI_CUST_ADJ_VW(SQL View) |
Index Back |
|---|---|
Bills for Adjustment Add To Vw |
| SELECT a.business_unit , a.bill_to_cust_id , a.invoice , a.bi_currency_cd , a.bill_status , a.invoice_dT , a.invoice_amount FROM PS_BI_HDR a , ps_customer b WHERE a.bill_to_cust_id = b.cust_id AND b.cust_status = 'A' AND b.setid = ( SELECT setid FROM ps_set_cntrl_rec WHERE recname = 'CUSTOMER' AND setcntrlvalue = a.business_unit) AND (a.bill_status = 'HLD' OR a.bill_status = 'NEW') AND a.consol_hdr = 'N' |
| # | 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 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 4 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 5 | 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 |
| 6 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 7 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |