PO_HDR_STG_EXS(SQL Table) |
Index Back |
|---|---|
PO Header Staging EXS Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | CSD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Customs Duty applicable flag |
| 5 | CSD_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Customs Duty Tax Category |
| 6 | 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 |
| 7 | EXD_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Excise Cat |
| 8 | EXD_PTP_APPL | Character(1) | VARCHAR2(1) NOT NULL | Excise (Purchase).This field is used in the Business Tax Applicability |
| 9 | STX_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Applicability.
Default Value: N |
| 10 | STX_TPRTNR_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Trading Partner Tax Cat |
| 11 | STX_PTP_APPL | Character(1) | VARCHAR2(1) NOT NULL | Sales Tax (Purchase) Applicable |
| 12 | 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 |