Window: Bank/Cash Transfer
[Created: 03/04/2022 - Updated: 14/04/2022 ]
Description: Manage Bank Transfer
Help:
Tab: Bank Transfer
[Created: 03/04/2022 - Updated: 03/04/2022 ]
Description:
Help:
Tab Level: 0
Table 10: Bank Transfer - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | c_banktransfer.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | c_banktransfer.AD_Org_ID numeric(10) Table Direct |
| 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_", where TableName is the actual name of the table (e.g. C_Order). | c_banktransfer.DocumentNo character varying(30) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | c_banktransfer.Description character varying(255) String |
| Payment date | Date Payment made | The Payment Date indicates the date the payment was made. | c_banktransfer.PayDate timestamp without time zone 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. | c_banktransfer.DateAcct timestamp without time zone Date |
| From Bank Account | c_banktransfer.From_C_BankAccount_ID numeric(10) Table | ||
| From Organization | c_banktransfer.From_AD_Org_ID numeric(10) Table | ||
| From Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | c_banktransfer.From_C_BPartner_ID numeric(10) Search |
| From Charge | c_banktransfer.From_C_Charge_ID numeric(10) Table | ||
| From Bank Currency | c_banktransfer.From_C_Currency_ID numeric(10) Table | ||
| From Amount | c_banktransfer.From_Amt numeric Amount | ||
| From Tender Type | c_banktransfer.From_TenderType character(1) List | ||
| To Bank Account | c_banktransfer.To_C_BankAccount_ID numeric(10) Table | ||
| To Organization | c_banktransfer.To_AD_Org_ID numeric(10) Table | ||
| To Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | c_banktransfer.To_C_BPartner_ID numeric(10) Search |
| To Charge | c_banktransfer.To_C_Charge_ID numeric(10) Table | ||
| To Bank Currency | c_banktransfer.To_C_Currency_ID numeric(10) Table | ||
| 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_banktransfer.C_ConversionType_ID numeric(10) Table Direct |
| Override Currency Conversion Rate | Override Currency Conversion Rate | c_banktransfer.IsOverrideCurrencyRate character(1) Yes-No | |
| Rate | Rate or Tax or Exchange | The Rate indicates the percentage to be multiplied by the source to arrive at the tax or exchange amount. | c_banktransfer.Rate numeric Number |
| To Amount | c_banktransfer.To_Amt numeric Amount | ||
| To Tender Type | c_banktransfer.To_TenderType character(1) List | ||
| Document Status | The current status of the document | The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field | c_banktransfer.DocStatus character(2) List |
| Process Bank Transfer | c_banktransfer.DocAction character(2) Button | ||
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | c_banktransfer.Processed character(1) Yes-No |
Tab: Payments
[Created: 03/04/2022 - Updated: 03/04/2022 ]
Description:
Help:
Tab Level: 1
Table 20: Payments - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | c_payment.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | c_payment.AD_Org_ID numeric(10) Table Direct |
| Bank Transfer | Bank Transfer | c_payment.C_BankTransfer_ID numeric(10) Search | |
| Payment | Payment identifier | The Payment is a unique identifier of this payment. | c_payment.C_Payment_ID numeric(10) ID |
| Document Type | Document type or rules | The Document Type determines document sequence and processing rules | c_payment.C_DocType_ID numeric(10) Table Direct |
| 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_", where TableName is the actual name of the table (e.g. C_Order). | c_payment.DocumentNo character varying(30) String |
| Document Status | The current status of the document | The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field | c_payment.DocStatus character(2) List |
| Self-Service | This is a Self-Service entry or this entry can be changed via Self-Service | Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. | c_payment.IsSelfService character(1) Yes-No |
| Transaction Date | Transaction Date | The Transaction Date indicates the date of the transaction. | c_payment.DateTrx timestamp without time zone Date |
| Bank Account | Account at the Bank | The Bank Account identifies an account at this Bank. | c_payment.C_BankAccount_ID numeric(10) Table Direct |
| Online Access | Can be accessed online | The Online Access check box indicates if the application can be accessed via the web. | c_payment.IsOnline character(1) Yes-No |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | c_payment.C_Currency_ID numeric(10) Table Direct |
| 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. | c_payment.PayAmt numeric Amount |
| 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_payment.C_ConversionType_ID numeric(10) Table Direct |
| Override Currency Conversion Rate | Override Currency Conversion Rate | c_payment.IsOverrideCurrencyRate character(1) Yes-No | |
| Rate | Currency Conversion Rate | The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency | c_payment.CurrencyRate numeric Number |
| Converted Amount | Converted Amount | The Converted Amount is the result of multiplying the Source Amount by the Conversion Rate for this target currency. | c_payment.ConvertedAmt numeric Amount |
| Discount Amount | Calculated amount of discount | The Discount Amount indicates the discount amount for a document or line. | c_payment.DiscountAmt numeric Amount |
| Write-off Amount | Amount to write-off | The Write Off Amount indicates the amount to be written off as uncollectible. | c_payment.WriteOffAmt numeric Amount |
| Tender type | Method of Payment | The Tender Type indicates the method of payment (ACH or Direct Deposit, Credit Card, Check, Direct Debit) | c_payment.TenderType character(1) List |
| Prepayment | The Payment/Receipt is a Prepayment | Payments not allocated to an invoice with a charge are posted to Unallocated Payments. When setting this flag, the payment is posted to the Customer or Vendor Prepayment account. | c_payment.IsPrepayment character(1) Yes-No |
| Delayed Capture | Charge after Shipment | Delayed Capture is required, if you ship products. The first credit card transaction is the Authorization, the second is the actual transaction after the shipment of the product. | c_payment.IsDelayedCapture character(1) Yes-No |
| Invoice | Invoice Identifier | The Invoice Document. | c_payment.C_Invoice_ID numeric(10) Search |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | c_payment.C_Charge_ID numeric(10) Table Direct |