|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Print Preferences
Table Name: AADP
Table Description: Print Preferences
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| PrintId | Print Number | nVarChar | 4 | - | Â | Â | Â |
| ObjList | Object List | nVarChar | 11 | - | 13 | 1470000049 | Capitalization |
| Â | Â | Â | Â | Â | Â | 1470000071 | Depreciation Run |
| Â | Â | Â | Â | Â | Â | 1470000090 | Fixed Asset Transfer |
| Â | Â | Â | Â | Â | Â | 23 | Sales Quotation |
| Â | Â | Â | Â | Â | Â | 17 | Sales Order |
| Â | Â | Â | Â | Â | Â | 15 | Delivery |
| Â | Â | Â | Â | Â | Â | 234000031 | Return Request |
| Â | Â | Â | Â | Â | Â | 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 |
| Â | Â | Â | Â | Â | Â | 1470000113 | Purchase Request |
| Â | Â | Â | Â | Â | Â | 540000006 | Purchase Quotation |
| Â | Â | Â | Â | Â | Â | 22 | Purchase Order |
| Â | Â | Â | Â | Â | Â | 20 | Goods Receipt PO |
| Â | Â | Â | Â | Â | Â | 234000032 | Goods Return Request |
| Â | Â | Â | Â | Â | Â | 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 |
| Â | Â | Â | Â | Â | Â | 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 |
| Â | Â | Â | Â | Â | Â | 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 |
| Â | Â | Â | Â | Â | Â | 191 | Service Call |
| Â | Â | Â | Â | Â | Â | 190 | Service Contract |
| Â | Â | Â | Â | Â | Â | 176 | Equipment Card |
| Â | Â | Â | Â | Â | Â | 88 | Entrada |
| Â | Â | Â | Â | Â | Â | 89 | Salida |
| Â | Â | Â | Â | Â | Â | 90 | Traspaso |
| Â | Â | Â | Â | Â | Â | 132 | Correction Invoice |
| Â | Â | Â | Â | Â | Â | 234000021 | Project Management Document |
| MaxLineNum | Max. Rows per Page | Int | 6 | - | 99 | Â | Â |
| TopMrgn | Top Margin Width | Int | 6 | - | Â | Â | Â |
| BtmMrgn | Bottom Margin Width | Int | 6 | - | Â | Â | Â |
| LftMrgn | Left Margin Width | Int | 6 | - | Â | Â | Â |
| RgtMrgn | Right Margin Width | Int | 6 | - | Â | Â | Â |
| PrnCompany | Print on Company Paper | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MnhlNote | Text Printed by PLD | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MaxWordLin | Max. Rows for Export | Int | 6 | - | 10 | Â | Â |
| V_Compress | Compress Vertically | Int | 6 | - | 100 | 50 | 50 |
| Â | Â | Â | Â | Â | Â | 60 | 60 |
| Â | Â | Â | Â | Â | Â | 70 | 70 |
| Â | Â | Â | Â | Â | Â | 80 | 80 |
| Â | Â | Â | Â | Â | Â | 90 | 90 |
| Â | Â | Â | Â | Â | Â | 100 | 100 |
| Â | Â | Â | Â | Â | Â | 110 | 110 |
| Â | Â | Â | Â | Â | Â | 120 | 120 |
| Â | Â | Â | Â | Â | Â | 130 | 130 |
| Â | Â | Â | Â | Â | Â | 140 | 140 |
| Â | Â | Â | Â | Â | Â | 150 | 150 |
| WordPath | WORD Template Path | Text | 16 | - | Â | Â | Â |
| BitmapPath | Picture Path | Text | 16 | - | Â | Â | Â |
| PrintMeta | Print as Picture | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PrintRcpt | Print Receipt | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | A | Only When Adding |
| Â | Â | Â | Â | Â | Â | Y | Always |
| ShortRcpt | Print Payment with Invoice | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ExportCode | Export Material/Account Code | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AttachPath | Attachments Path | Text | 16 | - | Â | Â | Â |
| DraftNote | Print Draft Note | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ExtPath | Extensions Path | Text | 16 | - | Â | Â | Â |
| DmePath | DME Files Store Path | Text | 16 | - | Â | Â | Â |
| SNType | Serial Number Type | Int | 6 | - | 2 | 1 | Mfr Serial No. |
| Â | Â | Â | Â | Â | Â | 2 | Serial No. |
| Â | Â | Â | Â | Â | Â | 3 | Lot Number |
| GBIPath | GB Data Interface Path | Text | 16 | - | Â | Â | Â |
| LogoFile | Logo File | nVarChar | 200 | - | Â | Â | Â |
| LogoImage | Logo Image | Text | 16 | - | Â | Â | Â |
| B1Server | Business One Server Address | Text | 16 | - | Â | Â | Â |
| IsTrustSrv | Always Trust This Server | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| SnapShotId | Snapshot ID | Int | 11 | - | 0 | Â | Â |
| DefirExpP | Export Folder | Text | 16 | - | Â | Â | Â |
| DefirDemop | DEFIR Database Path | Text | 16 | - | Â | Â | Â |
| PrintPDF | Generate PDF When Printing | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PrtCancel | Print Watermark on Cancl. Docs | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PrtUseSys | Use System Print Preferences | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RptList | Report List | nVarChar | 20 | - | 1 | 1 | Aging Report |
| Â | Â | Â | Â | Â | Â | 2 | Dunning Wizard |
| PreAttach | Previous Attachment Path | Text | 16 | - | Â | Â | Â |
| ExportPDF | Export PDF to Dflt Attachment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AttachPDF | Attach Exported PDF to Doc | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| GSTPath | GST ANX Report Path | Text | 16 | - | Â | Â | Â |
| CRNote | Text Printed by Crystal Reports | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| UpdateTS | Update Full Time | Int | 11 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| GSTRtnPath | GST Return Path | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | PrintId |
| Â | Â | LogInstanc |