ACPRODHDR – Activity Product Header

System: AC Billing Revenue (BR)
Prefix: AHR
Primary key: CONTRACT
Fields: 38
Updated by: 6 programs
Referenced by: 32 programs

ACPRODHDR is the Activity Product Header table in Lawson AC Billing Revenue (prefix AHR). It is indexed by CONTRACT (AHRSET1). It is related 1:1 to ACACTIVITY, ACCNTRACT, ACCNTRSTAT, ACGLCODE, ACPRODLST, ACREASONCD, ACSRVCLOC, ARCOMP and 1 more and 1:M to ACCNTRCMTX, ACPRMSTN, ACPRMSTNX and ACPRODDTL. It is updated by BR153, BR51.1, BR51.2, BR53.1, BR53.2 and BR570 and referenced by BR02.3, BR10.9, BR120, BR121, BR122, BR123, BR124, BR140 and 24 more. The table has 38 fields, 1 index and 14 documented relations.

About ACPRODHDR

No description in the Lawson data dictionary.

Fields (38)

Column = COBOL field name without the AHR- 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
#`AHR-CONTRACT` PK CONTRACT	Alpha 15	Activity Management contract.	BR51.1, BR570
#`AHR-CONT-STATUS` CONT_STATUS	Alpha 2	—	BR51.1, BR570
#`AHR-PRODUCT-LIST` PRODUCT_LIST	Alpha 10	—	BR51.1, BR570
#`AHR-DISCOUNT-PCT` DISCOUNT_PCT	Signed 8.5	—	BR51.1, BR570
#`AHR-MAINT-PERCENT` MAINT_PERCENT	Signed 7.3	The percentage determines how much retention is held. It can either be a percentage of each invoice, or it can be a percentage of a total.	BR51.1, BR570
#`AHR-LIST-NET-FLAG` LIST_NET_FLAG	Alpha 1	— `1` List `2` Net	BR51.1, BR570
#`AHR-MAINT-PERIOD` MAINT_PERIOD	Numeric 2	This is the current accounting period. This field is updated by Period Closing (GL199).	—
#`AHR-DEFERRED-FL` DEFERRED_FL	Alpha 1	— `Y` Yes `N` No	BR153, BR51.1, BR570
#`AHR-REASON-CODE` REASON_CODE	Alpha 4	This field contains the reason code, which indicates the cause for credit memos.	BR51.1, BR570
#`AHR-MAINT-SCHEDULE` MAINT_SCHEDULE	Alpha 15	—	BR51.1, BR570
#`AHR-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	BR51.1, BR570
#`AHR-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `0` Unreleased `1` Released	BR51.1, BR51.2, BR570
#`AHR-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	BR51.1, BR570
#`AHR-CONT-DATE` CONT_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	BR51.1, BR570
#`AHR-BEGIN-DATE` BEGIN_DATE	Numeric 8 (yyyymmdd)	The begin date for this effort period.	BR51.1, BR570
#`AHR-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	The end date for this effort period.	BR51.1, BR570
#`AHR-LIST-PRICE` LIST_PRICE	Signed 18.2	—	BR51.1, BR570
#`AHR-NET-PRICE` NET_PRICE	Signed 18.2	—	BR51.1, BR570
#`AHR-FREE-MAINT` FREE_MAINT	Signed 18.2	—	BR51.1, BR570
#`AHR-DEFERRED-AMT` DEFERRED_AMT	Signed 18.2	—	BR53.1, BR53.2, BR570
#`AHR-OPERATOR` OPERATOR	Alpha 10	This field is used to store the login id of the person who entered the record.	BR51.1, BR51.2, BR570
#`AHR-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BR51.1, BR51.2, BR570
#`AHR-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BR51.1, BR51.2, BR570
#`AHR-DFLT-COMPANY` DFLT_COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	BR51.1, BR570
#`AHR-DFLT-ACCT-UNIT` DFLT_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	BR51.1, BR570
#`AHR-BILL-ACCT-CAT` BILL_ACCT_CAT	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	BR51.1, BR570
#`AHR-BILL-GL-CD` BILL_GL_CD	Alpha 4	—	BR51.1, BR570
#`AHR-BILL-ACCOUNT` BILL_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	BR51.1, BR570
#`AHR-BILL-SUB-ACCT` BILL_SUB_ACCT	Numeric 4	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	BR51.1, BR570
#`AHR-UNBL-ACCT-CAT` UNBL_ACCT_CAT	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	BR51.1, BR570
#`AHR-UNBL-GL-CD` UNBL_GL_CD	Alpha 4	—	BR51.1, BR570
#`AHR-UNBL-ACCOUNT` UNBL_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	BR51.1, BR570
#`AHR-UNBL-SUB-ACCT` UNBL_SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	BR51.1, BR570
#`AHR-SERVICE-LOC` SERVICE_LOC	Numeric 4	A user defined code identifying a customer's service location.	BR51.1, BR570
#`AHR-CUST-NAME` CUST_NAME	Derived	—	—
#`AHR-NET-PROD-REV` NET_PROD_REV	Derived	—	—
#`AHR-ACTUAL-PRICE` ACTUAL_PRICE	Signed 18.2	—	BR51.1, BR570
#`AHR-INV-NET-PRICE` INV_NET_PRICE	Signed 18.2	—	BR51.1, BR570

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
`AHRSET1`	`CONTRACT`	Primary		BR02.3, BR10.9, BR120, BR121, BR122, BR123, BR124, BR140 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (10) — lookups and parents

