iDempiere 13 標準ウィンドウ(AD_Window_ID: 291)
メニュー: 取引先管理 ▸ 取引先管理セットアップ ▸ 取引先別取引情報
Document Information of Business Partners
| # | タブ | テーブル | 階層 | 説明 |
|---|
| 10 | 取引先 | C_BPartner | 0 | Business Partner Selection |
| 20 | 注文情報 | C_Order | 1 | Business Partner Orders |
| 30 | 出荷情報 | M_InOut | 1 | Business Partner Shipments |
| 40 | 請求情報 | C_Invoice | 1 | Business Partner Invoices |
| 50 | 支払情報 | C_Payment | 1 | Business Partner Payments |
| 60 | 資産情報 | A_Asset | 1 | Business Partner Assets |
| 70 | リクエスト | R_Request | 1 | Business Partner Requests |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 検索キー | Value | String | ✔ | Search key for the record in the format required - must be unique |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | | Optional short description of the record |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 取引先グループ | C_BP_Group_ID | Table Direct | ✔ | Business Partner Group |
| 債権債務残高 | TotalOpenBalance | Amount | | Total Open Balance Amount in primary Accounting Currency |
| 得意先 | IsCustomer | Yes-No | ✔ | Indicates if this Business Partner is a Customer |
| 仕入先 | IsVendor | Yes-No | ✔ | Indicates if this Business Partner is a Vendor |
| 社内担当者 | IsSalesRep | Yes-No | ✔ | Indicates if the business partner is a sales representative or company agent |
| 従業員 | IsEmployee | Yes-No | ✔ | Indicates if this Business Partner is an employee |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 伝票番号 | DocumentNo | String | ✔ | Document sequence number of the document |
| 説明 | Description | Text | | Optional short description of the record |
| 伝票タイプ | C_DocType_ID | Table Direct | ✔ | Document type or rules |
| 伝票状態 | DocStatus | List | ✔ | The current status of the document |
| 注文日付 | DateOrdered | Date | ✔ | Date of Order |
| 転記日付 | DateAcct | Date | ✔ | Accounting Date |
| 納品予定日 | DatePromised | Date | ✔ | Date Order was promised |
| 印刷日付 | DatePrinted | Date | | Date the document was printed. |
| 取引先 | C_BPartner_ID | Search | ✔ | Identifies a Business Partner |
| 請求先 | Bill_BPartner_ID | Search | | Business Partner to be invoiced |
| 取引先住所 | C_BPartner_Location_ID | Table Direct | ✔ | Identifies the (ship to) address for this Business Partner |
| 請求先住所 | Bill_Location_ID | Table | | Business Partner Location for invoicing |
| 出荷ルール | DeliveryRule | List | ✔ | Defines the timing of Delivery |
| 優先度 | PriorityRule | List | ✔ | Priority of a document |
| 倉庫 | M_Warehouse_ID | Table Direct | ✔ | Storage Warehouse and Service Point |
| 直送 | IsDropShip | Yes-No | ✔ | Drop Shipments are sent directly to the Drop Shipment Location |
| 請求ルール | InvoiceRule | List | ✔ | Frequency and method of invoicing |
| 販売(ON) / 購買(OFF) | IsSOTrx | Yes-No | ✔ | This is a Sales Transaction |
| 価格表 | M_PriceList_ID | Table Direct | ✔ | Unique identifier of a Price List |
| 通貨 | C_Currency_ID | Table Direct | ✔ | The Currency for this record |
| 社内担当者 | SalesRep_ID | Table | ✔ | Sales Representative or Company Agent |
| セルフサービス | IsSelfService | Yes-No | ✔ | This is a Self-Service entry or this entry can be changed via Self-Service |
| 支払方法 | PaymentRule | Payment | ✔ | How you pay the invoice |
| 支払条件 | C_PaymentTerm_ID | Table Direct | ✔ | The terms of Payment (timing, discount) |
| プロジェクト | C_Project_ID | Table Direct | | Financial Project |
| 営業活動 | C_Campaign_ID | Table Direct | | キャンペーン、営業活動 |
| 明細行合計 | TotalLines | Amount | ✔ | Total of all document lines |
| 総合計 | GrandTotal | Amount | ✔ | Total amount of document |
| 受注伝票 | C_Order_ID | ID | ✔ | Order |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 伝票タイプ | C_DocType_ID | Table | ✔ | Document type or rules |
| 伝票番号 | DocumentNo | String | ✔ | Document sequence number of the document |
| 伝票状態 | DocStatus | List | ✔ | The current status of the document |
| 移動タイプ | MovementType | List | ✔ | Method of moving the inventory |
| 移動日付 | MovementDate | Date | ✔ | Date a product was moved in or out of inventory |
| 社内担当者 | SalesRep_ID | Table | | Sales Representative or Company Agent |
| 説明 | Description | Text | | Optional short description of the record |
| 倉庫 | M_Warehouse_ID | Table Direct | ✔ | Storage Warehouse and Service Point |
| 検討中 | IsInDispute | Yes-No | ✔ | Document is in dispute |
| 受注伝票 | C_Order_ID | Search | | Order |
| 入出荷伝票 | M_InOut_ID | ID | ✔ | Material Shipment Document |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 伝票タイプ | C_DocType_ID | Table Direct | ✔ | Document type or rules |
| 伝票番号 | DocumentNo | String | ✔ | Document sequence number of the document |
| 伝票状態 | DocStatus | List | ✔ | The current status of the document |
| セルフサービス | IsSelfService | Yes-No | ✔ | This is a Self-Service entry or this entry can be changed via Self-Service |
| 請求日付 | DateInvoiced | Date | ✔ | Date printed on Invoice |
| 社内担当者 | SalesRep_ID | Search | | Sales Representative or Company Agent |
| 説明 | Description | Text | | Optional short description of the record |
| 入金済み | IsPaid | Yes-No | ✔ | ONの場合は回収済みを意味し、OFFの場合は未回収を意味する。 |
| 検討中 | IsInDispute | Yes-No | ✔ | Document is in dispute |
| 通貨 | C_Currency_ID | Table Direct | ✔ | The Currency for this record |
| 総合計 | GrandTotal | Amount | ✔ | Total amount of document |
| 受注伝票 | C_Order_ID | Search | | Order |
| 売上請求伝票 | C_Invoice_ID | ID | ✔ | Invoice Identifier |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| 前払 | IsPrepayment | Yes-No | ✔ | The Payment/Receipt is a Prepayment |
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 伝票タイプ | C_DocType_ID | Table Direct | ✔ | Document type or rules |
| 伝票番号 | DocumentNo | String | ✔ | Document sequence number of the document |
| 伝票状態 | DocStatus | List | ✔ | The current status of the document |
| セルフサービス | IsSelfService | Yes-No | ✔ | This is a Self-Service entry or this entry can be changed via Self-Service |
| 取引日付 | DateTrx | Date | ✔ | Transaction Date |
| 銀行口座 | C_BankAccount_ID | Table Direct | | Account at the Bank |
| オンラインアクセス | IsOnline | Yes-No | ✔ | Can be accessed online |
| 通貨 | C_Currency_ID | Table Direct | ✔ | The Currency for this record |
| 御支払金額 | PayAmt | Amount | ✔ | 入金/支払金額 |
| 割引金額 | DiscountAmt | Amount | | Calculated amount of discount |
| 回収不能額 | WriteOffAmt | Amount | | 貸倒損失 |
| 出荷後清算 | IsDelayedCapture | Yes-No | ✔ | Charge after Shipment |
| 売上請求伝票 | C_Invoice_ID | Search | | Invoice Identifier |
| 入金支払伝票 | C_Payment_ID | ID | ✔ | Payment identifier |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 検索キー | Value | String | ✔ | Search key for the record in the format required - must be unique |
| 資産グループ | A_Asset_Group_ID | Search | ✔ | Group of Assets |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | | Optional short description of the record |
| 品目 | M_Product_ID | Search | ✔ | Product, Service, Item |
| 属性セットインスタンス | M_AttributeSetInstance_ID | Product Attribute | ✔ | Product Attribute Set Instance |
| ロット番号 | Lot | String | | Lot number (alphanumeric) |
| シリアルNo | SerNo | String | | Product Serial Number |
| 数量 | Qty | Quantity | | Quantity |
| 使用開始日付 | AssetServiceDate | Date | | Date when Asset was put into service |
| 保証日付 | GuaranteeDate | Date | | Date when guarantee expires |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| リクエストタイプ | R_RequestType_ID | Table Direct | ✔ | Type of request (e.g. Inquiry, Complaint, ..) |
| 伝票番号 | DocumentNo | String | ✔ | Document sequence number of the document |
| グループ | R_Group_ID | Table Direct | | Request Group |
| カテゴリ | R_Category_ID | Table Direct | | Request Category |
| ステータス | R_Status_ID | Table Direct | | Request Status |
| 結果 | R_Resolution_ID | Table Direct | | Request Resolution |
| 優先度 | Priority | List | ✔ | Indicates if this request is of a high, medium or low priority. |
| ユーザー優先度 | PriorityUser | List | | Priority of the issue for the User |
| 社内担当者 | SalesRep_ID | Table | | Sales Representative or Company Agent |
| サマリ | Summary | Text | ✔ | Textual summary of this request |
| 最新実行日 | DateLastAction | Date+Time | | Date this request was last acted on |
| 最新履歴情報 | LastResult | String | | Result of last contact |
| 期限タイプ | DueType | List | ✔ | Status of the next action for this Request |
| 次回対応日付 | DateNextAction | Date+Time | | Date that this request should be acted on |
| Cost Center | C_CostCenter_ID | Table Direct | | |
| Department | C_Department_ID | Table Direct | | |