Import Invois (tetingkap ID-279)

Daripada iDempiere ms
Lompat ke:pandu arah, cari



tetingkap: Import Invois

Huraian: Import Invoices

Bantuan: Import invoiced loaded



TAB: Invois

Huraian: Import Invoices


Bantuan You should supply the Document Type Name (or ID). The Document Type is on purpose not fully derived as it has too many consequences if it's wrong. The best way is to set the Document Type Name as a Constant in your Import File Format or as an imported field in the file.


Fail:Import Invois - Invois - 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 Invoice Import Invois Import Invois null I_Invoice_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
Invoice Invois Invoice Identifier The Invoice Document. C_Invoice_ID
numeric(10)
Search
Invoice Line Barisan Invois Invoice Detail Line The Invoice Line uniquely identifies a single line of an Invoice. C_InvoiceLine_ID
numeric(10)
Search
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
Document Type Name Nama Jenis Dokumen Name of the Document Type null DocTypeName
character varying(60)
String
Document Type Jenis Dokumen Document type or rules The Document Type determines document sequence and processing rules C_DocType_ID
numeric(10)
Table Direct
Document No Nombor Dokumen Dokumenkan jujukan nombor dokumen The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. 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).

DocumentNo
character varying(30)
String
Sales Transaction Transaksi Jualan This is a Sales Transaction The Sales Transaction checkbox indicates if this item is a Sales Transaction. IsSOTrx
character(1)
Yes-No
Description Perihal Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Sales Representative Wakil Jualan Sales Representative or Company Agent The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. SalesRep_ID
numeric(10)
Table
Currency Matawang The Currency for this record Indicates the Currency to be used when processing or reporting on this record C_Currency_ID
numeric(10)
Table Direct
Price List Senarai Harga Unique identifier of a Price List Price Lists are used to determine the pricing, margin and cost of items purchased or sold. M_PriceList_ID
numeric(10)
Table Direct
Payment Term Key Kunci Terma Pemabayaran Key of the Payment Term null PaymentTermValue
character varying(40)
String
Payment Term Terma Pembayaran The terms for Payment of this transaction Payment Terms identify the method and timing of payment for this transaction. C_PaymentTerm_ID
numeric(10)
Table Direct
Business Partner Rakan Niaga Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID
numeric(10)
Search
Business Partner Key Kunci Rakan kongsi Niaga Key of the Business Partner null BPartnerValue
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
Partner Location Lokasi Rakan kongsi Identifies the (ship to) address for this Business Partner The Partner address indicates the location of a Business Partner C_BPartner_Location_ID
numeric(10)
Table Direct
Address Alamat Lokasi atau Alamat The Location / Address field defines the location of an entity. C_Location_ID
numeric(10)
Search
Address 1 Alamat 1 Address line 1 for this location The Address 1 identifies the address for an entity's location Address1
character varying(60)
String
Address 2 Alamat 2 Address line 2 for this location The Address 2 provides additional address information for an entity. It can be used for building location, apartment number or similar information. Address2
character varying(60)
String
City Bandar Identifies a City The City identifies a unique City for this Country or Region. City
character varying(60)
String
ZIP Poskod Postal code The Postal Code or ZIP identifies the postal code for this entity's address. Postal
character varying(10)
String
Region Kawasan Nama Wilayah The Region Name defines the name that will print when this region is used in a document. RegionName
character varying(60)
String
Region Kawasan Identifies a geographical Region The Region identifies a unique Region for this Country. C_Region_ID
numeric(10)
Table Direct
ISO Country Code Kod ISO Negara Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html For details - http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1.html or - http://www.unece.org/trade/rec/rec03en.htm CountryCode
character(2)
Yes-No
Country Negara Country The Country defines a Country. Each Country must be defined before it can be used in any document. C_Country_ID
numeric(10)
Table Direct
User/Contact Pengguna/Hubung User within the system - Internal or Business Partner Contact The User identifies a unique user in the system. Boleh jadi pengguna dalaman atau Rakan Kongsi Niaga Kontrak AD_User_ID
numeric(10)
Table Direct
Contact Name Nama untuk Dihubungi Business Partner Contact Name null ContactName
character varying(60)
String
Phone Telefon Identifies a telephone number The Phone field identifies a telephone number Phone
character varying(40)
String
EMail Address Emel Electronic Mail Address The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com). The Email Address is used to access the self service application functionality from the web. EMail
character varying(60)
String
Date Invoiced Tarikh Diinvoiskan Date printed on Invoice The Date Invoice indicates the date printed on the invoice. DateInvoiced
timestamp without time zone
Date
Account Date Tarikh Akaun 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
timestamp without time zone
Date
Product Produk Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10)
Search
Product Key Kunci Produk Key of the Product null ProductValue
character varying(40)
String
Charge Caj Additional document charges The Charge indicates a type of Charge (Handling, Shipping, Restocking) C_Charge_ID
numeric(10)
Table Direct
Charge Name Nama Caj Name of the Charge null ChargeName
character varying(60)
String
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
character varying(30)
String
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
character varying(30)
String
Ordered Quantity Kuantiti yang Ditempah Kuantiti yang Ditempah The Ordered Quantity indicates the quantity of a product that was ordered. QtyOrdered
numeric
Quantity
Unit Price Harga Unit Actual Price The Actual or Unit Price indicates the Price for a product in source currency. PriceActual
numeric
Costs+Prices
Line Description Penerangan Line Description of the Line null LineDescription
character varying(255)
String
Tax Indicator Penunjuk Cukai Short form for Tax to be printed on documents The Tax Indicator identifies the short name that will print on documents referencing this tax. TaxIndicator
character varying(10)
String
Tax Cukai Tax identifier The Tax indicates the type of tax used in document line. C_Tax_ID
numeric(10)
Table Direct
Tax Amount Amaun Cukai Tax Amount for a document The Tax Amount displays the total tax amount for a document. TaxAmt
numeric
Amount
Project Key Kunci Projek Key of the Project null ProjectValue
character varying(40)
String
Project Projek Financial Project A Project allows you to track and control internal or external activities. C_Project_ID
numeric(10)
Search
Campaign Kempen Kampanye Pemasaran 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
numeric(10)
Table Direct
Activity Value Activity Value null null ActivityValue
character varying(40)
String
Activity Pembahagian Aktifitas Bisnis Activities indicate tasks that are performed and used to utilize Activity based Costing C_Activity_ID
numeric(10)
Table Direct
Trx Organization Organisasi Trx Performing or initiating 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
numeric(10)
Table
Import Invoice Import Invois Import Invois The Parameters are default values for null import record values, they do not overwrite any data.

Note that only Prepare and Complete are valid document actions.

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.