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.
FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
TAC-COMPANY Element: Company | Numeric 4 This field indicates the company
number. You must have already defined
the company in the General Ledger
system.
|
|
TAC-TAX-CODE Element: Tax Code | Alpha 10 A user-defined code representing tax
information. You define tax codes using
TX01.1 (Tax Code Master).
|
|
TAC-TAX-ID Element: Tax Id | Alpha 20 The company's tax identification or
registration number.
|
|
TAC-ACCRUAL-FL Element: Accrual Fl | Alpha 1 This 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 |
|
TAC-ALLOW-CHANGE Element: All Flag | Alpha 1 This field indicates whether or not you
can override the default general ledger
accounts at tax calculation time.
Y = Yes N = No |
|
TAC-TAX-TERMS Element: Tax Terms | Alpha 1 Indicates 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 |
|
TAC-TAX-POINT Element: Tax Point | Alpha 1 This 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 |
|
TAC-ACCR-CODE Element: Ar Code | Alpha 4 A user-defined code representing an
accounts payable accrual account.
|
|
TAC-LAST-TRANS-ID Element: Last Transaction ID | Numeric 10 This field indicates the system
assigned, internal tax transaction
number. It is used to keep tax
transactions unique.
|
|
TAC-LAND-COST-FLG Element: All Flag | Alpha 1 This 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 |
|
TAC-TOLERANCE-LMT Element: Intl Amt | Signed 18.2 This 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.
|
|
TAC-TOLERANCE-AMT Element: Intl Amt | Signed 18.2 Enter 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.
|
|
TAC-FROM-RATE Element: From Rate | Percent 7.4 (Percent) If you entered a tolerance limit, this
field indicates the lowest acceptable
tax rate.
|
|
TAC-THRU-RATE Element: From Rate | Percent 7.4 (Percent) If you entered a tolerance limit, this
field indicates the highest acceptable
tax rate.
|
|
TAC-ADJUST-DISC Element: Adjust Disc | Alpha 1 This field indicates whether or not you
can change the discount amount in the
Accounts Payable system.
|
|
TAC-INP-ACCT-UNIT Element: Acct Unit | Alpha 15 The general ledger accounting unit used
for input taxes. Input taxes are paid
by the company through the Accounts
Payable system.
|
|
TAC-INP-ACCOUNT Element: Account | Numeric 6 The general ledger account used for
input taxes. Input taxes are paid for
by the company through the Accounts
Payable system.
|
|
TAC-INP-SUB-ACCT Element: Sub Acct | Numeric 4 The general ledger subaccount used for
input taxes. Input taxes are paid for
by the company through the Accounts
Payable system.
|
|
TAC-INPDU-ACT-UNIT Element: Acct Unit | Alpha 15 The 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.
|
|
TAC-INPDU-ACCOUNT Element: Account | Numeric 6 The 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.
|
|
TAC-INPDU-SUB-ACCT Element: Sub Acct | Numeric 4 The 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.
|
|
TAC-OUT-ACCT-UNIT Element: Acct Unit | Alpha 15 The general ledger accounting unit for
output taxes. Output taxes are
collected by the company through the
Accounts Receivable system.
|
|
TAC-OUT-ACCOUNT Element: Account | Numeric 6 The general ledger account used for
output taxes. Output taxes are
collected by the company through the
Accounts Receivable system.
|
|
TAC-OUT-SUB-ACCT Element: Sub Acct | Numeric 4 The general ledger subaccount used for
output taxes. Output taxes are
collected by the company through the
Accounts Receivable system.
|
|
TAC-OUTDU-ACT-UNIT Element: Acct Unit | Alpha 15 The 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.
|
|
TAC-OUTDU-ACCOUNT Element: Account | Numeric 6 The 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.
|
|
TAC-OUTDU-SUB-ACCT Element: Sub Acct | Numeric 4 The 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.
|
|
TAC-TAX-NAME Element: Tax Name | Derived This field contains the tax code name.
|
|
TAC-GDS-SVCS-IND Element: Gds Svcs Ind | Alpha 1 Goods and services indicator.
|
|
TAC-VAT-TYPE Element: Vat Type | Alpha 1 Specifies the type of transaction the
tax code is used for.
D = Domestic E = Intra-EC I = Import X = Export |
|
TAC-TRNGL-IND Element: Trngl Ind | Alpha 1 Triangulation indicator
Y = Yes N = No |
|
TAC-STATUS Element: Status | Numeric 1
0 = Inactive 1 = Active |
|