ACPMHSTHDR – No description in the Lawson data dictionary

System: AC Billing Revenue (BR)
Prefix: PMH
Primary key: OBJ-ID
Fields: 58
Updated by: 2 programs
Referenced by: 5 programs

ACPMHSTHDR is a Lawson AC Billing Revenue table (prefix PMH); no description in the lawson data dictionary. It is indexed by OBJ-ID (PMHSET1); alternate indexes: PMHSET2 and PMHSET3. It is related 1:1 to ACCNTRACT, ACSRVCLOC, ARCOMP, ARCONTACTS, ARCUSTOMER, AROIHDR, ARPROCLEVL, BILLTO and 1 more and 1:M to ACINVAUDIT, ACMNTSCH, ACPMHSTCSL, ACPMHSTDTL and ACPRMSTNX. It is updated by BR123 and BRIP.1 and referenced by BR157, BR252, BR52.1, BR55.1 and BR56.1. The table has 58 fields, 3 indexes and 17 documented relations.

About ACPMHSTHDR

No description in the Lawson data dictionary.

Fields (58)

Column = COBOL field name without the PMH- 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
#`PMH-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.	BRIP.1
#`PMH-COMPANY` SET2 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.	BRIP.1
#`PMH-CUSTOMER` SET2 CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	BRIP.1
#`PMH-INVOICE` SET2 INVOICE	Alpha 22	Used to identify the invoice.	BRIP.1
#`PMH-INVOICE-PREFIX` SET3 INVOICE_PREFIX	Alpha 2	—	BRIP.1
#`PMH-INVOICE-NBR` SET3 INVOICE_NBR	Numeric 8	—	BRIP.1
#`PMH-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	BRIP.1
#`PMH-DUE-DATE` DUE_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	BRIP.1
#`PMH-BILL-TO` BILL_TO	Numeric 4	This field contains the mailing address for the invoice. Bill to addresses are maintained in the Accounts Receviable Bill To form AR09.4.	BRIP.1
#`PMH-CONTRACT` SET2 CONTRACT	Alpha 15	Activity Management contract.	BRIP.1
#`PMH-CONTACT-CODE` CONTACT_CODE	Alpha 5	—	BRIP.1
#`PMH-AR-DETAIL` AR_DETAIL	Alpha 1	— `S` Summary `D` Detail `A` Activity	BRIP.1
#`PMH-INVOICE-TYPE` INVOICE_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. `R` Retainer `I` Invoice `B` Invoice Cancel `C` Auto generated retainer credit `T` Tax `P` Product `M` Maintenance	BRIP.1
#`PMH-INVOICE-DATE` INVOICE_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	BRIP.1
#`PMH-POSTING-DATE` POSTING_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	BRIP.1
#`PMH-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference number associated with the transaction.	BRIP.1
#`PMH-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BRIP.1
#`PMH-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BRIP.1
#`PMH-INVOICE-AMT` INVOICE_AMT	Signed 18.2	—	BRIP.1
#`PMH-UNITS-AMOUNT` UNITS_AMOUNT	Signed 18.2	—	BRIP.1
#`PMH-CUST-PO-NBR` CUST_PO_NBR	Alpha 22	—	BRIP.1
#`PMH-INVC-OPTIONS` INVC_OPTIONS	Alpha 1	— `A` Acct Category `B` Acct Category Class `C` Attribute `D` Resource	BRIP.1
#`PMH-INVC-FORMAT` INVC_FORMAT	Alpha 1	— `S` Standard `C` Custom `F` Fax with Standard `E` EDI with Standard	BRIP.1
#`PMH-RETAIN-ID` RETAIN_ID	Numeric 6	—	BRIP.1
#`PMH-RETAIN-DESC` RETAIN_DESC	Alpha 30	—	BRIP.1
#`PMH-CUM-FLAG` CUM_FLAG	Alpha 1	— `Y` Yes `N` No	BRIP.1
#`PMH-INVC-SUMM-OPT` INVC_SUMM_OPT	Alpha 1	— `D` Detail `S` Summary	BRIP.1
#`PMH-INV-OPTION-2` INV_OPTION_2	Alpha 1	— `A` Acct Category `B` Account Category Class `C` Attribute `D` Resource	BRIP.1
#`PMH-AC-CUSTOMER-ID` SET2 AC_CUSTOMER_ID	Alpha 5	—	BRIP.1
#`PMH-WBS-INVC-NBR` WBS_INVC_NBR	Numeric 8	—	BRIP.1
#`PMH-CUST-NAME` CUST_NAME	Alpha 30 (Lower Case)	—	—
#`PMH-LOCK-BOX` LOCK_BOX	Alpha 2	—	BRIP.1
#`PMH-XREF-NBR` XREF_NBR	Alpha 22	—	BRIP.1
#`PMH-BILL-WBS-CODE` BILL_WBS_CODE	Alpha 3	—	BRIP.1
#`PMH-EXCEED-OPTION` EXCEED_OPTION	Alpha 1	— `I` Include `E` Exclude	BRIP.1
#`PMH-REALIZATION-FL` REALIZATION_FL	Alpha 1	— `Y` Yes `N` No	BRIP.1
#`PMH-WBS-XREF-NBR` WBS_XREF_NBR	Alpha 22	—	—
#`PMH-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `0` Unreleased `1` Released `2` Pending Approval `3` Processed `4` Cancelled `5` Invoice Delete	BR123, BRIP.1
#`PMH-LAST-LINE-NBR` LAST_LINE_NBR	Numeric 6	This field contains the line number.	BRIP.1
#`PMH-USER-NAME` USER_NAME	Alpha 10 (Lower Case)	—	BRIP.1
#`PMH-BILL-TO-GRP` BILL_TO_GRP	Numeric 4	Used to identify a group of AR bill-to addresses used for customer invoicing in the BR system.	BRIP.1
#`PMH-CNT-WBS-CODE` CNT_WBS_CODE	Alpha 3	—	BRIP.1
#`PMH-FEE-EXCEED-OPT` FEE_EXCEED_OPT	Alpha 1	— `I` Include `E` Exclude	BRIP.1
#`PMH-PRE-ADJUST-AMT` PRE_ADJUST_AMT	Signed 18.2	—	BRIP.1
#`PMH-PRE-HOLD-AMT` PRE_HOLD_AMT	Signed 18.2	—	BRIP.1
#`PMH-PRE-BILL-HIST` PRE_BILL_HIST	Signed 18.2	—	BRIP.1
#`PMH-FINAL-INVC-FL` FINAL_INVC_FL	Alpha 1	— `Y` Yes `N` No	BRIP.1
#`PMH-PRE-BIA` PRE_BIA	Signed 18.2	—	—
#`PMH-PRE-XFER` PRE_XFER	Signed 18.2	—	—
#`PMH-TAX-PRINT` TAX_PRINT	Alpha 1	— `M` Multiple sum by code `S` Single Tax Line	BRIP.1
#`PMH-HIST-FLAG` HIST_FLAG	Alpha 1	—	—
#`PMH-JURIS-CODE` JURIS_CODE	Alpha 3	—	BRIP.1
#`PMH-TAX-FLAG` TAX_FLAG	Alpha 1	—	—
#`PMH-INVC-OPTION-3` INVC_OPTION_3	Alpha 1	— `A` Acct Category `B` Acct Category Class `C` Attribute `D` Resource	BRIP.1
#`PMH-INVC-OPTION-4` INVC_OPTION_4	Alpha 1	— `A` Acct Category `B` Acct Category Class `C` Attribute `D` Resource	BRIP.1
#`PMH-INVC-OPTION-5` INVC_OPTION_5	Alpha 1	— `A` Acct Category `B` Acct Category Class `C` Attribute `D` Resource	BRIP.1
#`PMH-TAX-CALC-FLAG` TAX_CALC_FLAG	Alpha 1	This flag determines whether tax will be calculated at a detail level or summary level. If calculated at a detail level, tax amounts will be calculated separately for each invoice line. If calculated at a summary level, taxable amount for a tax code for the whole invoice will be determined, and tax will be calculated on that summarized taxable amount. `1` Detail `2` Summary	BRIP.1
#`PMH-SERVICE-LOC` SERVICE_LOC	Numeric 4	A user defined code identifying a customer's service location.	BRIP.1

Indexes (3)

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	Used in
`PMHSET1`	`OBJ-ID`	Primary	BR123, BR157, BR252, BR52.1, BR56.1, BRIP.1
`PMHSET2`	`CONTRACT` `COMPANY` `CUSTOMER` `AC-CUSTOMER-ID` `INVOICE` `OBJ-ID`	KeyChange	BR55.1
`PMHSET3`	`INVOICE-PREFIX` `INVOICE-NBR` `OBJ-ID`	KeyChange	—

Relations

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

One to one (12) — lookups and parents

Relation Table Rules Condition Field map

Accntract

ACCNTRACT

Not Required

PMH-CONTRACT → CNT-CONTRACT (CNTSET1)

Acsrvcloc

ACSRVCLOC

Not Required

`PMH-COMPANY`	→	`ASV-COMPANY`
`PMH-CUSTOMER`	→	`ASV-CUSTOMER`
`PMH-SERVICE-LOC`	→	`ASV-SERVICE-LOC`

Arcomp

ARCOMP

Not Required

PMH-COMPANY → ACO-COMPANY

Arcontacts

ARCONTACTS

Not Required

`PMH-COMPANY`	→	`CON-COMPANY`
`PMH-CUSTOMER`	→	`CON-CUSTOMER`
`PMH-CONTACT-CODE`	→	`CON-RESP-CODE`

