1. Web Reports Gen2 Report Creation

5Appendix 2

Appendix 2

The following is a list of categories and fields exposed in Web Reports Gen2.
Note: Foreign keys are indicated as " join field" (bold text in the Type column.)

Table Categries and Fields

Categories Fields Type
action_code
DESCRIPTION string
alloc_distribution_mode
DESCRIPTION string
alloc_item_expiry_range_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
EXPIRY_RANGE_HDR_ID join field
FIELD1_CODE string
FIELD2_CODE string
FIELD3_CODE string
FIELD4_CODE string
FIELD5_CODE string
FIELD6_CODE string
ALLOC_ITEM_EXPIRING_BEFORE_DAYS integer
ALLOC_ITEM_EXPIRING_AFTER_DAYS integer
PRIORITY integer
alloc_item_expiry_range_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
RULE_NAME string
RULE_DESCRIPTION string
alloc_method
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ALLOC_METHOD_NAME string
ALLOC_METHOD_DESCRIPTION string
alloc_mode
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
ALLOC_MODE_DESCRIPTION string
REPLEN_ACTIVE_FLG boolean
REPLEN_CASE_PICK_FLG boolean
VAS_FLG boolean
alloc_mode_sequence
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ALLOC_MODE_ID join field
SEQ_NBR integer
LOCATION_TYPE_ID join field
ALLOC_UOM_ID join field
RESTRICT_AREA string
RESTRICT_ALLOC_ZONE string
CARTONIZE_UOM_ID join field
ALLOC_DISTRIBUTION_MODE_ID join field
MHE_SYSTEM_ID join field
IGNORE_ORD_DTL_ATTR_LIST string
INCLUDE_MULTI_SKU_LPN_FLG boolean
ALLOC_METHOD_ID join field
allocation
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ORDER_DTL_ID join field
FROM_INVENTORY_ID join field
TO_INVENTORY_ID join field
STATUS_ID join field
ALLOC_QTY decimal
PACKED_QTY decimal
TYPE_ID join field
WAVE_ID join field
TASK_ID join field
ALLOC_UOM_ID join field
CARTONIZE_UOM_ID join field
TASK_SEQ_NBR integer
OB_LPN_TYPE_ID join field
MHE_SYSTEM_ID join field
PICK_USER string
PICKED_TS datetime
PICK_LOCN_STR string
FINAL_OBLPN_NBR string
IS_PICKING_FLG boolean
WAVE_ALLOC_SEQUENCE_NBR integer
allocation_run_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
RUN_HDR_ID join field
ORDER_DTL_ID join field
ALLOC_QTY decimal
IS_PICKING_FLG boolean
STATUS_ID join field
allocation_run_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
RUN_NBR string
ALLOC_METHOD string
STATUS_ID join field
USE_IB_LPN_NBR_IN_OB boolean
ALLOC_MODE_DESCRIPTION string
MESSAGE_TEXT string
LOCN_SIZE_TYPE_ID join field
WAVE_TEMPLATE_NAME string
TRAILER_TYPE_ID join field
REPLEN_ACTIVE_FLG boolean
REPLEN_CASE_PICK_FLG boolean
VAS_FLG boolean
CURR_STAGE_ID join field
RUN_HOST string
RUN_PID integer
ROUTING_MODE_ID join field
OB_LPN_TYPE_ID join field
CUBING_MODE_ID join field
WAVE_TYPE_ID join field
WAVE_MHE_STATUS_ID join field
CELERY_TASKID string
DEST_FACILITY_CAPACITY_CHECK_FLG boolean
REPLENISHMENT_RULE_NAME string
WAVE_SEARCH_NAME string
ALLOC_ITEM_EXPIRY_RANGE_NAME string
MANIFEST_OBLPNS_BY_ORDER_FLG boolean
PACK_WITH_WAVE_FLG boolean
WAVE_GROUP_RUN_ID join field
allocation_status
DESCRIPTION string
allocation_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
TYPE_NAME string
PROGRAM_TYPE string
answer_input_type
DESCRIPTION string
CODE string
appointment
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
APPT_NBR string
DOCK_TYPE_ID join field
PREFERRED_DOCK_ID join field
ACTUAL_DOCK_NBR string
STATUS_ID join field
PLANNED_START_TS datetime
ARRIVED_TS datetime
DURATION integer
MATCHING_VALUE_TYPE_ID join field
MATCHING_VALUE string
LOAD_ID join field
ESTIMATED_UNITS decimal
CARRIER_INFO string
CHECKIN_TS datetime
CHECKOUT_TS datetime
CUST_REFERENCE_TEXT string
appointment_status
DESCRIPTION string
asset
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
FACILITY_ID join field
ASSET_NBR string
STATUS_ID join field
LPN_TYPE_ID join field
asset_status
DESCRIPTION string
audit_history
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
AUDIT_TYPE_ID join field
CONTAINER_ID join field
AUDIT_USER string
AUDIT_MODE_ID join field
ORDER_NBR string
ORDER_TYPE string
LOAD_NUMBER string
WAVE_NUMBER string
ALLOC_UOM string
PACK_USER string
PICK_USER string
SHIPTO_FAC_CODE string
DEST_FACILITY_CODE string
MANIFEST_NBR string
AUDIT_PALLET_NBR string
EXPECTED_PALLET_NBR string
ALLOC_TYPE_ID join field
LPN_TYPE_ID join field
audit_mode
DESCRIPTION string
audit_status
DESCRIPTION string
audit_type
DESCRIPTION string
auth_user
USERNAME string
FIRST_NAME string
LAST_NAME string
EMAIL string
barcode_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CODE string
barcode_type_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
BARCODE_TYPE_ID join field
SEQ_NBR integer
DESCRIPTION string
PREFIX string
REMOVE_PREFIX_FLG boolean
LENGTH integer
NUMERIC_FLG boolean
batch_number
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
FACILITY_ID join field
BATCH_NBR string
ITEM_ID join field
EXPIRY_DATE date
LOCK_ID join field
billing_item
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
NAME string
HISTORY_ACTIVITY_ID join field
PER_UNIT_RATE decimal
ACTIVITY_GROUP_VALUE string
BILLING_CATEGORY string
bonus_budget
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CAL_YEAR integer
TOTAL_BONUS_AMT float
bonus_group
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
NAME string
FROM_BONUS float
TO_BONUS float
break_by_modifier
DESCRIPTION string
bridge_status
DESCRIPTION string
cc_adjustment_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CC_ADJUSTMENT_HDR_ID join field
GROUP_SEQ_NBR integer
LPN_ID join field
ITEM_ID join field
EXPECTED_QTY decimal
COUNTED_QTY decimal
ADJ_COST decimal
LPN_SCAN boolean
BATCH_NBR_ID join field
EXPIRY_DATE date
SERIAL_NUMBER_ID join field
EXPECTED_LOCN_ID join field
INVN_ATTR_ID join field
UNIT_COST decimal
PRIORITY_DATE date
cc_adjustment_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
FACILITY_ID join field
GROUP_NBR integer
RF_SCREEN_NAME string
STATUS_ID join field
CREATION_TYPE_ID join field
LOCATION_ID join field
TASK_ID join field
RECOUNT_REF_NBR integer
REASON_CODE_ID join field
LOCN_DETAILED_COUNT string
ELIGIBLE_FOR_AUTO_APPROVAL string
RULE_EVALUATED string
cc_adjustment_status
DESCRIPTION string
cc_creation_type
DESCRIPTION string
CREATION_TYPE string
cc_warning
DESCRIPTION string
cal_month
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
NAME string
capacity_check_method
DESCRIPTION string
carrier
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
STD_CARRIER_ID join field
CODE string
DESCRIPTION string
STATUS_ID join field
CARRIER_TYPE_ID join field
ADDRESS_1 string
ADDRESS_2 string
ADDRESS_3 string
LOCALITY string
CITY string
STATE string
ZIP string
COUNTRY string
PHONE_NBR string
EMAIL string
CONTACT string
DEFERRED_CLOSE_FLG boolean
carrier_facility
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CARRIER_ID join field
CONTACT string
INTEGRATION_TYPE_ID join field
ACCOUNT_NBR string
PAYMENT_METHOD_ID join field
LICENSE_OR_METER_NBR string
WSDL_ROOT string
WEBSERVICES_USERNAME string
HUB string
ALLOW_MANIFEST_NO_DIMS_FLG boolean
BILL_3RD_PARTY_CONTACT_ID join field
SHIP_FROM_CONTACT_ID join field
REQUIRE_TRAILER_ASSIGNMENT_FLG boolean
carrier_integration_type
DESCRIPTION string
CONSOLIDATED_MANIFESTING_SUPPORTED_FLG boolean
carrier_lpn
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
SHIP_VIA_ID join field
LPN_ID join field
TRACKING_NBR string
RATE decimal
WEIGHT decimal
MASTER_TRACKING_NBR string
EST_DELIVERY_TS datetime
ROUTE_ID join field
WEBSERVICE_LABEL string
CARRIER_WEBSERVICE_LABEL_TYPE_ID join field
INTERNAL_TRACKING_NBR string
PALLET_MANIFEST_FLG boolean
DRY_ICE_WEIGHT decimal
CUSTOMS_ITN string
carrier_status
DESCRIPTION string
carrier_type
DESCRIPTION string
carrier_webservice_label_type
DESCRIPTION string
check_digit_method
CODE string
DESCRIPTION string
cico_type
DESCRIPTION string
column_order_type
DESCRIPTION string
company
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CODE string
NAME string
ADDRESS_1 string
ADDRESS_2 string
LOCALITY string
CITY string
STATE string
ZIP string
COUNTRY string
COMPANY_TYPE_ID join field
UNIV_ID_1 string
LOGO_IMAGE_FILE string
ACTIVE_FLG boolean
PARENT_COMPANY_ID join field
EDI_PARTNER_NBR string
ADDRESS_3 string
PHONE_NBR string
EMAIL string
CONTACT string
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
LOGO_IMAGE_ID join field
EMPLOYER_NBR string
MAX_ALLOWED_QTY_DECIMAL_SCALE integer
MAX_ALLOWED_WT_VOL_DIM_DECIMAL_SCALE integer
ERP_VENDORID string
company_image
VALUE string
company_parm
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
PARM_KEY string
PARM_VALUE string
CONFIG_TYPE string
company_report_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
REPORT_TYPE_ID join field
DESTINATION_COMPANY_ID join field
REPORT_ATTR_1 string
REPORT_ATTR_2 string
REPORT_ATTR_3 string
REPORT_ATTR_4 string
REPORT_ATTR_5 string
DOC_LABEL_CODE string
WEBREPORT_PATH string
WEBREPORT_FORMAT string
company_type
DESCRIPTION string
CODE string
condition_type
DESCRIPTION string
consolidation_location_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CONSOLIDATION_LOCATION_ID join field
DC_FACILITY_ID join field
DESTINATION_FACILITY_ID join field
contact
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CODE string
NAME string
ADDRESS_1 string
ADDRESS_2 string
ADDRESS_3 string
LOCALITY string
CITY string
STATE string
ZIP string
COUNTRY string
PHONE_NBR_1 string
PHONE_NBR_2 string
FAX_NBR string
EMAIL string
CONTACT string
container
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
CONTAINER_NBR string
STATUS_ID join field
VAS_STATUS_ID join field
CURR_LOCATION_ID join field
PREV_LOCATION_ID join field
PRIORITY_DATE date
TYPE string
PALLET_ID join field
RCVD_SHIPMENT_ID join field
RCVD_TS datetime
RCVD_USER string
WEIGHT decimal
VOLUME decimal
PICK_USER string
PACK_USER string
PUTAWAYTYPE_ID join field
REF_IBLPN_NBR string
REF_SHIPMENT_NBR string
REF_PO_NBR string
REF_OBLPN_NBR string
FIRST_PUTAWAY_TS datetime
PARCEL_BATCH_FLG boolean
LPN_TYPE_ID join field
CART_POSN_NBR integer
AUDIT_STATUS_ID join field
QC_STATUS_ID join field
ASSET_ID join field
ASSET_SEAL_NBR string
PRICE_LABELS_PRINTED boolean
COMMENTS string
ACTUAL_WEIGHT_FLG boolean
LENGTH decimal
WIDTH decimal
HEIGHT decimal
RCVD_TRAILER_NBR string
ORIG_CONTAINER_NBR string
PALLET_POSITION string
container_lock_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CONTAINER_ID join field
LOCK_ID join field
container_status
DESCRIPTION string
container_vas_status
DESCRIPTION string
cost_centre
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
DESCRIPTION string
NAME string
FACILITY_ID join field
cubing_mode
DESCRIPTION string
cw_break
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
NAME string
DURATION integer
COLOR string
cw_user
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
AUTH_USER_ID join field
UNIV_ID_1 string
H_WAGE decimal
H_WAGE_OT decimal
FACILITY_ID join field
COMPANY_ID join field
SHIFT_ID join field
RESTRICT_WORK_AREA boolean
LANG_CODE_ID join field
DEFAULT_LABEL_PRINTER string
IMAGE_FILE string
IMAGE_DATA string
ROWS_PER_PAGE integer
ALTERNATE_USER_NAME string
FAILED_LOGIN_ATTEMPTS integer
LAUNCH_DASHBOARD_ON_LOGIN_FLG boolean
DATE_FORMAT_ID join field
TIME_FORMAT_ID join field
THEME_NAME string
DEFAULT_DOCUMENT_PRINTER string
STAFF_ACCOUNT_LIFE_IN_DAYS integer
cw_user_company
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CW_USER_ID join field
COMPANY_ID join field
cw_user_facility
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CW_USER_ID join field
FACILITY_ID join field
cw_user_work_area_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CW_USER_ID join field
WORK_AREA_ID join field
DEFAULT_FLG boolean
DEFAULT_WORK_AREA_ACTIVITY_ID join field
daily_activity_track
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
WMS_TRANSACTION_ID join field
SKU_LINE_GROUP_ID join field
CAL_DATE date
CW_USER_ID join field
NBR_UNITS integer
NBR_LPNS integer
NBR_PALLETS integer
DURATION integer
daily_activity_track_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
DAILY_ACTIVITY_TRACK_ID join field
PALLET_NBR string
LPN_NBR string
LOCATION string
HANDLING_UOM_ID join field
HANDLING_QTY decimal
IS_PRE_PACK boolean
BEGIN_TS datetime
END_TS datetime
DURATION integer
daily_vas_track
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CAL_DATE date
TEAM_ID join field
QTY integer
SKU_LINE_GROUP_ID join field
daily_vas_user_track
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
DAILY_VAS_TRACK_ID join field
CW_USER_ID join field
DURATION integer
date_format
DESCRIPTION string
PYTHON_FORMAT string
DOJO_FORMAT string
FLEX_FORMAT string
MS_FORMAT string
dest_facility_attributes
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
DEST_FACILITY_ID join field
DAILY_UNIT_CAPACITY decimal
DAILY_WEIGHT_CAPACITY decimal
DAILY_VOLUME_CAPACITY decimal
TOLERANCE_PERCENTAGE integer
CAPACITY_MULTIPLIER integer
destination_location_type
DESCRIPTION string
NAME string
dock
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
DOCK_NBR string
DOCK_TYPE_ID join field
DOCK_REF_NBR string
LOCATION_ID join field
STATUS_ID join field
LOAD_ID join field
ALLOW_XDOCK_WITH_LOCK_FLG boolean
dock_status
DESCRIPTION string
dock_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CODE string
DESCRIPTION string
entity_change_action
DESCRIPTION string
equipment_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CODE string
DESCRIPTION string
facility
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CODE string
NAME string
ADDRESS_1 string
ADDRESS_2 string
LOCALITY string
CITY string
STATE string
ZIP string
COUNTRY string
LANG string
DEFAULT_SHIP_VIA_CODE string
TIME_ZONE_ID join field
BONUS_AMT_PER_USER decimal
FACILITY_TYPE_ID join field
PARENT_COMPANY_ID join field
PRIORITY integer
ADDRESS_3 string
PHONE_NBR string
EMAIL string
CONTACT string
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
ACCEPT_TRANSFER_SHIPMENT_FLG boolean
WMS_MANAGED_FLG boolean
RF_INACTIVE_TIMEOUT_MINUTES integer
facility_company_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
ACTIVE_FLG boolean
facility_parm
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
PROG_KEY string
PARM_KEY string
PARM_VALUE string
CONFIG_TYPE string
facility_type
DESCRIPTION string
CODE string
facility_work_area_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
WORK_AREA_ID join field
group_activity
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
NAME string
DESCRIPTION string
FACILITY_ID join field
harmonized_tariff
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CODE string
COMPANY_ID join field
DESCRIPTION string
hazmat_regulation_type
DESCRIPTION string
CODE string
history_activity
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CODE string
DESCRIPTION string
ib_shipment
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
SHIPMENT_NBR string
STATUS_ID join field
REF_NBR string
SHIPMENT_TYPE_ID join field
LOAD_ID join field
ORIG_SHIPPED_CNTRS integer
VERIFIED_TS datetime
MANIFEST_NBR string
TRAILER_TYPE string
VENDOR_INFO string
ORIGIN_INFO string
ORIGIN_CODE string
ORIG_SHIPPED_UNITS decimal
SHIPPED_DATE date
VERIFIED_USER string
LOCK_ID join field
PARCEL_BATCH_FLG boolean
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
ORIGIN_FACILITY_ID join field
QC_ELIGIBILITY_CHECK_PERFORMED_FLG boolean
SOLD_TO_LEGAL_NAME string
CUST_DATE_1 date
CUST_DATE_2 date
CUST_DATE_3 date
CUST_DATE_4 date
CUST_DATE_5 date
CUST_NUMBER_1 integer
CUST_NUMBER_2 integer
CUST_NUMBER_3 integer
CUST_NUMBER_4 integer
CUST_NUMBER_5 integer
CUST_DECIMAL_1 decimal
CUST_DECIMAL_2 decimal
CUST_DECIMAL_3 decimal
CUST_DECIMAL_4 decimal
CUST_DECIMAL_5 decimal
CUST_SHORT_TEXT_1 string
CUST_SHORT_TEXT_2 string
CUST_SHORT_TEXT_3 string
CUST_SHORT_TEXT_4 string
CUST_SHORT_TEXT_5 string
CUST_SHORT_TEXT_6 string
CUST_SHORT_TEXT_7 string
CUST_SHORT_TEXT_8 string
CUST_SHORT_TEXT_9 string
CUST_SHORT_TEXT_10 string
CUST_SHORT_TEXT_11 string
CUST_SHORT_TEXT_12 string
CUST_LONG_TEXT_1 string
CUST_LONG_TEXT_2 string
CUST_LONG_TEXT_3 string
RETURN_FROM_FACILITY_ID join field
ib_shipment_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
IB_SHIPMENT_ID join field
ITEM_ID join field
CONTAINER_NBR string
SHIPPED_QTY decimal
PRIORITY_DATE date
PO_DTL_ID join field
RECEIVED_QTY decimal
PRE_RECV_QTY decimal
CUST_FIELD_1 string
PALLET_NBR string
PUTAWAYTYPE_ID join field
BATCH_NBR string
EXPIRY_DATE date
RECV_XDOCK_FACILITY_CODE string
LPN_IS_PHYSICAL_PALLET_FLG boolean
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
LPN_WEIGHT decimal
LPN_VOLUME decimal
LPN_LENGTH decimal
LPN_WIDTH decimal
LPN_HEIGHT decimal
LPN_LOCK_CODE string
HOST_SEQ_NBR integer
DTL_RCV_FLG boolean
INVN_ATTR_ID join field
INTERNAL_TEXT_FIELD_1 string
MARKED_FOR_QC_FLG boolean
ORIGINAL_SHIPTO string
RECEIPT_ADVICE_LINE string
CUST_DATE_1 date
CUST_DATE_2 date
CUST_DATE_3 date
CUST_DATE_4 date
CUST_DATE_5 date
CUST_NUMBER_1 integer
CUST_NUMBER_2 integer
CUST_NUMBER_3 integer
CUST_NUMBER_4 integer
CUST_NUMBER_5 integer
CUST_DECIMAL_1 decimal
CUST_DECIMAL_2 decimal
CUST_DECIMAL_3 decimal
CUST_DECIMAL_4 decimal
CUST_DECIMAL_5 decimal
CUST_SHORT_TEXT_1 string
CUST_SHORT_TEXT_2 string
CUST_SHORT_TEXT_3 string
CUST_SHORT_TEXT_4 string
CUST_SHORT_TEXT_5 string
CUST_SHORT_TEXT_6 string
CUST_SHORT_TEXT_7 string
CUST_SHORT_TEXT_8 string
CUST_SHORT_TEXT_9 string
CUST_SHORT_TEXT_10 string
CUST_SHORT_TEXT_11 string
CUST_SHORT_TEXT_12 string
CUST_LONG_TEXT_1 string
CUST_LONG_TEXT_2 string
CUST_LONG_TEXT_3 string
REF_ORDER_NBR string
REF_ORDER_SEQ_NBR integer
LPN_TYPE_ID join field
ib_shipment_status
DESCRIPTION string
ib_shipment_vendor_perf
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
VENDOR_ID join field
IB_SHIPMENT_ID join field
VENDOR_PERF_CODE_ID join field
ITEM_ID join field
IMAGE_FILE string
QTY decimal
UOM_ID join field
IMAGE_DATA string
ib_shipment_container_lock
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
IB_SHIPMENT_ID join field
CONTAINER_NBR string
LOCK_ID join field
ib_shipment_qc
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
IB_SHIPMENT_ID join field
VENDOR_ID join field
ITEM_ID join field
QTY_TO_QC decimal
QTY_MARKED_FOR_QC decimal
ib_shipment_serial_nbr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
FACILITY_ID join field
IB_SHIPMENT_ID join field
ITEM_ID join field
ORIGINAL_SERIAL_NBR string
RECEIVED_SERIAL_NBR string
LPN_NBR string
ib_shipment_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
SHIPMENT_TYPE string
DESCRIPTION string
UNDER_RECEIPT_WARNING_PERCENT integer
OVER_RECEIPT_WARNING_PERCENT integer
OVER_RECEIPT_ERROR_PERCENT integer
RECEIPT_VALIDATION_TYPE_ID join field
ALLOW_EXPIRED_INVN_FLG boolean
BREAK_PREPACKS_FLG boolean
PREVENT_VERIFY_PUTAWAY_OUTSTANDING_FLG boolean
SHIPMENT_VERIF_ORDER_DTL_CANCEL_MODE_ID join field
LPN_QC_PERCENT integer
CAPTURE_RETURNS_INFO_FLG boolean
CARTONIZED_RCVNG_BATCH_EXP_PROMPT_ID join field
CARTONIZED_RCVNG_INVN_ATTR_PROMPT_ID join field
CARTONIZED_RCVNG_SERIAL_NBR_PROMPT_ID join field
NON_CARTONIZED_RCVNG_BATCH_EXP_PROMPT_ID join field
NON_CARTONIZED_RCVNG_INVN_ATTR_PROMPT_ID join field
interface_format_type
DESCRIPTION string
CODE string
interface_protected_field
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
INTERFACE_TYPE_ID join field
interface_protocol
DESCRIPTION string
CODE string
interface_type
DESCRIPTION string
CODE string
TYPE string
inventory
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
ITEM_ID join field
LOCATION_ID join field
CONTAINER_ID join field
PRIORITY_DATE date
CURR_QTY decimal
ORIG_QTY decimal
PACK_QTY decimal
CASE_QTY decimal
STATUS_ID join field
MANUFACTURE_DATE date
EXPIRY_DATE date
BATCH_NUMBER_ID join field
INVN_ATTR_ID join field
inventory_attribute
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
FACILITY_ID join field
INVN_ATTR_A string
INVN_ATTR_B string
INVN_ATTR_C string
INVN_ATTR_D string
INVN_ATTR_E string
INVN_ATTR_F string
INVN_ATTR_G string
INVN_ATTR_H string
INVN_ATTR_I string
INVN_ATTR_J string
INVN_ATTR_K string
INVN_ATTR_L string
INVN_ATTR_M string
INVN_ATTR_N string
INVN_ATTR_O string
inventory_history
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
GROUP_NBR integer
SEQ_NBR integer
STATUS_ID join field
HISTORY_ACTIVITY_ID join field
REASON_CODE_ID join field
LOCK_CODE string
CONTAINER_NBR string
LOCATION string
TO_CONTAINER_NBR string
TO_LOCATION string
ITEM_CODE string
ITEM_ALTERNATE_CODE string
ITEM_PART_A string
ITEM_PART_B string
ITEM_PART_C string
ITEM_PART_D string
ITEM_PART_E string
ITEM_PART_F string
HOST_AWARE_ITEM_FLG boolean
SYSTEM_GENERATED_FLG boolean
ITEM_DESCR string
SHIPMENT_NBR string
TRAILER_NBR string
PO_NBR string
PO_LINE_NBR integer
VENDOR_CODE string
ORDER_NBR string
ORDER_SEQ_NBR integer
TO_FACILITY_CODE string
ORIG_QTY decimal
ADJ_QTY decimal
CONTAINERS_SHIPPED integer
CONTAINERS_RECEIVED integer
UNITS_SHIPPED decimal
UNITS_RECEIVED decimal
REF_CODE_1 string
REF_VALUE_1 string
REF_CODE_2 string
REF_VALUE_2 string
REF_CODE_3 string
REF_VALUE_3 string
REF_CODE_4 string
REF_VALUE_4 string
REF_CODE_5 string
REF_VALUE_5 string
REF_CODE_6 string
REF_VALUE_6 string
REF_CODE_7 string
REF_VALUE_7 string
REF_CODE_8 string
REF_VALUE_8 string
REF_CODE_9 string
REF_VALUE_9 string
REF_CODE_10 string
REF_VALUE_10 string
REF_CODE_11 string
REF_VALUE_11 string
REF_CODE_12 string
REF_VALUE_12 string
ITEM_ID join field
INVN_ATTR_A string
INVN_ATTR_B string
INVN_ATTR_C string
SHIPMENT_LINE_NBR integer
SERIAL_NBR string
ORDER_ID join field
IB_SHIPMENT_ID join field
INVN_ATTR_D string
INVN_ATTR_E string
INVN_ATTR_F string
INVN_ATTR_G string
WORK_ORDER_NBR string
WORK_ORDER_SEQ_NBR integer
MODULE_NAME string
SCREEN_NAME string
ORDER_TYPE string
SHIPMENT_TYPE string
PO_TYPE string
BILLING_LOCATION_TYPE string
INVN_ATTR_H string
INVN_ATTR_I string
INVN_ATTR_J string
INVN_ATTR_K string
INVN_ATTR_L string
INVN_ATTR_M string
INVN_ATTR_N string
INVN_ATTR_O string
REF_CODE_13 string
REF_VALUE_13 string
REF_CODE_14 string
REF_VALUE_14 string
REF_CODE_15 string
REF_VALUE_15 string
REF_CODE_16 string
REF_VALUE_16 string
REF_CODE_17 string
REF_VALUE_17 string
REF_CODE_18 string
REF_VALUE_18 string
REF_CODE_19 string
REF_VALUE_19 string
REF_CODE_20 string
REF_VALUE_20 string
CELERY_TASKID string
LOCK_CODE_PRIORITY integer
PREV_ERP_BUCKET string
CURRENT_ERP_BUCKET string
PREV_ATPABLE_FLG boolean
CURRENT_ATPABLE_FLG boolean
PREV_NETTABLE_FLG boolean
CURRENT_NETTABLE_FLG boolean
PREV_RESERVABLE_FLG boolean
CURRENT_RESERVABLE_FLG boolean
inventory_history_activity_parameters
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
INVENTORY_HISTORY_ACTIVITY_ID join field
SUPPORTS_SPLIT_BY_SERIAL_NBR_FLG boolean
ENABLE_SPLIT_BY_SERIAL_NBR_FLG boolean
AUTO_PROCESS_FLG boolean
REALTIME_PROCESS_FLG boolean
inventory_lock
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
LOCK_CODE string
LOCK_DESCRIPTION string
ALLOCATABLE_FOR_ORDER boolean
UNLOCK_ON_LOCATE_TO_RESERVE boolean
TREAT_AS_ATTRIBUTE string
ALLOW_MULTIPLE_LOCK_CODES_FLG boolean
GENERATE_INV_ADJ_FLG boolean
ALLOW_LOADING_FLG boolean
ALLOW_MANIFESTING_FLG boolean
PREVENT_PUTAWAY_FLG boolean
COPY_TO_TRANSFER_SHIPMENT_FLG boolean
PREVENT_DIRECT_CONSUME_FLG boolean
ATTRIBUTE_TRANSFER_CODE string
ERP_BUCKET string
LOCK_CODE_PRIORITY integer
IS_ATPABLE_FLG boolean
IS_NETTABLE_FLG boolean
IS_RESERVABLE_FLG boolean
inventory_status
DESCRIPTION string
invoice
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
INVOICE_NBR string
BILL_FROM_TS datetime
BILL_TO_TS datetime
TOTAL_BILLED_AMT decimal
STATUS_ID join field
BILLING_CATEGORY string
invoice_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
INVOICE_ID join field
BILLING_ITEM_NAME string
HISTORY_ACTIVITY_ID join field
UNIT_RATE decimal
NUM_UNITS decimal
BILLED_AMT decimal
MANUAL_FLG boolean
BILLING_CATEGORY string
ACTIVITY_GROUP_NAME string
ACTIVITY_GROUP_VALUE string
invoice_status
DESCRIPTION string
item
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CALCULATED_CODE string
PART_A string
PART_B string
PART_C string
PART_D string
PART_E string
PART_F string
ITEM_ALTERNATE_CODE string
DESCRIPTION string
SHORT_DESCR string
PUTAWAYTYPE_ID join field
BARCODE string
UNIT_COST decimal
UNIT_LENGTH decimal
UNIT_WIDTH decimal
UNIT_HEIGHT decimal
UNIT_WEIGHT decimal
UNIT_VOLUME decimal
HAZMAT boolean
SKU_LINE_ID join field
EXTERNAL_STYLE string
VAS_GROUP_CODE string
PRE_PACK_CODE string
HOST_AWARE_ITEM_FLG boolean
IS_PARENT_FLG boolean
MOD_INTERFACE_FLG boolean
DUMMY_SKU_FLG boolean
CUBISCAN_MOD_TS datetime
DESCRIPTION_2 string
DESCRIPTION_3 string
INVN_ATTR_A_TRACKING_ID join field
INVN_ATTR_A_DFLT_VALUE string
INVN_ATTR_B_TRACKING_ID join field
INVN_ATTR_B_DFLT_VALUE string
INVN_ATTR_C_TRACKING_ID join field
INVN_ATTR_C_DFLT_VALUE string
NMFC_CODE string
CONVERSION_FACTOR integer
INVN_ATTR_D_TRACKING_ID join field
INVN_ATTR_E_TRACKING_ID join field
INVN_ATTR_F_TRACKING_ID join field
INVN_ATTR_G_TRACKING_ID join field
IMAGE_ID join field
PACKING_TOLERANCE_PERCENT decimal
HANDLE_DECIMAL_QTY_FLG boolean
PACK_WITH_WAVE_FLG boolean
item_assignment_type
DESCRIPTION string
CODE string
item_barcode
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ITEM_ID join field
BARCODE string
UOM_ID join field
QTY_PER_UOM decimal
item_characteristics
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ITEM_ID join field
RECV_TYPE string
OB_LPN_TYPE string
OB_LPN_TYPE_ID join field
CATCH_WEIGHT_METHOD string
ORDER_CONSOLIDATION_ATTR string
SEASON_CODE string
BRAND_CODE string
CUST_ATTR_1 string
CUST_ATTR_2 string
STACKABILITY_CODE string
MIN_DISPATCH_UOM_ID join field
REQ_BATCH_NBR_FLG boolean
SERIAL_NBR_TRACKING_ID join field
BATCH_HANDLING_RECEIVING_ID join field
EXPIRY_HANDLING_RECEIVING_ID join field
CONVEYABLE boolean
SORTABLE boolean
VELOCITY_CODE string
REGULARITY_CODE string
HARMONIZED_TARIFF_ID join field
FULL_OBLPN_TYPE string
CASE_OBLPN_TYPE string
PACK_OBLPN_TYPE string
UN_NUMBER string
UN_CLASS string
UN_DESCRIPTION string
PACKING_GROUP string
PROPER_SHIPPING_NAME string
EXCEPTED_QTY_INSTR string
LIMITED_QTY_FLG boolean
FULLDG_FLG boolean
HAZARD_STATEMENT string
SHIPPING_TEMPERATURE_INSTR string
CARRIER_COMMODITY_DESCRIPTION string
HAZMAT_PACKAGING_DESCRIPTION string
item_facility
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
ITEM_ID join field
PREFERRED_AREA string
PREFERRED_AISLE string
PUTAWAYTYPE_ID join field
CONVEYABLE boolean
OB_LPN_BREAK_ATTR string
ACTIVE_LOCN_TYPE string
DEFAULT_MAX_LOCATIONS_PER_REPLEN_ZONE integer
MOD_INTERFACE_FLG boolean
REPLENISHMENT_TYPE_ID join field
SHOWROOM_MIN decimal
SHOWROOM_MAX decimal
DESCRIPTION string
item_facility_material_hazard_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ITEM_FACILITY_ID join field
MATERIAL_HAZARD_TYPE_ID join field
item_group_defn
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CODE string
DESCRIPTION string
item_hierarchy_defn
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
LEVEL integer
CODE string
DESCRIPTION string
PARENT_ID join field
item_image
VALUE string
item_material_hazard_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ITEM_ID join field
MATERIAL_HAZARD_TYPE_ID join field
item_metrics
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ITEM_ID join field
RETAIL_PRICE decimal
NET_COST decimal
CURRENCY_CODE string
STD_PACK_QTY decimal
STD_PACK_LENGTH decimal
STD_PACK_WIDTH decimal
STD_PACK_HEIGHT decimal
STD_PACK_WEIGHT decimal
STD_PACK_VOLUME decimal
STD_CASE_QTY decimal
MAX_CASE_QTY decimal
STD_CASE_LENGTH decimal
STD_CASE_WIDTH decimal
STD_CASE_HEIGHT decimal
STD_CASE_WEIGHT decimal
STD_CASE_VOLUME decimal
DIMENSION1 decimal
DIMENSION2 decimal
DIMENSION3 decimal
LPNS_PER_TIER integer
TIERS_PER_PALLET integer
PRODUCT_LIFE integer
PERCENT_ACCEPTABLE_PRODUCT_LIFE integer
SHIPPING_CONVERSION_FACTOR decimal
SHIPPING_UOM string
item_pre_pack
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
PARENT_ITEM_ID join field
SEQ_NBR integer
CHILD_ITEM_ID join field
CHILD_UNITS decimal
PRE_PACK_WEIGHT decimal
PRE_PACK_VOLUME decimal
PRE_PACK_LENGTH decimal
PRE_PACK_WIDTH decimal
PRE_PACK_HEIGHT decimal
PRE_PACK_STD_CASE_QTY decimal
PRE_PACK_MAX_CASE_QTY decimal
SCRAP_PERCENTAGE integer
KITTING_INSTRUCTION string
item_struct
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ITEM_ID join field
HIERARCHY_1_ID join field
HIERARCHY_2_ID join field
HIERARCHY_3_ID join field
HIERARCHY_4_ID join field
HIERARCHY_5_ID join field
GROUP_ID join field
lpn_audit_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
AUDIT_HISTORY_ID join field
ITEM_ID join field
ORIG_QTY decimal
AUDIT_QTY decimal
INVENTORY_PACK_QTY decimal
INVENTORY_CASE_QTY decimal
AUDIT_PALLET_NBR string
BATCH_NBR string
label_template
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
LABEL_TYPE_ID join field
DEST_COMPANY_ID join field
SHIP_VIA_ID join field
ORDER_TYPE_ID join field
TEMPLATE_NAME string
NBR_LABELS_PER_ROW integer
ASN_TYPE_ID join field
ALLOC_TYPE_ID join field
ORDER_CUST_FIELD_1 string
ORDER_CUST_FIELD_2 string
ORDER_CUST_FIELD_3 string
ORDER_CUST_FIELD_4 string
ORDER_CUST_FIELD_5 string
label_type
DESCRIPTION string
CODE string
lang_code
LANG_CODE string
DESCRIPTION string
load
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
LOAD_NBR string
STATUS_ID join field
TYPE string
DRIVER string
SEAL_NBR string
PRO_NBR string
FIRST_LOAD_TS datetime
LAST_LOAD_TS datetime
ROUTE_NBR string
TRAILER_TYPE_ID join field
FIRST_GDR_NBR string
FREIGHT_CLASS string
TOTAL_WEIGHT decimal
TOTAL_VOLUME decimal
TOTAL_SHIPPING_CHARGE decimal
EST_DEPARTURE_TS datetime
SCHED_DELIVERY_TS datetime
BOL_NBR string
CARRIER_ID join field
TRAILER_ID join field
ACT_DEPARTURE_TS datetime
ACT_ARRIVAL_TS datetime
EXTERNALLY_PLANNED_LOAD_NBR string
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
CUST_FIELD_6 string
CUST_FIELD_7 string
CUST_FIELD_8 string
CUST_FIELD_9 string
CUST_FIELD_10 string
load_gdd
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
LOAD_ID join field
PRINT_NBR integer
INTERFACE_TS datetime
load_gdd_nbr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
LOAD_GDD_ID join field
ORDER_ID join field
GDD_NBR string
load_status
DESCRIPTION string
location
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
DEDICATED_COMPANY_ID join field
AREA string
AISLE string
BAY string
LEVEL string
POSITION string
BIN string
TYPE_ID join field
ALLOW_MULTI_SKU boolean
BARCODE string
DESTINATION_COMPANY_ID join field
LENGTH decimal
WIDTH decimal
HEIGHT decimal
MAX_UNITS decimal
MAX_LPNS integer
TO_BE_COUNTED_FLG boolean
TO_BE_COUNTED_TS datetime
LOCK_CODE_ID join field
LOCK_FOR_PUTAWAY_FLG boolean
PICK_SEQ string
LAST_COUNT_TS datetime
LAST_COUNT_USER string
LOCN_SIZE_TYPE_ID join field
MIN_UNITS decimal
ALLOW_RESERVE_PARTIAL_PICK_FLG boolean
ALLOC_ZONE string
LOCN_STR string
PUTAWAY_SEQ string
REPLENISHMENT_ZONE_ID join field
MIN_VOLUME decimal
MAX_VOLUME decimal
RESTRICT_BATCH_NBR_FLG boolean
ITEM_ASSIGNMENT_TYPE_ID join field
ITEM_ID join field
MHE_SYSTEM_ID join field
PICK_ZONE string
DIVERT_LANE string
TASK_ZONE_ID join field
IN_TRANSIT_UNITS decimal
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
RESTRICT_INVN_ATTR_FLG boolean
ASSEMBLY_FLG boolean
BILLING_LOCATION_TYPE string
MIN_WEIGHT decimal
MAX_WEIGHT decimal
location_size_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
SIZE_TYPE string
DESCRIPTION string
location_type
CODE string
DESCRIPTION string
lpn_movement
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
TASK_ID join field
SEQ_NBR integer
LPN_ID join field
PALLET_ID join field
FINAL_LOCN_ID join field
STATUS_ID join field
WAVE_ID join field
lpn_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CODE string
DESCRIPTION string
MAX_VOLUME decimal
MAX_WEIGHT decimal
PREFIX string
EMPTY_WEIGHT decimal
LENGTH decimal
WIDTH decimal
HEIGHT decimal
USE_FOR_CUBING_FLG boolean
LPN_TYPE_CLASS string
DRY_ICE_WEIGHT decimal
material_hazard_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CODE string
mhe_destination_code
DESCRIPTION string
mhe_lane
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
MHE_DESTINATION_CODE_ID join field
DESTINATION_VALUE string
DIVERT_LANE string
mhe_msg_type
DESCRIPTION string
MSG_DIRECTION string
mhe_system
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
MHE_TYPE_ID join field
MHE_VENDOR_CODE string
CODE string
DESCRIPTION string
WEIGHT_OVERRIDE boolean
MHE_ATTR_1 string
MHE_ATTR_1_DESC string
MHE_ATTR_2 string
MHE_ATTR_2_DESC string
MHE_ATTR_3 string
MHE_ATTR_3_DESC string
MHE_ATTR_4 string
MHE_ATTR_4_DESC string
MHE_ATTR_5 string
MHE_ATTR_5_DESC string
ORDER_DTL_MATCH_FIELD string
ORDER_DTL_MATCH_VALUE string
WEIGHT_TOLERANCE decimal
MHE_ATTR_6 string
MHE_ATTR_6_DESC string
MHE_ATTR_7 string
MHE_ATTR_7_DESC string
MHE_ATTR_8 string
MHE_ATTR_8_DESC string
MHE_ATTR_9 string
MHE_ATTR_9_DESC string
MHE_ATTR_10 string
MHE_ATTR_10_DESC string
USE_CONSOL_DISTR_ALLOCS_FLG boolean
GROUPING_SIZE integer
CLOSE_ACTION_MAX_WAIT_SECONDS integer
COMPLETE_ACTION_MAX_WAIT_SECONDS integer
mhe_type
DESCRIPTION string
multi_field_barcode_class
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CODE string
ENABLED_FLG boolean
PREFIX_SPECIAL_CHAR_ID join field
PREFIX_TEXT string
STRIP_PREFIX_TEXT_FLG boolean
DEFAULT_MFB_CODE string
PREFIX_SEPARATOR string
multi_field_barcode_class_field
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
MULTI_FIELD_BARCODE_CLASS_ID join field
FIELD_IDENTIFIER string
FIELD_NAME string
MAX_LENGTH integer
CHECK_DIGIT_ID join field
BARCODE_TYPE_ID join field
NUMERIC_FLG boolean
FIXED_WIDTH_FLG boolean
DELIMITER_ID join field
DELIMITER_TEXT string
STRIP_CHECK_DIGIT_FLG boolean
DATE_FORMAT_ID join field
multi_field_barcode_delimiter
CODE string
DESCRIPTION string
ASCII_VALUE integer
ob_stop
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
LOAD_ID join field
SEQ_NBR integer
SHIPTO_FACILITY_ID join field
SHIPTO_NAME string
SHIPTO_ADDR string
STAGE_LOCATION_ID join field
BOL_NBR string
TOTAL_WEIGHT decimal
TOTAL_VOLUME decimal
TOTAL_SHIPPING_CHARGE decimal
STATUS_ID join field
SEAL_NBR string
ob_stop_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
OB_STOP_ID join field
CONTAINER_ID join field
BOL_NBR string
oblpn_printing_validation
DESCRIPTION string
CODE string
oblpn_restriction
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
FACILITY_ID join field
PA_TYPE1_ID join field
PA_TYPE2_ID join field
order_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ORDER_ID join field
SEQ_NBR integer
ITEM_ID join field
ORD_QTY decimal
ORIG_ORD_QTY decimal
ALLOC_QTY decimal
REQ_CNTR_NBR string
PO_NBR string
SHIPMENT_NBR string
DEST_FACILITY_ATTR_A string
DEST_FACILITY_ATTR_B string
DEST_FACILITY_ATTR_C string
REF_NBR_1 string
VAS_ACTIVITY_CODE string
COST decimal
SALE_PRICE decimal
HOST_OB_LPN_NBR string
SPL_INSTR string
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
BATCH_NUMBER_ID join field
CUST_FIELD_4 string
CUST_FIELD_5 string
VOUCHER_NBR string
VOUCHER_AMOUNT decimal
VOUCHER_EXP_DATE date
REQ_PALLET_NBR string
LOCK_CODE string
SERIAL_NBR string
VOUCHER_PRINT_COUNT integer
CUST_DATE_1 date
CUST_DATE_2 date
CUST_DATE_3 date
CUST_DATE_4 date
CUST_DATE_5 date
CUST_NUMBER_1 integer
CUST_NUMBER_2 integer
CUST_NUMBER_3 integer
CUST_NUMBER_4 integer
CUST_NUMBER_5 integer
CUST_DECIMAL_1 decimal
CUST_DECIMAL_2 decimal
CUST_DECIMAL_3 decimal
CUST_DECIMAL_4 decimal
CUST_DECIMAL_5 decimal
CUST_SHORT_TEXT_1 string
CUST_SHORT_TEXT_2 string
CUST_SHORT_TEXT_3 string
CUST_SHORT_TEXT_4 string
CUST_SHORT_TEXT_5 string
CUST_SHORT_TEXT_6 string
CUST_SHORT_TEXT_7 string
CUST_SHORT_TEXT_8 string
CUST_SHORT_TEXT_9 string
CUST_SHORT_TEXT_10 string
CUST_SHORT_TEXT_11 string
CUST_SHORT_TEXT_12 string
CUST_LONG_TEXT_1 string
CUST_LONG_TEXT_2 string
CUST_LONG_TEXT_3 string
SHIP_REQUEST_LINE string
UNIT_DECLARED_VALUE decimal
EXTERNALLY_PLANNED_LOAD_NBR string
INVN_ATTR_ID join field
INTERNAL_TEXT_FIELD_1 string
ORIG_ITEM_CODE string
ERP_SOURCE_LINE_REF string
ERP_SOURCE_SHIPMENT_REF string
ERP_FULFILLMENT_LINE_REF integer
TMS_ORDER_DTL_REF string
SALES_ORDER_SCHEDULE_REF string
SALES_ORDER_LINE_REF string
order_dtl_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ORDER_DTL_ID join field
ORIG_ORDER_DTL_ID join field
ALLOC_QTY decimal
order_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
ORDER_NBR string
ORDER_TYPE_ID join field
STATUS_ID join field
ORD_DATE date
EXP_DATE date
REQ_SHIP_DATE date
DEST_FACILITY_ID join field
SHIPTO_FACILITY_ID join field
CUST_NAME string
CUST_ADDR string
CUST_ADDR2 string
CUST_ADDR3 string
REF_NBR string
STAGE_LOCATION_ID join field
CUST_NBR string
CUST_CITY string
CUST_STATE string
CUST_ZIP string
CUST_COUNTRY string
CUST_PHONE_NBR string
CUST_EMAIL string
SHIPTO_NAME string
SHIPTO_ADDR string
SHIPTO_ADDR2 string
SHIPTO_ADDR3 string
SHIPTO_CITY string
SHIPTO_STATE string
SHIPTO_ZIP string
SHIPTO_COUNTRY string
SHIPTO_PHONE_NBR string
SHIPTO_EMAIL string
SHIP_VIA_REF_CODE string
ROUTE_NBR string
EXTERNAL_ROUTE string
DESTINATION_COMPANY_ID join field
SHIP_VIA_ID join field
PRIORITY integer
HOST_ALLOCATION_NBR string
SALES_ORDER_NBR string
SALES_CHANNEL string
CUSTOMER_PO_NBR string
CARRIER_ACCOUNT_NBR string
PAYMENT_METHOD_ID join field
DEST_DEPT_NBR string
START_SHIP_DATE date
STOP_SHIP_DATE date
VAS_GROUP_CODE string
SPL_INSTR string
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CURRENCY_CODE string
RECORD_ORIGIN_CODE string
CUST_CONTACT string
SHIPTO_CONTACT string
CUST_FIELD_4 string
CUST_FIELD_5 string
OB_LPN_TYPE string
OB_LPN_TYPE_ID join field
TOTAL_ORIG_ORD_QTY decimal
ORIG_SKU_COUNT integer
ORIG_SALE_PRICE decimal
GIFT_MSG string
SCHED_SHIP_DATE date
CUSTOMER_PO_TYPE string
CUSTOMER_VENDOR_CODE string
CUST_DATE_1 date
CUST_DATE_2 date
CUST_DATE_3 date
CUST_DATE_4 date
CUST_DATE_5 date
CUST_NUMBER_1 integer
CUST_NUMBER_2 integer
CUST_NUMBER_3 integer
CUST_NUMBER_4 integer
CUST_NUMBER_5 integer
CUST_DECIMAL_1 decimal
CUST_DECIMAL_2 decimal
CUST_DECIMAL_3 decimal
CUST_DECIMAL_4 decimal
CUST_DECIMAL_5 decimal
CUST_SHORT_TEXT_1 string
CUST_SHORT_TEXT_2 string
CUST_SHORT_TEXT_3 string
CUST_SHORT_TEXT_4 string
CUST_SHORT_TEXT_5 string
CUST_SHORT_TEXT_6 string
CUST_SHORT_TEXT_7 string
CUST_SHORT_TEXT_8 string
CUST_SHORT_TEXT_9 string
CUST_SHORT_TEXT_10 string
CUST_SHORT_TEXT_11 string
CUST_SHORT_TEXT_12 string
CUST_LONG_TEXT_1 string
CUST_LONG_TEXT_2 string
CUST_LONG_TEXT_3 string
EXTERNALLY_PLANNED_LOAD_FLG boolean
WORK_ORDER_KIT_ID join field
ORDER_NBR_TO_REPLACE string
STOP_SHIP_FLG boolean
LPN_TYPE_CLASS string
BILLTO_CARRIER_ACCOUNT_NBR string
DUTIES_CARRIER_ACCOUNT_NBR string
DUTIES_PAYMENT_METHOD_ID join field
CUSTOMS_BROKER_CONTACT_ID join field
ORDER_SHIPPED_TS datetime
ERP_SOURCE_HDR_REF string
ERP_SOURCE_SYSTEM_REF string
TMS_ORDER_HDR_REF string
GROUP_REF string
order_instruction_level
DESCRIPTION string
order_instruction_type
CODE string
DESCRIPTION string
order_instructions
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ORDER_ID join field
INSTR_CODE string
INSTR_TYPE_ID join field
ORDER_DTL_ID join field
INSTR_DESC string
ORDER_INSTR_LEVEL_ID join field
order_lock
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
LOCK_CODE string
LOCK_DESCRIPTION string
ALLOW_ALLOCATE_FLG boolean
order_lock_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ORDER_ID join field
ORDER_LOCK_ID join field
COMMENTS string
order_status
DESCRIPTION string
order_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
ORDER_TYPE string
DESCRIPTION string
DEST_FACILITY_FLG boolean
FLOWTHROUGH_FLG boolean
WAVE_FLG boolean
PARTIAL_ALLOCATION_FLG boolean
ONLY_DEALLOCATE_ON_SHORT_FLG boolean
ASN_PERCENT_PO_UOM_ID join field
GDD_PRINTING boolean
ALLOCATE_DURING_PICK_FLG boolean
WORK_ORDER_TYPE_ID join field
BREAK_PREPACKS_FLG boolean
SINGLE_ORDER_ON_MULTIPLE_LOAD_ID join field
LOCK_ID join field
BLOCK_PACKING_MANIFEST_FLG boolean
RETURNS_ASN_SHIPMENT_TYPE_ID join field
ALLOW_EXPIRED_INVENTORY_FLG boolean
order_type_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ORDER_TYPE_ID join field
SEQ_NBR integer
WORK_AREA_ID join field
order_validation_mode
DESCRIPTION string
output_interface
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
INTERFACE_TYPE_ID join field
FILENAME string
SOURCE_DIR string
CELERY_TASKID string
RETRY_COUNT integer
STATUS_ID join field
MESSAGE string
ARCHIVE_PATH string
CUST_INTF_CODE string
pallet
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
PALLET_NBR string
CURR_LOCATION_ID join field
PREV_LOCATION_ID join field
STATUS_ID join field
IS_LPN_FLG boolean
AUDIT_STATUS_ID join field
LENGTH decimal
WIDTH decimal
HEIGHT decimal
ACTUAL_WEIGHT decimal
ACTUAL_VOLUME decimal
LPN_TYPE_ID join field
pallet_activity
DESCRIPTION string
pallet_audit_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
AUDIT_HISTORY_ID join field
PALLET_NBR string
ORIG_NUM_LPNS integer
AUDIT_NUM_LPNS integer
EXPECTED_LPN_NBR string
NBR_OF_UNEXPECTED_LPNS integer
pallet_history
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
PALLET_ID join field
CONTAINER_ID join field
PALLET_NBR string
CONTAINER_NBR string
SHIPMENT_NBR string
LOAD_NBR string
PALLET_ACTIVITY_ID join field
FROM_LOCN_STR string
TO_LOCN_STR string
TOTAL_QTY decimal
LPN_COUNT integer
TOTAL_WEIGHT decimal
TOTAL_VOLUME decimal
IS_LPN_FLG boolean
LENGTH decimal
WIDTH decimal
HEIGHT decimal
LPN_TYPE_ID join field
ACTUAL_WEIGHT decimal
pallet_status
DESCRIPTION string
parcel_manifest
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CARRIER_ID join field
MANIFEST_NBR string
STATUS_ID join field
FREIGHT_CLASS string
TOTAL_WEIGHT decimal
TOTAL_VOLUME decimal
TOTAL_SHIPPING_CHARGE decimal
EST_DEPARTURE_TS datetime
SCHED_DELIVERY_TS datetime
TRAILER_NBR string
SEAL_NBR string
BOL_NBR string
MESSAGE_TEXT string
INTERNAL_MANIFEST_NBR string
CONSOLIDATED_MANIFESTING_FLG boolean
DEFERRED_CLOSE_COMPLETE_FLG boolean
CARRIER_DOCUMENT string
parcel_manifest_status
DESCRIPTION string
parcel_shipment
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
PARCEL_MANIFEST_ID join field
PARCEL_SHIPMENT_NBR string
DESTINATION_ZIP string
TOTAL_WEIGHT decimal
TOTAL_VOLUME decimal
TOTAL_SHIPPING_CHARGE decimal
parcel_shipment_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
PARCEL_SHIPMENT_ID join field
CARRIER_LPN_ID join field
parm_type
NAME string
payment_method
DESCRIPTION string
PAYMENT_METHOD_CODE string
pp_form_type
DESCRIPTION string
FORM_TYPE_CODE string
NBR_HEADER_LINES integer
NBR_DETAIL_LINES integer
price_label
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ITEM_ID join field
DEST_COMPANY_ID join field
ITEM_CODE_PL string
ITEM_DESC_PL string
PRICE_PL decimal
BARCODE_PL string
HIERARCHY_1_PL string
HIERARCHY_2_PL string
HIERARCHY_3_PL string
HIERARCHY_4_PL string
HIERARCHY_5_PL string
CHECK_DIGIT_PL string
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
CUST_FIELD_6 string
CUST_FIELD_7 string
CUST_FIELD_8 string
CUST_FIELD_9 string
CUST_FIELD_10 string
CUST_FIELD_11 string
CUST_FIELD_12 string
printer
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
PRINTER_TYPE_ID join field
PRINTER_NAME string
DESCRIPTION string
PROTOCOL_ID join field
DOMAIN_OR_IP string
PORT integer
PRINTER_QUEUE_NAME string
URI_OPTIONS string
PPD_FILENAME string
LAST_STATUS_CHECK_TS datetime
LAST_STATUS_CHECK_MESSAGE string
printer_form
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
PRINTER_ID join field
PP_FORM_TYPE_ID join field
SERIES string
START_NUM integer
END_NUM integer
CURR_NUM integer
MAX_WIDTH integer
printer_lock
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
PRINTER_ID join field
LOCK_STATUS boolean
LOCK_TIMEOUT_SECS integer
printer_protocol
DESCRIPTION string
CODE string
printer_type
DESCRIPTION string
PRINTER_TYPE_CODE string
prod_goal_line_group
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
SKU_LINE_GROUP_ID join field
CAL_YEAR integer
UOM_ID join field
UOM_PER_HR integer
IS_PRE_PACK boolean
prod_goal_line_group_history
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
SKU_LINE_GROUP_ID join field
CAL_YEAR integer
UOM_ID join field
UOM_PER_HR integer
ACTION_CODE integer
GOAL_CHANGED_BY string
prod_goal_vas
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CAL_YEAR integer
UOM_ID join field
UOM_PER_HR integer
SKU_LINE_GROUP_ID join field
prod_goal_vas_history
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CAL_YEAR integer
UOM_ID join field
UOM_PER_HR integer
ACTION_CODE integer
GOAL_CHANGED_BY string
property_prompt_in_asn_type
DESCRIPTION string
property_prompt_in_receiving
DESCRIPTION string
property_prompt_mode
DESCRIPTION string
purchase_order_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
PURCHASE_ORDER_ID join field
ITEM_ID join field
ORD_QTY decimal
ORIG_ORD_QTY decimal
RCVD_QTY decimal
SHPD_QTY decimal
UNIT_COST decimal
UNIT_RETAIL decimal
VENDOR_ITEM_CODE string
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
HOST_SEQ_NBR integer
LINE_SCHEDULE_NBRS string
INVN_ATTR_ID join field
STOP_RECV_FLG boolean
ERP_VENDORSITEID string
purchase_order_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
PO_NBR string
STATUS_ID join field
ORD_DATE date
REF_NBR string
PO_TYPE_ID join field
DELIVERY_DATE date
VENDOR_ID join field
DEPT_CODE string
SHIP_DATE date
CANCEL_DATE date
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
LOCK_ID join field
CUST_NBR string
CUST_NAME string
CUST_ADDR string
CUST_ADDR2 string
CUST_ADDR3 string
RMA_NBR string
SOLD_TO_LEGAL_NAME string
purchase_order_status
DESCRIPTION string
purchase_order_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
PO_TYPE string
PO_TYPE_DESCRIPTION string
IB_SHIPMENT_TYPE_ID join field
COPY_CUST_FIELDS_TO_ASN_FLG boolean
putaway_method
DESCRIPTION string
putaway_priority
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
LOCN_SIZE_TYPE_ID join field
LOCN_TYPE_ID join field
PUTAWAY_METHOD_ID join field
PUTAWAY_TYPE_ID join field
REPLENISHMENT_ZONE_ID join field
PRIORITY integer
CONSIDER_FEFO_FLG boolean
RADIUS integer
RADIAL_INCREMENT integer
putaway_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
PA_TYPE string
DESCRIPTION string
PALLET_POSITION_REQUIRED_FLG boolean
DEPALLETIZE_ON_PUTAWAY_FLG boolean
qc_status
DESCRIPTION string
reason_code
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CODE string
DESCRIPTION string
COMPANY_ID join field
REASON_CODE_TYPE_ID join field
reason_code_type
DESCRIPTION string
receipt_validation_type
DESCRIPTION string
record_status
DESCRIPTION string
replenishment_template
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
AREA string
FACILITY_ID join field
TEMPLATE_NAME string
REPLENISHMENT_ZONE_ID join field
REPLENISHMENT_TRIGGER_MODE_ID join field
PERCENTAGE_OF_MAX integer
ALLOW_EXPIRED_INVENTORY_FLG boolean
replenishment_trigger_mode
DESCRIPTION string
replenishment_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
REPLENISHMENT_TYPE string
COMPANY_ID join field
DESCRIPTION string
replenishment_type_zone_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
REPLENISHMENT_TYPE_ID join field
REPLENISHMENT_ZONE_ID join field
SEQ_NBR integer
REQUIRED_FOR_SHOWROOM boolean
replenishment_zone
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CODE string
DESCRIPTION string
report_type
DESCRIPTION string
REPORT_TYPE string
required_item_field
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
FACILITY_ID join field
route_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ROUTE_ID join field
DEST_FACILITY_ID join field
STOP_SEQ integer
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
route_dtl_plan
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ROUTE_ID join field
DEST_FACILITY_ID join field
ACTION_CODE_ID join field
STOP_SEQ integer
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
route_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
ROUTE_NBR string
DAY_OF_WEEK string
DEPARTURE_TIME time
SHIP_VIA_ID join field
ACTIVE_FLG boolean
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
STATUS_ID join field
route_hdr_plan
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
ROUTE_NBR string
ACTION_CODE_ID join field
DAY_OF_WEEK string
DEPARTURE_TIME time
SHIP_VIA_ID join field
ACTIVE_FLG boolean
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
route_hdr_status
DESCRIPTION string
routing_mode
DESCRIPTION string
run_status
DESCRIPTION string
screen_type
NAME string
MAX_MENU_DEPTH integer
selection_type
DESCRIPTION string
serial_nbr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
SERIAL_NBR string
ITEM_ID join field
serial_nbr_action_code
DESCRIPTION string
serial_nbr_history
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_CODE string
COMPANY_CODE string
SERIAL_NBR string
ITEM_CODE string
LPN_NBR string
TYPE string
LOCN_STR string
SERIAL_NBR_ACTION_CODE_ID join field
ITEM_DESCRIPTION string
ITEM_ALTERNATE_CODE string
serial_nbr_inventory
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
INVENTORY_ID join field
SERIAL_NBR_ID join field
shift
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
NAME string
START_TIME time
END_TIME time
shift_cw_break_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
SHIFT_ID join field
CW_BREAK_ID join field
ship_via
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CARRIER_ID join field
STD_SERVICE_TYPE_ID join field
CODE string
DESCRIPTION string
CARRIER_WEBSERVICE_LABEL_TYPE_ID join field
INTERNAL_SHIP_VIA_CODE string
CONSOLIDATED_MANIFESTING_FLG boolean
USE_DATE_TO_CONSOLIDATE_FLG boolean
OBLPN_PRINTING_VALIDATION_ID join field
MULTI_PIECE_SHIPMENT_FLG boolean
HAZMAT_REGULATION_TYPE_ID join field
AGGREGATE_CARRIER_COMMODITIES_FLG boolean
COMMODITY_HAZMAT_SUMMARY string
ship_via_account_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
SHIP_VIA_ID join field
ACCOUNT_NBR string
WEBSERVICES_USERNAME string
LICENSE_OR_METER_NBR string
HUB string
BILL_3RD_PARTY_CONTACT_ID join field
SHIP_FROM_CONTACT_ID join field
ship_via_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
SHIP_VIA_ID join field
SEQ_NBR integer
STD_CARRIER_ACCESSORIAL_ID join field
shipment_verif_orderdtl_cancel_mode
DESCRIPTION string
sku_line
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
NAME string
DESCRIPTION string
sku_line_group
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
NAME string
DESCRIPTION string
sku_line_group_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
SKU_LINE_GROUP_ID join field
SKU_LINE_ID join field
sku_line_vas_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
SKU_LINE_ID join field
sort_break_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
SORT_BREAK_HDR_ID join field
BREAK_VAL decimal
sort_break_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
RULE_NAME string
RULE_DSC string
sort_receive_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
SORT_RECEIVE_HDR_ID join field
CRITERIA_VAL1 string
CRITERIA_VAL2 string
CONTAINER_ID join field
sort_receive_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
RCV_STN_LOCN_ID join field
CLOSE_LPN_LOCN_ID join field
SORT_BREAK_HDR_ID join field
CONDITION_TYPE_ID join field
sort_zone_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
SORT_ZONE_ID join field
LOCATION_ID join field
PALLET_ID join field
CRITERIA_VALUE string
CRITERIA2_VALUE string
CONTAINER_ID join field
sort_zone_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
SORT_ZONE string
TYPE string
staffing_plan
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CAL_YEAR integer
BUDGETED_EMPLOYEES integer
BUDGETED_CONTRACTORS integer
HIRED_EMPLOYEES integer
HIRED_CONTRACTORS integer
CONTRACTED_HOURS integer
AVG_COST float
stage_status
DESCRIPTION string
standard_check_digit_method
CODE string
status
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
OBJECT_NAME string
STAT_CODE integer
STAT_DESC string
std_carrier
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CODE string
DESCRIPTION string
CARRIER_TYPE_ID join field
std_carrier_accessorial
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
STD_CARRIER_ID join field
CODE string
DESCRIPTION string
std_carrier_service
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
STD_CARRIER_ID join field
CODE string
DESCRIPTION string
WEBSERVICE_CODE string
ORIGIN string
DESTINATION string
stop_gdd
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
OB_STOP_ID join field
PRINT_NBR integer
INTERFACE_TS datetime
stop_gdd_nbr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
STOP_GDD_ID join field
ORDER_ID join field
INVENTORY_ID join field
GDD_NBR string
ALTERNATE_GDD_NBR string
stop_status
DESCRIPTION string
task
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
TASK_NBR string
TASK_TYPE_ID join field
PRIORITY integer
STATUS_ID join field
NEXT_LOCATION_ID join field
CART_NBR string
CURR_LOCATION_ID join field
CURR_TASK_TYPE_EXEC_SEQ integer
DESTINATION_ZONE_ID join field
REQD_EQUIPMENT_TYPE_ID join field
CC_CREATION_TYPE_ID join field
RECOUNT_REF_GROUP_NBR string
WAVE_ID join field
ASSIGNED_USER string
WAVE_GROUP_RUN_ID join field
task_status
DESCRIPTION string
task_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
TASK_TYPE string
DESCRIPTION string
FACILITY_ID join field
ALLOC_TYPE_ID join field
GEN_MOVES_AT_CREATION_FLG boolean
DESTINATION_CHECK_FOR_PALLET_MOVE_AUTO_PACK_FLG boolean
task_type_exec
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
TASK_TYPE_ID join field
SEQ_NBR integer
REQD_FLG boolean
task_zone
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CODE string
DESCRIPTION string
task_zone_movement
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
TASK_ID join field
SEQ_NBR integer
TASK_ZONE_ID join field
LOCATION_ID join field
STATUS_ID join field
EQUIPMENT_TYPE_ID join field
team
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
NAME string
team_user_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
TEAM_ID join field
CW_USER_ID join field
template_type
DESCRIPTION string
time_format
DESCRIPTION string
PYTHON_FORMAT string
DOJO_FORMAT string
FLEX_FORMAT string
MS_FORMAT string
time_zone
CODE string
TZDATA_CODE string
DESCRIPTION string
tolerance_check_choice
DESCRIPTION string
track_record
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ACTION_CODE integer
CW_USER_ID join field
CLOCKER_ID join field
FACILITY_ID join field
SHIFT_ID join field
TEAM_ID join field
CW_BREAK_ID join field
QTY integer
IN_OUT string
ACTIVE_FLG boolean
trailer
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
TRAILER_NBR string
TRAILER_REG_NBR string
SHIPPER_NAME string
SHIPPER_REG_NBR string
TRAILER_BRAND string
LOCATION_ID join field
CUST_REFERENCE_TEXT string
trailer_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
TRAILER_TYPE string
DESCRIPTION string
MAX_LPNS integer
MAX_UNITS decimal
LENGTH decimal
WIDTH decimal
HEIGHT decimal
tran_daily_activity_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
TRANSACTION_NBR integer
DAILY_ACTIVITY_TRACK_ID join field
NBR_TRANSACTION integer
tran_wms_activity_xref
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
TRANSACTION_NBR integer
WMS_ACTIVITY_TRACK_ID join field
uom
UOM_CODE string
UOM_NAME string
ups_routing_code
COUNTRY_CODE string
ZIP_FROM string
ZIP_TO string
ROUTING_CODE string
VERSION string
user_equipment_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CW_USER_ID join field
EQUIPMENT_TYPE_ID join field
value_or_percentage
DESCRIPTION string
value_type
DESCRIPTION string
vas_execution_status
DESCRIPTION string
vas_reqd_type
CODE string
DESCRIPTION string
vendor_characteristics
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
PARENT_COMPANY_ID join field
VENDOR_ID join field
CREATE_ASN_ON_PO_INTF boolean
FACILITY_ID join field
vendor_perf_code
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
CODE string
DESCRIPTION string
vendor_qc_parm
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
VENDOR_ID join field
QC_QTY_PER_LOAD_SKU decimal
COUNT_OR_PERCENTAGE_FLG string
RECEPTION_PERCENT_LEVEL integer
COLUMN_VALUE_1 string
COLUMN_VALUE_2 string
PRIORITY integer
verification_result_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
VERIFICATION_RESULT_HDR_ID join field
VERIFICATION_QUESTION_NAME string
IS_CUST_FLG boolean
VALID_FOR string
ANSWER_INPUT_TYPE string
ITEM_CODE string
EXPECTED_VALUE string
ENTERED_VALUE string
BATCH_NBR string
EXPIRY_DATE date
INVN_ATTR_A string
INVN_ATTR_B string
INVN_ATTR_C string
INVN_ATTR_D string
INVN_ATTR_F string
INVN_ATTR_E string
INVN_ATTR_G string
SERIAL_NBR string
QC_CHECK_MODULE_NAME string
QC_CHECK_SCREEN_NAME string
verification_result_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
LPN_NBR string
VENDOR_PERF_CODE string
SHIPMENT_NBR string
QC_STATUS_ID join field
QC_LOCATION string
ACCEPT_REJECT_USER string
QC_ACCEPT_REJECT_MODULE_NAME string
QC_ACCEPT_REJECT_SCREEN_NAME string
ACCEPT_REJECT_TS datetime
wave_alloc_sequence
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
WAVE_ID join field
SEQ_NBR integer
LOCATION_TYPE_ID join field
ALLOC_UOM_ID join field
RESTRICT_AREA string
RESTRICT_ALLOC_ZONE string
CARTONIZE_UOM_ID join field
ALLOC_DISTRIBUTION_MODE_ID join field
ALLOC_METHOD_ID join field
MHE_SYSTEM_ID join field
IS_PICKING_FLG boolean
IGNORE_ORD_DTL_ATTR_LIST string
IGNORE_ALLOCATED_QTY_FLG boolean
INCLUDE_MULTI_SKU_LPN_FLG boolean
ROUND_UP_ONE_UOM_FLG boolean
wave_group
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
NAME string
ACTIVE_FLG boolean
ABORT_FLG boolean
MAX_ORDERS_TO_DISTRIBUTE integer
MAX_UNITS_TO_DISTRIBUTE decimal
MAX_WEIGHT_TO_DISTRIBUTE decimal
MAX_VOLUME_TO_DISTRIBUTE decimal
wave_group_run
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
RUN_NBR string
WAVE_GROUP_NAME string
STATUS_ID join field
MESSAGE_TEXT string
wave_group_sequence
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
WAVE_GROUP_ID join field
SEQ_NBR integer
WAVE_TEMPLATE_ID join field
ACTIVE_FLG boolean
wave_mhe_status
DESCRIPTION string
wave_stage
DESCRIPTION string
wave_template
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
TEMPLATE_NAME string
ALLOC_METHOD_ID join field
ALLOC_MODE_ID join field
USE_IB_LPN_NBR_IN_OB boolean
STATUS_ID join field
LOCN_SIZE_TYPE_ID join field
TRAILER_TYPE_ID join field
CANCEL_UNALLOCATED_ORDERS_FLG boolean
CANCEL_PARTIALLY_UNALLOCATED_ORDERS_FLG boolean
ROUTING_MODE_ID join field
CUBING_MODE_ID join field
OB_LPN_TYPE_ID join field
AUTO_RELEASE_MHE_MSG_FLG boolean
FACILITY_CAPACITY_CHECK_FLG boolean
MAX_UNITS decimal
MAX_WEIGHT decimal
MAX_VOLUME decimal
MAX_ORDERS integer
TOLERANCE_PERCENTAGE integer
ALLOC_ITEM_EXPIRY_RANGE_ID join field
LABEL_PRINTER_ID join field
AUTO_RELEASE_PICK_INFO_FLG boolean
AUTO_RELEASE_OBLPN_INFO_FLG boolean
LPN_TYPE_CLASS string
MANIFEST_OBLPNS_BY_ORDER_FLG boolean
PACK_WITH_WAVE_FLG boolean
wave_template_status
DESCRIPTION string
wave_type
DESCRIPTION string
wms_activity
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
COMPANY_ID join field
TASK_NBR string
MODULE_NAME string
SCREEN_NAME string
USER_NAME string
BEGIN_TS datetime
END_TS datetime
STATUS_ID join field
wms_activity_code
DESCRIPTION string
wms_activity_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
ACTIVITY_ID join field
LPN_NBR string
PALLET_NBR string
LOCATION string
ITEM_CODE string
SKU_LINE string
UNITS decimal
ACTIVITY_CODE_ID join field
REF_FIELD_1 string
REF_FIELD_2 string
BEGIN_TS datetime
END_TS datetime
UOM_CODE string
CONVERSION_FACTOR integer
PRE_PACK_FLG boolean
wms_activity_status
DESCRIPTION string
wms_activity_track
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
UNKNOWN_SKU_LINE_NAME string
SKU_LINE_GROUP_ID join field
UNKNOWN_WMS_USER string
CW_USER_ID join field
NBR_PALLETS integer
NBR_LPNS integer
NBR_UNITS integer
NBR_OF_PICKS integer
NBR_SCAN integer
BEGIN_TS datetime
END_TS datetime
MODULE_NAME string
UNKNOWN_SUB_OPTION_NAME string
WMS_TRANSACTION_ID join field
STAT_CODE integer
wms_activity_track_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
WMS_ACTIVITY_TRACK_ID join field
PALLET_NBR string
LPN_NBR string
LOCATION string
HANDLING_UOM_ID join field
HANDLING_QTY decimal
STORAGE_QTY integer
CONVERSION_FACTOR integer
IS_PRE_PACK boolean
BEGIN_TS datetime
END_TS datetime
wms_activity_track_status
DESCRIPTION string
wms_transaction
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
NAME string
wms_transaction_dtl
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
WMS_TRANSACTION_ID join field
UOM_ID join field
IS_PRE_PACK boolean
work_area
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
CODE string
NAME string
COLOR string
SUPER_IN_CHARGE_ID join field
work_area_activity
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
CODE string
NAME string
EXTERNAL_CODE string
WORK_AREA_ID join field
WORK_AREA_ACTIVITY_TYPE_ID join field
VAS_UOM_ID join field
HISTORY_ACTIVITY_ID join field
work_area_activity_type
DESCRIPTION string
work_group
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
NAME string
DESCRIPTION string
COST_CENTRE_ID join field
work_order_activity_type
DESCRIPTION string
work_order_component
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
WORK_ORDER_KIT_ID join field
ITEM_ID join field
CHILD_UNITS decimal
REQUIRED_QTY decimal
SCRAP_QTY decimal
SCRAP_PERCENTAGE integer
KITTING_INSTRUCTION string
BATCH_NUMBER_ID join field
INVN_ATTR_ID join field
work_order_hdr
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
WORK_ORDER_NBR string
FACILITY_ID join field
COMPANY_ID join field
WORK_ORDER_TYPE_ID join field
STATUS_ID join field
REQD_BY_DATE date
PRIORITY integer
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
work_order_kit
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
WORK_ORDER_ID join field
SEQ_NBR integer
ITEM_ID join field
ORD_QTY decimal
ORIG_ORD_QTY decimal
UOM_ID join field
INVN_ATTR_ID join field
BATCH_NUMBER_ID join field
BACKFLUSH_FLG boolean
QTY_COMPLETED decimal
ASSEMBLY_LOCATION_ID join field
CUST_FIELD_1 string
CUST_FIELD_2 string
CUST_FIELD_3 string
CUST_FIELD_4 string
CUST_FIELD_5 string
SPL_INSTR string
SALES_ORDER_ID join field
EXPECTED_SALES_ORDER_NBR string
work_order_status
DESCRIPTION string
work_order_type
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
COMPANY_ID join field
WORK_ORDER_TYPE string
DESCRIPTION string
ACTIVITY_TYPE_ID join field
ONLY_DEALLOCATE_ON_SHORT_FLG boolean
PARTIAL_ALLOCATION_FLG boolean
AUTOCREATED_WO_BACKFLUSH_FLG boolean
ALLOW_EXPIRED_INVENTORY_FLG boolean
work_order_wave_template
MOD_USER string
CREATE_USER string
CREATE_TS datetime
MOD_TS datetime
FACILITY_ID join field
TEMPLATE_NAME string
CANCEL_UNALLOCATED_ORDERS_FLG boolean
from_inventory Same as inventory, used to join with allocation.from_inventory_id
to_inventory Same as inventory, used to join with allocation.to_inventory_id