Referans (pencere ID-101)

pencere: Referans

tanım: Sistem Referansları Bakımı

Yardım: Referans Penceresi Alan/Biçim tiplerini ve doğrulamaları tanımlar. Bu pencere sadece Sistem Yöneticisi kullanımı içindir.

TAB: Reference

tanım: Reference header definitions

Yardım The Reference Tab defines the references that are used to validate data

Dosya:Referans - Reference - pencere (iDempiere 1.0.0).png

isim	isim	tanım	Yardım	Özellikler
Reference	Referans	System Reference and Validation	The Reference could be a display type, list or table validation.	AD_Reference_ID numeric(10) NOT NULL ID
Client	İstemci	Client/Tenant for this installation.	İstemci bir firma veya legal bir kurulustur. Verileri İstemciler arasında paylasilmaz. Mutasarruf ise İstemci ile aynı anlama gelmektedir.	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organizasyon	Organizational entity within client	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.	AD_Org_ID numeric(10) NOT NULL Table Direct
Name	İsim	Alphanumeric identifier of the entity	The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.	Name character varying(60) NOT NULL String
Description	Description	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
Comment/Help	Comment/Help	Comment or Hint	The Help field contains a hint, comment or help about the use of this item.	Help character varying(2000) Text
Active	Active	The record is active in the system	There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.	IsActive character(1) NOT NULL Yes-No
Entity Type	Entity Type	Dictionary Entity Type; Determines ownership and synchronization	The Entity Types "Dictionary", "Adempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"!	EntityType character varying(40) NOT NULL Table
Validation type	Validation type	Different method of validating data	The Validation Type indicates the validation method to use. These include list, table or data type validation.	ValidationType character(1) NOT NULL List
Value Format	Value Format	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"	Validation elements: (Space) any character _ Space (fixed character) l any Letter a..Z NO space L any Letter a..Z NO space converted to upper case o any Letter a..Z or space O any Letter a..Z or space converted to upper case a any Letters & Digits NO space A any Letters & Digits NO space converted to upper case c any Letters & Digits or space C any Letters & Digits or space converted to upper case 0 Digits 0..9 NO space 9 Digits 0..9 or space Example of format "(000)_000-0000"	VFormat character varying(40) String
Order By Value	Order By Value	Order list using the value column instead of the name column	Order list using the value column instead of the name column	IsOrderByValue character(1) Yes-No

TAB: Reference Translation

tanım: null

Yardım null

Dosya:Referans - Reference Translation - pencere (iDempiere 1.0.0).png

isim	isim	tanım	Yardım	Özellikler
Client	İstemci	Client/Tenant for this installation.	İstemci bir firma veya legal bir kurulustur. Verileri İstemciler arasında paylasilmaz. Mutasarruf ise İstemci ile aynı anlama gelmektedir.	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organizasyon	Organizational entity within client	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.	AD_Org_ID numeric(10) NOT NULL Table Direct
Reference	Referans	System Reference and Validation	The Reference could be a display type, list or table validation.	AD_Reference_ID numeric(10) NOT NULL Table Direct
Language	Lisan	Bu birim için Dil	Dilin nasıl kullanılacağını ve biçimlendirileceğini tanımlar	AD_Language character varying(6) NOT NULL Table
Active	Active	The record is active in the system	There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.	IsActive character(1) NOT NULL Yes-No
Translated	Translated	This column is translated	The Translated checkbox indicates if this column is translated.	IsTranslated character(1) Yes-No
Name	İsim	Alphanumeric identifier of the entity	The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.	Name character varying(60) NOT NULL String
Description	Description	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
Comment/Help	Comment/Help	Comment or Hint	The Help field contains a hint, comment or help about the use of this item.	Help character varying(2000) Text

TAB: List Validation

tanım: Reference List

Yardım The List Validation Tab defines lists to validate data

Dosya:Referans - List Validation - pencere (iDempiere 1.0.0).png

isim	isim	tanım	Yardım	Özellikler
Reference List	Referans Liste	Tablodan alınan referans listesi	The Reference List field indicates a list of reference values from a database tables. Reference lists populate drop down list boxes in data entry screens	AD_Ref_List_ID numeric(10) NOT NULL ID
Client	İstemci	Client/Tenant for this installation.	İstemci bir firma veya legal bir kurulustur. Verileri İstemciler arasında paylasilmaz. Mutasarruf ise İstemci ile aynı anlama gelmektedir.	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organizasyon	Organizational entity within client	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.	AD_Org_ID numeric(10) NOT NULL Table Direct
Reference	Referans	System Reference and Validation	The Reference could be a display type, list or table validation.	AD_Reference_ID numeric(10) NOT NULL Table Direct
Search Key	Search Key	Search key for the record in the format required - must be unique	A search key allows you a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).	Value character varying(60) NOT NULL String
Name	İsim	Alphanumeric identifier of the entity	The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.	Name character varying(60) NOT NULL String
Description	Description	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
Active	Active	The record is active in the system	There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.	IsActive character(1) NOT NULL Yes-No
Entity Type	Entity Type	Dictionary Entity Type; Determines ownership and synchronization	The Entity Types "Dictionary", "Adempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"!	EntityType character varying(40) NOT NULL Table
Valid from	Valid from	Valid from including this date (first day)	The Valid From date indicates the first day of a date range	ValidFrom timestamp without time zone Date
Valid to	Valid to	Valid to including this date (last day)	The Valid To date indicates the last day of a date range	ValidTo timestamp without time zone Date

TAB: List Translation

tanım: null

Yardım null

Dosya:Referans - List Translation - pencere (iDempiere 1.0.0).png

