biuan SAP® BUSINESS ONE SDK
SQL Administration / Print Preferences
DTW Purchasing / Purchase Tax Invoice
API AADP
AADP - Print Preferences Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PrintId KEY UNIQUEPrint NumbernVarChar
4
PRIMARYYes
ObjListObject ListInt
1470000049) Capitalization
1470000071) Depreciation Run
1470000090) Fixed Asset Transfer
(-0) (-
23) Sales Quotation
17) Sales Order
15) Delivery
16) Returns
203) A/R Down Payment
13) A/R Invoice
165) A/R Correction Invoice
166) A/R Correction Invoice Reversal
14) A/R Credit Memo
(-1) (-
1470000113) Purchase Request
540000006) Purchase Quotation
22) Purchase Order
20) Goods Receipt PO
21) Goods Return
204) A/P Down Payment
18) A/P Invoice
163) A/P Correction Invoice
164) A/P Correction Invoice Reversal
19) A/P Credit Memo
69) Landed Costs
(-2) (-
24) Incoming Payment
25) Deposit
46) Outgoing Payment
76) Postdated Deposit
57) Check for Payment
30) Journal Entry
28) Journal Voucher
140000010) Incoming Excise Invoice
140000009) Outgoing Excise Invoice
(-3) (-
59) Goods Receipt
60) Goods Issue
1250000001) Inventory Transfer Request
67) Inventory Transfer
68) Work Instructions
202) Production Order
162) Inventory Revaluation
156) Pick List
1470000065) Inventory Counting
10000071) Inventory Posting
310000001) Inventory Opening Balances
(-4) (-
88) Entrada
89) Salida
90) Traspaso
132) Correction Invoice
11
13
MaxLineNumMax. Rows per PageInt
6
99
TopMrgnTop Margin WidthInt
6
BtmMrgnBottom Margin WidthInt
6
LftMrgnLeft Margin WidthInt
6
RgtMrgnRight Margin WidthInt
6
PrnCompanyPrint on Company PaperVarChar
Y) Yes
N) No
1
N
MnhlNoteText Printed by PLDVarChar
Y) Yes
N) No
1
Y
MaxWordLinMax. Rows for ExportInt
6
10
V_CompressCompress VerticallyInt
50) 50
60) 60
70) 70
80) 80
90) 90
100) 100
110) 110
120) 120
130) 130
140) 140
150) 150
6
100
WordPathWORD Template PathText
16
BitmapPathPicture PathText
16
PrintMetaPrint as PictureVarChar
Y) Yes
N) No
1
N
PrintRcptPrint ReceiptVarChar
N) No
A) Only When Adding
Y) Always
1
N
ShortRcptPrint Payment with InvoiceVarChar
Y) Yes
N) No
1
N
ExportCodeExport Material/Account CodeVarChar
Y) Yes
N) No
1
N
AttachPathAttachments PathText
16
DraftNotePrint Draft NoteVarChar
Y) Yes
N) No
1
Y
ExtPathExtensions PathText
16
DmePathDME Files Store PathText
16
SNTypeSerial Number TypeInt
1) Mfr Serial No.
2) Serial No.
3) Lot Number
6
2
GBIPathGB Data Interface PathText
16
LogoFileLogo FilenVarChar
127
LogoImageLogo ImageText
16
B1ServerBusiness One Server AddressText
16
IsTrustSrvAlways Trust This ServerVarChar
Y) Yes
N) No
1
N
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
UserSign2Updating UserInt
6OUSR
Users
SnapShotIdSnapshot IDInt
11
0
DefirExpPExport FolderText
16
DefirDemopDEFIR Database PathText
16
PrintPDFGenerate PDF When PrintingVarChar
Y) Yes
N) No
1
N
PrtCancelPrint Watermark on Cancl. DocsVarChar
Y) Yes
N) No
1
Y
PrtUseSysUse System Print PreferencesVarChar
Y) Yes
N) No
1
N
RptListReport ListnVarChar
1) Aging Report
2) Dunning Wizard
20
1
PreAttachPrevious Attachment PathText
16

SELECT statement

SELECT AADP.PrintId AS 'Print Number', AADP.ObjList AS 'Object List', AADP.MaxLineNum AS 'Max. Rows per Page', AADP.TopMrgn AS 'Top Margin Width', AADP.BtmMrgn AS 'Bottom Margin Width', AADP.LftMrgn AS 'Left Margin Width', AADP.RgtMrgn AS 'Right Margin Width', AADP.PrnCompany AS 'Print on Company Paper', AADP.MnhlNote AS 'Text Printed by PLD', AADP.MaxWordLin AS 'Max. Rows for Export', AADP.V_Compress AS 'Compress Vertically', AADP.WordPath AS 'WORD Template Path', AADP.BitmapPath AS 'Picture Path', AADP.PrintMeta AS 'Print as Picture', AADP.PrintRcpt AS 'Print Receipt', AADP.ShortRcpt AS 'Print Payment with Invoice', AADP.ExportCode AS 'Export Material/Account Code', AADP.AttachPath AS 'Attachments Path', AADP.DraftNote AS 'Print Draft Note', AADP.ExtPath AS 'Extensions Path', AADP.DmePath AS 'DME Files Store Path', AADP.SNType AS 'Serial Number Type', AADP.GBIPath AS 'GB Data Interface Path', AADP.LogoFile AS 'Logo File', AADP.LogoImage AS 'Logo Image', AADP.B1Server AS 'Business One Server Address', AADP.IsTrustSrv AS 'Always Trust This Server', AADP.LogInstanc AS 'Log Instance', AADP.UpdateDate AS 'Date of Update', AADP.UserSign2 AS 'Updating User', AADP.SnapShotId AS 'Snapshot ID', AADP.DefirExpP AS 'Export Folder', AADP.DefirDemop AS 'DEFIR Database Path', AADP.PrintPDF AS 'Generate PDF When Printing', AADP.PrtCancel AS 'Print Watermark on Cancl. Docs', AADP.PrtUseSys AS 'Use System Print Preferences', AADP.RptList AS 'Report List', AADP.PreAttach AS 'Previous Attachment Path' FROM AADP AS AADP

Related information


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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates