BI_CONS_INQ_VW(SQL View) |
Index Back |
|---|---|
Consol Bill Attached Bills |
| select business_unit, invoice, bi_currency_cd, consol_hdr, bill_status, invoice_type, invoice_dt, invoice_amount, invoice_amt_pretax, invoice_amt_bse, invoice_pretax_bse, invoice_amt_xeu, invoice_pretax_xeu, base_currency, currency_cd_xeu, consol_bus_unit, consol_invoice, bill_to_cust_id from PS_BI_HDR |
| # | 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 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 4 | CONSOL_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Consolidated Hdr?
N=No Y=Yes |
| 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_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 |
| 7 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 8 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 9 | INVOICE_AMT_PRETAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 10 | INVOICE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 11 | INVOICE_PRETAX_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 12 | INVOICE_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 13 | INVOICE_PRETAX_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 14 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 15 | CURRENCY_CD_XEU | Character(3) | VARCHAR2(3) NOT NULL |
Euro Currency
Prompt Table: CURRENCY_CD_TBL |
| 16 | CONSOL_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Billing business unit associated with a consolidated bill. |
| 17 | CONSOL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Specifies the invoice identifier associated with a consolidated bill. |
| 18 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |