CustInvoiceTable Table
The CustInvoiceTable table contains the free text invoices.
Configuration Key: LedgerBasic
Methods
Method | Description | |
---|---|---|
adjustDueDateOnAddressChange | Adjusts the due date on a CustInvoicetable record to a valid business day. | |
adjustDueDateOnPaymentMethodChange | Adjusts the due date on a CustInvoiceTable record to a valid business day. | |
agreementDocumentTitle_RU | Gets the document title of the invoice agreement. | |
amountMST | ||
aosValidateDelete | Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.) | |
aosValidateInsert | Validates on the server that the specified record can be inserted. (Inherited from xRecord.) | |
aosValidateRead | Validates on the server that the specified record can be read. (Inherited from xRecord.) | |
aosValidateUpdate | Validates on the server that the specified record can be updated. (Inherited from xRecord.) | |
buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) | |
calcCashDiscDate | ||
calcCashDiscountBaseDate | ||
calcDue | ||
calcInvoiceBalance | Calculates the transactionBalance value of the free text invoice. | |
cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) | |
canCorrect | Validates the correction of an invoice that is either reversed or marked for payment in the SpecTrans table. | |
canSubmitToWorkflow | Validates the invoice line amount for non-zero amount in order to activate the workflow on CustFreeInvoice form. | |
caption | Gets and sets the caption property of a table. (Inherited from xRecord.) | |
cashDiscBaseDateModified | ||
cashDiscCodeModified | ||
checkAccount | ||
checkAgreement_RU | ||
checkContactPerson | ||
checkCreditLimit | ||
checkCreditNoteReason | Checks whether a credit note line is does not contain a reason comment. | |
checkCreditNoteReasonServer | ||
checkCurrencyCode | Checks to see if it is acceptable to change the currency on this free-text invoice. | |
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) | |
checkRecord | Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.) | |
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) | |
clear | Removes all rows from the table buffer. (Inherited from xRecord.) | |
clearingLedgerDimension | ||
clearingPeriod | ||
company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) | |
companyInfo | Retrieves the CompanyInfo record associated with the current record. | |
con2buf | Unpacks a container into the table buffers. (Inherited from xRecord.) | |
concurrencyModel | Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.) | |
contactPersonName | ||
context | Gets and sets the context property. (Inherited from xRecord.) | |
convertCurrencyCode | ||
copyDimension | Retrieves a dimension set that can be applied to the defaultDimension field on this table. | |
copyPaymentSched | ||
createCustTrans_BR | Returns if the invoice will create customer transactions based on SalesPurchOperationTye_BR configuration. | |
createOneTimeAccount | ||
createPaymentSched | ||
creditNote_W | ||
custInvoiceJour | ||
custInvoiceTableExtensionTH | Get the CustInvoiceTableExtensionTH table. | |
customerName | ||
custTable_InvoiceAccount | ||
custTable_OrderAccount | ||
data | Retrieves a row from the table. (Inherited from xRecord.) | |
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) | |
defaultField | Populates default values in a field in the table. (Inherited from xRecord.) | |
defaultRow | Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.) | |
delete | Deletes the current record from the database. | |
deleteRecurrenceInvoice | Indicates whether the future posted or unposted free text invoices that are generated based on same recurrence invoice setup and delete the record from RecurrenceInvoice table. | |
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) | |
discPercent | ||
displayCorrectionState | Returns the CustFreeInvoiceCorrectionState enum value that represents the correction state of the invoice. | |
displayCustomerReference | Gets the customer reference for the order | |
displayExchRate | ||
displayExchRateSecondary | ||
displayInvoiceAccount | Retrieves the invoice account of the customer. | |
displayInvoiceAccountName | ||
displayInvoiceAmount | Retrieves the total invoice amount for the required action on the CustInvoiceTable record. | |
displayInvoiceLineDescription | Retrieves the description of the customer invoice in the CustInvoiceLine record. | |
displayMostRecentComment | Retrieves the last comment that was added to the task that was assigned to the CustInvoiceTable record. | |
displayRequiredAction | Gets the required action for the task that is assigned to the CustInvoiceTable record. | |
displayRequiredActionDueDate | Retrieves the due date for the required action on the CustInvoiceTable record. | |
displayWorkflowSubmitter | Retrieves the user who submitted the invoice to workflow. | |
dispose | Releases resources that are used by the xRecord object. (Inherited from xRecord.) | |
dispVATRegistrationNum | display method for customer VAT registration number. | |
doClear | Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.) | |
doDelete | Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.) | |
doInsert | Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.) | |
doUpdate | Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.) | |
doValidateDelete | Performs the action to validate that a record can be deleted. (Inherited from xRecord.) | |
editContactPersonName | ||
editExchRate_W | ||
editOrderAccountName | ||
editReasonCode | Gets and sets the reason code. | |
editReasonCodeForUnrealizedVAT | Gets and sets the reason code. | |
editReasonComment | Gets and sets the reason comment. | |
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) | |
euroTriangulation | ||
exchRate | ||
exchRateDate_W | ||
exchRateSecondary | ||
exchRateTxt | ||
existInvoice4Paym_RU | ||
fieldAccessRight | Returns the field access right. (Inherited from xRecord.) | |
fieldBufferAccessRight | Returns the field access right for the current record. (Inherited from xRecord.) | |
fieldState | Sets or returns the state of a field in the table buffer. (Inherited from xRecord.) | |
fiscalEstablishment | Retrieves the fiscal establishment for the current customer invoice. | |
getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) | |
getDefaultingDependencies | Returns the container that holds defaulting dependencies. (Inherited from xRecord.) | |
getEventHandler_BR | Calls the constructor of the CustInvoiceTableEventHandler_BR fot the current record. | |
getExchRateDate | Gets the appropriate date for the determination of exchange rate. | |
getExtension | Returns the table extension. (Inherited from xRecord.) | |
getFieldValue | Gets the value of the specified field from a table buffer. (Inherited from xRecord.) | |
getInstanceRelationType | Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.) | |
getPhysicalTableName | Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.) | |
getPresenceFieldData | Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.) | |
getSQLStatement | Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.) | |
getTableInInstanceHierarchy | (Inherited from xRecord.) | |
getTableType | Indicates the type of the table. (Inherited from xRecord.) | |
getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) | |
handle | Retrieves the handle of the class of the object. (Inherited from Object.) | |
hasCanceledRelatedInvoice_BR | Verifies if there is a Canceled invoice related to the current one. | |
hasLinesOrCharges | Determines whether any lines or miscellaneous charges are associated with the invoice. | |
hasRelatedTable | Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.) | |
hasTaxChanged | Determines whether the tax information has changed. | |
hasWithholdTaxChanged_IN | Gets a value that indicates whether the withhold tax information has changed. | |
helpField | Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.) | |
initBankAccounts_W | ||
initFromCustInvoiceTemplate | Sets the CustInvoiceTable table fields based on the CustRecurrenceInvoiceDefaultTypefield. | |
initFromCustTable | ||
initFromFiscalDocumentType | Initializes the fiscal document type information. | |
initFromPayment | ||
initFromSalesAgreementHeader_RU | ||
initFromTaxItemGroup | ||
initRecord | ||
initValue | Initializes a field to the default value. (Inherited from xRecord.) | |
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) | |
insert | Inserts a customer invoice header record. | |
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) | |
inventProfileType_RU | ||
invoiceDateModified | ||
invoiceDateTime | ||
isAlreadyCredited_W | Verifies, if any one of the lines of the posted transaction has been credited and that the credit note has not been cancelled. | |
isCancelInvoice_BR | Verifies if the current invoice is a cancelation one. | |
isCashPayment | ||
isCorrectedInvoice | Specifies whether the invoice is a corrected invoice. | |
isEditable | Indicates whether the free text invoice can be edited. | |
isFieldDataRetrieved | Checks whether the data of the given field has been retrieved. (Inherited from xRecord.) | |
isFieldSet | Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.) | |
isFormDataSource | Indicates whether the data source is a form. (Inherited from xRecord.) | |
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) | |
isPartOfUOWSaveChanges | (Inherited from xRecord.) | |
isTempDb | Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.) | |
isTmp | Indicates whether this is a temporary table. (Inherited from xRecord.) | |
isUserApprovalOwner | ||
isUserTaskOwner | ||
isWorkflowEditable | Check if the work flow for the document is editable. | |
joinChild | Finds the join child of the current record. (Inherited from xRecord.) | |
joinParent | Finds the join parent of the current record. (Inherited from xRecord.) | |
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) | |
location | ||
mcrGetPaymStatus | Calculates and returns for display purposes the payment status for a given transaction. | |
merge | Merges the current table with the specified table. (Inherited from xRecord.) | |
mergeDimension | Returns a dimension set that holds the merged combination of the current defaultDimensionfield on this table and the specified dimension set. | |
modifiedField | ||
modifiedFieldValue | Modifies the specified field to the original value. (Inherited from xRecord.) | |
mustBeCovPlanned | ||
new | Initializes a new instance of the Object class. (Inherited from Object.) | |
notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) | |
notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) | |
objectOnServer | Determines whether the object is on a server. (Inherited from Object.) | |
orig | Retrieves the original values of the current record. (Inherited from xRecord.) | |
overwriteSystemfields | Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.) | |
owner | Returns the instance that owns the object. (Inherited from Object.) | |
parmExchangeRateDate | ||
parmParentSourceDocumentLine | ||
parmSourceDocHeaderTypeEnumName | ||
parmSourceDocHeaderTypeEnumValue | ||
parmSourceDocLineTypeEnumName | ||
parmSourceDocLineTypeEnumValue | ||
parmSourceDocumentHeader | ||
partyTable_CustAccount | ||
paymDayId | ||
payment | ||
paymentDueDate | ||
paymentModified | ||
paymModeModified | ||
postCacheLoad | Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.) | |
postinitFromCustTableBR | Updates Brazilian specific fields after the CustInvoiceTable.initFromCustTable method. | |
postLoad | Is executed after a record is read. (Inherited from xRecord.) | |
postModifiedFieldBR | Performs Brazilian specific operations after the CustInvoiceTable.modifiedField method. | |
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.) | |
queryTimedOut | Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.) | |
queryTimeout | Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.) | |
readCommittedLock | (Inherited from xRecord.) | |
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.) | |
recordLevelSecurity | Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.) | |
refreshDataSource | Refreshes a data source. | |
refreshDataSource_BR | Performs a refresh if the CustInvoiceTable table is a form datasource. | |
relatedTable | Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.) | |
renamePrimaryKey | Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.) | |
reread | Rereads the record from the table. (Inherited from xRecord.) | |
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) | |
selectForUpdate | Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.) | |
selectLocked | Indicates whether to select locked records. (Inherited from xRecord.) | |
selectRefRecord | Selects the record by referenced field ID. (Inherited from xRecord.) | |
selectWithRepeatableRead | Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.) | |
setAgreement_RU | Initializes invoice from the agreement. | |
setConnection | Sets the user connection for this table. (Inherited from xRecord.) | |
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) | |
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) | |
setIntrastatDestinationData | Sets the value of the delivery location to the value of the invoice location. | |
setInvoiceAddress | ||
setInvoiceNameFromVATNum | ||
setLineCFOPTable_BR | ||
setListCode | ||
setPayment | Sets the Payment by using the billing classification if it is defined on billing classification; otherwise, uses the terms of payment of the Customer. | |
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) | |
setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) | |
setTmp | Sets the table so that it is not persisted to the database. (Inherited from xRecord.) | |
setTmpData | Sets the contents of the temporary table to the specified data. (Inherited from xRecord.) | |
setVATDueDate_W | ||
setXDSContext | Sets new XDS context. (Inherited from xRecord.) | |
showAmountMST | ||
skipAosValidation | Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.) | |
skipDatabaseLog | Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.) | |
skipDataMethods | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) | |
skipDeleteActions | Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.) | |
skipDeleteMethod | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) | |
skipEvents | Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.) | |
skipPostLoad | Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.) | |
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.) | |
sourceDocumentStatus | ||
summaryLedgerDimension | ||
suppressWarnings | Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.) | |
tableAccessRight | Returns the table access right. (Inherited from xRecord.) | |
tableBufferAccessRight | Returns the table access right for the current record. (Inherited from xRecord.) | |
takeOwnershipOfTempDBTable | (Inherited from xRecord.) | |
templateName | Sets or gets the information about the DistributionTemplate record to create of distributions. | |
toolTipField | Retrieves the HelpText value for the specified field. (Inherited from xRecord.) | |
toolTipRecord | Retrieves the ToolTip value for the current record. (Inherited from xRecord.) | |
toString | Returns a string that represents the current object. (Inherited from Object.) | |
transferToOnetimeCustomer | ||
ttsabort | Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) | |
ttsbegin | Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.) | |
ttscommit | Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) | |
update | Updates the current record in the database. | |
updateCustInvoiceLines_BR | ||
updateLedgerCov | ||
updateLineAgreementDimension_RU | ||
updateLineReasonCode | Updates the reason code on all the associated lines that are based on a header reason code. | |
updateLineReasonComment | Updates the reason comment on all the associated lines that are based on a header reason comment. | |
updateSumMarkupTrans | ||
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) | |
useExistingTempDBTable | (Inherited from xRecord.) | |
validateDelete | Determines whether the current record is valid and ready to be deleted from the database. | |
validateExcludeTaxFromInvoice | ||
validateField | Determines whether the p1 field is valid. | |
validateFieldValue | (Inherited from xRecord.) | |
validateWrite | Determines whether the current record is valid and ready to be written to the database. | |
validTimeStateUpdateMode | Sets a valid time state update mode on the cursor. (Inherited from xRecord.) | |
wait | Pauses a process. (Inherited from Object.) | |
wasCached | Specifies the location from which the data was retrieved. (Inherited from xRecord.) | |
write | Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.) | |
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) | |
::calculateTotalsWithoutTaxes | Calculates the totals for the CustInvoiceTable record without taxes. | |
::custOpenInvoices | ||
::existCustOpenInvoice | ||
::findPostedInvoice | Retrieves a record from the CustInvoiceTable table that is based on the customer account number and the invoice status. | |
::findRecId | ||
::findSourceDocumentHeader | Finds a CustInvoiceTable record by the specified SourceDocument record. | |
::findSourceDocumentLine | Finds a CustInvoiceTable record by using the specified SourceDocumentLine record. | |
::isInActiveWorkflow | Indicates whether the invoice is in an active workflow. | |
::paymentDueDateServer | Retrieves the due date for a specified transaction header. | |
::promptConvertCurrencyCode | ||
::promptConvertCurrencyCodeMethodToUse | Displays the dialog box that contains currency code conversion options. | |
::setWorkflowState | Sets the WorkflowApprovalState and WorkflowApprovalStatus fields of the CustInvoiceTable table, depending on the workflow events that have occurred. | |
::subLedgerJournalizationRequired | Checks the status of the SubLedgerJournalLine record. |
Top
Fields
Field | Type | Configuration key | Description |
---|---|---|---|
AccountingDistributionTemplate | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table |
AdjustingInvoiceDate | Extended Data Type: TransDate Type: Date |
None | Transaction date |
AgreementHeaderExt_RU | Extended Data Type: AgreementHeaderExtRecId_RU Type: Int64 |
TradeBlanketOrder | Agreement registration number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankAccount_LV | Extended Data Type: CompanyBankAccountId Type: String |
Bank | Select the primary bank account of the legal entity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankCentralBankPurposeCode | Extended Data Type: BankCentralBankPurposeCode Type: String |
LedgerBasic | Code used when reporting to the central bank. |
BankCentralBankPurposeText | Extended Data Type: BankCentralBankPurposeText Type: String |
LedgerBasic | Describe code used when reporting to the central bank. |
CashDiscBaseDate | Extended Data Type: CashDiscBaseDate Type: Date |
LedgerBasic | The date that is used for calculating discount dates and due dates (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)) |
CashDiscBaseDays | Extended Data Type: CashDiscBaseDays Type: Integer |
LedgerBasic | The number of days that will be added to the document date when calculating discounts and due dates (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)) |
CashDiscCode | Extended Data Type: CustCashDiscCode Type: String |
LedgerBasic | Terms of cash discount for the current invoice. |
CashDiscDate | Extended Data Type: CustCashDiscDate Type: Date |
LedgerBasic | Last date of payment to qualify for cash discount. |
CashDiscPercent | Extended Data Type: DiscPct Type: Real |
None | Discount in percentage. |
CFOPTable_BR | Extended Data Type: RefRecId Type: Int64 |
None | CFOP code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CFPSId_BR | Extended Data Type: CFPSId_BR Type: String |
None | Fiscal operation of services (CFPS) code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ComplementedInvoiceId | Extended Data Type: InvoiceId Type: String |
None | Identification of the invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ConsigneeAccount_RU | Extended Data Type: CustAccountConsignee_RU Type: String |
None | Reference customer when the 'Customer' and 'Consignee' are different. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ConsignorAccount_RU | Extended Data Type: VendAccountConsignor_RU Type: String |
None | Reference vendor when the 'Vendor' and 'Shipper' are different. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ContactPersonId | Extended Data Type: ContactPersonId Type: String |
None | Contact with customer. |
Correct_RU | Extended Data Type: Correct_RU Type: Enum |
LedgerBasic | Is the document a correction? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CorrectedFactureDate_RU | Extended Data Type: FactureDate_RU Type: Date |
LedgerBasicSalesTax | Date of corrected facture. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CorrectedFactureExternalId_RU | Extended Data Type: FactureExternalId_RU Type: String |
LedgerBasicSalesTax | Number of corrected facture. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CorrectedInvoiceDate_RU | Extended Data Type: CorrectedInvoiceDate_RU Type: Date |
None | Date of corrected invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CorrectedInvoiceId_RU | Extended Data Type: CorrectedInvoiceId_RU Type: String |
None | Number of invoice being corrected. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CorrectedPeriod_RU | Extended Data Type: TransDate Type: Date |
LedgerBasicSalesTax | Date of corrected period. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CorrectionReasonCode | Extended Data Type: ReasonRefRecID Type: Int64 |
None | Contains stored financial reason codes and comments for entered or posted transactions or actions. |
CorrectionType_RU | Enumeration: FactureCorrectionType_RU |
None | Facture correction type. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CovStatus | Extended Data Type: CovStatus Type: Integer |
LedgerAdvCashflowForecast | Coverage status |
createdBy | Extended Data Type: CreatedBy Type: String |
None | |
createdDateTime | Extended Data Type: CreatedDateTime Type: UtcDateTime |
None | |
CurBankAccount_LV | Extended Data Type: CompanyBankAccountId Type: String |
Bank | Select the bank account number for the currency used in the invoice (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 | Currency specified on the invoice. |
CustBankAccount_LV | Extended Data Type: CustBankAccountId Type: String |
Bank | Select the identifier of the customer's bank account (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CustBankAccountId | Extended Data Type: CustBankAccountId Type: String |
Bank | Identification of customer's bank account. |
CustBillingClassification | Extended Data Type: RefRecId Type: Int64 |
PublicSector | 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), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
CustFinalUser_BR | Extended Data Type: CustVendFinalUser_BR Type: Enum |
None | Is the customer the final user? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CustGroup | Extended Data Type: CustGroupId Type: String |
LedgerBasic | Customer group that invoice is attached to. |
CustomerRef | Extended Data Type: CustRef Type: String |
LedgerBasic | Customer's reference |
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, Microsoft Dynamics AX 2012 R2 (SYS)) |
DeliveryDate_ES | Extended Data Type: LedgerJournalDlvDate_ES Type: Date |
None | The date of delivery for the related goods/services (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
DeliveryLocation | Extended Data Type: LogisticsLocationRecId Type: Int64 |
None | Reference field in a different table |
DirectDebitMandate | Extended Data Type: CustDirectDebitMandateRecId Type: Int64 |
None | Select the direct debit mandate reference of the recipient (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DlvTerm | Extended Data Type: CustDlvTermId Type: String |
None | Unique identification of delivery terms |
DocNumberingCode_LT | Extended Data Type: LtDocNumberingCode Type: String |
None | Sequence code for automatic document numeration. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
DocumentDate | Extended Data Type: DocumentDate Type: Date |
None | Date of any external document |
DueDate | Extended Data Type: DueDate Type: Date |
LedgerBasic | Due date of invoice amount. |
EInvoiceAccountCode | Extended Data Type: EInvoiceAccountCode Type: String |
None | When settling to a public sector organization it is possible to specify a dimension account code. |
EInvoiceLineSpec | Extended Data Type: EInvoiceLineSpecific Type: Enum |
None | Specify the dimension account code for settlement to the public sector organization on line level. |
EnterpriseNumber | Extended Data Type: TaxEnterpriseNumber Type: String |
None | Enterprise number used to identify Belgian companies. |
ExchRate_W | Extended Data Type: CustExchRate Type: Real |
None | Specify the cost in the foreign currency. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
FineCode_BR | Extended Data Type: CustFineCode_BR Type: String |
None | Code that defines the fine rates and terms. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
FiscalDocType_PL | Enumeration: PlFiscalDocType |
None | Specifies whether an invoice or a bill is printed for the customer (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
FiscalDocumentType_BR | Extended Data Type: FiscalDocumentTypeRecID_BR Type: Int64 |
None | Type of fiscal document. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
FiscalEstablishment_BR | Extended Data Type: FiscalEstablishmentRecId_BR Type: Int64 |
None | Fiscal establishment identification (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ForInterestAdjustment | Enumeration: NoYes |
PublicSector | (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)) |
GiroType | Extended Data Type: PaymentStubInvoiceId Type: Enum |
CustGiro | Print associated payment attachment for free text invoice? |
InclTax_W | Extended Data Type: InclTax Type: Enum |
LogisticsBasic | Do prices include sales tax? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InterCompanyPosted | Extended Data Type: InterCompanyPosted Type: Enum |
TradeInterCompany | The journal was posted automatically via intercompany |
InterestCode_BR | Extended Data Type: CustInterestCode_BR Type: String |
None | Code that defines the interest rates and terms. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
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)) |
InvoiceAccount | Extended Data Type: CustInvoiceAccount Type: String |
None | The customer account to be invoiced |
InvoiceComplementaryType | Enumeration: InvoiceComplementaryType_BR |
None | Type of complementary fiscal document (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InvoiceDate | Extended Data Type: TransDate Type: Date |
None | Date of invoice. |
InvoiceId | Extended Data Type: CustInvoiceId Type: String |
LedgerBasic | Identification of the invoice. |
LanguageId | Extended Data Type: CustLanguageId Type: String |
LedgerBasic | Language used in invoice, etc. |
Listcode | Extended Data Type: ListcodeId Type: Enum |
ForeignTrade | List code to be used with the EU sales list. |
Log | Extended Data Type: LogText Type: String |
None | Log error messages |
ManualInvoiceID_W | Extended Data Type: InvoiceId Type: String |
None | Manual invoice number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ManualNumbering_W | Extended Data Type: LtInvoiceAutoNumbering Type: Enum |
None | Use the auto numbering. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
MCRGiftCard | Enumeration: NoYes |
MCRPayment | This field when checked indicates that this invoice belongs to a gift card transaction. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRLedgerVoucher | Extended Data Type: Voucher Type: String |
LedgerBasic | Voucher number in ledger. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRNumberSequenceCode | Extended Data Type: NumberSequenceCode Type: String |
None | Current number sequence code to be used with references. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRSalesID | Extended Data Type: SalesIdBase Type: String |
LogisticsBasic | Identification of the order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Name | Extended Data Type: LogisticsInvoiceName Type: String |
None | Name or company name of the invoice address |
NatureOfAssessee_IN | Enumeration: NatureOfAssessee_IN |
None | Nature of assessee. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
NonRealRevenue_RU | Extended Data Type: NonRealRevenue_RU Type: Enum |
LedgerBasic | Unrealized revenue - to be posted to gain/lost accounts. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
numberSequenceGroup | Extended Data Type: NumberSequenceGroupId Type: String |
None | Group for allocation of different number sequences to different customers/vendors. |
OneTimeCustomer | Extended Data Type: OneTimeCustomer Type: Enum |
LedgerBasic | Is the invoice for a one-time customer? |
OrderAccount | Extended Data Type: CustAccount Type: String |
None | Customer account that generated the order. |
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)) |
Payment | Extended Data Type: CustPaymTermId Type: String |
LedgerBasic | Terms of payment for the current invoice. |
PaymentSched | Extended Data Type: PaymSchedId Type: String |
PaymSched | Payment schedule to be used when invoicing. |
PaymMode | Extended Data Type: CustPaymMode Type: String |
LedgerBasic | Identification of the customer method of payment. |
PaymSpec | Extended Data Type: PaymSpec Type: String |
None | Specify payment handling for the current method of payment. |
PostalAddress | Extended Data Type: LogisticsPostalAddressRecId Type: Int64 |
None | Reference field in a different table |
Posted | Extended Data Type: Posted Type: Enum |
None | Has the transaction been posted? |
PostingProfile | Extended Data Type: CustPostingProfile Type: String |
None | Posting profile being processed. |
PostponeVAT | Extended Data Type: CzPostponeVAT Type: Enum |
LedgerBasicVatDueDate_W | Postpone VAT reporting for credit note. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
PrintOverdueFineTxt_FR | Extended Data Type: PrintOverdueFineTxt_FR Type: Enum |
None | If this check box is selected, the lump sum recovery text is printed on the sales invoice printing form (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ProjIntercompany | Extended Data Type: SelectableDataArea Type: String |
ProjBasic | ID for the company you can select (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
PurchOrderFormNum | Extended Data Type: CustPurchaseOrder Type: String |
None | Customer requisition number |
RecId | Extended Data Type: RecId Type: Int64 |
None | |
recVersion | Extended Data Type: RecVersion Type: Integer |
None | |
ReleaseDate | Extended Data Type: PostReleaseDate Type: UtcDateTime |
None | The date that the transaction can be posted. If the field is blank, the transaction can be posted immediately. |
SalesDate_W | Extended Data Type: SalesDate_W Type: Date |
TradeDates_W | Enter or select the date of the sales transaction (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
SalesId | Extended Data Type: SalesId Type: String |
LogisticsBasic | Identification of the order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
SalesPurchOperationType_BR | Extended Data Type: SalesPurchOperationTypeRecId_BR Type: Int64 |
None | The default operation type for the CFOP code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ServiceCodeOnDlvAddress_BR | Extended Data Type: TaxServiceCodeOnDlvAddress_BR Type: Enum |
None | Specifies service codes and IBGE city code is based on delivery address city (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
SourceDocumentHeader | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table |
SourceDocumentLine | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table |
SubLedgerJournalStatus | Enumeration: SubLedgerJournalStatus |
LedgerBasic | Type of subledger journal status |
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 | Sales tax codes in item sales tax group |
TaxPeriodPaymentCode_PL | Extended Data Type: PlTaxPeriodPaymentCode Type: String |
None | Enter a time period code for VAT transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TaxWithholdCalculate | Enumeration: NoYes |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TCSGroup_IN | Extended Data Type: TaxWithholdGroup Type: String |
LedgerBasicWithholdingTax | TCS group for calculation of withholding tax. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TDSGroup_IN | Extended Data Type: TaxWithholdGroup Type: String |
LedgerBasicWithholdingTax | TDS group for calculation of withholding tax. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
Touched | Extended Data Type: TradeTouched Type: Enum |
None | Update record |
TransportationDocument | Extended Data Type: TransportationDocumentRecId 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)) |
UnitedVATInvoice_LT | Extended Data Type: UnitedVATInvoice_LT Type: Enum |
None | Flag indicating united VAT invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
VatDueDate_W | Extended Data Type: VatDueDate_W Type: Date |
LedgerBasicVatDueDate_W | The transaction date for the VAT register period (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
VATNum | Extended Data Type: VATNumJournal Type: String |
LedgerBasicSalesTax | Tax exempt identification number |
VATOnPayment_RU | Extended Data Type: VATOnPayment_RU Type: Enum |
LedgerBasic | Process VAT on "On payment" principle. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
WorkerSalesTaker | Extended Data Type: SalesTaker Type: Int64 |
None | Employee who received order |
WorkflowApprovalState | Enumeration: CustFreeInvoiceWFApprovalState |
LedgerBasic | Free text invoice workflow state (submitted, pending or complete) |
WorkflowApprovalStatus | Enumeration: CustFreeInvoiceWFApprovalStatus |
None | Workflow status of the free text invoice |
Top
Field Groups
Field Group | Fields |
---|---|
MCRSalesID | |
MCRGiftCard | |
Log | |
InvoiceAccount | |
InvoiceId | |
InterCompany | |
Invoice | |
WithholdingTax_IN | |
WorkflowPreview | |
SalesTax | |
Services_BR | |
SourceDocumentHeader | |
System | |
Document | |
FiscalDocType_PL | |
FiscalInformation_BR | |
Einvoice | |
ForeignTrade | |
GiroMoneyTransferSlip | |
AccountingDistributionTemplate | |
Address | |
Administration | |
Agreement_RU | |
BankAccounts_LV | |
BillingClassification | |
AutoReport | |
ComplementaryInvoice | |
Currency | |
Customer | |
CorrectedInvoice | |
Correction_RU | |
Dimension | |
NotificationToTheCentralBank | |
Payment | |
Posting | |
PostingRelease | |
Reference |
Top
Relations
Relation | Table | Lines |
---|---|---|
AccountingDistributionTemplate | AccountingDistributionTemplate | |
AgreementHeaderExt_RU | AgreementHeaderExt_RU | |
BankAccount_LV | BankAccountTable | |
BankCentralBankPurpose | BankCentralBankPurpose | |
CashDisc | CashDisc | |
CFOPTable_BR | CFOPTable_BR | |
ContactPerson | ContactPerson | |
CurBankAccount_LV | BankAccountTable | |
Currency | Currency | |
CustBankAccount | CustBankAccount | |
CustBankAccount_LV | CustBankAccount | |
CustBillingClassification | CustBillingClassification | |
CustDirectDebitMandate | CustDirectDebitMandate | |
CustFineCode_BR | CustFineSetup_BR | |
CustGroup | CustGroup | |
CustInterestCode_BR | CustInterestSetup_BR | |
CustInvoice | CustInvoiceJour | |
CustInvoiceTable | CustInvoiceTable | |
CustLedger | CustLedger | |
CustPaymModeSpec | CustPaymModeSpec | |
CustPaymModeTable | CustPaymModeTable | |
CustTable_InvoiceAmount | CustTable | |
CustTable_OrderAmount | CustTable | |
CustTable_RU | CustTable | |
dataAreaId | DataArea | |
DefaultDimension | DimensionAttributeValueSet | |
DeliveryLocation_FK | LogisticsLocation | |
DlvTerm | DlvTerm | |
DocNumberingCode_LT | LtInvoiceAutoNumberingTable | |
FiscalDocumentType_BR | FiscalDocumentType_BR | |
FiscalEstablishment_BR | FiscalEstablishment_BR | |
LanguageTable | LanguageTable | |
MCRNumberSequenceTable | NumberSequenceTable | |
MCRSalesTable | SalesTable | |
NumberSequenceGroup | NumberSequenceGroup | |
Partition | Partitions | |
PaymentSched | PaymSched | |
PaymTerm | PaymTerm | |
PlTaxDueTable | PlTaxDueTable | |
PostalAddress | LogisticsPostalAddress | |
ProjIntercompany | DataArea | |
ReasonTableRef | ReasonTableRef | |
SalesPurchOperationType_BR | SalesPurchOperationType_BR | |
SalesTable_RU | SalesTable | |
SourceDocumentHeader | SourceDocumentHeader | |
SourceDocumentLine | SourceDocumentLine | |
TaxGroupHeading | TaxGroupHeading | |
TaxItemGroupHeading | TaxItemGroupHeading | |
TaxServiceTariff | TaxServiceTariff | |
TaxWithholdGroupHeadingTCS_IN | TaxWithholdGroupHeading | |
TaxWithholdGroupHeadingTDS_IN | TaxWithholdGroupHeading | |
TransportationDocument | TransportationDocument | |
VendTable_RU | VendTable | |
WorkerSalesTaker_FK | HcmWorker |
Top
Indexes
Index | AllowDuplicates | Enabled | Fields |
---|---|---|---|
AccountingDistributionTemplateIdx | Yes | Yes | |
AgreementHeaderExt_RUIdx | Yes | Yes | |
CustBillingClassificationIdx | Yes | Yes | |
DefaultDimensionIdx | Yes | Yes | |
FiscalDocumentType_BRIdx | Yes | Yes | |
FiscalEstablishment_BRIdx | Yes | Yes | |
InvoiceAccountIdx | Yes | Yes | |
InvoiceDateIdx | Yes | Yes | |
InvoiceIdIdx | Yes | Yes | |
OrderAccountIdx | Yes | Yes | |
RecId | No | Yes | |
SalesPurchOperationType_BRIdx | Yes | Yes | |
SourceDocumentHeaderIdx | No | Yes | |
SourceDocumentLineIdx | Yes | Yes | |
WorkerSalesTakerIdx | Yes | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
CustInvoiceTable Table