MIS-SZ
Kaga Electronics LTD(ShenZhen) – Kaga WMS Specification
WMS Specification
for
Kaga Electronics ( ShenZhen )
Revision : 1.00
Last Update Date: Oct. 14, 2012, Victor Hu
Program Name : Warehouse Manager System
Document Name: raw.doc Page 1 / 9 Revision: 1.01
MIS-SZ
Kaga Electronics LTD(ShenZhen) – Kaga WMS Specification
1.0 Objective
User requests to print Payment Voucher (Form) after confirm Voucher.
2.0 Detail
Show General Ledger Detail
Sort by supplier
Not print criteria information at last page
Show amount format as >,>>>,>>>,>>9.99
Show approve line every page
3.0 Selection Criteria
4.0 Report Layout
5.0 Example
6.0 Fields Detail
Table 1:kg_inbound <Inbound Master>
No. Field Name Data Type Default Key Label Description
1 ref_no varchar(30) Y Inbound Ref
2 inbound_id integer 0 Inbound ID
<reserve> Auto Increase
3 order_type varchar(8) Order Type Normal/???
4 inv_no varchar(15) 0 Invoice#
5 ship_type varchar(15) Ship Type Local Delivery
6 shipper varchar(32) Shipper Ref kg_shipper table
7 factory varchar(15) Factory Ref kg_fty table
8 inspection varchar(1) ‘N’ Inspection Y/N
9 date_eta date ETA Date
10 date_recvd date Received Date
11 status varchar(15) Status
12 rmks varchar(64) Remark
13 createdon
date
Created On
14 createdby varchar(32) Created By
15
Document Name: raw.doc Page 2 / 9 Revision: 1.01
MIS-SZ
Kaga Electronics LTD(ShenZhen) – Kaga WMS Specification
Table 2: kg_inbounditem <Inbound Detail>
No. Field Name Data Type Default Key Label Description
1 ref_no Varchar(30) Y Inbound Ref Inbound Reference No.
2 inbound_id int
0
Inbound ID System maintance (Auto Increase)
3 location Varchar(15) Location Ref kg_loc table
4 pallet_no varchar(15) Pallet#
5 inventory_no Varchar(30) Inventory#
6 lot_no Varchar(15) Lot#
7 partno_jp varchar(30) Part JP
8 partno_cn varchar(30) Part China
9 partno_kaga varchar(30) Part Kaga
10 prod_name varchar(30) Production Name
11 part_desc1 varchar(30) Desction
12 part_desc2 varchar(30) Description2
13 part_desc3 varchar(30) Description3
14 pono_china varchar(15) China PO
15 pono_kaga varchar(15) Kaga PO
16 qty_order integer 0 Qty Order
17 qty_recvd integer 0 Qty Received
18 qty_upcoming integer 0 Upcoming Qty
19 inv_gw
Decimal(15,5)
0 Invoice G.W.
20 ctn_gw
Decimal(15,5)
0 Carton G.W.
21 dime_l integer 0 Length cm
22 dime_w integer 0 Width cm
23 dime_h integer 0 Height cm
24 carton varchar(15) Carton
25 curr varchar(3) Curr
26 price_orig
Decimal(15,5)
Price Original
27 exr_rate
Decimal(15,5)
Exchange Rate
28 price_base
Decimal(15,5)
Price Base
29 origin varchar(8) Origin
30 rmks varchar(64) Remark
31 createdon date Created On
32 createdby varchar(32) Created By
33 partsn varchar(30)
Part Serial Number
<Unquie>
Document Name: raw.doc Page 3 / 9 Revision: 1.01
- 1
- 2
前往页