BUSINESS_UNITPrompt Table: SP_BU_BI_NONVW
INVOICEPrompt Table: BI_TYPE
Prompt Table: BI_SRC
BI_VAT_ERR_SRCH(SQL View) |
Index Back |
|---|---|
BI - VAT bill error search recBilling VAT bill error search record |
| SELECT V.BUSINESS_UNIT , V.INVOICE , H.BILL_TYPE_ID , H.BILL_SOURCE_ID , V.ERROR_STATUS_BI , X.XLATLONGNAME FROM PS_BI_HVAT_ERR V , PS_BI_HDR H , PSXLATITEM X WHERE H.BUSINESS_UNIT = V.BUSINESS_UNIT AND H.INVOICE = V.INVOICE AND V.ERROR_STATUS_BI <> ' ' AND X.FIELDNAME = 'ERROR_STATUS_BI' AND V.ERROR_STATUS_BI = X.FIELDVALUE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_BI_NONVW |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table: BI_TYPE |
| 4 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC |
| 5 | ERROR_STATUS_BI | Character(4) | VARCHAR2(4) NOT NULL | Error Status |
| 6 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |