PSA_ORG_DEFN(SQL Table) |
Index Back |
|---|---|
Organization DefinitionOrganization Definition for Accounting Rules |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NBR_ORG_CFS | Character(1) | VARCHAR2(1) NOT NULL |
Number of Chartfields
1=1 2=2 3=3 4=4 5=5 Default Value: 1 |
| 2 | LEVEL1_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 1 Chartfield
Prompt Table: CA_PC_CF_VW |
| 3 | LEVEL2_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 2 Chartfield
Prompt Table: CA_PC_CF_VW |
| 4 | LEVEL3_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 3 Chartfield
Prompt Table: CA_PC_CF_VW |
| 5 | LEVEL4_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 4 Chartfield
Prompt Table: CA_PC_CF_VW |
| 6 | LEVEL5_CF | Character(30) | VARCHAR2(30) NOT NULL |
Level 5 Chartfield
Prompt Table: CA_PC_CF_VW |