BUSINESS_UNITPrompt Table: SP_BU_GL_NONVW
E_ACCT_BK_IDPUB=Public Sectors
SOE=State Owned Enterprise
Default Value: SOE
CNAO_E_ACCT_BK(SQL Table) |
Index Back |
|---|---|
Electronic Accounting BookCNAO Electronic Accounting Book |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 2 | E_ACCT_BK_ID |
Character(60) | VARCHAR2(60) NOT NULL | Electronic Accounting Book ID |
| 3 | E_ACCT_BK_NM | Character(200) | VARCHAR2(200) NOT NULL | Electronic Accounting Book Name |
| 4 | ENTERPRISE_NM | Character(200) | VARCHAR2(200) NOT NULL | Enterprise Name |
| 5 | ORG_NO | Character(20) | VARCHAR2(20) NOT NULL | Organization Number |
| 6 | ENTERPRISE_QUALITY | Character(4) | VARCHAR2(4) NOT NULL |
Enterprise Quality
PUB=Public Sectors SOE=State Owned Enterprise Default Value: SOE |
| 7 | ENTERPRISE_IND | Character(20) | VARCHAR2(20) NOT NULL | Enterprise Industry |
| 8 | CNAO_STD_VER | Character(30) | VARCHAR2(30) NOT NULL | CNAO Standard Version |
| 9 | ERP_VER | Character(60) | VARCHAR2(60) NOT NULL | ERP Software Version |