APSECWTH – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
SWH
Primary key
SEC-WTH-CODE
Fields
9
Updated by
2 programs
Referenced by
10 programs

APSECWTH is a Lawson Accounts Payable table (prefix SWH); no description in the lawson data dictionary. It is indexed by SEC-WTH-CODE (SWHSET1); alternate indexes: SWHSET2. It is related 1:M to APSECWTHRT. It is updated by AP08.1 and AP305 and referenced by AP00.4, AP00.5, AP10.5, AP14.5, AP150, AP170, AP190, AP205 and 2 more. The table has 9 fields, 2 indexes and 1 documented relation.

About APSECWTH

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the SWH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
SWH-SEC-WTH-CODE PK
SEC_WTH_CODE		Alpha 10—AP08.1
SWH-COMPANY
COMPANY		Numeric 4—AP08.1
SWH-WTH-ACCT-UNIT
WTH_ACCT_UNIT		Alpha 15—AP08.1
SWH-WTH-ACCOUNT
WTH_ACCOUNT		Numeric 6—AP08.1
SWH-WTH-SUB-ACCT
WTH_SUB_ACCT		Numeric 4—AP08.1
SWH-WITHHOLD-TYPE
WITHHOLD_TYPE		Numeric 1—
  • 1 Federal
  • 2 State
  • 3 Other
AP08.1
SWH-MIN-PMT-AMT
MIN_PMT_AMT		Signed 18.2—AP08.1
SWH-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1—
  • A Active
  • I Inactive
AP08.1
SWH-USED-FLAG
USED_FLAG		Alpha 1—
  • Y Yes
  • N No
AP08.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SWHSET1SEC-WTH-CODEPrimaryAP00.4, AP00.5, AP08.1, AP14.5, AP150, AP170, AP190, AP205 +2 more
SWHSET2COMPANY, SEC-WTH-CODEKeyChangeAP10.5, AP205, AP305

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
ApsecwthratesAPSECWTHRTDelete CascadesSWH-SEC-WTH-CODE → SWR-SEC-WTH-CODE, → SWR-EFF-DATE

Programs

Updated by (2)

Referenced by (10)