SETIDREG_LEDGERFIELDNUMREG_LEDGER_CFS(SQL Table) |
Index Back |
|---|---|
Regulatory Ledger ChartFieldsDefines the external ChartFields used by the Regulatory Ledger. The FIELDNUM value is used to associate the external CF with its respective CF_NAMEx field on the REG_LEDGER_DATA table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | REG_LEDGER |
Character(20) | VARCHAR2(20) NOT NULL | Regulatory Ledger ID |
| 3 | FIELDNUM |
Number(4,0) | SMALLINT NOT NULL | Field Number |
| 4 | REG_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | External ChartField used in a Regulatory Ledger |