pjc_ctrl


Field Name	Label	Col-Label	Format	Dec
oid_pjc_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pjc__log01			yes/no
pjc__log02			yes/no
pjc__qadc01			x(24)
pjc__qadc02			x(24)
pjc__qadd01			->>>>,>>>,>>9.99<<<	10
pjc__qadi01			>>>>>>>9
pjc__qadi02			->>>>>>>9
pjc__qadl01			yes/no
pjc__qadl02			yes/no
pjc__qadt01			99/99/99
pjc_auto_mo	Auto Generate MO		yes/no
pjc_bg_above	Budget Overrun Limit		->>9.9<%	10
pjc_bg_below	Budget Warning Limit		->>9.9<%	10
pjc_close_status	Closed Status		x(8)
pjc_comp_status	Complete Status		x(8)
pjc_dflt_que	Queue		x(8)
pjc_domain	Domain		x(8)
pjc_global_inv	Global Invoicing		yes/no
pjc_hcmmts	Project Header Comments		yes/no
pjc_hold_level	Credit Hold Option		>>9
pjc_hold_status	Hold Status		x(8)
pjc_lcmmts	Project Line Comments		yes/no
pjc_mod_date	Modified Date	Mod Date	99/99/99
pjc_mod_userid	User ID		x(8)
pjc_open_status	Open Status		x(8)
pjc_pao_cancel	Cancel Status		x(8)
pjc_pao_close	Closed Status		x(8)
pjc_pao_complete	Complete Status		x(8)
pjc_pao_hold	Hold Status		x(8)
pjc_pao_nbr	Next PAO		>>>>>>>9
pjc_pao_open	Open Status		x(8)
pjc_pao_pre	PAO Prefix		x(3)
pjc_paocmmts	PAO Comments		yes/no
pjc_par_detail	PAR Detail		yes/no
pjc_par_labor_st	PAR Labor Start		Worksheet/PAO
pjc_par_return	PAR Return Status		x(8)
pjc_par_scrap	PAR Scrap Status		x(8)
pjc_pj_type	GL Project Type		x(2)
pjc_pjs_hist	Generate Transaction History		yes/no
pjc_pr_rollup	Auto Price Rollup		yes/no
pjc_prj_nbr	Next Project		>>>>>>>9
pjc_prj_pre	Project Prefix		x(3)
pjc_prj_site	Project Site		x(8)
pjc_ps_in_wip	Book Project Inventory to WIP		yes/no
pjc_pt_prod	Use Item Product Line		yes/no
pjc_schedule_pao	Schedule		yes/no
pjc_scmmts	Subproject Comments		yes/no
pjc_so_nbr	Next Project SO		>>>>>>>9
pjc_so_pre	Project SO Prefix		x(3)
pjc_sub_det	Subproject Details		yes/no
pjc_use_budgets	Use Budgets		yes/no
pjc_use_pay_rate	Use Employee Pay Rate		yes/no
pjc_user1	Ufld1		x(8)
pjc_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pjc_ctrl	yes	oid_pjc_ctrl	yes	no
∗	pjc_index1	yes	pjc_domain	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pjd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pjd__qadc01			x(24)
pjd__qadc02			x(24)
pjd__qadd01			->>>>,>>>,>>9.99<<<	10
pjd__qadi01			>>>>>>>9
pjd__qadl01			yes/no
pjd__qadt01			99/99/99
pjd_budget_type	Budget Type		>>9
pjd_ca_int_type	Work Code		x(8)
pjd_cmtindx	Comment Index		>>>>>>>9
pjd_comm_pct[4]	Commission		>>9.9<%	10
pjd_cr_terms	Credit Terms		x(8)
pjd_desc	Description		x(24)
pjd_disc_pct	Discount		->>9.9<%	10
pjd_domain	Domain		x(8)
pjd_end_date	End Date		99/99/99
pjd_end_orig	Original End		99/99/99
pjd_eng_nbr	Engineer		x(8)
pjd_eu_nbr	End User		x(8)
pjd_global_inv	Global Invoicing		yes/no
pjd_inv_det	Details on Invoice		yes/no
pjd_inv_det_pr	Prices of Details		yes/no
pjd_inv_lvl	Invoice Level		yes/no
pjd_list_pr	Total List Price		->>>>,>>>,>>9.99<<<	10
pjd_loc	Location		x(8)
pjd_mod_date	Modified Date	Mod Date	99/99/99
pjd_mod_userid	User ID		x(8)
pjd_nbr	Project		x(8)
pjd_pjt_code	Project Type		x(8)
pjd_pr_list	Price List		x(8)
pjd_prep_tax	Prepaid Tax		->>>>,>>>,>>9.99<<<	10
pjd_prepaid	Prepaid		->>>>,>>>,>>9.99<<<	10
pjd_prod_line	Product Line		x(4)
pjd_site	Site		x(8)
pjd_slspsn[4]	Slsperson		x(8)
pjd_st_date	Start Date		99/99/99
pjd_st_orig	Original Start		99/99/99
pjd_status	Status		x(8)
pjd_sub_nbr	Subproject	Subproj	>>>9
pjd_total_price	Total Net Price		->>>>,>>>,>>9.99<<<	10
pjd_user1	Ufld1		x(8)
pjd_user2	Ufld2		x(8)
pjd_variation	Variation		yes/no


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pjd_det	yes	oid_pjd_det	yes	no
	pjd_pjt_code	no	pjd_domain	yes	no
			pjd_pjt_code	yes	no
∗	pjd_sub_nbr	yes	pjd_domain	yes	no
			pjd_nbr	yes	no
			pjd_sub_nbr	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pjsh_hist			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pjsh__qadc01			x(24)
pjsh__qadd01			->>>>,>>>,>>9.99<<<	10
pjsh__qadi01			>>>>>>>9
pjsh__qadl01			yes/no
pjsh__qadt01			99/99/99
pjsh_amt_inv	Invoiced Amount		->>>>,>>>,>>9.99<<<	10
pjsh_amt_inv_chg	Invoiced Amt Change		->>>>,>>>,>>9.99<	10
pjsh_cost_act_chg	Actual Cost Change		->>>>,>>>,>>9.99<<<	10
pjsh_cost_actual	Actual Cost		->>>>,>>>,>>9.99<<<	10
pjsh_cost_iss	Issued Cost		->>>>,>>>,>>9.99<<<	10
pjsh_cost_iss_chg	Issued Cost Change		->>>>,>>>,>>9.99<<<	10
pjsh_cost_planned	Planned Cost		->>>>,>>>,>>9.99<<<	10
pjsh_cost_pln_chg	Planned Cost Change		->>>>,>>>,>>9.99<<<	10
pjsh_cost_wip	WIP Cost		->>>>,>>>,>>9.99<<<	10
pjsh_cost_wip_chg	WIP Cost Change		->>>>,>>>,>>9.99<<<	10
pjsh_domain	Domain		x(8)
pjsh_mod_date	Modified Date	Mod Date	99/99/99
pjsh_mod_userid	User ID		x(8)
pjsh_nbr	Project		x(8)
pjsh_old_status	Prev Line Status		x(8)
pjsh_pjs_line	Project Line		>>>>>>>9
pjsh_povar_amt	PO Variance Amt		->>>>,>>>,>>9.99<<<	10
pjsh_povar_chg	PO Variance Change		->>>>,>>>,>>9.99<<<	10
pjsh_qty_act_chg	Qty Actual Change		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_actual	Qty Actual		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_bg_chg	Qty Budgeted Change		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_budget	Qty Budgeted		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_inv	Qty Invoiced		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_inv_chg	Qty Invoiced Change		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_iss	Qty Issued		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_iss_chg	Qty Issued Change		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_oh	Project QOH		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_oh_chg	Project QOH Change		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_planned	Qty Planned		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_pln_chg	Qty Planned Change		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_sel_chg	Qty to Invoice Change		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_sel_inv	Qty to Invoice		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_wip	Qty WIP		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_qty_wip_chg	Qty WIP Change		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_rel_nbr	Related Project		x(8)
pjsh_status	Project Line Status		x(8)
pjsh_tr_cost	Transaction Cost		->>>>,>>>,>>9.99<<<	10
pjsh_tr_date	Transaction Date		99/99/99
pjsh_tr_ind	Transaction Indicator		x(8)
pjsh_tr_qty	Transaction Qty		->>,>>>,>>9.9<<<<<<<<<	10
pjsh_tr_time	Transaction Time		>>>>>>>>9
pjsh_tr_type	Transaction Type		x(8)
pjsh_trnbr	Transaction		>>>>>>>9
pjsh_user1	Ufld1		x(8)
pjsh_user2	Ufld2		x(8)
pjsh_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pjsh_hist	yes	oid_pjsh_hist	yes	no
	pjsh_prj_nbr	no	pjsh_domain	yes	no
			pjsh_nbr	yes	no
			pjsh_pjs_line	yes	no
			pjsh_tr_date	yes	no
			pjsh_tr_time	yes	no
∗	pjsh_trnbr	yes	pjsh_domain	yes	no
			pjsh_trnbr	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pjsx_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pjsx__dec01			->>>>,>>>,>>9.99<<<	10
pjsx__dte01			99/99/99
pjsx__log01			yes/no
pjsx__qadc01			x(24)
pjsx__qadc02			x(24)
pjsx__qadd01			->>>>,>>>,>>9.99<<<	10
pjsx__qadi01			>>>>>>>9
pjsx__qadl01			yes/no
pjsx__qadt01			99/99/99
pjsx_date	Last Modified Date		99/99/99
pjsx_def_ws	Worksheet		x(8)
pjsx_domain	Domain		x(8)
pjsx_end_date	End Date		99/99/99
pjsx_int_stat	Internal Status		x(8)
pjsx_line	PAO Line		>>9
pjsx_loc	Location		x(8)
pjsx_mod_date	Modified Date	Mod Date	99/99/99
pjsx_mod_userid	User ID		x(8)
pjsx_nbr	PAO		x(8)
pjsx_pjs_line	Project Line		>>>>>>>9
pjsx_prj_nbr	Project		x(8)
pjsx_qty_demand	Demand Qty		->>,>>>,>>9.9<<<<<<<<<	10
pjsx_qty_in_prog	Qty In Progress		->>,>>>,>>9.9<<<<<<<<<	10
pjsx_qty_iss	Qty Issued		->>,>>>,>>9.9<<<<<<<<<	10
pjsx_qty_ord	Qty Ordered		->>,>>>,>>9.9<<<<<<<<<	10
pjsx_site	Site		x(8)
pjsx_so_nbr	Material Order		x(8)
pjsx_sod_line	MO Line		>>9
pjsx_start_date	Start Date		99/99/99
pjsx_type	PAO Line Type		x(4)
pjsx_user1	Ufld1		x(8)
pjsx_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pjsx_det	yes	oid_pjsx_det	yes	no
∗	pjsx_nbrln	yes	pjsx_domain	yes	no
			pjsx_nbr	yes	no
			pjsx_line	yes	no
	pjsx_pjs	no	pjsx_domain	yes	no
			pjsx_prj_nbr	yes	no
			pjsx_pjs_line	yes	no
			pjsx_nbr	yes	no
	pjsx_sonbr	no	pjsx_domain	yes	no
			pjsx_so_nbr	yes	no
			pjsx_sod_line	yes	no
	pjsx_type	no	pjsx_domain	yes	no
			pjsx_prj_nbr	yes	no
			pjsx_pjs_line	yes	no
			pjsx_type	yes	no
	pjsx_ws	no	pjsx_domain	yes	no
			pjsx_def_ws	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pjs_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pjs__chr01			x(8)
pjs__dec01			->>>>,>>>,>>9.99<<<	10
pjs__dec02			->>>>,>>>,>>9.99<<<	10
pjs__dte01			99/99/99
pjs__dte02			99/99/99
pjs__log01			yes/no
pjs__log02			yes/no
pjs__qadc01			x(24)
pjs__qadc02			x(24)
pjs__qadc03			x(24)
pjs__qadd01			->>>>,>>>,>>9.99<<<	10
pjs__qadd02			->>>>,>>>,>>9.99<<<	10
pjs__qadi01			>>>>>>>9
pjs__qadi02			>>>>>>>9
pjs__qadl01			yes/no
pjs__qadl02			yes/no
pjs__qadt01			99/99/99
pjs__qadt02			99/99/99
pjs_amt_inv	Amount Invoiced	Amt Inv	->>>>,>>>,>>9.99<<<	10
pjs_budget_type	Budget Type		>9
pjs_ca_int_type	Work Code		x(8)
pjs_cmtindx	Comment Index		>>>>>>>9
pjs_completed	Completed		yes/no
pjs_cost	Unit Cost		->>>>,>>>,>>9.99<<<	10
pjs_cost_actual	Actual Cost		->>>>,>>>,>>9.99<<<	10
pjs_cost_iss	Issued Cost		->>>>,>>>,>>9.99<<<	10
pjs_cost_wip	WIP Cost		->>>>,>>>,>>9.99<<<	10
pjs_desc	Description		x(24)
pjs_detail_on_inv	Detail on Invoice		yes/no
pjs_disc_pct	Discount		->>9.9<%	10
pjs_domain	Domain		x(8)
pjs_frozen	Frozen		yes/no
pjs_fsc_code	Category		x(8)
pjs_inv_group	Invoice Group		x(8)
pjs_inv_lvl	Invoice Level		yes/no
pjs_line	Project Line		>>>>>>>9
pjs_line_disp	Project Line ID		x(12)
pjs_line_par	Parent Line		>>>>>>>9
pjs_line_seq	Project Line Seq		>>>9
pjs_line_sort	Project Line Sort		x(24)
pjs_link_ok	Link to PAO		yes/no
pjs_list_pr	List Price		->>>>,>>>,>>9.99<<<	10
pjs_mod_date	Modified Date	Mod Date	99/99/99
pjs_mod_userid	User ID		x(8)
pjs_nbr	Project		x(8)
pjs_part	Item Number		x(18)
pjs_povar_amt	PO Variance Amount		->>>>,>>>,>>9.99<<<	10
pjs_price	Net Price		->>>>,>>>,>>9.99<<<	10
pjs_price_on_inv	Price on Invoice		yes/no
pjs_prod_line	Product Line		x(4)
pjs_qty_actual	Qty Actual		->>,>>>,>>9.9<<<<<<<<<	10
pjs_qty_budget	Qty Budgeted		->>,>>>,>>9.9<<<<<<<<<	10
pjs_qty_inv	Qty Invoiced		->>,>>>,>>9.9<<<<<<<<<	10
pjs_qty_iss	Qty Issued		->>,>>>,>>9.9<<<<<<<<<	10
pjs_qty_oh	Project QOH		->>,>>>,>>9.9<<<<<<<<<	10
pjs_qty_planned	Qty Planned		->>,>>>,>>9.9<<<<<<<<<	10
pjs_qty_sel_inv	Qty to Invoice		->>,>>>,>>9.9<<<<<<<<<	10
pjs_qty_wip	Qty WIP		->>,>>>,>>9.9<<<<<<<<<	10
pjs_status	Status		x(8)
pjs_sub_nbr	Subproject		>>>9
pjs_subassy	Subassembly		yes/no
pjs_um	UM		x(2)
pjs_um_conv	UM Conversion		>>>>9.9999<<<<	10
pjs_user1	Ufld1		x(8)
pjs_user2	Ufld2		x(8)
pjs_variation	Variation		yes/no


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pjs_mstr	yes	oid_pjs_mstr	yes	no
∗	pjs_line	yes	pjs_domain	yes	no
			pjs_nbr	yes	no
			pjs_line	yes	no
	pjs_status	no	pjs_domain	yes	no
			pjs_nbr	yes	no
			pjs_status	yes	no
			pjs_link_ok	yes	no
	pjs_structure	no	pjs_domain	yes	no
			pjs_nbr	yes	no
			pjs_sub_nbr	yes	no
			pjs_line_par	yes	no
			pjs_line_seq	yes	no
	pjs_tree	no	pjs_domain	yes	no
			pjs_nbr	yes	no
			pjs_line_sort	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pjt_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pjt__qadc01			x(24)
pjt__qadd01			->>>>,>>>,>>9.99<<<	10
pjt__qadi01			>>>>>>>9
pjt__qadl01			yes/no
pjt__qadt01			99/99/99
pjt_ca_int_type	Work Code		x(8)
pjt_cmtindx	Comment Index		>>>>>>>9
pjt_code	Project Type		x(8)
pjt_desc	Description		x(24)
pjt_domain	Domain		x(8)
pjt_mod_date	Modified Date	Mod Date	99/99/99
pjt_mod_userid	User ID		x(8)
pjt_pr_list	Price List		x(8)
pjt_priority	Priority		>>>9
pjt_prod_line	Product Line		x(4)
pjt_taxable	Taxable		yes/no
pjt_taxc	Tax Class		x(3)
pjt_user1	Ufld1		x(8)
pjt_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pjt_mstr	yes	oid_pjt_mstr	yes	no
∗	pjt_code	yes	pjt_domain	yes	no
			pjt_code	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pj_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pj__qadc01			x(8)
pj_active	Active	Act	yes/no
pj_beg_dt	Begin Date	Beg Date	99/99/99
pj_cmtindx	Comment Index	Cmmt Indx	>>>>>>>9
pj_comp	Actual Completion Date	Comp Dt	99/99/99
pj_desc	Description		x(24)
pj_domain	Domain		x(8)
pj_findate	Original Completion Date	Org C Dt	99/99/99
pj_project	Project		x(8)
pj_revdate	Date Revised	Date Rev	99/99/99
pj_revfin	Revised Completion Date	Rev C Dt	99/99/99
pj_stat	Status Code	S	x(1)
pj_type	Project Type	T	x(2)
pj_user1	Ufld1		x(8)
pj_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pj_mstr	yes	oid_pj_mstr	yes	no
	pj_active	no	pj_domain	yes	no
			pj_project	yes	no
			pj_active	yes	no
	pj_desc	no	pj_domain	yes	no
			pj_desc	yes	no
			pj_project	yes	no
∗	pj_project	yes	pj_domain	yes	no
			pj_project	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pk_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pk__qadc01			x(8)
pk_domain	Domain		x(8)
pk_end	End		99/99/99
pk_loc	Location		x(8)
pk_lot	ID		x(8)
pk_part	Item Number		x(18)
pk_qty	Qty		->,>>>,>>9.9<<<<<<<<	10
pk_reference	Reference	Ref	x(8)
pk_start	Start		99/99/99
pk_user			x(50)
pk_user1	Ufld1		x(8)
pk_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pk_det	yes	oid_pk_det	yes	no
∗	pk_det	yes	pk_domain	yes	no
			pk_user	yes	no
			pk_part	yes	no
			pk_reference	yes	no
			pk_start	yes	no
			pk_end	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pld_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pld__qadc01			x(8)
pld_cchg_acc	Cost Revalue Acct	Revalue	x(8)
pld_cchg_cc	Inv Cost Change Cost Ctr	CC	x(4)
pld_cchg_sub	Cost Revalue Sub-Acct	Sub-Acct	x(8)
pld_domain	Domain		x(8)
pld_dscr_cc	Inv Discrep Cost Ctr	CC	x(4)
pld_dscr_sub	Inv Discrep Sub-Acct	Sub-Acct	x(8)
pld_dscracct	Inv Discrep Acct	Discrep	x(8)
pld_inv_acct	Inventory Acct	Inventory	x(8)
pld_inv_cc	Inventory Cost Ctr	CC	x(4)
pld_inv_sub	Inventory Sub-Acct	Sub-Acct	x(8)
pld_loc	Location		x(8)
pld_mod_date	Modified Date	Mod Date	99/99/99
pld_prodline	Product Line	Line	x(4)
pld_scrp_cc	Scrap Cost Ctr	CC	x(4)
pld_scrp_sub	Scrap Sub-Acct	Sub-Acct	x(8)
pld_scrpacct	Scrap Acct	Scrap	x(8)
pld_site	Site		x(8)
pld_user1	Ufld1		x(8)
pld_user2	Ufld2		x(8)
pld_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pld_det	yes	oid_pld_det	yes	no
∗	pld_det	yes	pld_domain	yes	no
			pld_prodline	yes	no
			pld_site	yes	no
			pld_loc	yes	no
	pld_site	yes	pld_domain	yes	no
			pld_site	yes	no
			pld_loc	yes	no
			pld_prodline	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pliabs_ref			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pliabs__qadc01	QAD Character Field 1		x(24)
