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.

Field / columnTypeDescription & valuesUpdated by
PDI-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BRIP.1
PDI-OBJ-ID PK
OBJ_ID		Numeric 12This 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PDISET1CONTRACT, OBJ-IDPrimaryBR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +10 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTRequiredPDI-CONTRACT → CNT-CONTRACT

Programs

Updated by (2)

Referenced by (16)