عرض مصدر قالب:Import GL Journal (نافذة ID-278 V1.0.0)

[[en:Import GL Journal (Window ID-278)]]
[[ar:Import GL Journal (نافذة ID-278)]]
[[bg:Import GL Journal (прозорец ID-278)]]
[[da:Import GL Journal (Vindue ID-278)]]
[[de:Import des Journals (Fenster ID-278)]]
[[el:Εισαγωγή Ημερολογίου ΓΚ (παράθυρο ID-278)]]
[[es:Importar Nota de Contabilidad (Ventana ID-278)]]
[[fr:Importation des journaux GL (Fenêtre ID-278)]]
[[hu:FK napló importja (Aablak ID-278)]]
[[id:Import GL Journal (jendela ID-278)]]
[[it:Importazione Gornali (finestra ID-278)]]
[[ja:総勘定元帳のインポート (ウィンドウ ID-278)]]
[[ms:Import Jurnal GL (tetingkap ID-278)]]
[[nl:Import GL Journal (Venster ID-278)]]
[[pl:Import księgi głównej (Okno ID-278)]]
[[pt:Importar Diário Contabilidade (Janela ID-278)]]
[[ro:Import note contabile (fereastră ID-278)]]
[[ru:Импорт журнала ГК (окно ID-278)]]
[[sr:Увези дневник главне књиге (прозор ID-278)]]
[[sv:Importera verifikat (Fönster ID-278)]]
[[th:นำเข้าบัญชีแยกประเภทรายวัน (หน้าต่าง ID-278)]]
[[tr:Import GL Journal (pencere ID-278)]]
[[zh:导入总帐分类帐 (窗口 ID-278)]]
 


== نافذة: Import GL Journal ==

'''وصف:''' Import General Ledger Journals

'''مساعدة:''' You way want to check the balance of the import with "Validate Only" before importing. 
Unbalanced Journals are imported; the handling is based on your settings for the posting process. The optional balance check checks the entire import, not individual batches and journals.

 

    
    
=== TAB: General Ledger ===

'''وصف:''' Import General Ledger 


'''مساعدة''' A new Journal Batch is created, if the Batch Document No or accounting schema are different. A new Journal is created, if the Document No, Currency, Document Type, GL Category, Posting Type or Accounting type is different. You can also force the creation of a new Batch or Jornal by selecting the creat new flag.<p>
Please note that there are three Organization Fields: The Document Organization is the owner of the document and set directly or per parameter default. The Organization is part of the accounting key and only required id no Valid Account Comination is specified; If not defined it is derived from the Document Organization. The Transaction Organization is part of the account combination.<br>
The optional balance check applies to the entire import, not for individual batches or journals.
<br>The document numbers will be overwritten if the document type is not set to manual sequences.


[[image:Import GL Journal - General Ledger - نافذة (iDempiere 1.0.0).png]]




     


