biuan SAP® BUSINESS ONE SDK
DTW Banking / Incoming Payments / Incoming Payments
API ODGP
ODGP - Document Generation Parameter Sets Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
SetName KEY UNIQUESet NamenVarChar
20
SET_NAMEYes
SetDescSet DescriptionnVarChar
100
CreateDateCreation DateDate
8
ModifyDateLast ModifiedDate
8
UserSignUser SignatureInt
6OUSR
Users
TargetTarget Document TypenVarChar
-1)
17) Sales Order
15) Delivery
16) Returns
13) A/R Invoice
20
-1
PostDatePosting DateDate
8
TaxDateDocument DateDate
8
SeriesSeriesInt
6
ItemsItems Documents SummaryVarChar
Y) Yes
N) No
1
Y
ItemSmmryItems Summary MethodVarChar
N) No Summary
I) Summary by Items
D) Summary by Documents
1
N
ServiceService Documents SummaryVarChar
Y) Yes
N) No
1
N
ServSmmryService Summary MethodVarChar
N) No Summary
D) Summary by Documents
1
N
ExchgRateExchange RateVarChar
D) Use Base Doc. and Row Rate
B) Use Base Row Rate
C) Use Current Rate
1
C
CreatDraftCreate DraftsVarChar
Y) Yes
N) No
1
N
BaseQUTSales Quotation SummaryVarChar
Y) Yes
N) No
1
N
BaseRDROrder SummaryVarChar
Y) Yes
N) No
1
N
BaseDLNDelivery SummaryVarChar
Y) Yes
N) No
1
N
BaseRDNReturns SummaryVarChar
Y) Yes
N) No
1
N
BaseResINVA/R Reserve Invoice SummaryVarChar
Y) Yes
N) No
1
N
ExpndSelExpanded Selection CriteriaVarChar
Y) Yes
N) No
1
N
SortFieldSort FieldnVarChar
DocNum) Document Number
DocDate) Posting Date
DocDueDate) Due Date
NumAtCard) BP Reference No.
DocTotal) Document Amount
SlpCode) Sales Employee
100
DocNum
ConsolidatConsolidateVarChar
Y) Yes
N) No
1
Y
ExpandConsExpanded Consolidation OptionsVarChar
Y) Yes
N) No
1
N
RCNSummaryReference DocumentVarChar
Y) Yes
N) No
1
N
ChainCodeRetail ChainInt
11
OredrNum1Order No. FromInt
11
OredrNum2ToInt
11
DirectDirectVarChar
Y) Yes
N) No
1
N
IndirectIndirectVarChar
Y) Yes
N) No
1
N
DoReportOverview of Invoice DeliveriesVarChar
Y) Yes
N) No
1
N
FileExportFile ExportVarChar
Y) Yes
N) No
1
N
SavePathFile PathText
16
DealNumClosing No.nVarChar
12
UseDirectDirect/IndirectVarChar
Y) Yes
N) No
1
N
NoItmCodeDrop Item No. Where Cat. No. EVarChar
Y) Yes
N) No
1
N
OnDataMissing DataVarChar
N) Skip to Next Document
B) Skip to Next Customer
W) Ask for User Confirmation
1
N
OnLedgerBookkeeping AlertVarChar
N) Skip to Next Document
B) Skip to Next Customer
W) Ask for User Confirmation
1
N
OnInvntWarehouse AlertVarChar
N) Skip to Next Document
B) Skip to Next Customer
W) Ask for User Confirmation
1
N
SummarySummarynVarChar
127
AltItmDocsProcess docsc with alt. itemsVarChar
Y) Yes
N) No
1
Y
PartDelivrPartial DeliveryVarChar
Y) Yes
N) No
1
N
ConsiderBPConsider BPVarChar
Y) Yes
N) No
1
Y
ConsiderTyConsider TypeVarChar
Y) Yes
N) No
1
Y
EDocGenTypElectr. Doc. Generation TypeVarChar
G) Generate
L) Generate - Later
S) Send
R) Send - Later
N) Not Relevant
1
N
ESeriesElectronic SeriesInt
6NNM4
Electronic Series
EDocNumElectronic Document NumbernVarChar
20
ReopOriRdrReopen Origin. Order by ReturnVarChar
Y) Yes
N) No
1
N
ReopManClsReop. Man. Closed/Canc. OrdersVarChar
Y) Yes
N) No
1
N
SeqCodeTarget Doc. NF Sequence CodeInt
6
UseBaseSeqUse Base Document NF SequenceVarChar
Y) Yes
N) No
1
N
OnSeqCodeMissing NF SequenceVarChar
N) Skip to Next Document
T) Use NF Sequence from Step 2
1
N
BPLIdBranchInt
11OBPL
Business Place
BlckFrOnlyBlock Docs. with Zero ItemsVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT ODGP.AbsEntry AS 'Internal Number', ODGP.SetName AS 'Set Name', ODGP.SetDesc AS 'Set Description', ODGP.CreateDate AS 'Creation Date', ODGP.ModifyDate AS 'Last Modified', ODGP.UserSign AS 'User Signature', ODGP.Target AS 'Target Document Type', ODGP.PostDate AS 'Posting Date', ODGP.TaxDate AS 'Document Date', ODGP.Series AS 'Series', ODGP.Items AS 'Items Documents Summary', ODGP.ItemSmmry AS 'Items Summary Method', ODGP.Service AS 'Service Documents Summary', ODGP.ServSmmry AS 'Service Summary Method', ODGP.ExchgRate AS 'Exchange Rate', ODGP.CreatDraft AS 'Create Drafts', ODGP.BaseQUT AS 'Sales Quotation Summary', ODGP.BaseRDR AS 'Order Summary', ODGP.BaseDLN AS 'Delivery Summary', ODGP.BaseRDN AS 'Returns Summary', ODGP.BaseResINV AS 'A/R Reserve Invoice Summary', ODGP.ExpndSel AS 'Expanded Selection Criteria', ODGP.SortField AS 'Sort Field', ODGP.Consolidat AS 'Consolidate', ODGP.ExpandCons AS 'Expanded Consolidation Options', ODGP.RCNSummary AS 'Reference Document', ODGP.ChainCode AS 'Retail Chain', ODGP.OredrNum1 AS 'Order No. From', ODGP.OredrNum2 AS 'To', ODGP.Direct AS 'Direct', ODGP.Indirect AS 'Indirect', ODGP.DoReport AS 'Overview of Invoice Deliveries', ODGP.FileExport AS 'File Export', ODGP.SavePath AS 'File Path', ODGP.DealNum AS 'Closing No.', ODGP.UseDirect AS 'Direct/Indirect', ODGP.NoItmCode AS 'Drop Item No. Where Cat. No. E', ODGP.OnData AS 'Missing Data', ODGP.OnLedger AS 'Bookkeeping Alert', ODGP.OnInvnt AS 'Warehouse Alert', ODGP.Summary AS 'Summary', ODGP.AltItmDocs AS 'Process docsc with alt. items', ODGP.PartDelivr AS 'Partial Delivery', ODGP.ConsiderBP AS 'Consider BP', ODGP.ConsiderTy AS 'Consider Type', ODGP.EDocGenTyp AS 'Electr. Doc. Generation Type', ODGP.ESeries AS 'Electronic Series', ODGP.EDocNum AS 'Electronic Document Number', ODGP.ReopOriRdr AS 'Reopen Origin. Order by Return', ODGP.ReopManCls AS 'Reop. Man. Closed/Canc. Orders', ODGP.SeqCode AS 'Target Doc. NF Sequence Code', ODGP.UseBaseSeq AS 'Use Base Document NF Sequence', ODGP.OnSeqCode AS 'Missing NF Sequence', ODGP.BPLId AS 'Branch', ODGP.BlckFrOnly AS 'Block Docs. with Zero Items' FROM ODGP AS ODGP

Related information


ODGP SQL Table

Business Place OBPL SQL Table

Electronic Series NNM4 SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates