ORG_TAXLOC_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for ORG_TAX_LOC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
| 4 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. |
| 5 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 6 | ORG_TAN | Character(20) | VARCHAR2(20) NOT NULL | Tax Deduction Account Number. A number allotted by the Income Tax Authority to identify an Organization for withholding payments. |
| 7 | ORG_TAN_WARD | Character(30) | VARCHAR2(30) NOT NULL | Income Tax Ward. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority. |
| 8 | ORG_TAN_CIRCLE | Character(30) | VARCHAR2(30) NOT NULL | Income Tax Circle. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority. |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 11 | EXD_NATURE_OF_LOC | Character(4) | VARCHAR2(4) NOT NULL |
Nature of Location. This field will have a default value of "Factory" and "Depo". It is used in the Tax location page. The translate value of "Depo" has been made inactive.
D=Depot F=Factory |
| 12 | EXD_CENVAT_CG_PCT | Number(3,0) | SMALLINT NOT NULL | Cenvat % on Capital Goods |
| 13 | EXD_CENVAT_UTL | Character(1) | VARCHAR2(1) NOT NULL |
CENVAT Utilization. This field will have two translate values of "fortnightly" and "Online".
F=Fortnightly O=Online |
| 14 | EXD_CHAPTER_VALID | Character(1) | VARCHAR2(1) NOT NULL | Chapter wise validation. This field will have Yes and No values. To check items of different chapters are not to be shipped in a single excise invoice. |
| 15 | EXD_SUBCONTR_OD | Number(3,0) | SMALLINT NOT NULL | Sub Contracting Overdue days. This field is used in Excise group |
| 16 | EXD_DEPL_CHECK | Character(1) | VARCHAR2(1) NOT NULL | Depletion Check. This flag needs to be checked, incase excise invoice can be created only when depletion is run. |
| 17 | EXD_ECC_NBR | Character(15) | VARCHAR2(15) NOT NULL | Excise Control Code number. This code is unique to the Excise Tax Location and it is issued by the Excise authority |
| 18 | EXD_RGSTN_NBR | Character(15) | VARCHAR2(15) NOT NULL | Excise Registration Code. This field is unique to a particular Excise Tax Location. |
| 19 | EXD_RANGE | Character(20) | VARCHAR2(20) NOT NULL | Excise Range. This field defines the Excise Range for a particular Tax Location code. It is used in documents and registers printing. |
| 20 | EXD_DIVISION | Character(20) | VARCHAR2(20) NOT NULL | Excise Division. This field defines the Excise Division for a particular Tax Location code. It is used in documents and registers printing. |
| 21 | EXD_COLLECTORATE | Character(20) | VARCHAR2(20) NOT NULL | Excise Collectorate. This field defines the Excise Collectorate for a particular Tax Location code. It is used in documents and registers printing. |
| 22 | EXD_NOTIF_NBR | Character(30) | VARCHAR2(30) NOT NULL | Notification Number |
| 23 | EXD_ZONE | Character(20) | VARCHAR2(20) NOT NULL | Excise Zone. This field defines the Excise Zone for a particular Tax Location code. It is used in documents and registers printing. |
| 24 | EXD_REGION | Character(20) | VARCHAR2(20) NOT NULL | Excise Region. This field defines the Excise Region for a particular Tax Location code. It is used in documents and registers printing. |
| 25 | EXD_CIRCLE | Character(20) | VARCHAR2(20) NOT NULL | Excise Circle. This field defines the Excise Circle for a particular Tax Location code. It is used in documents and registers printing. |
| 26 | EXD_PLA_ACCT_NBR | Character(20) | VARCHAR2(20) NOT NULL | Personal Ledger Account Number. This field is used in Excise invoice for shipping and PLA register printing. |
| 27 | EXD_SERV_TAX_RGSTN | Character(16) | VARCHAR2(16) NOT NULL | Service Tax Registration Number. This is unique to the Excise Tax Location. |
| 28 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 29 | EXD_CSD_TAX_CMPNT | Character(10) | VARCHAR2(10) NOT NULL | CSD Tax Component |
| 30 | EXD_CENVAT_LOCK | Character(1) | VARCHAR2(1) NOT NULL | CENVAT Tax Location Lock |
| 31 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |