VendInvoiceJour Table
The VendInvoiceJour table contains all invoiced purchase order headers.
Configuration Key: LedgerBasic
Methods
Method | Description | |
---|---|---|
accDistributionTemplateRecId | Determines the AccountingDistributionTemplateRecId value that is associated with the invoice. | |
allocateInternalInvoiceId | ||
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 | ||
calcDue | Calculates the due date for the invoice. | |
calcDueDateLimit_ES | ||
calcMSTAmounts | ||
cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) | |
canSubmitToWorkflow | Indicates whether submission to workflow is possible. (Inherited from xRecord.) | |
caption | Gets and sets the caption property of a table. (Inherited from xRecord.) | |
cashDiscTxt | ||
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.) | |
checkVATTaxAgentChargeType_RU | Checks if VAT tax agent charge source is correct | |
clear | Removes all rows from the table buffer. (Inherited from xRecord.) | |
company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) | |
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.) | |
costValue | ||
createPaymentSched | ||
createVendTrans_BR | Indicates whether the corresponding fiscal document will create vendor transactions based on SalesPurchOperationTye_BR configuration. | |
creditNote | ||
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 table. (Inherited from xRecord.) | |
deliveryAddress | Retrieves the delivery address for the invoice. | |
deliveryAddress_RU | ||
deliveryPostalAddressRecId_RU | Returns delivery postal address record id for current invoice | |
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) | |
displayInvoiceStatus | Displays the invoice status of unposted invoices. | |
displayIsVendorAdvance | ||
displayOnHold | ||
displayOrderAccountName | ||
displayPackingSlipId | Retrieves the packing slip number that is associated with the invoice. | |
displayRemittanceAddress | Retrieves the vendor remittance address that is associated with the vendor RemittanceAddressfield on the VendInvoiceJour table. | |
displayRemittanceLocation | Retrieves the vendor remittance location name that is associated with the vendor RemittanceAddress field on the VendInvoiceJour table. | |
displayTaxBranchDimension | Displays the tax branch code depending on the default dimension. | |
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.) | |
docuAllowEdit_W | ||
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.) | |
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) | |
existForCostAllocation_RU | Checks if cost accocations exist for current invoice | |
factureJourSortedList_RU | Return List object with factures created by current invoice | |
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.) | |
fiscalDocument_BR | Returns the FiscalDocument_BR related to the vendInvoiceJour | |
getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) | |
getCorrectedInvoiceDate_RU | Method created for use when calling CustVendInvoiceJour map method. | |
getCorrectedInvoiceId_RU | Method created for use when calling CustVendInvoiceJour map method. | |
getDefaultingDependencies | Returns the container that holds defaulting dependencies. (Inherited from xRecord.) | |
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.) | |
getInternalInvoiceId | ||
getInternalInvoiceIdFromVendTrans | ||
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.) | |
groupId | ||
handle | Retrieves the handle of the class of the object. (Inherited from Object.) | |
hasPositiveTrans_RU | Checks if exists any lines for current invoice with positive quantity | |
hasRelatedTable | Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.) | |
helpField | Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.) | |
initApprovalFromPurchTotals | ||
initFromLedgerJournalTrans | ||
initFromParmTable | Initializes the current VendInvoiceJour record based on the data in the specified VendInvoiceInfoTable record. | |
initFromPurchTable | ||
initFromPurchTablePost_BR | Initializes brazilian fields | |
initFromPurchTotals | ||
initFromSADInvoice_PL | Initialize invoice from SAD invoice reference | |
initFromSADTable_PL | Initalize duty invoice from SAD document | |
initFromVendInvoiceInfoTable | Initializes the current VendInvoiceJour table record based on the data in the specified VendInvoiceInfoTable table record. | |
initFromVendInvoiceInfoTablePost_BR | Initializes brazilian fields based on associated VendInvoiceInfoTable record | |
initFromVendTable | ||
initFromVendTrans | ||
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 the current record into the database. | |
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) | |
interCompanyDerivedActionPolicy | ||
interCompanyDoExternalPosting | ||
interCompanyDoInternalPosting | ||
interCompanyEndpointActionPolicy | Gets the intercompany trading policy for the current VendInvoiceJour table record. | |
interCompanyTransTableNum | ||
isAdvance | Indicates whether the invoice is an advance invoice. | |
isBlockedForBookInvoice_RU | ||
isCostAllocationInvoice_RU | ||
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.) | |
isInclTax | Determines whether this invoice includes tax in the line amount. | |
isIndebtednessInvoice_RU | ||
isInventProfileTypeMapped_RU | Method created for use when calling CustVendInvoiceJour map method. | |
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) | |
isNonPO | Determines whether this invoice is associated with a purchase order. | |
isPartOfUOWSaveChanges | (Inherited from xRecord.) | |
isProforma | ||
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.) | |
joinChild | Finds the join child of the current record. (Inherited from xRecord.) | |
joinParent | Finds the join parent of the current record. (Inherited from xRecord.) | |
ledgerVoucher | Determines the LedgerVoucher object that is associated with this invoice. | |
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) | |
merge | Merges the current table with the specified table. (Inherited from xRecord.) | |
modifiedField | Modifies the specified field to the original. (Inherited from xRecord.) | |
modifiedFieldValue | Modifies the specified field to the original value. (Inherited from xRecord.) | |
module | ||
netAmount | ||
new | Initializes a new instance of the Object class. (Inherited from Object.) | |
notClosed_RU | ||
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.) | |
originalInvoices_W | ||
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.) | |
packVendInvoiceJour_Intrastat | Packs VendInvoiceJour_Intrastat extension table record. | |
parmExchangeRateDate | ||
parmParentSourceDocumentLine | ||
parmSourceDocHeaderTypeEnumName | ||
parmSourceDocHeaderTypeEnumValue | ||
parmSourceDocLineTypeEnumName | ||
parmSourceDocLineTypeEnumValue | ||
paymentCondition | ||
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.) | |
printEUVatInvoice | ||
printJournal | ||
purchTable | ||
queryTaxTrans | ||
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.) | |
queryTmpTaxWorkTrans | ||
queryVendInvoiceTrans | ||
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.) | |
readyForCostAllocation_RU | ||
recordLevelSecurity | Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.) | |
refOriginalInvoiceRecId_RU | Gets record id of original invoice. | |
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.) | |
reverseChargeAmount_UK | ||
reverseChargeApplies_UK | ||
reverseChargeWording_UK | ||
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) | |
salesTaxNumber_IN | Displays the registration nubmer for the sale tax registration nubmer. | |
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.) | |
setConnection | Sets the user connection for this table. (Inherited from xRecord.) | |
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) | |
setFacturedFully_RU | ||
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) | |
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.) | |
setXDSContext | Sets new XDS context. (Inherited from xRecord.) | |
showExchRate | ||
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.) | |
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.) | |
taxableBalance | ||
taxAmountCorrected | ||
taxFreeBalance | ||
tinNumber_IN | Displays the registration nubmer for the Tax Identification Number. | |
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.) | |
totalAdvanceApplicationAmount | Calculates the prepayment amount applied in the invoice amount. | |
totaltaxAmountRetained_BR | Retrieves the sum of the SourceRegulateAmountCur fields from Tax trans related to the vendor journal. | |
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. | |
updateDue_JP | Calculates due date and updates related trans and open trans accordingly. | |
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. (Inherited from xRecord.) | |
validateField | Determines whether the p1 field is valid. | |
validateFieldValue | (Inherited from xRecord.) | |
validatePaymentSched | ||
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.) | |
vatDueDate_W | ||
vendAddress | ||
vendInvoiceJour_Intrastat | Retrieves VendInvoiceJour_Intrastat extension table record. | |
vendInvoiceJourExtensionTH | Get the VendInvoiceJourExtensionTH table. | |
vendName | ||
vendTable_InvoiceAccount | ||
vendTable_OrderAccount | ||
vendTrans | ||
venInvoiceJourListPreviewPaneTitle | ||
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.) | |
::exist | ||
::findFromPurchId | ||
::findFromPurchParmTable | ||
::findFromTaxTrans | ||
::findFromVendInvoiceTrans | ||
::findFromVendTrans | ||
::findFromVendTransVoucher | ||
::findRecId | ||
::findSourceDocumentHeader | Finds a VendInvoiceJour record by using the specified SourceDocumentHeader record. | |
::findSourceDocumentLine | Finds a VendInvoiceJour record by using the specified SourceDocumentLine record. |
Top
Fields
Field | Type | Configuration key | Description |
---|---|---|---|
AttorneyDate_RU | Extended Data Type: AttorneyDate_RU Type: Date |
LogisticsBasic | Issue date of proxy. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
AttorneyId_RU | Extended Data Type: AttorneyId_RU Type: String |
LogisticsBasic | Specify the proxy number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
AttorneyIssuedName_RU | Extended Data Type: AttorneyIssuedName_RU Type: String |
LogisticsBasic | To whom proxy was issued. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
BankLCImportLine | Extended Data Type: BankLCLineRefRecId Type: Int64 |
BankDocument | The shipment number of shipment details. |
CashDisc | Extended Data Type: VendCashDiscAmount Type: Real |
None | Cash discount granted when payment is made before a given date. |
CashDiscCode | Extended Data Type: VendCashDiscCode Type: String |
LedgerBasic | Terms of cash discount for the current invoice. |
CashDiscDate | Extended Data Type: VendCashDiscDate Type: Date |
None | Last date of payment to qualify for cash discount. |
CashDiscPercent | Extended Data Type: DiscPct Type: Real |
None | Discount in percentage. |
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)) |
ConsTarget_JP | Extended Data Type: VendConsTarget_JP Type: Enum |
LedgerBasic | This check box indicates whether the invoice for this purchase order will be consolidated later. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ContractNum_SA | Extended Data Type: VendContractNumZakat_SA Type: String |
LedgerBasic | Select the contract number. |
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)) |
CostLedgerVoucher | Extended Data Type: Voucher Type: String |
LedgerBasic | Voucher number in ledger. |
CountryRegionId | Extended Data Type: AddressCountryRegionId Type: String |
None | Specifies default native country/region in connection with addresses |
createdBy | Extended Data Type: CreatedBy Type: String |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
createdDateTime | Extended Data Type: CreatedDateTime Type: UtcDateTime |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CurrencyCode | Extended Data Type: VendCurrencyCode Type: String |
None | Currency used for invoicing |
dataAreaId | Extended Data Type: DataAreaId Type: String |
None | |
DefaultDimension | Extended Data Type: DimensionDefault Type: Int64 |
LedgerBasic | Default dimensions |
DeliveryAddress_LT | Extended Data Type: Addressing Type: String |
LedgerBasic | View the formatted information for the address (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: DlvDate Type: Date |
None | Purchase delivery date (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
DeliveryName | Extended Data Type: VendName Type: String |
LedgerBasic | The name that is associated with the selected delivery address |
DeliveryName_LT | Extended Data Type: VendName Type: String |
LedgerBasic | Name of vendor. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
DeliveryPostalAddress | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table |
Description | Extended Data Type: InvoiceDescription Type: String |
None | The description of the invoice |
DlvAddress_LV | Extended Data Type: Addressing Type: String |
LedgerBasic | View the formatted information for the address (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
DlvMode | Extended Data Type: VendDlvModeId Type: String |
None | Specify mode of delivery for the current delivery. |
DlvTerm | Extended Data Type: VendDlvTermId Type: String |
None | Specify terms of delivery for current delivery. |
DocumentDate | Extended Data Type: DocumentDate Type: Date |
None | Date of any external document |
DocumentNum | Extended Data Type: DocumentNum Type: String |
None | Number of the document that generated the transaction. |
DocumentOrigin | Enumeration: DocumentOrigin |
None | The source of the document |
DueDate | Extended Data Type: DueDate Type: Date |
LedgerBasic | Due date of invoice amount. |
EndDisc | Extended Data Type: PurchEndDiscAmount Type: Real |
PriceDisc | Total invoice discount |
EndDiscMST | Extended Data Type: PurchEndDiscAmountMST Type: Real |
PriceDisc | The transaction amount, in the accounting currency |
EnterpriseNumber | Extended Data Type: TaxEnterpriseNumber Type: String |
None | Enterprise number used to identify Belgian companies. |
EUSalesList | Extended Data Type: ListDispatchId Type: String |
ForeignTrade | Sequence transaction number. |
ExchRate | Extended Data Type: VendExchRate Type: Real |
None | Exchange rate of invoice currency (%1 = 1.0) |
ExchRateSecondary | Extended Data Type: ExchrateSecondary Type: Real |
None | Rate of the secondary part of the currency calculation, when triangulation is used |
FacturedFully_RU | Extended Data Type: FacturedFully_RU Type: Enum |
LedgerBasicSalesTax | Fully factured line. (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: RefRecId 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)) |
FixedDueDate | Extended Data Type: PurchFixedDueDate Type: Date |
LogisticsBasic | Due date independent of terms of payment. |
InclTax | Extended Data Type: InclTax Type: Enum |
LogisticsBasic | Do prices include sales tax? |
InterCompanyCompanyId | Extended Data Type: InterCompanyCompanyId Type: String |
TradeInterCompany | Identification of intercompany company accounts. |
InterCompanyLedgerVoucher | Extended Data Type: InterCompanyVoucher Type: String |
TradeInterCompany | Identification of the intercompany purchase order. |
InterCompanyPosted | Extended Data Type: InterCompanyPosted Type: Enum |
TradeInterCompany | The journal was posted automatically via intercompany |
InterCompanySalesId | Extended Data Type: InterCompanySalesId Type: String |
TradeInterCompany | Identification of the intercompany sales order. |
InternalInvoiceId | Extended Data Type: PurchInternalInvoiceId Type: String |
LogisticsBasic | Internal identification of the invoice |
IntrastatAddValue_LV | Extended Data Type: LvIntrastatAddValue Type: Real |
ForeignTrade | The additional value to be distributed equally among the lines to calculate the statistical value (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
IntrastatDispatch | Extended Data Type: IntrastatDispatchId Type: String |
ForeignTrade | Shipment batch number in Intrastat. |
IntrastatFulfillmentDate_HU | Extended Data Type: IntrastatFulfillmentDate_HU Type: Date |
ForeignTrade | Date of Intrastat fulfillment. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InventBaileeReceiptReportId_RU | Extended Data Type: InventBaileeReceiptReportId_RU Type: String |
LogisticsBasic | Identifier of acceptance report in storage. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InventProfileType_RU | Enumeration: InventProfileType_RU |
InventTrackingGTDProfileOwner | Kind of activity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InvoiceAccount | Extended Data Type: VendInvoiceAccount Type: String |
None | Vendor account that generated the invoice. |
InvoiceAmount | Extended Data Type: AmountCur Type: Real |
None | Total amount of invoice. |
InvoiceAmountMST | Extended Data Type: AmountMST Type: Real |
None | The total invoice amount, in the accounting currency |
InvoiceDate | Extended Data Type: TransDate Type: Date |
None | Date of invoice. |
InvoiceId | Extended Data Type: VendInvoiceId Type: String |
LedgerBasic | Invoice number |
InvoiceRegister_LT | Extended Data Type: LtDocRegister Type: Enum |
None | Include document in register log. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InvoiceRoundOff | Extended Data Type: RoundOff Type: Real |
None | Rounding-off of invoice amount. |
InvoiceStatus_LT | Enumeration: LtDocStatus |
None | Document status for transaction. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InvoiceType | Enumeration: PurchInvoiceType |
None | The type of invoice submitted by the vendor |
ItemBuyerGroupId | Extended Data Type: ItemBuyerGroupId Type: String |
LogisticsBasic | Identification of the buyer group. |
LanguageId | Extended Data Type: VendLanguageId Type: String |
None | Select the language for the current text. |
LedgerVoucher | Extended Data Type: Voucher Type: String |
LedgerBasic | Voucher number that the transaction is attached to. |
Listcode | Extended Data Type: ListcodeId Type: Enum |
ForeignTrade | List code to be used with the EU sales list. |
LogisticsElectronicAddress | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table |
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)) |
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)) |
NumberSequenceCode_LT | 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, 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. |
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)) |
OperationType_MX | Enumeration: VendorOperationType_MX |
None | Operation code used for DIOT declaration. |
OrderAccount | Extended Data Type: VendAccount Type: String |
None | Vendor account where purchase has been ordered |
ParmId | Extended Data Type: ParmId Type: String |
None | Number of the reporting (one total update). |
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)) |
PaymDayId | Extended Data Type: VendPaymDayId Type: String |
LedgerBasic | Identification of payment days |
Payment | Extended Data Type: VendPaymTermId Type: String |
LedgerBasic | Terms of payment for vendor |
PaymentSched | Extended Data Type: PaymSchedId Type: String |
PaymSched | Payment schedule to be used when invoicing. |
PaymId | Extended Data Type: PaymId Type: String |
LedgerBasic | Payment identification used for the payment of invoices |
PostingProfile | Extended Data Type: VendPostingProfile Type: String |
None | Posting profile being processed. |
Prepayment | Extended Data Type: CustVendPrepayment Type: Enum |
None | Is this invoice a prepayment invoice? |
Proforma | Extended Data Type: CustVendProforma Type: Enum |
None | Is this invoice a pro forma invoice? |
PurchAgreementHeader_PSN | 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)) |
PurchaseType | Enumeration: PurchaseType |
LogisticsBasic | Type of the current purchase |
PurchId | Extended Data Type: PurchIdBase Type: String |
LogisticsBasic | Purchase number that the invoice is attached to. |
PurchReceiptDate_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)) |
Qty | Extended Data Type: PurchInvoicedQty Type: Real |
LogisticsBasic | Total number of units on the invoice |
ReasonTableRef_BR | Extended Data Type: ReasonTableRefRecId Type: Int64 |
None | Contains stored financial reason codes and comments for entered or posted transactions or actions. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
RecId | Extended Data Type: RecId Type: Int64 |
None | |
recVersion | Extended Data Type: RecVersion Type: Integer |
None | |
RemittanceAddress | Extended Data Type: RemittanceAddress Type: Int64 |
None | The mailing address that will be printed on remittances and checks |
ReturnItemNum | Extended Data Type: ReturnItemNum Type: String |
ReturnItem | Unique number issued to authorize the return. |
ReverseCharge_UK | Extended Data Type: TaxAmountCur Type: Real |
LedgerBasicSalesTax | Calculated sales tax amount in the sales tax settlement currency |
SalesBalance | Extended Data Type: AmountCur Type: Real |
None | Total of invoice line amounts, incl. line discount |
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: SourceDocumentHeaderRecId Type: Int64 |
LedgerBasic | Reference field in a different table |
SourceDocumentLine | Extended Data Type: SourceDocumentLineRecId Type: Int64 |
LedgerBasic | Reference field in a different table |
StateInvoicePrinted_LV | Enumeration: NoYes |
None | Is printed (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
SumLineDisc | Extended Data Type: PurchSumLineDiscAmount Type: Real |
PriceDisc | Line discount total of the invoice lines |
SumMarkup | Extended Data Type: MarkupSumPurch Type: Real |
Markup | The total incidental cost of product acquisition |
SumMarkupMST | Extended Data Type: AmountMST Type: Real |
None | The transaction amount, in the accounting currency |
SumTax | Extended Data Type: TaxAmountCur Type: Real |
LedgerBasicSalesTax | Total sales tax amount of invoice |
TaxGroup | Extended Data Type: TaxGroup Type: String |
LedgerBasicSalesTax | A group of sales tax codes for calculating taxes on a sale or purchase |
TaxInvoicePurchId | Extended Data Type: TaxInvoicePurchId Type: String |
None | Unique key for invoice, allocated when invoice updating. |
TaxPrintOnInvoice | Extended Data Type: TaxPrintOnInvoice Type: Enum |
LedgerBasicSalesTax | Write marking on invoice. |
TaxRoundOff | Extended Data Type: TaxAmountCur Type: Real |
LedgerBasicSalesTax | Rounding in relation to sales tax amount of invoice |
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)) |
TaxSpecifyByLine | Extended Data Type: TaxSpecifyLine Type: Enum |
LedgerBasicSalesTax | Indicate whether calculated sales tax amount per line shall be stored in the invoice journal lines. |
TaxWithholdAmount_IN | 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)) |
TransitControlVoucher_BR | 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)) |
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)) |
Triangulation | Extended Data Type: EUROTriangulation Type: Enum |
None | Specify whether the exchange rate is included in triangulation. |
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)) |
VATAmount_IN | Extended Data Type: AmountCur Type: Real |
None | Total VAT amount calculated on capital items. (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)) |
VendConsInvoice_JP | 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)) |
VendFinalUser_BR | Extended Data Type: CustVendFinalUser_BR Type: Enum |
None | Are you the final user? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
VendGroup | Extended Data Type: VendGroupId Type: String |
LedgerBasic | Vendor group that the invoice is attached to. |
VendInvoiceDeclaration_IS | Extended Data Type: InvoiceDeclarationId_IS Type: Int64 |
None | Classification of vendor invoices used for instance for reporting to authorities. |
VendInvoiceGroup | Extended Data Type: VendInvoiceGrouping Type: String |
None | The group that this invoice belongs to |
VendorRequestedWorkerEmail | Extended Data Type: Email Type: String |
None | The e-mail address of the requested approver for the invoice |
VendPaymentGroup | Extended Data Type: VendPaymentGrouping Type: String |
None | The common code by which transactions are grouped for payment |
Volume | Extended Data Type: Volume Type: Real |
None | Total volume on invoice, in cubic meters |
Weight | Extended Data Type: Weight Type: Real |
None | Total weight in lbs. on invoice |
WhoIsAuthor_LT | Enumeration: LtDocOriginator |
None | Originator of the document. (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 |
---|---|
Administration | |
Advance | |
AutoReport | |
AutoSummary | |
CaseMoreInformation | |
Contract_SA | |
CreditNote_LV | |
BankLCImportGroup | |
Currency | |
Delivery_LT | |
Description | |
Correct_RU | |
Dimension | |
AmountInDefaultCurrency | |
Attorney_RU | |
FiscalInformation_BR | |
DiotInformation_MX | |
InventPackaging | |
ForeignTrade | |
Identification | |
Intercompany | |
InventBailee_RU | |
InvoiceDetails | |
InvoiceGrouping | |
InventProfile_RU | |
Ledger | |
LogisticsElectronicAddress | |
NonRealRevenue_RU | |
Payment | |
PaymentSchedule | |
PurchaseOrder | |
Remittance | |
ReverseCharge_UK | |
SalesTax | |
PrintManagement | |
SourceDocument | |
Quantity | |
TaxSetoffVoucher_IN | |
TermsOfDelivery | |
SpecialReport | |
StateNumbering | |
Vendor | |
VendPaymentGroup | |
Totals | |
VAT_IN | |
VendConsInvoice_JP | |
VendInvoiceDeclaration | |
VSSInvoiceApproval | |
VSSElectronicAddress | |
VSSOtherDetails | |
VSSInvoiceDates | |
VSSDeliveryAddress | |
VSSInvoiceIdentification |
Top
Relations
Relation | Table | Lines |
---|---|---|
BankLCImportLine | BankLCImportLine | |
CashDisc | CashDisc | |
Currency | Currency | |
CustTableConsignee | CustTable | |
DataArea | DataArea | |
dataAreaId | DataArea | |
DefaultDimension | DimensionAttributeValueSet | |
DeliveryPostalAddress_FK | LogisticsPostalAddress | |
DlvMode | DlvMode | |
DlvTerm | DlvTerm | |
FiscalDocumentType_BR | FiscalDocumentType_BR | |
InventBuyerGroup | InventBuyerGroup | |
InvoiceDeclarationId_FK | VendInvoiceDeclaration_IS | |
LanguageTable | LanguageTable | |
LogisticsAddressCountryRegion | LogisticsAddressCountryRegion | |
LogisticsElectronicAddress_FK | LogisticsElectronicAddress | |
NumberSequenceCode_LT | NumberSequenceTable | |
NumberSequenceGroup | NumberSequenceGroup | |
OfficialsTrans | OfficialsTrans_RU | |
Partition | Partitions | |
PaymDay | PaymDay | |
PaymSched | PaymSched | |
PaymTerm | PaymTerm | |
PurchAgreementHeader | PurchAgreementHeader | |
PurchTable_PurchId | PurchTable | |
ReasonTableRef | ReasonTableRef | |
RemittanceAddress_FK | LogisticsPostalAddress | |
SalesPurchOperationType_BR | SalesPurchOperationType_BR | |
SourceDocumentHeader | SourceDocumentHeader | |
SourceDocumentLine | SourceDocumentLine | |
TaxGroupHeading | TaxGroupHeading | |
TransportationDocument | TransportationDocument | |
VendConsInvoice_JP | VendConsInvoice_JP | |
VendGroup | VendGroup | |
VendInvoiceJour | VendInvoiceJour | |
VendLedger | VendLedger | |
VendTable_InvoiceAccount | VendTable | |
VendTable_OrderAccount | VendTable | |
VendTableConsignor | VendTable |
Top
Indexes
Index | AllowDuplicates | Enabled | Fields |
---|---|---|---|
CostLedgerVoucherInvoiceDateIdx | Yes | Yes | |
DefaultDimensionIdx | Yes | Yes | |
DEL_ConsIdx_JP | Yes | Yes | |
DEL_InventProfileType_RU_Idx | Yes | Yes | |
FiscalDocumentType_BRIdx | Yes | Yes | |
InvoiceAccountIdx | Yes | Yes | |
InvoiceIdx | Yes | Yes | |
LedgerVoucherInvoiceDateIdx | Yes | Yes | |
ParmIdx | Yes | Yes | |
PurchIdx | Yes | Yes | |
RecId | No | Yes | |
SourceDocumentHeader | Yes | Yes | |
SourceDocumentLine | Yes | Yes | |
VATNumIdx | Yes | Yes | |
VendConsInvoice_JPIdx | Yes | Yes | |
VendIdx | Yes | Yes | |
VendInvoiceDeclaration_ISIdx | Yes | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
VendInvoiceJour Table