ACPRODDTL – Activity Product Detail

System: AC Billing Revenue (BR)
Prefix: AHD
Primary key: CONTRACT, OBJ-ID
Fields: 53
Updated by: 6 programs
Referenced by: 25 programs

ACPRODDTL is the Activity Product Detail table in Lawson AC Billing Revenue (prefix AHD). It is indexed by CONTRACT, OBJ-ID (AHDSET1); alternate indexes: AHDSET2. It is related 1:1 to ACCNTRACT, ACGLCODE, ACPRODHDR, ACPRODLSTX and ACREASONCD and 1:M to ACCNTRCMTX, ACDEFREV, ACPRODTAX and ACPRODUSER. 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, BR140, BR151 and 17 more. The table has 53 fields, 2 indexes and 11 documented relations.

About ACPRODDTL

No description in the Lawson data dictionary.

Fields (53)

Column = COBOL field name without the AHD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`AHD-CONTRACT` PK CONTRACT	Alpha 15	Activity Management contract.	BR51.1, BR570
`AHD-OBJ-ID` PK 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.	BR51.1, BR570
`AHD-PRODUCT` PRODUCT	Alpha 15	—	BR51.1, BR570
`AHD-PROD-VERSION` PROD_VERSION	Alpha 10	—	BR51.1, BR570
`AHD-EFFECTIVE-DT` EFFECTIVE_DT	Numeric 8 (yyyymmdd)	The effective date is the date the record is first valid.	BR51.1, BR570
`AHD-USERS` USERS	Numeric 12	—	BR51.1, BR570
`AHD-LIST-PRICE` LIST_PRICE	Signed 18.2	—	BR51.1, BR570
`AHD-DISCOUNT-AMT` DISCOUNT_AMT	Signed 18.2	—	BR51.1
`AHD-NET-PRICE` NET_PRICE	Signed 18.2	—	BR51.1
`AHD-FREE-MAINT` FREE_MAINT	Signed 18.2	—	BR51.1, BR570
`AHD-SHIP-DATE` SHIP_DATE	Numeric 8 (yyyymmdd)	This field contains the ship date. If left blank, the system date defaults.	BR51.1, BR570
`AHD-ANT-SHIP-DATE` ANT_SHIP_DATE	Numeric 8 (yyyymmdd)	This field contains the ship date. If left blank, the system date defaults.	BR51.1, BR570
`AHD-DEFERRED-FL` DEFERRED_FL	Alpha 1	— `Y` Yes `N` No `X` Not Shipped	BR153, BR51.1, BR570
`AHD-DEFERRED-AMT` DEFERRED_AMT	Signed 18.2	—	BR153, BR51.1, BR53.1, BR53.2, BR570
`AHD-REASON-CODE` REASON_CODE	Alpha 4	This field contains the reason code, which indicates the cause for credit memos.	BR51.1, BR570
`AHD-TOT-REV-AMT` TOT_REV_AMT	Signed 18.2	—	BR153, BR570
`AHD-DISCOUNT-PCT` DISCOUNT_PCT	Signed 8.5	—	BR51.1, BR570
`AHD-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
`AHD-LIST-NET-FLAG` LIST_NET_FLAG	Alpha 1	— `1` List `2` Net	BR51.1, BR570
`AHD-MAINT-PERIOD` MAINT_PERIOD	Numeric 2	This is the current accounting period. This field is updated by Period Closing (GL199).	BR570
`AHD-INCLUDE-BASE` INCLUDE_BASE	Alpha 1	— `Y` Yes `N` No	BR51.1, BR570
`AHD-REV-ACCT-CAT` REV_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
`AHD-REV-GL-CD` REV_GL_CD	Alpha 4	—	BR51.1, BR570
`AHD-REV-ACCOUNT` REV_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
`AHD-REV-SUB-ACCT` REV_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
`AHD-COST-BASIS-FL` COST_BASIS_FL	Alpha 1	—	BR570
`AHD-TOTAL-COST` TOTAL_COST	Signed 18.2	—	BR51.1, BR51.2, BR570
`AHD-PREV-EXP-AMT` PREV_EXP_AMT	Signed 18.2	—	BR153, BR570
`AHD-CGSL-ACCT-CAT` CGSL_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, BR51.2, BR570
`AHD-CGSL-GL-CD` CGSL_GL_CD	Alpha 4	—	BR51.1, BR51.2, BR570
`AHD-CGSL-ACCOUNT` CGSL_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, BR51.2, BR570
`AHD-CGSL-SUB-ACCT` CGSL_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, BR51.2, BR570
`AHD-CGSX-ACCT-CAT` CGSX_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, BR51.2, BR570
`AHD-CGSX-GL-CD` CGSX_GL_CD	Alpha 4	—	BR51.1, BR51.2, BR570
`AHD-CGSX-ACCOUNT` CGSX_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, BR51.2, BR570
`AHD-CGSX-SUB-ACCT` CGSX_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, BR51.2, BR570
`AHD-LAST-SEQ-NBR` LAST_SEQ_NBR	Numeric 6	Identifies the last sequence number used. Ensures the record is unique.	—
`AHD-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	Code indicating the taxing status. E - Exempt, T - Taxable.	BR570
`AHD-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
`AHD-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
`AHD-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
`AHD-REVENUE-FLAG` REVENUE_FLAG	Alpha 1	This flag identifies whether an activity/account category is eligible for revenue recognition.	BR153, BR51.1, BR51.2, BR570
`AHD-USER-FIELD1` USER_FIELD1	Alpha 15 (Lower Case)	—	BR51.1, BR51.2, BR570
`AHD-USER-FIELD2` USER_FIELD2	Alpha 15 (Lower Case)	—	BR51.1, BR51.2, BR570
`AHD-USER-FIELD3` USER_FIELD3	Alpha 15 (Lower Case)	—	BR51.1, BR51.2, BR570
`AHD-SITE-LOCATION` SITE_LOCATION	Numeric 2	—	BR51.1, BR51.2, BR570
`AHD-INV-NET-PRICE` INV_NET_PRICE	Signed 18.2	—	BR51.1, BR570
`AHD-SUITE` SUITE	Alpha 6	—	BR51.1, BR570
`AHD-ACTUAL-PRICE` ACTUAL_PRICE	Signed 18.2	—	BR51.1, BR570
`AHD-NET-PROD-REV` NET_PROD_REV	Derived	—	—
`AHD-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	BR51.1, BR570
`AHD-TOT-DEF-AMT` TOT_DEF_AMT	Signed 18.2	—	BR51.1, BR53.1, BR53.2, BR570
`AHD-DELIV-METHOD` DELIV_METHOD	Alpha 1	— `S` Shipped `H` Hosted at `E` Electronic `L` Loaded `1` Method 1 `2` Method 2 `3` Method 3	BR51.1, BR570

