BI_EIVC_WKB_VW(SQL View) |
Index Back |
|---|---|
Elec Invcoie Status ViewRecord View for Electronic Invoice Status Management page. |
| SELECT A.BUSINESS_UNIT ,A.INVOICE ,A.BILL_STATUS ,A.BILL_TO_CUST_ID ,A.NAME1 ,A.INVOICE_AMOUNT ,A.BI_CURRENCY_CD ,B.EIVC_STATUS ,B.SUBMISSION_DATE ,A.ENTRY_TYPE ,A.ENTRY_REASON ,A.BILL_SOURCE_ID ,A.BILLING_SPECIALIST ,A.ADD_DTTM ,A.CONSOL_HDR ,A.INVOICE_DT ,A.INVOICE_TYPE ,A.BILL_TYPE_ID FROM PS_BI_HDR A , PS_BI_EIVC_STATUS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE = B.INVOICE AND A.BILL_TO_MEDIA = 'X' 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 |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | 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 |
| 4 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 6 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 7 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 8 | EIVC_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Electronic Invoice Status
ACC=Accepted FAL=Failed Delivery GEN=Generated RDY=Ready REC=Received REF=Refused REJ=Rejected REV=Reversed TRA=Transmitted |
| 9 | SUBMISSION_DATE | Date(10) | DATE | Submission Date |
| 10 | ENTRY_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction. |
| 11 | ENTRY_REASON | Character(5) | VARCHAR2(5) NOT NULL | "Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""." |
| 12 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
| 13 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL | Billing Specialist |
| 14 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 15 | CONSOL_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Consolidated Hdr?
N=No Y=Yes |
| 16 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 17 | 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 |
| 18 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |