biuan SAP® BUSINESS ONE SDK
SQL Administration / User Defaults - Documents / Object Settings - History
DTW Administration / Setup / General / User Default Groups / Object Settings - History
API Default Documents / Add Export
ADP1 - Object Settings - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PrintId KEY UNIQUEPrint No.nVarChar
4OADP
Print Preferences		PRIMARYYes
ObjType KEY UNIQUEObject TypenVarChar
20
OBJECTYes
CopiesNo. of CopiesInt
6
1
PrintOnAddAdd & PrintVarChar
Y) Yes
N) No
1
N
ExprtOnAddAdd & ExportVarChar
Y) Yes
N) No
1
N
RoundSumsRounding AmountsVarChar
Y) Yes
N) No
1
N
RemarkStandard RemarksText
16
PrintSumsPrint TotalsVarChar
Y) Yes
N) No
1
Y
VndrNumPrint Mfr Catalog No.VarChar
Y) Yes
N) No
1
N
PrnDscntPrint Discount DataVarChar
Y) Yes
N) No
1
Y
SplitTran1Split Transaction 1VarChar
Y) Yes
N) No
1
N
SplitTran2Split Transaction 2VarChar
Y) Yes
N) No
1
Y
SplitTran3Split Transaction 3VarChar
Y) Yes
N) No
1
Y
ShowBothNuPrint Mfr Catalog No. InsteadVarChar
Y) Yes
N) No
1
N
BaseRmrkDisplay Base RemarksVarChar
Y) Yes
N) No
1
Y
HandCopiesNo. of Copies for Manual Doc.Int
6
1
EngKBItemSwitch to English Keyboard when EnteringVarChar
Y) Yes
N) No
1
N
EngKBCardSwitch to English Keyboard when EnteringVarChar
Y) Yes
N) No
1
N
OrdrPicDefSet Pick Order as DefaultVarChar
Y) Yes
N) No
1
N
SpltTrBOE1Split Bill of Exchange TransactionVarChar
Y) Yes
N) No
1
N
LineNumPPgRow Item Number Per PageInt
6
5
JENumPPgJournal Entry Number Per PageInt
6
2
CashPayRemark for Cash PaymentsText
16
NonCashPayRemark for Non-Cash PaymentsText
16
MaxUOPayMax. Under/Overpayment AmountNum
20
CkeckPaperPaper for ChecksVarChar
B) Blank Paper
S) Overflow Check Stock
P) Overflow Blank Paper
1
S
AllowFuPosAllow Future PostingVarChar
Y) Yes
N) No
1
N
ErdOutModeERD Mode for Outgoing PaymentsVarChar
Y) Yes
N) No
1
N
ErdIncModeERD Mode for Incoming PaymentsVarChar
Y) Yes
N) No
1
N
ChkDupRefCheck Duplicate BP Reference NumberVarChar
N) Without Warning
W) Warning Only
B) Block Release
1
N
CpyCVRefCopy BP Reference NumberVarChar
N) No
Y) Yes
1
N
BatchSerPrBatch/Serial No. Print DefinitionsVarChar
A) Document and Batch/Serial No.
D) Document Only
B) Batch/Serial No. Only
1
A
YearTransDisplay Transaction in PaymentVarChar
N) No
Y) Yes
1
N
ReconJeSerReconciliation JE SeriesInt
6
0
ReopOrderEnable Reopen Orders by ReturnVarChar
N) No
Y) Yes
1
N
ForceReOrdAlways Reopen Orders by ReturnVarChar
N) No
Y) Yes
1
N
PrintRowsPrint RowsVarChar
A) All Rows
M) All Modified Rows
T) Modified Rows Excl. Tax Amount
1
A
orderblockBlock Early Posting DateVarChar
Y) Yes
N) No
1
N
RecomPkgRecommend PackagingVarChar
N) No
Y) Yes
1
N
EnitemcostEnable Setting Item CostVarChar
Y) Yes
N) No
1
N
ClosePQClose Related PQVarChar
Y) Yes
N) No
1
Y
CpyPRPriceEnable Copying PR PriceVarChar
Y) Yes
N) No
1
N
EnSetCostEnable Setting Cost By DefaultVarChar
1
N
DftPLChkDefault Price List CheckVarChar
1
N
DfltPLSelDefault Price List SelectionInt
6
-1
EmailOnAddAdd & E-MailVarChar
Y) Yes
N) No
1
N
PDFOnAddAdd & Export to PDFVarChar
Y) Yes
N) No
1
N
EmailSbjE-Mail SubjectnVarChar
127
EmailBodyE-Mail BodyText
16

