Share via


CustInvoiceTrans Table

The CustInvoiceTrans table contains all the sales invoice lines that are posted in Microsoft Dynamics AX that originate from sales order lines.

Configuration Key: LedgerBasic

Methods

  Method Description
Gg943036.pubmethod(en-us,AX.60).gif accountDisc_RU
Gg943036.pubmethod(en-us,AX.60).gif accountSales_RU
Gg943036.pubmethod(en-us,AX.60).gif amountDiscAmount
Gg943036.pubmethod(en-us,AX.60).gif amountDiscPercentInclTax
Gg943036.pubmethod(en-us,AX.60).gif amountExclTax
Gg943036.pubmethod(en-us,AX.60).gif aosValidateDelete Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif aosValidateInsert Validates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif aosValidateRead Validates on the server that the specified record can be read. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif aosValidateUpdate Validates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif buf2con Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif calcContributionMargin Calculates the contribution margin for the currently selected CustInvoiceTrans record.
Gg943036.pubmethod(en-us,AX.60).gif calcContributionRatio Calculates the contribution ratio for the currently selected CustInvoiceTrans record.
Gg943036.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif canSubmitToWorkflow Indicates whether submission to workflow is possible. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif caption Gets and sets the caption property of a table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif checkInvalidFieldAccess Gets and sets invalid field access. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif checkRecord Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif checkRestrictedDeleteActions Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif clear Removes all rows from the table buffer. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif commissionLedgerDimension
Gg943036.pubmethod(en-us,AX.60).gif commissionOffsetLedgerDimension
Gg943036.pubmethod(en-us,AX.60).gif company Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif companyInfo Retrieves the CompanyInfo record associated with the current record.
Gg943036.pubmethod(en-us,AX.60).gif con2buf Unpacks a container into the table buffers. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif concurrencyModel Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif context Gets and sets the context property. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif contributionMargin
Gg943036.pubmethod(en-us,AX.60).gif contributionMarginMST
Gg943036.pubmethod(en-us,AX.60).gif contributionRatio
Gg943036.pubmethod(en-us,AX.60).gif copyDimension Retrieves a dimension set that can be applied to the defaultDimension field on this table.
Gg943036.pubmethod(en-us,AX.60).gif costValue
Gg943036.pubmethod(en-us,AX.60).gif custInvoicedItemPreviewPaneTitle
Gg943036.pubmethod(en-us,AX.60).gif custInvoiceJour
Gg943036.pubmethod(en-us,AX.60).gif custInvoiceLineProjCategoryId
Gg943036.pubmethod(en-us,AX.60).gif custInvoiceLineProjId
Gg943036.pubmethod(en-us,AX.60).gif custInvoiceTrans_IN Gets the CustInvoiceTrans_IN record associated with the current record.
Gg943036.pubmethod(en-us,AX.60).gif custInvoiceTrans_Intrastat Retrieves CustInvoiceTrans_Intrastat extension table record.
Gg943036.pubmethod(en-us,AX.60).gif custInvoiceTrans_RU Gets the CustInvoiceTrans_RU record associated with the current record.
Gg943036.pubmethod(en-us,AX.60).gif custInvoiceTrans_W Gets the CustInvoiceTrans_W record associated with the current record.
Gg943036.pubmethod(en-us,AX.60).gif custTable_InvoiceAccount
Gg943036.pubmethod(en-us,AX.60).gif data Retrieves a row from the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif dataSource Retrieves the data source of the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif defaultField Populates default values in a field in the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif defaultRow Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif delete Deletes the current record from the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif deliveryAddress
Gg943036.pubmethod(en-us,AX.60).gif deliveryDate Gets delivery date of the CustPackingSlipTrans table.
Gg943036.pubmethod(en-us,AX.60).gif disableCache Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif displayReverseChargeApplies_UK
Gg943036.pubmethod(en-us,AX.60).gif displayTaxAmount Returns the tax amount for the posted invoice.
Gg943036.pubmethod(en-us,AX.60).gif displayTaxWithholdAmount_IN Display the tax withhold amount.
Gg943036.pubmethod(en-us,AX.60).gif dispose Releases resources that are used by the xRecord object. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif doClear Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif documentId Gets PackingSlipId of the CustPackingSlipTrans table.
Gg943036.pubmethod(en-us,AX.60).gif doDelete Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif doInsert Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif doUpdate Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif doValidateDelete Performs the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif editDomesticSalesTaxGroup_PL Edits the domestic sales tax group for the export sales.
Gg943036.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif exchRate
Gg943036.pubmethod(en-us,AX.60).gif existsCorrLink_RU Determines if there is link between this record and corrected record, e.g. this record is corrected record.
Gg943036.pubmethod(en-us,AX.60).gif fieldAccessRight Returns the field access right. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif fieldBufferAccessRight Returns the field access right for the current record. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif fieldState Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif fullyFactured_RU
Gg943036.pubmethod(en-us,AX.60).gif getAllowRedefault Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getDefaultingDependencies Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getExtension Returns the table extension. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getFieldValue Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getIndirectTax Displays the sum SourceRegulateAmountCur value for the custinvoicetrans.
Gg943036.pubmethod(en-us,AX.60).gif getInstanceRelationType Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getItemType Displays the ItemType value for the item.
Gg943036.pubmethod(en-us,AX.60).gif getPhysicalTableName Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getPresenceFieldData Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getSQLStatement Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getTableInInstanceHierarchy (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getTableType Indicates the type of the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif grossAmount
Gg943036.pubmethod(en-us,AX.60).gif grossAmountInclTax
Gg943036.pubmethod(en-us,AX.60).gif grossAmountMST
Gg943036.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif hasRelatedTable Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif helpField Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif initFromCustInvoiceJour
Gg943036.pubmethod(en-us,AX.60).gif initFromCustInvoiceLine Copies data from the specified table to the CustInoiceTrans table.
Gg943036.pubmethod(en-us,AX.60).gif initFromLedgerJournalTrans
Gg943036.pubmethod(en-us,AX.60).gif initFromLedgerJournalTrans_RU
Gg943036.pubmethod(en-us,AX.60).gif initFromRBOSalesTrans
Gg943036.pubmethod(en-us,AX.60).gif initFromSalesLine
Gg943036.pubmethod(en-us,AX.60).gif initFromSalesLineForeignTradeCategory Initializes the CustInvoiceTrans record from the SalesLineForeignTradeCategory record.
Gg943036.pubmethod(en-us,AX.60).gif initFromTaxTrans_RU
Gg943036.pubmethod(en-us,AX.60).gif initFromTaxWorkTrans_RU
Gg943036.pubmethod(en-us,AX.60).gif initValue Initializes a field to the default value. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif inputStatus Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif insert Inserts the current record into the database.
Gg943036.pubmethod(en-us,AX.60).gif interactiveContext Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif interCompanySourceTable
Gg943036.pubmethod(en-us,AX.60).gif inventCostAmount Calculates the cost amount of the journal line.
Gg943036.pubmethod(en-us,AX.60).gif inventDim
Gg943036.pubmethod(en-us,AX.60).gif inventLocationId
Gg943036.pubmethod(en-us,AX.60).gif inventQty
Gg943036.pubmethod(en-us,AX.60).gif inventQtyToDelivery_RU Calculates Qty which availiable for delivery in Inventory units.
Gg943036.pubmethod(en-us,AX.60).gif inventSiteId
Gg943036.pubmethod(en-us,AX.60).gif inventTable
Gg943036.pubmethod(en-us,AX.60).gif invoiceAccount
Gg943036.pubmethod(en-us,AX.60).gif isCategoryBased Determines whether the journal line is category based.
Gg943036.pubmethod(en-us,AX.60).gif isExportTrans_RU
Gg943036.pubmethod(en-us,AX.60).gif isFieldDataRetrieved Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif isFieldSet Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif isFormDataSource Indicates whether the data source is a form. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif isInterCompany Determines whether or not the record is intercompany.
Gg943036.pubmethod(en-us,AX.60).gif isNewRecord Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif isPartOfUOWSaveChanges (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif isStocked Checks whether the journal line is tracked in inventory.
Gg943036.pubmethod(en-us,AX.60).gif isTempDb Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif isTmp Indicates whether this is a temporary table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif isTransferFromCurrentCompany Determines whether the items are transferred from the current company or from the intercompany company.
Gg943036.pubmethod(en-us,AX.60).gif itemId_W
Gg943036.pubmethod(en-us,AX.60).gif itemName
Gg943036.pubmethod(en-us,AX.60).gif itemName_RU Returns item name for current CustInvoiceTrans line
Gg943036.pubmethod(en-us,AX.60).gif joinChild Finds the join child of the current record. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif joinParent Finds the join parent of the current record. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif lineAmountInclTax
Gg943036.pubmethod(en-us,AX.60).gif lineAmountPreAddOfSalesMarkup
Gg943036.pubmethod(en-us,AX.60).gif lineAmountPreAddOfSalesMarkupInclTax
Gg943036.pubmethod(en-us,AX.60).gif lineAmountPreSubOfDiscAmount
Gg943036.pubmethod(en-us,AX.60).gif lineAmountPreSubOfDiscAmountInclTax
Gg943036.pubmethod(en-us,AX.60).gif lineAmountPreSubOfDiscPercent
Gg943036.pubmethod(en-us,AX.60).gif lineAmountPreSubOfDiscPercentInclTax
Gg943036.pubmethod(en-us,AX.60).gif linkPhysicalTableInstance Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif mcrInitFromSalesParmLine Initializes custinvoicetrans from salesparmline.
Gg943036.pubmethod(en-us,AX.60).gif mcrQtyInvoice Retrieves the invoiced quantity from the InventTrans table.
Gg943036.pubmethod(en-us,AX.60).gif mcrQtyInvoicePerBatch Retrieves the invoiced quantity for the passed InventBatchId.
Gg943036.pubmethod(en-us,AX.60).gif mcrQtyInvoicePerBatchPriceMatch Retrieves the invoiced quantity for the passed SalesLine object with a price match.
Gg943036.pubmethod(en-us,AX.60).gif merge Merges the current table with the specified table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif mergeDimension Retrieves a dimension set that holds the merged combination of the current defaultDimensionfield on this table and the provided dimension set.
Gg943036.pubmethod(en-us,AX.60).gif modifiedField Modifies the specified field to the original. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif modifiedFieldValue Modifies the specified field to the original value. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif new Initializes a new instance of the Object class. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif orderAccount
Gg943036.pubmethod(en-us,AX.60).gif orig Retrieves the original values of the current record. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif overwriteSystemfields Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif packCustInvoiceTrans_IN Packs the CustInvoiceTrans_IN record associated with the current record.
Gg943036.pubmethod(en-us,AX.60).gif packCustInvoiceTrans_Intrastat Packs CustInvoiceTrans_Intrastat extension table record.
Gg943036.pubmethod(en-us,AX.60).gif packCustInvoiceTrans_RU Packs the CustInvoiceTrans_RU record associated with the current record.
Gg943036.pubmethod(en-us,AX.60).gif packCustInvoiceTrans_W Packs the CustInvoiceTrans_W record associated with the current record.
Gg943036.pubmethod(en-us,AX.60).gif packingSlipId Gets PackingSlipId of the CustPackingSlipTrans table.
Gg943036.pubmethod(en-us,AX.60).gif packingSlipIdAndDate Gets PackingSlipId and delivery date in a container of the CustPackingSlipTrans table.
Gg943036.pubmethod(en-us,AX.60).gif parmExchangeRateDate Returns the date used as the basis for calculating the exchange rate.
Gg943036.pubmethod(en-us,AX.60).gif pdsCWQtyToDelivery_RU Calculates Qty which availiable for delivery in catch weight units.
Gg943036.pubmethod(en-us,AX.60).gif pdsCWUnitId Gets the catch weight unit for the item.
Gg943036.pubmethod(en-us,AX.60).gif postCacheLoad Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif postLoad Is executed after a record is read. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif preRemoting Is executed before a cross-tier call is about to be executed for the table that would pack its state to the other tier. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif priceAfterDisc_PL
Gg943036.pubmethod(en-us,AX.60).gif qty Calculates the quantity to be displayed
Gg943036.pubmethod(en-us,AX.60).gif qty_W
Gg943036.pubmethod(en-us,AX.60).gif qtyDelivered_RU
Gg943036.pubmethod(en-us,AX.60).gif qtyDeliveryReturned_RU
Gg943036.pubmethod(en-us,AX.60).gif qtyRemainReturnCreditNote
Gg943036.pubmethod(en-us,AX.60).gif qtyToDelivery_RU
Gg943036.pubmethod(en-us,AX.60).gif queryTimedOut Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif queryTimeout Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif readCommittedLock (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif readPast Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif recordLevelSecurity Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif refAdjustedTransRecId_RU Gets adjusted line record id.
Gg943036.pubmethod(en-us,AX.60).gif relatedTable Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif renamePrimaryKey Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif reread Rereads the record from the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif returnLineAmount Calculating line amount for the return of items.
Gg943036.pubmethod(en-us,AX.60).gif RowCount Retrieves the number of rows in the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif salesLine
Gg943036.pubmethod(en-us,AX.60).gif salesUnitTxt
Gg943036.pubmethod(en-us,AX.60).gif selectForUpdate Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif selectLocked Indicates whether to select locked records. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif selectRefRecord Selects the record by referenced field ID. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif selectWithRepeatableRead Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif setConnection Sets the user connection for this table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif setCrossPartition Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif setFieldValue Sets the field value in the record buffer. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif setLinenum
Gg943036.pubmethod(en-us,AX.60).gif setSQLTracing Enables or disables SQL tracing mode. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif setTmp Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif setTmpData Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif setXDSContext Sets new XDS context. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif skipAosValidation Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif skipDatabaseLog Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif skipDataMethods Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif skipDeleteActions Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif skipDeleteMethod Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif skipEvents Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif skipPostLoad Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif skipTTSCheck Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif suppressWarnings Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif tableAccessRight Returns the table access right. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif tableBufferAccessRight Returns the table access right for the current record. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif takeOwnershipOfTempDBTable (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif taxAmountIncludedCur_BR Returns the total tax included amount in document currency
Gg943036.pubmethod(en-us,AX.60).gif taxAmountIncludedMST_BR Returns the total tax included amount in company currency
Gg943036.pubmethod(en-us,AX.60).gif toolTipField Retrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif toolTipRecord Retrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif ttsabort Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif ttsbegin Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif ttscommit Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif unit_W
Gg943036.pubmethod(en-us,AX.60).gif update Updates the current record in the database.
Gg943036.pubmethod(en-us,AX.60).gif updateCommission
Gg943036.pubmethod(en-us,AX.60).gif usageCount Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif useExistingTempDBTable (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif validateDelete Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif validateField Determines whether the specified field is valid. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif validateFieldValue (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif validateWrite Determines whether the current record is valid and ready to be written. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif validTimeStateUpdateMode Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif vatType_RU
Gg943036.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg943036.pubmethod(en-us,AX.60).gif wasCached Specifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif write Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gif xml Retrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::exist
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::existSalesId
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::findByCustInvoiceLineRefId Finds a specific CustInvoiceTrans record.
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::findBySourceDocumentLine Finds the specified record in the CustInvoiceTrans table.
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::findCustInvoiceTrans
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::findCustInvoiceTransFromTaxTrans_IN Finds the record in the CustInvoiceTrans table.
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::findFacture_RU
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::findInventTransid
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::findOriginalTrans_RU Returns container holding chain of corrected invoice trans records
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::findRecId
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::getOrderedQty_IN Gets ordered quantity.
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::getReceive_IN Gets received quantity.
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::numOfLines Determines the number of lines that are associated with the specified invoice transaction.
Gg943036.pubmethod(en-us,AX.60).gifGg943036.static(en-us,AX.60).gif ::updateIntrastatFulfillDatePackingSlip_HU Updates the packing slip transaction with the IntrastatFulfillmentDate_HU value.

Top

Fields

Field Type Configuration key Description
AssetBookId Extended Data Type: AssetBookIdPurchSalesInvent
Type: String
Asset Value model related to the current transaction.
AssetId Extended Data Type: AssetIdOpen
Type: String
Asset Unique key for identification of fixed asset. The key is used when creating new assets.
BillingCode Extended Data Type: BillingCode
Type: String
PublicSector Define a set of default billing values and rates for a free text invoice line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
CommissAmountCur Extended Data Type: CommissAmountCur
Type: Real
Commission Calculated commission on current invoice line
CommissAmountMST Extended Data Type: CommissAmountMST
Type: Real
Commission Calculated commission on current invoice line
CommissCalc Extended Data Type: CommissCalc
Type: Enum
Commission Has a commission been calculated in the current invoice line?
CountryRegionOfShipment Extended Data Type: AddressCountryRegionId
Type: String
None Country/region from where the order was shipped
createdBy Extended Data Type: CreatedBy
Type: String
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
createdDateTime Extended Data Type: CreatedDateTime
Type: UtcDateTime
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CurrencyCode Extended Data Type: CustCurrencyCode
Type: String
None Current currency code
CustInvoiceLineIdRef Extended Data Type: CustInvoiceLineIdRefRecId
Type: Int64
None Reference field in a different table
CustomerLineNum Extended Data Type: CustLineNum
Type: Integer
None Customer's line number.
dataAreaId Extended Data Type: DataAreaId
Type: String
None
DefaultDimension Extended Data Type: DimensionDefault
Type: Int64
LedgerBasic Default dimensions
dEL_CreatedTime Extended Data Type: DEL_CreatedTime
Type: Integer
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
DeliveryPostalAddress Extended Data Type: LogisticsPostalAddressRecId
Type: Int64
None Reference field in a different table
DeliveryType Extended Data Type: TradeLineDlvTypeId
Type: Enum
None Delivery type of the current order line.
DiscAmount Extended Data Type: SalesDiscAmount
Type: Real
PriceDisc The amount in the transaction currency
DiscPercent Extended Data Type: SalesDiscPercent
Type: Real
PriceDisc Discount in percentage.
DlvDate Extended Data Type: SalesShippingDate
Type: Date
LogisticsBasic Confirmed ship date if exists, otherwise requested ship date
EInvoiceAccountCode Extended Data Type: EInvoiceAccountCode
Type: String
None When settling to a public sector organization it is possible to specify a dimension account code.
ExternalItemId Extended Data Type: SalesExternalItemId
Type: String
LogisticsBasic Customer item number.
InterCompanyInventTransId Extended Data Type: InventTransId
Type: String
LogisticsBasic Identification of the item lot.
IntrastatDispatchId Extended Data Type: IntrastatDispatchId
Type: String
ForeignTrade Shipment batch number in Intrastat.
IntrastatFulfillmentDate_HU Extended Data Type: IntrastatFulfillmentDate_HU
Type: Date
ForeignTrade Date of Intrastat fulfillment. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InventDimId Extended Data Type: InventDimId
Type: String
None Identification of dimensions for the item.
InventQty Extended Data Type: InventQty
Type: Real
None Quantity of the item in inventory unit
InventRefId Extended Data Type: InventRefId
Type: String
None Number of the order, project, production, or purchase referred to
InventRefTransId Extended Data Type: InventRefTransId
Type: String
LogisticsBasic Lot ID referred to.
InventRefType Enumeration: InventRefType
None Module and number referred to
InventTransId Extended Data Type: TradeInventTransId
Type: String
LogisticsBasic Identification of the item lot.
InvoiceDate Extended Data Type: TransDate
Type: Date
None Transaction date
InvoiceId Extended Data Type: CustInvoiceId
Type: String
LedgerBasic Invoice number
ItemCodeId Extended Data Type: IntrastatItemCodeId
Type: String
ForeignTrade Item commodity code
ItemId Extended Data Type: ItemId
Type: String
LogisticsBasic Identify item.
LedgerDimension Extended Data Type: LedgerDimensionDefaultAccount
Type: Int64
LedgerBasic Default main account used for posting in ledger
LineAmount Extended Data Type: AmountCur
Type: Real
None The amount in the transaction currency
LineAmountMST Extended Data Type: AmountMST
Type: Real
None The transaction amount, in the accounting currency
LineAmountTax Extended Data Type: LineAmountTax
Type: Real
LogisticsBasic Sales tax amount included in the amount because sales tax is included in prices
LineAmountTaxMST Extended Data Type: LineAmountTaxMST
Type: Real
LogisticsBasic Sales tax amount included in the amount because sales tax is included in prices
LineDisc Extended Data Type: SalesLineDisc
Type: Real
PriceDisc Line discount in amount per price unit.
LineHeader Extended Data Type: LineHeader
Type: String
None Text describing the line
LineNum Extended Data Type: LineNum
Type: Real
None Identification of line.
LinePercent Extended Data Type: SalesLinePercent
Type: Real
PriceDisc Line discount percentage.
MCRDeliveryName Extended Data Type: CustName
Type: String
LedgerBasic The name that is associated with the selected delivery address (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRDlvMode Extended Data Type: CustDlvModeId
Type: String
None The means by which the order will be delivered (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
modifiedDateTime Extended Data Type: ModifiedDateTime
Type: UtcDateTime
None
MultiLnDisc Extended Data Type: SalesMultiLnDisc
Type: Real
PriceDisc Multiline discount per price unit
MultiLnPercent Extended Data Type: SalesMultiLnPercent
Type: Real
PriceDisc The multiline discount percentage
Name Extended Data Type: ItemFreeTxtBase
Type: String
None Standard item description.
NGPCodesTable_FR Extended Data Type: NGPCodesTableFRId
Type: Int64
None French national item code
numberSequenceGroup Extended Data Type: NumberSequenceGroupId
Type: String
None Group for allocation of different number sequences to different customers/vendors.
OLAPCostValue Extended Data Type: SalesCostValue
Type: Real
LogisticsBasic Cost value for quantity.
OrigCountryRegionId Extended Data Type: ItemOrigCountryRegionId
Type: String
ForeignTrade Country/region of origin of the current inventory item
OrigSalesId Extended Data Type: SalesIdOrig
Type: String
LogisticsBasic Order that the line is generated from
OrigState Extended Data Type: ItemOrigStateId
Type: String
ForeignTrade State of origin for the current item
ParentRecId Extended Data Type: RefRecId
Type: Int64
None Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PartDelivery Extended Data Type: PartDelivery
Type: Enum
None Has part delivery been made?
Partition Extended Data Type: Partition
Type: Int64
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PdsCWQty Extended Data Type: PdsCWInventQty
Type: Real
PdsCatchWeight Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCWQtyPhysical Extended Data Type: PdsCWInventQty
Type: Real
PdsCatchWeight CW physical quantity delivered without packing slip. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCWRemain Extended Data Type: PdsCWInventQty
Type: Real
PdsCatchWeight Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
Port Extended Data Type: IntrastatPortId
Type: String
ForeignTrade Port where current delivery is loaded.
PriceUnit Extended Data Type: PriceUnit
Type: Real
LogisticsBasic Number of units the price is specified in.
Qty Extended Data Type: SalesInvoicedQty
Type: Real
None Quantity that was invoiced in sales units.
QtyPhysical Extended Data Type: SalesQty
Type: Real
None Physical quantity delivered without packing slip
ReasonRefRecId Extended Data Type: ReasonRefRecID
Type: Int64
None Contains stored financial reason codes and comments for entered or posted transactions or actions.
RecId Extended Data Type: RecId
Type: Int64
None
recVersion Extended Data Type: RecVersion
Type: Integer
None
Remain Extended Data Type: SalesQty
Type: Real
None Number of sales units.
RemainBefore Extended Data Type: SalesQty
Type: Real
None Number of sales units.
RetailCategory Extended Data Type: RetailCategory
Type: Int64
RetailHeadquarters Category identifier (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS))
ReturnArrivalDate Extended Data Type: ReturnArrivalDate
Type: Date
ReturnItem Date when the return delivery was received.
ReturnClosedDate Extended Data Type: ReturnClosedDate
Type: Date
ReturnItem Date when the return line was invoiced or cancelled.
ReturnDispositionCodeId Extended Data Type: ReturnDispositionCodeId
Type: String
ReturnItem Identification of the disposition code.
ReverseChargeApplies_UK Extended Data Type: ReverseChargeApplies_UK
Type: Enum
None Is reverse charge applicable?
ReversedRecId Extended Data Type: RefRecId
Type: Int64
None Reference field in a different table
SalesCategory Extended Data Type: SalesCategory
Type: Int64
LogisticsBasic Category from the sales category hierarchy
SalesGroup Extended Data Type: CommissSalesGroup
Type: String
Commission Commission sales group
SalesId Extended Data Type: SalesId
Type: String
LogisticsBasic Order that the current line is attached to.
SalesMarkup Extended Data Type: SalesMarkup
Type: Real
LogisticsBasic Fixed charges on sales price, which are independent of quantity
SalesPrice Extended Data Type: SalesPrice
Type: Real
None Overview of sales price setup for costs.
SalesUnit Extended Data Type: SalesUnit
Type: String
None Unit the item is sold in.
SourceDocumentLine Extended Data Type: RefRecId
Type: Int64
None Reference field in a different table
StatLineAmountMST Extended Data Type: IntrastatLineAmountMST
Type: Real
ForeignTrade The transaction amount, in the accounting currency
StatProcId Extended Data Type: IntrastatProcId
Type: String
ForeignTrade Code for the current statistical procedure.
StockedProduct Extended Data Type: TradeStockedProduct
Type: Enum
LogisticsBasic Track in inventory?
SumLineDisc Extended Data Type: SalesSumLineDiscAmount
Type: Real
PriceDisc Line discount total of the lines
SumLineDiscMST Extended Data Type: SalesSumLineDiscAmountMST
Type: Real
PriceDisc Line discount total of the lines
TaxAmount Extended Data Type: TaxAmountCur
Type: Real
LedgerBasicSalesTax Calculated sales tax amount in the sales tax settlement currency
TaxAmountMST Extended Data Type: TaxAmount
Type: Real
LedgerBasicSalesTax Calculated sales tax amount.
TaxAutogenerated Extended Data Type: TaxAutoGenerated
Type: Enum
LedgerBasicSalesTax Sales tax is automatically calculated or specified by user.
TaxGroup Extended Data Type: TaxGroup
Type: String
LedgerBasicSalesTax A group of sales tax codes for calculating taxes on a sale or purchase
TaxItemGroup Extended Data Type: TaxItemGroup
Type: String
LedgerBasicSalesTax Group of sales tax codes that can be calculated for an item.
TaxWithholdGroup_TH Extended Data Type: TaxWithholdGroup
Type: String
LedgerBasicWithholdingTax Identification of the withholding tax group.
TaxWithholdItemGroupHeading_TH Extended Data Type: TaxWithholdItemGroupId_TH
Type: Int64
None Group of withholding tax codes that can be calculated for an item
TaxWriteCode Extended Data Type: TaxWriteCode
Type: String
LedgerBasicSalesTax Code printed on the voucher.
TransactionCode Extended Data Type: IntrastatTransactionCodeId
Type: String
ForeignTrade Code for the current transaction code.
Transport Extended Data Type: IntrastatTransport
Type: String
ForeignTrade Specify means of transport for the current order.
Weight Extended Data Type: Weight
Type: Real
None Specification of weight.

Top

Field Groups

Field Group Fields
ReverseCharge_UK
SalesQuantity
NGPCode
OrderLines
Price
OLAP
Name_W
Posting
PdsCW
MCRDelivery
RetailCategory
Return
Reference
Reason
Reversal
Invoice
Item
Amount
DeliveryAddress
BillingCode
Discount
Customer
DiscountAmount
AutoReport
EInvoice
ExportSalesInvoiceLine
Dimension
AmountInDefaultCurrency
Commission
ExportSalesInvoiceLineDetail
ExternalReference
FixedAssets
ForeignTrade
InventPackaging
Inventory
SourceDocumentLine
SalesTax
System
WithholdingTax

Top

Relations

Relation Table Lines
AssetBookTable AssetBookTable
AssetTable AssetTable
CommissionSalesGroup CommissionSalesGroup
Currency Currency
CustInvoice CustInvoiceJour
CustInvoiceJour CustInvoiceJour
CustInvoiceJour_ParentRecId CustInvoiceJour
CustInvoiceLineIdRef CustInvoiceLineIdRef
CustInvoiceSalesLink CustInvoiceSalesLink
CustInvoiceTrans_Reversal CustInvoiceTrans
dataAreaId DataArea
DefaultDimension DimensionAttributeValueSet
DeliveryPostalAddress_FK LogisticsPostalAddress
EcoResCategory EcoResCategory
IntrastatItemCode IntrastatItemCode
IntrastatPort IntrastatPort
IntrastatStatProc IntrastatStatProc
IntrastatTransactionCode IntrastatTransactionCode
IntrastatTransportMode IntrastatTransportMode
InventDim_InventDimId InventDim
InventTable_ItemId InventTable
InventTransOrigin_InterCmpInvTransId InventTransOrigin
InventTransOrigin_InventTransId InventTransOrigin
LedgerDimension DimensionAttributeValueCombination
LogisticsAddressCountryRegion_RegionId LogisticsAddressCountryRegion
LogisticsAddressCountryRegion_Shipment LogisticsAddressCountryRegion
MCRDlvMode DlvMode
NGPCodesTable_FR NGPCodesTable_FR
NumberSequenceGroup NumberSequenceGroup
Partition Partitions
ReasonTableRef ReasonTableRef
ReturnDispositionCode ReturnDispositionCode
SalesCategory EcoResCategory
SalesTable_OrigSalesId SalesTable
SalesTable_SalesId SalesTable
SalesUnit UnitOfMeasure
SourceDocumentLine SourceDocumentLine
TaxGroupHeading TaxGroupHeading
TaxItemGroupHeading TaxItemGroupHeading
TaxWithholdGroupHeading TaxWithholdGroupHeading
taxWithholdItemGroupHeading_TH TaxWithholdItemGroupHeading_TH

Top

Indexes

Index AllowDuplicates Enabled Fields
DefaultDimensionIdx Yes Yes
EcoResCategoryIdx Yes Yes
InvoiceIdx Yes Yes
ItemIdIdx Yes Yes
LedgerDimensionIdx Yes Yes
MCRInvoiceIdx Yes Yes
RecId No Yes
SourceDocumentLineIdx Yes Yes
TaxWithholdItemGroupHeading_THIdx Yes Yes
TransIdIdx Yes Yes

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    CustInvoiceTrans Table

See Also

Table Methods

Tables Overview