PurchParmTable Table

  • Article

The PurchParmTable table contains detailed information about posting purchase headers.

Configuration Key: LogisticsBasic

Methods

  Method Description
Gg956908.pubmethod(en-us,AX.60).gif aosValidateDelete Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif aosValidateInsert Validates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif aosValidateRead Validates on the server that the specified record can be read. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif aosValidateUpdate Validates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif buf2con Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif canSubmitToWorkflow Indicates whether submission to workflow is possible. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif caption Gets and sets the caption property of a table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif checkIfLines
Gg956908.pubmethod(en-us,AX.60).gif checkInvalidFieldAccess Gets and sets invalid field access. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif checkRecord Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif checkRestrictedDeleteActions Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif clear
Gg956908.pubmethod(en-us,AX.60).gif company Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif con2buf Unpacks a container into the table buffers. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif concurrencyModel Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif context Gets and sets the context property. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif copyPaymentSched
Gg956908.pubmethod(en-us,AX.60).gif createPaymentSched
Gg956908.pubmethod(en-us,AX.60).gif data Retrieves a row from the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif dataSource Retrieves the data source of the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif defaultField Applies default value to a field.
Gg956908.pubmethod(en-us,AX.60).gif defaultRow Applies default values to all fields.
Gg956908.pubmethod(en-us,AX.60).gif delete Deletes the current record from the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif deleteRelatedTrans Delete records of OfficialsTrans_RU for current PurchParmTable record.
Gg956908.pubmethod(en-us,AX.60).gif deliveryAddress
Gg956908.pubmethod(en-us,AX.60).gif disableCache Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif displayOrdering Displays the label text for the current value in the ordering field.
Gg956908.pubmethod(en-us,AX.60).gif dispose Releases resources that are used by the xRecord object. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif doClear Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif documentDate
Gg956908.pubmethod(en-us,AX.60).gif doDelete Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif doInsert Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif doUpdate Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif doValidateDelete Performs the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif editExchRate
Gg956908.pubmethod(en-us,AX.60).gif editExchRateSecond
Gg956908.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif fieldAccessRight Returns the field access right. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif fieldBufferAccessRight Returns the field access right for the current record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif fieldState Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif firstPackingSlipDate_ES Finds the first delivery date for the packing slip.
Gg956908.pubmethod(en-us,AX.60).gif getAllowRedefault Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getBillOfEntryQuantity_IN Gets BillOfEntry quantity for specified PurchId and CustomsImportInvoiceNumberTable_IN recId.
Gg956908.pubmethod(en-us,AX.60).gif getDefaultingDependencies Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getEUROTriangulation
Gg956908.pubmethod(en-us,AX.60).gif getExchRateDate Determines exchange rate date.
Gg956908.pubmethod(en-us,AX.60).gif getExtension Returns the table extension. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getFieldValue Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getFiscalEstablishment_BR Retrieves the fiscal establishments of the current VendInvoiceInfoTable table record.
Gg956908.pubmethod(en-us,AX.60).gif getImporterInvoiceDate_IN Reads the CustomsImportInvoiceNumberTable_IN table for the specified record id.
Gg956908.pubmethod(en-us,AX.60).gif getInstanceRelationType Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getPhysicalTableName Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getPresenceFieldData Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getReceive_IN Gets the receive quantity.
Gg956908.pubmethod(en-us,AX.60).gif getRemainingQuantity_IN Gets the remaining quantity.
Gg956908.pubmethod(en-us,AX.60).gif getSQLStatement Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getTableInInstanceHierarchy (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getTableType Indicates the type of the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif hasRelatedTable Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif helpField Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif initFromExchRates
Gg956908.pubmethod(en-us,AX.60).gif initFromPurchTable
Gg956908.pubmethod(en-us,AX.60).gif initTotals
Gg956908.pubmethod(en-us,AX.60).gif initValue Initializes a field to the default value. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif inputStatus Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif insert Inserts the current record into the database.
Gg956908.pubmethod(en-us,AX.60).gif interactiveContext Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif isAdvance
Gg956908.pubmethod(en-us,AX.60).gif isArranged
Gg956908.pubmethod(en-us,AX.60).gif isFieldDataRetrieved Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif isFieldSet Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif isFormDataSource Indicates whether the data source is a form. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif isNewRecord Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif isNonPO
Gg956908.pubmethod(en-us,AX.60).gif isPartOfUOWSaveChanges (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif isTempDb Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif isTmp Indicates whether this is a temporary table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif joinChild Finds the join child of the current record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif joinParent Finds the join parent of the current record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif linkPhysicalTableInstance Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif markupAllowed Determines if the associated MarkupTrans records may be added, changed, or deleted.
Gg956908.pubmethod(en-us,AX.60).gif merge Merges the current table with the specified table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif modifiedField
Gg956908.pubmethod(en-us,AX.60).gif modifiedFieldValue Modifies the specified field to the original value. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif new Initializes a new instance of the Object class. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif numberOfLines
Gg956908.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif orig Retrieves the original values of the current record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif overwriteSystemfields Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif paymModeModified
Gg956908.pubmethod(en-us,AX.60).gif postCacheLoad Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif postLoad Is executed after a record is read. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif preRemoting Is executed before a cross-tier call is about to be executed for the table that would pack its state to the other tier. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif processingTime
Gg956908.pubmethod(en-us,AX.60).gif purchParmUpdate
Gg956908.pubmethod(en-us,AX.60).gif purchTable
Gg956908.pubmethod(en-us,AX.60).gif queryLine
Gg956908.pubmethod(en-us,AX.60).gif querySubTable
Gg956908.pubmethod(en-us,AX.60).gif queryTimedOut Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif queryTimeout Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif readCommittedLock (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif readPast Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif recordLevelSecurity Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif relatedTable Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif renamePrimaryKey Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif reread Rereads the record from the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif RowCount Retrieves the number of rows in the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif selectForUpdate Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif selectLocked Indicates whether to select locked records. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif selectRefRecord Selects the record by referenced field ID. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif selectWithRepeatableRead Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif setConnection Sets the user connection for this table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif setCrossPartition Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif setFieldValue Sets the field value in the record buffer. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif setSQLTracing Enables or disables SQL tracing mode. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif setTmp Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif setTmpData Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif setXDSContext Sets new XDS context. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif skipAosValidation Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif skipDatabaseLog Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif skipDataMethods Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif skipDeleteActions Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif skipDeleteMethod Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif skipEvents Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif skipPostLoad Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif skipTTSCheck Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif suppressWarnings Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif tableAccessRight Returns the table access right. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif tableBufferAccessRight Returns the table access right for the current record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif takeOwnershipOfTempDBTable (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif toolTipField Retrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif toolTipRecord Retrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif ttsabort Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif ttsbegin Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif ttscommit Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg956908.privmethod(en-us,AX.60).gif type Gets the strategy used for validation and applying default values.
Gg956908.pubmethod(en-us,AX.60).gif update Updates the current record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif updateDate
Gg956908.pubmethod(en-us,AX.60).gif updateParmJobStatusContainErrors
Gg956908.pubmethod(en-us,AX.60).gif updateParmJobStatusExecuted
Gg956908.pubmethod(en-us,AX.60).gif usageCount Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif useDocumentDate
Gg956908.pubmethod(en-us,AX.60).gif useExistingTempDBTable (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif validateDelete Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif validateField Determines whether the _fieldIdToCheck field is valid.
Gg956908.pubmethod(en-us,AX.60).gif validateFieldValue Determines whether the parameter "_fieldName" field is valid.
Gg956908.pubmethod(en-us,AX.60).gif validateWrite Determines whether the current record is valid and ready to be written to the database.
Gg956908.privmethod(en-us,AX.60).gif validateWrite_ServerPre Determines whether the current record is valid and ready to be written to the database.
Gg956908.pubmethod(en-us,AX.60).gif validTimeStateUpdateMode Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif vendTable_InvoiceAccount
Gg956908.pubmethod(en-us,AX.60).gif vendTable_OrderAccount
Gg956908.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg956908.pubmethod(en-us,AX.60).gif wasCached Specifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif write Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gif xml Retrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::checkDuplicateBOENumber_IN Checks duplicate BOE number.
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::checkDuplicateImporterNumber_IN Checks duplicate importer number.
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::defaultEUROTriangulation
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::defaultExchRate
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::defaultExchRateSecondary
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::deleteWithoutUpdate
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::exist
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::existsActivePurchId Indicates whether a specified purchase order is selected for any kind of posting.
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::find
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::findPurchId
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::findRecId
Gg956908.pubmethod(en-us,AX.60).gifGg956908.static(en-us,AX.60).gif ::setWorkflowState Sets the PurchParmTable workflow state for the COR: Packing slip posting workflow.

Top

Fields

Field Type Configuration key Description
BankLCImportLine Extended Data Type: BankLCLineRefRecId
Type: Int64
 BankDocument The shipment number of shipment details.
BatchAdministration Extended Data Type: BatchAdministration
Type: Enum
 None Run batch administration?
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 Code for cash discount on invoice received
CashDiscDate Extended Data Type: VendCashDiscDate
Type: Date
 None Cash discount date to be used when creating vendor transaction.
CashDiscPercent Extended Data Type: DiscPct
Type: Real
 None Discount in percentage.
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))
CountyOrigDest Extended Data Type: AddressCountyOrigDest
Type: String
 None Intrastat county of origin/destination.
createdBy Extended Data Type: CreatedBy
Type: String
 None
createdDateTime Extended Data Type: CreatedDateTime
Type: UtcDateTime
 None
CurrencyCode Extended Data Type: VendCurrencyCode
Type: String
 None Currency the purchase is invoiced in.
CustomsBillOfEntryNumberTable_IN Extended Data Type: RefRecId
Type: Int64
 None The bill of entry number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CustomsImportInvoiceNumberTable_IN Extended Data Type: RefRecId
Type: Int64
 None The import invoice number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dataAreaId Extended Data Type: DataAreaId
Type: String
 None
DeliveryName Extended Data Type: VendName
Type: String
 LedgerBasic The name that is associated with the selected delivery address
DeliveryPostalAddress Extended Data Type: LogisticsPostalAddressRecId
Type: Int64
 None Reference field in a different table
Description Extended Data Type: InvoiceDescription
Type: String
 None The description of the invoice
DocRegister_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))
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
ElectronicInvoice_BR Extended Data Type: EletronicInvoice_BR
Type: Enum
 None Identification of electronic invoice (city) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
EndDateTime Extended Data Type: EndDateTime
Type: UtcDateTime
 None End Datetime help text
EndDisc Extended Data Type: PurchEndDiscAmount
Type: Real
 PriceDisc Total invoice discount
EnterpriseNumber Extended Data Type: TaxEnterpriseNumber
Type: String
 None Enterprise number used to identify Belgian companies.
EUROTriangulation Extended Data Type: EUROTriangulation
Type: Enum
 None Specify whether the exchange rate is included in triangulation.
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
FiscalDocumentModel_BR Extended Data Type: FiscalDocumentModel_BR
Type: String
 None Fiscal document model (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
FiscalDocumentSeries_BR Extended Data Type: FiscalDocumentSeries_BR
Type: String
 None Fiscal document series (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
FiscalDocumentSpecie_BR Enumeration: FiscalDocumentSpecie_BR
 None Specie of the fiscal document (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 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))
FixedDueDate Extended Data Type: PurchFixedDueDate
Type: Date
 LogisticsBasic The due date is independent of the terms of payment.
FixedExchRate Extended Data Type: FixedExchRate
Type: Enum
 None Specify whether fixed exchange rate is to be used.
Hold Extended Data Type: Hold
Type: Enum
 LedgerBasic If selected, the invoice document will be saved but not posted
IgnoreCalculatedSalesTax Enumeration: NoYes
 LedgerBasicSalesTax If selected, only actual sales tax amounts received on electronic PO invoices are used
InclTax Extended Data Type: InclTax
Type: Enum
 LogisticsBasic Do prices include sales tax?
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 invoicing the purchase
InvoiceReleaseDate Extended Data Type: InvoiceReleaseDate
Type: UtcDateTime
 None The date when the hold is released for the invoice payment
InvoiceRoundOff Extended Data Type: RoundOff
Type: Real
 None Rounding-off of invoice amount.
LastMatchVariance Extended Data Type: LastMatchVariance
Type: Enum
 PurchInvoiceMatching The result of invoice matching the last time the document was saved
Log Extended Data Type: LogText
Type: String
 None Log error messages
Num Extended Data Type: Num
Type: String
 None Invoice number
NumberSequenceGroup Extended Data Type: NumberSequenceGroupId
Type: String
 None Group for allocation of different number sequences to different customers/vendors.
OffReportType_RU Enumeration: OffReportType_RU
 None Report type with officials. (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))
OrderAccount Extended Data Type: VendAccount
Type: String
 None Vendor account number.
Ordering Enumeration: DocumentStatus
 None Description of the current document type.
PackingSlipIdForUpdate_W Extended Data Type: PackingSlipIdForUpdate_W
Type: String
 LogisticsBasic Numbers of packing slips for update. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ParmId Extended Data Type: ParmId
Type: String
 None Number of the reporting (one total update).
ParmJobStatus Enumeration: ParmJobStatus
 None Status of the current 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))
