TXCOMPANY – Tax Company

System
Tax (TX)
Prefix
TXC
Primary key
COMPANY
Fields
36
Updated by
427 programs
Referenced by
48 programs

TXCOMPANY is the Tax Company table in Lawson Tax (prefix TXC). It is indexed by COMPANY (TXCSET1). It is related 1:1 to GLMASTER and 1:M to TXTAXCODE. It is updated by AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 and 419 more and referenced by AP161, AP272, AP52.1, AP52.3, AP55.2, AP700, IC15.2, IC175 and 40 more. The table has 36 fields, 1 index and 5 documented relations.

About TXCOMPANY

The Tax Company file contains company information, as well as which tax system the company uses. If general ledger accounts are defined at the company level, those accounts are included on this file.

Fields (36)

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

Field / columnTypeDescription & valuesUpdated by
TXC-COMPANY PK
COMPANY		Numeric 4This field contains the company number.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-NAME
NAME		Alpha 30 (Lower Case)This field contains the company name or description.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-TAX-ID
TAX_ID		Alpha 20This field contains the tax ID or registration number.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-THIRD-PARTY
THIRD_PARTY		Alpha 1This field indicates which tax system you are using, whether you use the Tax system or a third-party tax system. " " = Using Lawson Tax System
  • A Using AVP Sales/Use Tax System
  • C Using Vertex - City/Zip Access
  • G Using Vertex - Geocode Access
  • S Using Vertex - State Zip
  • Z Using Vertex - Zip Code Access
  • Q Using V/Quantum Geocode
  • R Using V/Quantm CtyStZp or StZp
  • B Using NF Tax Engine
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-TOLERANCE-LMT
TOLERANCE_LMT		Signed 18.2This field indicates the 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)
TXC-TOLERANCE-AMT
TOLERANCE_AMT		Signed 18.2Enter a tax tolerance amount for tolerance checking. Tolerance checking applies to verifying a tax amount (for example, Accounts Payable would verify a sales tax amount on an invoice that they're about to pay). If the difference between the passed 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)
TXC-LAST-TRANS-ID
LAST_TRANS_ID		Numeric 10This field indicates the last transaction identifier that the system generated.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
TXC-FROM-RATE
FROM_RATE		Percent 7.4 (Percent)This field shows the lowest acceptable tax rate, if you entered a tolerance limit.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-THRU-RATE
THRU_RATE		Percent 7.4 (Percent)This field shows the highest acceptable tax rate if you entered a tolerance limit.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-ACCT-BY-CODE
ACCT_BY_CODE		Alpha 1This field indicates whether general ledger accounts are defined at the company level or at the tax code level. Select Yes to indicate that general ledger accounts are defined at the tax code level. Select No to indicate that general ledger accounts are defined at the company level.
  • Y Yes
  • N No
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-TAX-POINT
TAX_POINT		Alpha 1This field indicates the date at which you want the system to calculate sales tax. If you select Invoice Date, tax is calculated when you release an invoice in the Billing system. If you select Shipping Date, it is calculated when you perform shipping feedback in the Warehouse system. If you select Payment Date, tax is calculated at the date of payment.
  • 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)
