SLGUMD


Field Name	Label	Col-Label	Format	Dec
AllowSplit	Allow Split	Split	yes/no
AltUM	AltUM	Alt!UM	x(2)
CreateDate	Create Date		99/99/99
CreateUserID	Created		x(8)
Domain	Domain		x(8)
ModDate	Modified Date	Mod Date	99/99/99
ModUserID	User ID		x(8)
MultTrans	Multi-Trans	Multi!Trans	yes/no
oid_SLGUMD			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
OverPick	Over Pick	Over!Pick	yes/no
PickMultUM	Picking Multiple UM	Pick!Mult!UM	x(2)
QadC01	QAD Field		X(8)	0
QadC02	QAD Field		X(8)	0
QadC03	QAD Field		X(8)	0
QadC04	QAD Field		X(8)	0
QadC05	QAD Field		X(8)	0
QadD01	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD02	QAD Field		->>>>,>>>,>>9.99<<<	10
QadD03	QAD Field		->>>>,>>>,>>9.99<<<	10
QadI01	QAD Field		->,>>>,>>9
QadI02	QAD Field		->,>>>,>>9
QadI03	QAD Field		->,>>>,>>9
QadL01	QAD Field		yes/no
QadL02	QAD Field		yes/no
QadT01	QAD Field		99/99/99
QadT02	QAD Field		99/99/99
QadT03	QAD Field		99/99/99
Site	Site		x(8)
SLocGp	Store Loc Group	SLocGrp	x(8)
User1	User 1		x(8)
User2	User 2		x(8)
UserC03	User Field Character 3		x(24)
UserC04	User Field Character 4		x(24)
UserC05	User Field Character 5		x(24)
UserD01	User Field Decimal 1		->>>>,>>>,>>9.9<<<<<<<<<	10
UserD02	User Field Decimal 2		->>>>,>>>,>>9.9<<<<<<<<<	10
UserI01	User Field Integer 1		->>>>>>>9
UserI02	User Field Integer 2		->>>>>>>9
UserL01	User Field Logical 1		yes/no
UserL02	User Field Logical 2		yes/no
UserT01	User Field Date 1		99/99/99
UserT02	User Field Date 1		99/99/99
Whse	Warehouse	Whse	x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_SLGUMD	yes	oid_SLGUMD	yes	no
∗	SLGUM	yes	Domain	yes	no
			Site	yes	no
			Whse	yes	no
			SLocGp	yes	no
			AltUM	yes	no
	UsrIdx	no	Domain	yes	no
			User1	yes	no
			User2	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_slrd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
slrd__qadc01			x(24)
slrd__qadc02			x(24)
slrd__qadd01			->>>>,>>>,>>9.9<<<<<<<<<	10
slrd__qadd02			->>>>,>>>,>>9.9<<<<<<<<<	10
slrd__qadi01			->>>>>>>9
slrd__qadl01			yes/no
slrd__qadt01			99/99/99
slrd__qadt02			99/99/99
slrd_attrib_code	Attribute Value		x(18)
slrd_domain	Domain		x(8)
slrd_gl_cost_site	Default GL Cost Site	GL Site	x(8)
slrd_inventory_site	Inventory Site	Site	x(8)
slrd_linking_rule	Site Linking Rule	Linking!Rule	9
slrd_mod_date	Modified Date		99/99/99
slrd_mod_userid	User ID		x(8)
slrd_userc01	User Field Character 1		x(24)
slrd_userc02	User Field Character 2		x(24)
slrd_userd01	User Field Decimal		->>>>,>>>,>>9.9<<<<<<<<<	10
slrd_useri01	User Field Integer		->>>>>>>9
slrd_userl01	User Field Logical		yes/no
slrd_usert01	User Field Date		99/99/99


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_slrd_det	yes	oid_slrd_det	yes	no
	slrd_cost_site	no	slrd_domain	yes	no
			slrd_gl_cost_site	yes	no
∗	slrd_site	yes	slrd_domain	yes	no
			slrd_inventory_site	yes	no
			slrd_attrib_code	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_slr_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
slr__qadc01			x(24)
slr__qadc02			x(24)
slr__qadd01			->>>>,>>>,>>9.9<<<<<<<<<	10
slr__qadd02			->>>>,>>>,>>9.9<<<<<<<<<	10
slr__qadi01			->>>>>>>9
slr__qadl01			yes/no
slr__qadt01			99/99/99
slr__qadt02			99/99/99
slr_attribute	Item Attribute		x(1)
slr_domain	Domain		x(8)
slr_inventory_site	Inventory Site	Site	x(8)
slr_lsc_active	Linked-Site Costing Active		yes/no
slr_mod_date	Modified Date		99/99/99
slr_mod_userid	User ID		x(8)
slr_userc01	User Field Character 1		x(24)
slr_userc02	User Field Character 2		x(24)
slr_userd01	User Field Decimal		->>>>,>>>,>>9.9<<<<<<<<<	10
slr_useri01	User Field Integer		->>>>>>>9
slr_userl01	User Field Logical		yes/no
slr_usert01	User Field Date		99/99/99


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_slr_mstr	yes	oid_slr_mstr	yes	no
∗	slr_site	yes	slr_domain	yes	no
			slr_inventory_site	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sm_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sm__qadc01			x(8)
sm_domain	Domain		x(8)
sm_end	End		99/99/99
sm_lead	Lead Time		->,>>>	10
sm_mktg_site	Marketing Site	Marketing	x(8)
sm_part	Item Number		x(18)
sm_pct	Supply Percent	Percent	>>9.9<%	10
sm_start	Start		99/99/99
sm_sup_site	Supply Site	Supply	x(8)
sm_trans	Transport Code	Transport	x(8)
sm_type	Type		x(1)
sm_user1	Ufld1		x(8)
sm_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sm_mstr	yes	oid_sm_mstr	yes	no
∗	sm_mstr	yes	sm_domain	yes	no
			sm_part	yes	no
			sm_sup_site	yes	no
			sm_mktg_site	yes	no
			sm_start	yes	no
			sm_type	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sob_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sob__qadc01			x(8)
sob_bo_chg	Qty B/O		->,>>>,>>9.9<<<<<<<<	10
sob_cfg_type	Configuration	Config	x(1)
sob_cmtindx	Comment Index	Comment	>>>>>>>9
sob_domain	Domain		x(8)
sob_feature	Feature		x(12)
sob_iss_date	Issue Date	Iss Date	99/99/99
sob_line	Line		>>9
sob_loc	Location		x(8)
sob_nbr	Sales Order	Order	x(8)
sob_parent	Parent Item		x(18)
sob_part	Item Number		x(18)
sob_price	Price		>>>>,>>>,>>9.99<<<	10
sob_qty_all	Qty Allocated		->,>>>,>>9.9<<<<<<<<	10
sob_qty_chg	Qty to Issue		->,>>>,>>9.9<<<<<<<<	10
sob_qty_iss	Qty Issued		->,>>>,>>9.9<<<<<<<<	10
sob_qty_pick	Qty Picked		->,>>>,>>9.9<<<<<<<<	10
sob_qty_req	Qty Required		->,>>>,>>9.9<<<<<<<<	10
sob_scrp_pct	Scrap		>>9.99%	10
sob_serial	Lot/Serial		x(18)
sob_site	Site		x(8)
sob_tot_std	List Price		->>>,>>9.999	10
sob_user1	Ufld1		x(8)
sob_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sob_det	yes	oid_sob_det	yes	no
∗	sob_det	yes	sob_domain	yes	no
			sob_nbr	yes	no
			sob_line	yes	no
			sob_parent	yes	no
			sob_feature	yes	no
			sob_part	yes	no
	sob_part	yes	sob_domain	yes	no
			sob_part	yes	no
			sob_nbr	yes	no
			sob_line	yes	no
			sob_parent	yes	no
			sob_feature	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_socc_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
