ORS Reports List

Reports List and Levels

Report Type	Report Level
ANTIC_OML	HEADER
ANTIC_OML	DETAIL
CUSTOMER	HEADER
CY_CON_DTL	CONT_DTL
CY_MOV_DTL	C_MV_DTL
DATE_AUDIT	HEADER
DATE_DISC	HEADER
DESPATCHES	PALLET
EDI_PREADV	EDI_ERR
EDI_SALORD	EDI_ERR
GRNC_DESP	DTL
HAZ_CATS	HEADER
HELD_STK	HELD
HOJ_STK	HEADER
INBOUND	HEAD
INBOUND	DETAIL
INBOUND	PALLET
INVENTORY	STOCK
INVENTORY	WAREHOUSE
INVENTORY	PALLET
INVENTORY	SERIAL
INVTRY_HAZ	STOCK
INVTRY_HAZ	WAREHOUSE
INVTRY_HAZ	PALLET
INVTRY_HAZ	HAZARD
JD_STK	JD_STK_RPT
JOURNAL	HEADER
JOURNAL	REFERENCE
JOURNAL	SERIAL
JRN_DTL	HEADER
KMOVES_DTL	DTL
KMOVES_HDR	HDR
LOC_XTRACT	HEADER
LOGON_AUD	HEADER
MASTER_OML	HEADER
MASTER_OML	DETAIL
MED_NUM	MED_NUM
METAPACK	METAPACK
OINV_CHGS	CHARGES
OINV_CHGS	INVOICE
OINV_RATES	CHG_CODES
OINV_RATES	RATES
OINV_RATES	BANDS
OINV_SETUP	OWNER
ORDER	HEADER
ORDER	WELL
ORDER	DETAIL
ORDER	PALLET
ORDER_PACK	HEADER
ORDER_PACK	WELL
ORDER_PACK	DETAIL
ORDER_PACK	PALLET
ORDER_SW	HEADER
ORDER_SW	WELL
ORDER_SW	DETAIL
PACK	PACK_LVL
PACK	PACK_DTL
PACK_CONS	PACK_DTL
PACK_EFUL	PACK
PALTRACK	HEADER
PICK_CONT	PICK_CONT
PIP_DISC	HEADER
POST_OML	HEADER
PREDES_SRL	HEADER
PURCH_ORD	HDR
PURCH_ORD	DET
REPLEN	HEADER
REPRINT	HEADER
RMS	STOCK
SBD_HOLD	HOLD
SC_CHECKED	HEADER
SC_COUNTS	HEADER
SC_COUNTS	DETAIL
SC_UNCHECK	HEADER
SHIP_PAL	HDR
SHIP_PAL	DTL
STK_DTL	HEADER
STOCK	HEADER
STOCK	LOCATION
STOCK_TAKE	DETAIL
STOCK_UOMS	HEADER
SUBSTITUTE	SUBSTITUTE
SUPPLIER	HEADER
USER_LOGON	HEADER
USERS_AUD	HEADER
WARRANT	DETAIL
WMS_AUDIT	WMS_AUDIT

Report Fields

