project QadFinancials > class BCInvoice > dataset tApiCInvoiceVat


copy of class table tCInvoiceVat

table tApiCInvoiceVat

Description

API table for CInvoiceVat

field namedata typedescription
CInvoiceVat_IDinteger
CInvoice_IDinteger
Vat_IDinteger
NormalTaxGL_IDinteger
NormalTaxDivision_IDinteger
AbsRetTaxGL_IDinteger
AbsRetTaxDivision_IDinteger
SuspDelTaxGL_IDinteger
SuspDelTaxDivision_IDinteger
PostingVat_IDinteger
CInvoiceVatVatBaseDebitLCdecimal(4)BC Base Amount DR. This field displays the debit base amount in the base currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
CInvoiceVatVatBaseCreditLCdecimal(4)BC Base Amount CR. This field displays the credit base amount in the base currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
CInvoiceVatVatBaseDebitTCdecimal(4)TC Base Amount DR. This field displays the debit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatBaseCreditTCdecimal(4)TC Base Amount CR. This field displays the credit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatBaseDebitCCdecimal(4)SC Base Amount DR. This field displays the debit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
CInvoiceVatVatBaseCreditCCdecimal(4)SC Base Amount CR. This field displays the credit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
CInvoiceVatVatDebitLCdecimal(4)BC Tax Amount DR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount DR and the Exchange rate.
CInvoiceVatVatCreditLCdecimal(4)BC Tax Amount CR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount CR and the Exchange rate.
CInvoiceVatVatDebitTCdecimal(4)TC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatCreditTCdecimal(4)TC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatDebitCCdecimal(4)SC Tax Amount DR. This field displays the debit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount DR and the SC rate.
CInvoiceVatVatCreditCCdecimal(4)SC Tax Amount CR. This field displays the credit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount CR and the SC rate.
CInvoiceVatIsTaxablelogicalTaxable. This field indicates if the invoice is taxable.
This field defaults to true if the supplier is taxable.
CInvoiceVatNonRecTaxAmtTCdecimal(4)Non-Rev Tax Amount. This field displays the percentage of tax that is not recoverable.
Taxes are recoverable whenever your company is eligible to offset a percentage of tax on purchases against tax collected on sales. Recoverable taxes are common in Europe.
CInvoiceVatIsUpdAllowlogicalUpdate Tax Allowed. When this is field is true, you can modify the base and tax credit and debit amounts during transaction entry.
This field is useful for overriding the system if there is a need to match amounts on manually issued documents. In some environments, tax authorities require that you cannot modify the calculated tax amounts.
CInvoiceVatIsAbsRetlogicalRetained. This field indicates that the tax rate in use has been configured to retain taxes for payment directly to the government.
CInvoiceVatIsAccrRcpUslogicalCInvoiceVatIsAccrRcpUS Tax is accrued at receipt. This is a parameter of the tax rate code in GTM.
CInvoiceVatTaxTrTypecharacterCInvoiceVatTaxTrType Tax transaction type. This is a parameter of the tax rate code in GTM.
CInvoiceVatIsRevChargelogicalCInvoiceIsRevCharge.This field indicates if the invoice tax is of type Reverse Charge.
CInvoiceVatUILinkedRowIDcharacter
CInvoiceVatSequenceintegerCInvoceVatSequence.The sequentiel number of the tax line on the invoice.
CInvoiceVatNTBaseDebitTCdecimal(4)TC Base Debit Non-taxable. This field displays the Non-taxable debit base amount in the transaction currency.
This is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatNTBaseCreditTCdecimal(4)TC Base Credit Non-taxable. This field displays the Non-taxable credit base amount in the transaction currency.
This is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatIsSuspDellogicalCInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM.
CInvoiceVatSuspDelTaxAmtTCdecimal(4)Tax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency.
TxuTaxUsagecharacterTax Usage. These fields default from the supplier, and can be modified.
TxenvTaxEnvcharacterTax Environment. This field is automatically calculated based on the supplier and ship-to address details, and can be modified.
TxclTaxClscharacterTax Class. This field default from the supplier, and can be modified.
TxtyTaxTypecharacterTax Type. This field displays the tax type, which defaults from the tax environment.
tdCInvoiceVatVatBaseDebitVCdecimal(4)Obsolete field.
tdCInvoiceVatVatBaseCreditVCdecimal(4)Obsolete field.
tdCInvoiceVatVatDebitVCdecimal(4)Obsolete field.
tdCInvoiceVatVatCreditVCdecimal(4)Obsolete field.
tlIsRecalculateTaxlogicalRecalc. When you change the tax class, tax usage, tax environment, or the Taxable fields or modify one of the base amounts, this field is automatically set to true,and the system recalculates the amounts when you have completed the line in the grid. You can also manually set this field to true or false.
tcDomainCodecharacterDomain. This field displays the doamin of the invoice (the current domain).
tcVatInOutcharactertcVatInOut Indication if the tax in Input (tax on purchases) or Output (tax on sales).
tcVatCodecharacterTax Code. This field displays the code of the tax rate, based on the tax environment for the combination of supplier and ship-to address.
tcNormalTaxGLCodecharacterNormal Tax Account. This field indicates the Gl account for tax use.
The Tax accounts are defined for the current domain in Domain/Account Control.
tcNormalTaxDivisionCodecharacterNormal Tax Sub-Account. This field indicates the sub-account if the supplier control account is defined with sub-account analysis.
tcAbsRetTaxGLCodecharacterRetained Tax Account. This field indicates the GL account used to retain the tax.
When you have selected the Retained/Absorbed options.
This field is defined in Tax Rate Maintenance.
tcAbsRetTaxDivisionCodecharacterRetained Tax Sub-Account.This field indicates the sub- Account used to retain the tax.
When you have selected the Retained/Absorbed options.
This field is defined in Tax Rate Maintenance.
tcSuspDelTaxGLCodecharacterDelayed Tax Account. This field indicates the GL account used to handle the delayed tax.
tcSuspDelTaxDivisionCodecharacterDelayed Tax Sub-Account. This field indicates the sub-account used to handle the delayed tax.
tlTx2InvDisclogicalDiscount invoice at Invoice?
tdCInvoiceVatExchangeRateCCdecimal(10)SC Exchange Rate
LastModifiedDatedate
LastModifiedTimeinteger
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


QadFinancials
method BCInvoice.AllocateCInvoices
method BCInvoice.ApiStdMaintainTT
method BCInvoice.ApiStdMaintainTTV01
method BCInvoice.ApiUpdateCInvoiceFromAPM
method BCInvoice.CreateCIPosting
method BCInvoice.CreateCIPosting2
method BCInvoice.CreateMFPosting
method BCInvoice.CreatePostingCalculateTotInvAmount
method BCInvoice.DefaultValuesTaxInfo
method BCInvoice.UpdateCInvoiceFromAPM