Payment Extended Data Type: VendPaymTermId
Type: String
 LedgerBasic Terms of payment for the received invoice
PaymentSched Extended Data Type: PaymSchedId
Type: String
 PaymSched Payment schedule to be used when invoicing.
PaymId Extended Data Type: PaymId
Type: String
 LedgerBasic The payment identification that is used when an invoice is paid
PaymMode Extended Data Type: VendPaymMode
Type: String
 LedgerBasic The method of payment for the vendor
PaymSpec Extended Data Type: PaymSpec
Type: String
 None The specification code for the selected method of payment
Port Extended Data Type: IntrastatPortId
Type: String
 ForeignTrade Port where current delivery is loaded.
PostingProfile Extended Data Type: VendPostingProfile
Type: String
 None Posting profile being processed.
PurchId Extended Data Type: PurchId
Type: String
 LogisticsBasic Identification of the purchase.
PurchName Extended Data Type: PurchName
Type: String
 LogisticsBasic Purchase description
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)
ReCalculate Enumeration: boolean
 None
RecId Extended Data Type: RecId
Type: Int64
 None
recVersion Extended Data Type: RecVersion
Type: Integer
 None
ReleaseDateComment Extended Data Type: ReleaseDateComment
Type: String
 None Provide an optional comment for the release date
