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.
FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
TXC-COMPANY Element: Company | Numeric 4 This field contains the company number.
|
|
TXC-NAME Element: Name | Alpha 30 (Lower Case) This field contains the company name or
description.
|
|
TXC-TAX-ID Element: Tax Id | Alpha 20 This field contains the tax ID or
registration number.
|
|
TXC-THIRD-PARTY Element: Third Party | Alpha 1 This field indicates which tax system
you are using, whether you use the Tax
system or a third-party 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 " " = Using Lawson Tax System |
|
TXC-TOLERANCE-LMT Element: Intl Amt | Signed 18.2 This 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.
|
|
TXC-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, 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.
|
|
TXC-LAST-TRANS-ID Element: Seq Trns Nbr | Numeric 10 This field indicates the last
transaction identifier that the system
generated.
|
|
TXC-FROM-RATE Element: From Rate | Percent 7.4 (Percent) This field shows the lowest acceptable
tax rate, if you entered a tolerance
limit.
|
|
TXC-THRU-RATE Element: From Rate | Percent 7.4 (Percent) This field shows the highest acceptable
tax rate if you entered a tolerance
limit.
|
|
TXC-ACCT-BY-CODE Element: All Flag | Alpha 1 This 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 |
|
TXC-TAX-POINT Element: Tax Point | Alpha 1 This 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 |
|
TXC-ACCR-CODE Element: Ar Code | Alpha 4 A user-defined code representing an
accounts payable accrual account.
|
|
TXC-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 (noninvoiced) taxes
do not affect the transaction amount.
I = Invoiced A = Accrued |
|
TXC-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 |
|
TXC-LAND-COST-FLG Element: All Flag | Alpha 1 This 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 |
|
TXC-TAX-TERMS Element: Tax Terms | Alpha 1 This 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 |
|
TXC-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.
|
|
TXC-INP-ACCOUNT Element: Account | Numeric 6 The general ledger account used for
input taxes. Input taxes are paid by
the company through the Accounts Payable
system.
|
|
TXC-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.
|
|
TXC-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.
|
|
TXC-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.
|
|
TXC-INPDU-SUB-ACCT Element: Sub Acct | Numeric 4 The 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.
|
|
TXC-OUT-ACCT-UNIT Element: Acct Unit | Alpha 15 The general ledger accounting unit used
for output taxes. Output taxes are
collected by the company through the
Accounts Receivable system.
|
|
TXC-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.
|
|
TXC-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.
|
|
TXC-OUTDU-ACT-UNIT Element: Acct Unit | Alpha 15 The 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.
|
|
TXC-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.
|
|
TXC-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.
|
|
TXC-NBR-PERIODS Element: Nbr Periods | Numeric 2 The 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 Element: Intrastat Ind | Alpha 1 Determines whether the company is
subject to Intrastat reporting.
|
|
TXC-VAT-REG-CTRY Element: Vat Reg Ctry | Alpha 2 The country component of the VAT
Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
|
|
TXC-VAT-REG-NBR Element: Vat Reg Nbr | Alpha 12 The number component of the VAT
Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
|
|
TXC-VAT-NBR Element: Vat Nbr | Derived The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
|
|
TXC-BRANCH-ID Element: Branch Id | Alpha 3 The company's branch ID, if required
for Intrastate reporting.
|
|
TXC-TAXABLE-CNTR Element: Taxable Cntr | Alpha 1 This 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 |
|