Indexes (2)

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
`AHDSET1`	`CONTRACT`, `OBJ-ID`	Primary		BR02.3, BR10.9, BR120, BR121, BR122, BR123, BR140, BR151 +21 more
`AHDSET2`	`CONTRACT`, `PRODUCT`, `PROD-VERSION`, `OBJ-ID`	KeyChange		BR153, BR251, BR253, BR31.2, BR51.1, BR51.2, BR53.1, BR53.2 +1 more

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Field map
Accntract	ACCNTRACT	Required	`AHD-CONTRACT` → `CNT-CONTRACT`
Acglcode Cgsl	ACGLCODE	Not Required	`AHD-CGSL-GL-CD` → `AGC-AC-GL-CODE`
Acglcode Cgsx	ACGLCODE	Not Required	`AHD-CGSX-GL-CD` → `AGC-AC-GL-CODE`
Acglcode Rev	ACGLCODE	Not Required	`AHD-REV-GL-CD` → `AGC-AC-GL-CODE`
Acprodhdr	ACPRODHDR	Required	`AHD-CONTRACT` → `AHR-CONTRACT`
Acprodlstx	ACPRODLSTX	Required	`AHR-PRODUCT-LIST` → `BRQ-PRODUCT-LIST`, `AHD-PRODUCT` → `BRQ-PRODUCT`, `AHD-PROD-VERSION` → `BRQ-PROD-VERSION`
Acreasoncd	ACREASONCD	Not Required	`AHD-REASON-CODE` → `CDE-REASON-CODE`

One to many (4) — child tables

Relation	Table	Field map
Accntrcmtx	ACCNTRCMTX	`AHD-CONTRACT` → `CXM-CONTRACT`, `Spaces` → `CXM-MAINT-SCHEDULE`, `AHD-PRODUCT` → `CXM-PRODUCT`, `AHD-PROD-VERSION` → `CXM-PROD-VERSION`, `AHD-OBJ-ID` → `CXM-OBJ-ID`, → `CXM-COMMENT-TYPE`, → `CXM-DATE`, → `CXM-SEQ-NBR`
Acdefrev	ACDEFREV	`AHD-CONTRACT` → `DRD-CONTRACT`, `AHD-PRODUCT` → `DRD-PRODUCT`, `AHD-PROD-VERSION` → `DRD-PROD-VERSION`, `AHD-OBJ-ID` → `DRD-OBJ-ID`, → `DRD-SEQ-NBR`
Acprodtax	ACPRODTAX	`AHD-REV-ACCT-CAT` → `BTX-TAX-ACCT-CAT`, `AHD-DELIV-METHOD` → `BTX-DELIV-METHOD`, → `BTX-EFFECTIVE-DATE`
Acproduser	ACPRODUSER	`AHR-PRODUCT-LIST` → `BRU-PRODUCT-LIST`, `AHD-PRODUCT` → `BRU-PRODUCT`, `AHD-PROD-VERSION` → `BRU-PROD-VERSION`, `AHD-EFFECTIVE-DT` → `BRU-EFFECTIVE-DT`, → `BRU-RECORD-TYPE`, → `BRU-MAX-USERS`

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 (25)

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
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
BR31.2 Product Detail Comments
BR420 Billing Invoice Report
BR52.4 Renew All
BR521 Billing Import
BR54.2 Days Product Billing Milestones
BR54.3 Date Product Billing Milestones
BR54.4 Manual Product Billing Milestones
BRIP.1 Invoice Print Program