Public Sector Management :: Funds Management :: Budget Control System :: Availability Control | |||||||
Product | Version | Table | Columns | Indexes | Description | Module | |
---|---|---|---|---|---|---|---|
1 | ERP EHP7 | 6.0 | FMAVCP | 99 | 4 | Plan line items table | Availability Control |
Name | Primary | Unique | Type | Columns |
---|---|---|---|---|
FMAVCP~0 | Yes | Yes | CLUSTERED | GL_SIRID, RCLNT |
FMAVCP~1 | No | No | NONCLUSTERED | RYEAR, RFIKRS, RLDNR |
FMAVCP~2 | No | Yes | NONCLUSTERED | RPMAX, DOCLN, RLDNR, RFIKRS, DOCCT, RYEAR, DOCNR, RCLNT |
FMAVCP~3 | No | No | NONCLUSTERED | REFDOCLN, RLDNR, RFIKRS, REFDOCCT, REFRYEAR, REFDOCNR, RCLNT |