Unreported VAT Transactions - Rows

Table Name: UTX1

Table Description: Unreported VAT Transactions - Rows

Field	Description	Type	Size	Related	Default Value	Constraints
AbsEntry	Internal ID	Int	11	OUTX
LineSeq	Row Sequence	Int	11	-
SrcArrType	Source Array Type	Int	11	-	-1	-1	Default
						1	Main
						12	Array1
						13	Array2
						14	Array3
						15	Array4
						16	Array5
						17	Array6
						18	Array7
						24	Array13
SrcLineNum	Source Row Number	Int	11	-	-1
SrcGrpNum	Source Group Number	Int	11	-	-1	-1	Default
						0	Group1
						1	Group2
						2	Group3
TaxCode	Tax Code	nVarChar	8	-
StaCode	Tax Authority Code	nVarChar	8	OSTA
StaType	Tax Authority Type	Int	11	OSTT
StaIndex	Tax Authority Seq Index	Int	11	-
IsLiable	Is Tax Liable	VarChar	1	-	Y	Y	Yes
						N	No
TaxType	Tax Type	VarChar	1	-	Y	Y	Regular
						U	Use Tax
						N	No Tax
						O	Tax Offset Transaction
						R	Reverse Tax Offset Transaction
						P	DPM Request Tax Offset Transaction
						D	Deferred Tax Offset Transaction
IsAcq	Is Acquisition Tax	VarChar	1	-	N	N	No
						Y	Yes
Isdeferred	Deferred Tax [Yes/No]	VarChar	1	-	N	N	No
						Y	Yes
ValueDate	Due Date for Payment	Date	8	-
VatPercent	VAT Percent	Num	19.6	-
NdPercent	Non Deductible %	Num	19.6	-
EqPercent	Equalization Percent	Num	19.6	-
BaseObjTyp	Base Object Type	nVarChar	20	-	-1	-1
						15	Delivery notes
						16	Revert Delivery Notes
						17	Sales Order
						20	Goods Receipt
						21	Goods Return
						22	Purchase order
						23	Sales Quotation
						112	Document Draft
						59	Goods Receipt
						60	Goods Issue
						28	Journal Batches
						140	Payment Draft
						123	Checks for Payment Drafts
						540000006	Purchase Quotation
BaseAbs	Base Document Internal No.	Int	11	-	-1
BaseArrTyp	Base Array Type	Int	11	-	-1	-1	Default
						1	Main
						12	Array1
						13	Array2
						14	Array3
						15	Array4
						16	Array5
						17	Array6
						18	Array7
						24	Array13
BaseLinNum	Base Row Number	Int	11	-	-1
BaseGrpNum	Base Group No.	Int	11	-	-1	-1	Default
						0	Group1
						1	Group2
						2	Group3
BaseSum	Base Sum	Num	19.6	-
BaseSumSc	Base Sum (SC)	Num	19.6	-
BaseSumFc	Base Sum (FC)	Num	19.6	-
VatSum	VAT Sum	Num	19.6	-
VatSumSc	VAT Sum (SC)	Num	19.6	-
VatSumFc	VAT Sum (FC)	Num	19.6	-
DeductSum	Deduct VAT Sum	Num	19.6	-
DedctSumSC	Deduct VAT Sum (SC)	Num	19.6	-
DedctSumFC	Deduct VAT Sum (FC)	Num	19.6	-
EqSum	Equalization Sum	Num	19.6	-
EqSumSC	Equalization Sum (SC)	Num	19.6	-
EqSumFC	Equalization Sum (FC)	Num	19.6	-
TaxAcct	Tax Account	nVarChar	15	OACT
DefAcct	Deferred Tax Account	nVarChar	15	OACT
NdAcct	Non Deduct. Account	nVarChar	15	OACT
AcqAcct	Acquisition Tax Account	nVarChar	15	OACT
ExpAcct	Expense Account	nVarChar	15	OACT
CrditDebit	Credit Or Debit Transaction	VarChar	1	-		C	Credit
						D	DEBIT
PostingTyp	Sales or Purchasing	VarChar	1	-	N	N	None
						R	Sales
						P	Purchase
