Document Generation Parameter Sets

Table Name: ODGP

Table Description: Document Generation Parameter Sets

Field	Description	Type	Size	Related	Default Value	Constraints
AbsEntry	Internal Number	Int	11	-
SetName	Set Name	nVarChar	20	-
SetDesc	Set Description	nVarChar	100	-
CreateDate	Creation Date	Date	8	-
ModifyDate	Last Modified	Date	8	-
UserSign	User Signature	Int	6	OUSR
Target	Target Document Type	nVarChar	20	-	-1	-1
						17	Sales Order
						15	Delivery
						16	Returns
						13	A/R Invoice
PostDate	Posting Date	Date	8	-
TaxDate	Document Date	Date	8	-
Series	Series	Int	11	-
Items	Items Documents Summary	VarChar	1	-	Y	Y	Yes
						N	No
ItemSmmry	Items Summary Method	VarChar	1	-	N	N	No Summary
						I	Summary by Items
						D	Summary by Documents
Service	Service Documents Summary	VarChar	1	-	N	Y	Yes
						N	No
ServSmmry	Service Summary Method	VarChar	1	-	N	N	No Summary
						D	Summary by Documents
ExchgRate	Exchange Rate	VarChar	1	-	C	D	Use Base Doc. and Row Rate
						B	Use Base Row Rate
						C	Use Current Rate
CreatDraft	Create Drafts	VarChar	1	-	N	Y	Yes
						N	No
BaseQUT	Sales Quotation Summary	VarChar	1	-	N	Y	Yes
						N	No
BaseRDR	Order Summary	VarChar	1	-	N	Y	Yes
						N	No
BaseDLN	Delivery Summary	VarChar	1	-	N	Y	Yes
						N	No
BaseRDN	Returns Summary	VarChar	1	-	N	Y	Yes
						N	No
BaseResINV	A/R Reserve Invoice Summary	VarChar	1	-	N	Y	Yes
						N	No
ExpndSel	Expanded Selection Criteria	VarChar	1	-	N	Y	Yes
						N	No
SortField	Sort Field	nVarChar	100	-	DocNum	DocNum	Document Number
						DocDate	Posting Date
						DocDueDate	Due Date
						NumAtCard	BP Reference No.
						DocTotal	Document Amount
						SlpCode	Sales Employee
Consolidat	Consolidate	VarChar	1	-	Y	Y	Yes
						N	No
ExpandCons	Expanded Consolidation Options	VarChar	1	-	N	Y	Yes
						N	No
RCNSummary	Reference Document	VarChar	1	-	N	Y	Yes
						N	No
ChainCode	Retail Chain	Int	11	-
OredrNum1	Order No. From	Int	11	-
OredrNum2	To	Int	11	-
Direct	Direct	VarChar	1	-	N	Y	Yes
						N	No
Indirect	Indirect	VarChar	1	-	N	Y	Yes
						N	No
DoReport	Overview of Invoice Deliveries	VarChar	1	-	N	Y	Yes
						N	No
FileExport	File Export	VarChar	1	-	N	Y	Yes
						N	No
SavePath	File Path	Text	16	-
DealNum	Closing No.	nVarChar	12	-
UseDirect	Direct/Indirect	VarChar	1	-	N	Y	Yes
						N	No
NoItmCode	Drop Item No. Where Cat. No. E	VarChar	1	-	N	Y	Yes
						N	No
OnData	Missing Data	VarChar	1	-	N	N	Skip to Next Document
						B	Skip to Next Customer
						W	Ask for User Confirmation
OnLedger	Bookkeeping Alert	VarChar	1	-	N	N	Skip to Next Document
						B	Skip to Next Customer
						W	Ask for User Confirmation
OnInvnt	Warehouse Alert	VarChar	1	-	N	N	Skip to Next Document
						B	Skip to Next Customer
						W	Ask for User Confirmation
Summary	Summary	nVarChar	250	-
AltItmDocs	Process docsc with alt. items	VarChar	1	-	Y	Y	Yes
						N	No
PartDelivr	Partial Delivery	VarChar	1	-	N	Y	Yes
						N	No
ConsiderBP	Consider BP	VarChar	1	-	Y	Y	Yes
						N	No
ConsiderTy	Consider Type	VarChar	1	-	Y	Y	Yes
						N	No
EDocGenTyp	Electr. Doc. Generation Type	VarChar	1	-	D	N	Not Relevant
						G	Generate
						L	Generate - Later
						S	Send
						R	Send - Later
						D	Use Defaults
ESeries	Electronic Series	Int	6	NNM4
EDocNum	Electronic Document Number	nVarChar	20	-
ReopOriRdr	Reopen Origin. Order by Return	VarChar	1	-	N	Y	Yes
						N	No
ReopManCls	Reop. Man. Closed/Canc. Orders	VarChar	1	-	N	Y	Yes
						N	No
SeqCode	Target Doc. NF Sequence Code	Int	6	-
UseBaseSeq	Use Base Document NF Sequence	VarChar	1	-	N	Y	Yes
						N	No
OnSeqCode	Missing NF Sequence	VarChar	1	-	N	N	Skip to Next Document
						T	Use NF Sequence from Step 2
BPLId	Branch	Int	11	OBPL
BlckFrOnly	Block Docs. with Zero Items	VarChar	1	-	N	Y	Yes
						N	No
DocSubType	Document Sub-Type	nVarChar	2	-	--	--	Bill of Supply
						GA	GST Tax Invoice
EDocDflt	Apply El. Doc. Defaults	VarChar	1	-	Y	Y	Yes
						N	No
EDocMapID	Electronic Document Format Mapping	Int	11	-
VatDate	VAT Allocation Date	Date	8	-
BsPrcMode	Base Document Price Mode	VarChar	1	-	Y	Y	Yes
						N	No

Key	Unique	Field
PRIMARY	Yes	AbsEntry
SET_NAME	Yes	SetName