Import Akaun (tetingkap ID-248)

Daripada iDempiere ms
Lompat ke:pandu arah, cari



tetingkap: Import Akaun

Huraian: Import Natural Account Values

Bantuan: The Import Natural Account Window is an interim table which is used when importing external data into the system. Selecting the 'Process' button will either add or modify the appropriate records.



TAB: Import Akaun

Huraian: null


Bantuan null


Fail:Import Akaun - Import Akaun - tetingkap (iDempiere 1.0.0).png




Nama Nama Huraian Bantuan spesifikasi
Active Aktif 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)
Yes-No
Import Account Import Akaun Import Account Value null I_ElementValue_ID
numeric(10) NOT NULL
ID
Imported Diimport Has this import been processed The Imported check box indicates if this import has been processed. I_IsImported
character(1) NOT NULL
Yes-No
Account Element Elemen Perakaunan Elemen Perakaunan Account Elements can be natural accounts or user defined values. C_ElementValue_ID
numeric(10)
Table Direct
Import Error Message Import Pesanan Salah Messages generated from import process The Import Error Message displays any error messages generated during the import process. I_ErrorMsg
character varying(2000)
String
Client Klien Klien/Pengguna untuk terjemahan ini Klien/Penghuni adalah syarikat atau pihak yang sah. Anda tidak boleh berkongsi maklumat antara Klien. Penghuni adalah sama erti dengan Klien. AD_Client_ID
numeric(10)
Table Direct
Organization Organisasi Organizational entity within client Organisasi adalah unit pelanggan atau entiti sah - contonnya kedai, Jabatan. Data boleh dikongsi antara organisasi. AD_Org_ID
numeric(10)
Table Direct
Element Name Nama Elemen Name of the Element null ElementName
character varying(60)
String
Element Elemen Accounting Element The Account Element uniquely identifies an Account Type. These are commonly known as a Chart of Accounts. C_Element_ID
numeric(10)
Table Direct
Search Key Kekunci Carian 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(40)
String
Name Nama 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)
String
Description Perihal Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Account Type Jenis Akaun Indicates the type of account Valid account types are A - Asset, E - Expense, L - Liability, O- Owner's Equity, R -Revenue and M- Memo. The account type is used to determine what taxes, if any are applicable, validating payables and receivables for business partners. Note: Memo account amounts are ignored when checking for balancing AccountType
character(1)
List
Account Sign Petanda Akaun Indicates the Natural Sign of the Account as a Debit or Credit Indicates if the expected balance for this account should be a Debit or a Credit. If set to Natural, the account sign for an asset or expense account is Debit Sign (i.e. negative if a credit balance). AccountSign
character(1)
List
Summary Level Peringkat Rumusan This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary
character(1)
Yes-No
Parent Key Kunci Induk Key if the Parent null ParentValue
character varying(40)
String
Parent Account Akaun Induk The parent (summary) account null ParentElementValue_ID
numeric(10)
Table
Post Actual Post Sebenar Actual Values can be posted The Post Actual indicates if actual values can be posted to this element value. PostActual
character(1)
Yes-No
Post Budget Bajet Post Budget values can be posted The Post Budget indicates if budget values can be posted to this element value. PostBudget
character(1)
Yes-No
Post Statistical Statistik Post Post statistical quantities to this account? null PostStatistical
character(1)
Yes-No
Post Encumbrance Beban Pos Post commitments to this account null PostEncumbrance
character(1)
Yes-No
Document Controlled Dokumen Terkawal Control account - If an account is controlled by a document, you cannot post manually to it null IsDocControlled
character(1)
Yes-No
Default Account Default Account Name of the Default Account Column null Default_Account
character varying(30)
String
Column Ruangan Lajur dalam Jadual Sambungan kepada lajur pengkalan data dalam jadual AD_Column_ID
numeric(10)
Table
Import Accounts Import Accounts Import Natural Accounts Import accounts and their hierarchies and optional update the default accounts.

Updating the Default Accounts changes the natural account segment of the used account, e.g. account 01-240 becomes 01-300). If you create a new combination, the old account (e.g. 01-240) will remain, otherwise replaced. If you select this, make sure that you not multiple default accounts using one natural account and HAVE A BACKUP !!

The Parameters are default values for null import record values, they do not overwrite any data.

Processing
character(1)
Button
Processed Diproses The document has been processed The Processed checkbox indicates that a document has been processed. Processed
character(1)
Yes-No


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.