ManPageW ImportInvoice es
¡Disfrútalo y ayuda a completarlo! Pero por favor, siempre respetando los derechos de autor.
Por favor, escriba sus contribuciones bajo la Sección Contribuciones
Window: Import Invoice
Description : Import Invoices
Help : Import invoiced loaded
Tab: Invoice
Description : Import Invoices
Help : 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.
Table Name : I_Invoice
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Import Invoice | Import Invoice | I_Invoice_ID
NUMBER(10) ID | |
Imported | Has this import been processed | The Imported check box indicates if this import has been processed. | I_IsImported
CHAR(1) YesNo |
Invoice | Invoice Identifier | The Invoice Document. | C_Invoice_ID
NUMBER(10) Search |
Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | C_InvoiceLine_ID
NUMBER(10) Search |
Import Error Message | Messages generated from import process | The Import Error Message displays any error messages generated during the import process. | I_ErrorMsg
NVARCHAR2(2000) String |
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | 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
NUMBER(10) TableDir |
Document Type Name | Name of the Document Type | DocTypeName
NVARCHAR2(60) String | |
Document Type | Document type or rules | The Document Type determines document sequence and processing rules | C_DocType_ID
NUMBER(10) TableDir |
Document No | Document sequence number of the document | 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
NVARCHAR2(30) String |
Sales Transaction | This is a Sales Transaction | The Sales Transaction checkbox indicates if this item is a Sales Transaction. | IsSOTrx
CHAR(1) YesNo |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Sales Representative | 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
NUMBER(10) Table |
Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID
NUMBER(10) TableDir |
Price List | 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
NUMBER(10) TableDir |
Payment Term Key | Key of the Payment Term | PaymentTermValue
NVARCHAR2(40) String | |
Payment Term | The terms of Payment (timing, discount) | Payment Terms identify the method and timing of payment. | C_PaymentTerm_ID
NUMBER(10) TableDir |
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
NUMBER(10) Search |
Business Partner Key | Key of the Business Partner | BPartnerValue
NVARCHAR2(40) String | |
Name | 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
NVARCHAR2(60) String |
Partner Location | Identifies the (ship to) address for this Business Partner | The Partner address indicates the location of a Business Partner | C_BPartner_Location_ID
NUMBER(10) TableDir |
Address | Location or Address | The Location / Address field defines the location of an entity. | C_Location_ID
NUMBER(10) Search |
Address 1 | Address line 1 for this location | The Address 1 identifies the address for an entity's location | Address1
NVARCHAR2(60) String |
Address 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
NVARCHAR2(60) String |
City | Identifies a City | The City identifies a unique City for this Country or Region. | City
NVARCHAR2(60) String |
ZIP | Postal code | The Postal Code or ZIP identifies the postal code for this entity's address. | Postal
VARCHAR2 String |
Region | Name of the Region | The Region Name defines the name that will print when this region is used in a document. | RegionName
NVARCHAR2(60) String |
Region | Identifies a geographical Region | The Region identifies a unique Region for this Country. | C_Region_ID
NUMBER(10) TableDir |
ISO Country Code | 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
CHAR(2) YesNo |
Country | Country | The Country defines a Country. Each Country must be defined before it can be used in any document. | C_Country_ID
NUMBER(10) TableDir |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | AD_User_ID
NUMBER(10) TableDir |
Contact Name | Business Partner Contact Name | ContactName
NVARCHAR2(60) String | |
Phone | Identifies a telephone number | The Phone field identifies a telephone number | Phone
NVARCHAR2(40) String |
EMail Address | 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
NVARCHAR2(60) String |
Date Invoiced | Date printed on Invoice | The Date Invoice indicates the date printed on the invoice. | DateInvoiced
DATE 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
DATE Date |
Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(10) Search |
Product Key | Key of the Product | ProductValue
NVARCHAR2(40) String | |
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
NVARCHAR2(30) String |
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
NVARCHAR2(30) String |
Ordered Quantity | Ordered Quantity | The Ordered Quantity indicates the quantity of a product that was ordered. | QtyOrdered
NUMBER Quantity |
Unit Price | Actual Price | The Actual or Unit Price indicates the Price for a product in source currency. | PriceActual
NUMBER CostsPrices |
Line Description | Description of the Line | LineDescription
NVARCHAR2(255) String | |
Tax Indicator | 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
NVARCHAR2(10) String |
Tax | Tax identifier | The Tax indicates the type of tax used in document line. | C_Tax_ID
NUMBER(10) TableDir |
Tax Amount | Tax Amount for a document | The Tax Amount displays the total tax amount for a document. | TaxAmt
NUMBER Amount |
Project | Financial Project | A Project allows you to track and control internal or external activities. | C_Project_ID
NUMBER(10) Search |
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
NUMBER(10) TableDir |
Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID
NUMBER(10) TableDir |
Trx Organization | 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
NUMBER(10) Table |
Import Invoice | Import Invoice | 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
CHAR(1) Button |
Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed
CHAR(1) YesNo |