| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | PrintId | Print No. | nvarchar | 4 | 0 | OADP | | | 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=No, Y=Yes | Allow NULL? |
| 5 | ExprtOnAdd | Add & Export | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 6 | RoundSums | Rounding Amounts | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 7 | Remark | Standard Remarks | text | 16 | 0 | | | | |
| 8 | PrintSums | Print Totals | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 9 | VndrNum | Print Mfr Catalog No. | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 10 | PrnDscnt | Print Discount Data | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 11 | SplitTran1 | Split Transaction 1 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 12 | SplitTran2 | Split Transaction 2 | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 13 | SplitTran3 | Split Transaction 3 | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 14 | ShowBothNu | Print Mfr Catalog No. Instead | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 15 | BaseRmrk | Display Base Remarks | char | 1 | 0 | | Y | N=No, Y=Yes | 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=No, Y=Yes | Allow NULL? |
| 18 | EngKBCard | Switch to English Keyboard when Entering a BP | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 19 | OrdrPicDef | Set Pick Order as Default | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 20 | SpltTrBOE1 | Split Bill of Exchange Transaction | char | 1 | 0 | | N | N=No, Y=Yes | 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=Blank Paper, P=Overflow Blank Paper, S=Overflow Check Stock | Allow NULL? |
| 27 | AllowFuPos | Allow Future Posting | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 28 | ErdOutMode | ERD Mode for Outgoing Payments | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 29 | ErdIncMode | ERD Mode for Incoming Payments | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 30 | ChkDupRef | Check Duplicate BP Reference Number | char | 1 | 0 | | N | B=Block Release, N=Without Warning, W=Warning Only | Allow NULL? |
| 31 | CpyCVRef | Copy BP Reference Number | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 32 | BatchSerPr | Batch/Serial No. Print Definitions | char | 1 | 0 | | A | A=Document and Batch/Serial No., B=Batch/Serial No. Only, D=Document Only | Allow NULL? |
| 33 | YearTrans | Display Transaction in Payment | char | 1 | 0 | | N | N=No, Y=Yes | 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=No, Y=Yes | Allow NULL? |
| 36 | ForceReOrd | Always Reopen Orders by Return | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 37 | PrintRows | Print Rows | char | 1 | 0 | | A | A=All Rows, M=All Modified Rows, T=Modified Rows Excl. Tax Amount | Allow NULL? |
| 38 | orderblock | Block Early Posting Date | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 39 | RecomPkg | Recommend Packaging | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 40 | Enitemcost | Enable Setting Item Cost | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 41 | ClosePQ | Close Related PQ | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 42 | CpyPRPrice | Enable Copying PR Price | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 43 | EnSetCost | Enable Setting Cost By Default | char | 1 | 0 | | N | | Allow NULL? |
| 44 | DftPLChk | Default Price List Check | char | 1 | 0 | | N | | Allow NULL? |
| 45 | DfltPLSel | Default Price List Selection | int | 6 | 0 | | -1 | | Allow NULL? |
| 46 | EmailOnAdd | Add & E-Mail | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 47 | PDFOnAdd | Add & Export to PDF | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 48 | EmailSbj | E-Mail Subject | nvarchar | 254 | 0 | | | | Allow NULL? |
| 49 | EmailBody | E-Mail Body | text | 16 | 0 | | | | |
| 50 | BlockWHT08 | Block payment in local currency WHT 08 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 51 | BlockExprt | Block Export to Word | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 52 | BlockPrint | Block print document | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 53 | BlockMail | Block Email Document | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 54 | BlockToPDF | Block Export to PDF | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 55 | BlockFax | Block Sent to Fax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 56 | PoDropPrss | PO Drop-Ship Process | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 57 | ShowCash | Allow Cash Accounts Only | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 58 | PRUseBPTax | Purchase Request use BP Tax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