socc__qadc01			x(8)
socc__qadd01			->>>,>>>,>>9.9<<<<<<<<<	10
socc__qadi01			>>>>>>9
socc__qadl01			yes/no
socc__qadt01			99/99/99
socc_auth_amt	Authorization Amount	Auth Amt	>>>>,>>>,>>9.99<	10
socc_auth_date	Authorization Date	Auth Date	99/99/99
socc_auth_expire_date	Authorization Expires	Auth Expires	99/99/99
socc_auth_nbr	Authorization Number		x(20)
socc_billing_addr1	Address		x(28)
socc_billing_addr2	Address		x(28)
socc_billing_addr3	Address		x(28)
socc_billing_city	City		x(20)
socc_billing_country	Country		x(28)
socc_billing_ctry	Country Code	Ctry	x(3)
socc_billing_name	Name		x(28)
socc_billing_state	State	St	x(4)
socc_billing_zip	Post		x(10)
socc_card_type	Card Type		x(8)
socc_cc_expire_date	Expire Date	Expire	99/99/99
socc_cc_nbr	Credit Card Number		x(24)
socc_cc_nbr_tail	End Digits	Ending	x(4)
socc_domain	Domain		x(8)
socc_mod_date	Modified Date	Mod Date	99/99/99
socc_mod_userid	User ID		x(8)
socc_nbr	Sales Order	Order	x(8)
socc_user1	User Field 1		x(24)
socc_user2	User Field 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_socc_mstr	yes	oid_socc_mstr	yes	no
∗	socc_nbr	yes	socc_domain	yes	no
			socc_nbr	yes	no
			socc_cc_nbr	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_soc_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
