PurchLineAllVersions View [AX 2012]

The PurchLineAllVersions view contains all approved and confirmed purchase order line versions.

Configuration Key: LogisticsBasic

  MethodDescription
Gg990561.pubmethod(en-us,AX.60).gifaosValidateDeleteValidates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifaosValidateInsertValidates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifaosValidateReadValidates on the server that the specified record can be read. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifaosValidateUpdateValidates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifbuf2conPacks the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifcancelTimeOutCancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifcanSubmitToWorkflowIndicates whether submission to workflow is possible. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifcaptionGets and sets the caption property of a table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifcheckInvalidFieldAccessGets and sets invalid field access. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifcheckRecordGets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifcheckRestrictedDeleteActionsGets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifclearRemoves all rows from the table buffer. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifcompanyGets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifcon2bufUnpacks a container into the table buffers. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifconcurrencyModelGets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifcontextGets and sets the context property. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdataRetrieves a row from the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdataSourceRetrieves the data source of the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdefaultFieldPopulates default values in a field in the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdefaultRowPopulates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdeleteDeletes the current record from the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdisableCacheGets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdisposeReleases resources that are used by the xRecord object. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdoClearRemoves all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdoDeleteDeletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdoInsertInserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdoUpdateUpdates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifdoValidateDeletePerforms the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifequalDetermines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giffieldAccessRightReturns the field access right. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giffieldBufferAccessRightReturns the field access right for the current record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giffieldStateSets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetAllowRedefaultReturns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetDefaultingDependenciesReturns the container that holds defaulting dependencies. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetExtensionReturns the table extension. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetFieldValueGets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetInstanceRelationTypeReturns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetPhysicalTableNameReturn the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetPresenceFieldDataRetrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetSQLStatementGets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetTableInInstanceHierarchy (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetTableTypeIndicates the type of the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifgetTimeOutTimerHandleReturns the timer handle for the object. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifhandleRetrieves the handle of the class of the object. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifhasRelatedTableIndicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifhelpFieldRetrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifinitValueInitializes a field to the default value. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifinputStatusSets or returns the current input status of the table buffer. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifinsertInserts the record into the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifinteractiveContextSets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifinventDimFinds the InventDim record that is referenced by the line.
Gg990561.pubmethod(en-us,AX.60).gifinventTableFinds the InventTable record that is referenced by the line.
Gg990561.pubmethod(en-us,AX.60).gifisFieldDataRetrievedChecks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifisFieldSetChecks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifisFormDataSourceIndicates whether the data source is a form. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifisNewRecordReturns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifisPartOfUOWSaveChanges (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifisTempDbIndicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifisTmpIndicates whether this is a temporary table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifitemNameRetrieves the name of the InventTable record that is related to the current record.
Gg990561.pubmethod(en-us,AX.60).gifjoinChildFinds the join child of the current record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifjoinParentFinds the join parent of the current record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giflinkPhysicalTableInstanceChecks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifmcrPurchLineHistoryGets the PurchLineHistory record associated with the InventTransIdon the current PurchLineAllVersions record.
Gg990561.pubmethod(en-us,AX.60).gifmergeMerges the current table with the specified table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifmodifiedFieldModifies the specified field to the original. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifmodifiedFieldValueModifies the specified field to the original value. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifnewInitializes a new instance of the Object class. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifnotifyReleases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifnotifyAllReleases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifobjectOnServerDetermines whether the object is on a server. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).giforigRetrieves the original values of the current record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifoverwriteSystemfieldsGets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifownerReturns the instance that owns the object. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifparmParentSourceDocumentLine
Gg990561.pubmethod(en-us,AX.60).gifparmSourceDocLineTypeEnumName
Gg990561.pubmethod(en-us,AX.60).gifparmSourceDocLineTypeEnumValue
Gg990561.pubmethod(en-us,AX.60).gifparmSourceDocumentHeader
Gg990561.pubmethod(en-us,AX.60).gifpdsCWUnitIdGets the catch weight unit for the item.
Gg990561.pubmethod(en-us,AX.60).gifpostCacheLoadIs executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifpostLoadIs executed after a record is read. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifpreRemotingIs 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.)
Gg990561.pubmethod(en-us,AX.60).gifqueryTimedOutIndicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifqueryTimeoutGets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifreadCommittedLock (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifreadPastGets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifrecordLevelSecurityGets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifrelatedTableSets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifrenamePrimaryKeyRenames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifrereadRereads the record from the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifRowCountRetrieves the number of rows in the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifselectForUpdateGets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifselectLockedIndicates whether to select locked records. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifselectRefRecordSelects the record by referenced field ID. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifselectWithRepeatableReadGets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifsetConnectionSets the user connection for this table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifsetCrossPartitionSets or resets cross-partitioning for the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifsetFieldValueSets the field value in the record buffer. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifsetSQLTracingEnables or disables SQL tracing mode. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifsetTimeOutSets up the scheduled execution of a specified method. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifsetTmpSets the table so that it is not persisted to the database. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifsetTmpDataSets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifsetXDSContextSets new XDS context. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifskipAosValidationGets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifskipDatabaseLogGets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifskipDataMethodsGets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifskipDeleteActionsGets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifskipDeleteMethodGets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifskipEventsProvides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifskipPostLoadGets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifskipTTSCheckGets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifsuppressWarningsGets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giftableAccessRightReturns the table access right. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giftableBufferAccessRightReturns the table access right for the current record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giftakeOwnershipOfTempDBTable (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giftoolTipFieldRetrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giftoolTipRecordRetrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).giftoStringReturns a string that represents the current object. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifttsabortAborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifttsbeginStarts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifttscommitCommits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifupdateUpdates the current record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifusageCountRetrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifuseExistingTempDBTable (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifvalidateDeleteDetermines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifvalidateFieldDetermines whether the specified field is valid. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifvalidateFieldValue (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifvalidateWriteDetermines whether the current record is valid and ready to be written. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifvalidTimeStateUpdateModeSets a valid time state update mode on the cursor. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifwaitPauses a process. (Inherited from Object.)
Gg990561.pubmethod(en-us,AX.60).gifwasCachedSpecifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifwriteUpdates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifxmlRetrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg990561.pubmethod(en-us,AX.60).gifGg990561.static(en-us,AX.60).gif::linesChangedFieldIdSetCreates a set containing the field ID for the fields in the LinesChangedConfirmationReport field group in the PurchLineAllVersions view.
Top

FieldTypeConfiguration keyDescription
AccountingDistributionTemplate Extended Data Type: RefRecId
Type: Int64
NoneReference field in a different table
ActivityNumber Extended Data Type: ProjActivityNumber
Type: String
ProjBasicThe activity number
AddressRefRecId Extended Data Type: AddressRefRecId
Type: Int64
NoneReference field in a different table
AddressRefTableId Extended Data Type: AddressRefTableId
Type: Integer
NoneTable the transaction refers to.
AssetBookId Extended Data Type: AssetBookIdPurchSalesInvent
Type: String
AssetValue model related to the current transaction.
AssetGroup Extended Data Type: AssetGroupId
Type: String
AssetSelect a fixed asset group
AssetId Extended Data Type: AssetIdOpen
Type: String
AssetUnique key for identification of fixed asset. The key is used when creating new assets.
AssetTransTypePurch Extended Data Type: AssetTransTypePurchEDT
Type: Enum
AssetWhich type of fixed asset transaction is to be created in connection with the purchase?
BarCode Extended Data Type: PurchBarCode
Type: String
LogisticsBasicBar code digits
BarCodeType Extended Data Type: BarcodeSetupId
Type: String
NoneSelect or view the bar code setup ID
Blocked Extended Data Type: LineStopped
Type: Enum
NoneIs the line locked?
CaseTagging Extended Data Type: RFIDCaseTagging
Type: Enum
RFIDTaggingIs case tagging mandatory?
Complete Extended Data Type: LineComplete
Type: Enum
NoneDeliver complete line?
ConfirmedDlv Extended Data Type: PurchLineDlvDate
Type: Date
LogisticsBasicDate for confirmed delivery.
ConfirmedTaxAmount Extended Data Type: TaxAmountCur
Type: Real
LedgerBasicSalesTaxCalculated sales tax amount in the sales tax settlement currency
ConfirmedTaxWriteCode Extended Data Type: TaxWriteCode
Type: String
LedgerBasicSalesTaxCode printed on the voucher.
CountryRegionName_RU Extended Data Type: CustInvoiceCountryName_RU
Type: String
LedgerBasicShort name for a country/region (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
NoneIntrastat county of origin/destination.
CovRef Enumeration: PurchCovRef
LedgerAdvCashflowForecastWhat is the purchase coverage planned for?
CreateFixedAsset Enumeration: NoYes
NoneSelect this field if a new fixed asset should be created for the purchase line when a product receipt or invoice is posted
CurrencyCode Extended Data Type: VendCurrencyCode
Type: String
NoneCurrency the line is invoiced in
CustomerRef Extended Data Type: CustRefLine
Type: String
LedgerBasicCustomer's reference
CustPurchaseOrderFormNum Extended Data Type: CustPurchaseOrder
Type: String
NoneCustomer requisition number
dataAreaId Extended Data Type: DataAreaId
Type: String
None
DefaultDimension Extended Data Type: DimensionDefault
Type: Int64
LedgerBasicDefault dimensions
DeliveryDate Extended Data Type: PurchLineDlvDate
Type: Date
LogisticsBasicLine delivery date
DeliveryName Extended Data Type: LogisticsDeliveryName
Type: String
NoneThe name that is associated with the selected delivery address
DeliveryPostalAddress Extended Data Type: LogisticsPostalAddressRecId
Type: Int64
NoneReference field in a different table
DeliveryType Extended Data Type: TradeLineDlvTypeId
Type: Enum
NoneDelivery type of the current order line.
DepreciationStartDate Extended Data Type: AssetDepreciationStartDate
Type: Date
AssetDate from which the fixed asset will begin depreciating.
DeviationQty_RU Extended Data Type: PurchDeviationQty_RU
Type: Real
LogisticsBasicInventory qty deviation. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DiscAmount Extended Data Type: PurchDiscAmount
Type: Real
PriceDiscThe amount in the transaction currency
DiscPercent Extended Data Type: PurchDiscPercent
Type: Real
PriceDiscDiscount in percentage.
ExternalItemId Extended Data Type: PurchExternalItemId
Type: String
LogisticsBasicVendor's item number
GSTHSTTaxType_CA Enumeration: GSTHSTTaxType_CA
NoneSelect the GST/HST line amount type.
InterCompanyInventTransId Extended Data Type: InventRefTransId
Type: String
TradeInterCompanyLot ID referred to.
InterCompanyOrigin Enumeration: InterCompanyOrigin
TradeInterCompanyStates whether the line was created manually (Source), or indirectly as part of an intercompany chain (Derived)
InventDimId Extended Data Type: InventDimId
Type: String
NoneIdentification of dimensions for the item.
InventReceivedNow Extended Data Type: InventQty
Type: Real
NoneQuantity now being received in inventory unit
InventRefId Extended Data Type: InventRefId
Type: String
NoneNumber of the order, project, production, or purchase referred to
InventRefTransId Extended Data Type: InventRefTransId
Type: String
LogisticsBasicLot ID referred to.
InventTransId Extended Data Type: TradeInventTransId
Type: String
LogisticsBasicIdentification of the item lot.
InvoiceGTDId_RU Extended Data Type: CustFreeInvoiceGTDId_RU
Type: String
LedgerBasicCustoms declaration number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
IsArchived Extended Data Type: VersioningIsVersionArchived
Type: Enum
NoneHas the current version been archived to the history tables?
IsFinalized Extended Data Type: PurchLineIsFinalized
Type: Enum
LogisticsBasicIndicates whether the purchase order line is finalized or not
ItemBOMId Extended Data Type: ItemBOMId
Type: String
BOMVersionBOM number for specific sub-BOM. If blank, the active number is used.
ItemId Extended Data Type: ItemIdSmall
Type: String
LogisticsBasicItem number included in the line.
itemPBAId Extended Data Type: PBAId
Type: String
PBA_ProductBuilderProduct model ID
ItemRefType Enumeration: InventRefType
NoneModule and number referred to
ItemRouteId Extended Data Type: ItemRouteId
Type: String
ProdRoutingRoute number for specific subroute. If blank, the active number is used.
ItemTagging Extended Data Type: RFIDItemTagging
Type: Enum
RFIDTaggingIs item tagging mandatory?
LedgerDimension Extended Data Type: LedgerDimensionDefaultAccount
Type: Int64
LedgerBasicLedger account for posting lines in special receipt account.
LineAmount Extended Data Type: PurchLineAmount
Type: Real
LogisticsBasicLine amount after subtracting discounts
LineDeliveryType Enumeration: LineDeliveryType
NoneRole of line in a delivery schedule
LineDisc Extended Data Type: PurchLineDisc
Type: Real
PriceDiscLine discount in amount per price unit.
LineHeader Extended Data Type: LineHeader
Type: String
NoneText describing the line
LineNumber Extended Data Type: TradeLineNumber
Type: Int64
LogisticsBasicIdentifies the line within the purchase order.
LinePercent Extended Data Type: PurchLinePercent
Type: Real
PriceDiscLine discount percentage.
MarkupCode_RU Extended Data Type: MarkupCodeVend_RU
Type: String
MarkupIdentification of the charges (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
MatchingAgreementLine Extended Data Type: RefRecId
Type: Int64
NoneReference field in a different table
MatchingPolicy Enumeration: PurchMatchingPolicyOption
PurchInvoiceMatchingPolicy for the selected PO line. Three-way: PO, product receipt, and invoice. Two-way: PO and invoice.
MultiLnDisc Extended Data Type: PurchMultiLnDisc
Type: Real
PriceDiscMultiline discount per price unit
MultiLnPercent Extended Data Type: PurchMultiLnPercent
Type: Real
PriceDiscThe multiline discount percentage
Name Extended Data Type: ItemFreeTxt
Type: String
LogisticsBasicLine description
OverDeliveryPct Extended Data Type: PurchOverDeliveryPct
Type: Real
LogisticsOverUnderDeliveryThe percentage by which the product receipt quantity is allowed to exceed the order quantity
PalletTagging Extended Data Type: RFIDPalletTagging
Type: Enum
RFIDTaggingIs pallet tagging mandatory?
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))
PdsCWInventReceivedNow Extended Data Type: PdsCWQtyReceiveNow
Type: Real
PdsCatchWeightCatch weight receive now quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCWQty Extended Data Type: PdsCWInventQty
Type: Real
PdsCatchWeightCatch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCWRemainInventFinancial Extended Data Type: PdsCWInventQty
Type: Real
PdsCatchWeightCW quantity that has been packing slip received but not yet invoice updated. (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))
PdsCWRemainInventPhysical Extended Data Type: PdsCWInventQty
Type: Real
PdsCatchWeightCW quantity - not yet packing slip delivered - in the inventory unit. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
Port Extended Data Type: IntrastatPortId
Type: String
ForeignTradePort where current delivery is loaded.
PostingProfile_RU Extended Data Type: VendPostingProfile
Type: String
NonePosting profile being processed. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PriceAgreementDate_RU Extended Data Type: PriceAgreementDate_RU
Type: Date
NoneDate for price determining in price agreement. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PriceUnit Extended Data Type: PriceUnit
Type: Real
LogisticsBasicNumber of units the quantity applies to.
ProcurementCategory Extended Data Type: PurchCategory
Type: Int64
LogisticsBasicCategory from the procurement category hierarchy
ProjCategoryId Extended Data Type: ProjCategoryId
Type: String
ProjBasicCategory that is used as a default.
ProjId Extended Data Type: ProjId
Type: String
ProjBasicProject identification
ProjLinePropertyId Extended Data Type: ProjLinePropertyId
Type: String
ProjBasicAttribute that defines cost and sales percentages and options for revenue accrual and capitalization cost
ProjSalesCurrencyId Extended Data Type: CurrencyCode
Type: String
NoneCurrency in which the project is invoiced.
ProjSalesPrice Extended Data Type: ProjSalesPriceCost
Type: Real
ProjBasicSales price per unit calculated in the current sales currency.
ProjSalesUnitId Extended Data Type: UnitOfMeasureSymbol
Type: String
NoneUnit symbol
ProjTaxGroupId Extended Data Type: ProjTaxGroup
Type: String
ProjBasicSales tax group project invoicing.
ProjTaxItemGroupId Extended Data Type: ProjTaxItemGroup
Type: String
ProjBasicItem sales tax group project invoicing.
ProjTransId Extended Data Type: ProjItemTransId
Type: String
ProjBasicIdentification of transaction.
PurchaseType Enumeration: PurchaseType
LogisticsBasicPurchase type
PurchId Extended Data Type: PurchIdBase
Type: String
LogisticsBasicPurchase number that the line is attached to
PurchMarkup Extended Data Type: PurchMarkup
Type: Real
LogisticsBasicFixed charges on purchase price, which are independent of quantity
PurchPrice Extended Data Type: PurchPrice
Type: Real
NonePurchase price per price unit
PurchQty Extended Data Type: PurchOrderedQty
Type: Real
LogisticsBasicQuantity ordered in purchase unit
PurchReceivedNow Extended Data Type: PurchQty
Type: Real
LogisticsBasicQuantity received now in purchase units
PurchReqId Extended Data Type: PurchReqId
Type: String
PurchReqIdentification of the purchase requisition
PurchReqLineRefId Extended Data Type: PurchReqLineRefId
Type: Guid
PurchReqUnique identification of line
PurchStatus Enumeration: PurchStatus
LogisticsBasicLine status with regard to delivery and invoicing
PurchTableVersionRecId Extended Data Type: RecId
Type: Int64
NoneUnique ID for the record in the database
PurchUnit Extended Data Type: PurchUnit
Type: String
NoneUnit in which the item is purchased.
QtyOrdered Extended Data Type: InventQty
Type: Real
NoneQuantity ordered in the inventory unit.
RecId Extended Data Type: RecId
Type: Int64
None
RecId1 Extended Data Type: RecId
Type: Int64
NoneUnique ID for the record in the database
recVersion Extended Data Type: RecVersion
Type: Integer
None
RefReturnInvoiceTrans_W Extended Data Type: RefReturnInvoiceTrans_W
Type: Int64
LedgerBasicReference 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))
RemainInventFinancial Extended Data Type: InventQty
Type: Real
NoneQuantity that has been received through a product receipt but has not yet been invoice updated.
RemainInventPhysical Extended Data Type: InventQty
Type: Real
NoneQuantity for which a packing slip has not yet been received in the inventory unit
RemainPurchFinancial Extended Data Type: PurchQty
Type: Real
LogisticsBasicQuantity that has been received through a product receipt but has not yet been invoice updated.
RemainPurchPhysical Extended Data Type: PurchQty
Type: Real
LogisticsBasicQuantity that has not yet been received through a product receipt.
ReqAttention Extended Data Type: PurchReqAttention
Type: String
PurchReqAttention information for the purchase requisition
ReqPlanIdSched Extended Data Type: ReqPlanIdSched
Type: String
ReqIdentification of plan
ReqPOId Extended Data Type: ReqPOId
Type: String
ReqNumber identifying the planned order
Requester Extended Data Type: PurchRequester
Type: Int64
NoneThe name of the worker
ReturnActionId Extended Data Type: PurchReturnActionId
Type: String
LogisticsBasicWhat should happen with the returned items?
ReturnDispositionCodeId Extended Data Type: ReturnDispositionCodeId
Type: String
ReturnItemIdentification of the disposition code.
ReturnStatus Enumeration: ReturnStatusLine
ReturnItemStatus of the return line.
Scrap Enumeration: NoYes
NoneNo inventory transactions will be created for the line.
ShippingDateConfirmed Extended Data Type: SalesShippingDateConfirmed
Type: Date
LogisticsBasicThe selling company confirms that the order will be shipped on this date.
ShippingDateRequested Extended Data Type: SalesShippingDateRequested
Type: Date
LogisticsBasicThe day the selling company should ship the item in order to meet the customer's requested receipt date.
SourceDocumentLine Extended Data Type: RefRecId
Type: Int64
NoneReference field in a different table
StatProcId Extended Data Type: IntrastatProcId
Type: String
ForeignTradeCode for the current statistical procedure.
StatTriangularDeal Extended Data Type: IntrastatTriangularDeal
Type: Enum
ForeignTradeIs this a triangular deal?
StockedProduct Extended Data Type: TradeStockedProduct
Type: Enum
LogisticsBasicTrack in inventory?
Tax1099Amount Extended Data Type: Tax1099Amount
Type: Real
NoneAmount to be reported in 1099
Tax1099Fields Extended Data Type: Tax1099FieldsRecId
Type: Int64
NoneBox code on the 1099 form that the total amount is posted to.
Tax1099State Extended Data Type: Tax1099State
Type: String
NoneIdentification of state
Tax1099StateAmount Extended Data Type: Tax1099StateAmount
Type: Real
NoneAmount to be reported in 1099
TaxAutogenerated Extended Data Type: TaxAutoGenerated
Type: Enum
LedgerBasicSalesTaxSales tax is automatically calculated or specified by user.
TaxGroup Extended Data Type: TaxGroup
Type: String
LedgerBasicSalesTaxName of sales tax group.
TaxItemGroup Extended Data Type: TaxItemGroup
Type: String
LedgerBasicSalesTaxGroup of sales tax codes that can be calculated for an item.
TaxWithholdBaseCur_TH Extended Data Type: TaxWithholdBaseCur
Type: Real
LedgerBasicWithholdingTaxAdjusted withholding tax base amount
TaxWithholdGroup_TH Extended Data Type: TaxWithholdGroup
Type: String
LedgerBasicWithholdingTaxIdentification of the withholding tax group.
TaxWithholdItemGroupHeading_TH Extended Data Type: TaxWithholdItemGroupId_TH
Type: Int64
NoneGroup of withholding tax codes that can be calculated for an item
TransactionCode Extended Data Type: IntrastatTransactionCodeId
Type: String
ForeignTradeCode for the current transaction code.
Transport Extended Data Type: IntrastatTransport
Type: String
ForeignTradeSpecify means of transport for the current order.
UnderDeliveryPct Extended Data Type: PurchUnderDeliveryPct
Type: Real
LogisticsOverUnderDeliveryThe percentage by which the product receipt quantity is allowed to be less than the order quantity
VendAccount Extended Data Type: VendAccount
Type: String
NoneVendor account number.
VendGroup Extended Data Type: VendGroupId
Type: String
LedgerBasicVendor group
VersionDateTime Extended Data Type: VersioningTimeStamp
Type: UtcDateTime
NoneTimestamp of the document version.
Top

