客户信息表:id、客户编码、客户全称、所属集团、客户仓库位置、收单地址、收货地址、付款条件、联系人、联系人电话、联系人邮箱、状态、税率
ca_custom_info: ID, custom_code, custom_full_name, custom_group, custom_warehouse_location, receipt_address, shipping_address, payment_terms, contact_person, contact_phone_no ,contact_email, status, tax_rate
产品信息表:id、型号、国内型号、描述、类别、单重、每托数量、客户SKU#、状态、型号分类
ca_products_info: ID, product_model, domestic_model, description, category, single_weight, qty_per_pallet, custom_sku, status, class
价格表:id、客户、型号、价格、币种、状态
ca_price_list: ID, custom_code, product_model, price, currency, status
销售订单表:id、客户编码、型号、订单数量、交期、客户PO#、订单号、价格、状态(新建、下发、暂停、删除)、下单模式(EDI、人工)、发货数量、折扣、下单日期、订单备注
ca_sales_order: ID,custom_code, product_model, order_qty, delivery_date,custom_po, order_num, price, status (New, Issued, Pause, Delete), order_mode (EDI, Manual), shipping_qty, discount, order_date, remarks
生产订单表:id、型号、数量、交期、PO#、状态、已入库数量
ca_produce_order: ID, product_model, qty, delivery_date, winhere_po, status, in_qty
条码信息表:id、条码、型号、数量、PO#、合并码
inv_ca_barinfo: ID, batch_num, product_model, quantity, winhere_po, comb_code
库存表:id、条码、仓库、货位、数量、备注、创建日期
inv_core_stock
出入库记录表:id、仓库id、货位、条码、数量、操作人员、操作日期、操作类型(入库、发货、手动入库、手动出库)、备注、箱号
Inventory Record Table: ID, Warehouse ID, Location, Barcode, Quantity, Operator, Operation Date, Operation Type (Inbound, Outbound, Manual Inbound, Manual Outbound), Remarks, Container Number
货位表:id、仓库、货位、说明、状态、备注
Location table: ID, warehouse, location, description, status, remarks
理货单表:id、销售订单id、客户编码、型号、数量、仓库、货位、条码、托号、理货状态(新建、理货、验货、发货)、理货单号、库存id
ca_tally: ID, sales_id, custom_code, product_model, tally_qty, warehouse, location, barcode, pallet_no, status (new, tally, inspection, shipment), tally_no, stock_id
发货单头表:id、客户编码、发货单号、状态(新建、已生成发票)、发货日期、理货单号
ca_ship_head: ID, custom_code, ship_no, status (New, Invoice Generated), ship_date, tally_no
发货单明细表:id、发货单头id、条码、型号、数量、仓库、货位、销售订单id、发票号、发票生成日期、托号
ca_ship_line: id, header_id, barcode, product_model, ship_qty, warehouse, location, sales_id, invoice_no, invoice_date, pallet_no
组托记录表:id、型号、数量、货位、条码、合并码、原库存数量、状态(新建、完成)
ca_comb_rec: ID, product_model, quantity, location, barcode, comb_code, origin_stock_qty, status (new, completed)
销售订单视图,用于销售订单界面,销售订单表关联客户信息表,关联产品信息表,增加发货状态(新建、完成)、未发货数量(数量发货数量)、总金额(数量价格折扣)。
Sales Order View, used for the sales order interface. The sales order table is associated with the customer information table and the product information table, and adds shipping status (new, completed), unshipped quantity (quantity shipped quantity), and total amount (quantity price discount).
销售--发货单视图,用于订单专员出各种单据界面,发货单头表、发货单明细表关联客户信息表,关联产品信息表,关联销售订单表,关联发票信息表,增加总金额(发货数量价格折扣)。
Sales - Shipping Order View, used by order specialists to create various document interfaces. The shipping order header table and shipping order details table are associated with customer information table, product information table, sales order table, and invoice information table, increasing the total amount (shipping quantity price discount).
理货--销售订单视图,用于生成理货单界面,显示未发货订单数量,销售订单表关联客户信息表,关联产品信息表,增加未发货数量(数量发货数量)、重量(单重发货数量)。
Tally - sales order view, used to generate tally order interface, display the quantity of unshipped orders, associate the sales order table with the customer information table, associate with the product information table, and increase the unshipped quantity (quantity shipped quantity) and weight (single weight shipped quantity).
发货--发货单视图(无价格),用于仓库操作人员查询发货单,发货单头表、发货单明细表关联客户信息表,关联产品信息表,关联销售订单表,增加重量(数量发货数量)。
Shipment - Shipment Order View (without price), used by warehouse operators to query shipment orders. The shipment order header table and shipment order details table are associated with the customer information table, product information table, and sales order table to increase weight (quantity shipment quantity).
库存视图,用于仓库操作人员查询库存,库存表关联条码信息表、关联产品信息表、关联发货单明细表、关联理货单表,增加重量(数量发货数量)。
Inventory view, used by warehouse operators to query inventory. The inventory table is associated with barcode information table, product information table, shipping order details table, and tally sheet table, and increases weight (quantity shipping quantity).
出入库查询视图,用于仓库操作人员出入库查询,出入库记录表关联条码信息表。
The inventory query view is used for warehouse operators to query inventory, and the inventory record table is associated with the barcode information table.
未经允许不得转载:lxfamn » 建表英文单词对应(自编)