iDempiere 13 標準ウィンドウ(AD_Window_ID: 293)
メニュー: 取引先管理 ▸ 担当者(エージェント)別取引情報
Company Agent (Sales Rep) Information
This window allows you to view Company agent related information
| # | タブ | テーブル | 階層 | 説明 |
|---|
| 10 | 販売代理 | AD_User | 0 | Sales Representative Selection |
| 20 | 注文書 | C_Order | 1 | All Orders where the Agent “owns” the Order, the Business Partner or the Product |
| 30 | 注文書詳細 | C_OrderLine | 2 | All Order Lines where the Agent “owns” the Order, the Business Partner or the Product |
| 40 | 請求書 | C_Invoice | 1 | All Invoices where the Agent “owns” the Invoice, the Business Partner or the Product |
| 50 | 請求書詳細 | C_InvoiceLine | 2 | All Invoice Liness where the Agent “owns” the Invoice, the Business Partner or the Product |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 名称 | 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_BPartner_ID | Search | | Identifies a Business Partner |
| 取引先住所 | C_BPartner_Location_ID | Table Direct | | Identifies the (ship to) address for this Business Partner |
| Eメール | EMail | String | | Electronic Mail Address |
| タイトル | Title | String | | Name this entity is referred to as |
| 生年月日 | Birthday | Date | | Birthday or Anniversary day |
| 電話番号 | Phone | String | | Identifies a telephone number |
| FAX | Fax | String | | Facsimile number |
| 責任者 | Supervisor_ID | Search | | Supervisor for this user/organization - used for escalation and approval |
| 取引組織 | AD_OrgTrx_ID | Table | | Performing or initiating organization |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | 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 |
| 顧客注文番号 | POReference | String | | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner |
| 説明 | 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 | | キャンペーン、営業活動 |
| 送付済み | IsDelivered | Yes-No | ✔ | |
| 請求済み | IsInvoiced | Yes-No | ✔ | Is this invoiced? |
| 明細行合計 | TotalLines | Amount | ✔ | Total of all document lines |
| 総合計 | GrandTotal | Amount | ✔ | Total amount of document |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 受注伝票 | C_Order_ID | Search | ✔ | Order |
| 明細番号 | Line | Integer | ✔ | Unique line for this document |
| 取引先 | C_BPartner_ID | Search | | Identifies a Business Partner |
| 取引先住所 | C_BPartner_Location_ID | Table Direct | ✔ | Identifies the (ship to) address for this Business Partner |
| 説明 | Description | Text | | Optional short description of the record |
| 注文日付 | DateOrdered | Date | ✔ | Date of Order |
| 納品予定日 | DatePromised | Date | | Date Order was promised |
| 出荷日付 | DateDelivered | Date | | Date when the product was delivered |
| 請求日付 | DateInvoiced | Date | | Date printed on Invoice |
| 倉庫 | M_Warehouse_ID | Table | ✔ | Storage Warehouse and Service Point |
| 品目 | M_Product_ID | Search | | Product, Service, Item |
| 説明のみ | IsDescription | Yes-No | ✔ | if true, the line is just description and no transaction |
| リソースアサイン | S_ResourceAssignment_ID | Assignment | | Resource Assignment |
| 属性セットインスタンス | M_AttributeSetInstance_ID | Product Attribute | ✔ | Product Attribute Set Instance |
| 注文数量 | QtyOrdered | Quantity | ✔ | Ordered Quantity |
| 引当数量 | QtyReserved | Quantity | ✔ | Reserved Quantity |
| 出荷済数量 | QtyDelivered | Quantity | ✔ | Delivered Quantity |
| 請求済数量 | QtyInvoiced | Quantity | ✔ | Invoiced Quantity |
| 通貨 | C_Currency_ID | Table Direct | ✔ | The Currency for this record |
| 税率 | C_Tax_ID | Table Direct | ✔ | Tax identifier |
| 営業定価 | PriceList | Costs+Prices | ✔ | List Price |
| 割引 % | Discount | Number | | Discount in percent |
| 単価 | PriceActual | Costs+Prices | ✔ | Actual Price |
| 行合計 | LineNetAmt | Amount | ✔ | Line Extended Amount (Quantity * Actual Price) without Freight and Charges |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | 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 |
| 顧客注文番号 | POReference | String | | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner |
| 受注伝票 | C_Order_ID | Search | | Order |
| 説明 | 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 |
| 請求日付 | DateInvoiced | Date | ✔ | Date printed on Invoice |
| 転記日付 | DateAcct | Date | ✔ | Accounting Date |
| 注文日付 | DateOrdered | Date | | Date of Order |
| 印刷日付 | DatePrinted | Date | | Date the document was printed. |
| 取引先 | C_BPartner_ID | Search | ✔ | Identifies a Business Partner |
| 取引先住所 | C_BPartner_Location_ID | Table Direct | ✔ | Identifies the (ship to) address for this Business Partner |
| 価格表 | M_PriceList_ID | Table Direct | ✔ | Unique identifier of a Price List |
| 通貨 | C_Currency_ID | Table Direct | ✔ | The Currency for this record |
| 支払方法 | PaymentRule | Payment | ✔ | How you pay the invoice |
| 支払条件 | C_PaymentTerm_ID | Table Direct | ✔ | The terms of Payment (timing, discount) |
| 社内担当者 | SalesRep_ID | Search | | Sales Representative or Company Agent |
| 販売(ON) / 購買(OFF) | IsSOTrx | Yes-No | ✔ | This is a Sales Transaction |
| セルフサービス | IsSelfService | Yes-No | ✔ | This is a Self-Service entry or this entry can be changed via Self-Service |
| プロジェクト | C_Project_ID | Table Direct | | Financial Project |
| 入金済み | IsPaid | Yes-No | ✔ | ONの場合は回収済みを意味し、OFFの場合は未回収を意味する。 |
| 検討中 | IsInDispute | Yes-No | ✔ | Document is in dispute |
| 明細行合計 | TotalLines | Amount | ✔ | Total of all document lines |
| 総合計 | GrandTotal | Amount | ✔ | Total amount of document |
| フィールド | カラム | 型 | 必須 | 説明 |
|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 売上請求伝票 | C_Invoice_ID | Search | ✔ | Invoice Identifier |
| 明細番号 | Line | Integer | ✔ | Unique line for this document |
| 説明 | Description | Text | | Optional short description of the record |
| 料金 | C_Charge_ID | Table Direct | | Additional document charges |
| 品目 | M_Product_ID | Search | | Product, Service, Item |
| 説明のみ | IsDescription | Yes-No | ✔ | if true, the line is just description and no transaction |
| リソースアサイン | S_ResourceAssignment_ID | Assignment | | Resource Assignment |
| 属性セットインスタンス | M_AttributeSetInstance_ID | Product Attribute | ✔ | Product Attribute Set Instance |
| 請求済数量 | QtyInvoiced | Quantity | ✔ | Invoiced Quantity |
| 単価 | PriceActual | Costs+Prices | ✔ | Actual Price |
| 営業定価 | PriceList | Costs+Prices | ✔ | List Price |
| 行合計 | LineNetAmt | Amount | ✔ | Line Extended Amount (Quantity * Actual Price) without Freight and Charges |
| 税額 | TaxAmt | Amount | | Tax Amount for a document |
| 税率 | C_Tax_ID | Table Direct | ✔ | Tax identifier |
| 税込行合計 | LineTotalAmt | Amount | | 税込の行合計金額 |