| 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 | (-=(-, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 156=Pick List, 15=Delivery, 162=Inventory Revaluation, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sale | 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 | | | | |