PROCESS_INSTANCEBUSINESS_UNITPrompt Table: BU_GL_UPDATE_VW
E_ACCT_BK_IDPUB=Public Sectors
SOE=State Owned Enterprise
Default Value: SOE
CNAO_XML_EATGBK(SQL Table) |
Index Back |
|---|---|
Electronic Accounting BookCNAO Electronic Accounting Book |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BU_GL_UPDATE_VW |
| 3 | E_ACCT_BK_ID |
Character(60) | VARCHAR2(60) NOT NULL | Electronic Accounting Book ID |
| 4 | E_ACCT_BK_NM | Character(200) | VARCHAR2(200) NOT NULL | Electronic Accounting Book Name |
| 5 | ENTERPRISE_NM | Character(200) | VARCHAR2(200) NOT NULL | Enterprise Name |
| 6 | ORG_NO | Character(20) | VARCHAR2(20) NOT NULL | Organization Number |
| 7 | ENTERPRISE_QUALITY | Character(4) | VARCHAR2(4) NOT NULL |
Enterprise Quality
PUB=Public Sectors SOE=State Owned Enterprise Default Value: SOE |
| 8 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 9 | ENTERPRISE_IND | Character(20) | VARCHAR2(20) NOT NULL | Enterprise Industry |
| 10 | SFTWR_VENDOR | Character(20) | VARCHAR2(20) NOT NULL | Software Vendor |
| 11 | ERP_VER | Character(60) | VARCHAR2(60) NOT NULL | ERP Software Version |
| 12 | CURRENCY_CD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Currency Code Description |
| 13 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 14 | CNAO_STD_VER | Character(30) | VARCHAR2(30) NOT NULL | CNAO Standard Version |