iiCompanyId | integer | Company id |
iiDInvoiceId | integer | |
ilDInvoiceVatIsSuspDel | logical |
field name | data type | db field | description |
---|---|---|---|
tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
tcCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
tdDInvoiceBalanceCreditTC | decimal | DInvoice.DInvoiceBalanceCreditTC | TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. |
tdDInvoiceBalanceDebitTC | decimal | DInvoice.DInvoiceBalanceDebitTC | TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency. |
tcDInvoiceDIText | character | DInvoice.DInvoiceDIText | CIDescription. A brief description for the SI posting. |
api annotation: | This field defaults from the DInvoiceDescription. | ||
tdDInvoiceExchangeRate | decimal | DInvoice.DInvoiceExchangeRate | Exchange Rate. The accounting exchange rate used by the invoice. The BC Invoice Amount is calculated based on the exchange rate. If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted. |
tdDInvoiceOriginalCreditCC | decimal | DInvoice.DInvoiceOriginalCreditCC | SC Invoice Amount (CR). This field displays the credit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate. |
tdDInvoiceOriginalCreditLC | decimal | DInvoice.DInvoiceOriginalCreditLC | BC Invoice Amount(CR). This field displays the credit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(CR) and the Exchange rate. |
tdDInvoiceOriginalCreditTC | decimal | DInvoice.DInvoiceOriginalCreditTC | TC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same. |
tdDInvoiceOriginalDebitCC | decimal | DInvoice.DInvoiceOriginalDebitCC | SC Invoice Amount (DR). This field displays the debit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate. |
tdDInvoiceOriginalDebitLC | decimal | DInvoice.DInvoiceOriginalDebitLC | BC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate. |
tdDInvoiceOriginalDebitTC | decimal | DInvoice.DInvoiceOriginalDebitTC | TC AP Amount. This field displays the debit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same. |
ttDInvoicePostingDate | date | DInvoice.DInvoicePostingDate | Posting Date. This field displays the date the sales-related invoice was generated by Invoice Post and Print. This field is updated when the invoice is validated and saved. |
api annotation: | This field defaults from the invoice creation date. | ||
tdDInvoiceRateScale | decimal | DInvoice.DInvoiceRateScale | Scale Factor.This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. The exchange rate is multiplied by the scale factor to determine the actual exchange rate. |
api annotation: | The value for the scale factor defaults from the exchange rate definition, but it can be modified. | ||
ttDInvoiceTaxPointDate | date | DInvoice.DInvoiceTaxPointDate | Tax Point Date. The date to be used in tax calculations. For sales-related invoices, this field displays the tax calculation date on the associated order. |
api annotation: | This field defaults to DInvoicePostingDate. | ||
tcDInvoiceType | character | DInvoice.DInvoiceType | Invoice Type. This field displays the invoice type. Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined. |
api annotation: | PartialUpdate = yes - defaults to Invoice | ||
tiDInvoiceVat_ID | integer | DInvoiceVat.DInvoiceVat_ID | Record ID |
tdDInvoiceVatBaseCreditTC | decimal | DInvoice.DInvoiceVatBaseCreditTC | 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. |
tdDInvoiceVatBaseDebitLC | decimal | DInvoice.DInvoiceVatBaseDebitLC | 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. |
tdDInvoiceVatBaseDebitTC | decimal | DInvoice.DInvoiceVatBaseDebitTC | 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. |
tdDInvoiceVatCreditTC | decimal | DInvoice.DInvoiceVatCreditTC | 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. |
tdDInvoiceVatDebitTC | decimal | DInvoice.DInvoiceVatDebitTC | 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. |
tlDInvoiceVatIsSuspDel | logical | DInvoiceVat.DInvoiceVatIsSuspDel | CInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM. |
api annotation: | PartialUpdate = yes - defaults to false | ||
tlDInvoiceVatIsTaxable | logical | DInvoiceVat.DInvoiceVatIsTaxable | Taxable. This field indicates if the invoice is taxable. |
api annotation: | This field defaults to true if the customer is taxable. | ||
tdDInvoiceVatSuspDelTaxAmtTC | decimal | DInvoiceVat.DInvoiceVatSuspDelTaxAmtTC | Tax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency. |
tcDivisionCode | character | Division3.DivisionCode | Sub-Account |
tcDomainCode | character | Domains.DomainCode | Domain |
tcFromTxzTaxZone | character | PostingVat.FromTxzTaxZone | From Tax Zone. |
api annotation: | ? | ||
tcNormalTaxDivisionCode | character | Division1.DivisionCode | Sub-Account |
tcNormalTaxGLCode | character | GL1.GLCode | A code identifying the GL account. |
tdPostingLineExchangeRate | decimal | PostingLine.PostingLineExchangeRate | Exchange Rate |
api annotation: | Default value for this field depends on the exchang erate shared set specified for the current domain. | ||
tdPostingLineRateScale | decimal | PostingLine.PostingLineRateScale | Scale Factor |
api annotation: | The default value is 1. | ||
tiPostingVat_ID | integer | PostingVat.PostingVat_ID | Record ID |
tdPostingVatBaseCreditCC | decimal | PostingVat.PostingVatBaseCreditCC | SC (Statutory Currency) Base Credit amount. |
tdPostingVatBaseCreditLC | decimal | PostingVat.PostingVatBaseCreditLC | BC (Base/Local Currency) Base Credit amount. |
tdPostingVatBaseCreditTC | decimal | PostingVat.PostingVatBaseCreditTC | TC (Transaction Currency) Base Credit amount. |
tdPostingVatBaseDebitCC | decimal | PostingVat.PostingVatBaseDebitCC | SC (Statutory Currency) Base Debit amount. |
tdPostingVatBaseDebitLC | decimal | PostingVat.PostingVatBaseDebitLC | BC (Base/Local Currency) Base Debit amount. |
tdPostingVatBaseDebitTC | decimal | PostingVat.PostingVatBaseDebitTC | TC (Transaction Currency) Base Debit amount. |
tdPostingVatExchangeRate | decimal | PostingVat.PostingVatExchangeRate | TC/BC Exchange Rate. |
api annotation: | ? | ||
tcPostingVatInOut | character | PostingVat.PostingVatInOut | In/Out? |
api annotation: | Aivalable value for this field: "INPUT" represents purchases, "OUTPUT" represents sales. | ||
tlPostingVatIsReverseCharge | logical | PostingVat.PostingVatIsReverseCharge | Reverse Charge |
tlPostingVatIsSuspDel | logical | PostingVat.PostingVatIsSuspDel | Suspended/Delayed Tax |
tiPostingVatOwnTaxDeclarat | integer | PostingVat.PostingVatOwnTaxDeclarat | Own Declaration Tax |
tcPostingVatOwnTaxIDFeder | character | PostingVat.PostingVatOwnTaxIDFeder | Own Federal Tax? |
api annotation: | ? | ||
tcPostingVatOwnTaxIDMisc1 | character | PostingVat.PostingVatOwnTaxIDMisc1 | Own Miscellaneous Tax 1? For reference and documentation purposes, enter any other tax identification numbers that are useful. |
api annotation: | ? | ||
tcPostingVatOwnTaxIDMisc2 | character | PostingVat.PostingVatOwnTaxIDMisc2 | Own Miscellaneous Tax 2 |
tcPostingVatOwnTaxIDMisc3 | character | PostingVat.PostingVatOwnTaxIDMisc3 | Own Miscellaneous Tax 3 |
tcPostingVatOwnTaxIDState | character | PostingVat.PostingVatOwnTaxIDState | Own State Tax? |
api annotation: | ? | ||
tdPostingVatRateScale | decimal | PostingVat.PostingVatRateScale | Scale Factor (TC/BC). |
api annotation: | ? | ||
tdPostingVatTaxCreditCC | decimal | PostingVat.PostingVatTaxCreditCC | SC (Statutory Currency) Tax Credit amount. |
api annotation: | ? | ||
tdPostingVatTaxCreditLC | decimal | PostingVat.PostingVatTaxCreditLC | BC (Base/Local) Tax Credit amount. |
api annotation: | ? | ||
tdPostingVatTaxCreditTC | decimal | PostingVat.PostingVatTaxCreditTC | TC (Transaction Currency) Tax Credit amount. |
api annotation: | ? | ||
tdPostingVatTaxDebitCC | decimal | PostingVat.PostingVatTaxDebitCC | SC (Statutory Currency) Tax Debit amount. |
api annotation: | ? | ||
tdPostingVatTaxDebitLC | decimal | PostingVat.PostingVatTaxDebitLC | BC (Base Currency) Tax Debit amount. |
api annotation: | ? | ||
tdPostingVatTaxDebitTC | decimal | PostingVat.PostingVatTaxDebitTC | TC (Transaction Currency) Tax Debit amount. |
api annotation: | ? | ||
tcPostingVatTaxIDFeder | character | PostingVat.PostingVatTaxIDFeder | Federal Tax? |
api annotation: | ? | ||
tcPostingVatTaxIDMisc1 | character | PostingVat.PostingVatTaxIDMisc1 | Miscellaneous Tax 1. For reference and documentation purposes, enter any other tax identification numbers that are useful. |
api annotation: | ? | ||
tcPostingVatTaxIDMisc2 | character | PostingVat.PostingVatTaxIDMisc2 | Miscellaneous Tax 2 |
tcPostingVatTaxIDMisc3 | character | PostingVat.PostingVatTaxIDMisc3 | Miscellaneous Tax 3 |
tcPostingVatTaxIDState | character | PostingVat.PostingVatTaxIDState | State Tax? |
api annotation: | ? | ||
ttPostingVatTaxPointDate | date | PostingVat.PostingVatTaxPointDate | The date when this posting is taken into account in the Tax sub-adminstration. |
api annotation: | ? | ||
tcPostingVatTaxTransType | character | PostingVat.PostingVatTaxTransType | Tax Transaction Type? |
api annotation: | Available value for this field: 29 represents "AP Payment Check (Discount at Payment)", 55 represents "AP Transactions", 22 represents "AP Invoice", 18 represents "AR Invoice", 16 represents "AR Operational Invoice", 19 represents "AR Payment (Discount at Payment)", 56 represents "AR Transactions", 45 represents "Logistic Accounting - DO Shipment", 27 represents "Logistic Accounting - PO Receipt", 43 represents "Logistic Accounting - SO Shipment", 20 represents "Purchase Order", 21 represents "Purchase Order Receipt", 25 represents "Purchase Order Return" | ||
tcPostingVatTransType | character | PostingVat.PostingVatTransType | Transaction Type? |
api annotation: | Available value for this field is: ACQUISITION represents "IC Acquisition", BOTH represents "Both", EXPORT represents "Export", IN represents "IN", OUT represents "OUT", IMPORT represents "Import", INLAND-PURCHASE represents "INLAND-PURCHASE", INLAND-SALES represents "INLAND-SALES", PURCHASE represents "Inland Purchase", SALES represents "Inland Sales", SUPPLY represents "IC Supply", TRIANGULARPURCHASE represents "Triangular Purchase", TRIANGULARSALES represents "Triangular Sales". | ||
tcProjectCode | character | Project.ProjectCode | Project |
tcSuspTaxDivisionCode | character | Division2.DivisionCode | Sub-Account |
tcSuspTaxGLCode | character | GL2.GLCode | A code identifying the GL account. |
tcToTxzTaxZone | character | PostingVat.ToTxzTaxZone | To Tax Zone |
api annotation: | ? | ||
tcTxclTaxCls | character | PostingVat.TxclTaxCls | Tax Class. A tax class previously defined in Tax Class Maintenance. Tax classes group addresses taxed at specific rates or that are tax-exempt and help determine the default tax environment (set of tax types) for related transactions. |
api annotation: | The value of Tax Class defaults to the header of transactions created for this address | ||
tcTxenvTaxEnv | character | PostingVat.TxenvTaxEnv | Tax Environment. A code (maximum 16 characters) that identifies a set of tax types for a tax zone/tax class combination. On transactions, this code identifies the transaction or line-item tax environment. |
api annotation: | ? | ||
tcTxtyTaxType | character | PostingVat.TxtyTaxType | Tax Type |
tcTxuTaxUsage | character | PostingVat.TxuTaxUsage | Tax Usage. A tax usage code previously defined in Tax Usage Maintenance. Tax usage codes identify the normal use of items sold to this address. Common tax usages are retail, manufacturing, and industrialization. |
api annotation: | The value of Tax Usage defaults to the header of transactions created for this address. | ||
tcVatCode | character | Vat.VatCode | Tax Code |
tcVatInOut | character | Vat.VatInOut | Tax In/Out |