Public Sector Management :: Fund Accounting | |||||||
Product | Version | Table | Columns | Indexes | Description | Module | |
---|---|---|---|---|---|---|---|
1 | ERP EHP7 | 6.0 | FMCCAVCP | 89 | 5 | Plan line items table | Fund Accounting |
Name | Primary | Unique | Type | Columns |
---|---|---|---|---|
FMCCAVCP~0 | Yes | Yes | CLUSTERED | GL_SIRID, RCLNT |
FMCCAVCP~1 | No | No | NONCLUSTERED | RACCT, RYEAR, RBUKRS, RLDNR |
FMCCAVCP~2 | No | Yes | NONCLUSTERED | RPMAX, DOCLN, RLDNR, RBUKRS, DOCCT, RYEAR, DOCNR, RCLNT |
FMCCAVCP~3 | No | No | NONCLUSTERED | REFDOCLN, RLDNR, RBUKRS, REFDOCCT, REFRYEAR, REFDOCNR, RCLNT |
FMCCAVCP~4 | No | No | NONCLUSTERED | RACCT |