PROCESS_INSTANCEDEB=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_BLD3_AET(SQL Table) |
Index Back |
|---|---|
Voucher Build State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | 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 |
| 3 | STX_TPRTNR_CAT_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Tax Trading Partner |
| 4 | EXD_TPRTNR_CAT_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Duty Trading Partner |
| 5 | STX_ITM_CAT_CD | Character(10) | VARCHAR2(10) NOT NULL | Item Tax Category |
| 6 | EXD_ITM_CAT_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Item Category |
| 7 | WHERE_CLAUSE5 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 8 | WHERE_CLAUSE6 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |