BI_CRCARD_HT_VW(SQL View) |
Index Back |
|---|
| SELECT h.business_unit , h.invoice , h.order_no , h.bill_status , h.bill_to_cust_id , c.ADD_DTTM FROM PS_BI_HDR h , ps_crcard_hst c WHERE h.consol_hdr <> 'Y' AND h.process_instance = 0 AND h.business_unit = c.business_unit AND h.invoice = c.invoice AND h.bill_status IN ('INV', 'FNL') |
| # | 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 |
| 3 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 4 | 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 |
| 5 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUST_BI_A2_VW |
| 6 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |