ORD_EXSTAX_H_VW(SQL View) |
Index Back |
|---|
| SELECT h.business_unit , h.order_no , h.order_int_line_no , h.sched_line_nbr , h.address_seq_num , h.business_unit_exs , h.country_ship_from , h.country_ship_to , h.currency_cd , h.currency_cd_base , h.exd_appl_flg , h.exd_assess_value , h.exd_chapter_id , h.exd_conversion_rt , h.exd_itm_catg_cd , h.exd_tax_item_type , h.exd_tax_amt_rpt , h.exd_tax_rate_cd , h.exd_tprtnr_catg_cd , h.exd_uom , h.exd_use_av_flg , h.exs_currency_rptg , h.exs_itm_prod_id , h.exs_itm_prod_setid , h.exs_prod_kit_use , h.exs_rate_div , h.exs_rate_mult , h.exs_rt_type , h.exs_serv_tax_flg , h.exs_tax_rate_cd , h.exs_tax_txn_type , h.exs_taxvalue , h.exs_tprtnr_id , h.exs_tprtnr_setid , h.exs_tprtnr_type , h.exs_vndr_loc , h.org_bu_type , h.org_code , h.org_setid , h.org_tax_loc_cd , h.state_ship_from , h.state_ship_to , h.stx_appl_flg , h.stx_form_cd , h.stx_itm_catg_cd , h.stx_tax_auth_rate , h.stx_tax_auth_rpt , h.stx_tax_rate_cd , h.stx_tprtnr_catg_cd FROM ps_ord_exs_tax_hdr h , PS_ORD_SCHEDULE s WHERE h.business_unit = s.business_unit AND h.order_no = s.order_no AND h.order_int_line_no = s.order_int_line_no AND h.sched_line_nbr = s.sched_line_nbr AND s.ord_sch_status NOT IN ('C', 'X') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 3 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 4 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 5 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 6 | BUSINESS_UNIT_EXS | Character(5) | VARCHAR2(5) NOT NULL | Excise Business Unit |
| 7 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
| 8 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 11 | EXD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values. |
| 12 | EXD_ASSESS_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Assessable Value |
| 13 | EXD_CHAPTER_ID | Character(7) | VARCHAR2(7) NOT NULL | Excise Chapter ID |
| 14 | EXD_CONVERSION_RT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 15 | EXD_ITM_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Item Category Code |
| 16 | EXD_TAX_ITEM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Tax Item Type
C=Capital Goods F=Finished Goods R=Raw Material S=Service |
| 17 | EXD_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty Amt In Rpt Curr |
| 18 | EXD_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Tax Calculation Code |
| 19 | EXD_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Excise Cat |
| 20 | EXD_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 21 | EXD_USE_AV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Excise Use Av Flag |
| 22 | EXS_CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Excise Currency Reporting |
| 23 | EXS_ITM_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Item Product ID |
| 24 | EXS_ITM_PROD_SETID | Character(5) | VARCHAR2(5) NOT NULL | |
| 25 | EXS_PROD_KIT_USE | Character(1) | VARCHAR2(1) NOT NULL |
Product Kit Usage
I=Item N=Not Applicable P=Product |
| 26 | EXS_RATE_DIV | Number(4,0) | SMALLINT NOT NULL | Exchange Rate Div |
| 27 | EXS_RATE_MULT | Number(4,0) | SMALLINT NOT NULL | Exchange Rate Mult |
| 28 | EXS_RT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Currency Rate Type |
| 29 | EXS_SERV_TAX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Service Tax Indicator
N=Not Service Tax Y=Service Tax |
| 30 | EXS_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Rate Code |
| 31 | 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 |
| 32 | EXS_TAXVALUE | Number(27,3) | DECIMAL(26,3) NOT NULL | Tax Value in Entered Currency |
| 33 | EXS_TPRTNR_ID | Character(15) | VARCHAR2(15) NOT NULL | Trading Partner Id |
| 34 | EXS_TPRTNR_SETID | Character(5) | VARCHAR2(5) NOT NULL | |
| 35 | EXS_TPRTNR_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Excise Duty Trading Partner |
| 36 | EXS_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Supplier Location |
| 37 | 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 |
| 38 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
| 39 | ORG_SETID | Character(5) | VARCHAR2(5) NOT NULL | Organization SetID. |
| 40 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. |
| 41 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
| 42 | STATE_SHIP_TO | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 43 | STX_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Sales Tax Applicability. |
| 44 | STX_FORM_CD | Character(8) | VARCHAR2(8) NOT NULL | Form Code |
| 45 | STX_ITM_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Item Category Code |
| 46 | STX_TAX_AUTH_RATE | Character(8) | VARCHAR2(8) NOT NULL | Tax Authority Rate (India Sales Tax) |
| 47 | STX_TAX_AUTH_RPT | Character(8) | VARCHAR2(8) NOT NULL | Reporting Authority (India Sales Tax) |
| 48 | STX_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Tax Calculation Code |
| 49 | STX_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Tax Cat |