Arcustomer

ARCUSTOMER

Not Required

`PMH-COMPANY`	→	`ACM-COMPANY`
`PMH-CUSTOMER`	→	`ACM-CUSTOMER`

Aroihdr C

AROIHDR

Not Required

`PMH-COMPANY`	→	`ARH-COMPANY`
`"C"`	→	`ARH-TRANS-TYPE`
`PMH-INVOICE`	→	`ARH-INVOICE`

Aroihdr D

AROIHDR

Not Required

`PMH-COMPANY`	→	`ARH-COMPANY`
`"D"`	→	`ARH-TRANS-TYPE`
`PMH-INVOICE`	→	`ARH-INVOICE`

Aroihdr I

AROIHDR

Not Required

`PMH-COMPANY`	→	`ARH-COMPANY`
`"I"`	→	`ARH-TRANS-TYPE`
`PMH-INVOICE`	→	`ARH-INVOICE`

Aroihdr M

AROIHDR

Not Required

`PMH-COMPANY`	→	`ARH-COMPANY`
`"M"`	→	`ARH-TRANS-TYPE`
`PMH-INVOICE`	→	`ARH-INVOICE`

Arproclevl

ARPROCLEVL

Not Required

`PMH-COMPANY`	→	`APV-COMPANY`
`PMH-PROCESS-LEVEL`	→	`APV-PROCESS-LEVEL`

Billto

BILLTO

Not Required

`ACO-CUST-GROUP`	→	`ABS-CUST-GROUP`
`PMH-CUSTOMER`	→	`ABS-CUSTOMER`
`PMH-BILL-TO`	→	`ABS-BILL-TO`

Custdesc

CUSTDESC

Not Required

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

One to many (5) — child tables

Relation Table Rules Condition Field map

Acinvaudit

ACINVAUDIT

`PMH-OBJ-ID`	→	`IVA-OBJ-ID`
—	→	`IVA-LINE-NBR`
—	→	`IVA-TRANS-DATE`
—	→	`IVA-SEQUENCE-NBR`

Acmntsch

ACMNTSCH

`PMH-OBJ-ID`	→	`MSC-PMH-OBJ-ID`
—	→	`MSC-CONTRACT`
—	→	`MSC-MAINT-SCHEDULE`
—	→	`MSC-PRODUCT`
—	→	`MSC-PROD-VERSION`
—	→	`MSC-OBJ-ID`

Acpmhstcsl

ACPMHSTCSL

`PMH-OBJ-ID`	→	`PMC-OBJ-ID`
—	→	`PMC-LINE-NBR`

Acpmhstdtl

ACPMHSTDTL

`PMH-OBJ-ID`	→	`PML-OBJ-ID`
—	→	`PML-LINE-NBR`

Acprmstnx

ACPRMSTNX

`PMH-OBJ-ID`	→	`PMX-PMH-OBJ-ID`
—	→	`PMX-ACTIVITY`
—	→	`PMX-MILESTONE-CAT`
—	→	`PMX-MILESTONE`

Programs

Updated by (2)

BR123 Product Invoice Cancel
BRIP.1 Invoice Print Program

Referenced by (5)

BR157 Maintenance Cancel
BR252 Maintenance Schedule Listing
BR52.1 Maintenance Schedule
BR55.1 Maintenance Invoice Cancellation
BR56.1 Product Invoice Cancellation

ACPMHSTHDR – No description in the Lawson data dictionary

About ACPMHSTHDR

Fields (58) Copy as SQL

Indexes (3)

Relations

One to one (12) — lookups and parents

One to many (5) — child tables

Programs

Updated by (2)

Referenced by (5)

Fields (58)