|
|
SAP Business One SDK 10.0 - Database Tables Reference |
A/P Correction Invoice Reversal - Installments
Table Name: CPV6
Table Description: A/P Correction Invoice Reversal - Installments
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | OCPV | Â | Â | Â |
| InstlmntID | Installment ID | Int | 6 | - | 1 | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 164 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| Status | Installment Status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Closed |
| DunnLevel | Dunning Level | Int | 11 | - | 0 | Â | Â |
| InsTotal | Total Installment | Num | 19.6 | - | Â | Â | Â |
| InsTotalFC | Total Installment (FC) | Num | 19.6 | - | Â | Â | Â |
| InsTotalSy | Total Installment (SC) | Num | 19.6 | - | Â | Â | Â |
| PaidToDate | Paid to Date | Num | 19.6 | - | Â | Â | Â |
| PaidFC | Paid (FC) | Num | 19.6 | - | Â | Â | Â |
| PaidSys | Paid (SC) | Num | 19.6 | - | Â | Â | Â |
| VatSum | Total Tax | Num | 19.6 | - | Â | Â | Â |
| VatSumFC | Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| VatSumSy | Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| VatPaid | Tax Paid to Date | Num | 19.6 | - | Â | Â | Â |
| VatPaidFC | Tax Paid (FC) | Num | 19.6 | - | Â | Â | Â |
| VatPaidSys | Tax Paid (SC) | Num | 19.6 | - | Â | Â | Â |
| TotalExpns | Total Freight Charges | Num | 19.6 | - | Â | Â | Â |
| TotalExpFC | Total Freight Charges (FC) | Num | 19.6 | - | Â | Â | Â |
| TotalExpSC | Total Freight Charges (SC) | Num | 19.6 | - | Â | Â | Â |
| ExpAppl | Applied Freight Charges | Num | 19.6 | - | Â | Â | Â |
| ExpApplFC | Applied Freight Charges (FC) | Num | 19.6 | - | Â | Â | Â |
| ExpApplSC | Applied Freight Charges (SC) | Num | 19.6 | - | Â | Â | Â |
| WTSum | WTax Amount | Num | 19.6 | - | Â | Â | Â |
| WTSumFC | WTax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| WTSumSC | WTax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| WTApplied | Applied WTax | Num | 19.6 | - | Â | Â | Â |
| WTAppliedF | Applied WTax (FC) | Num | 19.6 | - | Â | Â | Â |
| WTAppliedS | Applied WTax (SC) | Num | 19.6 | - | Â | Â | Â |
| TotalBlck | Total Reserved Amount | Num | 19.6 | - | Â | Â | Â |
| TotalBlckF | Total Reserved Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| TotalBlckS | Total Reserved Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| VATBlck | Reserved Tax Amount | Num | 19.6 | - | Â | Â | Â |
| VATBlckFC | Reserved Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| VATBlckSC | Reserved Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| ExpnsBlck | Reserved Freight Amount | Num | 19.6 | - | Â | Â | Â |
| ExpnsBlckF | Reserved Freight Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| ExpnsBlckS | Reserved Freight Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| WTBlocked | Reserved WTax Amount | Num | 19.6 | - | Â | Â | Â |
| WTBlockedF | Reserved WTax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| WTBlockedS | Reserved WTax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| InstPrcnt | Installment % | Num | 19.6 | - | Â | Â | Â |
| DunWizBlck | Wizard dunning block | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| DunDate | Last Dunning Date | Date | 8 | - | Â | Â | Â |
| Paid | Paid | Num | 19.6 | - | Â | Â | Â |
| PaidFrgn | Paid (FC) | Num | 19.6 | - | Â | Â | Â |
| PaidSc | Paid (SC) | Num | 19.6 | - | Â | Â | Â |
| reserved | Reserved | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| TaxOnExp | Tax on Expenses | Num | 19.6 | - | Â | Â | Â |
| TaxOnExpFc | Tax on Expenses (FC) | Num | 19.6 | - | Â | Â | Â |
| TaxOnExpSc | Tax on Expenses (SC) | Num | 19.6 | - | Â | Â | Â |
| TaxOnExpAp | Applied Tax on Expenses | Num | 19.6 | - | Â | Â | Â |
| TaxOnExApF | Applied Tax on Expenses (FC) | Num | 19.6 | - | Â | Â | Â |
| TaxOnExApS | Applied Tax on Expenses (SC) | Num | 19.6 | - | Â | Â | Â |
| TaxOnExBlo | Reserved Tax on Freight Amount | Num | 19.6 | - | Â | Â | Â |
| TaxOnExBlF | Reserved Tax on Freight Amt FC | Num | 19.6 | - | Â | Â | Â |
| TaxOnExBlS | Reserved Tax on Freight Amt SC | Num | 19.6 | - | Â | Â | Â |
| LvlUpdDate | Dunning Level Update Date | Date | 8 | - | Â | Â | Â |
| Ordered | Payment Ordered | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PaidDpm | Paid by Down Payment | Num | 19.6 | - | Â | Â | Â |
| PaidDpmFc | Paid by Down Payment (FC) | Num | 19.6 | - | Â | Â | Â |
| PaidDpmSc | Paid by Down Payment (SC) | Num | 19.6 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | InstlmntID |