| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | PrintId | Print Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 2 | ObjList | Object List | int | 11 | 0 | | 13 | 10000071=Inventory Posting, 1250000001=Inventory Transfer Request, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 1470000049=Capitalization, 1470000065=Inventory Counting, 1470000071=Depreciation Run, 1470000090=Fixed Asset Transfer, 1470000113=Purchase Request, 14=A/R Credit M | Allow NULL? |
| 3 | MaxLineNum | Max. Rows per Page | int | 6 | 0 | | 99 | | Allow NULL? |
| 4 | TopMrgn | Top Margin Width | int | 6 | 0 | | | | Allow NULL? |
| 5 | BtmMrgn | Bottom Margin Width | int | 6 | 0 | | | | Allow NULL? |
| 6 | LftMrgn | Left Margin Width | int | 6 | 0 | | | | Allow NULL? |
| 7 | RgtMrgn | Right Margin Width | int | 6 | 0 | | | | Allow NULL? |
| 8 | PrnCompany | Print on Company Paper | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 9 | MnhlNote | Text Printed by PLD | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 10 | MaxWordLin | Max. Rows for Export | int | 6 | 0 | | 10 | | Allow NULL? |
| 11 | V_Compress | Compress Vertically | int | 6 | 0 | | 100 | 100=100, 110=110, 120=120, 130=130, 140=140, 150=150, 50=50, 60=60, 70=70, 80=80, 90=90 | Allow NULL? |
| 12 | WordPath | WORD Template Path | text | 16 | 0 | | | | |
| 13 | BitmapPath | Picture Path | text | 16 | 0 | | | | |
| 14 | PrintMeta | Print as Picture | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 15 | PrintRcpt | Print Receipt | char | 1 | 0 | | N | A=Only When Adding, N=No, Y=Always | Allow NULL? |
| 16 | ShortRcpt | Print Payment with Invoice | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 17 | ExportCode | Export Material/Account Code | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 18 | AttachPath | Attachments Path | text | 16 | 0 | | | | |
| 19 | DraftNote | Print Draft Note | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 20 | ExtPath | Extensions Path | text | 16 | 0 | | | | |
| 21 | DmePath | DME Files Store Path | text | 16 | 0 | | | | |
| 22 | SNType | Serial Number Type | int | 6 | 0 | | 2 | 1=Mfr Serial No., 2=Serial No., 3=Lot Number | Allow NULL? |
| 23 | GBIPath | GB Data Interface Path | text | 16 | 0 | | | | |
| 24 | LogoFile | Logo File | nvarchar | 200 | 0 | | | | Allow NULL? |
| 25 | LogoImage | Logo Image | text | 16 | 0 | | | | |
| 26 | B1Server | Business One Server Address | text | 16 | 0 | | | | |
| 27 | IsTrustSrv | Always Trust This Server | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 28 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 29 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 30 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 31 | SnapShotId | Snapshot ID | int | 11 | 0 | | 0 | | Allow NULL? |
| 32 | DefirExpP | Export Folder | text | 16 | 0 | | | | |
| 33 | DefirDemop | DEFIR Database Path | text | 16 | 0 | | | | |
| 34 | PrintPDF | Generate PDF When Printing | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 35 | PrtCancel | Print Watermark on Cancl. Docs | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 36 | PrtUseSys | Use System Print Preferences | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 37 | RptList | Report List | nvarchar | 20 | 0 | | 1 | 1=Aging Report, 2=Dunning Wizard | Allow NULL? |
| 38 | PreAttach | Previous Attachment Path | text | 16 | 0 | | | | |
| 39 | ExportPDF | Export PDF to Dflt Attachment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 40 | AttachPDF | Attach Exported PDF to Doc | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
