CustTable Table
The CustTable table contains a list of customers for the accounts receivable and customer relationship management.
Configuration Key: LedgerBasic
Methods
Method | Description | |
---|---|---|
address | ||
addressComplement_BR | Gets the building name of the customer. | |
amountChargedNotPosted | Gets the sum of the amountToAccount field for the current customer account. | |
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.) | |
axCustTable | ||
balanceAllCurrency | ||
balanceCurPerDate | ||
balanceCurrency | ||
balanceMST | ||
balancePerDate | ||
bankAccountNum | ||
buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) | |
cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) | |
canDisplayCreditLimit | Determines whether the credit limit can be displayed. | |
canSubmitToWorkflow | Indicates whether submission to workflow is possible. (Inherited from xRecord.) | |
caption | Gets and sets the caption property of a table. (Inherited from xRecord.) | |
cashDiscName | ||
checkAccountBlocked | ||
checkBlockedAll | ||
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.) | |
checkRelatedAgreement_RU | Validates if intercompany agreement exists. | |
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) | |
checkVATNumUsed | ||
cityName_BR | Gets the city name based on the customer primary postal address | |
clear | Removes all rows from the table buffer. (Inherited from xRecord.) | |
clearingLedgerDimension | ||
clearingLedgerDimensionGroup | ||
clearingPeriod | ||
company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) | |
companyCountryRegionISOCode | Retrieves the LogisticsAddressCountryRegionISOCode code associated with the current record. | |
companyInfo | Retrieves the CompanyInfo record associated with the current record. | |
con2buf | Unpacks a container into the table buffers. (Inherited from xRecord.) | |
concurrencyModel | Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.) | |
context | Gets and sets the context property. (Inherited from xRecord.) | |
convertCurrencyCode | ||
copyDimension | Retrieves a dimension set that can be applied to the defaultDimension field on this table. | |
countryName | ||
countryRegionId | Retrieves the LogisticsAddressCountryRegionId code associated with the current record. | |
countyName | ||
creditMaxCur | ||
currencyName | ||
custCNPJ_BR | ||
customerGroup | ||
data | Retrieves a row from the table. (Inherited from xRecord.) | |
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) | |
defaultField | Populates default values in a field in the table. (Inherited from xRecord.) | |
defaultRow | Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.) | |
delete | Deletes the current record from the database. | |
diffCurrencyCodes | ||
diffCurrencyCodesOnOpen | ||
DirPartyTable_FK | Looks up the related DirPartyTable table. | |
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) | |
dispose | Releases resources that are used by the xRecord object. (Inherited from xRecord.) | |
districtName_BR | Gets the district name based on the customer primary postal address | |
doClear | Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.) | |
doDelete | Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.) | |
doInsert | Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.) | |
doUpdate | Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.) | |
doValidateDelete | Performs the action to validate that a record can be deleted. (Inherited from xRecord.) | |
editContactPersonName | ||
endDiscName | ||
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) | |
exceedMax | ||
existOpenOrders | ||
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.) | |
firstOpenPayment | ||
firstSettledPayment | ||
freeValueCur | ||
freeValueMST | ||
getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) | |
getCurrenciesForAllTrans | Gets the list of currencies for the transactions in the specified date range. | |
getCurrenciesForOpenTrans | Gets the list of currencies for the open transactions in the specified date range. | |
getCurrenciesForTrans | Gets the list of currencies for the transactions in the specified date range. | |
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.) | |
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.) | |
getSettleDate | ||
getSQLStatement | Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.) | |
getStructDepartment_RU | Implementation of \Data Dictionary\Maps\CustVendTable\Methods\getStructDepartment_RU | |
getTableInInstanceHierarchy | (Inherited from xRecord.) | |
getTableType | Indicates the type of the table. (Inherited from xRecord.) | |
getTaxInformationCustTable_IN | get TaxInformation of customer. | |
getTaxWithholdGroup | Gets the withholding tax group of current customer. | |
getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) | |
graphicsByAgeAllocate | ||
handle | Retrieves the handle of the class of the object. (Inherited from Object.) | |
hasForecastSales | ||
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.) | |
initFromCustGroup | ||
initValue | Initializes field values in a new CustTable record. | |
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) | |
insert | ||
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) | |
interCompanyTradingPartner | Finds the specified record in the InterCompanyTradingPartner table base on the current customer. | |
interCompanyTradingPartnerAccount | Finds the account ID for the corresponding vendor for the current customer intercompany trading relation. | |
interCompanyTradingPartnerCompanyID | Finds the company ID for the corresponding vendor for the current customer intercompany trading relation. | |
interCompanyTradingRelationActive | Checks whether the current customer is in an active intercompany trading relation. | |
invoiceAccountName | ||
invoiceAddress | ||
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.) | |
isForeign | Indicates whether a Customer is a Foreign. | |
isFormDataSource | Indicates whether the data source is a form. (Inherited from xRecord.) | |
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) | |
isPartOfUOWSaveChanges | (Inherited from xRecord.) | |
isPreferential | Indicates whether a Customer is a Preferential. | |
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.) | |
languageId | ||
lastCollectionLetterJour | ||
lastInterestJournal | ||
lastInvoice | ||
lastInvoiceDate | ||
lastPayment | ||
lastPaymentDate | ||
lastProjInvoice | ||
lastProjInvoiceDate | ||
lineDiscName | ||
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) | |
mcrCustTable | Recovers the retail customer record. | |
mcrDefaultDeliveryPostalAddress | Retrievest the postal address for the current CustTable record. | |
mcrDisplayIsMerged | Displays if the customer was merged. | |
mcrIsMerged | Makes a small x image if the customer is merged. | |
mcrPackMCRCustTable | Packs the MCRCustTable record into the extension field on the corresponding CustTable record. | |
merge | Merges the current table with the specified table. (Inherited from xRecord.) | |
mergeDimension | Retrieves a dimension set that holds the merged combination of the current defaultDimensionfield on this table and the specified dimension set. | |
modifiedField | ||
modifiedFieldValue | Modifies the specified field to the original value. (Inherited from xRecord.) | |
multiLineDiscName | ||
name | ||
nameAlias | ||
new | Initializes a new instance of the Object class. (Inherited from Object.) | |
notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) | |
notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) | |
objectOnServer | Determines whether the object is on a server. (Inherited from Object.) | |
openBalanceCur | ||
openBalanceMST | ||
openBalanceMSTDoc | ||
openBalanceMSTDue | ||
openBalanceMSTPerAgreement_RU | Calculate open customer balance with regards to contract (agreement) | |
openInvoiceBalanceMST | ||
openinvoiceBalanceMSTDoc | ||
openInvoiceBalanceMSTDue | ||
openPaymentBalanceMST | ||
openPaymentBalanceMSTDoc | ||
openPaymentBalanceMSTDue | ||
orig | Retrieves the original values of the current record. (Inherited from xRecord.) | |
overwriteSystemfields | Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.) | |
owner | Returns the instance that owns the object. (Inherited from Object.) | |
partyINNasOfDate_RU | Accessor method to party attributes with respect to date effectivity. | |
partyKPPasOfDate_RU | Accessor method to party attributes with respect to date effectivity. | |
partyOKATOasOfDate_RU | Accessor method to party attributes with respect to date effectivity. | |
partyOKDPasOfDate_RU | Accessor method to party attributes with respect to date effectivity. | |
partyOKPOasOfDate_RU | Accessor method to party attributes with respect to date effectivity. | |
partyType | ||
paymentType | Gets the payment type of the current record in the CustPaymModeTable table. | |
paymName | ||
phone | ||
phoneLocal | ||
postalAddress | ||
postalAddressRecId | Retrieves the record ID of the primary postal address for the current CustTable record. | |
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.) | |
previewPaneTitle | Retrieves the title field that is on top of the preview pane. | |
priceDiscGroupName | ||
projectListName | ||
promptCust | ||
queryTimedOut | Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.) | |
queryTimeout | Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.) | |
readCommittedLock | (Inherited from xRecord.) | |
readPast | Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.) | |
recordLevelSecurity | Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.) | |
relatedTable | Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.) | |
remainAmountCurPeriod | ||
renamePrimaryKey | ||
reread | Rereads the record from the table. (Inherited from xRecord.) | |
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) | |
selectForUpdate | Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.) | |
selectLocked | Indicates whether to select locked records. (Inherited from xRecord.) | |
selectRefRecord | Selects the record by referenced field ID. (Inherited from xRecord.) | |
selectWithRepeatableRead | Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.) | |
setConnection | Sets the user connection for this table. (Inherited from xRecord.) | |
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) | |
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) | |
setInventProfileId_RU | Update Inventory profile based on Inventory profile type | |
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) | |
setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) | |
settlementBuffer | ||
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.) | |
shouldEstimateBeCalculated | Determines whether the estimate value should be calculated for the order. | |
showPartyMatchIcon | ||
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.) | |
statementAddress | Find address used for statement. | |
stateName | ||
streetName_BR | Gets the street name based on the customer primary postal address | |
streetNumber_BR | Gets the StreetNumber of the customer. | |
subscriptionType_BR | Gets national company/person number | |
summaryLedgerDimension | ||
suppressWarnings | Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.) | |
tableAccessRight | Returns the table access right. (Inherited from xRecord.) | |
tableBufferAccessRight | Returns the table access right for the current record. (Inherited from xRecord.) | |
takeOwnershipOfTempDBTable | (Inherited from xRecord.) | |
taxGroupName | ||
telefax | ||
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.) | |
transBuffer | ||
transOpenBuffer | ||
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 | ||
url | ||
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) | |
useExistingTempDBTable | (Inherited from xRecord.) | |
validateBlocked | Verifies that the selected value for Blocked is valid for a record in CustTable. | |
validateDelete | Determines whether the current record is valid and ready to be deleted from the database. | |
validateField | Determines whether the p1 field is valid. | |
validateFieldValue | (Inherited from xRecord.) | |
validateIdentificationForCreditLimit | Validates whether the identification number for the CreditLimit value is required. | |
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.) | |
vendorAccountName | ||
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.) | |
zipCode_BR | Gets the zipcode based on the customer primary postal address | |
::blocked | ||
::canCustomerBeUpdated | ||
::checkCreditLimit | ||
::checkEInvoiceEAN | ||
::checkExist | Indicates whether the specified record exists in the CustTable table and displays a message if the record does not exist. | |
::checkExistAndOpen | ||
::confirmAndSaveCustGroupChange | Shows a confirmation dialog box if the CustGroup field value is modified and reverts to previous value if user selects cancel. | |
::createOneTimeAccount | Creates a one-time customer | |
::createOneTimeAccountValidate | ||
::creditMax | ||
::deleteOneTimeAccount | ||
::exist | ||
::existDlvMode | Checks whether the delivery mode is used on a customer record. | |
::existTransactions | Checks whether the transactions exist for the specified customer account. | |
::find | ||
::findByCompany | Finds the specified record in the CustTable table. | |
::findByDataAreaId | Finds the specified record in the CustTable table. | |
::findByKanaName_JP | Finds custTable record according to the kana name. | |
::findByLedgerDimension | ||
::findByPartyRecId | ||
::findByRef | Finds the specified record in the CustTable table. | |
::findByVendor | Finds the specified record in the CustTable table. | |
::findInvoiceAddressAccountFromParty | Finds the customer invoice account entry for a given party. | |
::findRecId | ||
::getNumberSeqFormHandler | Retrieves the numbersequenceformhandler that can be used in the form creation of this entity to generate the numbersequence related field | |
::groupId | ||
::inventSiteIdCustItem | Looks up site ID for an item depending on the customer if multisite is enabled. | |
::isCustDKPublic | Determines whether sending invoice electronically is applicable for specified customer or not. | |
::jumpRefCustomer | ||
::lookupCustomer | ||
::mcrLookupTradePromoCustomers | Looks up trade promotion customers for the passed form control object. | |
::mcrMergeCustomers | Merges the passed customers together. | |
::projPriceGroup | ||
::promptAddress | ||
::promptConvertCurrencyCode | ||
::quickCreateSaveAndOpenLinks | ||
::retreiveQuickCreateSettings | Retrieves the needed metadata for the quick create form | |
::txtNotExist | Gets the message to use when a specific record in the CustTable table does not exist. |
Top
Fields
Field | Type | Configuration key | Description |
---|---|---|---|
AccountNum | Extended Data Type: CustAccount Type: String |
None | Customer account number. |
AccountStatement | Enumeration: CustAccountStatement |
LedgerBasic | View how often an account statement should be sent to the customer |
Affiliated_RU | Extended Data Type: CustAffiliated_RU Type: Enum |
RAsset | The customer is affiliated with the company that pays the taxes (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
AgencyLocationCode | Extended Data Type: AgencyLocationCode Type: String |
PublicSector | Enter an agency location code for this customer. This number must be 11 to 12 digits long. (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)) |
BankAccount | Extended Data Type: CustBankAccountId Type: String |
Bank | The customer bank account type |
BankCentralBankPurposeCode | Extended Data Type: BankCentralBankPurposeCode Type: String |
LedgerBasic | The central bank purpose code for the selected customer record |
BankCentralBankPurposeText | Extended Data Type: BankCentralBankPurposeText Type: String |
LedgerBasic | The information about the central bank purpose code |
BankCustPaymIdTable | Extended Data Type: BankCustPaymIdRecId Type: Int64 |
None | The customer's payment identification type |
BirthCountyCode_IT | Extended Data Type: AddressCountyCode_IT Type: String |
None | Specify the Italian county province. |
BirthDate_IT | Extended Data Type: BirthDate Type: Date |
None | Enter the birth date of the customer. |
BirthPlace_IT | Extended Data Type: AddressCity Type: String |
LedgerBasic | Enter the birth place of the customer |
Blocked | Extended Data Type: CustBlocked Type: Enum |
LedgerBasic | View whether invoicing or deliveries have been placed on hold for the selected record |
CashDisc | Extended Data Type: CustCashDiscCode Type: String |
LedgerBasic | The cash discount applicable for the customer |
CashDiscBaseDays | Extended Data Type: CashDiscBaseDays Type: Integer |
LedgerBasic | The number of days that will be added to the document date when calculating discounts and due dates (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
CCMNum_BR | Extended Data Type: CCMNum_BR Type: String |
None | Customer's registration number for the city. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ClearingPeriod | Extended Data Type: CustClearingPeriod Type: String |
LedgerBasic | Terms of payment for period from due date to payment. |
CNAE_BR | Extended Data Type: CNAE_BR Type: String |
None | National classification of company economic activity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CNPJCPFNum_BR | Extended Data Type: CNPJCPFNum_BR Type: String |
None | Tax registration number of the company/person. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CommercialRegister | Extended Data Type: CommercialRegister Type: String |
None | Enter the name of the commercial register (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CommercialRegisterInsetNumber | Extended Data Type: CommercialRegisterInsetNumber Type: String |
None | Enter the inset number in the commercial register (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CommercialRegisterSection | Extended Data Type: CommercialRegisterSection Type: String |
None | Enter the section of the commercial register (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CommissionGroup | Extended Data Type: CommissCustomerGroup Type: String |
Commission | The sales commission group for the customer |
CompanyChainId | Extended Data Type: smmChainId Type: String |
SmmCRM | The company chain that the customer is |
CompanyIdSiret | Extended Data Type: CompanyIdSiret Type: String |
None | Siret number of the company. |
CompanyNAFCode | Extended Data Type: CompanyNAFRecId Type: Int64 |
None | NAF code of the company. |
CompanyType_MX | Enumeration: CompanyType_MX |
None | Type of company |
ConsDay_JP | Extended Data Type: CustConsDay_JP Type: Integer |
LedgerBasic | Enter the consolidation day to consolidate sales orders for a customer. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ContactPersonId | Extended Data Type: ContactPersonId Type: String |
None | The primary contact for the customer |
createdDateTime | Extended Data Type: CreatedDateTime Type: UtcDateTime |
None | |
CreditCardAddressVerification | Enumeration: CreditCardAddressVerification |
CreditCard | Select yes to verify the credit card address or use blank to use the setting in the Payment services setup form |
CreditCardAddressVerificationLevel | Enumeration: CreditCardAddressVerificationLevel |
CreditCard | Transactions are voided if the payment service does not return the selected status or higher |
CreditCardAddressVerificationVoid | Extended Data Type: CreditCardAddressVerificationVoid Type: Enum |
CreditCard | If selected, the transaction is voided when no address verification results are available |
CreditCardCVC | Enumeration: CreditCardCVC |
CreditCard | Select Yes to display a prompt when a credit card transaction is entered or blank to use the default setting |
CreditMax | Extended Data Type: CustCreditMaxMST Type: Real |
LedgerBasic | The customer's credit limit |
CreditRating | Extended Data Type: CustCreditRating Type: String |
LedgerBasic | The customer's credit rating |
Curp_MX | Extended Data Type: Curp_MX Type: String |
None | CURP - Federal Tax Number. |
Currency | Extended Data Type: CustCurrencyCode Type: String |
None | The customer's company currency for invoicing |
CustClassificationId | Extended Data Type: CustClassificationId Type: String |
None | Specify customer classification groups. |
CustExcludeCollectionFee | Extended Data Type: CustExcludeCollectionFee Type: Enum |
Collections | If selected, collection fees will not be calculated for this customer |
CustExcludeInterestCharges | Extended Data Type: CustExcludeInterestCharges Type: Enum |
Collections | If selected, interest charges will not be calculated for this customer |
CustFinalUser_BR | Extended Data Type: CustVendFinalUser_BR Type: Enum |
None | Is the customer the final user? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CustGroup | Extended Data Type: CustGroupId Type: String |
LedgerBasic | Customer group that the customer is attached to. |
CustItemGroupId | Extended Data Type: CustItemGroupId Type: String |
LogisticsBasic | Customer group for external item descriptions |
CustTradingPartnerCode | Extended Data Type: TradingPartnerCodeRecId Type: Int64 |
PublicSector | Assign a trading partner code to this customer for federal GFRS and FACTS I reporting (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)) |
CustWhtContributionType_BR | Extended Data Type: WhtContributionType_BR Type: Enum |
None | Withholding tax customer type (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
dataAreaId | Extended Data Type: DataAreaId Type: String |
None | |
DAXIntegrationId | Extended Data Type: ConnIntegrationKey Type: Guid |
None | The integration key for Dynamics Connector (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DefaultDimension | Extended Data Type: DimensionDefault Type: Int64 |
LedgerBasic | Default dimensions |
DefaultDirectDebitMandate | Extended Data Type: CustDirectDebitMandateRecId Type: Int64 |
None | Select the direct debit mandate reference of the recipient (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DefaultInventStatusId | Extended Data Type: WHSDefaultStatusId Type: String |
WHSandTMS | The default inventory status ID on inventory transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
dEL_CreatedTime | Extended Data Type: DEL_CreatedTime Type: Integer |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
dEL_ModifiedTime | Extended Data Type: DEL_ModifiedTime Type: Integer |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DestinationCodeId | Extended Data Type: CustDestinationCodeId Type: String |
None | The customer's destination code |
DlvMode | Extended Data Type: CustDlvModeId Type: String |
None | The customer's preferred mode of delivery |
DlvReason | Extended Data Type: DlvReasonId Type: String |
None | Unique identification of delivery reasons |
DlvTerm | Extended Data Type: CustDlvTermId Type: String |
None | The delivery terms for the customer |
EInvoice | Extended Data Type: NoYesId Type: Enum |
None | Enables customer for electronic invoicing |
EinvoiceEANNum | Extended Data Type: EinvoiceEANNum Type: String |
None | The customer's European Article Number (EAN) |
EndDisc | Extended Data Type: CustEndDiscCode Type: String |
PriceDisc | The total discount group that the customer is assigned to |
EnterpriseCode | Extended Data Type: EnterpriseCode Type: String |
None | Enter the enterprise code of the customer’s company (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
EnterpriseNumber | Extended Data Type: TaxEnterpriseNumber Type: String |
None | Enterprise number used to identify Belgian companies. |
EntryCertificateRequired_W | Extended Data Type: EntryCertificateRequired_W Type: Enum |
None | Select this check box to indicate that an entry certificate that is issued by you or a third party is required for the customer invoice (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ExportSales_PL | Extended Data Type: PlExportSales Type: Enum |
LedgerBasicSalesTax | Is it an export sale? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ExpressBillOfLading | Extended Data Type: TMSExpressBillofLading Type: Enum |
WHSandTMS | Customer accepts express bill of lading. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
FactoringAccount | Extended Data Type: BankCustFactoringAccount Type: String |
None | Customer account number. |
FederalComments | Extended Data Type: FederalComments Type: String |
PublicSector | Enter an optional comment about this customer (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)) |
FedNonFedIndicator | Enumeration: FederalNonFederalIndicatorCode |
PublicSector | Assign a federal/non-federal indicator to this customer for FACTS I and FACTS II reporting (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)) |
FineCode_BR | Extended Data Type: CustFineCode_BR Type: String |
None | Code that defines the fine rates and terms. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
FiscalCode | Extended Data Type: FiscalCode Type: String |
None | Enter fiscal code for the customer. |
FiscalDocType_PL | Enumeration: PlFiscalDocType |
None | Specifies whether an invoice or a bill is printed for the customer (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ForecastDMPInclude | Extended Data Type: ForecastDMPInclude Type: Enum |
None | A selected check box indicates that demand planning is appropriate for the customer |
ForeignResident_RU | Extended Data Type: ForeignResident_RU Type: Enum |
None | Foreign counteragent flag. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
FreightZone | Extended Data Type: CustFreightZoneId Type: String |
None | The UPS zone for the customer |
GenerateIncomingFiscalDocument_BR | Extended Data Type: GenerateIncomingFiscalDocument_BR Type: Enum |
None | Generate and print an entrance fiscal document at customer invoice posting (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
GiroType | Extended Data Type: PaymentStubInvoiceId Type: Enum |
CustGiro | The type of transfer slip to print on a customer invoice |
GiroTypeAccountStatement | Extended Data Type: PaymentStubAccountStatementId Type: Enum |
CustGiro | Print associated payment attachment for the account statement? |
GiroTypeCollectionletter | Extended Data Type: PaymentStubCollectionId Type: Enum |
CustGiro | The type of transfer slip to print on a collection letter |
GiroTypeFreeTextInvoice | Extended Data Type: PaymentStubInvoiceId Type: Enum |
CustGiro | The type of transfer slip to print on a free text invoice |
GiroTypeInterestNote | Extended Data Type: PaymentStubInterestId Type: Enum |
CustGiro | The type of transfer slip to print on an interest note |
GiroTypeProjInvoice | Extended Data Type: PaymentStubProjId Type: Enum |
CustGiro | The type of transfer slip to print on a project invoice |
ICMSContributor_BR | Extended Data Type: ICMSContributor_BR Type: Enum |
None | Is the customer an ICMS contributor? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
IdentificationNumber | Extended Data Type: CustIdentificationNumber Type: String |
None | An identifying number. For a person, the number is a driver's license number or another government-issued ID number. For an organization, the number is an employer identification number or another unique ID number. |
IENum_BR | Extended Data Type: IENum_BR Type: String |
None | Customer's registration number for the state. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InclTax | Extended Data Type: InclTax Type: Enum |
LogisticsBasic | A selected check box indicates that prices include sales tax |
INSSCEI_BR | Extended Data Type: INSSCEI_BR Type: String |
None | Brazilian Security Institute number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
IntBank_LV | Extended Data Type: CustBankAccountId Type: String |
Bank | Identification of customer's bank account. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InterCompanyAllowIndirectCreation | Extended Data Type: InterCompanyAllowIndirectCreation Type: Enum |
TradeInterCompany | A selected check box indicates that indirect order lines should be created when the sales order is a direct delivery |
InterCompanyAutoCreateOrders | Extended Data Type: InterCompanyAutoCreateOrders Type: Enum |
TradeInterCompany | A selected check box indicates that a purchase order is created when a sales order is created |
InterCompanyDirectDelivery | Extended Data Type: InterCompanyDirectDelivery Type: Enum |
TradeInterCompany | A selected check box indicates synchronization of intercompany orders and direct delivery to the customer |
InterestCode_BR | Extended Data Type: CustInterestCode_BR Type: String |
None | Code that defines the interest rates and terms. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InventLocation | Extended Data Type: InventLocationId Type: String |
LogisticsBasic | The warehouse to be included on a sales order |
InventProfileId_RU | Extended Data Type: InventProfileId_RU Type: String |
InventTrackingGTDProfileOwner | Inventory profile. (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)) |
InventSiteId | Extended Data Type: InventSiteId Type: String |
LogisticsBasic | The site to be included on a sales order |
InvoiceAccount | Extended Data Type: CustInvoiceAccount Type: String |
None | The alternate customer account selected to receive invoices for the customer |
InvoiceAddress | Extended Data Type: CustInvoiceAddress Type: Enum |
LedgerBasic | The account that contains the address assigned to receive posted invoices |
InvoicePostingType_RU | Enumeration: SalesInvoicePostingType_RU |
LedgerBasic | Default customer invoice posting type. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
IRS1099CIndicator | Extended Data Type: CustIRS1099CIndicator Type: Enum |
PublicSector | Assign a 1099-C indicator to this customer (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)) |
IsResident_LV | Extended Data Type: LvResident Type: Enum |
None | Is the company a resident? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
IssueOwnEntryCertificate_W | Extended Data Type: IssueOwnEntryCertificate_W Type: Enum |
None | Select this check box to issue an entry certificate for the customer invoice (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
IssuerCountry_HU | Extended Data Type: AddressCountryRegionId Type: String |
None | Customer passport's issuer country/region. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
LineDisc | Extended Data Type: CustLineDiscCode Type: String |
PriceDisc | The line discount group that the customer is assigned to |
LineOfBusinessId | Extended Data Type: CustLineOfBusinessId Type: String |
LedgerBasic | The line of business of the customer's company or organization |
LvPaymTransCodes | Extended Data Type: PaymTransCodeRecId Type: Int64 |
None | Default payment transaction code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
MainContactWorker | Extended Data Type: smmBusRelAccResponsibleWorker Type: Int64 |
SmmCRM | The employee responsible for the customer |
MandatoryCreditLimit | Extended Data Type: MandatoryCreditLimit Type: Enum |
LedgerBasic | A selected check box indicates that there is a mandatory credit limit for the customer record |
MandatoryVatDate_PL | Extended Data Type: PlMandatoryVatDate Type: Enum |
LedgerBasicVatDueDate_W | Select the check box if the VAT date is required. Or, you can enter the VAT date in the Posted sales tax form. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
MarkupGroup | Extended Data Type: CustMarkupGroupId Type: String |
Markup | The charges group that the customer is assigned to |
MCRMergedParent | Extended Data Type: CustAccount Type: String |
None | The immediate account of which this customer is merged. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRMergedRoot | Extended Data Type: CustAccount Type: String |
None | The top-level account of which this customer is merged. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Memo | Extended Data Type: smmBusRelMemo Type: VarString |
SmmCRM | More information about the customer |
modifiedBy | Extended Data Type: ModifiedBy Type: String |
None | |
modifiedDateTime | Extended Data Type: ModifiedDateTime Type: UtcDateTime |
None | |
MultiLineDisc | Extended Data Type: CustMultiLineDiscCode Type: String |
PriceDisc | The multiline discount group that the customer is assigned to |
NIT_BR | Extended Data Type: NIT_BR Type: String |
None | Worker identification number (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 | The number sequence group for the selected customer |
OneTimeCustomer | Extended Data Type: OneTimeCustomer Type: Enum |
LedgerBasic | A selected check box indicates that this is a one-time customer |
OrderEntryDeadlineGroupId | Extended Data Type: InventOrderEntryDeadlineGroupId Type: String |
LogisticsBasic | The order entry deadline group for the customer |
OrgId | Extended Data Type: OrgId Type: String |
None | The ID number used by the Icelandic government to identify individuals and organizations |
OurAccountNum | Extended Data Type: CustAccountExt Type: String |
LedgerBasic | Our account number with customer. |
PackageDepositExcempt_PL | Extended Data Type: PlPackageDepositExcempt Type: Enum |
None | Is the client exempt from deposit fee? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
PackMaterialFeeLicenseNum | Extended Data Type: InventPackingMaterialFeeLicenseNum Type: String |
InventPackaging | The number assigned to the customer by the appropriate recycling company |
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)) |
Party | Extended Data Type: DirPartyRecId Type: Int64 |
None | Reference field in a different table |
PartyCountry | Extended Data Type: AddressCountryRegionId Type: String |
None | The country/region where the customer is located |
PartyState | Extended Data Type: AddressStateId Type: String |
None | The state where the customer is located |
PassportNo_HU | Extended Data Type: PassportNo_HU Type: String |
None | Specify passport number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
PaymDayId | Extended Data Type: CustPaymDayId Type: String |
LedgerBasic | The day of payment for the customer |
PaymentReference_EE | Extended Data Type: CustPaymReference_EE Type: String |
LedgerBasic | Reference to a specific payment. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
PaymIdType | Extended Data Type: BankCustPaymIdType Type: String |
None | Payment ID type to define the content of the payment ID |
PaymMode | Extended Data Type: CustPaymMode Type: String |
LedgerBasic | The method of payment for the customer |
PaymSched | Extended Data Type: PaymSchedId Type: String |
PaymSched | The payment schedule for the customer |
PaymSpec | Extended Data Type: PaymSpec Type: String |
None | The payment specification for the customer |
PaymTermId | Extended Data Type: CustPaymTermId Type: String |
LedgerBasic | The terms of payment for the customer |
PBACustGroupId | Extended Data Type: PBACustGroupId Type: String |
PBA_ProductBuilder | The product model group for the customer |
PdsCustRebateGroupId | Extended Data Type: PdsCustRebateGroupId Type: String |
PdsRebate | Group of customer for which a rebate is applicable. (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)) |
PdsFreightAccrued | Extended Data Type: PdsFreightAccrued Type: Enum |
PdsRebate | Set if the customer can used freight rebate programs. (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)) |
PdsRebateTMAGroup | Extended Data Type: PdsRebateProgramTMAGroup Type: String |
PdsRebate | Customer TMA group ID. (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)) |
PriceGroup | Extended Data Type: CustPriceGroup Type: String |
PriceDisc | The price group that the customer is assigned to |
RecId | Extended Data Type: RecId Type: Int64 |
None | |
recVersion | Extended Data Type: RecVersion Type: Integer |
None | |
RegNum_W | Extended Data Type: CompanyRegNum Type: String |
None | Company registration number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ResidenceForeignCountryRegionId_IT | Extended Data Type: LogisticsAddressCountryRegionId Type: String |
None | Enter the country/region of residence for the customer. This is used in the Certification report. |
Rfc_MX | Extended Data Type: Rfc_MX Type: String |
None | RFC - Federal Tax Number. |
RFIDCaseTagging | Extended Data Type: RFIDCaseTagging Type: Enum |
RFIDTagging | A selected check box indicates that case tagging is required for the customer |
RFIDItemTagging | Extended Data Type: RFIDItemTagging Type: Enum |
RFIDTagging | A selected check box indicates that item tagging is required for the customer |
RFIDPalletTagging | Extended Data Type: RFIDPalletTagging Type: Enum |
RFIDTagging | A selected check box indicates that pallet tagging is required for the customer |
SalesCalendarId | Extended Data Type: SalesCalendarId Type: String |
SalesDeliveryDateControl | The calendar that matches the customer's receiving schedule |
SalesDistrictId | Extended Data Type: smmSalesDistrictId Type: String |
SmmCRM | The customer's sales district |
SalesGroup | Extended Data Type: CommissSalesGroup Type: String |
Commission | The sales group that the customer's sales representative is assigned to |
SalesPoolId | Extended Data Type: CustSalesPoolId Type: String |
LogisticsBasic | Specify the sales order pool sales orders from customers are to be placed in |
SegmentId | Extended Data Type: smmSegmentId Type: String |
SmmCRM | The customer segment |
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)) |
ShipCarrierAccount | Extended Data Type: ShipCarrierAccount Type: String |
ShipCarrier | Account number that is invoiced by the carrier |
ShipCarrierAccountCode | Extended Data Type: ShipCarrierAccountCode Type: String |
ShipCarrier | Account code to identify the carrier account number that will be used to bill the company |
ShipCarrierBlindShipment | Extended Data Type: ShipCarrierBlindShipment Type: Enum |
ShipCarrier | If selected, the return address and logo are not printed on the packing slip or invoice |
ShipCarrierFuelSurcharge | Extended Data Type: ShipCarrierFuelSurcharge Type: Enum |
ShipCarrier | A selected check box indicates that a fuel surcharge should be added to the shipping charges |
ShipCarrierId | Extended Data Type: ShipCarrierId Type: String |
ShipCarrier | Identification of the carrier service, assigned by the shipping carrier |
StateInscription_MX | Extended Data Type: StateInscription_MX Type: String |
None | State inscription number |
StatisticsGroup | Extended Data Type: CustStatGroupId Type: String |
LedgerBasic | The statistics group for the customer record |
SubsegmentId | Extended Data Type: smmSubsegmentId Type: String |
SmmCRM | The customer subsegment |
Suframa_BR | Extended Data Type: CustSuframa_BR Type: Enum |
None | Does the customer belong to the SUFRAMA region? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
SuframaNumber_BR | Extended Data Type: CustSuframaNumber_BR Type: String |
None | SUFRAMA number of the customer. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
SuframaPISCOFINS_BR | Enumeration: NoYes |
None | Do you want to discount PIS and COFINS taxes for the SUFRAMA customer? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
SuppItemGroupId | Extended Data Type: CustSuppItemGroupId Type: String |
SuppItem | The supplementary item group that the customer is assigned to |
SyncEntityId | Extended Data Type: SyncEntityId Type: Guid |
None | Unique identifier of an entity instance |
SyncVersion | Extended Data Type: SyncVersion Type: Int64 |
None | Version of an entity. This is a sequential number |
TaxBorderNumber_FI | Extended Data Type: TaxBorderNumber_FI Type: String |
None | Tax border number is required for customer invoices. |
TaxGroup | Extended Data Type: TaxGroup Type: String |
LedgerBasicSalesTax | The sales tax group to use for this customer when calculating tax for purchases and sales |
TaxLicenseNum | Extended Data Type: TaxPackagingLicenseNum Type: String |
LedgerBasicSalesTax | The customer's packing duty license number that is listed with the sales tax authority |
TaxPeriodPaymentCode_PL | Extended Data Type: PlTaxPeriodPaymentCode Type: String |
None | Enter a time period code for VAT transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TaxWithholdCalculate_IN | Extended Data Type: NoYesId Type: Enum |
None | Select this check box to calculate withholding tax for the customer. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TaxWithholdCalculate_TH | Extended Data Type: TaxWithholdCalculate_TH Type: Enum |
None | Shall withholding tax be calculated for vendor payment transactions in journals? |
TaxWithholdGroup_TH | Extended Data Type: TaxWithholdGroup Type: String |
LedgerBasicWithholdingTax | Identification of the withholding tax group. |
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)) |
UseCashDisc | Enumeration: UseCashDisc |
None | In which way is the cash discount to be used? (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)) |
usePurchRequest | Extended Data Type: RetailUsePurchRequest Type: Enum |
Retail | (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)) |
VATNum | Extended Data Type: VATNum Type: String |
LedgerBasicSalesTax | The customer's tax exempt number |
VendAccount | Extended Data Type: VendAccount Type: String |
None | The vendor account for the customer |
WebSalesOrderDisplay | Enumeration: ECPsalesOrdersViewType |
CSS | The history of the customer record |
Top
Field Groups
Field Group | Fields |
---|---|
Identification | |
GiroMoneyTransferSlip | |
InventProfile_RU | |
Gateway | |
GovernmentIdentification | |
InventoryStatus | |
LeadEditCustomerDetails | |
MCRCustMerge | |
MainContact | |
Memo | |
FiscalInformation_BR | |
GiroMoneyTransferSlipEP | |
Integration | |
Intercompany | |
Inventory | |
Invoice | |
ContactInfo | |
Delivery | |
Einvoice | |
EPCharacteristics | |
EPCharacteristics2 | |
Dimension | |
EPCreditInfo | |
Credit | |
EPContactInfoAddEdit | |
EPCustomer | |
EntryCertificate_W | |
CarrierInfo | |
CaseMoreInformation | |
ConsDay_JP | |
Classification | |
CompanyChain | |
ConnIntegration | |
CustomerSelfService | |
DeliveryTerms | |
DirectDebit | |
Currency | |
CreditCardProcessing | |
EPPayment2 | |
EPSetup3 | |
EPGeneral3 | |
EPDetailsOther | |
EPMiniPage | |
EPSetup2 | |
EPSetup1 | |
EPFrench | |
FederalAttributes | |
EPPayment1 | |
All | |
AutoSummary | |
Affiliated_RU | |
AutoLookup | |
AutoReport | |
Budget | |
SalesDiscount | |
RFIDTagging | |
SalesDistrict | |
SalesOrder | |
SalesOrderOther | |
ReturnablePackage_PL | |
quickCreateDetails | |
Posting | |
quickCreateHeader | |
Payment | |
PdsFreightAccrued | |
National_BR | |
NotificationToTheCentralBank | |
PackagingMaterialFee | |
SalesTaxEP | |
SalesReturn_BR | |
SalesTax | |
SalesTaxExchangeRate | |
Segment | |
SuframaRegion_BR | |
Services_BR | |
Subsegment | |
SupplementaryItem | |
TMS | |
TaxRegistration_MX | |
Vendor | |
WebCategoryBrowsing | |
WithholdingTax | |
WhtContribution_BR | |
WithholdingTax_IN | |
AdministrationEP | |
AddressLookup | |
Administration |
Top
Relations
Relation | Table | Lines |
---|---|---|
AccountNum | CustTable | |
BankAccounts | CustBankAccount | |
BankAccounts_LV | CustBankAccount | |
BankCentralBankPurpose | BankCentralBankPurpose | |
BankCustPaymIdTable | BankCustPaymIdTable | |
BirthCounty | LogisticsAddressCounty | |
CashDisc | CashDisc | |
CommissionCustomerGroup | CommissionCustomerGroup | |
CommissionSalesGroup | CommissionSalesGroup | |
CompanyNAFCode | CompanyNAFCode | |
ContactPerson | ContactPerson | |
Currency | Currency | |
CustClassificationGroup | CustClassificationGroup | |
CustDirectDebitMandate | CustDirectDebitMandate | |
CustFineSetup_BR | CustFineSetup_BR | |
CustGroup | CustGroup | |
CustInterestSetup_BR | CustInterestSetup_BR | |
CustPaymentModeSpec | CustPaymModeSpec | |
CustPaymModeTable | CustPaymModeTable | |
CustStatisticsGroup | CustStatisticsGroup | |
CustTable_FactoringAccount | CustTable | |
CustTable_InvoiceAccount | CustTable | |
CustTradingPartnerCode | CustTradingPartnerCode | |
CustVendItemGroup | CustVendItemGroup | |
dataAreaId | DataArea | |
DefaultDimension | DimensionAttributeValueSet | |
DestinationCode | DestinationCode | |
DirAddressBookParty | DirAddressBookPartyAllView | |
DirPartyTable_FK | DirPartyTable | |
DirPartyView | DirPartyView | |
DlvMode | DlvMode | |
DlvReason | DlvReason | |
DlvTerm | DlvTerm | |
InventLocation | InventLocation | |
InventOrderEntryDeadlineGroup | InventOrderEntryDeadlineGroup | |
InventProfile_RU | InventProfile_RU | |
InventSite | InventSite | |
LineOfBusiness | LineOfBusiness | |
LogisticsAddressCountryRegion | LogisticsAddressCountryRegion | |
LogisticsAddressCountryRegion_RFIT | LogisticsAddressCountryRegion | |
LvPaymTransCodes | LvPaymTransCodes | |
MainContactWorker | HcmWorker | |
MarkupGroup | MarkupGroup | |
NumberSequenceGroup | NumberSequenceGroup | |
Partition | Partitions | |
PartyState | LogisticsAddressState | |
PassportIssuerLogisticsAddressCountry_HU | LogisticsAddressCountryRegion | |
PaymDay | PaymDay | |
PaymSched | PaymSched | |
PaymTerm_ClearingPeriod | PaymTerm | |
PaymTerm_PaymTermId | PaymTerm | |
PBACustGroup | PBACustGroup | |
PdsCustRebateGroup | PdsCustRebateGroup | |
PdsRebateProgramTMATable | PdsRebateProgramTMATable | |
PlTaxDueTable | PlTaxDueTable | |
PriceDiscGroup_EndDisc | PriceDiscGroup | |
PriceDiscGroup_LineDisc | PriceDiscGroup | |
PriceDiscGroup_MultiLineDisc | PriceDiscGroup | |
PriceDiscGroup_PriceGroup | PriceDiscGroup | |
SalesPool | SalesPool | |
ShipCarrierTable | ShipCarrierTable | |
smmBusRelChainGroup | smmBusRelChainGroup | |
smmBusRelSalesDistrictGroup | smmBusRelSalesDistrictGroup | |
smmBusRelSegmentGroup | smmBusRelSegmentGroup | |
smmBusRelSubSegmentGroup | smmBusRelSubSegmentGroup | |
SuppItemGroup | SuppItemGroup | |
TaxGroupHeading | TaxGroupHeading | |
TaxWithholdGroupHeading | TaxWithholdGroupHeading | |
VatNum | TaxVATNumTable | |
VendTable | VendTable | |
WHSInventStatus | WHSInventStatus | |
WorkCalendarTable | WorkCalendarTable |
Top
Indexes
Index | AllowDuplicates | Enabled | Fields |
---|---|---|---|
AccountIdx | No | Yes | |
BankCustPaymIdTableIdx | Yes | Yes | |
CompanyNAFCodeIdx | Yes | Yes | |
CustGroupIdx | Yes | Yes | |
CustTradingPartnerCodeIdx | Yes | Yes | |
DEL_PartyIdx | Yes | Yes | |
DEL_PhoneIdx | Yes | Yes | |
HcmWorkerIdx | Yes | Yes | |
LogisticsAddressCountryRegionIdx | Yes | Yes | |
LvPaymTransCodesIdx | Yes | Yes | |
MCRMergeIdx | Yes | Yes | |
OurAccountNumIdx | Yes | Yes | |
Party | No | Yes | |
PaymRefIdx_EE | Yes | Yes | |
PlTaxDueTableIdx | Yes | Yes | |
RecId | No | Yes | |
VendAccount | Yes | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
CustTable Table