TXTAXCODE – Tax Code Maintenance

System
Tax (TX)
Prefix
TAC
Primary key
COMPANY, TAX-CODE
Fields
33
Updated by
413 programs
Referenced by
27 programs

TXTAXCODE is the Tax Code Maintenance table in Lawson Tax (prefix TAC). It is indexed by COMPANY, TAX-CODE (TACSET1); alternate indexes: TACSET2. It is related 1:1 to GLSYSTEM, GLMASTER, TACBOD, TXCODEMAST and TXCOMPANY and 1:M to TXTAXRATE and TXTAXTRAN. It is updated by AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 and 405 more and referenced by AR02.1, AR501, BR180, PD21.1, PD22.1, PO53.4, PO53.5, PO53.8 and 19 more. The table has 33 fields, 2 indexes and 10 documented relations.

About TXTAXCODE

The Tax Code file contains all tax code information. Tax codes are used in several Lawson systems to calculate tax transactions. Some examples of tax codes are VAT (Value Added Tax), GST (Goods and Services Tax), PST (Provincial Goods and Services Tax), and USE (Use Tax). Tax codes are stored with tax rate effective dates to allow individual tax codes to have multiple effective dates. Each Lawson system uses the most recent tax rate effective date defined for the tax code (compared to the transaction date, for example) to calculate tax information.

Fields (33)

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

Field / columnTypeDescription & valuesUpdated by
TAC-COMPANY PK
COMPANY		Numeric 4This field indicates the company number. You must have already defined the company in the General Ledger system.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-TAX-CODE PK
TAX_CODE		Alpha 10A user-defined code representing tax information. You define tax codes using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-TAX-ID
TAX_ID		Alpha 20The company's tax identification or registration number.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-ACCRUAL-FL
ACCRUAL_FL		Alpha 1This field indicates how the tax code will affect a taxable transaction. Invoiced taxes increase the transaction amount and accrued taxes (non-invoiced) do not affect the transaction amount.
  • I Invoiced
  • A Accrual
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-ALLOW-CHANGE
ALLOW_CHANGE		Alpha 1This field indicates whether or not you can override the default general ledger accounts at tax calculation time.
  • Y Yes
  • N No
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-TAX-TERMS
TAX_TERMS		Alpha 1Indicates at what point the tax will be calculated, before or after payment terms are applied. You define terms in the Terms system.
  • B Tax Before Terms
  • A Tax After Terms
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-TAX-POINT
TAX_POINT		Alpha 1This field indicates the date at which you want the system to calculate sales tax.
  • I Invoice Date
  • S Shipping Date
  • P Payment Date
  • G GL Date
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-ACCR-CODE
ACCR_CODE		Alpha 4A user-defined code representing an accounts payable accrual account.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-LAST-TRANS-ID
LAST_TRANS_ID		Numeric 10This field indicates the system assigned, internal tax transaction number. It is used to keep tax transactions unique.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
TAC-LAND-COST-FLG
LAND_COST_FLG		Alpha 1This field is used with the Purchase Order and Inventory Control systems. You determine whether or not the tax on an item is to be included in the item's cost.
  • Y Yes
  • N No
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-TOLERANCE-LMT
TOLERANCE_LMT		Signed 18.2This field indicates a minimum taxable amount for the acceptable tax rate range. The tolerance limit is valid for taxable amounts greater than or equal to the amount you entered.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-TOLERANCE-AMT
TOLERANCE_AMT		Signed 18.2Enter a tax tolerance amount for tolerance checking. Tolerance checking applies to verifying a tax amount (for example, the Accounts Payable system would verify a sales tax amount on an invoice that they're about to pay). If the difference between the passed tax amount and the system calculated tax amount exceeds the tax tolerance amount, then it will result in an error.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-FROM-RATE
FROM_RATE		Percent 7.4 (Percent)If you entered a tolerance limit, this field indicates the lowest acceptable tax rate.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-THRU-RATE
THRU_RATE		Percent 7.4 (Percent)If you entered a tolerance limit, this field indicates the highest acceptable tax rate.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-ADJUST-DISC
ADJUST_DISC		Alpha 1This field indicates whether or not you can change the discount amount in the Accounts Payable system.—
TAC-INP-ACCT-UNIT
INP_ACCT_UNIT		Alpha 15The general ledger accounting unit used for input taxes. Input taxes are paid by the company through the Accounts Payable system.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-INP-ACCOUNT
INP_ACCOUNT		Numeric 6The general ledger account used for input taxes. Input taxes are paid for by the company through the Accounts Payable system.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-INP-SUB-ACCT
INP_SUB_ACCT		Numeric 4The general ledger subaccount used for input taxes. Input taxes are paid for by the company through the Accounts Payable system.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-INPDU-ACT-UNIT
INPDU_ACT_UNIT		Alpha 15The general ledger accounting unit for the input due account. This account is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the company actually pays the vendor, the tax posting is moved from this account to the input accounting unit.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-INPDU-ACCOUNT
INPDU_ACCOUNT		Numeric 6The general ledger account for the input due account. This account is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the company actually pays the vendor, the tax posting is moved from this account to the input account.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-INPDU-SUB-ACCT
INPDU_SUB_ACCT		Numeric 4The general ledger subaccount for the input due account. This is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the company actually pays the vendor, the tax posting is moved from this account to the input subaccount.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-OUT-ACCT-UNIT
OUT_ACCT_UNIT		Alpha 15The general ledger accounting unit for output taxes. Output taxes are collected by the company through the Accounts Receivable system.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-OUT-ACCOUNT
OUT_ACCOUNT		Numeric 6The general ledger account used for output taxes. Output taxes are collected by the company through the Accounts Receivable system.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-OUT-SUB-ACCT
OUT_SUB_ACCT		Numeric 4The general ledger subaccount used for output taxes. Output taxes are collected by the company through the Accounts Receivable system.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-OUTDU-ACT-UNIT
OUTDU_ACT_UNIT		Alpha 15The general ledger accounting unit for the output due account. This is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the customer actually pays the invoice, the tax posting is moved from this account to the output accounting unit.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-OUTDU-ACCOUNT
OUTDU_ACCOUNT		Numeric 6The general ledger account for the output due account. This account is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the customer actually pays the invoice, the tax posting is moved from this account to the output account.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-OUTDU-SUB-ACCT
OUTDU_SUB_ACCT		Numeric 4The general ledger subaccount for the output due account. This account is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the customer actually pays the invoice, the tax posting is moved from this account to the output subaccount.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-TAX-NAME
TAX_NAME		DerivedThis field contains the tax code name.—
TAC-GDS-SVCS-IND
GDS_SVCS_IND		Alpha 1Goods and services indicator.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-VAT-TYPE
VAT_TYPE		Alpha 1Specifies the type of transaction the tax code is used for.
  • D Domestic
  • E Intra-EC
  • I Import
  • X Export
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-TRNGL-IND
TRNGL_IND		Alpha 1Triangulation indicator
  • Y Yes
  • N No
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TAC-STATUS
STATUS		Numeric 1—
  • 0 Active
  • 1 Inactive
—
TAC-POST-OPTION
POST_OPTION		Alpha 1—
  • I AP Invoice Company
  • D Distribution Company
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)

