EXD_INV_SER_VW(SQL View) |
Index Back |
|---|---|
Excise Number Series Grp ViewUsed by Supplier Excise Invoice |
| SELECT DISTINCT A.BUSINESS_UNIT , B.EXD_DOC_NBR_SER , A.ORG_BU_TYPE , B.DESCR1 , B.EXD_TXN_TYPE , B.EXD_OVERWRITE_FLG , C.START_DT FROM PS_ORG_BU_TAX_APPL A , PS_ORG_DOC_NBR_SER B , PS_ORG_DOC_NBR_RNG C WHERE A.ORG_BU_TYPE IN ('IN', 'PO') AND A.ORG_SETID = B.SETID AND B.EXD_TXN_TYPE IN ('BOE', 'DOMR', 'IUT') AND A.ORG_SETID = C.SETID AND A.ORG_CODE = C.ORG_CODE AND A.ORG_TAX_LOC_CD = C.ORG_TAX_LOC_CD AND B.EXD_DOC_NBR_SER = C.EXD_DOC_NBR_SER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: %RECNAME_EDIT |
| 2 | 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. |
| 3 | ORG_BU_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Business Unit Type. This field will have six translate values representing the various BUs
AP=Payables AR=Receivables BI=Billing IN=Inventory OM=Order Management PO=Purchasing |
| 4 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 5 | EXD_TXN_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Excise Tax Transaction Type. This field will have various translate values for the transaction types.
BOE=Bill of Entry DEXB=Deemed Export with Bond DEXP=Deemed Export DOMR=Domestic Receipt DOMS=Domestic Sales EXP=Export without bond EXPB=Export with bond IBUS=Inter-Unit Sale IUT=InterUnit Receipt MEIN=Manual STFR=Stock Transfer |
| 6 | EXD_OVERWRITE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Overwrite Allowed. This field is used in Excise document series to specify whether the user needs to override the system option of auto numbering.
Y/N Table Edit |
| 7 | START_DT | Date(10) | DATE | Start Date |