ACPMHSTTAX – No description in the Lawson data dictionary
- System
- AC Billing Revenue (BR)
- Prefix
PHT- Primary key
OBJ-ID,PML-LINE-NBR,SEQ-NBR- Fields
- 8
- Updated by
- 1 program
- Referenced by
- 0 programs
ACPMHSTTAX is a Lawson AC Billing Revenue table (prefix PHT); no description in the lawson data dictionary. It is indexed by OBJ-ID, PML-LINE-NBR, SEQ-NBR (PHTSET1). It is related 1:1 to ACPMHSTDTL and ACPMHSTHDR. It is updated by BRIP.1. The table has 8 fields, 1 index and 2 documented relations.
About ACPMHSTTAX
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the PHT- 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 |
|---|---|---|---|
#PHT-OBJ-ID PKOBJ_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 |
#PHT-PML-LINE-NBR PKPML_LINE_NBR | Numeric 6 | This field contains the line number. | BRIP.1 |
#PHT-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | BRIP.1 |
#PHT-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | BRIP.1 |
#PHT-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | BRIP.1 |
#PHT-TAX-RATETAX_RATE | Percent 7.5 (Percent) | The tax rate defined for the tax code. | BRIP.1 |
#PHT-TAX-AMTTAX_AMT | Signed 18.2 | — | BRIP.1 |
#PHT-TAX-LEVELTAX_LEVEL | Alpha 1 | — | BRIP.1 |
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 |
|---|---|---|---|---|
PHTSET1 |
| Primary | BRIP.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Acpmhstdtl | ACPMHSTDTL | Not Required |
| |||||||
| Acpmhsthdr | ACPMHSTHDR | Required |
|
Programs
Updated by (1)
- BRIP.1 Invoice Print Program