Indexes (2)

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

IndexKeysFlagsConditionUsed in
TACSET1COMPANY, TAX-CODEPrimaryAC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
TACSET2TAX-CODE, COMPANYAC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
GlsystemGLSYSTEMRequiredTAC-COMPANY → GLS-COMPANY
Input AccountGLMASTERRequiredWhen TAC-INP-ACCT-UNIT != Spaces Or TAC-INP-ACCOUNT != Zeroes Or TAC-INP-SUB-ACCT != ZeroesTAC-COMPANY → GLM-COMPANY, TAC-INP-ACCT-UNIT → GLM-ACCT-UNIT, TAC-INPDU-ACCOUNT → GLM-ACCOUNT, TAC-INPDU-SUB-ACCT → GLM-SUB-ACCOUNT
Input Due AcctGLMASTERRequiredWhen TAC-INPDU-ACT-UNIT != Spaces Or TAC-INPDU-ACCOUNT != Zeroes Or TAC-INPDU-SUB-ACCT != ZeroesTAC-COMPANY → GLM-COMPANY, TAC-INPDU-ACT-UNIT → GLM-ACCT-UNIT, TAC-INPDU-ACCOUNT → GLM-ACCOUNT, TAC-INPDU-SUB-ACCT → GLM-SUB-ACCOUNT
Outpt Due AcctGLMASTERRequiredWhen (TAC-OUTDU-ACT-UNIT != Spaces) Or (TAC-OUTDU-ACCOUNT != Zeroes) Or (TAC-OUTDU-SUB-ACCT != Zeroes)TAC-COMPANY → GLM-COMPANY, TAC-OUTDU-ACT-UNIT → GLM-ACCT-UNIT, TAC-OUTDU-ACCOUNT → GLM-ACCOUNT, TAC-OUTDU-SUB-ACCT → GLM-SUB-ACCOUNT
Output AccountGLMASTERRequiredWhen TAC-OUT-ACCT-UNIT != Spaces Or TAC-OUT-ACCOUNT != Zeroes Or TAC-OUT-SUB-ACCT != ZeroesTAC-COMPANY → GLM-COMPANY, TAC-OUT-ACCT-UNIT → GLM-ACCT-UNIT, TAC-OUT-ACCOUNT → GLM-ACCOUNT, TAC-OUT-SUB-ACCT → GLM-SUB-ACCOUNT
TacbodTACBODNot Required, Delete CascadesTAC-COMPANY → YTA-COMPANY, TAC-TAX-CODE → YTA-TAX-CODE
TxcodemastTXCODEMASTRequiredTAC-TAX-CODE → TCM-TAX-CODE
TxcompanyTXCOMPANYRequiredTAC-COMPANY → TXC-COMPANY

One to many (2) — child tables

RelationTableRulesConditionField map
TxtaxrateTXTAXRATEValid When TCM-TAX-TYPE = "S" Or TCM-TAX-TYPE = "M"TAC-TAX-CODE → TXR-TAX-CODE, → TXR-PROD-TAX-CAT, → TXR-EFFECT-DATE
TxtaxtranTXTAXTRANTAC-COMPANY → TXD-COMPANY, TAC-TAX-CODE → TXD-TAX-CODE, → TXD-SYSTEM-CD, → TXD-TAX-PNT-DATE, → TXD-VOUCHER-NBR, → TXD-TRANS-IDENT

Programs

Updated by (413)

Referenced by (27)