Create SKU Master Data

Field

Data Type

Description

Note

sku

string(50)

Product Identifier Code

example : BLJ01

Mandatory

sku_descr_1

string(200)

Product Name (Short Name)

example : Black Long Jacket

Mandatory

sku_descr_2

string(200)

Product Name (Long Name)

example : Black Long Jacket from Bear Skin

Mandatory

sku_high

decimal(18, 4)

Product Height in centimeters

Optional

sku_length

decimal(18, 4)

Product Length in centimeters

Optional

sku_width

decimal(18, 4)

Product Width in centimeters

Optional

gross_weight

decimal(18, 8)

The Weight of the Product after packing in grams

Optional

alternate_sku_a

string(20)

Alternative SKU Product Identifier 1

Optional

alternate_sku_b

string(20)

Alternative SKU Product Identifier 2

Optional

sku_group_1

string(12)

Product Category Code 1

Notes :

if there no category code you can fill same as sku

Mandatory

alternate_sku_c

string(100)

Alternative Product Identifier 3

Please Fill with Empty String

sku_group_2

string(100)

Product Group Code 2

Please Fill with Empty String

easy_code

string(500)

Mnemonic SKU Code / More Readable SKU Code

Please Fill with Empty String

item_code

string(100)

Commodity Code

Please Fill with Empty String

sku_barcode

string(100)

Barcode No

Please Fill with Empty String

net_weight

decimal(18, 8)

The Weight of the Product before packing / Net Weight

Please Fill with 0 (Zero)

tare

decimal(18, 8)

Weight of Empty Container

Please Fill with 0 (Zero)

cube

decimal(18, 8)

Cube

Please Fill with 0 (Zero)

price

decimal(18, 8)

Product Price in Rupiah

Please Fill with 0 (Zero)

freight_class

string(20)

a standardised shipping industry pricing classification.

Please Fill with Empty String

cycle_class

string(1)

-

Please Fill with Empty String

qty_max

Integer

Maximum QTY of SKU

Please Fill with 0 (Zero)

qty_min

Integer

Minimum QTY of SKU

Please Fill with 0 (Zero)

shelf_life_flag

boolean

Validity Period Control

Please Fill with false

shelf_life_type

string(1)

Duration Control Types

Notes:

(E-Expiry Date, M-Manufacturing Date, R-Receiving Date)

Please Fill with Empty String

shelf_life

decimal(18, 0)

Days of validity Period (Expired Date)

Please Fill with 0 (Zero)

shelf_life_alert_days

int

Days of Early Warning for Failure Period

Please Fill with 0 (Zero)

inbound_life_days

int

Inbound Validity Period

Please Fill with 0 (Zero)

outbound_life_days

int

Outbound Validity Period

Please Fill with 0 (Zero)

serial_no_catch

boolean

Whether to Collect Serial Numbers (true/false)

Please Fill with false

over_rcv_percentage

decimal(18, 0)

Percentage of Excess Receipt

Please Fill with 0 (Zero)

kit_flag

boolean

Component Identification (true/false)

Please Fill with false

re_order_qty

Integer

The quantity of product that will be reordered when product is empty

Please Fill with 0 (Zero)

first_op

Boolean

Pharmaceutical - First Batch

Please Fill with false

approval_no

string(20)

Pharmaceutical- Approval Number

Please Fill with Empty String

medical_type

string(15)

Pharmaceutical - Dosage Form

Please Fill with Empty String

medicine_specical_control

boolean

Pharmaceutical - Class II Psychotropic Drugs (true/false)

Please Fill with false

special_maintenance

string(1)

Medical -Maintenance Type (Default GENERAL)

Please Fill with Empty String

second_serial_no_catch

boolean

Medical - Second Sequence Number Scanning (true / false)

Please Fill with false

reserved_field_01

string(200)

Reserved Field 01

Please Fill with Empty String

reserved_field_02

string(200)

Reserved Field 02

Please Fill with Empty String

notes

text

Notes for Product

Please Fill with Empty String

rotationID (default FIFO)

String

Support FIFO or FEFO

Default is FIFO

default_supplier_id

String(10)

Same as Supplier ID in WMS

Default is empty

image_address

String(200)

Image address

Default is empty

capture_serial_no_flag

String(1)

Support Y or N (Capitalize)

Default is N

uom_conversions

uom_name

String(10)

Use Valid UoM Name from Shipper

Optional

uom_qty

decimal(18, 0)

QTY Conversion to EA

Optional