COMPANY_TBL_CHN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	ORG_NBR_CHN	Character(20)	VARCHAR2(20) NOT NULL	Organization NO
4	ENTERPRISE_IND_CHN	Character(20)	VARCHAR2(20) NOT NULL	Enterprise Industry Name
5	TRANS_TYPE_CHN	Character(1)	VARCHAR2(1) NOT NULL	Translation Type P=Public Sector and Ministries S=State Owned Enterprise Default Value: S
6	ELEC_BOOK_NO_CHN	Character(60)	VARCHAR2(60) NOT NULL	Electronic Book NO
7	ELEC_BOOK_NAME_CHN	Character(200)	VARCHAR2(200) NOT NULL	Electronic Book Name
8	ACC_PERIOD_MAP_CHN	Character(1)	VARCHAR2(1) NOT NULL	Accounitng Period mapping for China E=Earn Date P=Pay Date Default Value: P
9	ADMIN_DIV_CODE_CHN	Character(20)	VARCHAR2(20) NOT NULL	Administrative Division code
10	BGT_MGMT_LEV_CHN	Character(20)	VARCHAR2(20) NOT NULL	Budget Management Level
11	FUND_SRC_CHN	Character(20)	VARCHAR2(20) NOT NULL	Fund Source
12	SFTWARE_VENDOR_CHN	Character(200)	VARCHAR2(200) NOT NULL	Software Vendor
13	ERP_VERSION_CHN	Character(20)	VARCHAR2(20) NOT NULL	ERP Software Version
14	CNAO_STD_VER_CHN	Character(30)	VARCHAR2(30) NOT NULL	CNAO Standard Version
15	OPR_CLASS_CHN	Character(100)	VARCHAR2(100) NOT NULL	Operation classification
16	LEGAL_REP_CHN	Character(11)	VARCHAR2(11) NOT NULL	Legal representative Prompt Table: PERSON_NAME
17	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50