|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Object Settings - History
Table Name: AADP1
Table Description: Object Settings - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| PrintId | Print No. | nVarChar | 4 | OADP | Â | Â | Â |
| ObjType | Object Type | 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 |
| Copies | No. of Copies | Int | 6 | - | 1 | Â | Â |
| PrintOnAdd | Add & Print | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ExprtOnAdd | Add & Export | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RoundSums | Rounding Amounts | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Remark | Standard Remarks | Text | 16 | - | Â | Â | Â |
| PrintSums | Print Totals | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| VndrNum | Print Mfr Catalog No. | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PrnDscnt | Print Discount Data | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SplitTran1 | Split Transaction 1 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SplitTran2 | Split Transaction 2 | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SplitTran3 | Split Transaction 3 | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ShowBothNu | Print Mfr Catalog No. Instead | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BaseRmrk | Display Base Remarks | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| HandCopies | No. of Copies for Manual Doc. | Int | 6 | - | 1 | Â | Â |
| EngKBItem | Switch to English Keyboard when Entering an Item | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EngKBCard | Switch to English Keyboard When Entering a BP | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| OrdrPicDef | Set Pick Order as Default | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SpltTrBOE1 | Split Bill of Exchange Transaction | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LineNumPPg | Row Item Number Per Page | Int | 6 | - | 5 | Â | Â |
| JENumPPg | Journal Entry Number Per Page | Int | 6 | - | 2 | Â | Â |
| CashPay | Remark for Cash Payments | Text | 16 | - | Â | Â | Â |
| NonCashPay | Remark for Non-Cash Payments | Text | 16 | - | Â | Â | Â |
| MaxUOPay | Max. Under/Overpayment Amount | Num | 19.6 | - | Â | Â | Â |
| CkeckPaper | Paper for Checks | VarChar | 1 | - | S | B | Blank Paper |
| Â | Â | Â | Â | Â | Â | S | Overflow Check Stock |
| Â | Â | Â | Â | Â | Â | P | Overflow Blank Paper |
| AllowFuPos | Allow Future Posting | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ErdOutMode | ERD Mode for Outgoing Payments | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ErdIncMode | ERD Mode for Incoming Payments | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ChkDupRef | Check Duplicate BP Reference Number | VarChar | 1 | - | N | N | Without Warning |
| Â | Â | Â | Â | Â | Â | W | Warning Only |
| Â | Â | Â | Â | Â | Â | B | Block Release |
| CpyCVRef | Copy BP Reference Number | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| BatchSerPr | Batch/Serial No. Print Definitions | VarChar | 1 | - | A | A | Document and Batch/Serial No. |
| Â | Â | Â | Â | Â | Â | D | Document Only |
| Â | Â | Â | Â | Â | Â | B | Batch/Serial No. Only |
| YearTrans | Display Transaction in Payment | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| ReconJeSer | Reconciliation JE Series | Int | 6 | - | 0 | Â | Â |
| ReopOrder | Enable Reopen Orders by Return | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| ForceReOrd | Always Reopen Orders by Return | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| PrintRows | Print Rows | VarChar | 1 | - | A | A | All Rows |
| Â | Â | Â | Â | Â | Â | M | All Modified Rows |
| Â | Â | Â | Â | Â | Â | T | Modified Rows Excl. Tax Amount |
| orderblock | Block Early Posting Date | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RecomPkg | Recommend Packaging | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| Enitemcost | Enable Setting Item Cost | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ClosePQ | Close Related PQ | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CpyPRPrice | Enable Copying PR Price | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnSetCost | Enable Setting Cost By Default | VarChar | 1 | - | N | Â | Â |
| DftPLChk | Default Price List Check | VarChar | 1 | - | N | Â | Â |
| DfltPLSel | Default Price List Selection | Int | 6 | - | -1 | Â | Â |
| EmailOnAdd | Add & Email | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PDFOnAdd | Add & Export to PDF | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EmailSbj | E-Mail Subject | nVarChar | 254 | - | Â | Â | Â |
| EmailBody | Email Body | Text | 16 | - | Â | Â | Â |
| BlockWHT08 | Block Payment in Local Currency WHT 08 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BlockExprt | Block Export to Word | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| BlockPrint | Block Printing Documents | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| BlockMail | Block Email Document | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| BlockToPDF | Block Export to PDF | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| BlockFax | Block Sent to Fax | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| PoDropPrss | PO Drop-Ship Process | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ShowCash | Allow Cash Accounts Only | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PRUseBPTax | Purchase Request use BP Tax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblTtlEgD | Apply Exchange Rate of Drawn Down Payments | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblUpdUDF | Enable Updating UDF | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnblDpmTax | Enable Tax Calculation in Down Payment Invoices | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ChkRefBP | Validate on Customer Level | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ChkRefYear | Validate on Fiscal Year Level | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BspDpmType | Down Payment Type for BSP | VarChar | 1 | - | E | E | Â |
| Â | Â | Â | Â | Â | Â | R | Down Payment Request |
| Â | Â | Â | Â | Â | Â | I | Down Payment Invoice |
| ReopenByC | Enable the Displaying of Base Document Items When Target Documents Are Canceled | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| ForceReByC | Always Display Base Document Items When Target Documents Are Canceled | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| OpenSnB | Open SnB form for Bin First Item when Auto Allocation | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| BItmDscUpd | Block Item Description Updated in the Copied Lines | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| DeferrTax | Deferred Tax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| CtlActSlct | Allow Control Account Selection | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SepDiscDpm | Separate Discount % and DPM % Fields | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DiffCigCup | Allow Different CIG and CUP Codes in One Payment | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| NotDeferTa | Do Not Apply Deferred Tax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EmailSignD | E-Mail Signed Document | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DftPriList | Default Price List | Int | 6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | PrintId |
| Â | Â | ObjType |
| Â | Â | LogInstanc |