TXC-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)
TXC-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 (noninvoiced) taxes do not affect the transaction amount.
  • I Invoiced
  • A Accrued
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-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)
TXC-LAND-COST-FLG
LAND_COST_FLG		Alpha 1This field is used with the Purchase Order and Inventory Control systems. Select Yes to indicate that the tax on an item is included in the item's cost (landed).
  • Y Yes
  • N No
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-TAX-TERMS
TAX_TERMS		Alpha 1This field indicates whether tax is 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)
TXC-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)
TXC-INP-ACCOUNT
INP_ACCOUNT		Numeric 6The general ledger account 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)
TXC-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)
TXC-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)
TXC-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)
TXC-INPDU-SUB-ACCT
INPDU_SUB_ACCT		Numeric 4The general ledger subaccount 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 subaccount.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-OUT-ACCT-UNIT
OUT_ACCT_UNIT		Alpha 15The general ledger accounting unit 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)
TXC-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)
TXC-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)
TXC-OUTDU-ACT-UNIT
OUTDU_ACT_UNIT		Alpha 15The general ledger accounting unit for output due taxes. 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 accounting unit.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-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)
TXC-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)
TXC-NBR-PERIODS
NBR_PERIODS		Numeric 2The Number of Periods field contains the number of periods that are included when the outline is built. This field can contain up to two numeric values.—
TXC-INTRASTAT-IND
INTRASTAT_IND		Alpha 1Determines whether the company is subject to Intrastat reporting.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-VAT-REG-CTRY
VAT_REG_CTRY		Alpha 2The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-VAT-REG-NBR
VAT_REG_NBR		Alpha 12The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-VAT-NBR
VAT_NBR		DerivedThe concatenation of the VAT-REG-CTRY and VAT-REG-NBR fields, used as VAT reporting ID.—
TXC-BRANCH-ID
BRANCH_ID		Alpha 3The company's branch ID, if required for Intrastate reporting.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-TAXABLE-CNTR
TAXABLE_CNTR		Alpha 1This field indicates whether the taxable amount edit is turned on or off. If turned on, the taxable amount sum of the invoice lines must equal the total taxable amount on the AP invoice.
  • N No (Default)
  • Y Yes
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXC-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 (1)

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

IndexKeysFlagsConditionUsed in
TXCSET1COMPANYPrimaryAC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Inp Due AcctGLMASTERRequiredWhen (TXC-INPDU-ACT-UNIT != Spaces) Or (TXC-INPDU-ACCOUNT != Zeroes) Or (TXC-INPDU-SUB-ACCT != Zeroes)TXC-COMPANY → GLM-COMPANY, TXC-INPDU-ACT-UNIT → GLM-ACCT-UNIT, TXC-INPDU-ACCOUNT → GLM-ACCOUNT, TXC-INPDU-SUB-ACCT → GLM-SUB-ACCOUNT
Input AccountGLMASTERRequiredWhen TXC-INP-ACCT-UNIT != Spaces Or TXC-INP-ACCOUNT != Zeroes Or TXC-INP-SUB-ACCT != ZeroesTXC-COMPANY → GLM-COMPANY, TXC-INP-ACCT-UNIT → GLM-ACCT-UNIT, TXC-INP-ACCOUNT → GLM-ACCOUNT, TXC-INP-SUB-ACCT → GLM-SUB-ACCOUNT
Outpt Due AcctGLMASTERRequiredWhen (TXC-OUTDU-ACT-UNIT != Spaces) Or (TXC-OUTDU-ACCOUNT != Zeroes) Or (TXC-OUTDU-SUB-ACCT != Zeroes)TXC-COMPANY → GLM-COMPANY, TXC-OUTDU-ACT-UNIT → GLM-ACCT-UNIT, TXC-OUTDU-ACCOUNT → GLM-ACCOUNT, TXC-OUTDU-SUB-ACCT → GLM-SUB-ACCOUNT
Output AccountGLMASTERRequiredWhen TXC-OUT-ACCT-UNIT != Spaces Or TXC-OUT-ACCOUNT != Zeroes Or TXC-OUT-SUB-ACCT != ZeroesTXC-COMPANY → GLM-COMPANY, TXC-OUT-ACCT-UNIT → GLM-ACCT-UNIT, TXC-OUT-ACCOUNT → GLM-ACCOUNT, TXC-OUT-SUB-ACCT → GLM-SUB-ACCOUNT

One to many (1) — child tables

RelationTableRulesConditionField map
TxtaxcodeTXTAXCODETXC-COMPANY → TAC-COMPANY, → TAC-TAX-CODE

Programs

Updated by (427)

Referenced by (48)