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.