EXD_SHP_CNVT_VW(SQL View) |
Index Back |
|---|---|
Online CENVAT Utilization |
| SELECT H.EXD_INVOICE_NO , H.EXD_INV_DATE , H.BUSINESS_UNIT , H.ORG_SETID , H.ORG_CODE , H.ORG_TAX_LOC_CD , H.EXD_DOC_NBR_SER , H.EXD_INV_STATUS , SUM(T.EXS_TAX_AMT_RPT) FROM PS_EXD_SHP_INV_HDR H , PS_EXD_SHP_INV_TAX T , PS_EXD_SHP_INV_LN L WHERE H.EXD_INV_STATUS = 'R' AND H.TOT_EXD_AMT_RPT > 0 AND H.EXD_QTY_REG_UPD = 'Y' AND H.BUSINESS_UNIT = T.BUSINESS_UNIT AND H.EXD_DOC_NBR_SER = T.EXD_DOC_NBR_SER AND H.EXD_INVOICE_NO = T.EXD_INVOICE_NO AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.EXD_DOC_NBR_SER = L.EXD_DOC_NBR_SER AND H.EXD_INVOICE_NO = L.EXD_INVOICE_NO AND L.BUSINESS_UNIT = T.BUSINESS_UNIT AND L.EXD_DOC_NBR_SER = T.EXD_DOC_NBR_SER AND L.EXD_INVOICE_NO = T.EXD_INVOICE_NO AND L.EXD_INVOICE_LN = T.EXD_INVOICE_LN AND L.EXD_CENVAT_FLG <> 'Y' GROUP BY H.EXD_INVOICE_NO , H.EXD_INV_DATE , H.BUSINESS_UNIT , H.ORG_SETID , H.ORG_CODE , H.ORG_TAX_LOC_CD , H.EXD_DOC_NBR_SER , H.EXD_INV_STATUS , H.TOT_EXD_AMT_RPT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXD_INVOICE_NO | Character(10) | VARCHAR2(10) NOT NULL | Excise Invoice Number |
| 2 | EXD_INV_DATE | Date(10) | DATE | Invoice Date |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | ORG_SETID | Character(5) | VARCHAR2(5) NOT NULL | Organization SetID. |
| 5 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
| 6 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. |
| 7 | EXD_DOC_NBR_SER | Character(6) | VARCHAR2(6) NOT NULL | Excise Document Number Series. Excise Document number series group will be created against each excise transaction type. |
| 8 | EXD_INV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Excise Invoice Status
C=Cancel N=New P=Post R=Ready |
| 9 | TOT_EXD_AMT_RPT | Number(27,3) | DECIMAL(26,3) NOT NULL | Total Excise Duty |