BI_INST_LIST_VW(SQL View) |
Index Back |
|---|---|
Installmnt Bill Select List Vw |
| SELECT I.OPRID , I.RUN_CNTL_ID , H.BUSINESS_UNIT , H.INVOICE , H.BILL_TO_CUST_ID , H.BILL_STATUS , H.BILL_SOURCE_ID , H.BILL_TYPE_ID , H.AR_DST_OPT , H.TEMPLATE_IVC_FLG , S.SETID , S2.SETID , H.PROCESS_INSTANCE , H.BI_BU_TAX_IND FROM PS_RUN_BI_INSTALL I , PS_BI_HDR H , PS_SET_CNTRL_REC S , PS_SET_CNTRL_REC S2 WHERE H.TEMPLATE_IVC_FLG = 'I' AND BILLING_FREQUENCY = 'INS' AND (H.BUSINESS_UNIT = I.BUSINESS_UNIT OR I.BUSINESS_UNIT = ' ') AND (H.BILL_CYCLE_ID = I.BILL_CYCLE_ID OR I.BILL_CYCLE_ID = ' ') AND (H.BILL_TO_CUST_ID = I.CUST_ID OR I.CUST_ID = ' ') AND (H.INVOICE BETWEEN I.START_INVOICE AND I.END_INVOICE OR I.START_INVOICE = ' ') AND S.SETCNTRLVALUE = H.BUSINESS_UNIT AND S.RECNAME = 'DST_CODE_TBL' AND S2.SETCNTRLVALUE = H.BUSINESS_UNIT AND S2.RECNAME = 'BI_TYPE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT_BI |
Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 4 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 5 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 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 |
| 7 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
| 8 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 9 | AR_DST_OPT | Character(1) | VARCHAR2(1) NOT NULL |
AR Distribution Option
H=Use Header for Distribution L=Use Line for Distribution |
| 10 | TEMPLATE_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Template Invoice Flag
I=Installment Bill N=No R=Recurring Bill |
| 11 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 12 | SETID_TYPE | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 13 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 14 | BI_BU_TAX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Billing Business Unit Tax Flag
0=PS standard taxes/VAT 1=Third-party tax supplier 2=India taxes |