APAUTHOR – Authority Code

System
Accounts Payable (AP)
Prefix
ATR
Primary key
COMPANY, AUTH-CODE
Fields
7
Updated by
22 programs
Referenced by
290 programs

APAUTHOR is the Authority Code table in Lawson Accounts Payable (prefix ATR). It is indexed by COMPANY, AUTH-CODE (ATRSET1); alternate indexes: ATRSET2 and ATRSET3. It is related 1:1 to APCOMPANY and 1:M to APINVOICE. It is updated by AP05.6, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 and 14 more and referenced by AC160, AC42.1, AC42.2, AM115, AM117, AM15.1, AM15.2, AM15.3 and 282 more. The table has 7 fields, 3 indexes and 2 documented relations.

About APAUTHOR

The Authority Code file contains authority codes. Authority codes are required for companies that have Yes selected in the Invoice Approval Option field and No selected in the Batch Release Option field. An authority code must be assigned to a registered invoice before the invoice can be released. Authority codes can also be used for a company that has Yes selected in both invoice entry option fields, but an authority code is not required for release in this case.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
ATR-COMPANY PK
COMPANY
Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.AP05.6
ATR-AUTH-CODE PK
AUTH_CODE
Alpha 3The user-defined authority code. Identifies the person or department responsible for approving a registered invoice.AP05.6
ATR-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)The description of the authority code.AP05.6, AP126, AP236, AP520
ATR-ACTIVITY-FLAG
ACTIVITY_FLAG
Alpha 1Indicates whether the authority code has been used.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7, AP21.1 +11 more
ATR-VENDOR-GROUP
VENDOR_GROUP
Alpha 4The vendor group associated with the authority code company.AP05.6
ATR-EMAIL-ADDRESS
EMAIL_ADDRESS
Alpha 60 (Lower Case)e-mail address.AP05.6
ATR-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1
  • A Active
  • I Inactive
AP05.6, AP702

Indexes (3)

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

IndexKeysFlagsConditionUsed in
ATRSET1COMPANY, AUTH-CODEPrimaryAC42.1, AC42.2, AP00.4, AP05.6, AP06.1, AP10.1, AP10.5, AP126 +22 more (list truncated in source)
ATRSET2VENDOR-GROUP, AUTH-CODE, COMPANYKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
ATRSET3AUTH-CODE, COMPANYKeyChangeAP205, MA540

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredATR-COMPANYCPY-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
ApinvoiceAPINVOICEDelete RestrictedATR-COMPANYAPI-COMPANY, ZeroesAPI-BATCH-NUM, ATR-AUTH-CODEAPI-AUTH-CODE, API-VOUCHER-NBR, API-VENDOR, API-INVOICE, API-SUFFIX, API-CANCEL-SEQ

Programs

Updated by (22)

Referenced by (290)