{| border="1" cellpadding="5" cellspacing="0" 
|- 
|-valign="top" 
!style="background:#efefef;" |'''''اسم''''' 
!style="background:#efefef;" |'''''اسم''''' 
!style="background:#efefef;" |'''''وصف''''' 
!style="background:#efefef;" |'''''مساعدة''''' 
!style="background:#efefef;" |'''''مواصفات''''' 
|-valign="top" 
|- 


|-valign="top" 
|Import GL Journal
|Import GL Journal
|Import General Ledger Journal 
|null
|I_GLJournal_ID<br>numeric(10) NOT NULL<br>ID
|-valign="top" 
|-

|-valign="top" 
|Imported
|Imported
|Has this import been processed 
|The Imported check box indicates if this import has been processed.
|I_IsImported<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Import Error Message
|Import Error Message
|Messages generated from import process 
|The Import Error Message displays any error messages generated during the import process.
|I_ErrorMsg<br>character varying(2000)<br>String
|-valign="top" 
|-

|-valign="top" 
|Journal Batch
|Journal Batch
|General Ledger Journal Batch 
|The General Ledger Journal Batch identifies a group of journals to be processed as a group.
|GL_JournalBatch_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Client Key
|Client Key
|Key of the Client 
|null
|ClientValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Client
|عميل
|عميل/مستأجر هذا التنصيب 
|العميل هو شركة أو كيان قانوني. لا يمكنك مشاركة البيانات بين العملاء.المستأجر هو مرادف للعميل
|AD_Client_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document Org
|Document Org
|Document Organization (independent from account organization) 
|null
|AD_OrgDoc_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Batch Document No
|Batch Document No
|Document Number of the Batch 
|null
|BatchDocumentNo<br>character varying(30)<br>String
|-valign="top" 
|-

|-valign="top" 
|Create New Batch
|Create New Batch
|If selected a new batch is created 
|Note that the balance check does not check that individual batches are balanced.
|IsCreateNewBatch<br>character(1)<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Batch Description
|Batch Description
|Description of the Batch 
|null
|BatchDescription<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Journal
|Journal
|General Ledger Journal 
|The General Ledger Journal identifies a group of journal lines which represent a logical business transaction
|GL_Journal_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Journal Document No
|Journal Document No
|Document number of the Journal 
|null
|JournalDocumentNo<br>character varying(30)<br>String
|-valign="top" 
|-

|-valign="top" 
|Create New Journal
|Create New Journal
|If selected a new journal within the batch is created 
|Note that the balance check does not check that individual journals are balanced.
|IsCreateNewJournal<br>character(1)<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Account Schema Name
|Account Schema Name
|Name of the Accounting Schema 
|null
|AcctSchemaName<br>character varying(60)<br>String
|-valign="top" 
|-

|-valign="top" 
|Accounting Schema
|Accounting Schema
|Rules for accounting 
|An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar
|C_AcctSchema_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|PostingType
|PostingType
|The type of posted amount for the transaction 
|The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction.
|PostingType<br>character(1)<br>List
|-valign="top" 
|-

|-valign="top" 
|Budget
|Budget
|General Ledger Budget 
|The General Ledger Budget identifies a user defined budget.  These can be used in reporting as a comparison against your actual amounts.
|GL_Budget_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Document Type Name
|Document Type Name
|Name of the Document Type 
|null
|DocTypeName<br>character varying(60)<br>String
|-valign="top" 
|-

|-valign="top" 
|Document Type
|Document Type
|Document type or rules 
|The Document Type determines document sequence and processing rules
|C_DocType_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Category Name
|Category Name
|Name of the Category 
|null
|CategoryName<br>character varying(60)<br>String
|-valign="top" 
|-

|-valign="top" 
|GL Category
|GL Category
|General Ledger Category 
|The General Ledger Category is an optional, user defined method of grouping journal lines.
|GL_Category_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Account Date
|Account Date
|Accounting Date 
|The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion.
|DateAcct<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|Period
|Period
|Period of the Calendar 
|The Period indicates an exclusive range of dates for a calendar.
|C_Period_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Journal Line
|Journal Line
|General Ledger Journal Line 
|The General Ledger Journal Line identifies a single transaction in a journal.
|GL_JournalLine_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Line No
|Line No
|Unique line for this document 
|Indicates the unique line for a document.  It will also control the display order of the lines within a document.
|Line<br>numeric(10)<br>Integer
|-valign="top" 
|-

|-valign="top" 
|Description
|Description
|Optional short description of the record 
|A description is limited to 255 characters.
|Description<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Source Debit
|Source Debit
|Source Debit Amount 
|The Source Debit Amount indicates the credit amount for this line in the source currency.
|AmtSourceDr<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Source Credit
|Source Credit
|Source Credit Amount 
|The Source Credit Amount indicates the credit amount for this line in the source currency.
|AmtSourceCr<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|ISO Currency Code
|ISO Currency Code
|Three letter ISO 4217 Code of the Currency 
|For details - http://www.unece.org/trade/rec/rec09en.htm
|ISO_Code<br>character(3)<br>String
|-valign="top" 
|-

|-valign="top" 
|Currency
|Currency
|The Currency for this record 
|Indicates the Currency to be used when processing or reporting on this record
|C_Currency_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Currency Type Key
|Currency Type Key
|Key value for the Currency Conversion Rate Type 
|The date type key for the conversion of foreign currency transactions
|ConversionTypeValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Currency Type
|Currency Type
|Currency Conversion Rate Type 
|The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates.
|C_ConversionType_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Rate
|Rate
|Currency Conversion Rate 
|The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency
|CurrencyRate<br>numeric<br>Number
|-valign="top" 
|-

|-valign="top" 
|Accounted Debit
|Accounted Debit
|Accounted Debit Amount 
|The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency
|AmtAcctDr<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Accounted Credit
|Accounted Credit
|Accounted Credit Amount 
|The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency
|AmtAcctCr<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|UOM
|UOM
|Unit of Measure 
|The UOM defines a unique non monetary Unit of Measure
|C_UOM_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Quantity
|Quantity
|Quantity 
|The Quantity indicates the number of a specific product or item for this document.
|Qty<br>numeric<br>Quantity
|-valign="top" 
|-

|-valign="top" 
|Combination
|Combination
|Valid Account Combination 
|The Combination identifies a valid combination of element which represent a GL account.
|C_ValidCombination_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Org Key
|Org Key
|Key of the Organization 
|null
|OrgValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Organization
|تنظيم
|كيان تنظيمي داخل العميل 
|An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
|AD_Org_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Account Key
|Account Key
|Key of Account Element 
|null
|AccountValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Account
|Account
|Account used 
|The (natural) account used
|Account_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Business Partner Key
|Business Partner Key
|Key of the Business Partner 
|null
|BPartnerValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Business Partner 
|Business Partner 
|Identifies a Business Partner 
|A Business Partner is anyone with whom you transact.  This can include Vendor, Customer, Employee or Salesperson
|C_BPartner_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Product Key
|Product Key
|Key of the Product 
|null
|ProductValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|UPC/EAN
|UPC/EAN
|Bar Code (Universal Product Code or its superset European Article Number) 
|Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) 
|UPC<br>character varying(30)<br>String
|-valign="top" 
|-

