APDISACSTA – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
ADA
Primary key
ACCT-STRCT, DIST-COMPANY, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT, UNIQUE-I-D
Fields
6
Updated by
1 program
Referenced by
2 programs

APDISACSTA is a Lawson Accounts Payable table (prefix ADA); no description in the lawson data dictionary. It is indexed by ACCT-STRCT, DIST-COMPANY, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT, UNIQUE-I-D (ADASET1); alternate indexes: ADAUID. It is related 1:1 to GLSYSTEM. It is updated by AP00.7 and referenced by AP175 and AP200. The table has 6 fields, 2 indexes and 1 documented relation.

About APDISACSTA

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the ADA- 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 / columnTypeDescription & valuesUpdated by
#ADA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#ADA-ACCT-STRCT PK
ACCT_STRCT		Alpha 15—AP00.7
#ADA-DIST-COMPANY PK
DIST_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.AP00.7
#ADA-DIS-ACCT-UNIT PK
DIS_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.AP00.7
#ADA-DIS-ACCOUNT PK
DIS_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP00.7
#ADA-DIS-SUB-ACCT PK
DIS_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.AP00.7

Indexes (2)

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.

IndexKeysFlagsConditionUsed in
ADASET1
  1. ACCT-STRCT
  2. DIST-COMPANY
  3. DIS-ACCT-UNIT
  4. DIS-ACCOUNT
  5. DIS-SUB-ACCT
  6. UNIQUE-I-D
PrimaryAP00.7, AP175, AP200
ADAUID
  1. UNIQUE-I-D
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlcompanyGLSYSTEMRequired
ADA-DIST-COMPANY→GLS-COMPANY (GLSSET1)

Programs

Updated by (1)

Referenced by (2)