In tracezilla Constants are referred to in Liquid filters.
Below you find tables describing constants that can be used in Liquid filters in tracezilla.
Attributes
Attributes can be activated in Company settings and enabled for Stock Keeping Units. Enabled attributes can be assigned to lots.
Attribute name
Code
Eventual description
Aflatoxin B1
aflatoxin_b1
Aflatoxin Total
aflatoxin_total
Age of animal
age_of_animal
Appearance
appearance
Banana Strand/Twigs (per kg)
banana_strands
Black pieces
black_pieces
Burnt/Overcooked Chips (per kg)
burnt_chips
Banana Strand/Twigs (per kg)
banana_strands
Catch Method
catch_method
Coliforms
coliforms
Customs Status
customs_status
Cutting
cutting
Date extended
date_extended
For some product lots, the shelf life may be extended. This field is used to record the old shelf life date as well as the reason for the extension.
Density
density
Diameter
diameter
Effective pH
effective_ph
TBA
Effective temperature
effective_temperature
Enzyme activity
enzyme_activity
EU Tariff Code
eu_tariff_code
EVM (Extraneous Vegetable Material)
evm
EWC code
ewc_code
You can indicate a code from the European Waste Classification. Type in the code in the format XX-XX-XX.
FAO Catch Zone
fao_fishing_area
FAO Species Code
fao_species_code
FFA (as Oleic Acid)
ffa
Flavour & aroma
flavour
GMO’s
gmo
Internal comment
internal
It can be a comment on the individual product lot, for example if the lot may only be used for specific purposes. The comment does not appear on documents.
Ionoizing Radiation
ionizing_radiation
Moisture
moisture
Origin
origin
Breeder
origin_breeder
Farmer/Grower
origin_farm
Packaging
packaging
You can indicate the type of packaging the lot have e.g. 20 bags.
PAH Benzo(a)pyrene
pah_benpyr
PAH Sum of Benzo(a)pyrene, benzo(a)anthracene, chrysene, benzo(b)fluoranthene
pah_sum
Pistol
pistol
Presentation
presentation
Preservation
preservation
Product destination
product_destination
Peroxide Value (PV)
pv
Quality
quality
Salmonella spp
salmonella_spp
Scoville Heat Units (SHU)
shu
Size
size
Specification
specification
State
state
This attribute can be used broadly to describe the condition of the lot - either as a standard value (e.g. frozen, freeze-dried, refrigerated, etc.) or the condition of the individual lot if condition varies between lots.
Storage Bin
storage_bin
You can indicate a storage area for the lot in the warehouse. Storage bin attributes can be assigned to both SKUs with and without traceability.
Storage Bin, loc. 2
storage_bin_loc2
Similar to Storage Bin.
Storage Bin, loc. 3
storage_bin_loc3
Similar to Storage Bin.
Storage Bin, loc. 4
storage_bin_loc4
Similar to Storage Bin.
Supplier SKU
supplier_sku
Texture
texture
Thickness
thickness
Total Mould Count
tmc
Thickness
trim
Total Yeast Count
tyc
Water Activity
water_activity
Whole (w/w)
whole
Customer stages
Customer stages indicate the customer life cycle stages of the partner.
Date type
Code
Description
Active
active
The partner is considered an active customer.
Discovery
discovery
The partner has not been qualified as a lead yet.
Lead
lead
The partner has qualified as a lead that might have an interest in the company’s products/ services.
Opportunity
opportunity
The partner has qualified as an oppertunity that does have an interest in the company’s products/ services.
Prospect
prospect
A concrete oppertunity have been identified and offered to the partner.
Date types
Date type
Code
Description
Availability date
availability_date
The date when the goods will be disposable. Must be the same or after delivery_date.
Delivery date
delivery_date
The date when the order will be delivered.
Order date
order_date
The date when the order was placed.
Payment date
payment_date
The due date of the order.
Pick-up date
pickup_date
The date when the goods will be picked up.
Posting date
posting_date
The posting date of the order.
Order types
Order type
Code
Production
production
Purchase
purchase
Return
return
Sales
sales
Supplier return
supplierreturn
Warehouse
warehouse
Partner roles (to be updated)
| Partner role | Code |
|:————-|:——————|
| Supplier | is_supplier |
| Production | is_producer |
| Invoiced partner | invoice_to |
| Invoiced to | invoice_to |
| Deliver to | deliver_to |
| Forwarder | forwarder |
| Pickup from | pickup_from |
Payment terms
There are several default payment terms for partners.
Payment term
Code
Description
Custom
custom
A due date will need to be specified manualle each time an order or invoice is created.
Net Days
days
Days from the delivery date of the order (pickup date for Ex Works orders).
Net EOW + days
month_days
Days from beginning of next month.
Net EOW (start mon) + days
week_mon_days
Days from coming week (week starting on mondays).
Net EOW (start sun) + days
week_sun_days
Days from the delivery date of the order (pickup date for Ex Works orders).