|-valign="top" 
|SKU
|SKU
|Stock Keeping Unit 
|The SKU indicates a user defined stock keeping unit.  It may be used for an additional bar code symbols or your own schema.
|SKU<br>character varying(30)<br>String
|-valign="top" 
|-

|-valign="top" 
|Product
|Product
|Product, Service, Item 
|Identifies an item which is either purchased or sold in this organization.
|M_Product_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Project Key
|Project Key
|Key of the Project 
|null
|ProjectValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Project
|Project
|Financial Project 
|A Project allows you to track and control internal or external activities.
|C_Project_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Campaign
|Campaign
|Marketing Campaign 
|The Campaign defines a unique marketing program.  Projects can be associated with a pre defined Marketing Campaign.  You can then report based on a specific Campaign.
|C_Campaign_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Activity
|Activity
|Business Activity 
|Activities indicate tasks that are performed and used to utilize Activity based Costing
|C_Activity_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Sales Region
|Sales Region
|Sales coverage region 
|The Sales Region indicates a specific area of sales coverage.
|C_SalesRegion_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Trx Org Key
|Trx Org Key
|Key of the Transaction Organization 
|null
|OrgTrxValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Trx Organization
|Trx Organization
|أداء أو الشروع في تنظيم 
|The organization which performs or initiates this transaction (for another organization).  The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.
|AD_OrgTrx_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Location From
|Location From
|Location that inventory was moved from 
|The Location From indicates the location that a product was moved from.
|C_LocFrom_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Location To
|Location To
|Location that inventory was moved to 
|The Location To indicates the location that a product was moved to.
|C_LocTo_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|User List 1
|User List 1
|User defined list element #1 
|The user defined element displays the optional elements that have been defined for this account combination.
|User1_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|User List 2
|User List 2
|User defined list element #2 
|The user defined element displays the optional elements that have been defined for this account combination.
|User2_ID<br>numeric(10)<br>Table
|-valign="top" 
|-

|-valign="top" 
|Import Journal
|Import Journal
|Import General Ledger Batch/Journal/Line 
|The Parameters are default values for null import record values, they do not overwrite any data.
|Processing<br>character(1)<br>Button
|-valign="top" 
|-

|-valign="top" 
|Processed
|Processed
|The document has been processed 
|The Processed checkbox indicates that a document has been processed.
|Processed<br>character(1)<br>Yes-No
|-valign="top" 
|-
|}