TXCOMPANY

Tax Company

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.

REFERENCED BY
AP272 AP52.1 AP52.3 AP700 MA54.1 MA54.2
PO53.4 PO53.5 PO53.8 IN120 IN20.1 TX06.1
TX08.1 TX125 TX130 TX200 TX202 TX220
TX221 TX222 TX226 TX301


UPDATED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM19.1 AM19.2 AM20.1 AM20.3 AM21.1 AM21.3
AM500 AM51.1 AM551 AM97.1 AP00.3 AP00.4
AP03.3 AP10.1 AP10.2 AP10.5 AP10.6 AP110
AP115 AP125 AP126 AP131 AP150 AP170
AP180 AP181 AP190 AP193 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.6 AP20.7 AP21.1
AP210 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP305 AP510 AP520
AP90.1 AP91.1 AP95.1 API1.1 API2.1 API3.1
API4.1 API5.1 AR02.1 AR08.1 AR10.1 AR15.4
AR501 AR550 CB03.2 CB10.1 CB10.3 CB10.5
CB150 CB180 CB191 CB20.1 CB20.6 CB30.1
CB43.1 CB44.1 CB45.1 CB46.1 CB50.1 CB500
CB54.1 CB543 CB544 CB55.1 CB554 EE05.1
EE11.1 EE135 EE20.3 EE35.1 EE35.2 EE520
EX175 EX542 MX123 MX500 MA08.1 MA208
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA540 MAED.1
MAI1.1 PO10.1 PO136 PO190 PO300 PO520
POCP.1 POED.1 POI3.1 POI7.1 POIF.1 POIG.1
POII.1 POIJ.1 POIM.1 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 PR514 UK47.1 RQ01.1
TX00.1 TX02.1 TX04.1 TX100 TX101 TX120
TX140 TX204 TX300 TX40.1 TX40.2 TX804
TX07.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXC-COMPANY
Element: Company
Numeric 4
This field contains the company number.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
TXC-NAME
Element: Name
Alpha 30 (Lower Case)
This field contains the company name or description.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
TXC-TAX-ID
Element: Tax Id
Alpha 20
This field contains the tax ID or registration number.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
TXC-LAST-TRANS-ID
Element: Seq Trns Nbr
Numeric 10
This field indicates the last transaction identifier that the system generated.
AP125 AP126
AP170 AP180
AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
CB10.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1 TX04.1
TX804
TXC-FROM-RATE
Element: From Rate
Percent 7.4 (Percent)
This field shows the lowest acceptable tax rate, if you entered a tolerance limit.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
TXC-THRU-RATE
Element: From Rate
Percent 7.4 (Percent)
This field shows the highest acceptable tax rate if you entered a tolerance limit.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
TXC-ACCR-CODE
Element: Ar Code
Alpha 4
A user-defined code representing an accounts payable accrual account.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1
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
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
API2.1 API3.1


TXCOMPANY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXCSET1 COMPANY
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170


TXCOMPANY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Inp Due Acct GLMASTER Required
When (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 Account GLMASTER Required
When TXC-INP-ACCT-UNIT !=Spaces
OrTXC-INP-ACCOUNT !=Zeroes
OrTXC-INP-SUB-ACCT !=Zeroes
TXC-COMPANY->GLM-COMPANY
TXC-INP-ACCT-UNIT->GLM-ACCT-UNIT
TXC-INP-ACCOUNT->GLM-ACCOUNT
TXC-INP-SUB-ACCT->GLM-SUB-ACCOUNT
Outpt Due Acct GLMASTER Required
When (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 Account GLMASTER Required
When TXC-OUT-ACCT-UNIT !=Spaces
OrTXC-OUT-ACCOUNT !=Zeroes
OrTXC-OUT-SUB-ACCT !=Zeroes
TXC-COMPANY->GLM-COMPANY
TXC-OUT-ACCT-UNIT->GLM-ACCT-UNIT
TXC-OUT-ACCOUNT->GLM-ACCOUNT
TXC-OUT-SUB-ACCT->GLM-SUB-ACCOUNT


TXCOMPANY FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Txtaxcode TXTAXCODE
TXC-COMPANY->TAC-COMPANY
  TAC-TAX-CODE


File created: Wed Jun 08 20:51:46 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.