Home
nutrifood_development
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
RAP
id
increments
tahun
integer
tgl_sk
datetime
no_sk
string
cust_desc
string
cust_site_ship_code
string
cust_site_ship_desc
string
kota
string
region
string
brand
string
category
string
product_code
string
product_desc
string
jenis_alokasi
string
top_alokasi
float
harga
float
qty_alokasi
float
tgl_kirim
datetime
qty_kirim
float
value_kirim
float
alokasi_tidak_kirim
float
sisa_alokasi
float
value_sisa_alokasi
float
keterangan
string
filter_alokasi
string
timestamps
timestamps
FSD
id
increments
file_id
string
distributor_code
string
distributor_name
string
no_po
string
status
string
input_date
datetime
pricelist_code
string
requested_delivery_date
string
order_type
string
top_reguler
integer
kubikasi_gimmick
string
kubikasi
string
item_code
string
item_desc
string
avg_sales_value
float
avg_sales_karton
float
stock_qty_karton
float
stock_qty_pcs
float
stock_nilai
float
stock_intransit_karton
float
stock_intransit_nilai
float
order_rumus_karton
float
order_rumus_nilai
float
order_alokasi_karton
float
order_alokasi_nilai
float
total_order_karton
float
total_order_nilai
float
total_order_kubikasi
float
adjusment_distributor_karton
float
adjusment_distributor_nilai
float
adjusment_nfi_karton
float
adjusment_nfi_nilai
float
order_final_karton
float
order_final_nilai
float
order_final_kubikasi
float
stock_gudang
float
stock_qty_karton_ed3
float
stock_qty_pcs_ed3
float
stock_qty_karton_ed6
float
stock_qty_pcs_ed6
float
stock_qty_karton_ed9
float
stock_qty_pcs_ed9
float
discount_retur
float
cash_discount
float
timestamps
timestamps
FOD
id
increments
line_id
integer
fod_no
string
line_no
integer
product_code
string
product_desc
string
order_qty
float
jenis_alokasi
string
discount_pct
float
discount_retur
float
kubikasi
float
tonase
float
filename
string
timestamps
timestamps
cancel_backorder
id
increments
timestamps
timestamps
order_type
string
status
string
item_code
string
item_description
string
order_no
string
ordered_date
datetime
order_qty
float
unit_sales
string
cust_code
string
cust_site_number
integer
cust_desc
string
location
string
Dim_Product
id
increments
product_key
integer
product_id
integer
product_code
string
product_desc
string
principal
string
brand
string
flavor
string
packaging
string
sub_packaging
string
kelompok
string
channel
string
group_nasa
string
item_group
string
item_monitoring
string
sub_brand
string
active_status
string
weight_per_qty
integer
serving_per_qty
integer
kdi_conversional
integer
box_conversional
integer
item_global_desc
string
production_category
string
production_sub_category
string
category
string
lead_time_production
integer
lead_time_quarantine
integer
unit_weight
float
unit_volume
float
source
string
timestamps
timestamps
Dim_Period
id
increments
timestamps
timestamps
period_key
integer
full_date
datetime
year_num
smallInteger
semester_num
tinyInteger
semester_name
string
semester_short_name
string
cawu_num
tinyInteger
cawu_name
string
quarter_num
smallInteger
quarter_name
string
month_num
tinyInteger
month_name
string
mont_short_name
string
week_of_year
tinyInteger
week_of_month
tinyInteger
day_num
smallInteger
day_of_week
integer
day_of_year
integer
day_name
string
full_date_char
string
occasion
string
working_day
string
upload_fsd
id
increments
timestamps
timestamps
tanggal_upload
datetime
nama_file
string
uploader
string
status
string
fod_time
datetime
dist
string
roles
id
increments
role_name
string
status
integer
upload_rap
boolean
upload_fsd
boolean
down_temp_fsd
boolean
upload_tad
boolean
crud_user
boolean
timestamps
timestamps
users
id
increments
name
string
usernmae
string
email
string
password
string
role_id
string
dist
string
timestamps
timestamps
×
Comments for nutrifood_development
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01