AR_WC_BITOAR_VW(SQL View) |
Index Back |
|---|---|
AR WorkCenter invoices view |
| SELECT DISTINCT BUSINESS_UNIT ,INVOICE ,INVOICE_DT ,BILL_TO_CUST_ID ,INVOICE_AMT_BSE ,INVOICE_AMOUNT ,BI_CURRENCY_CD ,BILL_SOURCE_ID ,CONSOL_HDR ,CONSOL_INVOICE FROM PS_BI_HDR WHERE BILL_STATUS = 'INV' AND CONSOL_HDR = 'N' AND AR_ENTRY_CREATED <> 'Y' AND AR_LVL <> 'N' AND ((BUSINESS_UNIT_TO <> ' ' AND GEN_AR_ITEM_FLG = 'Y') OR (BUSINESS_UNIT_TO = ' ' AND GEN_AR_ITEM_FLG = 'N')) |
| # | 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 |
| 3 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 4 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: %EDITTABLE3 |
| 5 | INVOICE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 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
Prompt Table: CURRENCY_CD_TBL |
| 8 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC_EF_VW |
| 9 | CONSOL_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Consolidated Hdr?
N=No Y=Yes Y/N Table Edit Default Value: N |
| 10 | CONSOL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Specifies the invoice identifier associated with a consolidated bill. |