ERP 6.0 | PCRRETAILA TABLE
Financial Accounting :: Retail Ledger | |||||||
Product | Version | Table | Columns | Indexes | Description | Module | |
---|---|---|---|---|---|---|---|
1 | ERP EHP7 | 6.0 | PCRRETAILA | 44 | 6 | Actual line item table | Retail Ledger |
ERP 6.0 | PCRRETAILA COLUMNS
ERP 6.0 | PCRRETAILA INDEXES
Name | Primary | Unique | Type | Columns |
---|---|---|---|---|
PCRRETAILA~0 | Yes | Yes | CLUSTERED | GL_SIRID, RCLNT |
PCRRETAILA~1 | No | No | NONCLUSTERED | POPER, RACCT, RYEAR, RBUKRS, RLDNR |
PCRRETAILA~2 | No | Yes | NONCLUSTERED | DOCLN, RLDNR, RBUKRS, DOCCT, RYEAR, DOCNR, RCLNT |
PCRRETAILA~3 | No | No | NONCLUSTERED | REFDOCLN, RLDNR, RBUKRS, REFDOCCT, REFRYEAR, REFDOCNR, RCLNT |
PCRRETAILA~4 | No | No | NONCLUSTERED | RCNTR, RACCT |
PCRRETAILA~5 | No | No | NONCLUSTERED | RPRCTR, RACCT |