pliabs__qadc02	QAD Character Field 2		x(24)
pliabs_abs_id	Shipper ID		x(20)
pliabs_domain	Domain		x(8)
pliabs_mod_date	Modified Date	Mod Date	99/99/99
pliabs_mod_userid	User ID		x(8)
pliabs_pli_keyid	Key ID		>>>>>>>>>
pliabs_supplier	Supplier		x(8)
pliabs_user1	User Field Character 1		x(24)
pliabs_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pliabs_ref	yes	oid_pliabs_ref	yes	no
∗	pliabs_pli_keyid	yes	pliabs_domain	yes	no
			pliabs_pli_keyid	yes	no
	pliabs_supplier	no	pliabs_domain	yes	no
			pliabs_supplier	yes	no
			pliabs_abs_id	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_plid_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
plid__qadc01			x(24)
plid__qadc02			x(24)
plid_abs_id	Shipper ID	Shipper ID	x(20)
plid_cmtindx	Comment Index	Comment	>>>>>>>9
plid_domain	Domain		x(8)
plid_grosswgt	Gross Weight	Gross Wt	>,>>>,>>9.9<<<<<<<<	10
plid_inv_cost	Invoice Cost		->>>>,>>>,>>9.99<<<	10
plid_inv_qty	Invoice Quantity		->>,>>>,>>>,>>9.99<<<<<<<<<	10
plid_line	Line		>>>>>>>9
plid_mod_date	Modified Date	Mod Date	99/99/99
plid_mod_userid	User ID		x(8)
plid_netwgt	Net Weight		>,>>>,>>9.9<<<<<<<<	10
plid_order	Order		x(8)
plid_order_line	Order Line	Ln	>>9
plid_order_type	Order Type	Order!Type	x(2)
plid_pli_keyid	Invoice Key ID	Invoice!Key ID	>>>>>>>>>
plid_pvo_id	Pending Voucher ID	Pend Vchr	>>>>>>>>>
plid_tax_env	Tax Environment	Tax Env	x(16)
plid_tax_in	Tax In	Tax!In	yes/no
plid_tax_usage	Tax Usage	Tax!Usage	x(8)
plid_taxable	Taxable	Tax	yes/no
plid_taxc	Tax Class	Tax!Class	x(3)
plid_user1	User Field Character 1		x(24)
plid_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_plid_det	yes	oid_plid_det	yes	no
	plid_order	no	plid_domain	yes	no
			plid_order	yes	no
			plid_order_line	yes	no
∗	plid_pli_keyid	yes	plid_domain	yes	no
			plid_pli_keyid	yes	no
			plid_line	yes	no
	plid_pli_keyid_order	no	plid_domain	yes	no
			plid_pli_keyid	yes	no
			plid_order	yes	no
			plid_order_line	yes	no
	plid_pvo_id	no	plid_domain	yes	no
			plid_pvo_id	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pli_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pli__qadc01			x(24)
pli__qadc02			x(24)
pli__qadc03			x(24)
pli__qadc04			x(24)
pli_cinvoice_id	Invoice ID		-99999999999
pli_cr_terms	Credit Terms		x(8)
pli_curr	Currency	Cur	x(3)
pli_discamt	Discount Amount	Disc Amt	->>>>,>>>,>>9.99<	10
pli_docmodel	Document Model		x(3)
pli_domain	Domain		x(8)
pli_ex_rate	Exch Rate		->>>>,>>>,>>9.9<<<<<<<<<	10
pli_ex_rate2	Exch Rate 2		->>>>,>>>,>>9.9<<<<<<<<<	10
pli_ex_ratetype	Rate Type		x(8)
pli_exru_seq	Sequence		>>>>>>>>9
pli_fix_rate	Fixed Rate		yes/no
pli_goodsamt	Goods Amount		->>>>,>>>,>>9.99<	10
pli_invoice	Invoice Number		x(20)
pli_invoice_amt	Invoice Amount		->>,>>>,>>>,>>9.99<	10
pli_invoice_date	Invoice Date	Inv Date	99/99/99
pli_keyid	Key ID		>>>>>>>>>
pli_ldamt	Legal Doc Amount		->>>>,>>>,>>9.99<	10
pli_mod_date	Modified Date	Mod Date	99/99/99
pli_mod_userid	User ID		x(8)
pli_shipperid	Shipper ID		x(20)
pli_supplier	Supplier		x(8)
pli_tax_date	Tax Date		99/99/99
pli_tax_env	Tax Environment	Tax Env	x(16)
pli_tax_in	Tax In	Tax!In	yes/no
pli_tax_usage	Tax Usage	TaxUsage	x(8)
pli_taxable	Taxable	Tax	yes/no
pli_taxc	Tax Class	TxC	x(3)
pli_totwgt	Total Weight		>,>>>,>>9.9<<<<<<<<	10
pli_traileramt	Trailer Amount		->>>>,>>>,>>9.99<	10
pli_user1	User Field Character 1		x(24)
pli_user2	User Field Character 2		x(24)
pli_vo_ref	Voucher		x(22)
pli_vol_um	Volume UM	Vol UM	x(2)
pli_volume	Volume		>,>>>,>>9.9<<<<<<<<	10
pli_wt_um	Weight UM	UM	x(2)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pli_mstr	yes	oid_pli_mstr	yes	no
	pli_invoice	no	pli_domain	yes	no
			pli_supplier	yes	no
			pli_invoice	yes	no
∗	pli_keyid	yes	pli_domain	yes	no
			pli_keyid	yes	no
	pli_vo_ref	no	pli_domain	yes	no
			pli_vo_ref	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_plsd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
plsd__qadc01			x(8)
plsd_cbdn_acct	COGS Burden Acct	COGS-Bdn	x(8)
plsd_cbdn_cc	COGS Burden CC	CC	x(4)
plsd_cbdn_sub	COGS Burden Sub-Acct	Sub-Acct	x(8)
plsd_channel	Channel		x(8)
plsd_clbr_acct	COGS Labor Acct	COGS-Lbr	x(8)
plsd_clbr_cc	COGS Labor CC	CC	x(4)
plsd_clbr_sub	COGS Labor Sub-Acct	Sub-Acct	x(8)
plsd_cmtl_acct	COGS Material Acct	COGS-Mtl	x(8)
plsd_cmtl_cc	COGS Material CC	CC	x(4)
plsd_cmtl_sub	COGS Mtl Sub-Acct	Sub-Acct	x(8)
plsd_cmtype	Customer Type	Type	x(4)
plsd_covh_acct	COGS Overhead Acct	COGS-Ovh	x(8)
plsd_covh_cc	COGS Overhead CC	CC	x(4)
plsd_covh_sub	COGS Overhead Sub	Sub-Acct	x(8)
plsd_csub_acct	COGS Subcontract Acct	COGS-Sub	x(8)
plsd_csub_cc	COGS Subcontract CC	CC	x(4)
plsd_csub_sub	COGS Subcontract Sub	Sub-Acct	x(8)
plsd_domain	Domain		x(8)
plsd_dsc_acct	Sales Disc Acct	Disc Acct	x(8)
plsd_dsc_cc	Sales Disc Ctr	CC	x(4)
plsd_dsc_sub	Sales Disc Sub-Acct	Sub-Acct	x(8)
plsd_fsaccr_acct	Accrued Revenue	Accrued	x(8)
plsd_fsaccr_cc	Accrued Revenue CC		x(4)
plsd_fsaccr_sub	Accrued Revenue Sub-Acct		x(8)
plsd_fsdef_acct	Deferred Revenue	Deferred	x(8)
plsd_fsdef_cc	Deferred Revenue CC		x(4)
plsd_fsdef_sub	Deferred Revenue Sub-Acct		x(8)
plsd_mod_date	Modified Date	Mod Date	99/99/99
plsd_prodline	Product Line	Line	x(4)
plsd_site	Site		x(8)
plsd_sls_accr_acct	Self-Billing Sales Accrual Acct		x(8)
plsd_sls_accr_cc	Self-Billing Sales Accrual CC		x(4)
plsd_sls_accr_project	Self-Billing Sales Accrual Project		x(8)
plsd_sls_accr_sub	Self-Billing Sales Accrual Sub-Acct		x(8)
plsd_sls_acct	Sales Acct	Sales	x(8)
plsd_sls_cc	Sales Cost Ctr	CC	x(4)
plsd_sls_sub	Sales Sub-Acct	Sub-Acct	x(8)
plsd_user1	Ufld1		x(8)
plsd_user2	Ufld2		x(8)
plsd_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_plsd_det	yes	oid_plsd_det	yes	no
∗	plsd_prodline	yes	plsd_domain	yes	no
			plsd_prodline	yes	no
			plsd_site	yes	no
			plsd_cmtype	yes	no
			plsd_channel	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_plt_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
plt__qadc01			x(8)
plt_domain	Domain		x(8)
plt_mod_date	Modified Date	Mod Date	99/99/99
plt_prod_line	Product Line	Line	x(4)
plt_tax_type	Tax Type		x(3)
plt_taxable	Taxable		yes/no
plt_taxc	Tax Class	TxC	x(3)
plt_user1	User1		x(8)
plt_user2	User2		x(8)
plt_userid	User ID		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_plt_det	yes	oid_plt_det	yes	no
∗	plt_prod_line	yes	plt_domain	yes	no
			plt_prod_line	yes	no
			plt_tax_type	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pl_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pl__chr01			x(8)
pl__chr02			x(8)
pl__chr03			x(8)
pl__chr04			x(8)
pl__chr05			x(8)
pl__dec01			>>>,>>>,>>9.99	10
pl__dec02			>>>,>>>,>>9.99	10
pl__dte01			99/99/99
pl__dte02			99/99/99
pl__log01			yes/no
pl__qadc01	QAD Character Field 1		X(8)
pl__qadc02	QAD Character Field 2		X(8)
pl__qadc03	QAD Character Field 3		X(8)
pl__qadc04	QAD Character Field 4		X(8)
pl__qadc05	QAD Character Field 5		X(8)
pl__qadc06			x(8)
pl__qadc07			x(4)
pl__qadc08			x(8)
pl__qadc09			x(4)
pl__qadc10			x(8)
pl__qadc11			x(4)
pl__qadc12			x(8)
pl__qadc13			x(4)
pl__qadc14			x(8)
pl__qadc15			x(4)
pl__qadd01	QAD Decimal Field 1		->>,>>9.99	10
pl__qadl01	QAD Logical Field 1		yes/no
pl__qadt01	QAD Date Field 1		99/99/99
pl_apvr_acct	AP Rate Var Acct	AP Rate	x(8)
pl_apvr_cc	AP Rate Var Cost Ctr	CC	x(4)
pl_apvr_sub	AP Rate Var Sub-Acct	Sub-Acct	x(8)
pl_apvu_acct	AP Usage Var Acct	AP Usage	x(8)
pl_apvu_cc	AP Usage Var Cost Ctr	CC	x(4)
pl_apvu_sub	AP Usage Var Sub-Acct	Sub-Acct	x(8)
pl_cbdn_acct	COGS Burden Acct	COGS-Bdn	x(8)
pl_cbdn_cc	COGS Burden CC	CC	x(4)
pl_cbdn_sub	COGS Burden Sub-Acct	Sub-Acct	x(8)
pl_cchg_acct	Cost Revalue Acct	Revalue	x(8)
pl_cchg_cc	Cost Revalue Cost Ctr	CC	x(4)
pl_cchg_sub	Cost Revalue Sub-Acct	Sub-Acct	x(8)
pl_clbr_acct	COGS Labor Acct	COGS-Lbr	x(8)
pl_clbr_cc	COGS Labor CC	CC	x(4)
pl_clbr_sub	COGS Labor Sub-Acct	Sub-Acct	x(8)
pl_cmtl_acct	COGS Material Acct	COGS-Mtl	x(8)
pl_cmtl_cc	COGS Material CC	CC	x(4)
pl_cmtl_sub	COGS Mtl Sub-Acct	Sub-Acct	x(8)
pl_cog_acct	Cost of Goods Acct	COGS	x(8)
pl_cog_cc	COG Cost Ctr	CC	x(4)
pl_cog_sub	COGS Sub-Acct	Sub-Acct	x(8)
pl_cop_acct	Cost of Production	COP	x(8)
pl_cop_cc	Cost of Prod CC	CC	x(4)
pl_cop_sub	COP Sub-Acct	Sub-Acct	x(8)
pl_covh_acct	COGS Overhead Acct	COGS-Ovh	x(8)
pl_covh_cc	COGS Overhead CC	CC	x(4)
pl_covh_sub	COGS Overhead Sub	Sub-Acct	x(8)
pl_csub_acct	COGS Subcontract Acct	COGS-Sub	x(8)
pl_csub_cc	COGS Subcontract CC	CC	x(4)
pl_csub_sub	COGS Subcontract Sub	Sub-Acct	x(8)
pl_desc	Description		x(24)
pl_division			x(8)
pl_domain	Domain		x(8)
pl_dsc_acct	Sales Disc Acct	Disc Acct	x(8)
pl_dsc_cc	Sales Disc Ctr	CC	x(4)
pl_dsc_sub	Sales Disc Sub-Acct	Sub-Acct	x(8)
pl_dscr_acct	Inv Discrep Acct	Discrep	x(8)
pl_dscr_cc	Inv Discrep Cost Ctr	CC	x(4)
pl_dscr_sub	Inv Discrep Sub-Acct	Sub-Acct	x(8)
pl_esls_acct	Exempt Sales Acct		x(8)
pl_esls_cc	Exempt Sales Cost Ctr		x(4)
pl_fiscal_class	Fiscal Class		x(18)
pl_flr_acct	Floor Stock Account	Flr Acct	x(8)
pl_flr_cc	Floor Stock CC	CC	x(4)
pl_flr_sub	Floor Stock Sub-Acct	Sub-Acct	x(8)
pl_fsaccr_acct	Accrued Revenue	Accrued	x(8)
pl_fsaccr_cc	Accrued Revenue CC		x(4)
pl_fsaccr_sub	Accrued Revenue Sub-Acct		x(8)
pl_fsbdn_acct	Service Overhead	Ovh	x(8)
pl_fsbdn_cc	Service Overhead CC	CC	x(4)
pl_fsbdn_sub	Service Overhead Sub	Sub-Acct	x(8)
pl_fscm_inv_acct	Customer Inventory	Cus Inv	x(8)
pl_fscm_inv_cc	Customer Inventory CC	CC	x(4)
pl_fscm_inv_sub	Customer Inv Sub-Acct	Sub-Acct	x(8)
pl_fsdef_acct	Deferred Revenue	Deferred	x(8)
pl_fsdef_cc	Deferred Revenue CC		x(4)
pl_fsdef_sub	Deferred Revenue Sub-Acct		x(8)
pl_fsexd_acct	Expense Due Employee		x(8)
pl_fsexd_cc	Expenses Due CC	CC	x(4)
pl_fsexd_sub	Exp Due Employee Sub	Sub-Acct	x(8)
pl_fsexp_acct	Service Expense	Sv Exp	x(8)
pl_fsexp_cc	Service Expenses CC	CC	x(4)
pl_fsexp_sub	Service Exp Sub-Acct	Sub-Acct	x(8)
pl_fslbr_acct	Service Labor	Svc Lbr	x(8)
pl_fslbr_cc	Service Labor CC	CC	x(4)
pl_fslbr_sub	Service Labor Sub-Acct	Sub-Acct	x(8)
pl_fsrc_inv_acct	Repair Center Inv		x(8)
pl_fsrc_inv_cc	Repair Center CC	CC	x(4)
pl_fsrc_inv_sub	Repair Cent Inv Sub	Sub-Acct	x(8)
pl_group	Group		x(8)
pl_inv_acct	Inventory Acct	Inventory	x(8)
pl_inv_cc	Inventory Cost Ctr	CC	x(4)
pl_inv_sub	Inventory Sub-Acct	Sub-Acct	x(8)
pl_mod_date	Modified Date	Mod Date	99/99/99
pl_mvar_acct	Material Usage Var	Mtl Use	x(8)
pl_mvar_cc	Material Usage Variance CC	CC	x(4)
pl_mvar_sub	Mat Usage Var Sub	Sub-Acct	x(8)
pl_mvrr_acct	Material Rate Var	Mtl Rate	x(8)
pl_mvrr_cc	Material Rate Variance CC	CC	x(4)
pl_mvrr_sub	Mat Rate Var Sub	Sub-Acct	x(8)
pl_ovh_acct	Overhead Appl Acct	Overhead	x(8)
pl_ovh_cc	Overhead Appl CC	CC	x(4)
pl_ovh_sub	Overhead Appl Sub	Sub-Acct	x(8)
pl_ppv_acct	PO Price Var Acct	PO Var	x(8)
pl_ppv_cc	PO Price Var Cost Ctr	CC	x(4)
pl_ppv_sub	PO Price Var Sub	Sub-Acct	x(8)
pl_prod_line	Product Line	Line	x(4)
pl_pst	PST Taxed		yes/no
pl_pur_acct	Purchases Acct	Purchases	x(8)
pl_pur_cc	Purchases Cost Ctr	CC	x(4)
pl_pur_sub	Purchases Sub-Acct	Sub-Acct	x(8)
pl_rcpt_acct	PO Receipts Acct	PO Rct	x(8)
pl_rcpt_cc	PO Receipts Cost Ctr	CC	x(4)
pl_rcpt_sub	PO Receipts Sub-Acct	Sub-Acct	x(8)
pl_rmar_acct	Service Returns		x(8)	0
pl_rmar_cc	RMA Return CC	CC	x(4)
pl_rmar_sub	Service Returns Sub	Sub-Acct	x(8)
pl_scrp_acct	Scrap Acct	Scrap	x(8)
pl_scrp_cc	Scrap Cost Ctr	CC	x(4)
pl_scrp_sub	Scrap Sub-Acct	Sub-Acct	x(8)
pl_sls_acct	Sales Acct	Sales	x(8)
pl_sls_cc	Sales Cost Ctr	CC	x(4)
pl_sls_sub	Sales Sub-Acct	Sub-Acct	x(8)
pl_svar_acct	Subcontract Usage Var	Sub Use	x(8)
pl_svar_cc	Subcontract Usage Variance CC	CC	x(4)
pl_svar_sub	Sub Usage Var Sub-Acct	Sub-Acct	x(8)
pl_svrr_acct	Subcontract Rate Var	Sub Rate	x(8)
pl_svrr_cc	Subcontract Rate Variance CC	CC	x(4)
pl_svrr_sub	Sub Rate Var Sub-Acct	Sub-Acct	x(8)
pl_taxable	Taxable	Tax	yes/no
pl_taxc	Tax Class	TxC	x(3)
pl_user1	Ufld1		x(8)
pl_user2	Ufld2		x(8)
pl_userid	User ID		x(8)
pl_wip_acct	Work in Process Acct	WIP	x(8)
pl_wip_cc	WIP Cost Ctr	CC	x(4)
pl_wip_sub	WIP Sub-Acct	Sub-Acct	x(8)
pl_wvar_acct	Method Variance Acct	Mthd Var	x(8)
pl_wvar_cc	Method Variance CC	CC	x(4)
pl_wvar_sub	Method Var Sub-Acct	Sub-Acct	x(8)
pl_xfer_acct	Transfer Variance Account	Account	x(8)
pl_xfer_cc	Transfer Variance CC	CC	x(4)
pl_xfer_sub	Transfer Variance Sub	Sub-Acct	x(8)
pl_xvar_acct	Mix Var	Mix	x(8)
pl_xvar_cc	Mix Var CC	CC	x(4)
pl_xvar_sub	Mix Var Sub-Acct	Sub-Acct	x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pl_mstr	yes	oid_pl_mstr	yes	no
	pl_desc	yes	pl_domain	yes	no
			pl_desc	yes	no
			pl_prod_line	yes	no
∗	pl_prod_line	yes	pl_domain	yes	no
			pl_prod_line	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_poa_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_poad_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
poad__qadc01	QAD Character Field 1		x(24)
poad__qadc02	QAD Character Field 2		x(24)
poad_domain	Domain		x(8)
poad_mod_date	Modified Date	Mod Date	99/99/99
poad_mod_userid	User ID		x(8)
poad_percent	MRP Percent	Percent	>>9.9<	10
poad_po_nbr	Purchase Order	Order	x(8)
poad_pod_line	Line		>>9
poad_supplier	Supplier		x(8)
poad_user1	User Field Character 1		x(24)
poad_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_poad_det	yes	oid_poad_det	yes	no
∗	poad_oid_poa_mstr	no	oid_poa_mstr	yes	no
			poad_po_nbr	yes	no
			poad_pod_line	yes	no
	poad_supplier	no	poad_domain	yes	no
			poad_supplier	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_poa_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
poa__qadc01	QAD Character Field 1		x(24)
poa__qadc02	QAD Character Field 2		x(24)
poa_domain	Domain		x(8)
poa_eff_date	Effective Date	Effective	99/99/99
poa_mod_date	Modified Date	Mod Date	99/99/99
poa_mod_userid	User ID		x(8)
poa_operation	Operation	Op	>>>>9
poa_order_type	Order Type	Order!Type	>9
poa_part	Item Number		x(18)
poa_routing	Routing Code		x(18)
poa_site	Site		x(8)
poa_user1	User Field Character 1		x(24)
poa_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_poa_mstr	yes	oid_poa_mstr	yes	no
∗	poa_order_type	yes	poa_domain	yes	no
			poa_order_type	yes	no
			poa_site	yes	no
			poa_part	yes	no
			poa_routing	yes	no
			poa_operation	yes	no
			poa_eff_date	yes	no
	poa_part_site	no	poa_domain	yes	no
			poa_part	yes	no
			poa_site	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_poc_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
poc__qad01			99999
poc__qadc01	QAD Field		X(8)	0
poc__qadc02	QAD Field		X(8)	0
poc__qadc03	QAD Field		X(8)	0
poc__qadc04			x(8)
poc__qadc05			x(4)
poc__qadd01	QAD Field		->>>>,>>>,>>9.99<<<	10
poc__qadd02	QAD Field		->>>>,>>>,>>9.99<<<	10
poc__qadi02	QAD Field		->,>>>,>>9
poc__qadi03			->>>>>>>9
poc__qadi04	QAD Field		->,>>>,>>9
poc__qadl01	QAD Field		yes/no
poc__qadl02	QAD Field		yes/no
poc__qadl03	QAD Field		yes/no
poc__qadl04	QAD Field		yes/no
poc__qadl07	QAD Field		yes/no
poc__qadl08			yes/no
poc__qadt01	QAD Field		99/99/99
poc_ack_req	Require Acknowledgment	Req Conf	yes/no
poc_apv_req	Approved Reqs Needed for POs		yes/no
poc_bill	Bill-To		x(8)
poc_crtacc_acct	PO Interest Accrued Acct		X(8)
poc_crtacc_cc	PO Interest Accrued CC	CC	X(4)
poc_crtacc_sub	PO Int Accrued Sub-Acct	Sub-Acct	x(8)
poc_crtapp_acct	PO Interest Applied Acct		X(8)
poc_crtapp_cc	PO Interest Applied CC	CC	X(4)
poc_crtapp_sub	PO Int Applied Sub-Acct	Sub-Acct	x(8)
poc_date_based_rlse_id	Generate Date Based Release ID	Gen Date Based Rlse ID	yes/no
poc_dflt_dybkset	Default Daybook Set	Def Dybk Set	x(8)
poc_domain	Domain		x(8)
poc_dybk_on_invoice	Allow Supplier Invoice Daybook Update		yes/no
poc_dybkset_by_site	Use Daybook Set by Site		yes/no
poc_ers_opt	ERS Option	ERS!Opt	x(1)
poc_ers_proc	ERS Processing		yes/no
poc_ers_round_gl	LD/Invoice Discrepancy Acct Type		x(20)
poc_ex_ratetype	Rate Type		x(8)
poc_fiscal_confirm	Fiscal Confirm Required		yes/no
poc_fst_id	Company FST ID		x(18)
poc_hcmmts	PO Header Comments		yes/no
poc_insp_loc	Inspection Location	Inspect	x(8)
poc_lcmmts	PO Line Comments		yes/no
poc_ln_fmt	Ln Format S/M	Ln Format	single/multi
poc_ln_stat	Cancel Backorders	Cancel	x(1)
poc_multi_due_dates	Multi Due Dates	Multi!Due!Dates	yes/no
poc_next_batch	Next Fiscal Batch		>>>>>>>>9
poc_pc_line	Price by PO Line Due Date		yes/no
poc_pl_req	Price List Required		yes/no
poc_po_hist	Keep Booking History	Book!Hst	yes/no
poc_po_nbr	Next Purchase Order	Next PO	99999999
poc_po_pre	PO Prefix	Pre	x(3)
poc_pst_id	PST ID		x(18)
poc_pt_req	Price Table Required		yes/no
poc_rcv_all	Receive All		yes/no
poc_rcv_nbr	Next Receiver	Next Rcvr	99999999	0
poc_rcv_pre	Receiver Prefix	Pre	x(3)
poc_rcv_type	Receiver Type	T	9	0
poc_req_nbr	Next Req		>>>>>>>9
poc_req_pre	Requistion Prefix	Pre	x(3)
poc_sched_disc_tbl_req	Sched Disc Table Required		yes/no
poc_ship	Ship-To		x(8)
poc_sort_by	Sort PO By		Site/Line
poc_temp_price_enabled	Temporary Price Enabled		yes/no
poc_tol_cst	Tolerance Cost	Tolerance $	>>>>,>>>,>>9.99<<<	10
poc_tol_pct	Tolerance Percent	Tol %	>>>>.99	10
poc_user1	Ufld1		x(8)
poc_user2	Ufld2		x(8)
poc_zero_sched	Zero Schedule	Zero Schedule	>>9


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_poc_ctrl	yes	oid_poc_ctrl	yes	no
∗	poc_index1	yes	poc_domain	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_podd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
podd__qadc01			x(8)
podd__qadc02			x(8)
podd_consignment	Consignment		yes/no
podd_custpart	Customer Item		x(30)
podd_domain	Domain		x(8)
podd_line	Line		>>9
podd_loc	Location		x(8)
podd_mod_date	Modified Date	Mod Date	99/99/99
podd_mod_userid	User ID		x(8)
podd_order	Order		x(8)
podd_part	Part		x(18)
podd_rct_qty	Receipt Qty		->>>>,>>>,>>9.99<<<	10
podd_ship_qty	Qty Shipped		->>>>,>>>,>>9.99<<<	10
podd_shipfrom	Ship-From		x(8)
podd_shipper_id	Shipper		x(20)
podd_site	Site		x(8)
podd_um	UM		x(2)
podd_user1	Ufld1		x(24)
podd_user2	Ufld2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_podd_det	yes	oid_podd_det	yes	no
∗	podd_id	yes	podd_domain	yes	no
			podd_shipfrom	yes	no
			podd_shipper_id	yes	no
			podd_order	yes	no
			podd_line	yes	no
	podd_item	no	podd_domain	yes	no
			podd_part	yes	no
			podd_order	yes	no
			podd_line	yes	no
	podd_order	no	podd_domain	yes	no
			podd_order	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_podd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_podl_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
podl__qadc01			x(8)
podl__qadc02			x(8)
podl_domain	Domain		x(8)
podl_lotser	Lot/Serial		x(18)
podl_mod_date	Modified Date	Mod Date	99/99/99
podl_mod_userid	User ID		x(8)
podl_rct_qty	Receipt Qty		->>>>,>>>,>>9.99<<<	10
podl_ref	Reference		x(8)
podl_ship_qty	Qty Shipped		->>>>,>>>,>>9.99<<<	10
podl_user1	Ufld1		x(24)
podl_user2	Ufld2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_podl_det	yes	oid_podl_det	yes	no
∗	podl_id	yes	podl_domain	yes	no
			oid_podd_det	yes	no
			podl_lotser	yes	no
			podl_ref	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_podm_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
podm__qadc01			x(8)
podm__qadc02			x(8)
podm_domain	Domain		x(8)
podm_eff_date	Effective Date		99/99/99
podm_mod_date	Modified Date	Mod Date	99/99/99
podm_mod_userid	User ID		x(8)
podm_rct_date	Receipt Date		99/99/99
podm_ref	Reference		x(20)
podm_shipfrom	Ship-From		x(8)
podm_shipper_id	Shipper		x(20)
podm_shipto	Ship-To		x(8)
podm_shp_date	Ship Date		99/99/99
podm_user1	Ufld1		x(24)
podm_user2	Ufld2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_podm_mstr	yes	oid_podm_mstr	yes	no
∗	podm_id	yes	podm_domain	yes	no
			podm_shipfrom	yes	no
			podm_shipper_id	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_pod_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
pod__chr01			x(8)
pod__chr02			x(8)
pod__chr03			x(8)
pod__chr04			x(8)
pod__chr05			x(8)
pod__chr06			x(8)
pod__chr07			x(8)
pod__chr08			x(8)
pod__chr09			x(8)
pod__chr10			x(8)
pod__dec01			>>>,>>>,>>9.99	10
pod__dec02			>>>,>>>,>>9.99	10
pod__dte01			99/99/99
pod__dte02			99/99/99
pod__log01			yes/no
pod__qad02			->>>>>>>>>9
pod__qad03			99:99:99
pod__qad04[5]			x(40)
pod__qad05			yes/no
pod__qad06			x(1)
pod__qad07			x(2)
pod__qad08			99/99/99
pod__qad09			->>>>,>>>,>>9
pod__qad10			x(8)
pod__qad11			x(8)
pod__qad12			yes/no
pod__qad13			yes/no
pod__qad14			99/99/99
pod__qad15			yes/no
pod__qad16			x(8)
pod__qadd02	QAD Field		->>>>,>>>,>>9.99	10
pod__qadd03	QAD Field		->>>>,>>>,>>9.99<<<	10
pod__qadd04	QAD Field		->>>>,>>>,>>9.99	10
pod__qadt01			99/99/99
pod_acct	Pur Acct		x(8)
pod_approve	Approved By	Approved	x(8)
pod_apr_code	Approval Code	Apr Code	x(8)
pod_assay	Assay %		>>9.99%	10
pod_blanket	Blanket		x(8)
pod_blnkt_ln	Blanket Line	Bl Ln	>>9
pod_bo_chg	Qty B/O		->,>>>,>>9.9<<<<<<<<	10
pod_cc	Cost Ctr	CC	x(4)
pod_cmtindx	Comment Index	Comment	>>>>>>>9
pod_consignment	Consignment		yes/no
pod_contr_id	Contract ID		x(30)
pod_contract	Contract		x(8)
pod_cost_chg	Receipt Cost		->>>,>>>,>>9.99<<<	10
pod_crt_int	Credit Terms Int	CRT Int	->>>9.99	10
pod_cst_up	Update Current Cost		yes/no
pod_cum_date[4]	Cum Start		99/99/99
pod_cum_qty[4]	Cum Received		->>>>,>>>,>>9.9<<<<<<<<	10
pod_curr_rlse_id[3]	Active Rlse ID		x(30)
pod_desc	Description		x(40)
pod_disc_pct	Disc%		->>9.99	10
pod_dock	Dock		x(8)
pod_domain	Domain		x(8)
pod_drp_ref	DRP Ref		x(8)
pod_due_date	Due Date	Due	99/99/99
pod_end_eff[4]	End Effective		99/99/99
pod_ers_opt	ERS Option	ERS!Opt	>9
pod_expire	Expire Date	Expire	99/99/99
pod_fab_days	Fab Auth Days		>,>>9
pod_fab_weeks	Fab Auth Weeks		>,>>9
pod_firm_days	Firm Days		>,>>9
pod_firm_weeks	Firm Weeks		>,>>9
pod_fix_pr	Fixed Price		yes/no
pod_fr_list	Freight List	Frt List	x(8)
pod_fsm_type	FSM Type		x(8)
pod_grade	Grade		x(2)
pod_insp_rqd	Inspect Req	Insp	yes/no
pod_item_rev_date	Item Revision Date	Item Rev Date	99/99/99
pod_line	Line	Ln	>>9
pod_loc	Location		x(8)
pod_lot_next	Next Lot/Serial		x(18)
pod_lot_rcpt	Single Lot		yes/no
pod_max_aging_days	Maximum Aging Days	Maximum!Aging Days	>>9
pod_mrp_pct	Supply Percent		>>9.99%	10
pod_multi_due_dates	Multi Due Dates	Multi!Due!Dates	yes/no
pod_nbr	Purchase Order	Order	x(8)
pod_need	Need Date	Need	99/99/99
pod_op	Operation	Op	>>>>>9
pod_ord_mult	Std Pack Qty	Mult	>>,>>>,>>9	0
pod_part	Item Number		x(18)
pod_pastdue	Past Due Logic	C/R	x(1)
pod_pay_um	Pay UM	UM	x(2)
pod_per_date	Perform Date	Perform	99/99/99
pod_pjs_line	Project Line		>>>>>>>9
pod_pkg_code	Pkg Code		x(18)
pod_plan_days	Plan Sched Days		>>9
pod_plan_mths	Plan Sched Months		>>9
pod_plan_weeks	Plan Sched Weeks		>>9
pod_po_db	PO Database	PO DB	x(8)
pod_po_site	PO Site		x(8)
pod_pr_list	Price List	List	x(8)
pod_pr_lst_tp	ERS Price List Option	ERS!PLO	>9
pod_pricing_dt	Pricing Date	Price Dt	99/99/99
pod_project	Project		x(8)
pod_ps_chg	Packing Slip Qty	Pack Slip Qty	->,>>>,>>9.9<<<<<<<<	10
pod_pst	PST		yes/no
pod_pum_conv	Pay UM Conv		>>>>9.9999<<<<	10
pod_pur_cost	Purchase Cost		->>>,>>>,>>9.99<<<	10
pod_qty_chg	Receipt Qty		->,>>>,>>9.9<<<<<<<<	10
pod_qty_ord	Qty Ordered		->,>>>,>>9.9<<<<<<<<	10
pod_qty_rcvd	Qty Received		->,>>>,>>9.9<<<<<<<<	10
pod_qty_rtnd	Qty Returned		->,>>>,>>9.9<<<<<<<<	10
pod_raw_days	Raw Auth Days		>,>>9
pod_raw_weeks	Raw Auth Weeks		>,>>9
pod_rctstat	Receipt Status	Status	x(8)
pod_rctstat_active	Active	Act	yes/no
pod_reason	Reason		x(8)
pod_rel_nbr	Rel		>>9
pod_rel_qty	Qty Released	Rel Qty	->,>>>,>>9.9<<<<<<<<	10
pod_req_line	Req Line	Req Ln	>>9
pod_req_nbr	Req		x(8)
pod_request	Requested By	Req By	x(8)
pod_rev	Item Revision	Item Rev	x(4)
pod_rlse_nbr	Next Release ID		99999999
pod_rma_type	RMA Type		x(1)
pod_rum	UM		x(2)
pod_rum_conv	UM Conversion		>>>>9.9999<<<<	10
pod_sch_data	Schedule Data		x(8)
pod_sch_mrp	Sched MRP Req		yes/no
pod_sched	Scheduled		yes/no
pod_sched_chgd	Scheduled		yes/no
pod_sd_pat	Ship/Dlvy Pattern		x(2)
pod_sd_time	Ship/Dlvy Time		x(2)
pod_serial	Lot/Serial		x(18)
pod_sftylt_days	Safety Days		>>9.99	10
pod_sftylt_hrs	Safety Hours		>>9.99	10
pod_ship_weeks	Ship Sched Weeks		>>9
pod_site	Site		x(8)
pod_so_job	Sales/Job	SO/Job	x(8)
pod_so_status	Secondary SO Status		x
pod_sod_line	Primary SO Line	Pr SO Ln	>>9
pod_start_eff[4]	Start Effective		99/99/99
pod_status	Status	St	x(1)
pod_std_cost	Std Cost		->>>,>>>,>>9.99<<<	10
pod_sub	Pur Sub-Acct	Sub-Acct	x(8)
pod_sub_ship_date	Subcontract Ship		99/99/99
pod_sub_type	Subcontract Type		x(8)
pod_tax_env	Tax Environment	Tax Env	x(16)
pod_tax_in	Tax In		yes/no
pod_tax_max	Max Taxable Amount	Max Amount	->>>,>>>,>>9.99	10
pod_tax_usage	Tax Usage	TaxUsage	x(8)
pod_taxable	Taxable	Tax	yes/no
pod_taxc	Tax Class	TxC	x(3)
pod_translt_days	Transport Days		>>9.99	10
pod_translt_hrs	Transport Hours		>>9.99	10
pod_type	Type	T	x(1)
pod_um	UM		x(2)
pod_um_conv	UM Conversion	UM Conv	>>>>9.9999<<<<	10
pod_user1	Ufld1		x(8)
pod_user2	Ufld2		x(8)
pod_vat	VAT		yes/no
pod_vpart	Supplier Item		x(30)
pod_wip_lotser	Lot/Serial		x(18)
pod_wo_lot	Work Order ID	WO ID	x(8)
pod_zero_sched_count	Zero Schedule Counter	Zero Sched Count	>>9	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_pod_det	yes	oid_pod_det	yes	no
	pod_fsm_type	no	pod_domain	yes	no
			pod_fsm_type	yes	no
			pod_nbr	yes	no
			pod_line	yes	no
∗	pod_nbrln	yes	pod_domain	yes	no
			pod_nbr	yes	no
			pod_line	yes	no
	pod_part	yes	pod_domain	yes	no
			pod_part	yes	no
			pod_nbr	yes	no
			pod_line	yes	no
	pod_partdue	no	pod_domain	yes	no
			pod_part	yes	no
			pod_due_date	yes	no
	pod_project	no	pod_domain	yes	no
			pod_project	yes	no
			pod_pjs_line	yes	no
	pod_sdt_code	no	pod_domain	yes	no
			pod__qad07	yes	no
			pod_nbr	yes	no
			pod_line	yes	no


Field Name	Label	Col-Label	Format	Dec
AutoReversalPosting_ID	Automatic Reversal Posting	Automatic Reversal Posting	-99999999999
Company_ID	Link to Company		-99999999999
CreatorUsr_ID	Login		-99999999999
CustomCombo0	Custom Combo Field		x(20)
CustomCombo1	Custom Combo Field		x(20)
CustomCombo10	Custom Combo Field		x(20)
CustomCombo11	Custom Combo Field		x(20)
CustomCombo12	Custom Combo Field		x(20)
CustomCombo13	Custom Combo Field		x(20)
CustomCombo14	Custom Combo Field		x(20)
CustomCombo2	Custom Combo Field		x(20)
CustomCombo3	Custom Combo Field		x(20)
CustomCombo4	Custom Combo Field		x(20)
CustomCombo5	Custom Combo Field		x(20)
CustomCombo6	Custom Combo Field		x(20)
CustomCombo7	Custom Combo Field		x(20)
CustomCombo8	Custom Combo Field		x(20)
CustomCombo9	Custom Combo Field		x(20)
CustomDate0	Custom Date Field		99/99/9999
CustomDate1	Custom Date Field		99/99/9999
CustomDate2	Custom Date Field		99/99/9999
CustomDate3	Custom Date Field		99/99/9999
CustomDate4	Custom Date Field		99/99/9999
CustomDate5	Custom Date Field		99/99/9999
CustomDate6	Custom Date Field		99/99/9999
CustomDate7	Custom Date Field		99/99/9999
CustomDate8	Custom Date Field		99/99/9999
CustomDate9	Custom Date Field		99/99/9999
CustomDecimal0	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal1	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal2	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal3	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal4	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal5	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal6	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal7	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal8	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal9	Custom Decimal Field		->,>>>,>>9.99	4
CustomInteger0	Custom Integer Field		->,>>>,>>9
CustomInteger1	Custom Integer Field		->,>>>,>>9
CustomInteger2	Custom Integer Field		->,>>>,>>9
CustomInteger3	Custom Integer Field		->,>>>,>>9
CustomInteger4	Custom Integer Field		->,>>>,>>9
CustomLong0	Custom Long Field		x(255)
CustomLong1	Custom Long Field		x(255)
CustomNote	Custom Note Field		x(2000)
CustomShort0	Custom Short Field		x(20)
CustomShort1	Custom Short Field		x(20)
CustomShort10	Custom Short Field		x(20)
CustomShort11	Custom Short Field		x(20)
CustomShort12	Custom Short Field		x(20)
CustomShort13	Custom Short Field		x(20)
CustomShort14	Custom Short Field		x(20)
CustomShort2	Custom Short Field		x(20)
CustomShort3	Custom Short Field		x(20)
CustomShort4	Custom Short Field		x(20)
CustomShort5	Custom Short Field		x(20)
CustomShort6	Custom Short Field		x(20)
CustomShort7	Custom Short Field		x(20)
CustomShort8	Custom Short Field		x(20)
CustomShort9	Custom Short Field		x(20)
Journal_ID	Daybook Code		-99999999999
LastApprovedUsr_ID	Link to Usr		-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)
LastVerifiedUsr_ID	Link to Usr		-99999999999
ObsoleteClosing_ID	Link to Closing		-99999999999
Period_ID	Link to Period		-99999999999
PeriodMark_ID	Link to PeriodMark		-99999999999
Posting_ID	Record ID		-99999999999
PostingAddGLNbr	Sequence Number		999999999
PostingAddGLNbrDate	Additional GL Numbering Date		99/99/9999
PostingAddGLNbrRevDate	Additional GL Numbering Reversal Date		99/99/9999
PostingApproveComments	Approve Comments		x(40)
PostingApprovedDate	Last Approved Date		99/99/9999
PostingApprovedTime	Last Approved Time		->,>>>,>>9
PostingApproveStatus	Approve Status		x(40)
PostingAutoReversalDate	Automatic Reversal Date	Automatic Reversal Date	99/99/9999
PostingAutoReversalType	Automatic Reversal Type	Automatic Reversal Type	x(20)
PostingBankImpRef	Bank Importing Reference		x(255)
PostingBatchNumber	Batch Number		x(8)
PostingBusinessRelationTxt	Bus Rel (IC Posting)	Business Relation (IC Posting)	x(40)
PostingCreationDate	Creation Date		99/99/9999
PostingCreationTimeString	Creation Time		x(10)
PostingDate	Posting Date		99/99/9999
PostingInvoiceReferenceTxt	External Inv Ref	External Invoice Reference	x(50)
PostingIsAutoReversal	Automatic Reversal	Automatic Reversal	yes/no
PostingIsCorrection	Correction	Correction	yes/no
PostingIsReplacement	Replacement	Is Replacement	yes/no
PostingIsReversing	Reversal	Is Reversal	yes/no
PostingIsReversingBySign	Correction		yes/no
PostingIsSkipAutoAssignLC	Skip Auto Assign BC		yes/no
PostingIsZeroValueAllowed	Zero Value Allowed		yes/no
PostingMirrorRef	Mirroring Reference		x(20)
PostingOriginAddressCode	Address Code		x(20)
PostingOriginatorReference	Original Posting Reference		x(40)
PostingOriginDaybookCode	Origin Daybook Code		x(8)
PostingOriginDaybookNumber	Origin Daybook Number		x(40)
PostingOriginDocument	Origin Document	Origin Doc	x(22)
PostingOriginDocumentType	Origin Payment Type	Origin Pay Type	x(2)
PostingOriginIsExternal	External Origin		yes/no
PostingOriginReference	Origin Reference	Origin Ref	x(22)
PostingOriginTransType	Origin Transaction Type	Origin Trans Type	x(2)
PostingParentText	Parent Text		x(40)
PostingPeriod	GL Period		99
PostingSecondText	Second Description		x(40)
PostingSystemDate	System Date	Sys Date	99/99/9999
PostingText	Description		x(40)
PostingTransientRef	Transient Reference		x(40)
PostingValueDate	Value Date		99/99/9999
PostingVerifiedDate	Last Verified Date		99/99/9999
PostingVerifiedTime	Last Verified Time		->,>>>,>>9
PostingVerifyComments	Verify Comments		x(40)
PostingVerifyStatus	Verify Status		x(40)
PostingVoucher	Voucher		999999999
PostingYear	Year		9999
PostingYearPeriod	Year/GL Period	GL Cal Yr/GL Pd	999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
ReportingJournal_ID	Reporting Daybook		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	AddGLNbr	no	Company_ID	yes	no
			PostingAddGLNbr	no	no
			PostingAddGLNbrDate	no	no
	ApproveIdx	no	PostingApproveStatus	yes	no
	AutoReversal	no	PostingIsAutoReversal	yes	no
			PostingAutoReversalType	yes	no
	Company	no	Company_ID	yes	no
	CreateUsrIdx	no	CreatorUsr_ID	yes	no
	CyJrnlDateIdx	no	Company_ID	yes	no
			Journal_ID	yes	no
			PostingDate	yes	no
	CyOrig	no	Company_ID	yes	no
			PostingOriginTransType	yes	no
			PostingOriginReference	yes	no
	CyPeriodYearPeriodIdx	no	Company_ID	yes	no
			PostingYearPeriod	yes	no
	CyPostingDate	no	Company_ID	yes	no
			PostingDate	yes	no
	CySysDate	no	Company_ID	yes	no
			PostingSystemDate	yes	no
	Journal	no	Journal_ID	yes	no
	LastApprUsrIdx	no	LastApprovedUsr_ID	yes	no
	LastModIdx	no	LastModifiedDate	yes	no
	LastVerUsrIdx	no	LastVerifiedUsr_ID	yes	no
	MirrorRef	no	PostingMirrorRef	yes	no
	OriginatorRef	no	PostingOriginatorReference	yes	no
	Period	no	Period_ID	yes	no
	PeriodMarkIdx	no	PeriodMark_ID	yes	no
	PostingDate	no	PostingDate	yes	no
	PostingOriginIsExt	no	PostingOriginIsExternal	yes	no
	PostingOriginRef	no	PostingOriginReference	yes	no
	PostingYear	no	PostingYear	yes	no
∗	Prim	yes	Posting_ID	yes	no
	ReportingJrnlIdx	no	ReportingJournal_ID	yes	no
	UniqueIdx	yes	Company_ID	yes	no
			PostingYear	yes	no
			Journal_ID	yes	no
			PostingVoucher	yes	no
	VerifyIdx	no	PostingVerifyStatus	yes	no
	ViewIndex	no	Company_ID	yes	no
			PostingYear	yes	no
			PostingPeriod	yes	no
			Journal_ID	yes	no
			PostingVoucher	yes	no
	Voucher	no	PostingVoucher	yes	no


Field Name	Label	Col-Label	Format	Dec
Company_ID	Link to Company		-99999999999
CostCentre_ID	Link to CostCentre		-99999999999
Currency_ID	Link to Currency		-99999999999
Division_ID	Link to Division		-99999999999
GL_ID	Link to GL		-99999999999
IntercoBusinessRelation_ID	Link to BusinessRelation		-99999999999
Journal_ID	Link to Journal		-99999999999
JournalTypeCode	Daybook Type	Type	x(30)
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
Layer_ID	Link to Layer		-99999999999
PostingHist_ID	Record ID		-99999999999
PostingHistBalanceCreditCC	SC Credit Balance		->>>,>>>,>>>,>>9.99	4
PostingHistBalanceCreditLC	BC Balance Credit		->>>,>>>,>>>,>>9.99	4
PostingHistBalanceCreditPC	PC Credit Balance		->,>>>,>>9.99	4
PostingHistBalanceCreditTC	TC Credit Balance		->>>,>>>,>>>,>>9.99	4
PostingHistBalanceDebitCC	SC Debit Balance		->>>,>>>,>>>,>>9.99	4
PostingHistBalanceDebitLC	BC Balance Debit		->>>,>>>,>>>,>>9.99	4
PostingHistBalanceDebitPC	PC Debit Balance		->,>>>,>>9.99	4
PostingHistBalanceDebitTC	TC Debit Balance		->>>,>>>,>>>,>>9.99	4
PostingHistBalanceQTY	Quantity Balance	Qty Balance	->>>,>>>,>>9.99999	10
PostingHistFRWCubeTimeStamp	Timestamp		x(32)
PostingHistMovemntCreditCC	SC Credit Activity		->>>,>>>,>>>,>>9.99	4
PostingHistMovemntCreditLC	BC Movement Credit		->>>,>>>,>>>,>>9.99	4
PostingHistMovemntCreditPC	PC Credit Activity		->,>>>,>>9.99	4
PostingHistMovemntCreditTC	TC Credit Activity		->>>,>>>,>>>,>>9.99	4
PostingHistMovemntDebitCC	SC Debit Activity		->>>,>>>,>>>,>>9.99	4
PostingHistMovemntDebitLC	BC Movement Debit		->>>,>>>,>>>,>>9.99	4
PostingHistMovemntDebitPC	PC Debit Activity		->,>>>,>>9.99	4
PostingHistMovemntDebitTC	TC Debit Activity		->>>,>>>,>>>,>>9.99	4
PostingHistMovemntQTY	Qty Activity		->>>,>>>,>>9.99999	10
PostingHistYearPeriodFrom	From Year/GL Period		->,>>>,>>9
PostingHistYearPeriodTill	To Year/GL Period		->,>>>,>>9
PostingHistYTDCreditCC	SC Credit (YTD)		->>>,>>>,>>>,>>9.99	4
PostingHistYTDCreditLC	BC YTD Credit		->>>,>>>,>>>,>>9.99	4
PostingHistYTDCreditPC	PC Credit (YTD)		->>>,>>>,>>>,>>9.99	4
PostingHistYTDCreditTC	TC Credit (YTD)		->>>,>>>,>>>,>>9.99	4
PostingHistYTDDebitCC	SC Debit (YTD)		->>>,>>>,>>>,>>9.99	4
PostingHistYTDDebitLC	BC YTD Debit		->>>,>>>,>>>,>>9.99	4
PostingHistYTDDebitPC	PC Debit (YTD)		->>>,>>>,>>>,>>9.99	4
PostingHistYTDDebitTC	TC Debit (YTD)		->>>,>>>,>>>,>>9.99	4
PostingHistYTDQTY	Quantity (YTD)	Qty (YTD)	->>>,>>>,>>9.99999	10
PostingSafCombined_ID	Link to PostingSafCombined		-99999999999
Project_ID	Link to Project		-99999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
	Company	no	Company_ID	yes	no
	CompanyYPFrom	no	Company_ID	yes	no
			PostingHistYearPeriodFrom	yes	no
	CostCentre	no	CostCentre_ID	yes	no
	Currency	no	Currency_ID	yes	no
	CyCCTill	no	Company_ID	yes	no
			CostCentre_ID	yes	no
			PostingHistYearPeriodTill	yes	no
	CyDivTill	no	Company_ID	yes	no
			Division_ID	yes	no
			PostingHistYearPeriodTill	yes	no
	CyGLFrom	no	Company_ID	yes	no
			GL_ID	yes	no
			PostingHistYearPeriodFrom	yes	no
	CyGLLayPd1Till	no	Company_ID	yes	no
			GL_ID	yes	no
			Layer_ID	yes	no
			PostingHistYearPeriodTill	yes	no
	CyGLLayPd2From	no	Company_ID	yes	no
			GL_ID	yes	no
			Layer_ID	yes	no
			PostingHistYearPeriodFrom	yes	no
	CyGLTill	no	Company_ID	yes	no
			GL_ID	yes	no
			PostingHistYearPeriodTill	yes	no
	CyJrnlPdFrom	no	Company_ID	yes	no
			Journal_ID	yes	no
			PostingHistYearPeriodFrom	yes	no
	CyJrnlTill	no	Company_ID	yes	no
			Journal_ID	yes	no
			PostingHistYearPeriodTill	yes	no
	CyLayPd1Till	no	Company_ID	yes	no
			Layer_ID	yes	no
			PostingHistYearPeriodTill	yes	no
	CyLayPd2From	no	Company_ID	yes	no
			Layer_ID	yes	no
			PostingHistYearPeriodFrom	yes	no
	CyProjTill	no	Company_ID	yes	no
			Project_ID	yes	no
			PostingHistYearPeriodTill	yes	no
	Division	no	Division_ID	yes	no
	GL	no	GL_ID	yes	no
	GLCostCentre	no	GL_ID	yes	no
			CostCentre_ID	yes	no
	GLDivision	no	GL_ID	yes	no
			Division_ID	yes	no
	GLPostSafComb	no	GL_ID	yes	no
			PostingSafCombined_ID	yes	no
	GLProject	no	GL_ID	yes	no
			Project_ID	yes	no
	IDsPeriod1Till	no	Company_ID	yes	no
			Journal_ID	yes	no
			Layer_ID	yes	no
			GL_ID	yes	no
			Division_ID	yes	no
			CostCentre_ID	yes	no
			Project_ID	yes	no
			Currency_ID	yes	no
			IntercoBusinessRelation_ID	yes	no
			PostingSafCombined_ID	yes	no
			PostingHistYearPeriodTill	yes	no
	IDsPeriod2From	no	Company_ID	yes	no
			Journal_ID	yes	no
			Layer_ID	yes	no
			GL_ID	yes	no
			Division_ID	yes	no
			CostCentre_ID	yes	no
			Project_ID	yes	no
			Currency_ID	yes	no
			IntercoBusinessRelation_ID	yes	no
			PostingSafCombined_ID	yes	no
			PostingHistYearPeriodFrom	yes	no
	Interco	no	IntercoBusinessRelation_ID	yes	no
	Journal	no	Journal_ID	yes	no
	LastModIdx	no	LastModifiedDate	yes	no
	Layer	no	Layer_ID	yes	no
	Period1Till	no	PostingHistYearPeriodTill	yes	no
	Period2From	no	PostingHistYearPeriodFrom	yes	no
	PostingSafComb	no	PostingSafCombined_ID	yes	no
