EXD_DOC_VW(SQL View) |
Index Back |
|---|
| SELECT c.exd_doc_nbr_ser , c.descr1 , c.exd_txn_type FROM ps_bus_unit_tbl_in a , PS_ORG_BU_TAX_APPL b ,ps_org_doc_nbr_ser c WHERE a.business_unit=b.business_unit AND a.bu_status='1' AND b.org_bu_type='IN' AND b.exd_otc_appl='y' AND b.org_setid=c.setid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXD_DOC_NBR_SR | Character(6) | VARCHAR2(6) NOT NULL | Excise Document Number Series |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | 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 |