BUSINESS_UNITVOUCHER_IDVOUCHER_LINE_NUMDEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
VCHR_GST_VW(SQL View) |
Index Back |
|---|---|
Voucher GST Tax |
| SELECT B.BUSINESS_UNIT , B.VOUCHER_ID , B.VOUCHER_LINE_NUM , B.EXD_TPRTNR_CATG_CD , B.STX_TPRTNR_CATG_CD , B.EXS_TAX_TXN_TYPE , B.EXD_ITM_CATG_CD , B.STX_ITM_CATG_CD , B.SHIPTO_ID , A.COUNTRY_SHIP_FROM , A.COUNTRY_SHIP_TO , B.STATE_SHIP_FROM , B.STATE_SHIP_TO FROM PS_VOUCHER A , PS_VOUCHER_LINE B , PS_VCHR_LN_GST C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID AND B.VOUCHER_LINE_NUM = C.VOUCHER_LINE_NUM AND C.REV_CHARGE_APPL = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 4 | EXD_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Excise Cat |
| 5 | STX_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Tax Cat |
| 6 | EXS_TAX_TXN_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond DEWB=Direct Export Without Bond DIMP=Direct Import DOM=Domestic LEB=Local Export With Bond LEWB=Local Export Without Bond LIMP=Local Import |
| 7 | EXD_ITM_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Item Category Code |
| 8 | STX_ITM_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Item Category Code |
| 9 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 10 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
| 11 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
| 12 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
| 13 | STATE_SHIP_TO | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |