| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | PrintId | Print No. | nvarchar | 4 | 0 | | | | Allow NULL? |
| 2 | ObjType | Object Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | Copies | No. of Copies | int | 6 | 0 | | 1 | | Allow NULL? |
| 4 | PrintOnAdd | Add & Print | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 5 | ExprtOnAdd | Add & Export | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 6 | RoundSums | Rounding Amounts | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 7 | Remark | Standard Remarks | text | 16 | 0 | | | | |
| 8 | PrintSums | Print Totals | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 9 | VndrNum | Print Mfr Catalog No. | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 10 | PrnDscnt | Print Discount Data | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 11 | SplitTran1 | Split Transaction 1 | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 12 | SplitTran2 | Split Transaction 2 | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 13 | SplitTran3 | Split Transaction 3 | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 14 | ShowBothNu | Print Mfr Catalog No. Instead | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 15 | BaseRmrk | Display Base Remarks | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 16 | HandCopies | No. of Copies for Manual Doc. | int | 6 | 0 | | 1 | | Allow NULL? |
| 17 | EngKBItem | Switch to English Keyboard when Entering an Item | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 18 | EngKBCard | Switch to English Keyboard when Entering a BP | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 19 | OrdrPicDef | Set Pick Order as Default | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 20 | SpltTrBOE1 | Split Bill of Exchange Transaction | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 21 | LineNumPPg | Row Item Number Per Page | int | 6 | 0 | | 5 | | Allow NULL? |
| 22 | JENumPPg | Journal Entry Number Per Page | int | 6 | 0 | | 2 | | Allow NULL? |
| 23 | CashPay | Remark for Cash Payments | text | 16 | 0 | | | | |
| 24 | NonCashPay | Remark for Non-Cash Payments | text | 16 | 0 | | | | |
| 25 | MaxUOPay | Max. Under/Overpayment Amount | num | 19 | 6 | | | | Allow NULL? |
| 26 | CkeckPaper | Paper for Checks | char | 1 | 0 | | S | B, P, S | Allow NULL? |
| 27 | AllowFuPos | Allow Future Posting | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 28 | ErdOutMode | ERD Mode for Outgoing Payments | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 29 | ErdIncMode | ERD Mode for Incoming Payments | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 30 | ChkDupRef | Check Duplicate BP Reference Number | char | 1 | 0 | | N | B, N, W | Allow NULL? |
| 31 | CpyCVRef | Copy BP Reference Number | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 32 | BatchSerPr | Batch/Serial No. Print Definitions | char | 1 | 0 | | A | A, B, D | Allow NULL? |
| 33 | YearTrans | Display Transaction in Payment | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 34 | ReconJeSer | Reconciliation JE Series | int | 6 | 0 | | 0 | | Allow NULL? |
| 35 | ReopOrder | Enable Reopen Orders by Return | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 36 | ForceReOrd | Always Reopen Orders by Return | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 37 | PrintRows | Print Rows | char | 1 | 0 | | A | A, M, T | Allow NULL? |
| 38 | orderblock | Block Early Posting Date | char | 1 | 0 | | N | N, Y | Allow NULL? |