Report Type	Report Level	Title	Data Type	Required	Select	Validation	Group By
ANTIC_OML	HEADER	Vehicle Type	TEXT	N	Y
ANTIC_OML	HEADER	Despatch Date	DATE	N	R
ANTIC_OML	HEADER	Address Line 1	TEXT	N	N
ANTIC_OML	HEADER	Address Line 2	TEXT	N	N
ANTIC_OML	HEADER	Last Change Date	DATE	N	R
ANTIC_OML	HEADER	Last Change User	TEXT	N	Y
ANTIC_OML	HEADER	Country Code	TEXT	N	Y
ANTIC_OML	HEADER	Create Date Anticipated Order	DATE	N	R
ANTIC_OML	HEADER	Create User	TEXT	N	Y
ANTIC_OML	HEADER	Customer Code	TEXT	N	R
ANTIC_OML	HEADER	County	TEXT	N	Y
ANTIC_OML	HEADER	Town	TEXT	N	Y
ANTIC_OML	HEADER	Customer Type	TEXT	N	Y
ANTIC_OML	HEADER	Default Vehicle Type	TEXT	N	Y
ANTIC_OML	HEADER	Default Delivery Date	DATE	N	R
ANTIC_OML	HEADER	Risk Reason Description	TEXT	N	N
ANTIC_OML	HEADER	Status Desc	TEXT	N	N
ANTIC_OML	HEADER	Warehouse Name	TEXT	N	N
ANTIC_OML	HEADER	Despatch Pallets	NUMERIC	N	R
ANTIC_OML	HEADER	Primary Warehouse	TEXT	N	N
ANTIC_OML	HEADER	Drop	NUMERIC	N	N
ANTIC_OML	HEADER	Entered Vehicle Type	TEXT	N	Y
ANTIC_OML	HEADER	EDI Control Num	TEXT	N	R
ANTIC_OML	HEADER	Load Date	DATE	N	R
ANTIC_OML	HEADER	Load Number	TEXT	N	R
ANTIC_OML	HEADER	Marshall Loc	TEXT	N	R
ANTIC_OML	HEADER	Name	TEXT	N	N
ANTIC_OML	HEADER	Delivery Date	DATE	N	N
ANTIC_OML	HEADER	Short Stock	TEXT	N	N
ANTIC_OML	HEADER	Create sequence No.	NUMERIC	N	Y
ANTIC_OML	HEADER	DHL Link Ref	TEXT	N	R
ANTIC_OML	HEADER	Priority	TEXT	N	Y
ANTIC_OML	HEADER	Owner	TEXT	N	Y
ANTIC_OML	HEADER	Entered Delivery Date	DATE	N	R
ANTIC_OML	HEADER	Postcode	TEXT	N	R
ANTIC_OML	HEADER	Risk Comments	TEXT	N	N
ANTIC_OML	HEADER	Risk Date	DATE	N	R
ANTIC_OML	HEADER	Risk Flag	TEXT	N	R
ANTIC_OML	HEADER	Risk Level	TEXT	N	R
ANTIC_OML	HEADER	Risk Reason	TEXT	N	R
ANTIC_OML	HEADER	Route	TEXT	N	R
ANTIC_OML	HEADER	Status	TEXT	N	R
ANTIC_OML	HEADER	Transport Code	TEXT	N	Y
ANTIC_OML	HEADER	Volume	NUMERIC	N	R
ANTIC_OML	HEADER	Warehouse	TEXT	N	R
ANTIC_OML	HEADER	Weight	NUMERIC	N	R
ANTIC_OML	HEADER	Order Num(WHS)	TEXT	N	R
ANTIC_OML	DETAIL	Last Changed Date	DATE	N	R
ANTIC_OML	DETAIL	Last Change User	TEXT	N	Y
ANTIC_OML	DETAIL	Create Date	DATE	N	R
ANTIC_OML	DETAIL	Create User	TEXT	N	Y
ANTIC_OML	DETAIL	DESCRIPTION	TEXT	N	N
ANTIC_OML	DETAIL	DESCRIPTION 2	TEXT	N	R
ANTIC_OML	DETAIL	DESCRIPTION 3	TEXT	N	N
ANTIC_OML	DETAIL	Status Desc	TEXT	N	N
ANTIC_OML	DETAIL	Despatched Cases	NUMERIC	N	N
ANTIC_OML	DETAIL	Despatched Eaches	NUMERIC	N	N
ANTIC_OML	DETAIL	Line No	NUMERIC	N	N
ANTIC_OML	DETAIL	Generic Sku	TEXT	N	R
ANTIC_OML	DETAIL	Master Line No	NUMERIC	N	N
ANTIC_OML	DETAIL	Short Stock	TEXT	N	N
ANTIC_OML	DETAIL	Current Eaches Anticipated	NUMERIC	N	N
ANTIC_OML	DETAIL	Final Eaches Anticipated	NUMERIC	N	N
ANTIC_OML	DETAIL	Eaches Ordered	NUMERIC	N	N
ANTIC_OML	DETAIL	Customer Order	TEXT	N	R
ANTIC_OML	DETAIL	Status	TEXT	N	R
ANTIC_OML	DETAIL	ABC Code	TEXT	N	Y
ANTIC_OML	DETAIL	Eaches Per Shipping Unit	NUMERIC	N	R
ANTIC_OML	DETAIL	Ordered Cases	NUMERIC	N	N
ANTIC_OML	DETAIL	Ordered Units	NUMERIC	N	N
ANTIC_OML	DETAIL	NPC Code	TEXT	N	R
CUSTOMER	HEADER	Delivery Address Line 1	TEXT
CUSTOMER	HEADER	Invoice Address Line 1	TEXT
CUSTOMER	HEADER	Delivery Address Line 2	TEXT
CUSTOMER	HEADER	Invoice Address Line 2	TEXT
CUSTOMER	HEADER	Contact	TEXT
CUSTOMER	HEADER	Country	TEXT		R
CUSTOMER	HEADER	Country	TEXT
CUSTOMER	HEADER	Created By	TEXT		Y
CUSTOMER	HEADER	Created Date	DATE		R
CUSTOMER	HEADER	Currency Code	TEXT
CUSTOMER	HEADER	Customer Code	TEXT	Y	R
CUSTOMER	HEADER	Delivery Address Line 4	TEXT
CUSTOMER	HEADER	Invoice Address Line 4	TEXT
CUSTOMER	HEADER	Delivery Address Line 3	TEXT
CUSTOMER	HEADER	Invoice Address Line 3	TEXT
CUSTOMER	HEADER	Customer Type	TEXT
CUSTOMER	HEADER	Primary Warehouse	TEXT
CUSTOMER	HEADER	EAN Reference	TEXT
CUSTOMER	HEADER	Customer Name	TEXT		Y
CUSTOMER	HEADER	Delivery Address Name	TEXT
CUSTOMER	HEADER	Invoice Address Name	TEXT
CUSTOMER	HEADER	Description	TEXT	N	N
CUSTOMER	HEADER	Owner Code	TEXT	N	Y
CUSTOMER	HEADER	Owner Sub Code	TEXT	N	Y
CUSTOMER	HEADER	Payment Terms	TEXT
CUSTOMER	HEADER	Phone Number	TEXT
CUSTOMER	HEADER	Phone Number	TEXT
CUSTOMER	HEADER	Postcode	TEXT		Y
CUSTOMER	HEADER	Postcode	TEXT
CUSTOMER	HEADER	Route Code	TEXT
CUSTOMER	HEADER	Sales Area	TEXT
CUSTOMER	HEADER	Salesman	TEXT
CUSTOMER	HEADER	Sales Territory	TEXT		R
CUSTOMER	HEADER	Transport Charge	NUMBER
CUSTOMER	HEADER	Updated By	TEXT		Y
CUSTOMER	HEADER	Last Updated Date	DATE		R
CUSTOMER	HEADER	VAT Applied	TEXT
CUSTOMER	HEADER	Vehicle Type	TEXT
CUSTOMER	HEADER	Weekly Invoicing	TEXT
CY_CON_DTL	CONT_DTL	Account Id	TEXT	N	Y
CY_CON_DTL	CONT_DTL	Account Name	TEXT	N	N
CY_CON_DTL	CONT_DTL	Company Code	TEXT	Y	Y
CY_CON_DTL	CONT_DTL	Container No	TEXT	Y	Y
CY_CON_DTL	CONT_DTL	Days On Site	NUMERIC	N	Y
CY_CON_DTL	CONT_DTL	Hazardous	TEXT	N	N
CY_CON_DTL	CONT_DTL	Hazardous Ind	NUMERIC	N	Y
CY_CON_DTL	CONT_DTL	Inbound Method	TEXT	N	N
CY_CON_DTL	CONT_DTL	Location Code	TEXT	N	Y
CY_CON_DTL	CONT_DTL	Location Date	DATE	N	N
CY_CON_DTL	CONT_DTL	Onsite Date	DATE	N	N
CY_CON_DTL	CONT_DTL	Order No	TEXT	N	Y
CY_CON_DTL	CONT_DTL	Status Code	TEXT	N	Y
CY_CON_DTL	CONT_DTL	Status Description	TEXT	N	N
CY_CON_DTL	CONT_DTL	Type Code	TEXT	N	Y
CY_CON_DTL	CONT_DTL	Type Description	TEXT	N	N
CY_CON_DTL	CONT_DTL	Warehouse Id	TEXT	Y	Y
CY_CON_DTL	CONT_DTL	Weight Code	TEXT	N	N
CY_CON_DTL	CONT_DTL	Weight Description	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Account Id	TEXT	N	R
CY_MOV_DTL	C_MV_DTL	Account Name	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Carrier	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Company Code	TEXT	Y	Y
CY_MOV_DTL	C_MV_DTL	Container Id	TEXT	Y	Y
CY_MOV_DTL	C_MV_DTL	Container Status	TEXT	N	Y
CY_MOV_DTL	C_MV_DTL	Container Status Desc	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Created Date	DATE	N	N
CY_MOV_DTL	C_MV_DTL	Due Datetime	DATE	N	Y
CY_MOV_DTL	C_MV_DTL	Entered Date	DATE	N	N
CY_MOV_DTL	C_MV_DTL	From Location	TEXT	N	Y
CY_MOV_DTL	C_MV_DTL	HAULIER	TEXT	N	Y
CY_MOV_DTL	C_MV_DTL	Haulier Name	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Hazardous	TEXT	N	Y
CY_MOV_DTL	C_MV_DTL	Hazardous Ind	NUMERIC	N	N
CY_MOV_DTL	C_MV_DTL	Movement By	TEXT	N	Y
CY_MOV_DTL	C_MV_DTL	Movement Date	DATE	N	Y
CY_MOV_DTL	C_MV_DTL	Movement Id	NUMERIC	Y	Y
CY_MOV_DTL	C_MV_DTL	Movement Type	TEXT	N	Y
CY_MOV_DTL	C_MV_DTL	Movement Type Desc	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Order No	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Position Code	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Registration	TEXT	N	Y
CY_MOV_DTL	C_MV_DTL	Seal	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Service	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Signature Id	NUMERIC	N	N
CY_MOV_DTL	C_MV_DTL	Status Type	NUMERIC	N	Y
CY_MOV_DTL	C_MV_DTL	Status Desc	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	To Location	TEXT	N	Y
CY_MOV_DTL	C_MV_DTL	Type Code	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Type Description	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	UN Name	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	UN Number	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Warehouse Id	TEXT	Y	Y
CY_MOV_DTL	C_MV_DTL	Weight	NUMERIC	N	Y
CY_MOV_DTL	C_MV_DTL	Weight Code	TEXT	N	N
CY_MOV_DTL	C_MV_DTL	Weight Description	TEXT	N	N
DATE_AUDIT	HEADER	Company Code	TEXT	N	Y
DATE_AUDIT	HEADER	Date Changed	DATE	N	Y
DATE_AUDIT	HEADER	Despatched Date	DATE	N	Y
DATE_AUDIT	HEADER	Old Despatched Time	NUMBER	N	Y
DATE_AUDIT	HEADER	Load Number	TEXT	N	Y
DATE_AUDIT	HEADER	Logon Id	TEXT	N	Y
DATE_AUDIT	HEADER	Old Despatched Date	DATE	N	Y
DATE_AUDIT	HEADER	Old Despatched Time	NUMBER	N	Y
DATE_AUDIT	HEADER	Old Pick Conf Date	DATE	N	Y
DATE_AUDIT	HEADER	Old Pick Conf Time	NUMBER	N	Y
DATE_AUDIT	HEADER	Old Pick Conf Date	DATE	N	Y
DATE_AUDIT	HEADER	Old Pick Conf Time	NUMBER	N	Y
DATE_AUDIT	HEADER	Order Code	TEXT	N	Y
DATE_AUDIT	HEADER	Owner Code	TEXT	N	Y
DATE_AUDIT	HEADER	Owner Sub Code	TEXT	N	Y
DATE_AUDIT	HEADER	Pick Conf Date	DATE	N	Y
DATE_AUDIT	HEADER	Old Pick Conf Time	NUMBER	N	Y
DATE_AUDIT	HEADER	Pick Conf Date	DATE	N	Y
DATE_AUDIT	HEADER	Old Pick Conf Time	NUMBER	N	Y
DATE_AUDIT	HEADER	Product Type	TEXT	N	Y
DATE_AUDIT	HEADER	Route Code	TEXT	N	Y
DATE_AUDIT	HEADER	Warehouse Id	TEXT	N	Y
DATE_DISC	HEADER	AKA Stock Code	TEXT	N	R
DATE_DISC	HEADER	Alloc Case	NUMERIC	N	N
DATE_DISC	HEADER	Alloc Single	NUMERIC	N	N
DATE_DISC	HEADER	DESCRIPTION	TEXT	N	R
DATE_DISC	HEADER	DESCRIPTION 2	TEXT	N	R
DATE_DISC	HEADER	DESCRIPTION 3	TEXT	N	R
DATE_DISC	HEADER	Held Case	NUMERIC	N	N
DATE_DISC	HEADER	Held Single	NUMERIC	N	N
DATE_DISC	HEADER	Location	TEXT	N	R
DATE_DISC	HEADER	On Hand Case	NUMERIC	N	N
DATE_DISC	HEADER	On Hand Single	NUMERIC	N	N
DATE_DISC	HEADER	Pallet	NUMERIC	N	R
DATE_DISC	HEADER	Receipt Date	DATE	N	R
DATE_DISC	HEADER	Rotation	TEXT	Y	R
DATE_DISC	HEADER	Sell by Date	DATE	Y	R
DATE_DISC	HEADER	ABC Code	TEXT	N	Y
DATE_DISC	HEADER	Stock Code	TEXT	Y	R
DATE_DISC	HEADER	Stockist	TEXT	Y	Y
DATE_DISC	HEADER	Warehouse	TEXT	Y	R
DESPATCHES	PALLET	Ordered Quantity	NUMERIC	N	N
DESPATCHES	PALLET	Name	TEXT	N	N
DESPATCHES	PALLET	Company	TEXT	Y	Y
DESPATCHES	PALLET	Customer Code	TEXT	N	R
DESPATCHES	PALLET	Stock Description	TEXT	N	N
DESPATCHES	PALLET	Despatch Date	DATE	Y	R
DESPATCHES	PALLET	Load Number	TEXT	N	N
DESPATCHES	PALLET	Order Reference	TEXT	N	Y
DESPATCHES	PALLET	Order Line No	NUMERIC	N	N
DESPATCHES	PALLET	Order Number	TEXT	N	R
DESPATCHES	PALLET	Order Owner Code	TEXT	Y	Y
DESPATCHES	PALLET	Order Owner Sub-Code	TEXT	Y	Y
DESPATCHES	PALLET	Ordered Cases	NUMERIC	N	N
DESPATCHES	PALLET	Ordered Units	NUMERIC	N	N
DESPATCHES	PALLET	Pallet ID	NUMERIC	N	N
DESPATCHES	PALLET	Product Type	TEXT	N	R
DESPATCHES	PALLET	Despatched Quantity	NUMERIC	N	N
DESPATCHES	PALLET	Despatched Cases	NUMERIC	N	N
DESPATCHES	PALLET	Despatched Units	NUMERIC	N	N
DESPATCHES	PALLET	Route Code	TEXT	N	N
DESPATCHES	PALLET	Stock Code	TEXT	N	N
DESPATCHES	PALLET	Stockist Code	TEXT	N	N
DESPATCHES	PALLET	Warehouse	TEXT	Y	Y
EDI_PREADV	EDI_ERR	Supplier Address Line 1	TEXT	N	Y
EDI_PREADV	EDI_ERR	Addess 2	TEXT	N	Y
EDI_PREADV	EDI_ERR	Address 3 (Town)	TEXT	N	Y
EDI_PREADV	EDI_ERR	Address 4 (County)	TEXT	N	Y
EDI_PREADV	EDI_ERR	Supplier Country	TEXT	N	Y
EDI_PREADV	EDI_ERR	Supplier Post Code	TEXT	N	Y
EDI_PREADV	EDI_ERR	Company Code	TEXT	N	Y
EDI_PREADV	EDI_ERR	EDI Control Num	TEXT	Y	R
EDI_PREADV	EDI_ERR	Customer Pallet ID	TEXT	N	Y
EDI_PREADV	EDI_ERR	Delivery Date	DATE	N	Y
EDI_PREADV	EDI_ERR	Description of Stock	TEXT	N	Y
EDI_PREADV	EDI_ERR	Description_2 of Stock	TEXT	N	Y
EDI_PREADV	EDI_ERR	EDI Sequence	NUMBER	Y	Y
EDI_PREADV	EDI_ERR	Line No	NUMERIC	N	Y
EDI_PREADV	EDI_ERR	Email Address	TEXT	N	Y
EDI_PREADV	EDI_ERR	Error Parameter 1	TEXT	N	Y
EDI_PREADV	EDI_ERR	Error Parameter 2	TEXT	N	Y
EDI_PREADV	EDI_ERR	Error String	TEXT	N	Y
EDI_PREADV	EDI_ERR	Error Type	TEXT	N	Y
EDI_PREADV	EDI_ERR	Message ID	TEXT	N	Y
EDI_PREADV	EDI_ERR	Owner Code	TEXT	N	Y
EDI_PREADV	EDI_ERR	Advice Note No	TEXT	N	Y
EDI_PREADV	EDI_ERR	Owner Sub Code	TEXT	N	Y
EDI_PREADV	EDI_ERR	EDI Flow	TEXT	N	N
EDI_PREADV	EDI_ERR	Product Code	TEXT	N	Y
EDI_PREADV	EDI_ERR	Qty received	NUMERIC	N	Y
EDI_PREADV	EDI_ERR	Receipt Type	TEXT	N	Y
EDI_PREADV	EDI_ERR	Supplier Code	TEXT	N	Y
EDI_PREADV	EDI_ERR	Rotation No	TEXT	N	Y
EDI_PREADV	EDI_ERR	Warehouse Id	TEXT	N	Y
EDI_SALORD	EDI_ERR	Customer Code	TEXT	N	Y
EDI_SALORD	EDI_ERR	Company Code	TEXT	N	Y
EDI_SALORD	EDI_ERR	EDI Control Num	TEXT	Y	R
EDI_SALORD	EDI_ERR	Customer Pallet ID	TEXT	N	Y
EDI_SALORD	EDI_ERR	Customer Rotation No	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Address Line 1	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Address Line 2	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Address Line 3	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Address Line 4	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Address Line 5	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Address Line 6	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Address Line 7	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Country	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Date	DATE	N	R
EDI_SALORD	EDI_ERR	Delivery Post Code	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Phone Number	TEXT	N	Y
EDI_SALORD	EDI_ERR	Delivery Time	NUMBER	N	R
EDI_SALORD	EDI_ERR	Description of Stock	TEXT	N	Y
EDI_SALORD	EDI_ERR	Reason Code Description	TEXT	N	Y
EDI_SALORD	EDI_ERR	Description_2 of Stock	TEXT	N	Y
EDI_SALORD	EDI_ERR	Line No	NUMERIC	N	Y
EDI_SALORD	EDI_ERR	EDI Transaction Number	NUMERIC	N	Y
EDI_SALORD	EDI_ERR	Email Address	TEXT	N	Y
EDI_SALORD	EDI_ERR	Error Parameter 1	TEXT	N	Y
EDI_SALORD	EDI_ERR	Error Parameter 2	TEXT	N	Y
EDI_SALORD	EDI_ERR	Error String	TEXT	N	Y
EDI_SALORD	EDI_ERR	Error Type	TEXT	N	Y
EDI_SALORD	EDI_ERR	Import File Name	TEXT	N	Y
EDI_SALORD	EDI_ERR	Line Type	TEXT	N	Y
EDI_SALORD	EDI_ERR	Message ID	TEXT	N	Y
EDI_SALORD	EDI_ERR	Order Date	DATE	N	R
EDI_SALORD	EDI_ERR	Order Description	TEXT	N	Y
EDI_SALORD	EDI_ERR	Order Time	NUMBER	N	R
EDI_SALORD	EDI_ERR	Owner Code	TEXT	N	Y
EDI_SALORD	EDI_ERR	Owner Sub Code	TEXT	N	Y
EDI_SALORD	EDI_ERR	System Pallet No	NUMERIC	N	Y
EDI_SALORD	EDI_ERR	Priority Code	TEXT	N	Y
EDI_SALORD	EDI_ERR	EDI Flow	TEXT	N	N
EDI_SALORD	EDI_ERR	Qty Ordered	NUMERIC	N	Y
EDI_SALORD	EDI_ERR	Reason Code	TEXT	N	Y
EDI_SALORD	EDI_ERR	Order Number	TEXT	N	R
EDI_SALORD	EDI_ERR	Seller Order Referenc	TEXT	N	Y
EDI_SALORD	EDI_ERR	Product Code	TEXT	N	Y
EDI_SALORD	EDI_ERR	Sellers Identity	TEXT	N	Y
EDI_SALORD	EDI_ERR	System Rotation No	TEXT	N	Y
EDI_SALORD	EDI_ERR	Warehouse Id	TEXT	N	Y
GRNC_DESP	DTL	Case Picks	NUMERIC	Y	N
GRNC_DESP	DTL	Company Code	TEXT	N	Y
GRNC_DESP	DTL	Customer Name	TEXT	Y	N
GRNC_DESP	DTL	Cust Ref	TEXT	Y	N
GRNC_DESP	DTL	Despatch Date	TEXT	Y	N
GRNC_DESP	DTL	No of Pallets	NUMERIC	Y	N
GRNC_DESP	DTL	Reference	TEXT	Y	N
GRNC_DESP	DTL	Order Num	TEXT	Y	N
GRNC_DESP	DTL	Owner Code	TEXT	N	Y
GRNC_DESP	DTL	Total Qty Despd	NUMERIC	Y	N
GRNC_DESP	DTL	Warehouse Id	TEXT	N	Y
HAZ_CATS	HEADER	Area Code	TEXT	Y	N
HAZ_CATS	HEADER	Description	TEXT	Y	N
HAZ_CATS	HEADER	Hazard Category	TEXT	Y	N
HAZ_CATS	HEADER	Weight in Kgm	NUMBER	Y	N
HAZ_CATS	HEADER	Warehouse Id	TEXT	Y	R
HELD_STK	HELD	Audit No	NUMERIC	N	N
HELD_STK	HELD	Company Code	TEXT	Y	Y
HELD_STK	HELD	Cumulative Flag	TEXT	N	N
HELD_STK	HELD	Cust Pallet Id	TEXT	N	Y
HELD_STK	HELD	Cust Rot No	TEXT	N	Y
HELD_STK	HELD	Description	TEXT	N	N
HELD_STK	HELD	Freeze Ref	TEXT	N	N
HELD_STK	HELD	Freeze Status	TEXT	N	N
HELD_STK	HELD	Held Case	NUMERIC	N	N
HELD_STK	HELD	Held Qty	NUMERIC	N	N
HELD_STK	HELD	Held Single	NUMERIC	N	N
HELD_STK	HELD	Hold Reference	TEXT	N	N
HELD_STK	HELD	Location Code	TEXT	N	Y
HELD_STK	HELD	Pallet Id	NUMERIC	Y	R
HELD_STK	HELD	Prev Reason	TEXT	N	N
HELD_STK	HELD	Reason Category	TEXT	N	N
HELD_STK	HELD	Reason Code	TEXT	Y	Y
HELD_STK	HELD	Review Date	DATE	N	N
HELD_STK	HELD	Review Time	NUMERIC	N	N
HELD_STK	HELD	Rotation No	TEXT	Y	R
HELD_STK	HELD	Status Type	TEXT	N	N
HELD_STK	HELD	Stock Code	TEXT	N	R
HELD_STK	HELD	Stockist Code	TEXT	Y	R
HELD_STK	HELD	Stockist Sub Code	TEXT	N	Y
HELD_STK	HELD	Warehouse Id	TEXT	Y	R
HOJ_STK	HEADER	Alloc Case	NUMBER	N	Y
HOJ_STK	HEADER	Committed Case	NUMBER	N	Y
HOJ_STK	HEADER	Company Code	TEXT	N	Y
HOJ_STK	HEADER	Cust Rotation No	TEXT	N	Y
HOJ_STK	HEADER	Held Case	NUMBER	N	Y
HOJ_STK	HEADER	Location	TEXT	N	Y
HOJ_STK	HEADER	On Hand Case	NUMBER	N	Y
HOJ_STK	HEADER	Pallet ID	TEXT	N	Y
HOJ_STK	HEADER	Rotation No	TEXT	N	Y
HOJ_STK	HEADER	Sell By Date	DATE	N	Y
HOJ_STK	HEADER	Stock Desc	TEXT	N	Y
HOJ_STK	HEADER	Stock Code	TEXT	N	Y
HOJ_STK	HEADER	Aisle	TEXT	N	Y
HOJ_STK	HEADER	Bay	TEXT	N	Y
HOJ_STK	HEADER	Trans In Case	NUMBER	N	Y
HOJ_STK	HEADER	Trans Out Case	NUMBER	N	Y
HOJ_STK	HEADER	Warehouse ID	TEXT	N	Y
INBOUND	HEAD	Instructions	TEXT	N	N
INBOUND	HEAD	Advice Note No.	TEXT	N	Y
INBOUND	HEAD	Booking Reference	TEXT	N	Y
INBOUND	HEAD	Container No.	TEXT	N	Y
INBOUND	HEAD	Date Completed	DATE	N	Y
INBOUND	HEAD	Delivery Receipt Date	DATE	N	R
INBOUND	HEAD	Receipt Complete	TEXT	N	Y	Y,N
INBOUND	HEAD	Receipt Number	NUMERIC	Y	R
INBOUND	HEAD	GRN Owner Code	TEXT	N	N
INBOUND	HEAD	GRN Type	TEXT	N	Y	N,S,R,M,P,C
INBOUND	HEAD	Receipt Date	DATE	N	R
INBOUND	HEAD	Receipt Type	TEXT	N	N	REC,RET,POR
INBOUND	HEAD	Reference 1	TEXT	N	N
INBOUND	HEAD	Reference 2	TEXT	N	N
INBOUND	HEAD	Reference 3	TEXT	N	N
INBOUND	HEAD	Supplier Code	TEXT	N	Y
INBOUND	HEAD	Total Pallets Received	NUMERIC	N	N
INBOUND	HEAD	Total Pallets Returned	NUMERIC	N	N
INBOUND	HEAD	Trailer Temperature	NUMERIC	N	N
INBOUND	HEAD	Warehouse ID	TEXT	Y	Y
INBOUND	DETAIL	Catch Weight	NUMERIC	N	N
INBOUND	DETAIL	Customer PO Number	TEXT	N	N
INBOUND	DETAIL	Expected Cases	NUMERIC	N	N
INBOUND	DETAIL	On Hand Cases	NUMERIC	N	N
INBOUND	DETAIL	On-Hand Weight	NUMERIC	N	N
INBOUND	DETAIL	Order Line No	NUMERIC	N	N
INBOUND	DETAIL	Order Number	TEXT	N	N
INBOUND	DETAIL	Outstanding Cases	NUMERIC	N	N
INBOUND	DETAIL	PO Line Complete	TEXT	N	N	Y,N
INBOUND	DETAIL	Stock Code	TEXT	Y	R
INBOUND	DETAIL	Owner Code	TEXT	Y	Y
INBOUND	DETAIL	Calc. Outstanding Case	NUMERIC	N	N
INBOUND	DETAIL	Calc. Outstanding Qty	NUMERIC	N	N
INBOUND	DETAIL	Line Complete	TEXT	N	N	Y,N
INBOUND	PALLET	Customer Pallet ID	TEXT	N	R
INBOUND	PALLET	Customer PO Number	TEXT	N	N
INBOUND	PALLET	Customer Rotation No	TEXT	N	R
INBOUND	PALLET	Expected Cases	NUMERIC	N	N
INBOUND	PALLET	Receipt Complete	TEXT	N	Y	Y,N
INBOUND	PALLET	Location Code	TEXT	N	R
INBOUND	PALLET	Manufacture Date	DATE	N	R
INBOUND	PALLET	On Hand Cases	NUMERIC	N	N
INBOUND	PALLET	Pallet ID	NUMERIC	Y	R
INBOUND	PALLET	Pallet Temperature	NUMERIC	N	N
INBOUND	PALLET	Pallet Type	TEXT	N	R
INBOUND	PALLET	Reason Code	TEXT	N	R
INBOUND	PALLET	Receipt Location	TEXT	N	R
INBOUND	PALLET	Rotation No	TEXT	N	R
INBOUND	PALLET	Sell By Date	DATE	N	R
INVENTORY	STOCK	Bonded Flag	TEXT	N	Y	Y,N
INVENTORY	STOCK	Description	TEXT	N	N
INVENTORY	STOCK	Description_2	TEXT	N	N
INVENTORY	STOCK	Description3	TEXT	N	N
INVENTORY	STOCK	Pallet Type	TEXT	N	Y
INVENTORY	STOCK	Prod_Category	TEXT	N	Y
INVENTORY	STOCK	Prod_Class	TEXT	N	Y
INVENTORY	STOCK	Product Group	TEXT	N	Y
INVENTORY	STOCK	Product Range	TEXT	N	Y
INVENTORY	STOCK	Product Sub Group	TEXT	N	Y
INVENTORY	STOCK	Size_Pack	TEXT	N	N
INVENTORY	STOCK	Stock Code	TEXT	Y	R
INVENTORY	STOCK	Owner Code	TEXT	Y	Y
INVENTORY	STOCK	To Transit	NUMBER	N	N
INVENTORY	WAREHOUSE	Free Cases	NUMBER	N	N
INVENTORY	WAREHOUSE	Free Units	NUMBER	N	N
INVENTORY	WAREHOUSE	Alloc Cases	NUMBER	N	N
INVENTORY	WAREHOUSE	Alloc Units	NUMBER	N	N
INVENTORY	WAREHOUSE	Committed Cases	NUMBER	N	N
INVENTORY	WAREHOUSE	Committed Units	NUMBER	N	N
INVENTORY	WAREHOUSE	Free Pallets	NUMBER	N	N
INVENTORY	WAREHOUSE	On Hand Pallets	NUMBER	N	N
INVENTORY	WAREHOUSE	Held Cases	NUMBER	N	N
INVENTORY	WAREHOUSE	Held Units	NUMBER	N	N
INVENTORY	WAREHOUSE	On Hand Cases	NUMBER	N	N
INVENTORY	WAREHOUSE	On Hand Units	NUMBER	N	N
INVENTORY	WAREHOUSE	Transfer Cases	NUMERIC	N	N
INVENTORY	WAREHOUSE	Transfer Units	NUMERIC	N	N
INVENTORY	WAREHOUSE	Warehouse Id	TEXT	Y	R
INVENTORY	PALLET	Free Cases	NUMERIC	N	N
INVENTORY	PALLET	Quantity Free	NUMERIC	N	N
INVENTORY	PALLET	Free Units	NUMERIC	N	N
INVENTORY	PALLET	Allocated Cases	NUMERIC	N	N
INVENTORY	PALLET	Quantity Allocated	NUMERIC	N	N
INVENTORY	PALLET	Allocated Units	NUMERIC	N	N
INVENTORY	PALLET	Area Code	TEXT	N	N
INVENTORY	PALLET	Catch Weight	NUMERIC	N	N
INVENTORY	PALLET	Committed Cases	NUMERIC	N	N
INVENTORY	PALLET	Quantity Committed	NUMERIC	N	N
INVENTORY	PALLET	Committed Units	NUMERIC	N	N
INVENTORY	PALLET	Customer Pallet ID	TEXT	N	R
INVENTORY	PALLET	Customer Rotation No	TEXT	N	R
INVENTORY	PALLET	Activity Date	DATE	N	N
INVENTORY	PALLET	Activity Type	TEXT	N	N
INVENTORY	PALLET	On Hand Weight	NUMERIC	N	N
INVENTORY	PALLET	Cases Held	NUMERIC	N	N
INVENTORY	PALLET	Quantity Held	NUMERIC	N	N
INVENTORY	PALLET	Units Held	NUMERIC	N	N
INVENTORY	PALLET	Last Adjusted Date	DATE	N	R
INVENTORY	PALLET	Location Code	TEXT	N	R
INVENTORY	PALLET	Manufacture Date	DATE	N	R
INVENTORY	PALLET	Measure Qty	NUMERIC	N	N
INVENTORY	PALLET	Measure Type	TEXT	N	Y
INVENTORY	PALLET	Supplier Name	TEXT	N	N
INVENTORY	PALLET	On Hand Cases	NUMERIC	N	N
INVENTORY	PALLET	Quantity On Hand	NUMERIC	N	N
INVENTORY	PALLET	On Hand Units	NUMERIC	N	N
INVENTORY	PALLET	Pallet ID	NUMERIC	Y	R
INVENTORY	PALLET	Receipt Date	DATE	N	R
INVENTORY	PALLET	Rotation No	TEXT	N	R
INVENTORY	PALLET	Sell By Date	DATE	N	R
INVENTORY	PALLET	Stock Take In Prog	TEXT	N	Y
INVENTORY	PALLET	Stock Take No	NUMERIC	N	R
INVENTORY	PALLET	Hold Reason Code 1	TEXT	N	N
INVENTORY	PALLET	Hold Reason 1 Description	TEXT	N	N
INVENTORY	PALLET	Hold Reason Code 2	TEXT	N	N
INVENTORY	PALLET	Hold Reason 2 Description	TEXT	N	N
INVENTORY	PALLET	Hold Reason Code 3	TEXT	N	N
INVENTORY	PALLET	Hold Reason 3 Description	TEXT	N	N
INVENTORY	PALLET	Supplier Code	TEXT	N	R
INVENTORY	PALLET	In Cases	NUMERIC	N	N
INVENTORY	PALLET	Quantity In	NUMERIC	N	N
INVENTORY	PALLET	In Units	NUMERIC	N	N
INVENTORY	PALLET	Cases Out	NUMERIC	N	N
INVENTORY	PALLET	Quantity Out	NUMERIC	N	N
INVENTORY	PALLET	Units Out	NUMERIC	N	N
INVENTORY	SERIAL	Date Created	DATE	N	N
INVENTORY	SERIAL	Delete Flag	TEXT	N	N
INVENTORY	SERIAL	Master Seq	NUMBER	N	N
INVENTORY	SERIAL	Move Status	TEXT	N	N
INVENTORY	SERIAL	Order Status	TEXT	N	N
INVENTORY	SERIAL	Pallet ID	NUMBER	N	N
INVENTORY	SERIAL	Reason Code	TEXT	N	N
INVENTORY	SERIAL	Serial No	TEXT	Y	N
INVTRY_HAZ	STOCK	Bonded Flag	TEXT	N	Y	Y,N
INVTRY_HAZ	STOCK	Description	TEXT	N	N
INVTRY_HAZ	STOCK	Description_2	TEXT	N	N
INVTRY_HAZ	STOCK	Description_3	TEXT	N	N
INVTRY_HAZ	STOCK	Prod_Category	TEXT	N	N
INVTRY_HAZ	STOCK	Prod_Class	TEXT	N	Y
INVTRY_HAZ	STOCK	Size_Pack	TEXT	N	N
INVTRY_HAZ	STOCK	Stock Code	TEXT	Y	R
INVTRY_HAZ	STOCK	Owner Code	TEXT	Y	Y
INVTRY_HAZ	WAREHOUSE	Free Cases	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	Free Units	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	Alloc Cases	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	Alloc Units	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	Committed Cases	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	Committed Units	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	Held Cases	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	Held Units	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	On Hand Cases	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	On Hand Units	NUMBER	N	N
INVTRY_HAZ	WAREHOUSE	Transfer Cases	NUMERIC	N	N
INVTRY_HAZ	WAREHOUSE	Transfer Units	NUMERIC	N	N
INVTRY_HAZ	WAREHOUSE	Warehouse Id	TEXT	Y	R
INVTRY_HAZ	PALLET	Free Cases	NUMERIC	N	N
INVTRY_HAZ	PALLET	Quantity Free	NUMERIC	N	N
INVTRY_HAZ	PALLET	Free Units	NUMERIC	N	N
INVTRY_HAZ	PALLET	Allocated Cases	NUMERIC	N	N
INVTRY_HAZ	PALLET	Quantity Allocated	NUMERIC	N	N
INVTRY_HAZ	PALLET	Allocated Units	NUMERIC	N	N
INVTRY_HAZ	PALLET	Catch Weight	NUMERIC	N	N
INVTRY_HAZ	PALLET	Committed Cases	NUMERIC	N	N
INVTRY_HAZ	PALLET	Quantity Committed	NUMERIC	N	N
INVTRY_HAZ	PALLET	Committed Units	NUMERIC	N	N
INVTRY_HAZ	PALLET	Customer Pallet ID	TEXT	N	R
INVTRY_HAZ	PALLET	Customer Rotation No	TEXT	N	R
INVTRY_HAZ	PALLET	On Hand Weight	NUMERIC	N	N
INVTRY_HAZ	PALLET	Cases Held	NUMERIC	N	N
INVTRY_HAZ	PALLET	Quantity Held	NUMERIC	N	N
INVTRY_HAZ	PALLET	Units Held	NUMERIC	N	N
INVTRY_HAZ	PALLET	Last Adjusted Date	DATE	N	R
INVTRY_HAZ	PALLET	Location Code	TEXT	N	R
INVTRY_HAZ	PALLET	Manufacture Date	DATE	N	R
INVTRY_HAZ	PALLET	Supplier Name	TEXT	N	N
INVTRY_HAZ	PALLET	On Hand Cases	NUMERIC	N	N
INVTRY_HAZ	PALLET	Quantity On Hand	NUMERIC	N	N
INVTRY_HAZ	PALLET	On Hand Units	NUMERIC	N	N
INVTRY_HAZ	PALLET	Pallet ID	NUMERIC	Y	R
INVTRY_HAZ	PALLET	Rotation No	TEXT	N	R
INVTRY_HAZ	PALLET	Sell By Date	DATE	N	R
INVTRY_HAZ	PALLET	Supplier Code	TEXT	N	R
INVTRY_HAZ	PALLET	In Cases	NUMERIC	N	N
INVTRY_HAZ	PALLET	Quantity In	NUMERIC	N	N
INVTRY_HAZ	PALLET	In Units	NUMERIC	N	N
INVTRY_HAZ	PALLET	Cases Out	NUMERIC	N	N
INVTRY_HAZ	PALLET	Quantity Out	NUMERIC	N	N
INVTRY_HAZ	PALLET	Units Out	NUMERIC	N	N
INVTRY_HAZ	HAZARD	Adr No	TEXT	N	N
INVTRY_HAZ	HAZARD	Adr Ref	TEXT	N	N
INVTRY_HAZ	HAZARD	Adr Un Name	TEXT	N	N
INVTRY_HAZ	HAZARD	Boil Point	TEXT	N	N
INVTRY_HAZ	HAZARD	Cargo Aircraft Only	TEXT	N	N
INVTRY_HAZ	HAZARD	Closed Cup	TEXT	N	N
INVTRY_HAZ	HAZARD	Comments	TEXT	N	N
INVTRY_HAZ	HAZARD	Concentration	TEXT	N	N
INVTRY_HAZ	HAZARD	Control Temp	TEXT	N	N
INVTRY_HAZ	HAZARD	Date Stamp	DATE	N	N
INVTRY_HAZ	HAZARD	Delete Flag	TEXT	N	N
INVTRY_HAZ	HAZARD	Description	TEXT	N	N
INVTRY_HAZ	HAZARD	Dischg Temp	TEXT	N	N
INVTRY_HAZ	HAZARD	Eac Template	TEXT	N	N
INVTRY_HAZ	HAZARD	Eac Template2	TEXT	N	N
INVTRY_HAZ	HAZARD	Eac Template3	TEXT	N	N
INVTRY_HAZ	HAZARD	Elevated Temperature	TEXT	N	N
INVTRY_HAZ	HAZARD	Emerg Action Code	TEXT	N	N
INVTRY_HAZ	HAZARD	Emerg Action Code2	TEXT	N	N
INVTRY_HAZ	HAZARD	Emerg Action Code3	TEXT	N	N
INVTRY_HAZ	HAZARD	Emerg Action Code4	TEXT	N	N
INVTRY_HAZ	HAZARD	Emerg Action Code5	TEXT	N	N
INVTRY_HAZ	HAZARD	Emerg Temp	TEXT	N	N
INVTRY_HAZ	HAZARD	Emergency Response	NUMERIC	N	N
INVTRY_HAZ	HAZARD	Ems Fire	TEXT	N	N
INVTRY_HAZ	HAZARD	Ems Page	TEXT	N	N
INVTRY_HAZ	HAZARD	Ems Page Template	TEXT	N	N
INVTRY_HAZ	HAZARD	Ems Spill	TEXT	N	N
INVTRY_HAZ	HAZARD	Flashpoint Yn	TEXT	N	N
INVTRY_HAZ	HAZARD	Flashpoint2	TEXT	N	N
INVTRY_HAZ	HAZARD	Freight Mode	TEXT	N	N
INVTRY_HAZ	HAZARD	Gas Filling	TEXT	N	N
INVTRY_HAZ	HAZARD	Hazard Class	TEXT	N	N
INVTRY_HAZ	HAZARD	Icao Un Name	TEXT	N	N
INVTRY_HAZ	HAZARD	Id No	TEXT	N	N
INVTRY_HAZ	HAZARD	Id Selfreact	NUMERIC	N	N
INVTRY_HAZ	HAZARD	Imco Number	TEXT	N	N
INVTRY_HAZ	HAZARD	Imdg Class	TEXT	N	N
INVTRY_HAZ	HAZARD	Imdg Class2	TEXT	N	N
INVTRY_HAZ	HAZARD	Imdg Class3	TEXT	N	N
INVTRY_HAZ	HAZARD	Imdg Class4	TEXT	N	N
INVTRY_HAZ	HAZARD	Imdg Page	TEXT	N	N
INVTRY_HAZ	HAZARD	Imp Control Temp	TEXT	N	N
INVTRY_HAZ	HAZARD	Imp Emergency Temp	TEXT	N	N
INVTRY_HAZ	HAZARD	Kemmler Num	TEXT	N	N
INVTRY_HAZ	HAZARD	Kemmler Num2	TEXT	N	N
INVTRY_HAZ	HAZARD	Kemmler Num3	TEXT	N	N
INVTRY_HAZ	HAZARD	Limited Qtys	TEXT	N	N
INVTRY_HAZ	HAZARD	Marine Pollutant	TEXT	N	N
INVTRY_HAZ	HAZARD	Melt Point	TEXT	N	N
INVTRY_HAZ	HAZARD	Mfag Table	TEXT	N	N
INVTRY_HAZ	HAZARD	Min Shell	TEXT	N	N
INVTRY_HAZ	HAZARD	Mp Flag	TEXT	N	N
INVTRY_HAZ	HAZARD	Flashpoint	TEXT	N	N
INVTRY_HAZ	HAZARD	UN Number	TEXT	N	N
INVTRY_HAZ	HAZARD	UN Variant	TEXT	N	N
INVTRY_HAZ	HAZARD	Pack Instr Code	NUMERIC	N	N
INVTRY_HAZ	HAZARD	Packing Group	TEXT	N	N
INVTRY_HAZ	HAZARD	Packing Group2	TEXT	N	N
INVTRY_HAZ	HAZARD	Packing Group3	TEXT	N	N
INVTRY_HAZ	HAZARD	Placard 1	TEXT	N	N
INVTRY_HAZ	HAZARD	Placard 2	TEXT	N	N
INVTRY_HAZ	HAZARD	Press Rel Type	TEXT	N	N
INVTRY_HAZ	HAZARD	Psa Class	TEXT	N	N
INVTRY_HAZ	HAZARD	Refer To Code	TEXT	N	N
INVTRY_HAZ	HAZARD	Res Grade	TEXT	N	N
INVTRY_HAZ	HAZARD	Rid No	TEXT	N	N
INVTRY_HAZ	HAZARD	Rid Ref	TEXT	N	N
INVTRY_HAZ	HAZARD	Risk Label	TEXT	N	N
INVTRY_HAZ	HAZARD	Solid Liquid Gas	TEXT	N	N
INVTRY_HAZ	HAZARD	Spec Reqt	TEXT	N	N
INVTRY_HAZ	HAZARD	Special Provisions	TEXT	N	N
INVTRY_HAZ	HAZARD	Specific Gravity	TEXT	N	N
INVTRY_HAZ	HAZARD	Stowage Category	TEXT	N	N
INVTRY_HAZ	HAZARD	Technical Name	TEXT	N	N
INVTRY_HAZ	HAZARD	Test Pressure1	TEXT	N	N
INVTRY_HAZ	HAZARD	Test Pressure2	TEXT	N	N
INVTRY_HAZ	HAZARD	Test Pressure3	TEXT	N	N
INVTRY_HAZ	HAZARD	Test Pressure4	TEXT	N	N
INVTRY_HAZ	HAZARD	Tunnel Code	TEXT	N	N
INVTRY_HAZ	HAZARD	UN Name	TEXT	N	N
INVTRY_HAZ	HAZARD	Valid From	DATE	N	N
INVTRY_HAZ	HAZARD	Valid To	DATE	N	N
INVTRY_HAZ	HAZARD	Version No	NUMERIC	N	N
JD_STK	JD_STK_RPT	Product Reference	TEXT	Y
JD_STK	JD_STK_RPT	Company Code	TEXT	N
JD_STK	JD_STK_RPT	Description	TEXT	N
JD_STK	JD_STK_RPT	In Stock Indicator	TEXT	Y
JD_STK	JD_STK_RPT	Line Type	TEXT	Y
JD_STK	JD_STK_RPT	Status	TEXT	N
JD_STK	JD_STK_RPT	Stock Code	TEXT	N
JD_STK	JD_STK_RPT	Stockist Code	TEXT	N
JD_STK	JD_STK_RPT	Stockist Sub Code	TEXT	N
JD_STK	JD_STK_RPT	Warehouse ID	TEXT	N
JOURNAL	HEADER	Advice Note Number	TEXT	N	N
JOURNAL	HEADER	Catch Weight	NUMBER	N	N
JOURNAL	HEADER	Customer Pallet Id	TEXT	N	N
JOURNAL	HEADER	Cust Rotation No	TEXT	N	R
JOURNAL	HEADER	Customer / Supplier	TEXT	N	Y
JOURNAL	HEADER	Description	TEXT	N	N
JOURNAL	HEADER	Employee Code	TEXT	N	Y
JOURNAL	HEADER	Employee Name	TEXT	N	N
JOURNAL	HEADER	Keyed Input Date	TEXT	N	N
JOURNAL	HEADER	Keyed Input Time	NUMBER	N	N
JOURNAL	HEADER	Location Code	TEXT	N	R
JOURNAL	HEADER	Manu Date	DATE	N	N
JOURNAL	HEADER	Measure Type	TEXT	N	Y
JOURNAL	HEADER	Audit Text	TEXT	N	N
JOURNAL	HEADER	Old Cust Pallet ID	TEXT	N	N
JOURNAL	HEADER	Old Cust Pallet ID	TEXT	N	N
JOURNAL	HEADER	Old Cust Pallet ID	TEXT	N	N
JOURNAL	HEADER	Old Cust Rot No	TEXT	N	N
JOURNAL	HEADER	Old Cust Rot No	TEXT	N	N
JOURNAL	HEADER	Old Cust Rot No	TEXT	N	N
JOURNAL	HEADER	Old Rotation No	TEXT	N	N
JOURNAL	HEADER	Old Sell By Date	DATE	N	R
JOURNAL	HEADER	Order Number	TEXT	N	N
JOURNAL	HEADER	Pallet Id	NUMERIC	N	N
JOURNAL	HEADER	Oty Moved (Cases)	NUMERIC	N	N
JOURNAL	HEADER	Qty Moved (Units)	NUMERIC	N	N
JOURNAL	HEADER	Reason Code	TEXT	N	N
JOURNAL	HEADER	Rotation No	TEXT	N	R
JOURNAL	HEADER	Sell By Date	DATE	N	R
JOURNAL	HEADER	Sellers Reference	TEXT	N	N
JOURNAL	HEADER	Stock Code	TEXT	N	R
JOURNAL	HEADER	Stock Ref	TEXT	N	N
JOURNAL	HEADER	Stockist Code	TEXT	N	R
JOURNAL	HEADER	Transaction Date	DATE	N	R
JOURNAL	HEADER	Transaction Qty	NUMERIC	N	N
JOURNAL	HEADER	Transaction Time	NUMERIC	N	N
JOURNAL	HEADER	Transaction Type	TEXT	Y	Y
JOURNAL	HEADER	Warehouse Id	TEXT	N	Y
JOURNAL	REFERENCE	Reference 2	TEXT	N	N
JOURNAL	REFERENCE	Reference 3	TEXT	N	N
JOURNAL	SERIAL	Branch Id	TEXT	N	N
JOURNAL	SERIAL	Date Created	DATE	N	N
JOURNAL	SERIAL	Journal No	NUMBER	N	N
JOURNAL	SERIAL	Line No	NUMBER	N	N
JOURNAL	SERIAL	Serial No	TEXT	Y	N
JRN_DTL	HEADER	Advice Note Number	TEXT	N	N
JRN_DTL	HEADER	Catch Weight	NUMBER	N	N
JRN_DTL	HEADER	Customer Pallet Id	TEXT	N	N
JRN_DTL	HEADER	Cust Rotation No	TEXT	N	R
JRN_DTL	HEADER	Customer / Supplier	TEXT	N	Y
JRN_DTL	HEADER	Description	TEXT	N	N
JRN_DTL	HEADER	Reason Code Description	TEXT	N	N
JRN_DTL	HEADER	Customer Name	TEXT	N	N
JRN_DTL	HEADER	Order Description	TEXT	N	N
JRN_DTL	HEADER	Order Cust PO Ref	TEXT	N	N
JRN_DTL	HEADER	Employee Code	TEXT	N	Y
JRN_DTL	HEADER	Employee Name	TEXT	N	N
JRN_DTL	HEADER	Actual Eaches	NUMERIC	N	N
JRN_DTL	HEADER	Keyed Input Date	TEXT	N	N
JRN_DTL	HEADER	Keyed Input Time	NUMBER	N	N
JRN_DTL	HEADER	Location Code	TEXT	N	R
JRN_DTL	HEADER	Manu Date	DATE	N	N
JRN_DTL	HEADER	Measure Qty Moved	NUMBER	N	N
JRN_DTL	HEADER	Measure Type	TEXT	N	Y
JRN_DTL	HEADER	Audit Text	TEXT	N	N
JRN_DTL	HEADER	Old Cust Pallet ID	TEXT	N	N
JRN_DTL	HEADER	Old Cust Rot No	TEXT	N	N
JRN_DTL	HEADER	Old Rotation No	TEXT	N	N
JRN_DTL	HEADER	Old Sell By  Date	DATE	N	R
JRN_DTL	HEADER	Order Number	TEXT	N	N
JRN_DTL	HEADER	Pallet Id	NUMERIC	N	N
JRN_DTL	HEADER	Picking Reason Code	TEXT	N	N
JRN_DTL	HEADER	Oty Moved (Cases)	NUMERIC	N	N
JRN_DTL	HEADER	Qty Moved (Units)	NUMERIC	N	N
JRN_DTL	HEADER	Ordered Eaches	NUMERIC	N	N
JRN_DTL	HEADER	Reason Code	TEXT	N	N
JRN_DTL	HEADER	Rotation No	TEXT	N	R
JRN_DTL	HEADER	Sell By Date	DATE	N	R
JRN_DTL	HEADER	Sellers Reference	TEXT	N	N
JRN_DTL	HEADER	Stock Code	TEXT	N	R
JRN_DTL	HEADER	Stock Ref	TEXT	N	N
JRN_DTL	HEADER	Stockist Code	TEXT	N	R
JRN_DTL	HEADER	Transaction Date	DATE	N	R
JRN_DTL	HEADER	Transaction Qty	NUMERIC	N	N
JRN_DTL	HEADER	Transaction Time	NUMERIC	N	N
JRN_DTL	HEADER	Transaction Type	TEXT	Y	Y
JRN_DTL	HEADER	Warehouse Id	TEXT	N	Y
KMOVES_DTL	DTL	Company Code	TEXT	N	Y
KMOVES_DTL	DTL	Cust Supp Code	TEXT	N	Y
KMOVES_DTL	DTL	Cust Supp Name	TEXT	N	Y
KMOVES_DTL	DTL	DH Order Num	TEXT	N	Y
KMOVES_DTL	DTL	WMS Ord No/GRN No	TEXT	N	Y
KMOVES_DTL	DTL	Quantity	NUMERIC	N	Y
KMOVES_DTL	DTL	Seq Number	NUMERIC	N	Y
KMOVES_DTL	DTL	Stock Code	TEXT	N	Y
KMOVES_DTL	DTL	Stockist Code	TEXT	N	Y
KMOVES_DTL	DTL	Transaction Date	DATE	N	Y
KMOVES_DTL	DTL	Transaction Number	DATE	N	Y
KMOVES_DTL	DTL	Transaction Type	TEXT	N	Y
KMOVES_HDR	HDR	Closing Date	DATE	N	Y
KMOVES_HDR	HDR	Closing Qty	NUMERIC	N	Y
KMOVES_HDR	HDR	Company Code	TEXT	N	Y
KMOVES_HDR	HDR	Cust Retn Value	NUMERIC	N	Y
KMOVES_HDR	HDR	Cust Retn	NUMERIC	N	Y
KMOVES_HDR	HDR	Val of Cust Retn	NUMERIC	N	Y
KMOVES_HDR	HDR	Description	TEXT	N	Y
KMOVES_HDR	HDR	Description3	TEXT	N	Y
KMOVES_HDR	HDR	Issue Value	NUMERIC	N	Y
KMOVES_HDR	HDR	Issues	NUMERIC	N	Y
KMOVES_HDR	HDR	Val of Issues	NUMERIC	N	Y
KMOVES_HDR	HDR	Opening Qty	NUMERIC	N	Y
KMOVES_HDR	HDR	Receipts	NUMERIC	N	Y
KMOVES_HDR	HDR	Seq Number	NUMERIC	N	Y
KMOVES_HDR	HDR	Stock Code	TEXT	N	Y
KMOVES_HDR	HDR	Stockist Code	TEXT	N	Y
KMOVES_HDR	HDR	Supp Retn Value	NUMERIC	N	Y
KMOVES_HDR	HDR	Supp Retn	NUMERIC	N	Y
KMOVES_HDR	HDR	Val of Supp Retn	NUMERIC	N	Y
KMOVES_HDR	HDR	Write Back Value	NUMERIC	N	Y
KMOVES_HDR	HDR	Write Back	NUMERIC	N	Y
KMOVES_HDR	HDR	Val of Wrt Back	NUMERIC	N	Y
KMOVES_HDR	HDR	Write Off Value	NUMERIC	N	Y
KMOVES_HDR	HDR	Write Off	NUMERIC	N	Y
KMOVES_HDR	HDR	Val of Wrt Off	NUMERIC	N	Y
LOC_XTRACT	HEADER	Aisle Seq	TEXT	N	N
LOC_XTRACT	HEADER	Area	TEXT	N	Y
LOC_XTRACT	HEADER	Bond	TEXT	N	Y
LOC_XTRACT	HEADER	Company	TEXT	Y	Y
LOC_XTRACT	HEADER	Link Loc	TEXT	N	N
LOC_XTRACT	HEADER	Max Cases	NUMERIC	N	N
LOC_XTRACT	HEADER	Max Pallets	NUMERIC	N	N
LOC_XTRACT	HEADER	Putaway Seq	NUMERIC	N	N
LOC_XTRACT	HEADER	Restrict	TEXT	N	N
LOC_XTRACT	HEADER	Type	TEXT	N	Y
LOC_XTRACT	HEADER	Use	TEXT	N	Y
LOC_XTRACT	HEADER	LV	TEXT	N	N
LOC_XTRACT	HEADER	Loc Bond	TEXT	N	N
LOC_XTRACT	HEADER	CD	TEXT	N	N
LOC_XTRACT	HEADER	Location	TEXT	Y	R
LOC_XTRACT	HEADER	Loc Seq	TEXT	N	N
LOC_XTRACT	HEADER	Status	TEXT	N	Y
LOC_XTRACT	HEADER	MD	TEXT	N	Y
LOC_XTRACT	HEADER	No Labels	NUMERIC	N	N
LOC_XTRACT	HEADER	Opp Loc	TEXT	N	N
LOC_XTRACT	HEADER	Pall Type	TEXT	N	Y
LOC_XTRACT	HEADER	Pick Seq	NUMERIC	N	N
LOC_XTRACT	HEADER	Put Seq	TEXT	N	N
LOC_XTRACT	HEADER	Qty Pals	NUMERIC	N	N
LOC_XTRACT	HEADER	RDT	TEXT	N	N
LOC_XTRACT	HEADER	RC	TEXT	N	N
LOC_XTRACT	HEADER	SA	TEXT	N	N
LOC_XTRACT	HEADER	ST Type	TEXT	N	N
LOC_XTRACT	HEADER	Truck	TEXT	N	N
LOC_XTRACT	HEADER	User	TEXT	N	N
LOC_XTRACT	HEADER	Warehouse	TEXT	Y	Y
LOGON_AUD	HEADER	Action	NUMBER	N	Y
LOGON_AUD	HEADER	Action name	TEXT	N	Y
LOGON_AUD	HEADER	Successful Login Y/N	TEXT	N	Y
LOGON_AUD	HEADER	System Process Login Y/N	TEXT	N	Y
LOGON_AUD	HEADER	Logoff Date	DATE	N	R
LOGON_AUD	HEADER	Priv Used	TEXT	N	Y
LOGON_AUD	HEADER	Error Code	NUMERIC	N	Y
LOGON_AUD	HEADER	Session Length (Minutes)	NUMERIC	N	R
LOGON_AUD	HEADER	Sessionid	NUMERIC	N	Y
LOGON_AUD	HEADER	Logon Date	DATE	N	R
LOGON_AUD	HEADER	Username	TEXT	Y	Y
MASTER_OML	HEADER	Address Line 1	TEXT	N	N
MASTER_OML	HEADER	Address Line 2	TEXT	N	N
MASTER_OML	HEADER	Last Change Date	DATE	N	R
MASTER_OML	HEADER	Last Change User	TEXT	N	Y
MASTER_OML	HEADER	Country Code	TEXT	N	Y
MASTER_OML	HEADER	Create Date Master Order	DATE	N	R
MASTER_OML	HEADER	Create User	TEXT	N	Y
MASTER_OML	HEADER	Customer Code	TEXT	N	R
MASTER_OML	HEADER	County	TEXT	N	Y
MASTER_OML	HEADER	Town	TEXT	N	Y
MASTER_OML	HEADER	Status Desc	TEXT	N	N
MASTER_OML	HEADER	Primary Warehouse	TEXT	N	N
MASTER_OML	HEADER	Create Date DHL Link	DATE	N	R
MASTER_OML	HEADER	EDI Control Num	TEXT	N	R
MASTER_OML	HEADER	Delivery Date	DATE	N	R
MASTER_OML	HEADER	Name	TEXT	N	N
MASTER_OML	HEADER	DHL Link Ref	TEXT	N	R
MASTER_OML	HEADER	Owner	TEXT	N	Y
MASTER_OML	HEADER	Postcode	TEXT	N	R
MASTER_OML	HEADER	Status	TEXT	N	Y
MASTER_OML	DETAIL	Change Date	DATE	N	R
MASTER_OML	DETAIL	Change User	TEXT	N	Y
MASTER_OML	DETAIL	Create Date Master Order	DATE	N	R
MASTER_OML	DETAIL	Create User	TEXT	N	Y
MASTER_OML	DETAIL	DESCRIPTION	TEXT	N	N
MASTER_OML	DETAIL	DESCRIPTION 2	TEXT	N	R
MASTER_OML	DETAIL	DESCRIPTION 3	TEXT	N	N
MASTER_OML	DETAIL	Status Desc	TEXT	N	N
MASTER_OML	DETAIL	Generic Sku	TEXT	N	R
MASTER_OML	DETAIL	DH Line No.	NUMERIC	N	R
MASTER_OML	DETAIL	Anticipated Eaches	NUMERIC	N	N
MASTER_OML	DETAIL	Despatched Eaches	NUMERIC	N	N	N,O,C,9
MASTER_OML	DETAIL	Ordered Eaches	NUMERIC	N	N
MASTER_OML	DETAIL	Sent to WMS Eaches	NUMERIC	N	N
MASTER_OML	DETAIL	Customer Order	TEXT	N	R
MASTER_OML	DETAIL	Status	TEXT	N	R
MASTER_OML	DETAIL	ABC Code	TEXT	N	Y
MED_NUM	MED_NUM	Free Cases	NUMBER	N	N
MED_NUM	MED_NUM	PO Number	TEXT	N	N
MED_NUM	MED_NUM	Allocated Cases	NUMBER	N	N
MED_NUM	MED_NUM	Committed Cases	NUMBER	N	N
MED_NUM	MED_NUM	Customer Rotation Number	TEXT	N	R
MED_NUM	MED_NUM	Product Description	TEXT	N	N
MED_NUM	MED_NUM	Held Cases	NUMBER	N	N
MED_NUM	MED_NUM	Location	TEXT	N	R
MED_NUM	MED_NUM	Sequence Number	TEXT	N	R
MED_NUM	MED_NUM	On Hand Cases	NUMBER	N	N
MED_NUM	MED_NUM	Pallet ID	NUMBER	N	N
MED_NUM	MED_NUM	Rotation Number	TEXT	N	R
MED_NUM	MED_NUM	Sell By Date	DATE	N	N
MED_NUM	MED_NUM	Med Number	TEXT	N	R
MED_NUM	MED_NUM	Product Code	TEXT	N	R
MED_NUM	MED_NUM	Owner Code	TEXT	N	R
MED_NUM	MED_NUM	Warehouse	TEXT	N	R
METAPACK	METAPACK	Company Code	TEXT	N	Y
METAPACK	METAPACK	Date	DATE	Y	R
METAPACK	METAPACK	Message	TEXT	Y	Y
METAPACK	METAPACK	Stockist Name	TEXT	N	Y
METAPACK	METAPACK	Order Num	TEXT	Y	R
METAPACK	METAPACK	Status	TEXT	Y	Y
METAPACK	METAPACK	Stockist Code	TEXT	Y	Y
METAPACK	METAPACK	Time	NUMBER	Y	Y
METAPACK	METAPACK	Warehouse Id	TEXT	N	Y
METAPACK	METAPACK	Warehouse Name	TEXT	N	Y
OINV_CHGS	CHARGES	Case Qty	NUMBER	N	N
OINV_CHGS	CHARGES	Company	TEXT	N	Y
OINV_CHGS	CHARGES	Charge Description	VARCHAR2	N	N
OINV_CHGS	CHARGES	Break Type Desc	VARCHAR2	N	N
OINV_CHGS	CHARGES	Rate	NUMBER	N	N
OINV_CHGS	CHARGES	Break Type	VARCHAR2	N	Y
OINV_CHGS	CHARGES	Price Per Qty	NUMBER	N	N
OINV_CHGS	CHARGES	Invoice Type	VARCHAR2	N	Y
OINV_CHGS	CHARGES	Charge Code	VARCHAR2	N	Y
OINV_CHGS	CHARGES	Invoice Number	NUMBER	N	R
OINV_CHGS	CHARGES	Order Line	NUMBER	N	N
OINV_CHGS	CHARGES	Order Num	TEXT	N	Y
OINV_CHGS	CHARGES	Owner	TEXT	N	Y
OINV_CHGS	CHARGES	Owner Sub Code	TEXT	N	Y
OINV_CHGS	CHARGES	Pallet Qty	NUMBER	N	N
OINV_CHGS	CHARGES	Product Type	TEXT	N	Y
OINV_CHGS	CHARGES	Quantity	NUMBER	N	N
OINV_CHGS	CHARGES	Rate ID	TEXT	N	Y
OINV_CHGS	CHARGES	Start Date	DATE	N	N
OINV_CHGS	CHARGES	Stock Code	TEXT	N	Y
OINV_CHGS	CHARGES	Charge Type	VARCHAR2	N	Y
OINV_CHGS	CHARGES	Charge Amt	NUMBER	N	N
OINV_CHGS	CHARGES	Transaction Date	DATE	N	Y
OINV_CHGS	CHARGES	Unit Qty	NUMBER	N	N
OINV_CHGS	CHARGES	Vat Code	TEXT	N	Y
OINV_CHGS	CHARGES	Warehouse	TEXT	Y	Y
OINV_CHGS	CHARGES	Weight	NUMBER	N	N
OINV_CHGS	INVOICE	Due Date	DATE	N	N
OINV_CHGS	INVOICE	Invoice Date	DATE	N	R
OINV_CHGS	INVOICE	Printed Flag	VARCHAR2	N	Y
OINV_RATES	CHG_CODES	Charge Type	VARCHAR2	Y	Y
OINV_RATES	CHG_CODES	Manual/Automatic	VARCHAR2	N	Y
OINV_RATES	CHG_CODES	Charge Code	VARCHAR2	Y	Y
OINV_RATES	CHG_CODES	Charge Delete Flag	VARCHAR2	N	Y
OINV_RATES	CHG_CODES	Charge Description	VARCHAR2	N	N
OINV_RATES	CHG_CODES	Extra Description	VARCHAR2	N	N
OINV_RATES	CHG_CODES	Charge Type Desc	VARCHAR2	N	N
OINV_RATES	CHG_CODES	Charge Level	VARCHAR2	N	Y
OINV_RATES	CHG_CODES	Rate ID	TEXT	N	Y
OINV_RATES	CHG_CODES	Short Charge Desc	VARCHAR2	N	N
OINV_RATES	CHG_CODES	Stock Code Filter	TEXT	N	Y
OINV_RATES	CHG_CODES	Owner Filter	TEXT	N	Y
OINV_RATES	CHG_CODES	Owner Sub Code Filter	TEXT	N	Y
OINV_RATES	CHG_CODES	Warehouse filter	VARCHAR2	N	Y
OINV_RATES	RATES	Break Type	VARCHAR2	N	Y
OINV_RATES	RATES	Breakpoint Type	VARCHAR2	N	Y
OINV_RATES	RATES	Rate Delete Flag	VARCHAR2	N	Y
OINV_RATES	RATES	Rate Description	VARCHAR2	N	N
OINV_RATES	RATES	Breakpoint Type Desc	VARCHAR2	N	N
OINV_RATES	RATES	Break Type Desc	VARCHAR2	N	N
OINV_RATES	RATES	Date To	DATE	Y	R
OINV_RATES	RATES	Rounding Indicator	VARCHAR2	N	Y
OINV_RATES	RATES	Date From	DATE	Y	R
OINV_RATES	BANDS	Fixed Amount	NUMBER	N	N
OINV_RATES	BANDS	Rate	NUMBER	N	N
OINV_RATES	BANDS	Breakpoint	NUMBER	N	N
OINV_RATES	BANDS	Price Per Qty	NUMBER	N	N
OINV_SETUP	OWNER	Owner Customer Code	TEXT	N	Y
OINV_SETUP	OWNER	Owner Ledger	VARCHAR2	N	Y
OINV_SETUP	OWNER	Owner Customer Sub Code	TEXT	N	N
OINV_SETUP	OWNER	Rent Charge Type Desc	VARCHAR2	N	N
OINV_SETUP	OWNER	Rent Level Desc	VARCHAR2	N	N
OINV_SETUP	OWNER	Rent Timing Desc	VARCHAR2	N	N
OINV_SETUP	OWNER	Rent Whole/Partial Desc	VARCHAR2	N	N
OINV_SETUP	OWNER	Owner Invoicing	VARCHAR2	N	Y
OINV_SETUP	OWNER	Invoice Gen Charges	VARCHAR2	N	N
OINV_SETUP	OWNER	Owner Name	VARCHAR2	N	N
OINV_SETUP	OWNER	Order Header Charges	VARCHAR2	N	N
OINV_SETUP	OWNER	Order Pallet Charges	VARCHAR2	N	N
OINV_SETUP	OWNER	Order Pallet Exchange Charges	VARCHAR2	N	N
OINV_SETUP	OWNER	Order Well Charges	VARCHAR2	N	N
OINV_SETUP	OWNER	Receipt Detail Charges	VARCHAR2	N	N
OINV_SETUP	OWNER	Receipt Header Charges	VARCHAR2	N	N
OINV_SETUP	OWNER	Rent Charge Type	VARCHAR2	N	Y
OINV_SETUP	OWNER	Rent Cycle	VARCHAR2	N	N
OINV_SETUP	OWNER	Rent Level	VARCHAR2	N	Y
OINV_SETUP	OWNER	Rent Start Date	DATE	N	N
OINV_SETUP	OWNER	Rent Timing	VARCHAR2	N	Y
OINV_SETUP	OWNER	Rent Whole/Partial	VARCHAR2	N	Y
OINV_SETUP	OWNER	Owner	TEXT	Y	Y
OINV_SETUP	OWNER	Owner Sub Code	TEXT	N	Y
ORDER	HEADER	Booking Date	DATE	N	R
ORDER	HEADER	Booking Reference	TEXT	N	Y
ORDER	HEADER	Booking Time	NUMERIC	N	N
ORDER	HEADER	Brand Id	TEXT	N	N
ORDER	HEADER	Customer Code	TEXT	N	R
ORDER	HEADER	Customer PO Reference	TEXT	N	Y
ORDER	HEADER	Start Due Date	DATE	N	R
ORDER	HEADER	Despatch Text 1	TEXT	N	N
ORDER	HEADER	Despatch Text 2	TEXT	N	N
ORDER	HEADER	Despatch Text 3	TEXT	N	N
ORDER	HEADER	Despatch Text 4	TEXT	N	N
ORDER	HEADER	Despatch Text 5	TEXT	N	N
ORDER	HEADER	Despatch Text 6	TEXT	N	N
ORDER	HEADER	End Due Date	DATE	N	R
ORDER	HEADER	Extra Reference	TEXT	N	Y
ORDER	HEADER	Haulier Code	TEXT	N	Y
ORDER	HEADER	Carrier Reference	TEXT	N	N
ORDER	HEADER	Misc Text 1	TEXT	N	N
ORDER	HEADER	Mob Tel No	TEXT	N	N
ORDER	HEADER	Order Reference	TEXT	N	Y
ORDER	HEADER	Order Entry Date	DATE	N	R
ORDER	HEADER	Order Number	TEXT	Y	R
ORDER	HEADER	Order Owner	TEXT	Y	Y
ORDER	HEADER	Order Priority	NUMERIC	N	Y
ORDER	HEADER	Routing Code	TEXT	N	Y
ORDER	HEADER	Select Type	TEXT	N	Y
ORDER	HEADER	Order Status	TEXT	N	R
ORDER	HEADER	Order Type	TEXT	N	R	H,E,C,U,T,A,O,D,S,N,K,R
ORDER	HEADER	Ordered Cases	NUMERIC	N	N
ORDER	HEADER	Ordered Units	NUMERIC	N	N
ORDER	HEADER	Main Tel No	TEXT	N	N
ORDER	HEADER	Picking Text 1	TEXT	N	N
ORDER	HEADER	Picking Text 2	TEXT	N	N
ORDER	HEADER	Picking Text 3	TEXT	N	N
ORDER	HEADER	Picking Text 4	TEXT	N	N
ORDER	HEADER	Picking Text 5	TEXT	N	N
ORDER	HEADER	Picking Text 6	TEXT	N	N
ORDER	HEADER	Previous Order Status	TEXT	N	N
ORDER	HEADER	Quantity Ordered	NUMERIC	N	N
ORDER	HEADER	Reference 1	TEXT	N	N
ORDER	HEADER	Reference 2	TEXT	N	N
ORDER	HEADER	Reference 3	TEXT	N	N
ORDER	HEADER	Shipping Instructions	TEXT	N	N
ORDER	HEADER	Special Instructions	TEXT	N	N
ORDER	HEADER	Store Code	TEXT	N	N
ORDER	HEADER	Store Desc	TEXT	N	N
ORDER	HEADER	Carrier Code	TEXT	N	Y
ORDER	HEADER	Address Line 1	TEXT	N	N
ORDER	HEADER	Address Line 2	TEXT	N	N
ORDER	HEADER	Address Line 5	TEXT	N	N
ORDER	HEADER	Address Line 6	TEXT	N	N
ORDER	HEADER	Address Line 7	TEXT	N	N
ORDER	HEADER	Country Code	TEXT	N	Y
ORDER	HEADER	County	TEXT	N	N
ORDER	HEADER	Email Address	TEXT	N	N
ORDER	HEADER	Name	TEXT	N	N
ORDER	HEADER	Post Code	TEXT	N	N
ORDER	HEADER	Sales Area	TEXT	N	N
ORDER	HEADER	Sales Territory	TEXT	N	N
ORDER	HEADER	Town	TEXT	N	N
ORDER	HEADER	Warehouse ID	TEXT	Y	Y
ORDER	HEADER	Weighbridge Number	TEXT	N	N
ORDER	HEADER	Work Tel No	TEXT	N	N
ORDER	WELL	Actual Del Date	DATE	N	N
ORDER	WELL	Actual Del Time	NUMERIC	N	N
ORDER	WELL	Allocated Date	DATE	N	N
ORDER	WELL	Cancelled By	TEXT	N	N
ORDER	WELL	Pack Closed By	TEXT	N	N
ORDER	WELL	Pack Closed Date	TEXT	N	N
ORDER	WELL	Cust POD Date	NUMERIC	N	N
ORDER	WELL	Cust POD Time	NUMERIC	N	N
ORDER	WELL	Cust POD User	TEXT	N	N
ORDER	WELL	Cust Rec Ref	TEXT	N	N
ORDER	WELL	Cancelled Date	DATE	N	R
ORDER	WELL	Depot POD Date	NUMERIC	N	N
ORDER	WELL	Depot POD Time	NUMERIC	N	N
ORDER	WELL	Depot POD User	TEXT	N	N
ORDER	WELL	Despatch Text 1	TEXT	N	N
ORDER	WELL	Despatch Text 2	TEXT	N	N
ORDER	WELL	Despatch Text 3	TEXT	N	N
ORDER	WELL	Despatch Text 4	TEXT	N	N
ORDER	WELL	Despatch Text 5	TEXT	N	N
ORDER	WELL	Despatch Text 6	TEXT	N	N
ORDER	WELL	Despatch Date	DATE	N	R
ORDER	WELL	ETA Del Date	DATE	N	N
ORDER	WELL	ETA Del Time	NUMERIC	N	N
ORDER	WELL	Load Number	TEXT	Y	R
ORDER	WELL	Carrier Reference	TEXT	N	Y
ORDER	WELL	On Time Delivery	TEXT	N	N
ORDER	WELL	Order Status	TEXT	N	N
ORDER	WELL	Load Units	NUMERIC	N	N
ORDER	WELL	Load Cases	NUMERIC	N	N
ORDER	WELL	Load Pallets	NUMERIC	N	N
ORDER	WELL	Load Volume	NUMERIC	N	N
ORDER	WELL	Load Weight	NUMERIC	N	N
ORDER	WELL	Pack Number	TEXT	N	N
ORDER	WELL	Pick Confirm Date	DATE	N	R
ORDER	WELL	Picked Date	DATE	N	R
ORDER	WELL	Picking Text 1	TEXT	N	N
ORDER	WELL	Picking Text 2	TEXT	N	N
ORDER	WELL	Picking Text 3	TEXT	N	N
ORDER	WELL	Picking Text 4	TEXT	N	N
ORDER	WELL	Picking Text 5	TEXT	N	N
ORDER	WELL	Picking Text 6	TEXT	N	N
ORDER	WELL	POD Received	TEXT	N	Y
ORDER	WELL	Product Type	TEXT	Y	R
ORDER	WELL	Received Date	DATE	N	R
ORDER	WELL	Received Time	NUMERIC	N	N
ORDER	WELL	Route Code	TEXT	Y	R
ORDER	WELL	POD Signed By	TEXT	N	N
ORDER	WELL	Cancelled Time	NUMBER	N	N
ORDER	DETAIL	Base Price	NUMERIC	N	N
ORDER	DETAIL	Buyers Reference	TEXT	N	N
ORDER	DETAIL	Customer Rotation No	TEXT	N	R
ORDER	DETAIL	Delivered Cases	NUMERIC	N	N
ORDER	DETAIL	Delivered Units	NUMERIC	N	N
ORDER	DETAIL	Delivery Item No	TEXT	N	N
ORDER	DETAIL	Stock Description	TEXT	N	N
ORDER	DETAIL	Stock Description2	TEXT	N	Y
ORDER	DETAIL	Stock Description3	TEXT	N	N
ORDER	DETAIL	Despatch Text 1	TEXT	N	N
ORDER	DETAIL	Despatch Text 2	TEXT	N	N
ORDER	DETAIL	Despatch Text 3	TEXT	N	N
ORDER	DETAIL	Despatch Text 4	TEXT	N	N
ORDER	DETAIL	Despatch Text 5	TEXT	N	N
ORDER	DETAIL	Despatch Text 6	TEXT	N	N
ORDER	DETAIL	Despatched Cases	NUMERIC	N	N
ORDER	DETAIL	Despatched Units	NUMERIC	N	N
ORDER	DETAIL	Despatch Note No	NUMERIC	N	R
ORDER	DETAIL	Line No	NUMERIC	Y	N
ORDER	DETAIL	Line Type	TEXT	N	N	1,2,3,4,5,6,7,8,9,R,A,B,O,P,Q,S
ORDER	DETAIL	Location Code	TEXT	N	R
ORDER	DETAIL	Carrier Reference	TEXT	N	Y
ORDER	DETAIL	Client Line Number	NUMERIC	N	N
ORDER	DETAIL	Line Comment	TEXT	N	N
ORDER	DETAIL	Order Status	TEXT	N	R
ORDER	DETAIL	Ordered Cases	NUMERIC	N	N
ORDER	DETAIL	Ordered Units	NUMERIC	N	N
ORDER	DETAIL	Pallet ID	NUMERIC	N	R
ORDER	DETAIL	Picking Text 1	TEXT	N	N
ORDER	DETAIL	Picking Text 2	TEXT	N	N
ORDER	DETAIL	Picking Text 3	TEXT	N	N
ORDER	DETAIL	Picking Text 4	TEXT	N	N
ORDER	DETAIL	Picking Text 5	TEXT	N	N
ORDER	DETAIL	Picking Text 6	TEXT	N	N
ORDER	DETAIL	Previous Order Status	TEXT	N	N
ORDER	DETAIL	Price	NUMERIC	N	N
ORDER	DETAIL	Quantity Despatched	NUMERIC	N	N
ORDER	DETAIL	Quantity Ordered	NUMERIC	N	N
ORDER	DETAIL	Reason Code	TEXT	N	R
ORDER	DETAIL	Rotation No	TEXT	N	R
ORDER	DETAIL	Sellers Reference	TEXT	N	N
ORDER	DETAIL	Cost	NUMERIC	N	N
ORDER	DETAIL	Stock Code	TEXT	Y	R
ORDER	DETAIL	Stockist Code	TEXT	Y	Y
ORDER	DETAIL	Sales Area	TEXT	N	N
ORDER	DETAIL	Sales Territory	TEXT	N	N
ORDER	DETAIL	Weight	NUMERIC	N	N
ORDER	PALLET	Allocated Cases	NUMERIC	N	N
ORDER	PALLET	Quantity Allocated	NUMERIC	N	N
ORDER	PALLET	Allocated Units	NUMERIC	N	N
ORDER	PALLET	Customer Pallet ID	TEXT	N	R
ORDER	PALLET	Customer Rotation No	TEXT	N	R
ORDER	PALLET	Despatch Text 1	TEXT	N	N
ORDER	PALLET	Despatch Text 2	TEXT	N	N
ORDER	PALLET	Despatch Text 3	TEXT	N	N
ORDER	PALLET	Despatch Text 4	TEXT	N	N
ORDER	PALLET	Despatch Text 5	TEXT	N	N
ORDER	PALLET	Despatch Text 6	TEXT	N	N
ORDER	PALLET	Line No	NUMERIC	Y	N
ORDER	PALLET	Carrier Reference	TEXT	N	Y
ORDER	PALLET	Ordered Cases	NUMERIC	N	N
ORDER	PALLET	Quantity Ordered	NUMERIC	N	N
ORDER	PALLET	Ordered Units	NUMERIC	N	N
ORDER	PALLET	Page Number	NUMERIC	Y	N
ORDER	PALLET	Pallet Type	TEXT	N	R
ORDER	PALLET	Picked Cases	NUMERIC	N	N
ORDER	PALLET	Pick Location	TEXT	N	R
ORDER	PALLET	Pick Pallet ID	NUMERIC	N	R
ORDER	PALLET	Quantity Picked	NUMERIC	N	N
ORDER	PALLET	Pick Task Identifier	TEXT	N	N
ORDER	PALLET	Picked Units	NUMERIC	N	N
ORDER	PALLET	Picking Text 1	TEXT	N	N
ORDER	PALLET	Picking Text 2	TEXT	N	N
ORDER	PALLET	Picking Text 3	TEXT	N	N
ORDER	PALLET	Picking Text 4	TEXT	N	N
ORDER	PALLET	Picking Text 5	TEXT	N	N
ORDER	PALLET	Picking Text 6	TEXT	N	N
ORDER	PALLET	Quantity Despatched	NUMERIC	N	N
ORDER	PALLET	Despatched Cases	NUMERIC	N	N
ORDER	PALLET	Despatched Units	NUMERIC	N	N
ORDER	PALLET	Rotation No	TEXT	N	R
ORDER	PALLET	Sell By Date	DATE	N	R
ORDER_PACK	HEADER	Booking Date	DATE	N	R
ORDER_PACK	HEADER	Booking Reference	TEXT	N	Y
ORDER_PACK	HEADER	Booking Time	NUMERIC	N	N
ORDER_PACK	HEADER	Brand Id	TEXT	N	N
ORDER_PACK	HEADER	Customer Code	TEXT	N	R
ORDER_PACK	HEADER	Customer PO Reference	TEXT	N	Y
ORDER_PACK	HEADER	Start Due Date	DATE	N	R
ORDER_PACK	HEADER	Despatch Text 1	TEXT	N	N
ORDER_PACK	HEADER	Despatch Text 2	TEXT	N	N
ORDER_PACK	HEADER	Despatch Text 3	TEXT	N	N
ORDER_PACK	HEADER	Despatch Text 4	TEXT	N	N
ORDER_PACK	HEADER	Despatch Text 5	TEXT	N	N
ORDER_PACK	HEADER	Despatch Text 6	TEXT	N	N
ORDER_PACK	HEADER	End Due Date	DATE	N	R
ORDER_PACK	HEADER	Extra Reference	TEXT	N	Y
ORDER_PACK	HEADER	Haulier Code	TEXT	N	Y
ORDER_PACK	HEADER	Carrier Reference	TEXT	N	N
ORDER_PACK	HEADER	Misc Text 1	TEXT	N	N
ORDER_PACK	HEADER	Mob Tel No	TEXT	N	N
ORDER_PACK	HEADER	Order Reference	TEXT	N	Y
ORDER_PACK	HEADER	Order Entry Date	DATE	N	R
ORDER_PACK	HEADER	Order Number	TEXT	Y	R
ORDER_PACK	HEADER	Order Owner	TEXT	Y	Y
ORDER_PACK	HEADER	Order Priority	NUMERIC	N	Y
ORDER_PACK	HEADER	Routing Code	TEXT	N	Y
ORDER_PACK	HEADER	Select Type	TEXT	N	Y
ORDER_PACK	HEADER	Order Status	TEXT	N	R
ORDER_PACK	HEADER	Order Type	TEXT	N	R	H,E,C,U,T,A,O,D,S,N,K,R
ORDER_PACK	HEADER	Ordered Cases	NUMERIC	N	N
ORDER_PACK	HEADER	Ordered Units	NUMERIC	N	N
ORDER_PACK	HEADER	Main Tel No	TEXT	N	N
ORDER_PACK	HEADER	Picking Text 1	TEXT	N	N
ORDER_PACK	HEADER	Picking Text 2	TEXT	N	N
ORDER_PACK	HEADER	Picking Text 3	TEXT	N	N
ORDER_PACK	HEADER	Picking Text 4	TEXT	N	N
ORDER_PACK	HEADER	Picking Text 5	TEXT	N	N
ORDER_PACK	HEADER	Picking Text 6	TEXT	N	N
ORDER_PACK	HEADER	Previous Order Status	TEXT	N	N
ORDER_PACK	HEADER	Quantity Ordered	NUMERIC	N	N
ORDER_PACK	HEADER	Reference 1	TEXT	N	N
ORDER_PACK	HEADER	Reference 2	TEXT	N	N
ORDER_PACK	HEADER	Reference 3	TEXT	N	N
ORDER_PACK	HEADER	Shipping Instructions	TEXT	N	N
ORDER_PACK	HEADER	Special Instructions	TEXT	N	N
ORDER_PACK	HEADER	Store Code	TEXT	N	N
ORDER_PACK	HEADER	Store Desc	TEXT	N	N
ORDER_PACK	HEADER	Carrier Code	TEXT	N	Y
ORDER_PACK	HEADER	Address Line 1	TEXT	N	N
ORDER_PACK	HEADER	Address Line 2	TEXT	N	N
ORDER_PACK	HEADER	Address Line 5	TEXT	N	N
ORDER_PACK	HEADER	Address Line 6	TEXT	N	N
ORDER_PACK	HEADER	Address Line 7	TEXT	N	N
ORDER_PACK	HEADER	Country Code	TEXT	N	Y
ORDER_PACK	HEADER	County	TEXT	N	N
ORDER_PACK	HEADER	Email Address	TEXT	N	N
ORDER_PACK	HEADER	Name	TEXT	N	N
ORDER_PACK	HEADER	Post Code	TEXT	N	N
ORDER_PACK	HEADER	Sales Area	TEXT	N	N
ORDER_PACK	HEADER	Sales Territory	TEXT	N	N
ORDER_PACK	HEADER	Town	TEXT	N	N
ORDER_PACK	HEADER	Warehouse ID	TEXT	Y	Y
ORDER_PACK	HEADER	Weighbridge Number	TEXT	N	N
ORDER_PACK	HEADER	Work Tel No	TEXT	N	N
ORDER_PACK	WELL	Actual Del Date	DATE	N	N
ORDER_PACK	WELL	Actual Del Time	NUMERIC	N	N
ORDER_PACK	WELL	Allocated Date	DATE	N	N
ORDER_PACK	WELL	Cancelled By	TEXT	N	N
ORDER_PACK	WELL	Cust POD Date	NUMERIC	N	N
ORDER_PACK	WELL	Cust POD Time	NUMERIC	N	N
ORDER_PACK	WELL	Cust POD User	TEXT	N	N
ORDER_PACK	WELL	Cust Rec Ref	TEXT	N	N
ORDER_PACK	WELL	Cancelled Date	DATE	N	R
ORDER_PACK	WELL	Depot POD Date	NUMERIC	N	N
ORDER_PACK	WELL	Depot POD Time	NUMERIC	N	N
ORDER_PACK	WELL	Depot POD User	TEXT	N	N
ORDER_PACK	WELL	Despatch Text 1	TEXT	N	N
ORDER_PACK	WELL	Despatch Text 2	TEXT	N	N
ORDER_PACK	WELL	Despatch Text 3	TEXT	N	N
ORDER_PACK	WELL	Despatch Text 4	TEXT	N	N
ORDER_PACK	WELL	Despatch Text 5	TEXT	N	N
ORDER_PACK	WELL	Despatch Text 6	TEXT	N	N
ORDER_PACK	WELL	Despatch Date	DATE	N	R
ORDER_PACK	WELL	Pack Number	TEXT	N	N
ORDER_PACK	WELL	Pack Closed Date	TEXT	N	N
ORDER_PACK	WELL	Pack Closed By	TEXT	N	N
ORDER_PACK	WELL	Carrier Reference	TEXT	N	Y
ORDER_PACK	WELL	ETA Del Date	DATE	N	N
ORDER_PACK	WELL	ETA Del Time	NUMERIC	N	N
ORDER_PACK	WELL	Load Number	TEXT	Y	R
ORDER_PACK	WELL	On Time Delivery	TEXT	N	N
ORDER_PACK	WELL	Order Status	TEXT	N	N
ORDER_PACK	WELL	Load Units	NUMERIC	N	N
ORDER_PACK	WELL	Load Cases	NUMERIC	N	N
ORDER_PACK	WELL	Load Pallets	NUMERIC	N	N
ORDER_PACK	WELL	Load Volume	NUMERIC	N	N
ORDER_PACK	WELL	Load Weight	NUMERIC	N	N
ORDER_PACK	WELL	Pick Confirm Date	DATE	N	R
ORDER_PACK	WELL	Picked Date	DATE	N	R
ORDER_PACK	WELL	Picking Text 1	TEXT	N	N
ORDER_PACK	WELL	Picking Text 2	TEXT	N	N
ORDER_PACK	WELL	Picking Text 3	TEXT	N	N
ORDER_PACK	WELL	Picking Text 4	TEXT	N	N
ORDER_PACK	WELL	Picking Text 5	TEXT	N	N
ORDER_PACK	WELL	Picking Text 6	TEXT	N	N
ORDER_PACK	WELL	POD Received	TEXT	N	Y
ORDER_PACK	WELL	Product Type	TEXT	Y	R
ORDER_PACK	WELL	Received Date	DATE	N	R
ORDER_PACK	WELL	Received Time	NUMERIC	N	N
ORDER_PACK	WELL	Route Code	TEXT	Y	R
ORDER_PACK	WELL	POD Signed By	TEXT	N	N
ORDER_PACK	WELL	Cancelled Time	NUMBER	N	N
ORDER_PACK	DETAIL	Base Price	NUMERIC	N	N
ORDER_PACK	DETAIL	Buyers Reference	TEXT	N	N
ORDER_PACK	DETAIL	Customer Rotation No	TEXT	N	R
ORDER_PACK	DETAIL	Delivered Cases	NUMERIC	N	N
ORDER_PACK	DETAIL	Delivered Units	NUMERIC	N	N
ORDER_PACK	DETAIL	Delivery Item No	TEXT	N	N
ORDER_PACK	DETAIL	Stock Description	TEXT	N	N
ORDER_PACK	DETAIL	Stock Description2	TEXT	N	Y
ORDER_PACK	DETAIL	Stock Description3	TEXT	N	N
ORDER_PACK	DETAIL	Despatch Text 1	TEXT	N	N
ORDER_PACK	DETAIL	Despatch Text 2	TEXT	N	N
ORDER_PACK	DETAIL	Despatch Text 3	TEXT	N	N
ORDER_PACK	DETAIL	Despatch Text 4	TEXT	N	N
ORDER_PACK	DETAIL	Despatch Text 5	TEXT	N	N
ORDER_PACK	DETAIL	Despatch Text 6	TEXT	N	N
ORDER_PACK	DETAIL	Despatched Cases	NUMERIC	N	N
ORDER_PACK	DETAIL	Despatched Units	NUMERIC	N	N
ORDER_PACK	DETAIL	Despatch Note No	NUMERIC	N	R
ORDER_PACK	DETAIL	Carrier Reference	TEXT	N	Y
ORDER_PACK	DETAIL	Line No	NUMERIC	Y	N
ORDER_PACK	DETAIL	Line Type	TEXT	N	N	1,2,3,4,5,6,7,8,9,R,A,B,O,P,Q,S
ORDER_PACK	DETAIL	Location Code	TEXT	N	R
ORDER_PACK	DETAIL	Client Line Number	NUMERIC	N	N
ORDER_PACK	DETAIL	Line Comment	TEXT	N	N
ORDER_PACK	DETAIL	Order Status	TEXT	N	R
ORDER_PACK	DETAIL	Ordered Cases	NUMERIC	N	N
ORDER_PACK	DETAIL	Ordered Units	NUMERIC	N	N
ORDER_PACK	DETAIL	Pallet ID	NUMERIC	N	R
ORDER_PACK	DETAIL	Picking Text 1	TEXT	N	N
ORDER_PACK	DETAIL	Picking Text 2	TEXT	N	N
ORDER_PACK	DETAIL	Picking Text 3	TEXT	N	N
ORDER_PACK	DETAIL	Picking Text 4	TEXT	N	N
ORDER_PACK	DETAIL	Picking Text 5	TEXT	N	N
ORDER_PACK	DETAIL	Picking Text 6	TEXT	N	N
ORDER_PACK	DETAIL	Previous Order Status	TEXT	N	N
ORDER_PACK	DETAIL	Price	NUMERIC	N	N
ORDER_PACK	DETAIL	Quantity Despatched	NUMERIC	N	N
ORDER_PACK	DETAIL	Quantity Ordered	NUMERIC	N	N
ORDER_PACK	DETAIL	Reason Code	TEXT	N	R
ORDER_PACK	DETAIL	Rotation No	TEXT	N	R
ORDER_PACK	DETAIL	Sellers Reference	TEXT	N	N
ORDER_PACK	DETAIL	Cost	NUMERIC	N	N
ORDER_PACK	DETAIL	Stock Code	TEXT	Y	R
ORDER_PACK	DETAIL	Stockist Code	TEXT	Y	Y
ORDER_PACK	DETAIL	Sales Area	TEXT	N	N
ORDER_PACK	DETAIL	Sales Territory	TEXT	N	N
ORDER_PACK	DETAIL	Weight	NUMERIC	N	N
ORDER_PACK	PALLET	Allocated Cases	NUMERIC	N	N
ORDER_PACK	PALLET	Quantity Allocated	NUMERIC	N	N
ORDER_PACK	PALLET	Allocated Units	NUMERIC	N	N
ORDER_PACK	PALLET	Customer Pallet ID	TEXT	N	R
ORDER_PACK	PALLET	Customer Rotation No	TEXT	N	R
ORDER_PACK	PALLET	Despatch Text 1	TEXT	N	N
ORDER_PACK	PALLET	Despatch Text 2	TEXT	N	N
ORDER_PACK	PALLET	Despatch Text 3	TEXT	N	N
ORDER_PACK	PALLET	Despatch Text 4	TEXT	N	N
ORDER_PACK	PALLET	Despatch Text 5	TEXT	N	N
ORDER_PACK	PALLET	Despatch Text 6	TEXT	N	N
ORDER_PACK	PALLET	Carrier Reference	TEXT	N	Y
ORDER_PACK	PALLET	Line No	NUMERIC	Y	N
ORDER_PACK	PALLET	Ordered Cases	NUMERIC	N	N
ORDER_PACK	PALLET	Quantity Ordered	NUMERIC	N	N
ORDER_PACK	PALLET	Ordered Units	NUMERIC	N	N
ORDER_PACK	PALLET	Page Number	NUMERIC	Y	N
ORDER_PACK	PALLET	Pallet Type	TEXT	N	R
ORDER_PACK	PALLET	Picked Cases	NUMERIC	N	N
ORDER_PACK	PALLET	Pick Location	TEXT	N	R
ORDER_PACK	PALLET	Pick Pallet ID	NUMERIC	N	R
ORDER_PACK	PALLET	Quantity Picked	NUMERIC	N	N
ORDER_PACK	PALLET	Pick Task Identifier	TEXT	N	N
ORDER_PACK	PALLET	Picked Units	NUMERIC	N	N
ORDER_PACK	PALLET	Picking Text 1	TEXT	N	N
ORDER_PACK	PALLET	Picking Text 2	TEXT	N	N
ORDER_PACK	PALLET	Picking Text 3	TEXT	N	N
ORDER_PACK	PALLET	Picking Text 4	TEXT	N	N
ORDER_PACK	PALLET	Picking Text 5	TEXT	N	N
ORDER_PACK	PALLET	Picking Text 6	TEXT	N	N
ORDER_PACK	PALLET	Quantity Despatched	NUMERIC	N	N
ORDER_PACK	PALLET	Despatched Cases	NUMERIC	N	N
ORDER_PACK	PALLET	Despatched Units	NUMERIC	N	N
ORDER_PACK	PALLET	Rotation No	TEXT	N	R
ORDER_PACK	PALLET	Sell By Date	DATE	N	R
ORDER_SW	HEADER	Back Order Flag	TEXT	N	N
ORDER_SW	HEADER	Booking Date	DATE	N	R
ORDER_SW	HEADER	Booking Reference	TEXT	N	Y
ORDER_SW	HEADER	Booking Time	NUMERIC	N	N
ORDER_SW	HEADER	Brand Id	TEXT	N	N
ORDER_SW	HEADER	Customer Code	TEXT	N	R
ORDER_SW	HEADER	Customer PO Reference	TEXT	N	Y
ORDER_SW	HEADER	Start Due Date	DATE	N	R
ORDER_SW	HEADER	Despatch Text 1	TEXT	N	N
ORDER_SW	HEADER	Despatch Text 2	TEXT	N	N
ORDER_SW	HEADER	Despatch Text 3	TEXT	N	N
ORDER_SW	HEADER	Despatch Text 4	TEXT	N	N
ORDER_SW	HEADER	Despatch Text 5	TEXT	N	N
ORDER_SW	HEADER	Despatch Text 6	TEXT	N	N
ORDER_SW	HEADER	End Due Date	DATE	N	R
ORDER_SW	HEADER	Extra Reference	TEXT	N	Y
ORDER_SW	HEADER	Haulier Code	TEXT	N	Y
ORDER_SW	HEADER	Carrier Reference	TEXT	N	Y
ORDER_SW	HEADER	Misc Text 1	TEXT	N	N
ORDER_SW	HEADER	Mob Tel No	TEXT	N	N
ORDER_SW	HEADER	Order Reference	TEXT	N	Y
ORDER_SW	HEADER	Order Entry Date	DATE	N	R
ORDER_SW	HEADER	Order Number	TEXT	Y	R
ORDER_SW	HEADER	Order Owner	TEXT	Y	Y
ORDER_SW	HEADER	Order Priority	NUMERIC	N	Y
ORDER_SW	HEADER	Routing Code	TEXT	N	Y
ORDER_SW	HEADER	Select Type	TEXT	N	Y
ORDER_SW	HEADER	Order Status	TEXT	N	R
ORDER_SW	HEADER	Order Type	TEXT	N	R	H,E,C,U,T,A,O,D,S,N,K,R
ORDER_SW	HEADER	Ordered Cases	NUMERIC	N	N
ORDER_SW	HEADER	Ordered Units	NUMERIC	N	N
ORDER_SW	HEADER	Main Tel No	TEXT	N	N
ORDER_SW	HEADER	Picking Text 1	TEXT	N	N
ORDER_SW	HEADER	Picking Text 2	TEXT	N	N
ORDER_SW	HEADER	Picking Text 3	TEXT	N	N
ORDER_SW	HEADER	Picking Text 4	TEXT	N	N
ORDER_SW	HEADER	Picking Text 5	TEXT	N	N
ORDER_SW	HEADER	Picking Text 6	TEXT	N	N
ORDER_SW	HEADER	Previous Order Status	TEXT	N	N
ORDER_SW	HEADER	Quantity Ordered	NUMERIC	N	N
ORDER_SW	HEADER	Reference 1	TEXT	N	N
ORDER_SW	HEADER	Reference 2	TEXT	N	N
ORDER_SW	HEADER	Reference 3	TEXT	N	N
ORDER_SW	HEADER	Shipping Instructions	TEXT	N	N
ORDER_SW	HEADER	Special Instructions	TEXT	N	N
ORDER_SW	HEADER	Store Code	TEXT	N	N
ORDER_SW	HEADER	Store Desc	TEXT	N	N
ORDER_SW	HEADER	Carrier Code	TEXT	N	Y
ORDER_SW	HEADER	Address Line 1	TEXT	N	N
ORDER_SW	HEADER	Address Line 2	TEXT	N	N
ORDER_SW	HEADER	Address Line 5	TEXT	N	N
ORDER_SW	HEADER	Address Line 6	TEXT	N	N
ORDER_SW	HEADER	Address Line 7	TEXT	N	N
ORDER_SW	HEADER	Country Code	TEXT	N	Y
ORDER_SW	HEADER	County	TEXT	N	N
ORDER_SW	HEADER	Email Address	TEXT	N	N
ORDER_SW	HEADER	Name	TEXT	N	N
ORDER_SW	HEADER	Post Code	TEXT	N	N
ORDER_SW	HEADER	Sales Area	TEXT	N	N
ORDER_SW	HEADER	Sales Territory	TEXT	N	N
ORDER_SW	HEADER	Town	TEXT	N	N
ORDER_SW	HEADER	Warehouse ID	TEXT	Y	Y
ORDER_SW	HEADER	Weighbridge Number	TEXT	N	N
ORDER_SW	HEADER	Work Tel No	TEXT	N	N
ORDER_SW	WELL	Actual Del Date	DATE	N	N
ORDER_SW	WELL	Actual Del Time	NUMERIC	N	N
ORDER_SW	WELL	Allocated Date	DATE	N	N
ORDER_SW	WELL	Cancelled By	TEXT	N	N
ORDER_SW	WELL	Pack Closed By	TEXT	N	N
ORDER_SW	WELL	Pack Closed Date	TEXT	N	N
ORDER_SW	WELL	Cust POD Date	NUMERIC	N	N
ORDER_SW	WELL	Cust POD Time	NUMERIC	N	N
ORDER_SW	WELL	Cust POD User	TEXT	N	N
ORDER_SW	WELL	Cust Rec Ref	TEXT	N	N
ORDER_SW	WELL	Cancelled Date	DATE	N	R
ORDER_SW	WELL	Depot POD Date	NUMERIC	N	N
ORDER_SW	WELL	Depot POD Time	NUMERIC	N	N
ORDER_SW	WELL	Depot POD User	TEXT	N	N
ORDER_SW	WELL	Despatch Text 1	TEXT	N	N
ORDER_SW	WELL	Despatch Text 2	TEXT	N	N
ORDER_SW	WELL	Despatch Text 3	TEXT	N	N
ORDER_SW	WELL	Despatch Text 4	TEXT	N	N
ORDER_SW	WELL	Despatch Text 5	TEXT	N	N
ORDER_SW	WELL	Despatch Text 6	TEXT	N	N
ORDER_SW	WELL	Despatch Date	DATE	N	R
ORDER_SW	WELL	ETA Del Date	DATE	N	N
ORDER_SW	WELL	ETA Del Time	NUMERIC	N	N
ORDER_SW	WELL	Load Number	TEXT	N	R
ORDER_SW	WELL	Carrier Reference	TEXT	N	Y
ORDER_SW	WELL	On Time Delivery	TEXT	N	N
ORDER_SW	WELL	Order Status	TEXT	N	N
ORDER_SW	WELL	Load Units	NUMERIC	N	N
ORDER_SW	WELL	Load Cases	NUMERIC	N	N
ORDER_SW	WELL	Load Pallets	NUMERIC	N	N
ORDER_SW	WELL	Load Volume	NUMERIC	N	N
ORDER_SW	WELL	Load Weight	NUMERIC	N	N
ORDER_SW	WELL	Pack Number	TEXT	N	N
ORDER_SW	WELL	Pick Confirm Date	DATE	N	R
ORDER_SW	WELL	Picked Date	DATE	N	R
ORDER_SW	WELL	Picking Text 1	TEXT	N	N
ORDER_SW	WELL	Picking Text 2	TEXT	N	N
ORDER_SW	WELL	Picking Text 3	TEXT	N	N
ORDER_SW	WELL	Picking Text 4	TEXT	N	N
ORDER_SW	WELL	Picking Text 5	TEXT	N	N
ORDER_SW	WELL	Picking Text 6	TEXT	N	N
ORDER_SW	WELL	POD Received	TEXT	N	Y
ORDER_SW	WELL	Product Type	TEXT	N	R
ORDER_SW	WELL	Received Date	DATE	N	R
ORDER_SW	WELL	Received Time	NUMERIC	N	N
ORDER_SW	WELL	Route Code	TEXT	N	R
ORDER_SW	WELL	POD Signed By	TEXT	N	N
ORDER_SW	WELL	Cancelled Time	NUMBER	N	N
ORDER_SW	DETAIL	Free Cases	NUMBER	N	N
ORDER_SW	DETAIL	Free Units	NUMBER	N	N
ORDER_SW	DETAIL	Alloc Cases	NUMBER	N	N
ORDER_SW	DETAIL	Alloc Units	NUMBER	N	N
ORDER_SW	DETAIL	Base Price	NUMERIC	N	N
ORDER_SW	DETAIL	Buyers Reference	TEXT	N	N
ORDER_SW	DETAIL	Committed Cases	NUMBER	N	N
ORDER_SW	DETAIL	Committed Units	NUMBER	N	N
ORDER_SW	DETAIL	Customer Rotation No	TEXT	N	R
ORDER_SW	DETAIL	Delivered Cases	NUMERIC	N	N
ORDER_SW	DETAIL	Delivered Units	NUMERIC	N	N
ORDER_SW	DETAIL	Delivery Item No	TEXT	N	N
ORDER_SW	DETAIL	Stock Description	TEXT	N	N
ORDER_SW	DETAIL	Stock Description2	TEXT	N	N
ORDER_SW	DETAIL	OD Stock Description3	TEXT	N	N
ORDER_SW	DETAIL	Despatch Text 1	TEXT	N	N
ORDER_SW	DETAIL	Despatch Text 2	TEXT	N	N
ORDER_SW	DETAIL	Despatch Text 3	TEXT	N	N
ORDER_SW	DETAIL	Despatch Text 4	TEXT	N	N
ORDER_SW	DETAIL	Despatch Text 5	TEXT	N	N
ORDER_SW	DETAIL	Despatch Text 6	TEXT	N	N
ORDER_SW	DETAIL	Despatched Cases	NUMERIC	N	N
ORDER_SW	DETAIL	Despatched Units	NUMERIC	N	N
ORDER_SW	DETAIL	Despatch Note No	NUMERIC	N	R
ORDER_SW	DETAIL	Free Pallets	NUMBER	N	N
ORDER_SW	DETAIL	On Hand Pallets	NUMBER	N	N
ORDER_SW	DETAIL	Held Cases	NUMBER	N	N
ORDER_SW	DETAIL	Held Units	NUMBER	N	N
ORDER_SW	DETAIL	Line No	NUMERIC	Y	N
ORDER_SW	DETAIL	Line Type	TEXT	N	N	1,2,3,4,5,6,7,8,9,R,A,B,O,P,Q,S
ORDER_SW	DETAIL	Location Code	TEXT	N	R
ORDER_SW	DETAIL	Carrier Reference	TEXT	N	N
ORDER_SW	DETAIL	Client Line Number	NUMERIC	N	N
ORDER_SW	DETAIL	On Hand Cases	NUMBER	N	N
ORDER_SW	DETAIL	On Hand Units	NUMBER	N	N
ORDER_SW	DETAIL	Line Comment	TEXT	N	N
ORDER_SW	DETAIL	Order Status	TEXT	N	R
ORDER_SW	DETAIL	Ordered Cases	NUMERIC	N	N
ORDER_SW	DETAIL	Ordered Units	NUMERIC	N	N
ORDER_SW	DETAIL	Pallet ID	NUMERIC	N	R
ORDER_SW	DETAIL	Picking Text 1	TEXT	N	N
ORDER_SW	DETAIL	Picking Text 2	TEXT	N	N
ORDER_SW	DETAIL	Picking Text 3	TEXT	N	N
ORDER_SW	DETAIL	Picking Text 4	TEXT	N	N
ORDER_SW	DETAIL	Picking Text 5	TEXT	N	N
ORDER_SW	DETAIL	Picking Text 6	TEXT	N	N
ORDER_SW	DETAIL	Previous Order Status	TEXT	N	N
ORDER_SW	DETAIL	Price	NUMERIC	N	N
ORDER_SW	DETAIL	Quantity Despatched	NUMERIC	N	N
ORDER_SW	DETAIL	Quantity Ordered	NUMERIC	N	N
ORDER_SW	DETAIL	Reason Code	TEXT	N	R
ORDER_SW	DETAIL	Rotation No	TEXT	N	R
ORDER_SW	DETAIL	Sellers Reference	TEXT	N	N
ORDER_SW	DETAIL	Cost	NUMERIC	N	N
ORDER_SW	DETAIL	Stock Code	TEXT	Y	R
ORDER_SW	DETAIL	Stockist Code	TEXT	Y	Y
ORDER_SW	DETAIL	Transfer Cases	NUMERIC	N	N
ORDER_SW	DETAIL	Transfer Units	NUMERIC	N	N
ORDER_SW	DETAIL	Sales Area	TEXT	N	N
ORDER_SW	DETAIL	Sales Territory	TEXT	N	N
ORDER_SW	DETAIL	Weight	NUMERIC	N	N
PACK	PACK_LVL	Booking Reference	TEXT	N	Y
PACK	PACK_LVL	Cons Box Type	TEXT	N	N
PACK	PACK_LVL	Carrier Code	TEXT	Y	N
PACK	PACK_LVL	Pack Closed Date	DATE	Y	N
PACK	PACK_LVL	Customer Code	TEXT	N	R
PACK	PACK_LVL	Customer PO Reference	TEXT	N	Y
PACK	PACK_LVL	Despatch Date	DATE	N	R
PACK	PACK_LVL	Load Number	TEXT	N	R
PACK	PACK_LVL	Carrier Reference	TEXT	N	N
PACK	PACK_LVL	No of Packs	NUMERIC	N	Y
PACK	PACK_LVL	Order Reference	TEXT	Y	Y
PACK	PACK_LVL	Order Number	TEXT	Y	R
PACK	PACK_LVL	Order Owner	TEXT	Y	Y
PACK	PACK_LVL	Order Status	TEXT	N	R
PACK	PACK_LVL	Pack Number	TEXT	Y	Y
PACK	PACK_LVL	Pack Ref1	TEXT	Y	R
PACK	PACK_LVL	No of Cases	NUMERIC	N	N
PACK	PACK_LVL	No of Units	NUMERIC	N	N
PACK	PACK_LVL	Product Type	TEXT	N	R
PACK	PACK_LVL	Route Code	TEXT	N	R
PACK	PACK_LVL	Seq Number	TEXT	Y	N
PACK	PACK_LVL	Serial No	TEXT	N	N
PACK	PACK_LVL	Cons Temp Monitor	TEXT	N	N
PACK	PACK_LVL	Address Line 1	TEXT	N	N
PACK	PACK_LVL	Address Line 2	TEXT	N	N
PACK	PACK_LVL	Address Line 5	TEXT	N	N
PACK	PACK_LVL	Address Line 6	TEXT	N	N
PACK	PACK_LVL	Address Line 7	TEXT	N	N
PACK	PACK_LVL	Country Code	TEXT	N	Y
PACK	PACK_LVL	County	TEXT	N	N
PACK	PACK_LVL	Name	TEXT	N	N
PACK	PACK_LVL	Post Code	TEXT	N	N
PACK	PACK_LVL	Town	TEXT	N	N
PACK	PACK_LVL	Volume	NUMERIC	N	N
PACK	PACK_LVL	Warehouse ID	TEXT	Y	Y
PACK	PACK_LVL	Gross Weight	NUMERIC	N	N
PACK	PACK_LVL	Net Weight	NUMERIC	N	N
PACK	PACK_DTL	Stock Description	TEXT	N	N
PACK	PACK_DTL	Hazardous Flag	TEXT	N	N
PACK	PACK_DTL	Line Num	NUMERIC	N	N
PACK	PACK_DTL	Package Type	TEXT	Y	N
PACK	PACK_DTL	Packed Cases	NUMERIC	N	N
PACK	PACK_DTL	Packed Units	NUMERIC	N	N
PACK	PACK_DTL	Packed Weight	NUMERIC	N	N
PACK	PACK_DTL	Page Num	NUMERIC	N	N
PACK	PACK_DTL	Pallet ID	NUMERIC	N	N
PACK	PACK_DTL	Rotation No	TEXT	N	N
PACK	PACK_DTL	Stock Code	TEXT	Y	N
PACK	PACK_DTL	Stockist Code	TEXT	Y	N
PACK_CONS	PACK_DTL	Booking Reference	TEXT	N	Y
PACK_CONS	PACK_DTL	Cons Box Type	TEXT	N	N
PACK_CONS	PACK_DTL	Carrier Code	TEXT	Y	N
PACK_CONS	PACK_DTL	Pack Closed Date	DATE	Y	N
PACK_CONS	PACK_DTL	Customer Code	TEXT	N	R
PACK_CONS	PACK_DTL	Customer PO Reference	TEXT	N	Y
PACK_CONS	PACK_DTL	Stock Description	TEXT	N	N
PACK_CONS	PACK_DTL	Despatch Date	DATE	N	R
PACK_CONS	PACK_DTL	Hazardous Flag	TEXT	N	N
PACK_CONS	PACK_DTL	Line Num	NUMERIC	N	N
PACK_CONS	PACK_DTL	Load Number	TEXT	N	R
PACK_CONS	PACK_DTL	Carrier Reference	TEXT	N	N
PACK_CONS	PACK_DTL	No of Packs	NUMERIC	N	Y
PACK_CONS	PACK_DTL	Order Reference	TEXT	Y	Y
PACK_CONS	PACK_DTL	Order Number	TEXT	Y	R
PACK_CONS	PACK_DTL	Order Owner	TEXT	Y	Y
PACK_CONS	PACK_DTL	Order Status	TEXT	N	R	0,1,2,3,4,5,6,7,8,9,G,F,R,I,C,S,E,P,Q,X
PACK_CONS	PACK_DTL	Pack Number	TEXT	Y	Y
PACK_CONS	PACK_DTL	Pack Ref1	TEXT	Y	R
PACK_CONS	PACK_DTL	Package Type	TEXT	Y	N
PACK_CONS	PACK_DTL	No of Cases	NUMERIC	N	N
PACK_CONS	PACK_DTL	Packed Cases	NUMERIC	N	N
PACK_CONS	PACK_DTL	No of Units	NUMERIC	N	N
PACK_CONS	PACK_DTL	Packed Units	NUMERIC	N	N
PACK_CONS	PACK_DTL	Packed Weight	NUMERIC	N	N
PACK_CONS	PACK_DTL	Page Num	NUMERIC	N	N
PACK_CONS	PACK_DTL	Pallet ID	NUMERIC	N	N
PACK_CONS	PACK_DTL	Product Type	TEXT	N	R
PACK_CONS	PACK_DTL	Rotation No	TEXT	N	N
PACK_CONS	PACK_DTL	Route Code	TEXT	N	R
PACK_CONS	PACK_DTL	Seq Number	TEXT	Y	N
PACK_CONS	PACK_DTL	Serial No	TEXT	N	N
PACK_CONS	PACK_DTL	Stock Code	TEXT	Y	N
PACK_CONS	PACK_DTL	Stockist Code	TEXT	Y	N
PACK_CONS	PACK_DTL	Cons Temp Monitor	TEXT	N	N
PACK_CONS	PACK_DTL	Address Line 1	TEXT	N	N
PACK_CONS	PACK_DTL	Address Line 2	TEXT	N	N
PACK_CONS	PACK_DTL	Address Line 5	TEXT	N	N
PACK_CONS	PACK_DTL	Address Line 6	TEXT	N	N
PACK_CONS	PACK_DTL	Address Line 7	TEXT	N	N
PACK_CONS	PACK_DTL	Country Code	TEXT	N	Y
PACK_CONS	PACK_DTL	County	TEXT	N	N
PACK_CONS	PACK_DTL	Name	TEXT	N	N
PACK_CONS	PACK_DTL	Post Code	TEXT	N	N
PACK_CONS	PACK_DTL	Town	TEXT	N	N
PACK_CONS	PACK_DTL	Volume	NUMERIC	N	N
PACK_CONS	PACK_DTL	Warehouse ID	TEXT	Y	Y
PACK_CONS	PACK_DTL	Gross Weight	NUMERIC	N	N
PACK_CONS	PACK_DTL	Net Weight	NUMERIC	N	N
PACK_EFUL	PACK	Del Address Line 1	TEXT	N	N
PACK_EFUL	PACK	Del Address Line 2	TEXT	N	N
PACK_EFUL	PACK	Del Address Line 5	TEXT	N	N
PACK_EFUL	PACK	Del Address Line 6	TEXT	N	N
PACK_EFUL	PACK	Del Address Line 7	TEXT	N	N
PACK_EFUL	PACK	Carrier Code	TEXT	N	N
PACK_EFUL	PACK	Pack Closed Date	TEXT	N	N
PACK_EFUL	PACK	Del Country	TEXT	N	N
PACK_EFUL	PACK	Del County	TEXT	N	N
PACK_EFUL	PACK	Stock Desription	TEXT	N	N
PACK_EFUL	PACK	Despatched Date	DATE	N	R
PACK_EFUL	PACK	Load Number	TEXT	N	N
PACK_EFUL	PACK	Carrier Ref	TEXT	N	N
PACK_EFUL	PACK	Del Name	TEXT	N	N
PACK_EFUL	PACK	Order Description	TEXT	N	Y
PACK_EFUL	PACK	Order Entry Date	DATE	N	N
PACK_EFUL	PACK	Order Num	TEXT	N	Y
PACK_EFUL	PACK	Owner Code	TEXT	N	Y
PACK_EFUL	PACK	Owner Sub Code	TEXT	N	Y
PACK_EFUL	PACK	Order Priority	TEXT	N	N
PACK_EFUL	PACK	Order Status	TEXT	N	N
PACK_EFUL	PACK	Ordered Cases	NUMERIC	N	N
PACK_EFUL	PACK	Pack Number	TEXT	N	N
PACK_EFUL	PACK	Pack Ref1	TEXT	N	N
PACK_EFUL	PACK	Package Type	TEXT	N	N
PACK_EFUL	PACK	Packed Cases	NUMERIC	N	N
PACK_EFUL	PACK	Packed Units	NUMERIC	N	N
PACK_EFUL	PACK	Del Postcode	TEXT	N	N
PACK_EFUL	PACK	Route Code	TEXT	N	N
PACK_EFUL	PACK	Stock Code	TEXT	N	N
PACK_EFUL	PACK	Del Town	TEXT	N	N
PACK_EFUL	PACK	Volume	NUMERIC	N	N
PACK_EFUL	PACK	Warehouse	TEXT	N	Y
PACK_EFUL	PACK	Gross Weight	NUMERIC	N	N
PACK_EFUL	PACK	Net Weight	NUMERIC	N	N
PALTRACK	HEADER	Booking Date	DATE	N	R		Y
PALTRACK	HEADER	Booking Reference	TEXT	N	Y		Y
PALTRACK	HEADER	Booking Time	NUMERIC	N	N		Y
PALTRACK	HEADER	Confirm Flag	TEXT	N	N		Y
PALTRACK	HEADER	Customer Code	TEXT	N	R		Y
PALTRACK	HEADER	Customer PO Reference	TEXT	N	Y		Y
PALTRACK	HEADER	Transport Out	TEXT	N	N		Y
PALTRACK	HEADER	Delivery Address Line 1	TEXT	N	N		Y
PALTRACK	HEADER	Delivery Address Line 2	TEXT	N	N		Y
PALTRACK	HEADER	Delivery Address Country Code	TEXT	N	N		Y
PALTRACK	HEADER	Delivery Address County	TEXT	N	N		Y
PALTRACK	HEADER	Delivery Address Name	TEXT	N	N		Y
PALTRACK	HEADER	Delivery Address Post Code	TEXT	N	N		Y
PALTRACK	HEADER	Delivery Address Town	TEXT	N	N		Y
PALTRACK	HEADER	End Due Date	DATE	N	R		Y
PALTRACK	HEADER	Extra Reference	TEXT	N	Y		Y
PALTRACK	HEADER	Description	TEXT	N	N		Y
PALTRACK	HEADER	Order Reference	TEXT	N	Y		Y
PALTRACK	HEADER	Order Number	TEXT	N	R		Y
PALTRACK	HEADER	Order Owner	TEXT	N	Y		Y
PALTRACK	HEADER	Pallet Type	TEXT	N	Y		Y
PALTRACK	HEADER	Picking Container ID	TEXT	N	N		Y
PALTRACK	HEADER	Despatch Date	DATE	Y	R		Y
PALTRACK	HEADER	Warehouse ID	TEXT	Y	Y		Y
PICK_CONT	PICK_CONT	Company Code	TEXT	Y	Y
PICK_CONT	PICK_CONT	Cust Pallet Id	TEXT	N	N
PICK_CONT	PICK_CONT	Cust Rotation No	TEXT	N	N
PICK_CONT	PICK_CONT	Stock Desc	TEXT	N	R
PICK_CONT	PICK_CONT	Line Num	NUMERIC	N	N
PICK_CONT	PICK_CONT	Load Number	TEXT	N	R
PICK_CONT	PICK_CONT	Marshalling Location	TEXT	N	N
PICK_CONT	PICK_CONT	Order Num	TEXT	N	R
PICK_CONT	PICK_CONT	Order Owner	TEXT	N	Y
PICK_CONT	PICK_CONT	Page Num	NUMERIC	N	N
PICK_CONT	PICK_CONT	Pick Location	TEXT	N	N
PICK_CONT	PICK_CONT	Pallet Id	NUMERIC	N	N
PICK_CONT	PICK_CONT	Picking Container	TEXT	N	R
PICK_CONT	PICK_CONT	Rotation No	TEXT	N	N
PICK_CONT	PICK_CONT	Route Code	TEXT	N	Y
PICK_CONT	PICK_CONT	Stock Code	TEXT	N	R
PICK_CONT	PICK_CONT	Storage Location	TEXT	N	Y
PICK_CONT	PICK_CONT	To Deliver Cases	NUMERIC	N	N
PICK_CONT	PICK_CONT	To Deliver Units	NUMERIC	N	N
PICK_CONT	PICK_CONT	Warehouse Id	TEXT	Y	Y
PIP_DISC	HEADER	Customer Rotation No	TEXT	N	R
PIP_DISC	HEADER	User ID of Receiver	TEXT	N	N
PIP_DISC	HEADER	Discrepancy Indicator C	TEXT	N	Y
PIP_DISC	HEADER	Discrepancy Indicator I	TEXT	N	Y
PIP_DISC	HEADER	Discrepancy Indicator R	TEXT	N	Y
PIP_DISC	HEADER	Discrepancy Indicator S	TEXT	N	Y
PIP_DISC	HEADER	On Hand Quantity	NUMERIC	N	N
PIP_DISC	HEADER	Pallet ID	NUMERIC	N	R
PIP_DISC	HEADER	System Rotation No	TEXT	N	R
PIP_DISC	HEADER	Sell By Date	DATE	N	N
PIP_DISC	HEADER	Stock Code	TEXT	N	R
PIP_DISC	HEADER	Stockist Code	TEXT	N	R
PIP_DISC	HEADER	Stockist Sub Code	TEXT	N	R
PIP_DISC	HEADER	Receipt Date and Time	DATE	N	N
PIP_DISC	HEADER	Warehouse ID	TEXT	N	R
POST_OML	HEADER	Customer Type	TEXT	N	Y
POST_OML	HEADER	Postcode	TEXT	N	R
POST_OML	HEADER	Sequence	NUMERIC	N	Y
POST_OML	HEADER	Warehouse Name	TEXT	N	N
POST_OML	HEADER	Owner	TEXT	N	Y
POST_OML	HEADER	Owner Sub Code	TEXT	N	Y
POST_OML	HEADER	Warehouse Id	TEXT	N	R
PREDES_SRL	HEADER	Customer Code	TEXT	N	Y
PREDES_SRL	HEADER	Customer PO Ref	TEXT	N	N
PREDES_SRL	HEADER	Qty Ordered	NUMERIC	N	N
PREDES_SRL	HEADER	Description	TEXT	N	N
PREDES_SRL	HEADER	Line No	NUMERIC	N	N
PREDES_SRL	HEADER	Customer Name	TEXT	N	N
PREDES_SRL	HEADER	Order Reference	TEXT	N	R
PREDES_SRL	HEADER	Order Number	TEXT	N	R
PREDES_SRL	HEADER	Order Owner Code	TEXT	N	Y
PREDES_SRL	HEADER	Status	TEXT	N	Y
PREDES_SRL	HEADER	Serial No From	TEXT	N	N
PREDES_SRL	HEADER	Serial No To	TEXT	N	N
PREDES_SRL	HEADER	Serial Text	TEXT	N	N
PREDES_SRL	HEADER	Stock Code	TEXT	N	R
PREDES_SRL	HEADER	Warehouse Id	TEXT	N	Y
PURCH_ORD	HDR	Auth Exceeded	TEXT	N	N
PURCH_ORD	HDR	Branch ID	TEXT	N	N
PURCH_ORD	HDR	Company Code	TEXT	N	N
PURCH_ORD	HDR	Consignment Stock	TEXT	N	N
PURCH_ORD	HDR	Department	TEXT	N	N
PURCH_ORD	HDR	Goods Outstanding	TEXT	N	Y
PURCH_ORD	HDR	GRN Flag	TEXT	N	N
PURCH_ORD	HDR	Order Date	DATE	N	R
PURCH_ORD	HDR	Purchase Order No	TEXT	N	Y
PURCH_ORD	HDR	Owner Code	TEXT	Y	Y
PURCH_ORD	HDR	Owner Sub Code	TEXT	N	N
PURCH_ORD	HDR	Print Flag	TEXT	N	N
PURCH_ORD	HDR	Stock Ord	TEXT	N	N
PURCH_ORD	HDR	Stockist Code	TEXT	N	Y
PURCH_ORD	HDR	Supplier Code	TEXT	N	Y
PURCH_ORD	HDR	Warehouse ID	TEXT	N	Y
PURCH_ORD	DET	Case Net Weight	NUMERIC	N	N
PURCH_ORD	DET	Description	TEXT	N	N
PURCH_ORD	DET	Due Date	DATE	N	R
PURCH_ORD	DET	Factor 1-2	NUMERIC	N	N
PURCH_ORD	DET	Factor 1-3	NUMERIC	N	N
PURCH_ORD	DET	Factor 2-3	NUMERIC	N	N
PURCH_ORD	DET	Int Reorder	TEXT	N	N
PURCH_ORD	DET	Line Complete	TEXT	N	N
PURCH_ORD	DET	Measure Factor	NUMERIC	N	N
PURCH_ORD	DET	Order Line No	TEXT	N	N
PURCH_ORD	DET	Original Due Date	DATE	N	N
PURCH_ORD	DET	Qty Ordered	NUMERIC	N	N
PURCH_ORD	DET	Qty Received	NUMERIC	N	N
PURCH_ORD	DET	Line Value	NUMERIC	N	N
PURCH_ORD	DET	Purchase Price	NUMERIC	N	N
PURCH_ORD	DET	Stock Code	TEXT	N	N
PURCH_ORD	DET	Stocking UOM	TEXT	N	N
PURCH_ORD	DET	UOM Input	TEXT	N	N
PURCH_ORD	DET	UOM 1	TEXT	N	N
PURCH_ORD	DET	UOM 2	TEXT	N	N
PURCH_ORD	DET	UOM 3	TEXT	N	N
PURCH_ORD	DET	UOM Qty Ordered	NUMERIC	N	N
REPLEN	HEADER	Description	TEXT	N	N
REPLEN	HEADER	Use Type Desc	TEXT	N	N
REPLEN	HEADER	On-Hand Case Locn	NUMBER	N	N
REPLEN	HEADER	Location	TEXT	N	R
REPLEN	HEADER	Replenishment Level	NUMBER	N	Y
REPLEN	HEADER	Stock Code	TEXT	N	R
REPLEN	HEADER	Stockist Code	TEXT	N	Y
REPLEN	HEADER	Stockist Sub-Code	TEXT	N	Y
REPLEN	HEADER	Location Use Type	TEXT	N	Y
REPLEN	HEADER	Warehouse Id	TEXT	Y	R
REPRINT	HEADER	Company Code	TEXT	N	Y
REPRINT	HEADER	Date Stamp	DATE	N	Y
REPRINT	HEADER	Load Number	TEXT	N	Y
REPRINT	HEADER	Order Num	TEXT	N	Y
REPRINT	HEADER	Owner Code	TEXT	N	Y
REPRINT	HEADER	Owner Sub Code	TEXT	N	Y
REPRINT	HEADER	Request Type	TEXT	N	Y
REPRINT	HEADER	Requested From	TEXT	N	Y
REPRINT	HEADER	Route Code	TEXT	N	Y
REPRINT	HEADER	User ID	TEXT	N	Y
REPRINT	HEADER	Warehouse ID	TEXT	N	Y
RMS	STOCK	Alloc Qty	NUMERIC	N	N
RMS	STOCK	Colour	TEXT	Y	R
RMS	STOCK	Department	NUMERIC	Y	R
RMS	STOCK	Division	NUMERIC	Y	R
RMS	STOCK	4 Weeks Cover	NUMERIC	N	N
RMS	STOCK	Last Week Cover	NUMERIC	N	N
RMS	STOCK	Despatch All Days	NUMERIC	N	N
RMS	STOCK	Despatch 8-30 Days	NUMERIC	N	N
RMS	STOCK	Despatch 31-60 Days	NUMERIC	N	N
RMS	STOCK	Despatch 7 Days	NUMERIC	N	N
RMS	STOCK	Despatch 61+ Days	NUMERIC	N	N
RMS	STOCK	Last Intake Date	DATE	N	N
RMS	STOCK	Last Despatch Date	DATE	N	N
RMS	STOCK	Held Qty	NUMERIC	N	N
RMS	STOCK	On Hand Qty	NUMERIC	N	N
RMS	STOCK	Option	TEXT	N	N
RMS	STOCK	Size	TEXT	Y	R
RMS	STOCK	Season	TEXT	Y	R
RMS	STOCK	Stock Code	TEXT	N	R
RMS	STOCK	Stockist Code	TEXT	N	Y
RMS	STOCK	Stockist Sub Code	TEXT	N	Y
RMS	STOCK	Style	NUMERIC	Y	R
RMS	STOCK	Warehouse Id	TEXT	N	Y
SBD_HOLD	HOLD	Action	TEXT	N	Y		Y
SBD_HOLD	HOLD	Company Code	TEXT	N	Y		Y
SBD_HOLD	HOLD	Customer Pallet ID	TEXT	N	N		Y
SBD_HOLD	HOLD	Customer Rotation No	TEXT	N	N		Y
SBD_HOLD	HOLD	Cases	NUMERIC	N	N		Y
SBD_HOLD	HOLD	Quantity	NUMERIC	N	N		Y
SBD_HOLD	HOLD	Units	NUMERIC	N	N		Y
SBD_HOLD	HOLD	Location Code	TEXT	N	Y		Y
SBD_HOLD	HOLD	System Pallet ID	NUMERIC	N	N		Y
SBD_HOLD	HOLD	Reason Code	TEXT	N	N		Y
SBD_HOLD	HOLD	System Rotation No	TEXT	N	N		Y
SBD_HOLD	HOLD	Process Run Date	DATE	N	R		Y
SBD_HOLD	HOLD	Process Run ID	NUMERIC	N	Y		Y
SBD_HOLD	HOLD	Stock Code	TEXT	N	R		Y
SBD_HOLD	HOLD	Stockist Code	TEXT	N	R		Y
SBD_HOLD	HOLD	Stockist Sub Code	TEXT	N	Y		Y
SBD_HOLD	HOLD	Warehouse ID	TEXT	N	Y		Y
SC_CHECKED	HEADER	Start Check Year	DATE	Y	N
SC_CHECKED	HEADER	Last PI Check	DATE	Y	R
SC_CHECKED	HEADER	Location Code	TEXT	N	R
SC_CHECKED	HEADER	On Hand Cases	NUMERIC	N	N
SC_CHECKED	HEADER	On Hand Units	NUMERIC	N	N
SC_CHECKED	HEADER	Pallet Id	NUMERIC	N	R
SC_CHECKED	HEADER	Rotation	TEXT	N	R
SC_CHECKED	HEADER	Sell By Date	DATE	N	R
SC_CHECKED	HEADER	Stock Code	TEXT	N	R
SC_CHECKED	HEADER	Stockist Code	TEXT	N	Y
SC_CHECKED	HEADER	Stockist Sub Code	TEXT	N	Y
SC_CHECKED	HEADER	Warehouse Id	TEXT	Y	R
SC_COUNTS	HEADER	Count entered on	DATE	N	N
SC_COUNTS	HEADER	Update Number	NUMERIC	N	N
SC_COUNTS	HEADER	Count Option	TEXT	N	N
SC_COUNTS	HEADER	Count User	TEXT	N	Y
SC_COUNTS	HEADER	Counting Units	TEXT	N	N
SC_COUNTS	HEADER	Full Count	TEXT	N	Y
SC_COUNTS	HEADER	Generate User	TEXT	N	Y
SC_COUNTS	HEADER	Owners Ref	TEXT	N	Y
SC_COUNTS	HEADER	Count Number	NUMERIC	N	R
SC_COUNTS	HEADER	Report User	TEXT	N	Y
SC_COUNTS	HEADER	Reported On	DATE	N	R
SC_COUNTS	HEADER	Suppress Rot	TEXT	N	Y
SC_COUNTS	HEADER	Sort by	TEXT	N	N
SC_COUNTS	HEADER	Status	TEXT	N	Y
SC_COUNTS	HEADER	Date	DATE	N	R
SC_COUNTS	HEADER	Stock Take No	NUMERIC	N	R
SC_COUNTS	HEADER	Time	NUMERIC	N	N
SC_COUNTS	HEADER	Updated On	DATE	N	R
SC_COUNTS	HEADER	Updated By	TEXT	N	Y
SC_COUNTS	HEADER	Variance On	DATE	N	R
SC_COUNTS	HEADER	Variance By	TEXT	N	Y
SC_COUNTS	HEADER	Warehouse Id	TEXT	Y	R
SC_COUNTS	DETAIL	Count 1 Eaches	NUMERIC	N	N
SC_COUNTS	DETAIL	Count 2 Eaches	NUMERIC	N	N
SC_COUNTS	DETAIL	Count 3 Eaches	NUMERIC	N	N
SC_COUNTS	DETAIL	On Hand Eaches	NUMERIC	N	N
SC_COUNTS	DETAIL	Reason for Adjustment	TEXT	N	Y
SC_COUNTS	DETAIL	Count 1 Cases	NUMERIC	N	N
SC_COUNTS	DETAIL	Count 1 Units	NUMERIC	N	N
SC_COUNTS	DETAIL	Count 2 Cases	NUMERIC	N	N
SC_COUNTS	DETAIL	Count 2 Units	NUMERIC	N	N
SC_COUNTS	DETAIL	Count 3 Cases	NUMERIC	N	N
SC_COUNTS	DETAIL	Count 3 Units	NUMERIC	N	N
SC_COUNTS	DETAIL	Confirm Flag	TEXT	N	Y
SC_COUNTS	DETAIL	Count Status	NUMERIC	N	N
SC_COUNTS	DETAIL	Country of Origin	TEXT	N	Y
SC_COUNTS	DETAIL	Counted Catch Weight	NUMERIC	N	N
SC_COUNTS	DETAIL	Counted Measure Qty	NUMERIC	N	N
SC_COUNTS	DETAIL	Counted Cases	NUMERIC	N	N
SC_COUNTS	DETAIL	Counted Layers	NUMERIC	N	N
SC_COUNTS	DETAIL	Counted Qty	NUMERIC	N	N
SC_COUNTS	DETAIL	Counted Units	NUMERIC	N	N
SC_COUNTS	DETAIL	Customer Pallet Id	TEXT	N	Y
SC_COUNTS	DETAIL	Customer Rotation	TEXT	N	R
SC_COUNTS	DETAIL	Description	TEXT	N	N
SC_COUNTS	DETAIL	Employee Code	TEXT	N	Y
SC_COUNTS	DETAIL	Eurodate	TEXT	N	R
SC_COUNTS	DETAIL	Grn No	NUMERIC	N	N
SC_COUNTS	DETAIL	Line No	NUMERIC	N	N
SC_COUNTS	DETAIL	Location Code	TEXT	N	R
SC_COUNTS	DETAIL	Manu Date	DATE	N	R
SC_COUNTS	DETAIL	Measure Qty	NUMERIC	N	N
SC_COUNTS	DETAIL	Measure Qty UOM	TEXT	N	N
SC_COUNTS	DETAIL	MPC	TEXT	N	R
SC_COUNTS	DETAIL	NCR reference	NUMERIC	N	R
SC_COUNTS	DETAIL	NCR Status	TEXT	N	R
SC_COUNTS	DETAIL	On Hand Cases	NUMERIC	N	N
SC_COUNTS	DETAIL	Catch Weight	NUMERIC	N	N
SC_COUNTS	DETAIL	On Hand Qty	NUMERIC	N	N
SC_COUNTS	DETAIL	On Hand Units	NUMERIC	N	N
SC_COUNTS	DETAIL	Page	TEXT	N	N
SC_COUNTS	DETAIL	Pallet Id	NUMERIC	N	R
SC_COUNTS	DETAIL	Pallet Type	TEXT	N	Y
SC_COUNTS	DETAIL	Rotation	TEXT	N	R
SC_COUNTS	DETAIL	Sell By Date	DATE	N	R
SC_COUNTS	DETAIL	Stock Code	TEXT	N	R
SC_COUNTS	DETAIL	Stock Take Date	DATE	N	R
SC_COUNTS	DETAIL	Stockist Code	TEXT	N	Y
SC_COUNTS	DETAIL	Stockist Sub Code	TEXT	N	Y
SC_COUNTS	DETAIL	User Field 1	TEXT	N	N
SC_COUNTS	DETAIL	User Field 2	TEXT	N	N
SC_COUNTS	DETAIL	Weight Uom	TEXT	N	N
SC_UNCHECK	HEADER	Start Check Year	DATE	Y	N
SC_UNCHECK	HEADER	Last PI Check	DATE	Y	R
SC_UNCHECK	HEADER	Location Code	TEXT	N	R
SC_UNCHECK	HEADER	On Hand Cases	NUMERIC	N	N
SC_UNCHECK	HEADER	On Hand Units	NUMERIC	N	N
SC_UNCHECK	HEADER	Pallet Id	NUMERIC	N	R
SC_UNCHECK	HEADER	Rotation	TEXT	N	R
SC_UNCHECK	HEADER	Sell By Date	DATE	N	R
SC_UNCHECK	HEADER	Stock Code	TEXT	N	R
SC_UNCHECK	HEADER	Stockist Code	TEXT	N	Y
SC_UNCHECK	HEADER	Stockist Sub Code	TEXT	N	Y
SC_UNCHECK	HEADER	Warehouse Id	TEXT	Y	R
SHIP_PAL	HDR	Carrier	TEXT	N	N
SHIP_PAL	HDR	Closed Date	DATE	N	N
SHIP_PAL	HDR	Company Code	TEXT	Y	Y
SHIP_PAL	HDR	Pack Status	TEXT	N	N
SHIP_PAL	HDR	Ship Pall Status	TEXT	N	N
SHIP_PAL	HDR	Order Num	TEXT	N	R
SHIP_PAL	HDR	Owner Code	TEXT	Y	Y
SHIP_PAL	HDR	Pallet Location	TEXT	N	N
SHIP_PAL	HDR	Ord Priority	TEXT	N	N
SHIP_PAL	HDR	Ord Status	TEXT	N	N
SHIP_PAL	HDR	Pack List No	TEXT	N	Y
SHIP_PAL	HDR	Package Ref	TEXT	N	N
SHIP_PAL	HDR	Packed Cases	NUMERIC	N	N
SHIP_PAL	HDR	Packed Units	NUMERIC	N	N
SHIP_PAL	HDR	Shipment Pallet	NUMBERIC	N	Y
SHIP_PAL	HDR	Warehouse Id	TEXT	Y	Y
SHIP_PAL	HDR	Gross Weight	NUMERIC	N	N
SHIP_PAL	HDR	Net Weight	NUMERIC	N	N
SHIP_PAL	DTL	Hazardous Flag	TEXT	N	N
SHIP_PAL	DTL	Line No	NUMERIC	N	N
SHIP_PAL	DTL	Packed Cases	NUMERIC	N	N
SHIP_PAL	DTL	Packed Units	NUMERIC	N	N
SHIP_PAL	DTL	Packed Weight	NUMERIC	N	N
SHIP_PAL	DTL	Page Num	NUMERIC	N	N
SHIP_PAL	DTL	Pallet Id	NUMERIC	N	N
SHIP_PAL	DTL	Rotation No	TEXT	N	N
SHIP_PAL	DTL	Stock Code	TEXT	N	Y
STK_DTL	HEADER	Product Name	TEXT	N	N
STK_DTL	HEADER	Date/Time	TEXT	N	N
STK_DTL	HEADER	Message Identifier	TEXT	N	N
STK_DTL	HEADER	Product Description	TEXT	N	N
STK_DTL	HEADER	Generic Product Code	TEXT	N	N
STK_DTL	HEADER	National Product Code	TEXT	N	N
STK_DTL	HEADER	Packing Type	TEXT	N	N
STK_DTL	HEADER	Owner Code	TEXT	N	N
STK_DTL	HEADER	Eaches Per Packaging Unit	NUMERIC	N	N
STOCK	HEADER	Stock AKA	TEXT	N	N
STOCK	HEADER	Alloc Seq	TEXT	N	N
STOCK	HEADER	AQ Flag	TEXT	N	N
STOCK	HEADER	Base Price	NUMERIC	N	N
STOCK	HEADER	Bonded	TEXT	N	N	Y,N
STOCK	HEADER	Capacity Weight	NUMERIC	N	N
STOCK	HEADER	Depth	NUMERIC	N	N
STOCK	HEADER	Cases Per Layer	NUMERIC	N	N
STOCK	HEADER	Length	NUMERIC	N	N
STOCK	HEADER	Net Weight	NUMERIC	N	N
STOCK	HEADER	Width	NUMERIC	N	N
STOCK	HEADER	Country	TEXT	N	N
STOCK	HEADER	CUC Ean	TEXT	N	N
STOCK	HEADER	Date Amended	DATE	N	R
STOCK	HEADER	Date Created	DATE	N	R
STOCK	HEADER	Description	TEXT	Y	N
STOCK	HEADER	Description2	TEXT	N	N
STOCK	HEADER	Description3	TEXT	N	N
STOCK	HEADER	Factor 1 2	NUMERIC	N	N
STOCK	HEADER	Factor 1 3	NUMERIC	N	N
STOCK	HEADER	Factor 2 3	NUMERIC	N	N
STOCK	HEADER	Hazardous	TEXT	N	N
STOCK	HEADER	Min Intake Days	NUMERIC	N	N
STOCK	HEADER	Issue Days	NUMERIC	N	N
STOCK	HEADER	Layer Height	NUMERIC	N	N
STOCK	HEADER	Length UOM	TEXT	N	N
STOCK	HEADER	Lot Trace	TEXT	N	N
STOCK	HEADER	Max Intake Days	NUMERIC	N	N
STOCK	HEADER	Max Sales Order Qty	NUMERIC	N	N
STOCK	HEADER	Measure Type	TEXT	N	N
STOCK	HEADER	Min Order Qty	NUMERIC	N	N
STOCK	HEADER	Non-Stock	TEXT	N	N
STOCK	HEADER	Supplier	TEXT	N	Y
STOCK	HEADER	Layers Per Pallet	NUMERIC	N	N
STOCK	HEADER	Pallet Type	TEXT	N	N
STOCK	HEADER	Category	TEXT	N	R
STOCK	HEADER	Class	TEXT	N	R
STOCK	HEADER	Group	TEXT	N	R
STOCK	HEADER	Range	TEXT	N	R
STOCK	HEADER	Product Strength	TEXT	N	N
STOCK	HEADER	Product Sub Group	TEXT	N	R
STOCK	HEADER	Status	TEXT	N	Y
STOCK	HEADER	Product Type	TEXT	N	R
STOCK	HEADER	PUC Ean	TEXT	N	N
STOCK	HEADER	Putaway	TEXT	N	N
STOCK	HEADER	Re-Order	TEXT	N	N
STOCK	HEADER	Kit Flag	TEXT	N	N
STOCK	HEADER	Size	TEXT	N	N
STOCK	HEADER	Std Pallet Qty	NUMERIC	N	N
STOCK	HEADER	Cost	NUMERIC	N	N
STOCK	HEADER	Standard Cost	NUMERIC	N	N
STOCK	HEADER	ABC Code	TEXT	N	N
STOCK	HEADER	Stock Code	TEXT	Y	R
STOCK	HEADER	Stocking UOM	TEXT	N	Y
STOCK	HEADER	Owner	TEXT	Y	R
STOCK	HEADER	Temp	TEXT	N	N
STOCK	HEADER	Time Amended	NUMBER	N	N
STOCK	HEADER	Transit Factor	NUMBER	N	N
STOCK	HEADER	TUC Ean	TEXT	N	N
STOCK	HEADER	UN Number	TEXT	N	N
STOCK	HEADER	UN Variant	NUMERIC	N	N
STOCK	HEADER	UOM 1	TEXT	N	N
STOCK	HEADER	UOM 2	TEXT	N	N
STOCK	HEADER	UOM 3	TEXT	N	N
STOCK	HEADER	VAT Code	TEXT	N	N
STOCK	HEADER	Volume UOM	TEXT	N	N
STOCK	HEADER	Gross Weight	NUMERIC	N	N
STOCK	HEADER	Weight UOM	TEXT	N	N
STOCK	LOCATION	Replenish Quantity	NUMERIC	N	N
STOCK	LOCATION	Replenish at Quantity	NUMERIC	N	N
STOCK	LOCATION	Location Code	TEXT	N	N
STOCK	LOCATION	Putaway Priority	TEXT	N	N
STOCK	LOCATION	Replenish Pallet	NUMERIC	N	N
STOCK	LOCATION	Location Type	TEXT	N	N
STOCK	LOCATION	Warehouse	TEXT	N	R
STOCK_TAKE	DETAIL	Allocated Cases	NUMERIC	N	N
STOCK_TAKE	DETAIL	Allocated Units	NUMERIC	N	N
STOCK_TAKE	DETAIL	Date	DATE	N	R
STOCK_TAKE	DETAIL	Checker	TEXT	N	Y
STOCK_TAKE	DETAIL	Customer Pallet	TEXT	N	Y
STOCK_TAKE	DETAIL	Customer Rotation	TEXT	N	Y
STOCK_TAKE	DETAIL	Stock Found	TEXT	N	N	'Y','N'
STOCK_TAKE	DETAIL	Discrepancy	TEXT	N	N	'Y','N'
STOCK_TAKE	DETAIL	Stock Lost	TEXT	N	N	'Y','N'
STOCK_TAKE	DETAIL	Stock Description	TEXT	N	N
STOCK_TAKE	DETAIL	Stock Description 2	TEXT	N	N
STOCK_TAKE	DETAIL	Checker Name	TEXT	N	N
STOCK_TAKE	DETAIL	Expected Cases	NUMERIC	N	N
STOCK_TAKE	DETAIL	Expected Units	NUMERIC	N	N
STOCK_TAKE	DETAIL	Held Cases	NUMERIC	N	N
STOCK_TAKE	DETAIL	Held Units	NUMERIC	N	N
STOCK_TAKE	DETAIL	Location	TEXT	N	R
STOCK_TAKE	DETAIL	Stockist Name	TEXT	N	N
STOCK_TAKE	DETAIL	On Hand Cases	NUMERIC	N	N
STOCK_TAKE	DETAIL	On Hand Units	NUMERIC	N	N
STOCK_TAKE	DETAIL	Pallet ID	NUMERIC	N	Y
STOCK_TAKE	DETAIL	Rotation No.	TEXT	N	Y
STOCK_TAKE	DETAIL	Stock Code	TEXT	Y	R
STOCK_TAKE	DETAIL	Stockist Code	TEXT	N	Y
STOCK_TAKE	DETAIL	Stockist Sub Code	TEXT	N	Y
STOCK_UOMS	HEADER	Stock AKA	TEXT	N	N
STOCK_UOMS	HEADER	Alloc Seq	TEXT	N	N
STOCK_UOMS	HEADER	AQ Flag	TEXT	N	N
STOCK_UOMS	HEADER	Barcode	TEXT	N	Y
STOCK_UOMS	HEADER	Base Price	NUMERIC	N	N
STOCK_UOMS	HEADER	Bonded	TEXT	N	N	Y,N
STOCK_UOMS	HEADER	Capacity Weight	NUMERIC	N	N
STOCK_UOMS	HEADER	Depth	NUMERIC	N	N
STOCK_UOMS	HEADER	Cases Per Layer	NUMERIC	N	N
STOCK_UOMS	HEADER	Length	NUMERIC	N	N
STOCK_UOMS	HEADER	Net Weight	NUMERIC	N	N
STOCK_UOMS	HEADER	Width	NUMERIC	N	N
STOCK_UOMS	HEADER	Country	TEXT	N	N
STOCK_UOMS	HEADER	CUC Ean	TEXT	N	N
STOCK_UOMS	HEADER	Date Amended	DATE	N	R
STOCK_UOMS	HEADER	Date Created	DATE	N	R
STOCK_UOMS	HEADER	Description	TEXT	Y	N
STOCK_UOMS	HEADER	Description2	TEXT	Y	N
STOCK_UOMS	HEADER	Description3	TEXT	N	N
STOCK_UOMS	HEADER	Factor 1 2	NUMERIC	N	N
STOCK_UOMS	HEADER	Factor 1 3	NUMERIC	N	N
STOCK_UOMS	HEADER	Factor 2 3	NUMERIC	N	N
STOCK_UOMS	HEADER	Hazardous	TEXT	N	N
STOCK_UOMS	HEADER	Min Intake Days	NUMERIC	N	N
STOCK_UOMS	HEADER	Issue Days	NUMERIC	N	N
STOCK_UOMS	HEADER	Length UOM	TEXT	N	N
STOCK_UOMS	HEADER	Lot Trace	TEXT	N	N
STOCK_UOMS	HEADER	Max Intake Days	NUMERIC	N	N
STOCK_UOMS	HEADER	Max Sales Order Qty	NUMERIC	N	N
STOCK_UOMS	HEADER	Measure Type	TEXT	N	N
STOCK_UOMS	HEADER	Min Order Qty	NUMERIC	N	N
STOCK_UOMS	HEADER	Non-Stock	TEXT	N	N
STOCK_UOMS	HEADER	Supplier	TEXT	N	Y
STOCK_UOMS	HEADER	Layers Per Pallet	NUMERIC	N	N
STOCK_UOMS	HEADER	Pallet Type	TEXT	N	N
STOCK_UOMS	HEADER	Category	TEXT	N	R
STOCK_UOMS	HEADER	Class	TEXT	N	R
STOCK_UOMS	HEADER	Group	TEXT	N	R
STOCK_UOMS	HEADER	Range	TEXT	N	R
STOCK_UOMS	HEADER	Product Sub Group	TEXT	N	R
STOCK_UOMS	HEADER	Status	TEXT	N	Y
STOCK_UOMS	HEADER	Product Type	TEXT	N	R
STOCK_UOMS	HEADER	PUC Ean	TEXT	N	N
STOCK_UOMS	HEADER	Putaway	TEXT	N	N
STOCK_UOMS	HEADER	Re-Order	TEXT	N	N
STOCK_UOMS	HEADER	Kit Flag	TEXT	N	N
STOCK_UOMS	HEADER	Size	TEXT	N	N
STOCK_UOMS	HEADER	Std Pallet Qty	NUMERIC	N	N
STOCK_UOMS	HEADER	Standard Cost	NUMERIC	N	N
STOCK_UOMS	HEADER	ABC Code	TEXT	N	N
STOCK_UOMS	HEADER	Stock Code	TEXT	Y	R
STOCK_UOMS	HEADER	Stocking UOM	TEXT	N	Y
STOCK_UOMS	HEADER	Owner	TEXT	Y	R
STOCK_UOMS	HEADER	Temp	TEXT	N	N
STOCK_UOMS	HEADER	Time Amended	NUMERIC	N	N
STOCK_UOMS	HEADER	Transit Factor	NUMERIC	N	N
STOCK_UOMS	HEADER	TUC Ean	TEXT	N	N
STOCK_UOMS	HEADER	UN Number	TEXT	N	N
STOCK_UOMS	HEADER	UN Variant	NUMERIC	N	N
STOCK_UOMS	HEADER	UOM 1	TEXT	N	N
STOCK_UOMS	HEADER	UOM 2	TEXT	N	N
STOCK_UOMS	HEADER	UOM 3	TEXT	N	N
STOCK_UOMS	HEADER	VAT Code	TEXT	N	N
STOCK_UOMS	HEADER	Volume UOM	TEXT	N	N
STOCK_UOMS	HEADER	Gross Weight	NUMERIC	N	N
STOCK_UOMS	HEADER	Weight UOM	TEXT	N	N
SUBSTITUTE	SUBSTITUTE	Customer Code	TEXT	N	N
SUBSTITUTE	SUBSTITUTE	Customer Sub Code	TEXT	N	N
SUBSTITUTE	SUBSTITUTE	Description	TEXT	N	N
SUBSTITUTE	SUBSTITUTE	Subs Description	TEXT	N	N
SUBSTITUTE	SUBSTITUTE	Description 2	TEXT	N	N
SUBSTITUTE	SUBSTITUTE	Subs Description 2	TEXT	N	N
SUBSTITUTE	SUBSTITUTE	Description 3	TEXT	N	N
SUBSTITUTE	SUBSTITUTE	Subs Description 3	TEXT	N	N
SUBSTITUTE	SUBSTITUTE	Owner Code	TEXT	Y	R
SUBSTITUTE	SUBSTITUTE	Owner Sub Code	TEXT	Y	N
SUBSTITUTE	SUBSTITUTE	Seq Number	NUMBERIC	N	N
SUBSTITUTE	SUBSTITUTE	Master Stock Code	TEXT	Y	R
SUBSTITUTE	SUBSTITUTE	Substitute Product	TEXT	Y	N
SUBSTITUTE	SUBSTITUTE	Warehouse Id	TEXT	Y	R
SUPPLIER	HEADER	Approved	TEXT	N	R
SUPPLIER	HEADER	Buyer	TEXT	N	R
SUPPLIER	HEADER	Country Code	TEXT	N	Y
SUPPLIER	HEADER	County	TEXT	N	N
SUPPLIER	HEADER	Currency	TEXT	N	N
SUPPLIER	HEADER	Dispute Code	TEXT	N	R
SUPPLIER	HEADER	Country Name	TEXT	N	N
SUPPLIER	HEADER	Name	TEXT	Y	N
SUPPLIER	HEADER	Supplier ID	TEXT	Y	R
SUPPLIER	HEADER	Address Line 1	TEXT	N	N
SUPPLIER	HEADER	Address Line 2	TEXT	N	N
SUPPLIER	HEADER	Class	TEXT	N	R
SUPPLIER	HEADER	Name	TEXT	N	N
SUPPLIER	HEADER	Post Code	TEXT	N	N
SUPPLIER	HEADER	Type	TEXT	N	R
SUPPLIER	HEADER	Town	TEXT	N	N
USER_LOGON	HEADER	Activity	TEXT	N	Y
USER_LOGON	HEADER	Activity Date	TEXT	N	Y
USER_LOGON	HEADER	Username	TEXT	N	Y
USER_LOGON	HEADER	Previous Login	TEXT	N	Y
USER_LOGON	HEADER	Network Login	TEXT	N	Y
USER_LOGON	HEADER	Machine Name	TEXT	N	Y
USER_LOGON	HEADER	IP Address	TEXT	N	Y
USER_LOGON	HEADER	Java Version	TEXT	N	Y
USER_LOGON	HEADER	Operating System	TEXT	N	Y
USERS_AUD	HEADER	Action	NUMBER	N	R
USERS_AUD	HEADER	Action name	TEXT	N	Y
USERS_AUD	HEADER	Object Name	TEXT	N	R
USERS_AUD	HEADER	Priv Used	TEXT	N	Y
USERS_AUD	HEADER	Sql Values	TEXT	N	N
USERS_AUD	HEADER	Sql Used	TEXT	N	N
USERS_AUD	HEADER	Error Code	NUMERIC	N	Y
USERS_AUD	HEADER	Sessionid	NUMERIC	N	Y
USERS_AUD	HEADER	Logon Date	DATE	N	R
USERS_AUD	HEADER	Username	TEXT	Y	Y
WARRANT	DETAIL	Total num of outers	NUMERIC	Y	N
WARRANT	DETAIL	Customer Code	TEXT	Y	N
WARRANT	DETAIL	Description	TEXT	Y	N
WARRANT	DETAIL	Num of outers per case	NUMERIC	Y	N
WARRANT	DETAIL	Customer Name	TEXT	Y	N
WARRANT	DETAIL	Order Number	TEXT	Y	R
WARRANT	DETAIL	No of cases	DATE	Y	N
WARRANT	DETAIL	Stock Code	TEXT	Y	N
WARRANT	DETAIL	Despatch Date	TEXT	Y	N
WARRANT	DETAIL	Warrant Number	TEXT	Y	R
WMS_AUDIT	WMS_AUDIT	Audit No	NUMERIC	Y	R
WMS_AUDIT	WMS_AUDIT	Change Date	DATE	Y	R
WMS_AUDIT	WMS_AUDIT	Change Time	NUMERIC	Y	N
WMS_AUDIT	WMS_AUDIT	Change Type	TEXT	N	Y
WMS_AUDIT	WMS_AUDIT	Changed By	TEXT	Y	R
WMS_AUDIT	WMS_AUDIT	Company Code	TEXT	N	Y
WMS_AUDIT	WMS_AUDIT	Field Name	TEXT	Y	N
WMS_AUDIT	WMS_AUDIT	Message Type	TEXT	Y	Y
WMS_AUDIT	WMS_AUDIT	New Value	TEXT	Y	N
WMS_AUDIT	WMS_AUDIT	Old Value	TEXT	Y	N
WMS_AUDIT	WMS_AUDIT	Owner Code	TEXT	N	R
WMS_AUDIT	WMS_AUDIT	Owner Sub Code	TEXT	N	Y
WMS_AUDIT	WMS_AUDIT	Reference	TEXT	Y	Y
WMS_AUDIT	WMS_AUDIT	Reference 2	TEXT	N	N
WMS_AUDIT	WMS_AUDIT	Warehouse Id	TEXT	N	R