soc__qad01			yes/no
soc__qad02			yes/no
soc__qad03			>>>>>>9
soc__qadc01	QAD Field		X(8)	0
soc__qadc02	QAD Field		X(8)	0
soc__qadc03	QAD Field		X(8)	0
soc__qadi01	QAD Field		->,>>>,>>9
soc__qadi02	QAD Field		->,>>>,>>9
soc__qadl02	Check Customer Item Nbr First		yes/no
soc__qadl03	QAD Field		yes/no
soc_all	Qty All reduce qty Available		yes/no
soc_all_avl	Limit allocate to avail only		yes/no
soc_all_days	Allocate Days into Future		>>>>>9
soc_allow_closed_inv_corr	Allow Closed Invoice Correction	Allow Closed Inv Corr	yes/no
soc_apm	Integrate with APM		yes/no
soc_ar	Integrate with AR		yes/no
soc_atp_enabled	ATP Enforcement Enabled	ATP Enf	yes/no
soc_auto_chg	Auto Accept Supplier Changes		yes/no
soc_batch	Auto Batch Confirmation		yes/no
soc_batch_id	Confirmation Batch ID		X(8)
soc_btb_all	Direct Allocation	Dir All	yes/no
soc_btb_sel	EMT Sequence	EMT Seq	xxxx
soc_btb_type	EMT Type		xx
soc_calc_promise_date	Calc Promise Date	Calc Prom Date	yes/no
soc_company	Company Address		x(8)
soc_confirm	Confirmed Orders		yes/no
soc_cons_inv_by_shipfrom	Ignore Ship-From When Consolidating Invoices		yes/no
soc_cr_hold	Hold Orders Over Credit Limit		yes/no
soc_crn_next	Next Correction Invoice Nbr		>>>>>>>9
soc_crn_pre	Correction Invoice Prefix		x(3)
soc_crtacc_acct	SO Interest Accrued Acct		X(8)
soc_crtacc_cc	SO Interest Accrued CC	CC	X(4)
soc_crtacc_sub	SO Int Accrued Sub	Sub-Acct	x(8)
soc_crtapp_acct	SO Interest Applied Account		X(8)
soc_crtapp_cc	SO Interest Applied Cost Center	CC	X(4)
soc_crtapp_sub	SO Int Accrued Sub	Sub-Acct	x(8)
soc_days_del_so	Days to Delete a Sales Order		>>9
soc_delbas	Deliv Based Inv		Yes/No
soc_det_all	Detail Allocations		yes/no
soc_dflt_dybkset	Default Daybook Set	Def Dybk Set	x(8)
soc_domain	Domain		x(8)
soc_due_calc	Calculate Due Date	Calc Due Date	yes/no
soc_dum_loc	Direct Shipment Location		x(8)
soc_dybkset_by_site	Use Daybook Set by Site		yes/no
soc_edit_isb	SO Edit ISB Defaults		yes/no
soc_ex_ratetype	Rate Type		x(8)
soc_fcst_bck	Consume Back	Fcst Back	->,>>>,>>9
soc_fcst_fwd	Consume Fwd	Fcst Fwd	->,>>>,>>9
soc_fnbr_seq	Default Fiscal Number Sequence		x(8)
soc_fob	F.O.B.		x(20)
soc_fr_by_site	Calculate Freight by Site		yes/no
soc_fr_shp_calc	Recalc Freight at Ship Time		yes/no
soc_frc_returns	Sales Returns Freight Calculation		X(1)	0
soc_fysm	Fiscal Start Month		>9
soc_gst_pst	Print Tax ID on Invoice		yes/no
soc_hcmmts	Sales Order Header Comments		yes/no
soc_horizon	ATP Horizon		->,>>>,>>9
soc_index1	Index		>>>>>9
soc_inv	Next Invoice		>>>>>>>9
soc_inv_hist	Keep Invoice History	Inv!Hst	yes/no
soc_inv_min	Minimum Invoice Amount		>,>>>,>>9.	10
soc_inv_pre	Invoice Prefix	Pre	x(3)
soc_jrnl	Next Journal		999999
soc_lcmmts	Sales Order Line Comments		yes/no
soc_list_markup_net_req	List/Mark-Up/Net Price Tbl Req		yes/no
soc_ln_fmt	Ln Format S/M		single/multi
soc_ln_inv	Print Only Lines to Invoice		yes/no
soc_maintain_reviewed	Allow Maintenance of Reviewed Orders	Maintain Reviewed	yes/no
soc_margin	Comm on Margin not Sales		yes/no
soc_min_ship	Minimum Shipment Amount		>,>>>,>>9.	0
soc_min_shpamt	Minimum Shipment Amount		>,>>>,>>9	10
soc_mlevel_btb	Multiple Level EMT	Mlevel EMT	yes/no
soc_next_abl	Next ASN/BOL		>>>>>>>9
soc_next_cid	Next Cntnr Nbr		>>>>>>>9
soc_ntaxdesc[10]	Description		x(12)
soc_on_ord	Qty avail include qty on order		yes/no
soc_pass_curr	Use Customer Currency on PO		yes/no
soc_pc_line	Price by SO Line Due Date		yes/no
soc_pick	Pick Only Allocated Lines		yes/no
soc_pim_isb	Pend Inv Edit ISB		yes/no
soc_pl_req	Price List Required		yes/no
soc_print	Are Sales Orders Printed		yes/no
soc_print_id	Confirmation Printer		X(8)
soc_print_ship	Shipper On Invoice		yes/no
soc_pt_req	Price Table Required		yes/no
soc_req	Required qty reduce qty avail		yes/no
soc_returns_isb	SO Returns Update ISB		yes/no
soc_rnd_flag	Enable Rounding Function		yes/no
soc_sa	Integrate with SA	SA	yes/no
soc_shp_lead	Shipping Lead Time		>>>9
soc_so	Next Sales Order		>>>>>>>9
soc_so_hist	Keep Booking History	Book!Hst	yes/no
soc_so_pre	Sales Order Prefix	Pre	x(3)
soc_trl_ntax[3]	Nontaxable Trailer Code		x(2)
soc_trl_tax[3]	Taxable Trailer Code	Trl	x(2)
soc_use_btb	Use Enterprise Material Transfer	Use EMT	yes/no
soc_use_corr_inv	Use Correction Invoices		yes/no
soc_use_fnbr	Use Fiscal Number		yes/no
soc_use_frt_trl_cd	Use SO Frt List Trailer Code		yes/no
soc_user1	Ufld1		x(8)
soc_user2	Ufld2		x(8)
soc_valueorders_by	Value Orders Using		x(8)
soc_zero_pr_cust_schd	Zero Price Allowed for Cust Schedule		yes/no


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_soc_ctrl	yes	oid_soc_ctrl	yes	no
∗	soc_index1	yes	soc_domain	yes	no


Field Name	Label	Col-Label	Format	Dec
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SODAudit_ID	record ID		-99999999999
SODAuditDateTime	Time Stamp of Creation		x(40)
SODAuditResourceURI	Resource URI		x(256)
SODAuditRoleName	Role		x(20)
SODAuditUsrLogin	User		x(20)


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	prim	yes	SODAudit_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
CustomCombo0			x(20)
CustomCombo1			x(20)
CustomCombo2			x(20)
CustomCombo3			x(20)
CustomCombo4			x(20)
CustomCombo5			x(20)
CustomCombo6			x(20)
CustomCombo7			x(20)
CustomCombo8			x(20)
CustomCombo9			x(20)
CustomDate0			99/99/9999
CustomDate1			99/99/9999
CustomDate2			99/99/9999
CustomDate3			99/99/9999
CustomDate4			99/99/9999
CustomDecimal0			->,>>>,>>9.99	4
CustomDecimal1			->,>>>,>>9.99	4
CustomDecimal2			->,>>>,>>9.99	4
CustomDecimal3			->,>>>,>>9.99	4
CustomDecimal4			->,>>>,>>9.99	4
CustomInteger0			->,>>>,>>9
CustomInteger1			->,>>>,>>9
CustomInteger2			->,>>>,>>9
CustomInteger3			->,>>>,>>9
CustomInteger4			->,>>>,>>9
CustomLong0			x(255)
CustomLong1			x(255)
CustomNote			x(2000)
CustomShort0			x(20)
CustomShort1			x(20)
CustomShort2			x(20)
CustomShort3			x(20)
CustomShort4			x(20)
CustomShort5			x(20)
CustomShort6			x(20)
CustomShort7			x(20)
CustomShort8			x(20)
CustomShort9			x(20)
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SODCategory_ID	record ID		-99999999999
SODCategoryCode	SOD category code		x(20)
SODCategoryDescription	SOD category description		x(2000)


	Index-Name	Uni	Field-Name	Asc	Abbr
	Code	yes	SODCategoryCode	yes	no
∗	Prim	yes	SODCategory_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sodctg_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sodctg__qadc01			x(24)
sodctg__qadc02			x(24)
sodctg_category	SOD Category Code	Category	x(8)
sodctg_desc	SOD Category Description	Description	x(24)
sodctg_mod_date	Modified Date	Mod Date	99/99/99
sodctg_mod_userid	User ID		x(8)
sodctg_user1	User Field Character 1		x(24)
sodctg_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sodctg_mstr	yes	oid_sodctg_mstr	yes	no
∗	sodctg_category	yes	sodctg_category	yes	no


Field Name	Label	Col-Label	Format	Dec
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SODException_ID	record ID		-99999999999
SODExceptionCode	Exception Code		x(20)
SODExceptionDescription	Exception Description		x(2000)
Usr_ID	link to User		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	Code	yes	SODExceptionCode	yes	no
∗	prim	yes	SODException_ID	yes	no
	Usr	no	Usr_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
Company_ID	link to Entity		-99999999999
Domain_ID	link to Domain		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SODCategory1_ID	link to SOD Category 1		-99999999999
SODCategory2_ID	link to SOD Category 2		-99999999999
SODException_ID	link to parent		-99999999999
SODExceptionLn_ID	record ID		-99999999999
SODExceptionLnDescription	Description		x(2000)


	Index-Name	Uni	Field-Name	Asc	Abbr
	CY	no	Company_ID	yes	no
	DMN	no	Domain_ID	yes	no
	parent	no	SODException_ID	yes	no
∗	prim	yes	SODExceptionLn_ID	yes	no
	SODC1	no	SODCategory1_ID	yes	no
	SODC2	no	SODCategory2_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SODCategory1_ID	link to SOD Category 1		-99999999999
SODCategory2_ID	link to SOD Category 2		-99999999999
SODExclusionDescription	Description		x(2000)
SODExclusionLevel	Exclusion Level	Excl Level	x(1)


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	prim	yes	SODCategory1_ID	yes	no
			SODCategory2_ID	yes	no
	SODC2	no	SODCategory2_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sodlc_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sodlc__qadc01			x(24)
sodlc__qadc02			x(24)
sodlc_abs_shipfrom	Ship From		x(8)
sodlc_acct	Trailer Acct	Account	x(8)
sodlc_cc	Trailer CC	CC	x(4)
sodlc_charge_type	Charge Type	Charge!Type	x(8)
sodlc_domain	Domain		x(8)
sodlc_ext_price	Extended Charge		->>>>,>>>,>>9.99<<<	10
sodlc_lc_amt	Charge		->>>>,>>>,>>9.99<<<	10
sodlc_lc_line	Charge Line	Ln	>>9
sodlc_mod_date	Modified Date	Mod Date	99/99/99
sodlc_mod_userid	User ID		x(8)
sodlc_one_time	One Time Charge	OTC	yes/no
sodlc_ord_line	SO Line	SO!Line	>>9
sodlc_order	Sales Order		x(8)
sodlc_owned_by	Id		x(20)
sodlc_project	Project		x(8)
sodlc_ref	Reference		x(24)
sodlc_sub	Trailer Sub-Acct	Sub-Acct	x(8)
sodlc_taxable	Taxable		yes/no
sodlc_taxc	Tax Class	TxC	x(3)
sodlc_times_charged	Times Charged		->,>>>,>>9
sodlc_trl_code	Trailer Code	Code	x(2)
sodlc_userc01	User Field Character 1		x(24)
sodlc_userc02	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sodlc_det	yes	oid_sodlc_det	yes	no
∗	sodlc_order	yes	sodlc_domain	yes	no
			sodlc_order	yes	no
			sodlc_ord_line	yes	no
			sodlc_lc_line	yes	no
	sodlc_owned_by	no	sodlc_domain	yes	no
			sodlc_owned_by	yes	no
			sodlc_abs_shipfrom	yes	no
	sodlc_trl_code	no	sodlc_domain	yes	no
			sodlc_trl_code	yes	no
			sodlc_order	yes	no
			sodlc_ord_line	yes	no


Field Name	Label	Col-Label	Format	Dec
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SODLog_ID	record ID		-99999999999
SODLogCategory1Code	SOD Category 1		x(20)
SODLogCategory2Code	SOD Category 2		x(20)
SODLogCompanyCode	Entity		x(20)
SODLogDateTime	Time Stamp of Creation		x(40)
SODLogDomainCode	Domain		x(8)
SODLogExclusionLevel	Exclusion Level	Excl Level	x(1)
SODLogModifyingUsrLogin	Modifying User		x(20)
SODLogResource1URI	Resource 1 URI		x(256)
SODLogResource2URI	Resource 2 URI		x(256)
SODLogRole1Name	Role 1		x(20)
SODLogRole2Name	Role 2		x(20)
SODLogRule	SOD rule (1 or 2)		x(5)
SODLogStatus	Status		x(10)
SODLogUsrLogin	User		x(20)


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	prim	yes	SODLog_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sodm_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sodm__qadc01			x(24)
sodm__qadc02			x(24)
sodm_category1	SOD Category Code	Category	x(8)
sodm_category2	SOD Category Code	Category	x(8)
sodm_mod_date	Modified Date	Mod Date	99/99/99
sodm_mod_userid	User ID		x(8)
sodm_user1	User Field Character 1		x(24)
sodm_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sodm_det	yes	oid_sodm_det	yes	no
∗	sodm_ctg_pair	yes	sodm_category1	yes	no
			sodm_category2	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sodpe_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_sodped_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sodped__qadc01			x(24)
sodped__qadc02			x(24)
sodped_company	Entity		x(20)
sodped_domain	Domain		x(8)
sodped_group1	Role Name		x(20)
sodped_group2	Role Name		x(20)
sodped_mod_date	Modified Date	Mod Date	99/99/99
sodped_mod_userid	User ID		x(8)
sodped_user1	User Field Character 1		x(24)
sodped_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sodped_det	yes	oid_sodped_det	yes	no
∗	sodped_oid_sodpe	yes	oid_sodpe_mstr	yes	no
			sodped_group1	yes	no
			sodped_group2	yes	no
			sodped_domain	yes	no
			sodped_company	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sodpe_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sodpe__qadc01			x(24)
sodpe__qadc02			x(24)
sodpe_approver	Approver		x(32)
sodpe_code	SOD Policy Exception Code	Exception	x(8)
sodpe_desc	Description		x(60)
sodpe_mod_date	Modified Date	Mod Date	99/99/99
sodpe_mod_userid	User ID		x(8)
sodpe_title	Title		x(50)
sodpe_user1	User Field Character 1		x(24)
sodpe_user2	User Field Character 2		x(24)
sodpe_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sodpe_mstr	yes	oid_sodpe_mstr	yes	no
∗	sodpe_code	yes	sodpe_code	yes	no
	sodpe_userid	no	sodpe_userid	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sodrc_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sodrc__qadc01			x(24)
sodrc__qadc02			x(24)
sodrc_domain	Domain		x(8)
sodrc_line	RSS Line		>>9
sodrc_master_line	Master Line		>>9
sodrc_master_nbr	Master Order		x(8)
sodrc_mod_date	Modified Date		99/99/99
sodrc_mod_userid	User ID		x(8)
sodrc_nbr	RSS Order		x(8)
sodrc_sequence	Sequence		>>9
sodrc_user1	User Field Character 1		x(24)
sodrc_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sodrc_det	yes	oid_sodrc_det	yes	no
∗	sodrc_det	yes	sodrc_domain	yes	no
			sodrc_master_nbr	yes	no
			sodrc_master_line	yes	no
			sodrc_nbr	yes	no
			sodrc_line	yes	no
	sodrc_sequence	yes	sodrc_domain	yes	no
			sodrc_sequence	yes	no
			sodrc_master_nbr	yes	no
			sodrc_master_line	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sodr_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sodr__qadc01			x(8)
sodr__qadc02			x(8)
sodr__qadc03			x(8)
sodr__qadd01			->>>>,>>>,>>9.9	10
sodr__qadd02			->>>>,>>>,>>9.9	10
sodr__qadi01			->,>>>,>>9
sodr__qadi02			->,>>>,>>9
sodr__qadl01			yes/no
sodr__qadl02			yes/no
sodr__qadt01			99/99/99
sodr__qadt02			99/99/99
sodr_div	Division		X(8)
sodr_domain	Domain		x(8)
sodr_group	Group		X(8)
sodr_line	Line		>>9
sodr_nbr	Sales Order		X(8)
sodr_pricing	Pricing		>9
sodr_seq	Sequence		>>9
sodr_type	Type		>>>9
sodr_user1	Ufld1		x(8)
sodr_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sodr_det	yes	oid_sodr_det	yes	no
∗	sodr_nbrln_seq	yes	sodr_domain	yes	no
			sodr_nbr	yes	no
			sodr_line	yes	no
			sodr_seq	yes	no
	sodr_type	no	sodr_domain	yes	no
			sodr_type	yes	no


Field Name	Label	Col-Label	Format	Dec
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Role_ID	link to Role		-99999999999
SODCategory1_ID	link to SOD Category 1		-99999999999
SODCategory2_ID	link to SOD Category 2		-99999999999
SODViolation1_ID	record ID		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	iRole	no	Role_ID	yes	no
∗	prim	yes	SODViolation1_ID	yes	no
	SODC1	no	SODCategory1_ID	yes	no
	SODC2	no	SODCategory2_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Resource_ID	link to Resource		-99999999999
SODViolation1_ID	link to parent		-99999999999
SODViolation1R_ID	record ID		-99999999999
SODViolation1RCategory	Category nbr (1 or 2)		9


	Index-Name	Uni	Field-Name	Asc	Abbr
	parent	no	SODViolation1_ID	yes	no
∗	prim	yes	SODViolation1R_ID	yes	no
	rsrc	no	Resource_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
Company_ID	link to Entity		-99999999999
Domain_ID	link to Domain		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Role1_ID	link to Role 1		-99999999999
Role2_ID	link to Role 2		-99999999999
SODCategory1_ID	link to SOD Category 1		-99999999999
SODCategory2_ID	link to SOD Category 2		-99999999999
SODViolation2_ID	record ID		-99999999999
Usr_ID	link to User		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	CY	no	Company_ID	yes	no
	DMN	no	Domain_ID	yes	no
∗	prim	yes	SODViolation2_ID	yes	no
	Role1	no	Role1_ID	yes	no
	Role2	no	Role2_ID	yes	no
	SODC1	no	SODCategory1_ID	yes	no
	SODC2	no	SODCategory2_ID	yes	no
	Usr	no	Usr_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Resource_ID	link to Resource		-99999999999
SODViolation2_ID	link to parent		-99999999999
SODViolation2R_ID	record ID		-99999999999
SODViolation2RCategory	Category nbr (1 or 2)		9


	Index-Name	Uni	Field-Name	Asc	Abbr
	parent	no	SODViolation2_ID	yes	no
∗	prim	yes	SODViolation2R_ID	yes	no
	rsrc	no	Resource_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sodv_hist			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sodv__qadc01			x(24)
sodv__qadc02			x(24)
sodv_category1	SOD Category Code	Category	x(8)
sodv_category2	SOD Category Code	Category	x(8)
sodv_date	Created Date	Created	99/99/99
sodv_fix_date	Fixed Date		99/99/99
sodv_fix_time	Fixed Time	Time	>>>>9
sodv_fix_userid	Fixed By		x(8)
sodv_group	Role Name		x(20)
sodv_group1	Role Name		x(20)
sodv_group1_conflict	Role 1 Conflict	Role 1	yes/no
sodv_group2	Role Name		x(20)
sodv_group2_conflict	Role 2 Conflict	Role 2	yes/no
sodv_mod_date	Modified Date	Mod Date	99/99/99
sodv_mod_userid	User ID		x(8)
sodv_pe_code	SOD Policy Exception Code		x(35)
sodv_rule_type	SOD Rule Type	Type	x(2)
sodv_time	Time		>>,>>>,>>9
sodv_user	User ID		x(8)
sodv_user1	User Field Character 1		x(24)
sodv_user2	User Field Character 2		x(24)
sodv_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sodv_hist	yes	oid_sodv_hist	yes	no
∗	sodv_vio_id	yes	sodv_rule_type	yes	no
			sodv_user	yes	no
			sodv_group	yes	no
			sodv_category1	yes	no
			sodv_category2	yes	no
			sodv_group1	yes	no
			sodv_group2	yes	no
			sodv_userid	yes	no
			sodv_date	yes	no
			sodv_time	yes	no
			sodv_fix_userid	yes	no
			sodv_fix_date	yes	no
			sodv_fix_time	yes	no