BasePaid	Applied Base Sum	Num	19.6	-
BasePaidSC	Applied Base Sum SC	Num	19.6	-
BasePaidFC	Applied Base Sum FC	Num	19.6	-
VatPaid	Applied VAT Sum	Num	19.6	-
VatPaidSC	Applied VAT Sum SC	Num	19.6	-
VatPaidFC	Applied VAT Sum FC	Num	19.6	-
DeductPaid	Applied Deduct Sum	Num	19.6	-
DdctPaidSC	Applied Deduct Sum SC	Num	19.6	-
DdctPaidFC	Applied Deduct Sum FC	Num	19.6	-
EqPaid	Applied Equalization Sum	Num	19.6	-
EqPaidSC	Applied Equalization Sum SC	Num	19.6	-
EqPaidFC	Applied Equalization Sum FC	Num	19.6	-
TransAcct	Transaction Acccount	nVarChar	15	OACT
LnDataNum	Line Number in Tax Data	Int	11	-	-1
InPrice	Included in Price	VarChar	1	-	N	Y	Yes
						N	No
Exempt	Exempt	VarChar	1	-	N	Y	Yes
						N	No
InGrossRev	Included in Gross Revenue	VarChar	1	-	N	Y	Yes
						N	No
PostStatus	Posting Status	VarChar	1	-	Y	Y	Yes
						N	No
IsItmLevel	Is Item Level Tax	VarChar	1	-	N	N	No
						Y	Yes
MinTAmt	Min. Taxable Amount	Num	19.6	-
MinTAmtSC	Min. Taxable Amount (SC)	Num	19.6	-
MinTAmtFC	Min. Taxable Amount (FC)	Num	19.6	-
MaxTAmt	Max. Taxable Amount	Num	19.6	-
MaxTAmtSC	Max. Taxable Amount (SC)	Num	19.6	-
MaxTAmtFC	Max. Taxable Amount (FC)	Num	19.6	-
FlatTAmt	Flat Tax Amount	Num	19.6	-
FlatTAmtSC	Flat Tax Amount (SC)	Num	19.6	-
FlatTAmtFC	Flat Tax Amount (FC)	Num	19.6	-
EqTaxAcct	Equalization Tax Account	nVarChar	15	OACT
Reposted	Reposted in Transfer Wizard	VarChar	1	-	N	Y	Yes
						N	No
Unencumbrd	Unencumbered	VarChar	1	-	N	Y	Yes
						N	No
IsSplitPay	Split Payment	VarChar	1	-	N	Y	Yes
						N	No
SplitPayAc	Split Payment Account	nVarChar	15	-
TaxOnRI	Tax On Reserve Invoice	VarChar	1	-	N	Y	Yes
						N	No
RvsChrgPrc	Reverse Charge %	Num	19.6	-
RvsChrgSum	Reverse Charge Sum	Num	19.6	-
RvsChrgSC	Reverse Charge Sum (SC)	Num	19.6	-
RvsChrgFC	Reverse Charge Sum (FC)	Num	19.6	-
GstPayAct	GST Payable Account	nVarChar	15	OACT
RvsPaid	Applied Reverse Charge Sum	Num	19.6	-
RvsPaidSC	Applied Reverse Charge (SC)	Num	19.6	-
RvsPaidFC	Applied Reverse Charge (FC)	Num	19.6	-
InFirstIns	Included in First Installment	VarChar	1	-	N	Y	Yes
						N	No
GstRecvAct	GST Receivable Account	nVarChar	15	OACT
IsCstmAct	Apply Customer Accounting Tax Rule	VarChar	1	-	N	N	No
						Y	Yes
CAOutCode	Customer Accounting Output Tax Code	nVarChar	8	-
CABasSum	Customer Accounting Reverse Base Sum	Num	19.6	-
CABasSumSc	Customer Accounting Reverse Base Sum (SC)	Num	19.6	-
CABasSumFc	Customer Accounting Reverse Base Sum (FC)	Num	19.6	-
CAVatSum	Customer Accounting Reverse VAT Sum	Num	19.6	-
CAVatSumSc	Customer Accounting Reverse VAT Sum (SC)	Num	19.6	-
CAVatSumFc	Customer Accounting Reverse VAT Sum (FC)	Num	19.6	-
CAOutAcct	Customer Accounting Output Tax Account	nVarChar	15	-
ExtVatPcnt	External VAT Percent	Num	19.6	-
ExtVatSum	External VAT Amount	Num	19.6	-
VatSumSrc	VAT Sum Source	VarChar	1	-	S	S	Internal System Calculation
						E	External Calculation
ExtVatSumF	External VAT Amount (FC)	Num	19.6	-
ExtVatSumS	External VAT Amount (SC)	Num	19.6	-
AcqRevTax	Acquisition/Reverse Corresponding Tax Code	nVarChar	8	-
VatExmPrc	VAT Exemption %	Num	19.6	-
VatExmBase	VAT Base %	Num	19.6	-
RevCharge	Reverse Charge	VarChar	1	-	N	Y	Yes
						N	No

Key	Unique	Field
PRIMARY	Yes	AbsEntry
		LineSeq