BI_SPLST_VW(SQL View) |
Index Back |
|---|---|
BI bill status vw |
| SELECT H.BUSINESS_UNIT , H.INVOICE , H.INVOICE_DT , H.ACCOUNTING_DT , H.DATE_ADDED , H.BI_CURRENCY_CD , H.BILL_STATUS , H.INVOICE_AMOUNT , H.INVOICE_TYPE , H.BILL_TO_CUST_ID , S.NAME1 , H.BILL_SOURCE_ID , H.BILL_TYPE_ID , H.BILLING_SPECIALIST , H.CONTRACT_NUM , H.PROJECT_ID FROM PS_BI_SPLST_VW1 H LEFT OUTER JOIN PS_BI_SPECIALST_VW S ON (S.BILLING_SPECIALIST = H.BILLING_SPECIALIST AND S.SETID = H.CUST_SETID) |
| # | 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
Default Value: NEXT Prompt Table: BI_HDR_IVC_VW |
| 3 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 4 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 5 | DATE_ADDED | Date(10) | DATE | Date Added |
| 6 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 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_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 9 | 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 |
| 10 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUST_BI_A2_VW |
| 11 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 12 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
| 13 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 14 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL | Billing Specialist |
| 15 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 16 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |