|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Payment Draft - Invoices
Table Name: PDF2
Table Description: Payment Draft - Invoices
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocNum | Document Number | Int | 11 | OPDF | Â | Â | Â |
| InvoiceId | Sequence No. | Int | 11 | - | Â | Â | Â |
| DocEntry | Invoice Key | Int | 11 | - | Â | Â | Â |
| SumApplied | Paid to Invoice | Num | 19.6 | - | Â | Â | Â |
| AppliedFC | Paid in FC | Num | 19.6 | - | Â | Â | Â |
| AppliedSys | Paid in SC | Num | 19.6 | - | Â | Â | Â |
| InvType | Invoice Category | nVarChar | 20 | - | 13 | 203 | A/R Down Payment |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memo |
| Â | Â | Â | Â | Â | Â | 204 | A/P Down Payment |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 19 | A/P Credit Memo |
| Â | Â | Â | Â | Â | Â | 24 | Incoming Payment |
| Â | Â | Â | Â | Â | Â | 25 | Deposit |
| Â | Â | Â | Â | Â | Â | 46 | Payment Advice |
| Â | Â | Â | Â | Â | Â | 57 | Checks for Payment |
| Â | Â | Â | Â | Â | Â | 76 | Postdated Deposit |
| Â | Â | Â | Â | Â | Â | -2 | Opening Balance |
| Â | Â | Â | Â | Â | Â | -3 | Closing Balance |
| Â | Â | Â | Â | Â | Â | 30 | Journal Entry |
| Â | Â | Â | Â | Â | Â | -1 | All Transactions |
| Â | Â | Â | Â | Â | Â | 163 | A/P Correction Invoice |
| Â | Â | Â | Â | Â | Â | 165 | A/R Correction Invoice |
| Â | Â | Â | Â | Â | Â | 0 | Â |
| DocRate | Document Rate | Num | 19.6 | - | Â | Â | Â |
| Flags | Flags | Int | 11 | - | 0 | Â | Â |
| IntrsStat | Interest Letter Status | VarChar | 1 | - | U | U | Not Sent |
| Â | Â | Â | Â | Â | Â | S | Sent |
| Â | Â | Â | Â | Â | Â | C | Closed |
| DocLine | Row Key | Int | 11 | - | 0 | Â | Â |
| vatApplied | Tax Definition | Num | 19.6 | - | Â | Â | Â |
| vatAppldFC | Tax Paid in FC | Num | 19.6 | - | Â | Â | Â |
| vatAppldSy | Tax Paid in SC | Num | 19.6 | - | Â | Â | Â |
| selfInv | Autom. Invoice | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| ObjType | Object Type | nVarChar | 20 | ADP1 | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| Dcount | Discount % | Num | 19.6 | - | Â | Â | Â |
| DcntSum | Discount Amount | Num | 19.6 | - | Â | Â | Â |
| DcntSumFC | Discount Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| DcntSumSy | Discount Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| BfDcntSum | Amount Before Discount | Num | 19.6 | - | Â | Â | Â |
| BfDcntSumF | Amount Before Discount (FC) | Num | 19.6 | - | Â | Â | Â |
| BfDcntSumS | Amount Before Discount (SC) | Num | 19.6 | - | Â | Â | Â |
| BfNetDcnt | Net Amount Bef. Discount | Num | 19.6 | - | Â | Â | Â |
| BfNetDcntF | Net Amount Bef. Discount (FC) | Num | 19.6 | - | Â | Â | Â |
| BfNetDcntS | Net Amount Bef. Discount (SC) | Num | 19.6 | - | Â | Â | Â |
| PaidSum | Amount Paid (LC) | Num | 19.6 | - | Â | Â | Â |
| ExpAppld | Freight applied | Num | 19.6 | - | Â | Â | Â |
| ExpAppldFC | Freight applied FC | Num | 19.6 | - | Â | Â | Â |
| ExpAppldSC | Freight applied SC | Num | 19.6 | - | Â | Â | Â |
| Rounddiff | Rounding Diff. | Num | 19.6 | - | Â | Â | Â |
| RounddifFc | Rounding Diff. (FC) | Num | 19.6 | - | Â | Â | Â |
| RounddifSc | Rounding Diff. (SC) | Num | 19.6 | - | Â | Â | Â |
| InstId | Installment ID | Int | 6 | - | 1 | Â | Â |
| WtAppld | Applied WTax | Num | 19.6 | - | Â | Â | Â |
| WtAppldFC | Applied WTax (FC) | Num | 19.6 | - | Â | Â | Â |
| WtAppldSC | Applied WTax (SC) | Num | 19.6 | - | Â | Â | Â |
| LinkDate | Link Date | Date | 8 | - | Â | Â | Â |
| AmtDifPst | Amount Diffs. Posting Date | Date | 8 | - | Â | Â | Â |
| PaidDpm | Paid Down Payment | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| DpmPosted | Link Date | VarChar | 1 | - | Â | Â | Â |
| ExpVatSum | VAT on Expenses Sum | Num | 19.6 | - | Â | Â | Â |
| ExpVatSumF | VAT on Expenses Sum (FC) | Num | 19.6 | - | Â | Â | Â |
| ExpVatSumS | VAT on Expenses Sum (SC) | Num | 19.6 | - | Â | Â | Â |
| IsRateDiff | Is Exchange Rate | VarChar | 1 | - | N | Â | Â |
| WtInvCatS | Withholding Tax Invoice Categ. | Num | 19.6 | - | Â | Â | Â |
| WtInvCatSF | Withholding Tax Invoice Categ. | Num | 19.6 | - | Â | Â | Â |
| WtInvCatSS | Withholding Tax Invoice Categ. | Num | 19.6 | - | Â | Â | Â |
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR | Â | Â | Â |
| DocTransId | Trans. ID of Paid Document | Int | 11 | OJDT | Â | Â | Â |
| MIEntry | MI Entry Include this Payment | Int | 11 | - | 0 | Â | Â |
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR | Â | Â | Â |
| IsSelected | Is Record Selected | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| WTOnHold | Withholding Tax On Hold | Num | 19.6 | - | Â | Â | Â |
| WTOnhldPst | Withholding Tax Posted | Num | 19.6 | - | Â | Â | Â |
| baseAbs | Base Document Number | Int | 11 | - | Â | Â | Â |
| MIType | MI Type Include this Payment | nVarChar | 20 | - | Â | 270 | A/R Monthly Invoice |
| Â | Â | Â | Â | Â | Â | 140000014 | A/P Monthly Invoice |
| DocSubType | Document Subtype | nVarChar | 2 | - | -- | Â | Â |
| SpltPmtVAT | Split Payment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| WTSum | WTax Amount | Num | 19.6 | - | Â | Â | Â |
| WTSumFC | WTax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| WTSumSC | WTax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| SelOrder | Select Order | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocNum |
| Â | Â | InvoiceId |
| JDT | No | DocTransId |
| Â | Â | DocLine |