The Tax Transactions file contains all tax transaction records that have been
created for the Tax system by the Accounts Payable, Accounts Receivable,
Billing, Cash Ledger, and Cash Receipts systems.
Tax transaction records update this file when an Accounts Payable, Accounts
Receivable, Cash Ledger, or Employee Advance and Expense transaction with a
tax distribution is released, interfaced with a released status, or converted
with a released status, or when a released Billing invoice with a non-Vertex
tax distribution is printed.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
TXD-COMPANY
Element: Company | Numeric 4
The company number. The company must
already be defined in the General Ledger
system.
|
|
TXD-TAX-CODE
Element: Tax Code | Alpha 10
A user-defined code representing tax
information. You must have already
defined the tax code using TX01.1 (Tax
Code Master).
|
|
TXD-TRANS-IDENT
Element: Transaction ID | Numeric 10
A system-assigned, internal transaction
number. The system uses the transaction
ID to keep tax transactions unique.
|
|
TXD-SYSTEM-CD
Element: System Cd | Alpha 2
This field indicates on which system
the transaction originated.
AP = Accounts Payable
AR = Accounts Receivable
BL = Billing
CB = Cash Ledger
CR = Cash Receipts
BR = Billing and Revenue |
|
TXD-VEND-CUST
Vendor or Customer
ID | Alpha 9 (Right Justified)
The vendor or customer number the tax
transaction was created for.
|
|
TXD-TAX-ID-NBR
Element: Tax ID | Alpha 20
The tax identification or registration
number of the company the tax
transaction was created for.
|
|
TXD-PROD-TAX-CAT
Element: Prod Tax Cat | Alpha 15
A product tax category lets you group
items to determine the tax rate by item
grouping. For example, you can tax an
item grouping so that it is taxable in
one state but not another.
You define a product tax category in
the Inventory Control system.
|
|
TXD-INVOICE
Element: Invoice | Alpha 22
The invoice number associated with the
tax transaction.
|
|
TXD-SUFFIX
Element: Suffix | Numeric 3
The transaction suffix number
associated with the tax transaction.
This field represents the occurrence
value of the transaction.
|
|
TXD-CANCEL-SEQ
Element: Seq Nbr | Numeric 4
A sequence number that is assigned when
an accounts payable distributed invoice
is canceled. The first sequence
assigned is 9999.
|
|
TXD-DIST-COMPANY
Element: Company | Numeric 4
The company number used to post tax
transactions. The company must have
been already defined in the General
Ledger system.
|
|
TXD-TAX-ACCT-UNIT
Element: Acct Unit | Alpha 15
The general ledger accounting unit
associated with the tax transaction. You
must have already defined the accounting
unit in the General Ledger system.
|
|
TXD-TAX-ACCOUNT
Element: Account | Numeric 6
The general ledger account number
associated with the tax transaction. You
must have already defined the account in
the General Ledger system.
|
|
TXD-TAX-SUB-ACCT
Element: Sub Acct | Numeric 4
The general ledger subaccount number
associated with the tax transaction. You
must have already defined the subaccount
in the General Ledger system.
|
|
TXD-NAME
Vendor or Customer
Name | Alpha 30 (Lower Case)
The name of the vendor or customer the
tax transaction was created for.
|
|
TXD-VOUCHER-NBR
Element: Voucher Nbr | Alpha 10
The voucher number associated with the
tax transaction. Vouchers are used by
the Purchase Order system.
|
|
TXD-TAX-PNT-DATE
Element: Date | Numeric 8 (yyyymmdd)
The date at which the system calculated
sales tax.
|
|
TXD-INVOICE-DTE
Element: Invoice Dte | Numeric 8 (yyyymmdd)
The transaction date associated with
the tax transaction.
|
|
TXD-POST-DATE
Element: Post Date | Numeric 8 (yyyymmdd)
The general ledger posting date
associated with the tax transaction.
|
|
TXD-TRAN-CURRENCY
Element: To Base Curr | Alpha 5
The currency of the transaction
associated with the tax transaction. The
currency must be valid in the Currency
system.
|
|
TXD-TRAN-INV-AMT
Element: Intl Amt | Signed 18.2
The amount of the transaction in the
currency of the transaction.
|
|
TXD-TRAN-TAXABLE
Element: Intl Amt | Signed 18.2
The taxable amount of the transaction
in the currency of the transaction.
|
|
TXD-TRAN-TAX-AMT
Element: Intl Amt | Signed 18.2
The tax amount for the tax transaction
in the currency of the transaction.
|
|
TXD-TRAN-ND
Element: Acct Nd | Numeric 1
The number of decimal places defined
for the transaction currency associated
with the tax transaction.
|
|
TXD-BASE-INV-AMT
Element: Intl Amt | Signed 18.2
The amount of the transaction in the
company base currency.
|
|
TXD-BASE-TAXABLE
Element: Intl Amt | Signed 18.2
The taxable amount of the transaction
in the company base currency.
|
|
TXD-BASE-TAX-AMT
Element: Intl Amt | Signed 18.2
The tax amount of the tax transaction
in the company base currency.
|
|
TXD-BASE-ND
Element: Base Nd | Numeric 1
The number of decimal places defined
for the company base currency.
|
|
TXD-TAX-RATE
Element: Chrg Rate | Percent 7.5 (Percent)
The tax rate that the system used for
the transaction.
|
|
TXD-ACCRUAL-FL
Element: Accrual Fl | Alpha 1
Accrual flags determined how tax was
applied to invoices, whether as invoiced
or accrued (noninvoiced).
I = Invoiced
A = Accrued |
|
TXD-PROC-LEVEL
Element: Process Level | Alpha 5
The process level associated with the
tax transaction. You define process
levels in the Accounts Receivable,
Accounts Payable, and Billing systems.
|
|
TXD-CURR-RATE
Currency Exchange
Rate | Signed 14.7
The currency exchange rate used to
convert a nonbase currency transaction
amount to the company base currency.
|
|
TXD-STATUS
Tax Transaction
Update Status | Numeric 1
This field indicates whether the tax
transaction has been updated by running
TX100 (Tax Analysis Report).
0 = Created
1 = Reported |
|
TXD-MANUAL-FL
Element: All Flag | Alpha 1
This field indicates whether the tax
transaction was created manually or not.
Y = Yes
N = No |
|
TXD-INPUT-OUTPUT
Element: Input Output | Derived
This field indicates whether the tax
applied to the transaction was an input
or output tax. Input taxes are paid by
the company through the Accounts Payable
system.
Output taxes are collected by the
company through the Accounts Receivable
system.
|
|
TXD-VEND-CUST-NAME
Element: Vend Cust Name | Derived
|
|
TXD-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.
|
|
TXD-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.
|
|
TXD-TAX-USAGE-CD
Element: Tax Usage Cd | Alpha 10
The tax usage code for the vendor. This
field is required if the AP Company
indicates that VAT reporting is
required.
|
|
TXD-INV-CRD-IND
Element: Inv Crd Ind | Alpha 1
Specified whether the transaction on
which the tax was entered as an invoice
or a credit memo.
I = Invoice
C = Credit Memo
|
|
TXD-TAX-YEAR
Element: Tax Year | Numeric 4
The tax year for which the calendar was
defined.
|
|
TXD-TAX-PERIOD
Element: Tax Period | Numeric 2
The tax period of the specified year.
|
|
TXD-SOURCE
Element: Source | Alpha 1
The source of the transaction. Input or
output. Input transactions are Accounts
Payable. Output transactions are
Accounts Receivable.
I = Input = AP
O = Output = AR |
|
TXD-PURCH-SALE-RPT
Element: Purch Sale Rpt | Alpha 1
Indicates whether a VAT Purchase and
Sales report is required.
|
|
TXD-TAX-FLAG
Element: All Flag | Alpha 1
This is the flag which indicates to the
system whether this transaction has been
interfaced into the Tax Report files or
not.
" " = Not Interfaced
I = Interfaced |
|
TXD-CANCEL-FL
Element: All Flag | Alpha 1
|
|
