PO_HDR_EXS(SQL Table) |
Index Back |
|---|---|
PO Header Excise/Sales Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Default Value: NEXT |
| 3 | 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.
Y/N Table Edit Default Value: N |
| 4 | EXD_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Excise Cat |
| 5 | STX_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Applicability.
Default Value: N |
| 6 | STX_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Tax Cat |
| 7 | 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 |
| 8 | CSD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Customs Duty applicable flag
Y/N Table Edit Default Value: N |
| 9 | CSD_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Customs Duty Tax Category |