ManPageW ImportPayment 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 Payment
Description : Import Payments
Help :
Tab: Payment
Description : Import Payments
Help :
Table Name : I_Payment
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Import Payment | Import Payment | I_Payment_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 |
Payment | Payment identifier | The Payment is a unique identifier of this payment. | C_Payment_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 |
Bank Account No | Bank Account Number | BankAccountNo
NVARCHAR2(20) String | |
Bank Account | Account at the Bank | The Bank Account identifies an account at this Bank. | C_BankAccount_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 |
Receipt | This is a sales transaction (receipt) | IsReceipt
CHAR(1) YesNo | |
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 |
Transaction Date | Transaction Date | The Transaction Date indicates the date of the transaction. | DateTrx
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 DateTime |
Business Partner Key | Key of the Business Partner | BPartnerValue
NVARCHAR2(40) String | |
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 |
Invoice Document No | Document Number of the Invoice | InvoiceDocumentNo
NVARCHAR2(30) String | |
Invoice | Invoice Identifier | The Invoice Document. | C_Invoice_ID
NUMBER(10) Search |
ISO Currency Code | Three letter ISO 4217 Code of the Currency | For details - http://www.unece.org/trade/rec/rec09en.htm | ISO_Code
CHAR(3) String |
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 |
Payment amount | Amount being paid | Indicates the amount this payment is for. The payment amount can be for single or multiple invoices or a partial payment for an invoice. | PayAmt
NUMBER Amount |
Discount Amount | Calculated amount of discount | The Discount Amount indicates the discount amount for a document or line. | DiscountAmt
NUMBER Amount |
Write-off Amount | Amount to write-off | The Write Off Amount indicates the amount to be written off as uncollectible. | WriteOffAmt
NUMBER Amount |
Over/Under Payment | Over-Payment (unallocated) or Under-Payment (partial payment) | Overpayments (negative) are unallocated amounts and allow you to receive money for more than the particular invoice.
Underpayments (positive) is a partial payment for the invoice. You do not write off the unpaid amount. |
IsOverUnderPayment
CHAR(1) YesNo |
Over/Under Payment | Over-Payment (unallocated) or Under-Payment (partial payment) Amount | Overpayments (negative) are unallocated amounts and allow you to receive money for more than the particular invoice.
Underpayments (positive) is a partial payment for the invoice. You do not write off the unpaid amount. |
OverUnderAmt
NUMBER Amount |
Tender type | Method of Payment | The Tender Type indicates the method of payment (ACH or Direct Deposit, Credit Card, Check, Direct Debit) | TenderType
CHAR(1) List |
Credit Card | Credit Card (Visa, MC, AmEx) | The Credit Card drop down list box is used for selecting the type of Credit Card presented for payment. | CreditCardType
CHAR(1) List |
Transaction Type | Type of credit card transaction | The Transaction Type indicates the type of transaction to be submitted to the Credit Card Company. | TrxType
CHAR(1) List |
Number | Credit Card Number | The Credit Card number indicates the number on the credit card, without blanks or spaces. | CreditCardNumber
NVARCHAR2(20) String |
Exp. Month | Expiry Month | The Expiry Month indicates the expiry month for this credit card. | CreditCardExpMM
NUMBER(10) Integer |
Exp. Year | Expiry Year | The Expiry Year indicates the expiry year for this credit card. | CreditCardExpYY
NUMBER(10) Integer |
Routing No | Bank Routing Number | The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions. | RoutingNo
NVARCHAR2(20) String |
Account No | Account Number | The Account Number indicates the Number assigned to this bank account. | AccountNo
NVARCHAR2(20) String |
Check No | Check Number | The Check Number indicates the number on the check. | CheckNo
NVARCHAR2(20) String |
Micr | Combination of routing no, account and check no | The Micr number is the combination of the bank routing number, account number and check number | Micr
NVARCHAR2(20) String |
Account Name | Name on Credit Card or Account holder | The Name of the Credit Card or Account holder. | A_Name
NVARCHAR2(60) String |
Account Street | Street address of the Credit Card or Account holder | The Street Address of the Credit Card or Account holder. | A_Street
NVARCHAR2(60) String |
Account City | City or the Credit Card or Account Holder | The Account City indicates the City of the Credit Card or Account holder | A_City
NVARCHAR2(60) String |
Account Zip/Postal | Zip Code of the Credit Card or Account Holder | The Zip Code of the Credit Card or Account Holder. | A_Zip
NVARCHAR2(20) String |
Account State | State of the Credit Card or Account holder | The State of the Credit Card or Account holder | A_State
NVARCHAR2(40) String |
Account Country | Country | Account Country Name | A_Country
NVARCHAR2(40) String |
Driver License | Payment Identification - Driver License | The Driver's License being used as identification. | A_Ident_DL
NVARCHAR2(20) String |
Social Security No | Payment Identification - Social Security No | The Social Security number being used as identification. | A_Ident_SSN
NVARCHAR2(20) String |
Account EMail | Email Address | The EMail Address indicates the EMail address off the Credit Card or Account holder. | A_EMail
NVARCHAR2(60) String |
Voice authorization code | Voice Authorization Code from credit card company | The Voice Authorization Code indicates the code received from the Credit Card Company. | VoiceAuthCode
NVARCHAR2(20) String |
Original Transaction ID | Original Transaction ID | The Original Transaction ID is used for reversing transactions and indicates the transaction that has been reversed. | Orig_TrxID
NVARCHAR2(20) String |
Approved | Indicates if this document requires approval | The Approved checkbox indicates if this document requires approval before it can be processed. | IsApproved
CHAR(1) YesNo |
Result | Result of transmission | The Response Result indicates the result of the transmission to the Credit Card Company. | R_Result
NVARCHAR2(20) String |
Response Message | Response message | The Response Message indicates the message returned from the Credit Card Company as the result of a transmission | R_RespMsg
NVARCHAR2(60) String |
Reference | Payment reference | The Payment Reference indicates the reference returned from the Credit Card Company for a payment | R_PnRef
NVARCHAR2(20) String |
Authorization Code | Authorization Code returned | The Authorization Code indicates the code returned from the electronic transmission. | R_AuthCode
NVARCHAR2(20) String |
Import Payments | Import Payments | The Parameters are default values for null import record values, they do not overwrite any data. | Processing
CHAR(1) Button |