ACPRODINV – Product Invoice Cancellation
- System
- AC Billing Revenue (BR)
- Prefix
PDI- Primary key
CONTRACT,OBJ-ID- Fields
- 2
- Updated by
- 2 programs
- Referenced by
- 16 programs
ACPRODINV is the Product Invoice Cancellation table in Lawson AC Billing Revenue (prefix PDI). It is indexed by CONTRACT, OBJ-ID (PDISET1). It is related 1:1 to ACCNTRACT. It is updated by BR123 and BRIP.1 and referenced by BR02.3, BR120, BR121, BR122, BR140, BR151, BR152, BR156 and 8 more. The table has 2 fields, 1 index and 1 documented relation.
About ACPRODINV
No description in the Lawson data dictionary.
Fields (2)
Column = COBOL field name without the PDI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PDI-CONTRACT PKCONTRACT | Alpha 15 | Activity Management contract. | BRIP.1 |
#PDI-OBJ-ID PKOBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | BRIP.1 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PDISET1 |
| Primary | BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +10 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Accntract | ACCNTRACT | Required |
|
Programs
Updated by (2)
Referenced by (16)
- BR02.3 Retainer Invoice Entry
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR122 Online batch invoice process
- BR140 Billing and Revenue Backout
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR156 Maintenance Quote
- BR20.1 Invoice Edit Contract
- BR20.2 Invoice Edit Line
- BR20.3 Invoice Edit Activity
- BR20.4 Invoice Edit Activity and Account Category
- BR20.5 Invoice Edit Transaction
- BR420 Billing Invoice Report
- BR521 Billing Import
- BR56.1 Product Invoice Cancellation