ACPROFORMA – No description in the Lawson data dictionary
- System
- AC Billing Revenue (BR)
- Prefix
ATI- Primary key
INVOICE-TYPE,CONTRACT,DUE-DATE,MAINT-SCHEDULE- Fields
- 7
- Updated by
- 5 programs
- Referenced by
- 18 programs
ACPROFORMA is a Lawson AC Billing Revenue table (prefix ATI); no description in the lawson data dictionary. It is indexed by INVOICE-TYPE, CONTRACT, DUE-DATE, MAINT-SCHEDULE (ATISET1). It is updated by BR52.1, BR54.2, BR54.3, BR54.4 and BRIP.1 and referenced by BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 and 10 more. The table has 7 fields, 1 index and 0 documented relations.
About ACPROFORMA
No description in the Lawson data dictionary.
Fields (7)
Column = COBOL field name without the ATI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ATI-INVOICE-TYPE PKINVOICE_TYPE | Alpha 1 | THis field will be filled in from the Invoice based on PO number. This is a carrier for the field. The PORECEIVE file will have to be updated with this field.
| BRIP.1 |
ATI-CONTRACT PKCONTRACT | Alpha 15 | Activity Management contract. | BRIP.1 |
ATI-DUE-DATE PKDUE_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | BRIP.1 |
ATI-MAINT-SCHEDULE PKMAINT_SCHEDULE | Alpha 15 | — | BRIP.1 |
ATI-INVOICE-PREFIXINVOICE_PREFIX | Alpha 2 | — | BRIP.1 |
ATI-INVOICE-NBRINVOICE_NBR | Numeric 8 | — | BRIP.1 |
ATI-HIH-OBJ-IDHIH_OBJ_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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ATISET1 | INVOICE-TYPE, CONTRACT, DUE-DATE, MAINT-SCHEDULE | Primary | BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +15 more |
Programs
Updated by (5)
- BR52.1 Maintenance Schedule
- BR54.2 Days Product Billing Milestones
- BR54.3 Date Product Billing Milestones
- BR54.4 Manual Product Billing Milestones
- BRIP.1 Invoice Print Program
Referenced by (18)
- BR02.3 Retainer Invoice Entry
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR122 Online batch invoice process
- BR123 Product Invoice Cancel
- BR140 Billing and Revenue Backout
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR156 Maintenance Quote
- BR157 Maintenance Cancel
- 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
- BR252 Maintenance Schedule Listing
- BR420 Billing Invoice Report
- BR521 Billing Import