出納帳(標準)(Bank/Cash Statement)|iDempiere 13 画面リファレンス
出納帳(標準)(Bank/Cash Statement)
Section titled “出納帳(標準)(Bank/Cash Statement)”iDempiere 13 標準ウィンドウ(AD_Window_ID: 194)
メニュー: 債権債務管理&資金管理 ▸ 出納帳(標準)
Process Bank Statements
The Process Bank Statements window allows you to reconcile your Bank Statements. You can either enter the line items from the statement in the Statement Line tab or select the ‘Create From’ button to automatically generate the statement from all unreconciled payments to this bank account. Once you have completed reconciling, select the ‘Process Statement’ button to mark the payments as reconciled and update the appropriate GL accounts.
| # | タブ | テーブル | 階層 | 説明 |
|---|---|---|---|---|
| 10 | 出納帳 | C_BankStatement | 0 | Bank/Cash Statement |
| 20 | 出納帳明細 | C_BankStatementLine | 1 | Statement Line |
出納帳 タブのフィールド
Section titled “出納帳 タブのフィールド”The Bank/Cash Statement Tab defines the Bank/Cash Statement to be reconciled.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 銀行口座 | C_BankAccount_ID | Table Direct | ✔ | Account at the Bank |
| Document Type | C_DocType_ID | Table Direct | ✔ | Document type or rules |
| Document No | DocumentNo | String | ✔ | Document sequence number of the document |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 報告日付 | StatementDate | Date | ✔ | Date of the statement |
| 転記日付 | DateAcct | Date | ✔ | Accounting Date |
| 説明 | Description | String | Optional short description of the record | |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| マニュアル | IsManual | Yes-No | ✔ | This is a manual process |
| 記帳前残高 | BeginningBalance | Amount | Balance prior to any transactions | |
| 既存伝票をもとに明細行を作成 | CreateFrom | Button | Process which will generate a new document lines based on an existing document | |
| Bank Statement Create From Batch | CreateFromBatch | Button | ||
| 記帳金額 | StatementDifference | Amount | Difference between statement ending balance and actual ending balance | |
| 銀行報告書照合 | MatchStatement | Button | Match Bank Statement Info to Business Partners, Invoices and Payments | |
| Copy Lines | CopyFrom | Button | Copy Lines from other bank statement | |
| 期末残高 | EndingBalance | Amount | ✔ | Ending or closing balance |
| EFTステートメント | EftStatementReference | String | Electronic Funds Transfer Statement Reference | |
| EFT報告日付 | EftStatementDate | Date | Electronic Funds Transfer Statement Date | |
| 伝票状態 | DocStatus | List | ✔ | The current status of the document |
| 報告プロセス | DocAction | Button | ✔ | |
| 承認済み | IsApproved | Yes-No | ✔ | Indicates if this document requires approval |
| 転記 | Posted | Button | ✔ | Posting status |
出納帳明細 タブのフィールド
Section titled “出納帳明細 タブのフィールド”The Statement Line Tab defines the individual line items on the Bank Statement. They can be entered manually or generated from payments entered.
For Posting, the bank account organization is used, if it is not a charge.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 出納帳 | C_BankStatement_ID | Search | ✔ | Bank Statement of account |
| 明細番号 | Line | Integer | ✔ | Unique line for this document |
| 説明 | Description | String | Optional short description of the record | |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| マニュアル | IsManual | Yes-No | ✔ | This is a manual process |
| 報告明細行日付 | StatementLineDate | Date | ✔ | Date of the Statement Line |
| 転記日付 | DateAcct | Date | ✔ | Accounting Conversion Date |
| 有効日付 | ValutaDate | Date | ✔ | Date when money is available |
| 通貨 | C_Currency_ID | Table Direct | ✔ | The Currency for this record |
| 記帳金額 | StmtAmt | Amount | ✔ | Statement Amount |
| 入金支払伝票 | C_Payment_ID | Search | Payment identifier | |
| 取引金額 | TrxAmt | Amount | ✔ | Amount of a transaction |
| Deposit Batch | C_DepositBatch_ID | Search | ||
| 料金金額 | ChargeAmt | Amount | ✔ | Charge Amount |
| 料金 | C_Charge_ID | Table Direct | Additional document charges | |
| 利息金額 | InterestAmt | Amount | ✔ | Interest Amount |
| リファレンスNo | ReferenceNo | String | Your customer or vendor number at the Business Partner’s site | |
| メモ | Memo | String | Memo Text | |
| 銀行報告書照合 | MatchStatement | Button | Match Bank Statement Info to Business Partners, Invoices and Payments | |
| 支払作成 | CreatePayment | Button | 出納帳の情報をものと入金/支払伝票を作成します。 | |
| 取引先 | C_BPartner_ID | Search | Identifies a Business Partner | |
| 売上請求伝票 | C_Invoice_ID | Search | Invoice Identifier | |
| EFT取引ID | EftTrxID | String | Electronic Funds Transfer Transaction ID | |
| EFT取引タイプ | EftTrxType | String | Electronic Funds Transfer Transaction Type | |
| EFTチェック No | EftCheckNo | String | Electronic Funds Transfer Check No | |
| EFTリファレンス | EftReference | String | Electronic Funds Transfer Reference | |
| EFTメモ | EftMemo | String | Electronic Funds Transfer Memo | |
| EFT受取人 | EftPayee | String | Electronic Funds Transfer Payee information | |
| EFT受取人口座 | EftPayeeAccount | String | Electronic Funds Transfer Payee Account Information | |
| EFT報告明細日付 | EftStatementLineDate | Date | Electronic Funds Transfer Statement Line Date | |
| EFT有効日付 | EftValutaDate | Date | Electronic Funds Transfer Valuta (effective) Date | |
| EFT通貨 | EftCurrency | String | Electronic Funds Transfer Currency | |
| EFT総計 | EftAmt | Amount | Electronic Funds Transfer Amount |