∗	Prim	yes	PostingHist_ID	yes	no
	Project	no	Project_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
Company_ID	Link to Company		-99999999999
ConsumptionVat_ID	Link to Vat		-99999999999
CostCentre_ID	Cost Center Code		-99999999999
CrossCompany_ID	Link to Company		-99999999999
CrossCompanyPosting_ID	Posting (Cross-Cy)		-99999999999
CrossCompanyPostingLine_ID	Posting line (Cross-Cy)	Posting-line (Cross-Cy)	-99999999999
Currency_ID	Currency Code	Trans Curr	-99999999999
CustomCombo0	Custom Combo Field		x(20)
CustomCombo1	Custom Combo Field		x(20)
CustomCombo10	Custom Combo Field		x(20)
CustomCombo11	Custom Combo Field		x(20)
CustomCombo12	Custom Combo Field		x(20)
CustomCombo13	Custom Combo Field		x(20)
CustomCombo14	Custom Combo Field		x(20)
CustomCombo2	Custom Combo Field		x(20)
CustomCombo3	Custom Combo Field		x(20)
CustomCombo4	Custom Combo Field		x(20)
CustomCombo5	Custom Combo Field		x(20)
CustomCombo6	Custom Combo Field		x(20)
CustomCombo7	Custom Combo Field		x(20)
CustomCombo8	Custom Combo Field		x(20)
CustomCombo9	Custom Combo Field		x(20)
CustomDate0	Custom Date Field		99/99/9999
CustomDate1	Custom Date Field		99/99/9999
CustomDate2	Custom Date Field		99/99/9999
CustomDate3	Custom Date Field		99/99/9999
CustomDate4	Custom Date Field		99/99/9999
CustomDate5	Custom Date Field		99/99/9999
CustomDate6	Custom Date Field		99/99/9999
CustomDate7	Custom Date Field		99/99/9999
CustomDate8	Custom Date Field		99/99/9999
CustomDate9	Custom Date Field		99/99/9999
CustomDecimal0	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal1	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal2	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal3	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal4	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal5	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal6	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal7	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal8	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal9	Custom Decimal Field		->,>>>,>>9.99	4
CustomInteger0	Custom Integer Field		->,>>>,>>9
CustomInteger1	Custom Integer Field		->,>>>,>>9
CustomInteger2	Custom Integer Field		->,>>>,>>9
CustomInteger3	Custom Integer Field		->,>>>,>>9
CustomInteger4	Custom Integer Field		->,>>>,>>9
CustomLong0	Custom Long Field		x(255)
CustomLong1	Custom Long Field		x(255)
CustomNote	Custom Note Field		x(2000)
CustomShort0	Custom Short Field		x(20)
CustomShort1	Custom Short Field		x(20)
CustomShort10	Custom Short Field		x(20)
CustomShort11	Custom Short Field		x(20)
CustomShort12	Custom Short Field		x(20)
CustomShort13	Custom Short Field		x(20)
CustomShort14	Custom Short Field		x(20)
CustomShort15	Custom Short Field		x(20)
CustomShort16	Custom Short Field		x(20)
CustomShort17	Custom Short Field		x(20)
CustomShort18	Custom Short Field		x(20)
CustomShort19	Custom Short Field		x(20)
CustomShort2	Custom Short Field		x(20)
CustomShort3	Custom Short Field		x(20)
CustomShort4	Custom Short Field		x(20)
CustomShort5	Custom Short Field		x(20)
CustomShort6	Custom Short Field		x(20)
CustomShort7	Custom Short Field		x(20)
CustomShort8	Custom Short Field		x(20)
CustomShort9	Custom Short Field		x(20)
Division_ID	Sub-Account Code		-99999999999
GL_ID	GL Description		-99999999999
IntercoBusinessRelation_ID	Intercompany Code		-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)
Period_ID	Link to Period		-99999999999
Posting_ID	Link to Posting		-99999999999
PostingDate	Posting Date		99/99/9999
PostingLine_ID	Record ID		-99999999999
PostingLineAddGLNbr	Additional Sequence Number		99999999999
PostingLineAddGLNbrDate	Additional Sequence Date		99/99/9999
PostingLineCCRate	SC Rate		->,>>>,>>9.9999999999	10
PostingLineCCScale	SC Rate Scale		->,>>>,>>9.9999999999	10
PostingLineCostCentreText	Cost Center		x(40)
PostingLineCreditCC	SC Credit		->>>,>>>,>>>,>>9.99	4
PostingLineCreditLC	BC Credit		->>>,>>>,>>>,>>9.99	4
PostingLineCreditPC	PC Credit		->,>>>,>>9.99	4
PostingLineCreditTC	TC Credit		->>>,>>>,>>>,>>9.99	4
PostingLineCrossExternRef	Ext Reference (Cross-Cy)		x(40)
PostingLineDebitCC	SC Debit		->>>,>>>,>>>,>>9.99	4
PostingLineDebitLC	BC Debit		->>>,>>>,>>>,>>9.99	4
PostingLineDebitPC	PC Debit		->,>>>,>>9.99	4
PostingLineDebitTC	TC Debit		->>>,>>>,>>>,>>9.99	4
PostingLineExchangeRate	Exchange Rate		->,>>>,>>9.9999999999	10
PostingLineGrossIncAccRef	Gross Income Accounting Reference		x(40)
PostingLineIsProjPosting	Project Posting	Proj	yes/no
PostingLineLegalDocNbr	Legal Document Nbr		x(255)
PostingLineMaster_ID	Link to Master		-99999999999
PostingLineMirrorRef	Mirroring Reference		x(20)
PostingLineMirrorType	Mirroring Type		x(20)
PostingLineOriginLineNbr	Origin Line Number	Origin Line No	>>>9
PostingLineProjectText	Project	Prj	x(40)
PostingLineQTY	Quantity		->>>,>>>,>>9.99999	10
PostingLineRateScale	Scale Factor		->,>>>,>>9.9999999999	10
PostingLineSafText	SAF		x(40)
PostingLineSequence	Sequence	Seq	->,>>>,>>9
PostingLineText	Description		x(40)
PostingLineTransaction_ID	Link to Transaction		-99999999999
PostingYearPeriod	Year/GL Period	GL Cal Yr/GL Pd	999999
Project_ID	Description		-99999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
	AddGLIdx	no	Company_ID	yes	no
			PostingLineAddGLNbr	no	no
	Company	no	Company_ID	yes	no
	CompanyGLYearPd	no	Company_ID	yes	no
			GL_ID	yes	no
			PostingYearPeriod	yes	no
	CompanyYearPeirod	no	Company_ID	yes	no
			PostingYearPeriod	yes	no
	ConsumptionVat	no	ConsumptionVat_ID	yes	no
	CostCentre	no	CostCentre_ID	yes	no
	CrossCompany	no	CrossCompany_ID	yes	no
	CrossCompanyPost	no	CrossCompanyPosting_ID	yes	no
	CrossCompanyPostL	no	CrossCompanyPostingLine_ID	yes	no
	Currency	no	Currency_ID	yes	no
	CyDate	no	Company_ID	yes	no
			PostingDate	yes	no
	CyGLDate	no	Company_ID	yes	no
			GL_ID	yes	no
			PostingDate	yes	no
	Division	no	Division_ID	yes	no
	ExtCrossIdx	no	PostingLineCrossExternRef	yes	no
	GL	no	GL_ID	yes	no
	Interco	no	IntercoBusinessRelation_ID	yes	no
	LastModIdx	no	LastModifiedDate	yes	no
	Master	no	PostingLineMaster_ID	yes	no
	MirrorRef	no	PostingLineMirrorRef	yes	no
	Period	no	Period_ID	yes	no
	Posting	no	Posting_ID	yes	no
	PostingIDLineSeq	no	Posting_ID	yes	no
			PostingLineSequence	yes	no
	PostingYearPeriod	no	PostingYearPeriod	yes	no
∗	Prim	yes	PostingLine_ID	yes	no
	Project	no	Project_ID	yes	no
	ProjectPosting	no	PostingLineIsProjPosting	yes	no
	TransactionId	no	PostingLineTransaction_ID	yes	no