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.

Field / columnTypeDescription & valuesUpdated by
AHR-CONTRACT PK
CONTRACT		Alpha 15Activity 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.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
AHR-LIST-NET-FLAG
LIST_NET_FLAG		Alpha 1—
  • 1 List
  • 2 Net
BR51.1, BR570
AHR-MAINT-PERIOD
MAINT_PERIOD		Numeric 2This 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 4This 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 1This field displays the status of the transaction.
  • 0 Unreleased
  • 1 Released
BR51.1, BR51.2, BR570
AHR-ACTIVITY
ACTIVITY		Alpha 15Activities 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 10This 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 4Identifies 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 15The 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 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
AHR-BILL-GL-CD
BILL_GL_CD		Alpha 4—BR51.1, BR570
AHR-BILL-ACCOUNT
BILL_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
AHR-BILL-SUB-ACCT
BILL_SUB_ACCT		Numeric 4This 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 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
AHR-UNBL-GL-CD
UNBL_GL_CD		Alpha 4—BR51.1, BR570
AHR-UNBL-ACCOUNT
UNBL_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
AHR-UNBL-SUB-ACCT
UNBL_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
AHR-SERVICE-LOC
SERVICE_LOC		Numeric 4A 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AHRSET1CONTRACTPrimaryBR02.3, BR10.9, BR120, BR121, BR122, BR123, BR124, BR140 +22 more (list truncated in source)

Relations

One to one (10) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequiredAHR-ACTIVITY → ACV-ACTIVITY
AccntractACCNTRACTRequiredAHR-CONTRACT → CNT-CONTRACT
AccntrstatACCNTRSTATNot RequiredAHR-CONT-STATUS → CSB-CONT-STATUS
Acglcode BillACGLCODENot RequiredAHR-BILL-GL-CD → AGC-AC-GL-CODE
Acglcode UnblACGLCODENot RequiredAHR-UNBL-GL-CD → AGC-AC-GL-CODE
AcprodlstACPRODLSTRequiredAHR-PRODUCT-LIST → BRP-PRODUCT-LIST
AcreasoncdACREASONCDNot RequiredAHR-REASON-CODE → CDE-REASON-CODE
AcsrvclocACSRVCLOCNot RequiredCNT-COMPANY → ASV-COMPANY, CNT-CUSTOMER → ASV-CUSTOMER, AHR-SERVICE-LOC → ASV-SERVICE-LOC
ArcompARCOMPRequiredCNT-COMPANY → ACO-COMPANY
CustdescCUSTDESCRequiredACO-CUST-GROUP → CUD-CUST-GROUP, CNT-CUSTOMER → CUD-CUSTOMER

One to many (4) — child tables

RelationTableRulesConditionField map
AccntrcmtxACCNTRCMTXAHR-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
AcprmstnACPRMSTNCNT-ACTIVITY → PMS-ACTIVITY, → PMS-MILESTONE-CAT
AcprmstnxACPRMSTNXCNT-ACTIVITY → PMX-ACTIVITY, → PMX-MILESTONE-CAT, → PMX-MILESTONE
AcproddtlACPRODDTLAHR-CONTRACT → AHD-CONTRACT, → AHD-PRODUCT, → AHD-PROD-VERSION, → AHD-OBJ-ID

Programs

Updated by (6)

Referenced by (32)