|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Dunning Wizard Array 4-Paging Grid
Table Name: DWZ4
Table Description: Dunning Wizard Array 4-Paging Grid
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| WizardId | Wizard ID | Int | 11 | ODWZ | Â | Â | Â |
| CheckLine | Checked Row | VarChar | 1 | - | Y | Â | Â |
| ExeChkLine | Executed Checked Row | VarChar | 1 | - | Y | Â | Â |
| RowId | Row Num | Int | 11 | - | Â | Â | Â |
| CardCode | BP Card Code | nVarChar | 15 | OCRD | Â | Â | Â |
| LetterNum | Letter Number | Int | 11 | - | Â | Â | Â |
| DunnLevel | Dunning Level | Int | 11 | - | Â | Â | Â |
| CardName | BP Name | nVarChar | 200 | - | Â | Â | Â |
| DocCur | Doc. Currency | nVarChar | 3 | - | Â | Â | Â |
| DocType | Source Table | Int | 11 | - | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 203 | Down Payment Incoming |
| Â | Â | Â | Â | Â | Â | 165 | Correction A/R Invoice |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memo |
| Â | Â | Â | Â | Â | Â | 24 | Incoming Payment |
| Â | Â | Â | Â | Â | Â | 30 | Journal Transactions |
| Â | Â | Â | Â | Â | Â | -2 | Open Balance |
| Â | Â | Â | Â | Â | Â | -3 | Close Balance |
| DocNum | Doc. No. | Int | 11 | - | Â | Â | Â |
| InstlmntID | Installment ID | Int | 6 | - | Â | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| LastLvlDte | Last Update Date | Date | 8 | - | Â | Â | Â |
| LastDunDte | Last Dunning Date | Date | 8 | - | Â | Â | Â |
| NewLvlDate | New Level Update Date | Date | 8 | - | Â | Â | Â |
| DocAmntLC | DOC. AMOUNT (LC) | nVarChar | 100 | - | Â | Â | Â |
| DocAmntFC | DOC. AMOUNT (FC) | nVarChar | 100 | - | Â | Â | Â |
| OpenAmtLC | Open Amount (LC) | nVarChar | 100 | - | Â | Â | Â |
| OpenAmtFC | Open Amount (FC) | nVarChar | 100 | - | Â | Â | Â |
| IntrstDays | Interest Days | Int | 11 | - | Â | Â | Â |
| IntrstPC | Interest Percent | Num | 19.6 | - | Â | Â | Â |
| IntAmntLC | Interest Amount (LC) | nVarChar | 100 | - | Â | Â | Â |
| IntAmntFC | Interest Amount (FC) | nVarChar | 100 | - | Â | Â | Â |
| InclAmntLC | Total Incl. Amount (LC) | nVarChar | 100 | - | Â | Â | Â |
| InclAmntFC | Total Incl. Amount (FC) | nVarChar | 100 | - | Â | Â | Â |
| FeeLC | Fee (LC) | nVarChar | 100 | - | Â | Â | Â |
| FeeFC | Fee (FC) | nVarChar | 100 | - | Â | Â | Â |
| AllTotalLC | Overall Total (LC) | nVarChar | 100 | - | Â | Â | Â |
| AllTotalFC | Overall Total (FC) | nVarChar | 100 | - | Â | Â | Â |
| AutoPost | Automatic Posting | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | B | Interest and Fee |
| Â | Â | Â | Â | Â | Â | I | Interest Only |
| Â | Â | Â | Â | Â | Â | F | Fee Only |
| LineProp | Line Property | Int | 11 | - | Â | Â | Â |
| YearDays | Year Days | Int | 11 | - | Â | Â | Â |
| YearlyRate | Yearly Rate | Num | 19.6 | - | Â | Â | Â |
| LetterFrmt | Letter Formant | nVarChar | 8 | - | Â | Â | Â |
| MinBlan | Min. Balance | Num | 19.6 | - | Â | Â | Â |
| GrpMethod | Group Method | VarChar | 1 | - | Â | Â | Â |
| DocEntry | DocEntry | Int | 11 | - | Â | Â | Â |
| DocRate | Exchange Rate on Document | nVarChar | 100 | - | Â | Â | Â |
| FeeCurr | Fee Currency | nVarChar | 3 | - | Â | Â | Â |
| OrigFee | Original Fee on Dunning Term | Num | 19.6 | - | Â | Â | Â |
| MinBalCurr | Minimum Balance Currency | nVarChar | 3 | - | Â | Â | Â |
| LvlUpdated | Level Updated | nVarChar | 3 | - | Â | Â | Â |
| DunAddr | Dunning Address | nVarChar | 254 | - | Â | Â | Â |
| DocText | Doc. Text | nVarChar | 254 | - | Â | Â | Â |
| ParentId | Parent Id | Int | 11 | - | Â | Â | Â |
| BpCode2 | BP Code 2 | nVarChar | 15 | - | Â | Â | Â |
| BpType | BP Type | VarChar | 1 | - | Â | Â | Â |
| CardName2 | Card Name 2 | nVarChar | 200 | - | Â | Â | Â |
| Comment | Comment | nVarChar | 254 | - | Â | Â | Â |
| BPLId | Branch ID | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | WizardId |
| Â | Â | RowId |