ACPRODTAX – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
BTX
Primary key
TAX-ACCT-CAT, DELIV-METHOD, EFFECTIVE-DATE
Fields
4
Updated by
1 program
Referenced by
16 programs

ACPRODTAX is a Lawson AC Billing Revenue table (prefix BTX); no description in the lawson data dictionary. It is indexed by TAX-ACCT-CAT, DELIV-METHOD, EFFECTIVE-DATE (BTXSET1). It is related 1:1 to ACACCTCAT. It is updated by BR58.1 and referenced by BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 and 8 more. The table has 4 fields, 1 index and 1 documented relation.

About ACPRODTAX

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the BTX- 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
#BTX-TAX-ACCT-CAT PK
TAX_ACCT_CAT		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruBR58.1
#BTX-DELIV-METHOD PK
DELIV_METHOD		Alpha 1—
  • S Shipped
  • H Hosted at
  • E Electronic
  • L Loaded
  • 1 Method 1
  • 2 Method 2
  • 3 Method 3
BR58.1
#BTX-EFFECTIVE-DATE PK
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date a vendor's prices will be in effect.BR58.1
#BTX-TAX-PRODUCT
TAX_PRODUCT		Alpha 15—BR58.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.

IndexKeysFlagsConditionUsed in
BTXSET1
  1. TAX-ACCT-CAT
  2. DELIV-METHOD
  3. EFFECTIVE-DATE ↓
PrimaryBR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +9 more

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
BTX-TAX-ACCT-CAT→AAX-ACCT-CATEGORY

Programs

Updated by (1)

Referenced by (16)