1. 基本信息
| 数据模型名称 | 应收款明细DWD |
|---|---|
| 底表 | dwd_receivable_detail_data |
2. 字段列表
| 原名 | 别名 | 备注说明 |
|---|---|---|
| audit_status | 审核状态 | |
| bill_status | 单据状态 | |
| created_time | 条目创建时间 | |
| customer_code | 客户编号 | |
| customer_name | 客户名称 | |
| delivery_order_number | 发货单号 | |
| document_type | 单据类型 | |
| id | 数据ID | |
| inbound_outbound_number | 出入库单号 | |
| local_currency | 本位币 | |
| material_category | 物料分类 | |
| material_code | 物料编号 | |
| material_name | 物料名称 | |
| material_specification | 物料规格 | |
| original_currency | 原币别 | |
| parent_id | 父类ID | |
| sales_order_number | 销售订单号 | |
| source_document_code | 源单编号 | |
| tenant_id | 租户ID | |
| unit | 单位 | |
| updated_time | 条目最后更新时间 | |
| transaction_date | 日期 | |
| discount_amount | 折扣额 | |
| discount_rate | 折扣率 | |
| exchange_rate | 汇率 | |
| invoice_amount | 开票金额 | |
| local_total_tax_amount | 价税合计本位币金额 | |
| quantity | 数量 | |
| related_invoice_count | 关联开票数 | |
| tax_amount | 税额 | |
| tax_rate | 税率 | |
| tax_unit_price | 含税单价 | |
| total_tax_amount | 价税合计 | |
| total_untaxed_amount | 未税合计 | |
| unrelated_invoice_count | 未关联开票数 | |
| untaxed_unit_price | 未税单价 |