Table relationship map

SELECT statement

SELECT ADP1.PrintId AS 'Print No.', ADP1.ObjType AS 'Object Type', ADP1.Copies AS 'No. of Copies', ADP1.PrintOnAdd AS 'Add & Print', ADP1.ExprtOnAdd AS 'Add & Export', ADP1.RoundSums AS 'Rounding Amounts', ADP1.Remark AS 'Standard Remarks', ADP1.PrintSums AS 'Print Totals', ADP1.VndrNum AS 'Print Mfr Catalog No.', ADP1.PrnDscnt AS 'Print Discount Data', ADP1.SplitTran1 AS 'Split Transaction 1', ADP1.SplitTran2 AS 'Split Transaction 2', ADP1.SplitTran3 AS 'Split Transaction 3', ADP1.ShowBothNu AS 'Print Mfr Catalog No. Instead', ADP1.BaseRmrk AS 'Display Base Remarks', ADP1.HandCopies AS 'No. of Copies for Manual Doc.', ADP1.EngKBItem AS 'Switch to English Keyboard when Entering', ADP1.EngKBCard AS 'Switch to English Keyboard when Entering', ADP1.OrdrPicDef AS 'Set Pick Order as Default', ADP1.SpltTrBOE1 AS 'Split Bill of Exchange Transaction', ADP1.LineNumPPg AS 'Row Item Number Per Page', ADP1.JENumPPg AS 'Journal Entry Number Per Page', ADP1.CashPay AS 'Remark for Cash Payments', ADP1.NonCashPay AS 'Remark for Non-Cash Payments', ADP1.MaxUOPay AS 'Max. Under/Overpayment Amount', ADP1.CkeckPaper AS 'Paper for Checks', ADP1.AllowFuPos AS 'Allow Future Posting', ADP1.ErdOutMode AS 'ERD Mode for Outgoing Payments', ADP1.ErdIncMode AS 'ERD Mode for Incoming Payments', ADP1.ChkDupRef AS 'Check Duplicate BP Reference Number', ADP1.CpyCVRef AS 'Copy BP Reference Number', ADP1.BatchSerPr AS 'Batch/Serial No. Print Definitions', ADP1.YearTrans AS 'Display Transaction in Payment', ADP1.ReconJeSer AS 'Reconciliation JE Series', ADP1.ReopOrder AS 'Enable Reopen Orders by Return', ADP1.ForceReOrd AS 'Always Reopen Orders by Return', ADP1.PrintRows AS 'Print Rows', ADP1.orderblock AS 'Block Early Posting Date', ADP1.RecomPkg AS 'Recommend Packaging', ADP1.Enitemcost AS 'Enable Setting Item Cost', ADP1.ClosePQ AS 'Close Related PQ', ADP1.CpyPRPrice AS 'Enable Copying PR Price', ADP1.EnSetCost AS 'Enable Setting Cost By Default', ADP1.DftPLChk AS 'Default Price List Check', ADP1.DfltPLSel AS 'Default Price List Selection', ADP1.EmailOnAdd AS 'Add & E-Mail', ADP1.PDFOnAdd AS 'Add & Export to PDF', ADP1.EmailSbj AS 'E-Mail Subject', ADP1.EmailBody AS 'E-Mail Body' FROM ADP1 AS ADP1

Related information


Add Export AddExport Property· Table: ADP1
Determines the default for whether or not to also export the document to Microsoft Word format when the user clicks the Add button (adds the document to the system). Field name: ExprtOnAdd.
· Table: UDG1    Parent: Default Documents DefaultDocuments Object· Table: UDG1
ADP1 SQL Table

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