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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#AHD-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR51.1, BR570
#AHD-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.BR51.1, BR570
#AHD-PRODUCT SET2
PRODUCT		Alpha 15—BR51.1, BR570
#AHD-PROD-VERSION SET2
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 4This 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.3The 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 2This 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 5Account 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 thruBR51.1, BR570
#AHD-REV-GL-CD
REV_GL_CD		Alpha 4—BR51.1, BR570
#AHD-REV-ACCOUNT
REV_ACCOUNT		Numeric 6This 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 4This 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 5Account 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 thruBR51.1, BR51.2, BR570
#AHD-CGSL-GL-CD
CGSL_GL_CD		Alpha 4—BR51.1, BR51.2, BR570
#AHD-CGSL-ACCOUNT
CGSL_ACCOUNT		Numeric 6This 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 4This 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 5Account 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 thruBR51.1, BR51.2, BR570
#AHD-CGSX-GL-CD
CGSX_GL_CD		Alpha 4—BR51.1, BR51.2, BR570
#AHD-CGSX-ACCOUNT
CGSX_ACCOUNT		Numeric 6This 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 4This 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 6Identifies the last sequence number used. Ensures the record is unique.—
#AHD-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1Code indicating the taxing status. E - Exempt, T - Taxable.BR570
#AHD-OPERATOR
OPERATOR		Alpha 10This 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 1This 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AHDSET1
  1. CONTRACT
  2. OBJ-ID
PrimaryBR02.3, BR10.9, BR120, BR121, BR122, BR123, BR140, BR151 +21 more
AHDSET2
  1. CONTRACT
  2. PRODUCT
  3. PROD-VERSION
  4. OBJ-ID
KeyChangeBR153, BR251, BR253, BR31.2, BR51.1, BR51.2, BR53.1, BR53.2 +1 more

Relations

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

One to one (7) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTRequired
AHD-CONTRACT→CNT-CONTRACT
Acglcode CgslACGLCODENot Required
AHD-CGSL-GL-CD→AGC-AC-GL-CODE
Acglcode CgsxACGLCODENot Required
AHD-CGSX-GL-CD→AGC-AC-GL-CODE
Acglcode RevACGLCODENot Required
AHD-REV-GL-CD→AGC-AC-GL-CODE
AcprodhdrACPRODHDRRequired
AHD-CONTRACT→AHR-CONTRACT
AcprodlstxACPRODLSTXRequired
AHR-PRODUCT-LIST→BRQ-PRODUCT-LIST
AHD-PRODUCT→BRQ-PRODUCT
AHD-PROD-VERSION→BRQ-PROD-VERSION
AcreasoncdACREASONCDNot Required
AHD-REASON-CODE→CDE-REASON-CODE

One to many (4) — child tables

RelationTableRulesConditionField map
AccntrcmtxACCNTRCMTX
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
AcdefrevACDEFREV
AHD-CONTRACT→DRD-CONTRACT
AHD-PRODUCT→DRD-PRODUCT
AHD-PROD-VERSION→DRD-PROD-VERSION
AHD-OBJ-ID→DRD-OBJ-ID
—→DRD-SEQ-NBR
AcprodtaxACPRODTAX
AHD-REV-ACCT-CAT→BTX-TAX-ACCT-CAT
AHD-DELIV-METHOD→BTX-DELIV-METHOD
—→BTX-EFFECTIVE-DATE
AcproduserACPRODUSER
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)

Referenced by (25)