|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Dunning Wizard Array 3 - Recommended Service Invoice
Table Name: DWZ3
Table Description: Dunning Wizard Array 3 - Recommended Service Invoice
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| WizardId | Wizard ID | Int | 11 | - | Â | Â | Â |
| CardCode | BP Card Code | nVarChar | 15 | - | Â | Â | Â |
| LetterNum | Letter Number | Int | 11 | - | Â | Â | Â |
| AddChecked | Add Checked | VarChar | 1 | - | Y | Â | Â |
| DocAbs | Internal Document Number | Int | 11 | - | Â | Â | Â |
| IntrAmt | Interest Amount (LC) | Num | 19.6 | - | Â | Â | Â |
| IntrAmtFC | Interest Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| IntrAmtSC | Interest Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| FeeAmt | Fee Amount (LC) | Num | 19.6 | - | Â | Â | Â |
| FeeAmtFC | Fee Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| FeeAmtSC | Fee Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| InVatGroup | Interest VAT Group | nVarChar | 8 | - | Â | Â | Â |
| InTaxCode | Interest Tax Code | nVarChar | 8 | - | Â | Â | Â |
| FeVatGroup | Fee VAT Group | nVarChar | 8 | - | Â | Â | Â |
| FeTaxCode | Fee Tax Code | nVarChar | 8 | - | Â | Â | Â |
| VatPrcnt | VAT Percent | Num | 19.6 | - | Â | Â | Â |
| Executed | Executed | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Message | Message | nVarChar | 254 | - | Â | Â | Â |
| DocCur | Document Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| BPLId | BPL ID Assigned to Invoice | Int | 11 | - | Â | Â | Â |
| LocCode | Location Code | Int | 11 | - | Â | Â | Â |
| SACIntrst | SAC for Interest | Int | 11 | - | Â | Â | Â |
| SACFee | SAC for Fee | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | WizardId |
| Â | Â | CardCode |
| Â | Â | LetterNum |