Hi, I don’t have Axapta in house and I’m wondering where may I consult about tables and their corresponding fields by internet. At this moment I need to know about fields of BankChequeTable. Thanks Ruth
Hi Ruth, I am not sure whether there are any online resources for this. If at all you want to know about table structures, best place might be to post a request in discussion boards like Mbsonline. BTW I’m just curious - do you use Axapta at all? Is there any particular reason you want to know about this particular table structure? Cheers, Harish Mohanbabu
TABLE #BankChequeTable PROPERTIES Name #BankChequeTable Label #@SYS24207 FormRef #BankChequeTable TitleField1 #ChequeNum TitleField2 #ChequeStatus Temporary #No TableContents #Not specified Systemtable #No FeatureKey # ConfigurationKey #BankCheque SecurityKey #BankTables MaxAccessMode #Add CacheLookup #NotInTTS CreateRecIdIndex #No SaveDataPerCompany #Yes TableGroup #Main PrimaryIndex #AccountChequeIdx ClusterIndex #AccountChequeIdx ModifiedDate #Yes ModifiedTime #No ModifiedBy #Yes ModifiedTransactionId #No CreatedDate #Yes CreatedTime #No CreatedBy #Yes CreatedTransactionId #No ENDPROPERTIES FIELDS FIELD #ChequeNum STRING PROPERTIES Type #String Name #ChequeNum Label # HelpText # GroupPrompt # SaveContents #Yes Mandatory #Yes AllowEditOnCreate #Yes AllowEdit #No Visible #Yes FeatureKey # ConfigurationKey # Table #BankChequeTable AliasFor # ExtendedDataType ARRAY #BankChequeNum # ENDARRAY StringSize #30 Adjustment #Right ENDPROPERTIES FIELD #ChequeStatus ENUM PROPERTIES Type #Enum Name #ChequeStatus Label #@SYS25532 HelpText #@SYS25472 GroupPrompt # SaveContents #Yes Mandatory #No AllowEditOnCreate #Yes AllowEdit #Yes Visible #Yes FeatureKey # ConfigurationKey # Table #BankChequeTable AliasFor # ExtendedDataType ARRAY # # ENDARRAY EnumType #ChequeStatus ENDPROPERTIES FIELD #AccountID STRING PROPERTIES Type #String Name #AccountID Label # HelpText #@SYS22506 GroupPrompt # SaveContents #Yes Mandatory #Yes AllowEditOnCreate #Yes AllowEdit #Yes Visible #Yes FeatureKey # ConfigurationKey # Table #BankChequeTable AliasFor # ExtendedDataType ARRAY #CompanyBankAccountId # ENDARRAY StringSize #10 Adjustment #Left ENDPROPERTIES FIELD #AmountCur REAL PROPERTIES Type #Real Name #AmountCur Label #@SYS6928 HelpText #@SYS28237 GroupPrompt # SaveContents #Yes Mandatory #No AllowEditOnCreate #Yes AllowEdit #Yes Visible #Yes FeatureKey # ConfigurationKey # Table #BankChequeTable AliasFor # ExtendedDataType ARRAY #AmountCur # ENDARRAY FieldUpdate #Absolute ENDPROPERTIES FIELD #CurrencyCode STRING PROPERTIES Type #String Name #CurrencyCode Label # HelpText # GroupPrompt # SaveContents #Yes Mandatory #No AllowEditOnCreate #Yes AllowEdit #Yes Visible #Yes FeatureKey # ConfigurationKey # Table #BankChequeTable AliasFor # ExtendedDataType ARRAY #CurrencyCode # ENDARRAY StringSize #3 Adjustment #Left ENDPROPERTIES FIELD #RecipientAccountNum STRING PROPERTIES Type #String Name #RecipientAccountNum Label #@SYS4466 HelpText #@SYS28361 GroupPrompt # SaveContents #Yes Mandatory #No AllowEditOnCreate #Yes AllowEdit #Yes Visible #Yes FeatureKey # ConfigurationKey # Table #BankChequeTable AliasFor # ExtendedDataType ARRAY #VendAccount # ENDARRAY StringSize #10 Adjustment #Right ENDPROPERTIES FIELD #TransDate DATE PROPERTIES Type #Date Name #TransDate Label # HelpText # GroupPrompt # SaveContents #Yes Mandatory #No AllowEditOnCreate #Yes AllowEdit #No Visible #Yes FeatureKey # ConfigurationKey # Table #BankChequeTable AliasFor # ExtendedDataType ARRAY #TransDate # ENDARRAY ENDPROPERTIES FIELD #Voucher STRING PROPERTIES Type #String Name #Voucher Label # HelpText # GroupPrompt # SaveContents #Yes Mandatory #No AllowEditOnCreate #Yes AllowEdit #No Visible #Yes FeatureKey # ConfigurationKey # Table #BankChequeTable AliasFor # ExtendedDataType ARRAY #Voucher # ENDARRAY StringSize #20 Adjustment #Right ENDPROPERTIES ENDFIELDS