Field GroupFields
AutoReport
LinesChangedConfirmationReport
Posting_RU
Top

RelationTableLines
ActivityNumbersmmActivities
AssetBookIdAssetBookTable
AssetGroupAssetGroup
AssetIdAssetTable
BarCodeInventItemBarcode
BarCodeTypeBarcodeSetup
CurrencyCodeCurrency
dataAreaIdDataArea
InventDimIdInventDim
ItemBOMIdBOMTable
ItemIdInventTable
itemPBAIdPBATable
ItemRouteIdRouteTable
PartitionPartitions
PortIntrastatPort
PostingProfile_RUVendLedger
ProjCategoryIdProjCategory
ProjIdProjTable
ProjLinePropertyIdProjLineProperty
ProjSalesCurrencyIdCurrency
ProjTaxGroupIdTaxGroupHeading
ProjTaxItemGroupIdTaxItemGroupHeading
ProjTransIdProjItemTrans
PurchIdPurchTable
ReqPlanIdSchedReqPlanSched
ReturnActionIdReturnActionDefaults
ReturnDispositionCodeIdReturnDispositionCode
StatProcIdIntrastatStatProc
Tax1099StateLogisticsAddressState
TaxGroupTaxGroupHeading
TaxItemGroupTaxItemGroupHeading
TaxWithholdGroup_THTaxWithholdGroupHeading
TransactionCodeIntrastatTransactionCode
TransportIntrastatTransportMode
VendAccountVendTable
VendGroupVendGroup
Top

xRecord Class
  Common Table
    PurchLineAllVersions View

Community Additions

ADD
Show: