LedgerJournalTrans Table
The LedgerJournalTrans table contains the transaction detail information that pertains to a single journal. The individual transaction lines are also referred to as voucher lines. The journal is a record in the LedgerJournalTable table.
Configuration Key: LedgerBasic
Methods
Method | Description | |
---|---|---|
accountAgreementDocumentTitle_RU | Displays document title of the current LedgerJournalTrans agreement. | |
accountDisplay | ||
accountName | ||
accountNameFind | ||
affectsOtherWithholdCalcs_BR | ||
amount | ||
amountCur2DebCred | ||
amountCurPDC | ||
amountMST_RU | ||
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.) | |
areAccountsInSingleCompany | Determines whether the primary account and offset account are in a single company. | |
bankAccount_BR | Gets the account number of the bank. | |
bankAgency_BR | Gets the agency number of the bank. | |
bankDac_BR | Gets the account control characters (DAC) of the bank. | |
bankPaymentOrderJour_RU | ||
buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) | |
cacheAllowEdit | Updates the performance validation caches that indicate when the LedgerJournalTrans table can be edited. | |
cacheAllowEditUpdate | ||
calcAmountMST | Calculates the net MST total amount for a LedgerJournalTrans record. | |
calcAverageLinesExchRate_HU | Calculates the exchange rate on the journal line using average method. | |
calcBankAmount_RU | ||
calcBaseAmountMSTIncTaxInCostPrice | ||
calcCreditMST | Calculates the MST amount for a LedgerJournalTrans.amountCurCredit value. | |
calcDebitMST | Calculates the MST amount for a LedgerJournalTrans.amountCurDebit value. | |
calcFIFOLineExchRate_HU | Calculates the exchange rate for the journal line using FIFO. | |
calcLineAmountExclTax_RU | ||
calcPaymentFee | ||
calculateBankCurrencyAmount | Calculates the bank currency amount. | |
calcUserTaxBase_PL | ||
canAccountTypeBeTaxed | Determines whether the specified account type can be taxed by the tax engine. | |
cancelMandateLogRecord | ||
cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) | |
canCloseTaxWithholdEditStatus_BR | ||
canCreateBankDocument | Indicates whether a bank document can be created from the table in current status. | |
canCreateFixedAssetsSiblingRecord | Indicates whether a LedgerJournalTrans_Asset sibling record can be created. | |
canPrintNonNegotiableCheque | Indicates whether non-negotiable checks can be printed against this transaction. | |
canReopenTaxWithholdEditStatus_BR | ||
canSkipBlockedForManualEntryCheck | Gets a value that indicates whether the current record can skip the blocked for manual entry check. | |
canSubmitToWorkflow | Indicates whether submission to workflow is possible. (Inherited from xRecord.) | |
caption | Gets and sets the caption property of a table. (Inherited from xRecord.) | |
cashDiscAmount_BR | ||
checkAccountTypesProject | ||
checkAgreement_RU | Checks agreement of the current LedgerJournalTrans record depending on account type. | |
checkAllowEdit | ||
checkAllowEditPaymentOrder_RU | ||
checkAllowEditPromissoryNote | ||
checkAllowEditWhenCheckPrinted | ||
checkAllowPosting | ||
checkAmount | ||
checkApprovalActive | Performs approval validation on the current record. | |
checkBankAccounts | Indicates whether accounts of type bank are valid. | |
checkBridgePosting_IN | Returns true PDCClearingPosting is marked for the PaymMode; otherwise false. | |
checkBudget | Checks the availability of budget funds. | |
checkCreditRemainAmountCur | Checks the proposed settlements for possible overpayment. | |
checkCurrency | ||
checkCustomsTariffCode_IN | Checks the customs tariff code to see if it is valid. | |
checkDataAreaAccessible | ||
checkEnvironmentFlowDataEntered | ||
checkExchRate | ||
checkFieldViewAccessLevel_BR | This method will check if the column in the given table has proper field access. | |
checkInterCompany | ||
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) | |
checkJournalAccountControl | Performs journal control validation on the current record. | |
checkMaximumRetailPrice_IN | Checks whether maximum retail price is positive. | |
checkNegInstPosting | ||
checkOpertaionType_MX | Checks for the operation type if it is blank. | |
checkPaymentFilledOk | ||
checkPaymentReferenceIS | Verifies whether the payment reference is required for the transaction record. | |
checkPrepaymentTaxGroups | Verifies the tax groups of a prepayment against any linked advance invoices. | |
checkProjId | ||
checkRDefferalsClosingDate_RU | ||
checkReasonRefRecID | ||
checkRecord | Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.) | |
checkReleaseDate | Checks the release date against the current date. | |
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) | |
checkServiceCode_IN | This method is used to validate the user entry against the records in the master table for service codes. | |
checkSettledVendorAutority_IN | Checks whether settled vendor authority. | |
checkVATNumJournal | ||
checkVATPosting | ||
checkVatRegData_W | ||
checkVatTransaction | ||
checkVendPrepayment_CZ | ||
checkVoucherNotUsed | ||
checkVoucherNotUsedDataSource | Determines if the voucher is being used by a different ledgerJournalTrans row on a form's datasource that is not in the database. | |
checkVoucherSeries | ||
checkZeroAmount | ||
clear | Removes all rows from the table buffer. (Inherited from xRecord.) | |
clearAgreementDimension_RU | Clears agreement dimension of the current LedgerJournalTrans record depending on account type. | |
clearBankCurrencyAmount | Clears the bank currency amount. | |
closeTaxWithholdEditStatus_BR | ||
compAddressComplement_BR | Gets the building name of the company. | |
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. | |
companyName_BR | Retrieves the journal line company's name. | |
compCityName_BR | Retrieves the journal line company's primary address city. | |
compCNPJCPFNum_BR | Retrieves the journal line company's CNPJ/CPF number. | |
compDistrictName_BR | Retrieves the journal line company's address district name. | |
compStateName_BR | Retrieves the journal line company's address state name. | |
compStreetName_BR | Retrieves the journal line company's address street. | |
compStreetNumber_BR | Gets the StreetNumber of the company. | |
compZipCode_BR | Retrieves the journal line company's address zip code. | |
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.) | |
context | Gets and sets the context property. (Inherited from xRecord.) | |
convertCustPaymAmountCurToDebitCredit | Converts the specified customer payment amount into the appropriate debit or credit. | |
copyDimension | Copies a dimension set that can be applied to the defaultDimension field on this table. | |
copyTo | Copies the nonsystem fields from this buffer to the destination buffer. | |
correct | ||
createNewPayment | ||
createTransferTrans | ||
crossrate | ||
custPaymentFilledOk | ||
data | Retrieves a row from the table. (Inherited from xRecord.) | |
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) | |
debitCreditDifferenceCur | ||
defaultDimensionDisplay_RU | Displays dimensions of the current LedgerJournalTrans record. | |
defaultField | Sets the value of a field to the default value. | |
defaultingTax1099Amount | ||
defaultRow | Sets the values of the fields in a particular LedgerJournalTrans table row to their default values. | |
delete | ||
deleteForHeader | Deletes the compositional records related to the LedgerJournalTable record. | |
deleteTaxUncommitted | Deletes the TaxUncommitted records if a field that affects tax has changed. | |
deleteTaxWitholdUncommitted_IN | Deletes the TaxWithholdUncommitted_IN records if a field that affects tax has changed. | |
deleteVoucher | ||
determineVendBankDirection_IN | Determines vend bank direction. | |
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) | |
displayAddress_IN | Display the logistics address information. | |
displayBankLCLineNum | Displays the BankLCShipmentLineNum object of the letter of credit that is related to the CustVendTransOpen record, which is settled using the LedgerJournalTrans record. | |
displayBankLCNumber | Displays the BankLCNumber object of the letter of credit that is related to the CustVendTransOpen record, which is settled using the LedgerJournalTrans record. | |
displayCurrencyCode | ||
displayCustPaymAmount | Gets the customer payment amount from the debit or credit of the transaction. | |
displayExchRate | ||
displayExchRateSecond | ||
displayMainAccountType | Gets the main account type of the voucher. | |
displayTaxBranchDimension | Displays the tax branch code depending on the ledger dimension. | |
displayTCSGroupForWHTTaxJournal_IN | Display the TCS group for WHT tax journal. | |
displayTDSGroupForWHTTaxJournal_IN | Display TDS group for WHT tax journal. | |
dispose | Releases resources that are used by the xRecord object. (Inherited from xRecord.) | |
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.) | |
editExchRate | ||
editExchRateSecond | ||
editReasonCode | Gets and sets the reason code. | |
editReasonComment | Gets and sets the reason comment. | |
editServiceCode_IN | The ServiceCode field in the TaxInformation tab of journals is an edit method now. This will set or get the service codes accordingly. | |
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) | |
exchRateDate_W | ||
exchRateTxt | ||
exciseManufacture_IN | Gets or sets the manufacture excise record type for the customer free text invoice lines. | |
exciseNone_IN | Gets or sets the excise record type for the customer free text invoice lines. | |
exciseTraders_IN | Gets or sets the traders excise record type for the customer free text invoice lines. | |
existBankPaymentOrderJour_RU | ||
factureModule_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.) | |
fillPaymentNotes | ||
findAssetTable | ||
findBankAccountTable | Finds a BankAccountTable record that corresponds to the bank account. | |
findBankAccountTableForOffset | Finds a BankAccountTable record that corresponds to the offset bank account. | |
findCustForOffset | Finds the CustTable record corresponding to the offset account. | |
findCustTable | Finds the CustTable record corresponding to the account. | |
findCustTransOpen_BR | Finds the CustTransOpen record assigned to this journal record. | |
findLedgerJournalTransAssetSibling | Performs a company-safe lookup of a LedgerJournalTrans_Asset sibling record of the transaction. | |
findMainAccount | Finds the MainAccount record that corresponds to the account. | |
findMainAccountForOffset | Finds the MainAccount record that corresponds to the offset account. | |
findProjTable | ||
findVendForOffset | Finds the VendTable record corresponding to the offset account. | |
findVendTable | ||
findVendTransOpen_BR | Finds the VendTransOpen record assigned to this journal record. | |
flushAllowEditCaches | ||
formatTransactionText_BR | ||
formSelectSettledNegInst | ||
fullyFactured_RU | ||
generateRemittanceFeeTrans | ||
getActualAndCalculatedTaxForSingleLine | Gets the total actual and calculated tax amount for the current line. | |
getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) | |
getAssetCompany | Returns the company that the fixed asset transaction belongs to. | |
getAssetId | ||
getAssetId_RU | ||
getBankLCLine | Gets the BankLCLine record that is related to the CustVendTransOpen record, which is settled by using the LedgerJournalTrans record. | |
getBankTransactionCurrencyAmount | Gets the bank transaction currency amount. | |
getBudgetCheckResult | Gets the BudgetCheckResult value for the specified LedgerJournalTrans record. | |
getCashDocId_RU | ||
getDefaultingDependencies | Returns the container that holds defaulting dependencies. (Inherited from xRecord.) | |
getDeferralsId_RU | ||
getExtension | Returns the table extension. (Inherited from xRecord.) | |
getFieldValue | Gets the value of the specified field from a table buffer. (Inherited from xRecord.) | |
getIndirectExclusiveTaxAmountCur_IN | Gets Indirect exclusive tax amount | |
getInstanceRelationType | Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.) | |
getLedgerAccountForAccount | Gets the dispaly value of the ledger dimension to be posted to based on the account and account type. | |
getLedgerDimensionForJournalAccount | Gets the ledger dimension to be posted to based on the account and account type. | |
getLedgerDimensionForLedgerType | Gets the ledger account for the default account. | |
getLedgerJournalTransBankLC | ||
getOffsetCompany | ||
getOffsetLedgerDimensionForLedgerType | Gets the offset ledger account for the default account. | |
getOffsetLedgerDimensionForProposal | Gets the offset ledger account for the default account for a proposal. | |
getPaymentExtension_BR | Retrieves the LedgerJournalTransPayment_BR object | |
getPhysicalTableName | Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.) | |
getPostingProfileForCustVend | ||
getPresenceFieldData | Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.) | |
getProjectId | Gets the project ID for this transaction. | |
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.) | |
getTaxSetOffVoucher_IN | Retrieves the specified TaxSetoffVoucher record in the LedgerJournalTrans table. | |
getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) | |
getWithholdTaxTypeForJournalLine | Gets India withholding tax type for current journal line. | |
handle | Retrieves the handle of the class of the object. (Inherited from Object.) | |
handleDeleteTaxWithholdEditStatus_BR | ||
handleWriteTaxWithholdEditStatus_BR | ||
hasCashDiscChanged | Determines if the cash discount has been changed. | |
hasConflictingTaxWithholdEditStatus_BR | Returns true when there's another payment line in the same month, with the same LedgerTransTaxWithholdEditStatus_BR::Opened for the current party. | |
hasCustVendTransOpen_BR | Determines if the current journal transaction has a related open transaction. | |
hasIndirectTaxFieldChanged_IN | Check if india fields change affects tax changed. | |
hasPendingInvoice | Determines whether a pending invoice exists for a LedgerJournalTrans table record. | |
hasRelatedTable | Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.) | |
hasRelatedTaxWithholdTrans | Determines whether a TaxWithholdTrans table record exists for a LedgerJournalTrans table record. | |
hasTaxWithholdingTransactions_BR | ||
hasTaxWithholdSetting_BR | ||
helpField | Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.) | |
initAgreementDimension_RU | Inits agreement dimension of the current LedgerJournalTrans record from AgreementHeaderExt_RU record depending on account type. | |
initForCurrency | Initializes the current record for a new currency. | |
initFromBankClientPayment_RU | ||
initFromCustPaymModeTable | Performs initialization by using the specified payment method. | |
initFromCustTable | Performs initialization using the specified customer. | |
initFromCustVendVatRegNums_PL | ||
initFromGeneralJournal | ||
initFromLedgerJournalTable_LT | ||
initFromTAMDeduction | Initializes a LedgerJournalTrans record from current record. | |
initTaxInfomation_IN | Initializes the TaxInformation_IN field of LedgerJournalTrans table. | |
initValue | Initializes field values in a new LedgerJournalTrans record. | |
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) | |
insert | Inserts the current record into the database. | |
insertPost_BR | Runs after the insert() method of LedgerJournalTrans table in order to create extension tables for Brazil. | |
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) | |
invoiceAmount_BR | ||
invoiceDueDate_BR | ||
invoiceIssueDate_BR | ||
invoiceNumber_BR | ||
isBankDocumentPayment | Indicates whether the journal line is linked to a payment bank document. | |
isBankDocumentPaymentProcessNeeded | Checks whether the bank document processing logic is needed. | |
isBudgetCheckRequiredForUpdate | Indicates whether the check for available budget funds is required for the update on the LedgerJournalTrans record. | |
isCashTransaction_RU | ||
isCompanyIntercompany | Identifies whether a company account is intercompany. | |
isDeferralsTransaction_RU | ||
isDependantOnSettlement | Determines whether journal amounts and dates depend on transactions marked for settlement with the journal line. | |
isDirectSettleForCP_IN | Indicates whether this LedgerJournalTrans is for centralized payment. | |
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.) | |
isFixedAssetsTransaction | Indicates whether a transaction is a fixed assets transaction. | |
isFixedAssetsTransaction_RU | ||
isForeignVendorAccount_IN | Checks if the transaction is foreign vendor account. | |
isFormDataSource | Indicates whether the data source is a form. (Inherited from xRecord.) | |
isGTAVendorAccount_IN | Checks if the transaction is GTA vendor account. | |
isInterCompanySupportedByTransType | Determines if intercompany is supported by the account type or offset account type. | |
isLedgerBankJournal_IN | True if its a Ledger-Bank scenario. | |
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) | |
isOffsetCompanyIntercompany | Checks to see whether the offset company account is intercompany. | |
isOffsetTaxable | Determines whether the primary account type is taxable. | |
isPartOfUOWSaveChanges | (Inherited from xRecord.) | |
isPaymentJournal_IN | True if payment journal. | |
isPrimaryTaxable | Determines whether the primary account type is taxable. | |
isProjectTransaction | Determines whether this is a project transaction. | |
isPurchaseCashAccount_IN | True if the main AC or offset AC is a purchase cash one. | |
isSEPAPaymentRejected | ||
isServiceApplicable_IN | Checks if the service is applicable. | |
isServiceTax_IN | Checks if the service tax is available. | |
isTax1099DetailTransaction | Indicates whether this is a 1099 transaction that requires Tax1099Details. | |
isTaxable | Checks to see whether tax should be calculated for the journal line. | |
isTaxCorrection_RU | ||
isTaxTypeApplicable_IN | Checks if the tax type is applicable. | |
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.) | |
isTransferred | ||
isTransForGTAVendor_IN | Indicates whether transaction is for GTA vendor. | |
isTransIntercompany | ||
isVatTaxAgentAuthorityPayment_RU | ||
isVATTaxAgentPaymentFromVendorFunds_RU | ||
isVatTaxAgentPrepayment_RU | ||
joinChild | Finds the join child of the current record. (Inherited from xRecord.) | |
joinParent | Finds the join parent of the current record. (Inherited from xRecord.) | |
ledgerJournalTable | Finds the journal record that is the parent of this LedgerJournalTrans record. | |
ledgerJournalTransExtensionTH | Get the LedgerJournalTransExtensionTH table. | |
ledgerJournalTransTaxExtensionIN | Get the LedgerJournalTransTaxExtensionIN table. | |
linesQty_PL | ||
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) | |
listCodeAllowed | Determines whether the list code field is available. | |
lookupServiceCode_IN | The lookup logic used to display the service codes from the company selected in the general tab. | |
mainAccountType_PL | Gets the main account type of the current transaction. | |
markedForSettlementError | ||
markedForSettlementMaxDueDate | ||
markedForSettlementWarning | ||
markedForSettlementWarnMixedDueDate | ||
mcrCurrencyCode | Displays the currency code for the LedgerJournalTrans record. | |
mcrIsDeduction | Finds the specified record in the LedgerJournalTrans table. | |
mcrIsDeductionParent | Finds the specified record in the TAMDeduction table. | |
mcrUpdateRelatedPayment | Updates the related payment record if one exists. | |
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 provided dimension set. | |
modifiedField | ||
modifiedFieldRemovesAccruals | ||
modifiedFieldValue | Modifies the field value. | |
modifyVatDueDate_W | ||
negotiableInstrumentPostInsert | ||
negotiableInstrumentPreInsert | ||
negotiableInstrumentUpdate | ||
new | Initializes a new instance of the Object class. (Inherited from Object.) | |
notExistsPostedWHTForCP_IN | Indicates whether current LedgerJournalTrans settles an invoice which has posted withholding tax. | |
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.) | |
offsetAccountAgreementDocumentTitle_RU | Displays document title of the current LedgerJournalTrans offset agreement. | |
offsetAccountName | ||
offsetDefaultDimensionDisplay_RU | Displays offset dimensions of the current LedgerJournalTrans record. | |
openTaxWithholdEditStatus_BR | ||
operationTax_RU | ||
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.) | |
packExtensionTable | Packs a SysExtensionSerializerExtensionMap extension table's buffer inside the record's internal cache. | |
packledgerJournalTransTaxExtensionIN | Packs the LedgerJournalTransTaxExtensionIN table | |
parmAccount | ||
parmBankAccount | Gets the bank account ID. | |
parmBankCurrencyAmount | Gets the bank currency amount. | |
parmBankDocumentBookType | Gets the bank document type. | |
parmDefaultDimension | ||
parmLedgerDimension | ||
parmOffsetAccount | ||
parmOffsetDefaultDimension | ||
parmOffsetLedgerDimension | ||
paymentAmount_BR | ||
paymentDocumentName_RU | ||
paymentOrderBudgetTrans_RU | ||
paymModeModified | ||
paymStatusModified | ||
paySheetTransDeleteLink_RU | ||
pdsCalcAmt | ||
postCacheLoad | Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.) | |
postLoad | Is executed after a record is read. (Inherited from xRecord.) | |
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.) | |
processPaymentBankDocument | Processes payment type bank document from this table. | |
purchOffsetLedgerDimension | ||
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.) | |
relatedTable | Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.) | |
removeAccruals | ||
removeBudget | Removes the budget amounts for the current LedgerJournalTrans record. | |
removeBudgetForVoucher | Removes the budget amounts for all the LedgerJournalTrans records that are associated to the voucher of the current LedgerJournalTrans record. | |
renamePrimaryKey | Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.) | |
reopenTaxWithholdEditStatus_BR | ||
represPersonCard_LT | ||
represPersonCard_RU | ||
represPersonCardEdit_W | Edits the representative person card information. | |
represPersonName_LT | ||
represPersonName_RU | ||
represPersonNameEdit_W | Edits the representative person name. | |
reread | Rereads the record from the table. (Inherited from xRecord.) | |
reuseCheck | ||
revertBankAccountTrans | Reverts the BankAccountTrans table updates that were made when a bank check or deposit reversal journal is created. | |
revertBankChequeTable | Reverts the BankChequeTable table updates that were made when a bank check reversal journal is created. | |
revertBankDeposit | Reverts the BankDeposit table updates that were made when a bank deposit slip cancellation journal is created. | |
rollbackFIFOLineExchRate_HU | ||
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.) | |
serviceTaxAmountForReverseCharge_IN | Gets the service tax amount for reverse charge. | |
servicetaxBaseamountForAdvancePayment_IN | Gets the service tax base amount for advance payment. | |
setAgreementEmptyValues_RU | Clears agreement or ofsset agreement of the current LedgerJournalTrans record depending on account type. | |
setAssessableValue_IN | Sets Assessable value of the table LedgerJournalTrans record. | |
setConnection | Sets the user connection for this table. (Inherited from xRecord.) | |
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) | |
setCustVendSettlementbuffer | ||
setCustVendTransOpenbuffer | ||
setDefaultAccount | ||
setEPRemitInfo_BR | ||
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) | |
setInterestAndFine_BR | Adjusts LedgerJournalTrans fields (FinInterestAmount / FineAmount ) in response to a change in the LedgerJournalTrans AmountCurDebit or AmountCurCredit value. | |
setListCode | ||
setNotApplicableTaxWithholdEditStatus_BR | ||
setOffsetLedgerDimension | Sets the offset account type and offset account fields on the LedgerJournalTrans record. | |
setRepresPersonValues_W | Sets the values of representative dependent fields. | |
setSettleVoucher | ||
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) | |
setTaxInfoOfCompany_IN | Sets tax information of company. | |
setTaxInfoOfProjTable_IN | Initializes fields for the current LedgerJournaltrans record with values from the specified project record. | |
setTaxWithholdEditStatus_BR | ||
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.) | |
setXDSContext | Sets new XDS context. (Inherited from xRecord.) | |
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.) | |
splitPaymentInvoiceSettled | ||
splitPaymentTAN_IN | Splits payment. | |
suppressWarnings | Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.) | |
swapAccountOffsetAccount | ||
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.) | |
taxAmountInCostPrice | ||
taxAmountJournal | ||
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.) | |
totalTaxAmountForInvoice | Gets the total tax amount for an invoice. | |
totalTaxAmountSingleLine | Gets the total tax amount for the current line. | |
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.) | |
type | ||
update | Updates the current record in the database. | |
updateAmountCurDelete | ||
updateAmountCurWrite | ||
updateAttachments_CN | ||
updateBankPaymentOrderJour_RU | ||
updateCustEPRemitInfo_BR | Updates DocumnetType, BankFolder, Instrcution_1 and Instruction_2 in CustEPRemitInfo_BR table. | |
updateCustVendBankAccount | Saves the record ID of the CustBankAccount or VendBankAccount table in the CustBankAccount or VendBankAccount fields to complete the relation. | |
updateDerivedDepBookAmount_IN | Update derived depreciation book buffer. | |
updateEPRemitInfo_BR | Updates the TypedLine, EPBarCodeInfo_BR in VendEPRemitInfo_BR table and EPPaymentType_BR, EPPaymentWay_BR in LedgerJournalTransPayment_BR table when EPBarcodeInfo_BR in VendTransPayment_BR changed | |
updateFeeOffsetAccount | ||
updateFIFOLineExchRate_HU | ||
updateInvoicePaymStatus | ||
updateLedgerJournalTable | ||
updateLedgerJournalTransFeeVoucher | ||
updateMarkedInvoice | Updates the marked invoice of the current payment. | |
updateMarkedInvoiceWithTrans | Updates the marked invoice of the current payment by using the specified marked transaction. | |
updateOperationType_MX | Updates the OperationType_MX field value when you post the journals when there is no common tax codes, that is, when the DiotAddInfo_MX check box is checked, are not attached. | |
updatePaymentOrderBudgetTrans_RU | ||
updatePaySheetTrans_RU | ||
updateTaxCode | ||
updateTCSGroup_IN | Update TCSGroup_IN. | |
updateTDSGroup_IN | Update TDSGroup_IN. | |
updateVoucherHeader_CN | Updates old Chinese voucher number according to new journal lines, releases old voucher number. | |
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) | |
useExistingTempDBTable | (Inherited from xRecord.) | |
validateBankAccount | ||
validateCurrencyConvBankTransAccount_RU | ||
validateDelete | Determines whether the current record is valid and ready to be deleted from the database. | |
validateField | Determines whether the specified field is valid. | |
validateFieldValue | Validates field value. | |
validateGTA_ForeignVendor_IN | Validates GTA and foreign vendors for reverse cahrge mechanism. | |
validateInvoice | ||
validateSpecBankAccountId_RU | ||
validateW9Received | Validates that a W-9 has been received from the vendor if the journal's account or offset account corresponds to a vendor. | |
validateWrite | Determines whether the current record is valid and ready to be written to the database. | |
validateWrite_Server | Indicates whether the current record is valid and ready to be written to the database. | |
validateWrite_ServerPre | Indicates 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.) | |
vatData_copyLine_PL | ||
vatInPayment_RU | ||
vatTaxAgentAmountPayable_RU | ||
vendPaymentFilledOk | ||
wait | Pauses a process. (Inherited from Object.) | |
wasCached | Specifies the location from which the data was retrieved. (Inherited from xRecord.) | |
write | Writes data to ledger journal trans. | |
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) | |
::calcTaxOnVoucher | ||
::canServiceTaxCalculate_IN | Checks if the service tax can be calculated. | |
::checkVoucherNotUsed_CN | Checks if the voucher is used or not. | |
::clearTaxCache | Clears the internal caches for tax amounts and corrected tax amounts of all ledger journal transactions with specified journal number. | |
::deleteChildrenForLedgerJournalTable | Deletes the records in the delete action tables of the LedgerJournalTranstable associated with the specified LedgerJournalTable record. | |
::deleteForLedgerJournalTable | Deletes all the LedgerJournalTrans records associated with the specified LedgerJournalTable record. | |
::deleteIfZeroAmount | ||
::deleteLineAfterPosting | ||
::deleteTransFromVoucher | ||
::exist | ||
::existBadDebtPeriod_JP | Check whether there are record(s) existing in LedgerJournalTrans. | |
::existCollectedBadDebtPeriod_JP | Reads the LedgerBadDebtAccounts_JP table for the specified id. | |
::existJournalNum_CN | Checks if the journal number exist in the ledger journal transaction. | |
::existLedgerJournalTrans_IN | Determines whether the record exists in the table with specified value model. | |
::existsAdvancePaymentForServiceTax_IN | Checks if the advance payment for service tax exists. | |
::existsLedgerAccount_IN | Checks if the ledger account exists. | |
::existTransMinusThis | ||
::existVoucher | ||
::find | ||
::findByRef | Finds the specified record in the LedgerJournalTrans table. | |
::findByRefAndDataArea | Finds the specified record in the LedgerJournalTrans table. | |
::findByReverse | Finds the specified record in the LedgerJournalTrans table by using the reverse reference. | |
::findFacture_RU | ||
::findJournalForVoucher | Retrieves the specified record in the LedgerJournalTrans table, depending on the Voucher parameter and the transDate parameter. | |
::findLedgerJournalId | ||
::findRCashDocID_HU | ||
::findRecId | ||
::findTaxSource | Determines which LedgerJournalTrans record in an intercompany document is the tax obligation source company. | |
::findTmpVoucher | ||
::findVendTransId | ||
::findVoucher_BR | ||
::getActualAndCalculatedTaxForSingleLineIL | Gets the actual and calculated tax amount for the specified line. | |
::getInterCompanyForCentralizedPay_IN | Gets te company id or the offset company id for a centralized payment line. | |
::getLedgerDimensionForLedgerTypeServer | Gets the ledger account for the default account. | |
::getOffsetLedgerDimForLedgerTypeServer | Gets the offset ledger account for the default account. | |
::getOffsetLedgerDimForProposalServer | Gets the offset ledger account for the default account for a proposal. | |
::getTaxInstance | Gets an instance of TaxCalculation with the tax lines loaded into TmpTaxWorkTrans. | |
::getTaxWithholdInstance_IN | Gets an instance of TaxWithholdCalculation_IN with the withhold tax lines loaded into TmpTaxWithholdWorkTrans_IN. | |
::getTransDateByReverse | Finds the transDate in the LedgerJournalTrans table by using the reverse reference. | |
::isCentralizedAdvancePayment_IN | Checks whether the journal line is linked to Servicetax centralized payment. | |
::isLegalEntityInCountryRegionForDelAct | Gets a value that indicates whether any of the country specific delete action tables of the LedgerJournalTrans table are in scope. | |
::isTaxWithholdGroupOnLJT_IN | Determines whether the specified record have tax withhold group. | |
::lastLineNum | ||
::ledgerJournalTransPool | Returns a LedgerJournalTrans table record that represents an AP invoice pool. | |
::ledgerJournalTransRegister | Returns a record in the LedgerJournalTrans table that represents an AP invoice register. | |
::mainAccount | ||
::mcrFindByInvoice | Finds the specified record in the LedgerJournalTrans table. | |
::mcrFindByPaymIdPaymModePaymRef | Given the payment id,payment mode and paym reference return a record in the LedgerJournalTrans table. | |
::mcrFindRefPaymId | Finds the reference payment ID pertaining to the passed payment record ID. | |
::revertBankBorderoNum_BR | Finds LedgerJournalTrans records and sets their bordero number to empty. | |
::revertBankChequeNum | Finds LedgerJournalTrans records and sets their check number to empty. | |
::splitCreateNewVoucher | ||
::totalTaxAmountSingleLineIL | Gets the total tax amount for the current line. | |
::updateApproveJBAPayment | Updates field approved and approver according to the journal number |
Top
Fields
Field | Type | Configuration key | Description |
---|---|---|---|
AccountAgreementId_RU | Extended Data Type: AgreementId_RU Type: String |
TradeBlanketOrder | Agreement registration number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
AccountType | Enumeration: LedgerJournalACType |
None | Account type that specifies the type of account the transaction will be applied to. |
AcknowledgementDate | Extended Data Type: AcknowledgementDate Type: Date |
None | Date when the company gains knowledge of the transaction. |
Addressing_PL | Extended Data Type: Addressing Type: String |
LedgerBasic | Enter the address of the customer or vendor (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
AgreementCompany_RU | Extended Data Type: AgreementCompany_RU Type: String |
TradeBlanketOrder | Company for agreement selection (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
AmountCurCredit | Extended Data Type: AmountCurCredit Type: Real |
None | Credit amount in given currency. |
AmountCurDebit | Extended Data Type: AmountCurDebit Type: Real |
None | Debit amount in given currency. |
AnnouncementNum_RU | Extended Data Type: BankCashDueAnnouncement_RU Type: String |
Bank | Cash due announcement number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
Approved | Extended Data Type: Approved Type: Enum |
None | Has transaction been approved? |
Approver | Extended Data Type: HcmApprover Type: Int64 |
None | Worker who approved the record. |
AssessableValue_IN | Extended Data Type: AmountCur Type: Real |
None | Assessable value for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
Attachments_CN | Extended Data Type: Counter Type: Integer |
None | Number of attachments (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankAccountId | Extended Data Type: CompanyBankAccountId Type: String |
CustVendNegotiableInstrument | Bank account number |
BankAgreementExt_RU | Extended Data Type: AgreementHeaderExtRecId_RU Type: Int64 |
TradeBlanketOrder | Agreement from registration certificate of transaction. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankBillOfExchangeNum | Extended Data Type: BankBillOfExchangeNum Type: String |
CustBillOfExchange | Number of the printed bill of exchange. |
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. |
BankCentralBankTransTypeCur_RU | Extended Data Type: BankCentralBankTransTypeCur_RU Type: String |
Bank | Currency operation code according to central bank. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankChequeDepositTransRefRecID | Extended Data Type: RefRecId Type: Int64 |
Bank | Customer or vendor transaction for corresponding check reversal or bank deposit slip reference record ID. |
BankChequeNum | Extended Data Type: BankChequeNum Type: String |
BankCheque | Identification of the bank check. |
BankClientDocumentTypeId_RU | Extended Data Type: BankClientDocumentTypeId_RU Type: String |
None | The code of document kind. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankCommAccountId_RU | Extended Data Type: CompanyBankAccountId Type: String |
Bank | Bank account number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankCurrency | Extended Data Type: CurrencyCode Type: String |
None | Current currency code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankCurrencyAmount | Extended Data Type: AmountCur Type: Real |
None | The amount in the transaction currency (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankCurrencyDealCourse_RU | Extended Data Type: BankCurrencyDealCourse_RU Type: Real |
Bank | Bank exchange rate for currency conversion. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankCurrencyTransferLog_RU | Extended Data Type: RefRecId Type: Int64 |
None | Order number for currency sale/purchase/transfer. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankDepositNum | Extended Data Type: BankDepositNum Type: String |
BankDeposit | Deposit slip number. |
BankDepositVoucher | Extended Data Type: BankDepositVoucher Type: Enum |
BankDeposit | If selected, the payment amount can be deposited using a deposit slip |
BankNegInstRecipientName | Extended Data Type: BankNegInstRecipientName Type: String |
BankCheque | The name of the recipient who will be issued a check. |
BankPaymentRegistrationNum_LV | Extended Data Type: LvBankPaymentRegistrationNum Type: String |
None | The payment registration number assigned by bank. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankPrintAccountNum_RU | Extended Data Type: LedgerJournalAC Type: String |
Bank | Payment document will be created for the customer/vendor. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankPromissoryNoteNum | Extended Data Type: BankPromissoryNoteNum Type: String |
VendPromissoryNote | Number of the printed promissory note. |
BankReconcileAccountAtPost | Enumeration: NoYes |
Bank | Reconcile the bank transaction at posting |
BankRemittanceFileId | Extended Data Type: BankRemittanceFileId Type: String |
CustVendNegotiableInstrument | Unique identification of the remittance file. |
BankRemittanceType | Enumeration: BankRemittanceType |
CustVendNegotiableInstrument | Specify the type of remittance made to the bank. |
BankRespWorkerId_RU | Extended Data Type: HcmWorkerRecId Type: Int64 |
None | The name of the worker (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankSpecAccountId_RU | Extended Data Type: CompanyBankAccountId Type: String |
Bank | Bank account number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankTransType | Extended Data Type: BankTransactionType Type: String |
Bank | Transaction type in Cash and bank management module. |
BankVendAccountId_RU | Extended Data Type: VendAccount Type: String |
None | Foreign counteragent from registration certificate of transaction. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BudgetSourceLedgerEntryUnposted | Extended Data Type: RefRecId Type: Int64 |
LedgerAdv2BudgetCtrl | Reference field in a different table |
Cancel | Extended Data Type: Cancelled Type: Enum |
VendInvoiceRegisterApproval | Cancellation of vouchers transferred from invoice approval journal. |
CashDiscAmount | Extended Data Type: DiscAmount Type: Real |
None | Cash discount amount included in the payment. |
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: CashDiscCode Type: String |
LedgerBasic | Cash discount code for subsequent approval. |
CashDiscPercent | Extended Data Type: DiscPct Type: Real |
None | Discount in percentage. |
CashReceiptNum_LV | Extended Data Type: LvCashReceiptNumber Type: String |
None | Number of a cash receipt. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
Company | Extended Data Type: SelectableDataArea Type: String |
None | Abbreviation of the company accounts where the current line is to be posted. |
CompanyLocation_IN | Extended Data Type: LogisticsLocationRecId 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)) |
ConsignmentNoteNum_IN | Extended Data Type: ConsignmentNum_IN Type: String |
None | Identification of the consignment note number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
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)) |
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)) |
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)) |
CurrencyCode | Extended Data Type: CurrencyCode Type: String |
None | Current currency code |
CustBankAccount | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table |
CustEinvoicePaymDeliveryNum | Extended Data Type: CustEinvoicePaymDeliveryNum Type: Integer |
None | Integer. |
CustEinvoicePaymSectionNum | Extended Data Type: CustEinvoicePaymSectionNum Type: Integer |
None | Integer. |
CustEinvoicePaymTransNum | Extended Data Type: CustEinvoicePaymTransNum Type: Integer |
None | Integer. |
CustFactureAutoCreate_RU | Extended Data Type: CustFactureAutoCreate_RU Type: Enum |
LedgerBasic | Create facture on prepayment automatically. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CustomsDuty_IN | Extended Data Type: CustomsAmount_IN Type: Real |
None | The amount in the transaction currency (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CustomsTariffCodeTable_IN | Extended Data Type: RefRecId Type: Int64 |
None | Customs tariff code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CustomsTariffDirection_IN | Enumeration: Direction_IN |
None | Type of direction for the tariff code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CustTransId | Extended Data Type: CustTransRefRecId Type: Int64 |
None | ID of customer transaction being paid. |
CustVendAccount_PL | Extended Data Type: PlCustVendAccount Type: String |
None | Unique number for customer/vendor. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CustVendBankAccountId | Extended Data Type: BankAccountID Type: String |
Bank | Identify bank account of recipient. |
CustVendName_PL | Extended Data Type: PlCustVendName Type: String |
None | Name of customer/vendor. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CustVendNegInstProtestReason | Enumeration: CustVendNegInstProtestReason |
CustVendNegotiableInstrument | Select a protest cause. |
dataAreaId | Extended Data Type: DataAreaId Type: String |
None | |
DateCashDisc | Extended Data Type: TransDate Type: Date |
None | Last date of payment to qualify for cash discount. |
DebitCurrencyCode_LT | Extended Data Type: LtDebitCurrencyCode Type: String |
None | The currency code for the foreign payment (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
DefaultDimension | Extended Data Type: DimensionDefault Type: Int64 |
LedgerBasic | Default dimensions |
DocumentDate | Extended Data Type: DocumentDate Type: Date |
None | Date for document. |
DocumentNum | Extended Data Type: DocumentNum Type: String |
None | Number of the document that generated the voucher. |
Due | Extended Data Type: DueDate Type: Date |
LedgerBasic | Due date for customer/vendor transaction. |
EnterpriseNumber | Extended Data Type: TaxEnterpriseNumber Type: String |
None | Enterprise number used to identify Belgian companies. |
ErrorCodePayment | Extended Data Type: ErrorCodePayment Type: String |
None | Error code received with return message. |
EUSalesList | Extended Data Type: ListDispatchId Type: String |
ForeignTrade | Sequence transaction number. |
ExchRate | Extended Data Type: ExchRate Type: Real |
None | Currency exchange rate for 100 units. |
ExchRateSecond | Extended Data Type: ExchrateSecondary Type: Real |
None | Exchange rate of 2nd part of currency conversion with triangulation. Specified for 100 units. |
ExciseRecordType_IN | Enumeration: ExciseRecordType_IN |
None | Excise record type to update the excise amount to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ExciseTariffCodes_IN | Extended Data Type: RefRecId Type: Int64 |
None | Excise tariff code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ExciseType_IN | Enumeration: ExciseType_IN |
None | Excise-type category of the company. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
FileCreated | Extended Data Type: TransDate Type: Date |
None | Date of generation of payment file. |
ForeignBankFee_LT | Extended Data Type: LTForeignBankFee Type: Enum |
None | The party responsible to pay foreign bank fees (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ForeignCompany | Extended Data Type: SelectableDataArea Type: String |
LedgerAdvIntercompanyAccounting | Foreign company accounts where the voucher also has been posted. |
ForeignVoucher | Extended Data Type: Voucher Type: String |
LedgerAdvIntercompanyAccounting | Voucher number in the other company accounts. |
FreqCode | Enumeration: PeriodUnit |
LedgerBasic | Specify units for periodic transactions. |
FreqValue | Extended Data Type: Freq Type: Integer |
LedgerBasic | Number of units in the individual interval for the transaction. |
FurtherPostingRecId | Extended Data Type: LedgerJournalTransRefRecId Type: Int64 |
None | Reference field in a different table |
FurtherPostingType | Extended Data Type: FurtherPostingType Type: Enum |
LedgerBasic | Use bridging posting? |
GSTHSTTaxType_CA | Enumeration: GSTHSTTaxType_CA |
None | Select the GST/HST line amount type. |
GTAServiceCategory_IN | Enumeration: GTAServiceCategory_IN |
None | The service category for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ImportDate | Extended Data Type: TransDate Type: Date |
None | Date of import of items (used to report with payment). |
InformByPhone_LT | Extended Data Type: LTInformByPhone Type: Enum |
None | If this check box is selected, the beneficiary is informed by telephone (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InformByTelex_LT | Extended Data Type: LTInformByTelex Type: Enum |
None | If this check box is selected, the beneficiary is informed by telex (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
IntBank_LV | Extended Data Type: CompanyBankAccountId Type: String |
Bank | Bank account number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
IntraComVATDueDate_W | Extended Data Type: IntraComVATDueDate_W Type: Enum |
None | Use document date for VAT register (intra-community) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
Invisible | Enumeration: NoYes |
None | |
Invoice | Extended Data Type: InvoiceId Type: String |
None | Invoice number |
InvoiceReleaseDate | Extended Data Type: InvoiceReleaseDate Type: UtcDateTime |
None | The date when the hold is released for the invoice payment |
JournalNum | Extended Data Type: LedgerJournalId Type: String |
LedgerBasic | Ledger - journal batch number. |
LastTransferred | Extended Data Type: LastTransferred Type: Date |
LedgerBasic | Last date of transfer of periodic transactions. |
LedgerDimension | Extended Data Type: DimensionDynamicAccount Type: Int64 |
LedgerBasic | Account number for current account type. |
LedgerJournalDlvDate_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)) |
LedgerVoucherType_CN | Extended Data Type: LedgerVoucherTypeRefRecId_CN Type: Int64 |
LedgerBasic | Name of the voucher type. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
LineNum | Extended Data Type: LineNum Type: Real |
None | Identification of line. |
Listcode | Extended Data Type: ListcodeId Type: Enum |
ForeignTrade | List code to be used with the EU sales list. |
LoadingDate | Extended Data Type: TransDate Type: Date |
None | Date to load this journal. |
MarkedInvoice | Extended Data Type: InvoiceId Type: String |
None | The invoice number that is related to the payment. If multiple invoices are assigned, an asterisk (*) is displayed. |
MarkedInvoiceCompany | Extended Data Type: SelectableDataArea Type: String |
None | ID for the company you can select |
MarkedInvoiceRecId | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table |
MarkupCode_RU | Extended Data Type: MarkupCodeVend_RU Type: String |
Markup | Identification of the charges (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
MaximumRetailPrice_IN | Extended Data Type: AmountCur Type: Real |
None | Maximum retail price for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
MCRCCGeneralLedgerId | Extended Data Type: LedgerJournalId Type: String |
MCRPayment | The general ledger ID that ties the ledger journal transaction records to one general ledger header record (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRPaymOrderID | Extended Data Type: MCRPaymOrderId Type: String |
MCRPayment | Identification of the order (sales order, free-text invoice, etc.) associated with this payment (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRPrintTxtOnCheck | Extended Data Type: MCRPrintTxtOnCheck Type: Enum |
MCRPayment | Print text on check? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRRefPaymID | Extended Data Type: RefRecId Type: Int64 |
MCRPayment | Related payment recID (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
modifiedDateTime | Extended Data Type: ModifiedDateTime Type: UtcDateTime |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
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)) |
NegInstId | Extended Data Type: CustVendNegInstId Type: String |
CustVendNegotiableInstrument | Identification of the negotiable instrument. |
NoEdit | Enumeration: NoYes |
None | |
NonRecoverablePercent_IN | Extended Data Type: Percent Type: Real |
None | Enter the percentage of purchase amount not used to manufacture taxable items. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
OffSessionId_RU | Extended Data Type: OffSessionId_RU Type: String |
None | Unique ID to identify the officials session. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
OffsetAccountAgreementId_RU | Extended Data Type: AgreementId_RU Type: String |
TradeBlanketOrder | Agreement registration number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
OffsetAccountType | Enumeration: LedgerJournalACType |
None | Specify account type of the selected account, for instance ledger, customer or vendor. |
OffsetAgreementCompany_RU | Extended Data Type: AgreementCompany_RU Type: String |
TradeBlanketOrder | Company for agreement selection (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
OffsetCompany | Extended Data Type: SelectableDataArea Type: String |
LedgerAdvIntercompanyAccounting | Abbreviation of the company accounts where the current line is to be offset. |
OffsetDefaultDimension | Extended Data Type: DimensionDefault Type: Int64 |
LedgerBasic | Default dimensions |
OffsetLedgerDimension | Extended Data Type: DimensionDynamicAccount Type: Int64 |
LedgerBasic | Offset account for the transaction. |
OffsetPostingProfile_RU | Extended Data Type: PostingProfile Type: String |
None | Posting profile being processed. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
OffsetTxt | Extended Data Type: LedgerJournalTransTxt Type: String |
None | Any additional text for offset transaction. |
OperationType_MX | Enumeration: VendorOperationType_MX |
None | Operation code used for DIOT declaration. |
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: PaymTermId Type: String |
LedgerBasic | Terms of payment for the current invoice. |
PaymentAccount | Extended Data Type: CompanyBankAccountId Type: String |
BankElectronicBanking | Liquidity account for payment. |
PaymentNotes | Extended Data Type: PaymNote Type: String |
None | Specific comments on payment. |
PaymentPriority_LT | Extended Data Type: LTPaymentPriority Type: Enum |
None | The priority of the payment order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
PaymentSequenceNum | Extended Data Type: PaymentSequenceNum Type: Integer |
PaymMan | Number of the file sent. |
PaymentStatus | Enumeration: CustVendPaymStatus |
None | How far has payment come in the payment schedule? |
PaymId | Extended Data Type: PaymId Type: String |
LedgerBasic | Payment identification used upon payment. |
PaymInstruction1 | Extended Data Type: PaymInstructionRecId Type: Int64 |
None | Code which is used in the SWIFT message for foreign banks. |
PaymInstruction2 | Extended Data Type: PaymInstructionRecId Type: Int64 |
None | Code which is used in the SWIFT message for foreign banks. |
PaymInstruction3 | Extended Data Type: PaymInstructionRecId Type: Int64 |
None | Code which is used in the SWIFT message for foreign banks. |
PaymInstruction4 | Extended Data Type: PaymInstructionRecId Type: Int64 |
None | Code which is used in the SWIFT message for foreign banks. |
PaymMode | Extended Data Type: PaymMode Type: String |
LedgerBasic | The method of payment |
PaymPurpose_LT | Extended Data Type: LtPaymentPurpose Type: String |
LedgerBasic | Specify payment purpose. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
PaymReference | Extended Data Type: PaymReference Type: String |
LedgerBasic | Reference to a specific payment. |
PaymSpec | Extended Data Type: PaymSpec Type: String |
None | Payment specification for the selected payment. |
PoolRecId | Extended Data Type: LedgerJournalTransRefRecId Type: Int64 |
None | Reference field in a different table |
PostingProfile | Extended Data Type: PostingProfile Type: String |
None | Posting profile being processed. |
Prepayment | Enumeration: NoYes |
LedgerBasicSalesTax | Mark that the payment is to be managed as a prepayment. |
Price | Extended Data Type: Price Type: Real |
None | Price applied when recording quantities. |
PurchIdRange | Extended Data Type: PurchIdRange Type: String |
LogisticsBasic | Specify purchase order numbers pertaining to this invoice. |
PurchLedgerPosting | Extended Data Type: PurchLedgerPosting Type: Enum |
VendInvoiceRegisterApproval | Posting used when approving the purchase. |
Qty | Extended Data Type: QtyStatistical Type: Real |
None | Quantity in statistics |
RCashDocRepresPersonId | Extended Data Type: RCashDocRepresPersonId Type: String |
Bank | A person withholding a cash payment. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
RCashDocRepresType | Enumeration: RCashDocRepresType |
Bank | Type of representative. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
RCashPayTransType | Enumeration: RCashPayLedgerTransType |
Bank | Journal line type. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ReasonRefRecID | Extended Data Type: ReasonRefRecID Type: Int64 |
None | Contains stored financial reason codes and comments for entered or posted transactions or actions. |
ReceiptDate_W | Extended Data Type: PurchReceiptDate_W Type: Date |
TradeDates_W | The date when the invoice was received (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
RecId | Extended Data Type: RecId Type: Int64 |
None | |
recVersion | Extended Data Type: RecVersion Type: Integer |
None | |
RefCopyReverse_CN | Extended Data Type: RefRecId Type: Int64 |
LedgerBasic | Record the original journal information. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
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. |
ReleaseDateComment | Extended Data Type: ReleaseDateComment Type: String |
None | Provide an optional comment for the release date |
RemainAmount | Extended Data Type: Amount Type: Real |
None | Remaining amount from invoice after it was paid. |
RemittanceAddress | Extended Data Type: RemittanceAddress Type: Int64 |
None | The mailing address that will be printed on remittances and checks |
RemittanceLocation | Extended Data Type: RemittanceLocation Type: Int64 |
None | The remittance address location name |
RemitteeCurrency | Extended Data Type: CurrencyCode Type: String |
None | Currency in which the amount should be paid off to the receiver's bank. |
RepresPersonCard_W | Extended Data Type: PayeeDocument_RU Type: String |
LedgerBasic | Employee's identity card (i.e. passport). (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
RepresPersonName_W | Extended Data Type: EmplName Type: String |
None | Specify name of employee. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ReverseDate | Extended Data Type: TransDate Type: Date |
LedgerBasicReversingEntries | Enter a posting date for the reversing voucher. |
ReverseEntry | Enumeration: NoYes |
LedgerBasicReversingEntries | Indicates that the current voucher is a reversing entry. |
RevRecId | Extended Data Type: LedgerJournalTransRefRecId Type: Int64 |
LedgerBasicReversingEntries | Reference field in a different table |
SalesTaxFormTypes_IN | Extended Data Type: SalesTaxFormTypesRecId_IN Type: Int64 |
None | India sales tax form type for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ServiceCodeTable_IN | Extended Data Type: RefRecId Type: Int64 |
None | Service code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
SettleVoucher | Enumeration: SettlementType |
LedgerBasic | Specify how settlement takes place. |
SkipBlockedForManualEntryCheck | Enumeration: NoYes |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SoftwareDeclReceived_IN | Extended Data Type: SoftwareDeclReceived_IN Type: Enum |
None | Indicate if the tax on the software has already been paid. If selected, no tax is deducted for the software transaction. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Tax1099Amount | Extended Data Type: Tax1099Amount Type: Real |
None | Amount to be reported in 1099 |
Tax1099Fields | Extended Data Type: Tax1099FieldsRecId Type: Int64 |
None | Box code on the 1099 form that the total amount is posted to. |
Tax1099RecId | 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)) |
Tax1099State | Extended Data Type: Tax1099State Type: String |
None | Identification of state |
Tax1099StateAmount | Extended Data Type: Tax1099StateAmount Type: Real |
None | Amount to be reported in 1099 |
TaxBase_W | Extended Data Type: TaxBase_W Type: Real |
LedgerBasicSalesTax | Enter the statistical amount used to calculate the VAT amount only for the VAT registers (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TaxCode | Extended Data Type: TaxCode Type: String |
LedgerBasicSalesTax | Sales tax code must be entered if account number is a sales tax account. |
TaxDirectionControl | Enumeration: NoYes |
LedgerBasicSalesTax | Should the sales tax direction be controlled by ledger account setup? |
TaxGroup | Extended Data Type: TaxGroupJournal Type: String |
LedgerBasicSalesTax | Sales tax group for automatic tax. |
TaxItemGroup | Extended Data Type: TaxGroupJournal Type: String |
LedgerBasicSalesTax | Group of sales tax codes that can be calculated for an item. |
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)) |
TaxSetoffVoucher_IN | 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, Microsoft Dynamics AX 2012 R2 (SYS)) |
TaxWithholdAlternateVendorAcct_TH | Extended Data Type: TaxWithholdAlternateVendorAcct_TH Type: String |
None | Vendor invoice account. |
TaxWithholdCalculate_TH | Extended Data Type: TaxWithholdCalculate_TH Type: Enum |
None | Shall withholding tax be calculated for vendor payment transactions in journals? |
TaxWithholdCode_IN | Extended Data Type: TaxWithholdCode Type: String |
LedgerBasicWithholdingTax | Withholding tax code of the selected adjustment line in the journal. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TaxWithholdGroup | 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 |
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)) |
TransactionType | Enumeration: LedgerTransType |
None | General specification of the transaction type. |
TransDate | Extended Data Type: TransDate Type: Date |
None | Posting date |
Transfer | Enumeration: NoYes |
None | Is it a transfer? |
TransferCurrency_RU | Extended Data Type: CurrencyCode Type: String |
None | Conversion currency. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
Transferred | Enumeration: NoYes |
None | Has the record been transferred to the journal? |
TransferredBy | Extended Data Type: UserId Type: String |
None | User who transferred the voucher. |
TransferredOn | Extended Data Type: TransDate Type: Date |
None | Transfer date of voucher. |
TransferredTo | Extended Data Type: LedgerJournalId Type: String |
LedgerBasic | Ledger - journal batch number. |
Triangulation | Extended Data Type: EUROTriangulation Type: Enum |
None | Specify whether the exchange rate is included in triangulation. |
Txt | Extended Data Type: LedgerJournalTransTxt Type: String |
None | Text describing the transaction. |
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)) |
VATGoodsType_IN | Enumeration: VATGoodsType_IN |
None | VAT items type for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
VATNumJournal | Extended Data Type: VATNumJournal Type: String |
LedgerBasicSalesTax | Tax exempt number for extract of statistics. |
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)) |
VATOperationCode_RU | Extended Data Type: VATOperationCode_RU Type: String |
LedgerBasicSalesTax | Operation code for VAT declaration. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
VATPaymRefRecId_RU | 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)) |
VATTaxAgentVendAccount_RU | Extended Data Type: VATTaxAgentVendAccount_RU Type: String |
LedgerBasicSalesTax | Vendor account number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
VendBankAccount | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table |
VendInvoiceDeclaration_IS | Extended Data Type: InvoiceDeclarationId_IS Type: Int64 |
None | Classification of vendor invoices used for instance for reporting to authorities. |
VendTransId | Extended Data Type: VendTransRefRecId Type: Int64 |
None | Record ID of vendor transaction. |
Voucher | Extended Data Type: Voucher Type: String |
LedgerBasic | Voucher number |
Voucher_CN | Extended Data Type: Voucher_CN Type: String |
LedgerBasic | Chinese voucher number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
Top
Field Groups
Field Group | Fields |
---|---|
DiotInformation_MX | |
Document | |
ExciseAll_IN | |
EUSalesList | |
Excise_IN | |
ExportPayments | |
ForeignPayments_LT | |
FurtherPosting | |
g1099Fields | |
GSTHSTTaxType_CA | |
Identification | |
IntercompanyAccounting | |
Intrastat | |
Account_W | |
Agreement_RU | |
Administration | |
Amount | |
Amount_IN | |
Approve | |
AutoReport | |
BankClientDocumentType_RU | |
BankCurrencyDealCourse_RU | |
Bank | |
BankChequeDepositTransRef | |
BillOfExchangeDocument | |
BTL91 | |
BankReconcileAtChequeReversal | |
Correct_RU | |
CashDiscBaseDate | |
CashReceipts_LV | |
BudgetSource | |
CompanyInformation_IN | |
Currency | |
CashDiscount | |
CurrencyShow | |
CustomsAll_IN | |
CustomsMisc_IN | |
CustomerImportPayments | |
DepositSlip | |
Description | |
Dates | |
Dimension | |
Settlement | |
Tax_IN | |
TAN_IN | |
TaxSetoffVoucher_IN | |
TaxWithholdCode_IN | |
TransactionType | |
ThirdPartyBank | |
VAT_IN | |
VATOnPayment_RU | |
VatRegister_PL | |
Transfer | |
VATTaxAgent_RU | |
VATTaxAgentInvoice_RU | |
VendInvoiceDeclaration | |
VendTrans | |
Voucher_CN | |
WithHoldingTax | |
Reason | |
RCashPayTransType | |
ReceiptDate_W | |
Reference_CN | |
Remittance | |
Reference_RU | |
SalesTax | |
Representative_RU | |
ReversingEntry | |
SalesTaxAll_IN | |
ServiceTax_IN | |
Posting_W | |
Posting | |
PostingProfiles_RU | |
PostingRelease | |
PrintPaymentOrder_RU | |
ProjectIdentification | |
ProjectIdentificationLedger | |
PromissoryNoteDocument | |
PSA | |
Quantity | |
Purch | |
RCashOrderNotes_RU | |
Invoice | |
InvoicePool | |
Item | |
Markup_RU | |
MCRBankReconciliation | |
MCRMiscellaneous | |
Misc | |
NegInst | |
NegotiableInstrument | |
NotificationToTheCentralBank | |
Officials_RU | |
OffsetAccount | |
OffsetAccount_W | |
Payment | |
Payment_RU | |
PaymentOrder_LV | |
Periodic |
Top
Relations
Relation | Table | Lines |
---|---|---|
AccountAgreementHeaderExt_RU | AgreementHeaderExt_RU | |
AccountAgreementId_RU | AgreementHeaderExt_RU | |
Approver_FK | HcmWorker | |
AssetLedger | AssetLedger | |
BankAccountTable | BankAccountTable | |
BankAccountTable_BankAccountId | BankAccountTable | |
BankAgreementHeaderExt_RU | AgreementHeaderExt_RU | |
BankCentralBankPurpose | BankCentralBankPurpose | |
BankChequeReversalCust | CustTrans | |
BankChequeReversalVend | VendTrans | |
BankChequeTable_RU | BankChequeTable | |
BankClientDocumentType_RU | BankClientDocumentType_RU | |
BankCommAccountId_RU | BankAccountTable | |
BankCurrencyTransferLog_RU | BankCurrencyTransferLog_RU | |
BankDepositCancel | BankDeposit | |
BankPaymentOrderJour_RU | BankPaymentOrderJour_RU | |
BankPromissoryNoteTable | BankPromissoryNoteTable | |
BankRemittanceFilesCust | BankRemittanceFilesCust | |
BankRemittanceFilesVend | BankRemittanceFilesVend | |
BankRespWorker_RU | HcmWorker | |
BankSpecAccountId_RU | BankAccountTable | |
BankTransType | BankTransType | |
BankVendAccountId_RU | VendTable | |
BudgetSource | BudgetSource | |
CashDisc | CashDisc | |
CompanyLocation_IN | LogisticsLocation | |
Currency | Currency | |
Currency_RemitteeCurrency | Currency | |
CustBankAccount_FK | CustBankAccount | |
CustEPRemitInfo_BR | CustEPRemitInfo_BR | |
CustomsTariffCodeTable_IN | CustomsTariffCodeTable_IN | |
CustPaymMode | CustPaymModeTable | |
CustPaymModeSpec | CustPaymModeSpec | |
CustPostingProfile | CustLedger | |
CustTable_RU | CustTable | |
CustTable_W | CustTable | |
CustTrans | CustTrans | |
CustTransCashDisc | CustTransCashDisc | |
CustTransOpen | CustTransOpen | |
DataArea_AgreementCompany | DataArea | |
DataArea_Company | DataArea | |
DataArea_ForeignCompany | DataArea | |
DataArea_MarkedInvoiceCompany | DataArea | |
DataArea_OffsetAgreementCompany | DataArea | |
DataArea_OffsetCompany | DataArea | |
dataAreaId | DataArea | |
DebitCurrencyCode_LT | Currency | |
DefaultDimension | DimensionAttributeValueSet | |
EmplPostingProfile_RU | EmplLedger_RU | |
ExciseTariffCodes_IN | ExciseTariffCodes_IN | |
IntBank_LV | BankAccountTable | |
InvoiceDeclarationId_FK | VendInvoiceDeclaration_IS | |
LedgerDimension | DimensionAttributeValueCombination | |
LedgerJournalTable | LedgerJournalTable | |
LedgerJournalTable_TransferredTo | LedgerJournalTable | |
LedgerJournalTrans | LedgerJournalTrans | |
LedgerJournalTrans_FurtherPostingRecId | LedgerJournalTrans | |
LedgerJournalTrans_RevRecId | LedgerJournalTrans | |
LedgerJournalTransVATPaym_RU | LedgerJournalTrans | |
LedgerJournalTransVoucherTemplate | LedgerJournalTransVoucherTemplate | |
LedgerJournalTxt | LedgerJournalTxt | |
LedgerJournalTxtOffset | LedgerJournalTxt | |
LedgerPaymMode | VendPaymModeTable | |
LedgerVoucherType_CN | LedgerVoucherType_CN | |
LvOtherClients | LvOtherClients | |
MCRCCGeneralLegerId | LedgerJournalTable | |
MCRCustPaymTable | MCRCustPaymTable | |
OfficialsTrans_RU | OfficialsTrans_RU | |
OffsetAccountAgreementHeaderExt_RU | AgreementHeaderExt_RU | |
OffsetAccountAgreementId_RU | AgreementHeaderExt_RU | |
OffsetDefaultDimension | DimensionAttributeValueSet | |
OffsetLedgerDimension | DimensionAttributeValueCombination | |
OffsetPostingProfileCust_RU | CustLedger | |
OffsetPostingProfileEmpl_RU | EmplLedger_RU | |
OffsetPostingProfileRCash | RCashLedger | |
OffsetPostingProfileVend_RU | VendLedger | |
OffsetRCashDocRepresBankEmplId | EmployeeTable_RU | |
OffsetRCashDocRepresCustPersonId | ContactPerson | |
OffsetRCashDocRepresEmplId | EmployeeTable_RU | |
OffsetRCashDocRepresLedgerEmplId | EmployeeTable_RU | |
OffsetRCashDocRepresVendPersonId | ContactPerson | |
Partition | Partitions | |
PaymInstruction1 | PaymInstruction | |
PaymInstruction2 | PaymInstruction | |
PaymInstruction3 | PaymInstruction | |
PaymInstruction4 | PaymInstruction | |
PaymTerm | PaymTerm | |
PlCustVendVatRegNums | PlCustVendVatRegNums | |
PlTaxDueTable | PlTaxDueTable | |
PostingProfileRCash | RCashLedger | |
ProjJournalTxt | ProjJournalTxt | |
ProjJournalTxtOffset | ProjJournalTxt | |
ReasonRef | ReasonTableRef | |
RefCopyReverse_CN | LedgerJournalTrans | |
RemittanceAddress_FK | LogisticsPostalAddress | |
RemittanceLocation_FK | LogisticsLocation | |
SalesTaxFormTypes_IN | SalesTaxFormTypes_IN | |
ServiceCodeTable_IN | ServiceCodeTable_IN | |
TAMDeduction | TAMDeduction | |
Tax1099BoxDetail | Tax1099BoxDetail | |
Tax1099Fields | Tax1099Fields | |
Tax1099State | LogisticsAddressState | |
TaxCode | TaxTable | |
TaxGroup | TaxGroupHeading | |
TaxItemGroup | TaxItemGroupHeading | |
TaxServiceTariff | TaxServiceTariff | |
TaxTable | TaxTable | |
TaxWithholdAltVendorAccount | VendTable | |
TaxWithholdGroupHeading | TaxWithholdGroupHeading | |
TaxWithholdGroupHeadingTCS_IN | TaxWithholdGroupHeading | |
TaxWithholdGroupHeadingTDS_IN | TaxWithholdGroupHeading | |
TaxWithholdItemGroupHeading_TH | TaxWithholdItemGroupHeading_TH | |
TaxWithholdTable_IN | TaxWithholdTable | |
TransferCurrency_RU | Currency | |
UserInfo | UserInfo | |
VATOperationCodeTable_RU | VATOperationCodeTable_RU | |
VATTaxAgentVendAccount_RU | VendTable | |
VendBankAccount_FK | VendBankAccount | |
VendEPRemitInfo_BR | VendEPRemitInfo_BR | |
VendPaymentMode | VendPaymModeTable | |
VendPaymentModeCostJournal | VendPaymModeTable | |
VendPaymentModeSpec | VendPaymModeSpec | |
VendPaymentModeSpecCostJournal | VendPaymModeSpec | |
VendPostingProfile | VendLedger | |
VendPostingProfileCostJournal | VendLedger | |
VendTable_RU | VendTable | |
VendTable_W | VendTable | |
VendTrans | VendTrans | |
VendTransCashDisc | VendTransCashDisc |
Top
Indexes
Index | AllowDuplicates | Enabled | Fields |
---|---|---|---|
AccountAgreement_RUIdx | Yes | Yes | |
ApproverIdx | Yes | Yes | |
AssetToFromRecId_RU | Yes | Yes | |
BankAgreementExt_RUIdx | Yes | Yes | |
BankCurrencyTransferLog_RUIdx | Yes | Yes | |
BankRespWorkerId_RUIdx | Yes | Yes | |
BudgetSourceIdx | Yes | Yes | |
DEL_BankCentralBankPurchaseCur_RU_Idx | Yes | Yes | |
DEL_BankDepositNumIdx | Yes | Yes | |
DEL_Voucher_CNVoucherTypeId_CNRecIdx | Yes | Yes | |
DimensionAttributeValueCombinationIdx | Yes | Yes | |
DimensionAttributeValueCombinationIdx1 | Yes | Yes | |
DimensionAttributeValueSetIdx | Yes | Yes | |
DimensionAttributeValueSetIdx1 | Yes | Yes | |
FurtherPostingRecIdIdx | Yes | Yes | |
LedgerVoucherType_CNIdx | Yes | Yes | |
MCRInvoice | Yes | Yes | |
MCRPaymOrderID | Yes | Yes | |
NumVoucherIdx | Yes | Yes | |
OffsetAccountAgreement_RUIdx | Yes | Yes | |
PaymInstructionIdx1 | Yes | Yes | |
PaymInstructionIdx2 | Yes | Yes | |
PaymInstructionIdx3 | Yes | Yes | |
PaymInstructionIdx4 | Yes | Yes | |
PlTaxDueTableIdx | Yes | Yes | |
PoolRecId | Yes | Yes | |
RecId | No | Yes | |
RevRecIdIdx | Yes | Yes | |
Tax1099FieldsIdx | Yes | Yes | |
VendInvoiceDeclaration_ISIdx | Yes | Yes | |
VendTransIdx | Yes | Yes | |
VoucherTransdate | Yes | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
LedgerJournalTrans Table