BI_LVAT_ERR_VW(SQL View) |
Index Back |
|---|---|
BI - Line VAT Error RecordBI - Line VAT Error Record |
| SELECT V.BUSINESS_UNIT , V.INVOICE , V.LINE_SEQ_NUM , L.IDENTIFIER_TBL , L.IDENTIFIER , L.DESCR , L.NET_EXTENDED_AMT , L.BI_CURRENCY_CD , V.ERROR_STATUS_BI , V.MESSAGE_SET_NBR , V.MESSAGE_NBR , V.ERROR_FIELDNAME FROM PS_BI_LVAT_ERR V , PS_BI_LINE L WHERE V.BUSINESS_UNIT = L.BUSINESS_UNIT AND V.INVOICE = L.INVOICE AND V.LINE_SEQ_NUM = L.LINE_SEQ_NUM |
| # | 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 | LINE_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Sequence |
| 4 | IDENTIFIER_TBL | Character(3) | VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID CON=Contracts D=Discount Table G=Generic Identifier ID=PS/Billing Charge Id ITM=PS/Inventory Item ID LAB=Labor type PDA=Product Alias PRD=PS/Product Id PRM=PS/Promotion Code S=Surcharge Table SVC=Service UPC=UPC UPN=Universal Item ID |
| 5 | IDENTIFIER | Character(18) | VARCHAR2(18) NOT NULL | Identifier |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 8 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 9 | ERROR_STATUS_BI | Character(4) | VARCHAR2(4) NOT NULL | Error Status |
| 10 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 11 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 12 | ERROR_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field with an error. |