RemittanceLocation Extended Data Type: RemittanceLocation
Type: Int64
 None The remittance address location name
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))
SettleVoucher Extended Data Type: PurchSettlementType
Type: Enum
 LogisticsBasic Specify if voucher should be settled.
StartDateTime Extended Data Type: StartDateTime
Type: UtcDateTime
 None Start DateTime help text
StatProcId Extended Data Type: IntrastatProcId
Type: String
 ForeignTrade Code for the current statistical procedure.
Storno Enumeration: NoYes
 None Correction +/- (Debit/Credit) to transaction
StornoPhysical_RU Enumeration: NoYes
 None Correction +/- (Debit/Credit) to transaction (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TableRefId Extended Data Type: TradeLineRefId
Type: String
 None Reference between parent and child line.
TaxGroup Extended Data Type: TaxGroup
Type: String
 LedgerBasicSalesTax Sales tax group for calculation of sales tax on purchase
TaxInformation_IN Extended Data Type: TaxInformationRecId_IN
Type: Int64
 None Tax Account Number (TAN) to be used when identifying the withholding tax settlement periods. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TaxRoundOff Extended Data Type: TaxAmountCur
Type: Real
 LedgerBasicSalesTax Rounding in relation to sales tax amount of invoice
TransactionCode Extended Data Type: IntrastatTransactionCodeId
Type: String
 ForeignTrade Code for the current transaction code.
TransDate Extended Data Type: TransDate
Type: Date
 None Transaction date
Transport Extended Data Type: IntrastatTransport
Type: String
 ForeignTrade Specify means of transport for the current order.
VarianceApproved Extended Data Type: VarianceApproved
Type: Enum
 PurchInvoiceMatching If selected, invoices with matching errors are approved for posting
VarianceApprovedDateTime Extended Data Type: VarianceApprovedDateTime
Type: UtcDateTime
 PurchInvoiceMatching The date and time that the invoice was approved to post with matching discrepancies
VarianceComment Extended Data Type: VarianceComment
Type: String
 PurchInvoiceMatching Enter a comment associated with the approval of posting with matching discrepancies
VATNum Extended Data Type: VATNumJournal
Type: String
 LedgerBasicSalesTax Tax exempt identification number
VendBankAccountID Extended Data Type: VendBankAccountId
Type: String
 PublicSector The bank account for the vendor
VendFinalUser_BR Extended Data Type: CustVendFinalUser_BR
Type: Enum
 None Is this a "customer final user" or "vendor for used and consumption”? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VendInvoiceGroup Extended Data Type: VendInvoiceGrouping
Type: String
 None The group that this invoice belongs to
VendInvoiceSaveStatus Enumeration: VendInvoiceSaveStatus
 LedgerBasic Indicates whether the invoice document has been created (New) or if it has been saved (Pending)
VendPackingSlipJour Extended Data Type: VendPackingSlipJourRecId
Type: Int64
 None Reference field in a different table
VendPaymentGroup Extended Data Type: VendPaymentGrouping
Type: String
 None The common code by which transactions are grouped for payment
WorkflowState Enumeration: TradeWorkflowState
 LogisticsBasic Workflow state

Top

Field Groups

Field Group Fields
Document
Delivery
FiscalInformation_BR
FixedDueDate
ForeignTrade
Identification
InventProfile_RU
InvoiceDetails
PaymentInvoice
InvoiceGrouping
Posting
Payment
Posting_RU
RegistrationNumbers_IN
SalesTax
PurchaseTable
ProcessingTime
Remittance
ServiceTax_IN
SpecialReport
StateNumbering
TaxInformation_IN
VarianceApproval
Vendor
Administration
Amount
AutoReport
Approved
BankLCImportGroup
BankManagement
CashDiscount
Correction
Currency
CurrencyShow
Customs_IN
VendPaymentGroup
Workflow

Top

Relations

Relation Table Lines
BankLCImportLine BankLCImportLine
CashDisc CashDisc
CountyOrigDest LogisticsAddressCounty
Currency Currency
CustomsBillOfEntryNumberTable_IN CustomsBillOfEntryNumberTable_IN
CustomsImportInvoiceNumberTable_IN CustomsImportInvoiceNumberTable_IN
dataAreaId DataArea
DeliveryPostalAddress_FK LogisticsPostalAddress
FiscalDocModel_BR FiscalDocModel_BR
FiscalDocumentType_BR FiscalDocumentType_BR
IntrastatPort IntrastatPort
IntrastatStatProc IntrastatStatProc
IntrastatTransactionCode IntrastatTransactionCode
IntrastatTransportMode IntrastatTransportMode
InvoiceVendor VendTable
NumberSequenceGroup NumberSequenceGroup
OfficialsTrans_RU OfficialsTrans_RU
OrderVendor VendTable
Partition Partitions
PaymSched PaymSched
PaymTerm PaymTerm
PurchParmTable PurchParmTable
PurchParmUpdate PurchParmUpdate
PurchTable PurchTable
ReasonTableRef ReasonTableRef
RemittanceLocation_FK LogisticsLocation
TaxGroupHeading TaxGroupHeading
TaxInformation_IN TaxInformation_IN
TaxWorkRegulation TaxWorkRegulation
VendBankAccount VendBankAccount
VendLedger VendLedger
VendPackingSlipJour VendPackingSlipJour
VendPaymentModeSpec VendPaymModeSpec
VendPaymModeTable VendPaymModeTable

Top

Indexes

Index AllowDuplicates Enabled Fields
CustomsBillOfEntryNumberTable_INIdx Yes Yes
CustomsImportInvoiceNumberTable_INIdx Yes Yes
DEL_PostingProfile_RU_Idx Yes Yes
FiscalDocumentType_BRIdx Yes Yes
ParmIdPurchIdIdx Yes Yes
ParmTableRefIdx No Yes
PurchIdx Yes Yes
RecId No Yes
TaxInformation_INIdx Yes Yes
VendPackingSlipJourIdx Yes Yes

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    PurchParmTable Table

See Also

Table Methods

Tables Overview