isim	isim	tanım	Yardım	Özellikler
Client	İstemci	Client/Tenant for this installation.	İstemci bir firma veya legal bir kurulustur. Verileri İstemciler arasında paylasilmaz. Mutasarruf ise İstemci ile aynı anlama gelmektedir.	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organizasyon	Organizational entity within client	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.	AD_Org_ID numeric(10) NOT NULL Table Direct
Reference List	Referans Liste	Tablodan alınan referans listesi	The Reference List field indicates a list of reference values from a database tables. Reference lists populate drop down list boxes in data entry screens	AD_Ref_List_ID numeric(10) NOT NULL Table Direct
Language	Lisan	Bu birim için Dil	Dilin nasıl kullanılacağını ve biçimlendirileceğini tanımlar	AD_Language character varying(6) NOT NULL Table
Active	Active	The record is active in the system	There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.	IsActive character(1) NOT NULL Yes-No
Translated	Translated	This column is translated	The Translated checkbox indicates if this column is translated.	IsTranslated character(1) NOT NULL Yes-No
Name	İsim	Alphanumeric identifier of the entity	The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.	Name character varying(60) NOT NULL String
Description	Description	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String

TAB: Table Validation

tanım: Table validation

Yardım The Table Validation Tab defines tables to validate data

Dosya:Referans - Table Validation - pencere (iDempiere 1.0.0).png

isim	isim	tanım	Yardım	Özellikler
Client	İstemci	Client/Tenant for this installation.	İstemci bir firma veya legal bir kurulustur. Verileri İstemciler arasında paylasilmaz. Mutasarruf ise İstemci ile aynı anlama gelmektedir.	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organizasyon	Organizational entity within client	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.	AD_Org_ID numeric(10) NOT NULL Table Direct
Reference	Referans	System Reference and Validation	The Reference could be a display type, list or table validation.	AD_Reference_ID numeric(10) NOT NULL Table Direct
Table	Tablo	Veritabani Tablosu Bilgisi	Veritabani Tablosu, tablo tanımı için bilgi saglar	AD_Table_ID numeric(10) NOT NULL Table Direct
Key column	Anahtar sütun	Kayıt için benzersiz tanımlayıcı	Anahtar Sütün, tablodaki her bir kayıt için benzersiz bir tanımlayıcıdır.	AD_Key numeric(10) NOT NULL Table
Display column	Sütunu göster	Görünecek sütun	Görüntü Sütunu belirecek sütunu gösterir.	AD_Display numeric(10) NOT NULL Table
Display Value	Display Value	Displays Value column with the Display column	The Display Value checkbox indicates if the value column will display with the display column.	IsValueDisplayed character(1) NOT NULL Yes-No
Active	Active	The record is active in the system	There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.	IsActive character(1) NOT NULL Yes-No
Entity Type	Entity Type	Dictionary Entity Type; Determines ownership and synchronization	The Entity Types "Dictionary", "Adempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"!	EntityType character varying(40) NOT NULL Table
Sql WHERE	Sql WHERE	Fully qualified SQL WHERE clause	The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname".	WhereClause character varying(2000) Text
Sql ORDER BY	Sql ORDER BY	Fully qualified ORDER BY clause	The ORDER BY Clause indicates the SQL ORDER BY clause to use for record selection	OrderByClause character varying(2000) Text
Window	Pencere	Data entry or display window	The Window field identifies a unique Window in the system.	AD_Window_ID numeric(10) Table Direct

TAB: Used in Column

tanım: Used in Column (Reference)

Yardım null

Dosya:Referans - Used in Column - pencere (iDempiere 1.0.0).png

isim	isim	tanım	Yardım	Özellikler
Client	İstemci	Client/Tenant for this installation.	İstemci bir firma veya legal bir kurulustur. Verileri İstemciler arasında paylasilmaz. Mutasarruf ise İstemci ile aynı anlama gelmektedir.	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organizasyon	Organizational entity within client	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.	AD_Org_ID numeric(10) NOT NULL Table Direct
Table	Tablo	Veritabani Tablosu Bilgisi	Veritabani Tablosu, tablo tanımı için bilgi saglar	AD_Table_ID numeric(10) NOT NULL Table Direct
DB Column Name	DB Column Name	Name of the column in the database	The Column Name indicates the name of a column on a table as defined in the database.	ColumnName character varying(30) NOT NULL String
System Element	Sistem Elemenanı	Sistem Öğesi,sütun tanımının merkezi desteğini ve yardımını mümkün kılar.	Sistem Öğesi,bir veritabanı sütununda merkezi destek yardımı,tanım ve terminolojiye müsade eder.	AD_Element_ID numeric(10) Search
Name	İsim	Alphanumeric identifier of the entity	The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.	Name character varying(60) NOT NULL String
Description	Description	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
Comment/Help	Comment/Help	Comment or Hint	The Help field contains a hint, comment or help about the use of this item.	Help character varying(2000) Text
Active	Active	The record is active in the system	There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.	IsActive character(1) NOT NULL Yes-No
Length	Uzunluk	Length of the column in the database	The Length indicates the length of a column as defined in the database.	FieldLength numeric(10) Integer
Reference	Referans	System Reference and Validation	The Reference could be a display type, list or table validation.	AD_Reference_ID numeric(10) NOT NULL Table
Reference Key	Reference Key	Required to specify, if data type is Table or List	The Reference Value indicates where the reference values are stored. It must be specified if the data type is Table or List.	AD_Reference_Value_ID numeric(10) Table
Dynamic Validation	Dynamic Validation	Dynamic Validation Rule	These rules define how an entry is determined to valid. You can use variables for dynamic (context sensitive) validation.	AD_Val_Rule_ID numeric(10) Table Direct