HMCF_ACCT_FIND(SQL Table) |
Index Back |
|---|---|
HMCF_ACCT_FINDUsed to receive key values when transferring ChartFileds common component. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(25) | VARCHAR2(25) NOT NULL |
Code
Prompt Table: %EDITTABLE2 |
|
| 2 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
| 3 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 4 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
| 5 | Date(10) | DATE |
Accounting Date
Default Value: %date |
|
| 6 | Character(1) | VARCHAR2(1) NOT NULL |
Read Only
Y/N Table Edit Default Value: N |
|
| 7 | Character(35) | VARCHAR2(35) NOT NULL | Title | |
| 8 | Character(1) | VARCHAR2(1) NOT NULL |
Stop Finacials Message
Y/N Table Edit Default Value: N |
|
| 9 | Character(1) | VARCHAR2(1) NOT NULL |
Use Combo Code
Y/N Table Edit Default Value: Y |
|
| 10 | Character(1) | VARCHAR2(1) NOT NULL |
Use Valid GL Combination
Y/N Table Edit Default Value: Y |
|
| 11 | Character(1) | VARCHAR2(1) NOT NULL |
Use Speed Types
Y/N Table Edit Default Value: Y |
|
| 12 | Character(10) | VARCHAR2(10) NOT NULL | Account |