Relation Table Rules Condition Field map

Acactivity

ACACTIVITY

Required

AHR-ACTIVITY → ACV-ACTIVITY

Accntract

ACCNTRACT

Required

AHR-CONTRACT → CNT-CONTRACT

Accntrstat

ACCNTRSTAT

Not Required

AHR-CONT-STATUS → CSB-CONT-STATUS

Acglcode Bill

ACGLCODE

Not Required

AHR-BILL-GL-CD → AGC-AC-GL-CODE

Acglcode Unbl

ACGLCODE

Not Required

AHR-UNBL-GL-CD → AGC-AC-GL-CODE

Acprodlst

ACPRODLST

Required

AHR-PRODUCT-LIST → BRP-PRODUCT-LIST

Acreasoncd

ACREASONCD

Not Required

AHR-REASON-CODE → CDE-REASON-CODE

Acsrvcloc

ACSRVCLOC

Not Required

`CNT-COMPANY`	→	`ASV-COMPANY`
`CNT-CUSTOMER`	→	`ASV-CUSTOMER`
`AHR-SERVICE-LOC`	→	`ASV-SERVICE-LOC`

Arcomp

ARCOMP

Required

CNT-COMPANY → ACO-COMPANY

Custdesc

CUSTDESC

Required

`ACO-CUST-GROUP`	→	`CUD-CUST-GROUP`
`CNT-CUSTOMER`	→	`CUD-CUSTOMER`

One to many (4) — child tables

Relation Table Rules Condition Field map

Accntrcmtx

ACCNTRCMTX

`AHR-CONTRACT`	→	`CXM-CONTRACT`
`Spaces`	→	`CXM-MAINT-SCHEDULE`
`Spaces`	→	`CXM-PRODUCT`
`Spaces`	→	`CXM-PROD-VERSION`
—	→	`CXM-OBJ-ID`
—	→	`CXM-COMMENT-TYPE`
—	→	`CXM-DATE`
—	→	`CXM-SEQ-NBR`

Acprmstn

ACPRMSTN

`CNT-ACTIVITY`	→	`PMS-ACTIVITY`
—	→	`PMS-MILESTONE-CAT`

Acprmstnx

ACPRMSTNX

`CNT-ACTIVITY`	→	`PMX-ACTIVITY`
—	→	`PMX-MILESTONE-CAT`
—	→	`PMX-MILESTONE`

Acproddtl

ACPRODDTL

`AHR-CONTRACT`	→	`AHD-CONTRACT`
—	→	`AHD-PRODUCT`
—	→	`AHD-PROD-VERSION`
—	→	`AHD-OBJ-ID`

Programs

Updated by (6)

BR153 Product Revenue Calculation
BR51.1 Product Contract
BR51.2 Product Cost of Goods Sold
BR53.1 Product Deferred Revenue Schedule
BR53.2 Product Deferred Revenue Auto Scheduler
BR570 Product Contract Interface

Referenced by (32)

BR02.3 Retainer Invoice Entry
BR10.9 Product Contract Parameters
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR122 Online batch invoice process
BR123 Product Invoice Cancel
BR124 Deferred Revenue Adjustment
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
BR251 Product Contract Listing
BR253 Deferred Revenue Listing
BR30.1 Contract Status
BR31.1 Product Contract Comments
BR31.2 Product Detail Comments
BR31.4 Maintenance Product Comments
BR420 Billing Invoice Report
BR50.3 Define Product List
BR52.4 Renew All
BR521 Billing Import
BR54.1 Product Billing Milestones
BR54.2 Days Product Billing Milestones
BR54.3 Date Product Billing Milestones
BR54.4 Manual Product Billing Milestones
BR70.1 Product Contract Interface Adjustment
BRIP.1 Invoice Print Program

ACPRODHDR – Activity Product Header

About ACPRODHDR

Fields (38) Copy as SQL

Indexes (1)

Relations

One to one (10) — lookups and parents

One to many (4) — child tables

Programs

Updated by (6)

Referenced by (32)

Fields (38)