APSECWTHRT – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
SWR- Primary key
SEC-WTH-CODE,EFF-DATE- Fields
- 3
- Updated by
- 2 programs
- Referenced by
- 2 programs
APSECWTHRT is a Lawson Accounts Payable table (prefix SWR); no description in the lawson data dictionary. It is indexed by SEC-WTH-CODE, EFF-DATE (SWRSET1). It is related 1:1 to APSECWTH. It is updated by AP08.1 and AP305 and referenced by AP150 and AP205. The table has 3 fields, 1 index and 1 documented relation.
About APSECWTHRT
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the SWR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
SWR-SEC-WTH-CODE PKSEC_WTH_CODE | Alpha 10 | — | AP08.1 |
SWR-EFF-DATE PKEFF_DATE | Numeric 8 (yyyymmdd) | — | AP08.1 |
SWR-WITHHOLD-PCTWITHHOLD_PCT | Percent 5.3 (Percent) | — | AP08.1 |
Indexes (1)
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 |
|---|---|---|---|---|
SWRSET1 | SEC-WTH-CODE, EFF-DATE* | Primary | AP08.1, AP150, AP205, AP305 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apsecwth | APSECWTH | Required | SWR-SEC-WTH-CODE → SWH-SEC-WTH-CODE |