ORG_RGSTN_DTL(SQL Table) |
Index Back |
---|---|
Organization Details |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
3 | ORG_NAME | Character(50) | VARCHAR2(50) NOT NULL | Organization Name. |
4 | ORG_PAN | Character(20) | VARCHAR2(20) NOT NULL | Personal Account Number. This is allotted by the Income Tax Authority to identify an organization in their tax returns. |
5 | ORG_PAN_WARD | Character(30) | VARCHAR2(30) NOT NULL | PAN 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. |
6 | ORG_PAN_CIRCLE | Character(30) | VARCHAR2(30) NOT NULL | PAN 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. |
7 | ORG_IE_CODE | Character(20) | VARCHAR2(20) NOT NULL | Import Export Code for an Organization.This field will be used for Customs duty. |
8 | ORG_BIN | Character(20) | VARCHAR2(20) NOT NULL | Business Identification Number. This BIN is allotted for an Organization. |