| assist_unit_f |
辅助单位F |
|
A |
| audit_status |
采购单审核状态 |
|
A |
| base_unit_b |
基础单位B |
|
A |
| batch_number |
批次号 |
|
A |
| bom_version |
BOM版本 |
|
A |
| create_time |
采购单创建时间 |
|
A |
| currency |
货币类型 |
|
A |
| dead_line |
截止日期 |
|
A |
| department_name |
采购单部门名称 |
|
A |
| director_name |
负责人姓名 |
|
A |
| document_status |
采购单单据状态 |
|
A |
| finish_time |
完成时间 |
|
A |
| has_special_price |
是否有特殊价格 |
|
A |
| is_deleted |
是否删除 |
|
A |
| item_category_name |
物料类别名称 |
|
A |
| item_code |
物料编码 |
|
A |
| item_name |
物料名称 |
|
A |
| item_spec |
物料规格 |
|
A |
| item_type |
物料类型 |
|
A |
| new_receive_status |
采购单收货状态 |
[未收料，部分收料，全部收料，超额收料] |
A |
| new_return_status |
采购单退货状态 |
[未退货，部分退货，全部退料] |
A |
| order_product_comment |
采购物料行备注 |
|
A |
| order_product_customized_fields |
采购物料行自定义字段 |
|
A |
| order_product_handle_status |
采购物料行处理状态 |
[未开始,进行中,手动完成:点击物料行完成,自动完成:单据完成导致物料行完成] |
A |
| order_product_new_receive_status |
采购物料行收货状态 |
[未收料，部分收料，全部收料，超额收料] |
A |
| order_product_new_return_status |
采购物料行退货状态 |
[未退货，部分退货，全部退料] |
A |
| pay_condition_name |
支付条件名称 |
|
A |
| procurement_order_customized_fields |
采购订单自定义字段 |
|
A |
| procurement_order_id |
采购订单ID |
|
A |
| procurement_order_number |
采购订单编号 |
|
A |
| procurement_order_product_id |
采购订单产品ID |
|
A |
| procurement_order_shopping_list_id |
采购申请ID |
|
A |
| procurement_order_shopping_list_number |
关联采购申请编号 |
|
A |
| procurement_order_type |
采购订单类型 |
|
A |
| purchase_unit_p |
采购单位P |
|
A |
| real_director_name |
实际负责人姓名 |
|
A |
| sort |
排序 |
|
A |
| supplier_category |
供应商类别 |
|
A |
| supplier_code |
供应商代码 |
|
A |
| supplier_name |
供应商名称 |
|
A |
| tenant_id |
租户ID |
|
A |
| unique_key_update_time |
更新时间 |
|
A |
| warehouse_bin_name |
仓库库位名称 |
|
A |
| warehouse_name |
仓库名称 |
|
A |
| exchange_rate |
汇率 |
|
A |
| extra_price |
额外收费总额 |
|
A |
| inventory_qc_quantity |
库存待质检数，入待检仓 |
|
A |
| inventory_receive_quantity |
库存入库数，入普通仓 |
|
A |
| inventory_return_quantity |
库存退货数 |
|
A |
| origin_price |
原采购总额 |
|
A |
| pending_qc_quantity |
待检仓数量 |
|
A |
| procurement_quantity_b |
采购数B |
|
A |
| procurement_quantity_p |
采购数P |
|
A |
| receive_quantity_b |
实际收料入库数B |
|
A |
| receive_quantity_p |
实际收料入库数P |
|
A |
| return_quantity_b |
退料数B |
|
A |
| return_quantity_p |
退料数P |
|
A |
| tax_amount |
税额 |
|
A |
| tax_excluded_total_price |
未税合计 |
|
A |
| tax_excluded_unit_price |
未税单价 |
|
A |
| tax_included_total_price |
价税合计 |
|
A |
| tax_included_unit_price |
含税单价 |
|
A |
| tax_rate |
税率 |
|
A |
| total_price |
采购单总额 |
|
A |
| requirement_type |
需求类型 |
[空/订单/预测/备库单/安全库存] |
B |
| audit_status |
采购申请审核状态 |
[待审核,审核中,已审核,已完成] |
C |
| creator_id |
采购申请申请人ID |
|
C |
| department_name |
采购申请部门名称 |
|
C |
| director_id |
采购申请负责人ID |
|
C |
| document_status |
采购申请单据状态 |
[未开始,进行中,已完成,已作废] |
C |
| procurement_order_shopping_item_id |
采购申请产品行ID |
|
C |
| procurement_order_shopping_list_id |
采购申请ID(1) |
|
C |
| procurement_order_shopping_list_number |
采购申请编号(1) |
|
C |
| purchase_unit_json |
采购单位和基本单位换算比例 |
|
C |
| relation_order_id |
关联订单号 |
|
C |
| relation_order_number |
关联订单编号 |
|
C |
| relation_order_product_id |
关联订单产品id |
|
C |
| relation_order_type |
关联单据类型 |
[订单,备库单] |
C |
| shopping_item_customized_fields |
采购申请产品行自定义字段 |
|
C |
| shopping_item_dead_line |
采购申请产品行计划交期 |
|
C |
| shopping_item_finished |
采购申请行完成状态 |
[是,否] |
C |
| shopping_item_purchase_status |
采购申请行采购状态 |
[未采购,部分采购,全部采购,超额采购] |
C |
| shopping_item_sort |
采购清单物料行序号 |
|
C |
| shopping_list_comments |
采购申请备注 |
|
C |
| shopping_list_create_time |
采购申请创建时间 |
|
C |
| shopping_list_customized_fields |
采购申请自定义字段 |
|
C |
| shopping_list_dead_line |
采购申请计划交期 |
|
C |
| shopping_list_purchase_status |
采购申请采购状态 |
[未采购,部分采购,全部采购,超额采购] |
C |
| shopping_list_type |
采购申请来源 |
[仓库,物料清单,新建,生产单,MRP,其他] |
C |
| base_unit_quantity |
采购申请计划采购数（基本单位） |
|
C |
| base_unit_shopping_quantity |
采购申请已采购数（基本单位） |
|
C |
| procurement_unit_quantity |
采购申请计划采购数（采购单位） |
|
C |
| procurement_unit_shopping_quantity |
采购申请已采购数（采购单位） |
|
C |