|
|
API DWZ4
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WizardId KEY UNIQUE | Wizard ID | Int | 11 | ODWZ Dunning Wizard | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| 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 Business Partner | ||||
| LetterNum | Letter Number | Int | 11 | |||||
| DunnLevel | Dunning Level | Int | 11 | |||||
| CardName | BP Name | nVarChar | 100 | |||||
| DocCur | Doc. Currency | nVarChar | 3 | |||||
| DocType | Source Table | Int | 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 | 11 | ||||
| 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 | 20 | |||||
| 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 | N) No B) Interest and Fee I) Interest Only F) Fee Only | 1 | N | |||
| LineProp | Line Property | Int | 11 | |||||
| YearDays | Year Days | Int | 11 | |||||
| YearlyRate | Yearly Rate | Num | 20 | |||||
| LetterFrmt | Letter Formant | nVarChar | 8 | |||||
| MinBlan | Min. Balance | Num | 20 | |||||
| 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 | 20 | |||||
| MinBalCurr | Minimum Balance Currency | nVarChar | 3 | |||||
| LvlUpdated | Level Updated | nVarChar | 3 | |||||
| DunAddr | Dunning Address | nVarChar | 127 | |||||
| DocText | Doc. Text | nVarChar | 127 | |||||
| ParentId | Parent Id | Int | 11 |
Table relationship map
SELECT statement
SELECT
DWZ4.WizardId AS 'Wizard ID',
DWZ4.CheckLine AS 'Checked Row',
DWZ4.ExeChkLine AS 'Executed Checked Row',
DWZ4.RowId AS 'Row Num',
DWZ4.CardCode AS 'BP Card Code',
DWZ4.LetterNum AS 'Letter Number',
DWZ4.DunnLevel AS 'Dunning Level',
DWZ4.CardName AS 'BP Name',
DWZ4.DocCur AS 'Doc. Currency',
DWZ4.DocType AS 'Source Table',
DWZ4.DocNum AS 'Doc. No.',
DWZ4.InstlmntID AS 'Installment ID',
DWZ4.DueDate AS 'Due Date',
DWZ4.LastLvlDte AS 'Last Update Date',
DWZ4.LastDunDte AS 'Last Dunning Date',
DWZ4.NewLvlDate AS 'New Level Update Date',
DWZ4.DocAmntLC AS 'DOC. AMOUNT (LC)',
DWZ4.DocAmntFC AS 'DOC. AMOUNT (FC)',
DWZ4.OpenAmtLC AS 'Open Amount (LC)',
DWZ4.OpenAmtFC AS 'Open Amount (FC)',
DWZ4.IntrstDays AS 'Interest Days',
DWZ4.IntrstPC AS 'Interest Percent',
DWZ4.IntAmntLC AS 'Interest Amount (LC)',
DWZ4.IntAmntFC AS 'Interest Amount (FC)',
DWZ4.InclAmntLC AS 'Total Incl. Amount (LC)',
DWZ4.InclAmntFC AS 'Total Incl. Amount (FC)',
DWZ4.FeeLC AS 'Fee (LC)',
DWZ4.FeeFC AS 'Fee (FC)',
DWZ4.AllTotalLC AS 'Overall Total (LC)',
DWZ4.AllTotalFC AS 'Overall Total (FC)',
DWZ4.AutoPost AS 'Automatic Posting',
DWZ4.LineProp AS 'Line Property',
DWZ4.YearDays AS 'Year Days',
DWZ4.YearlyRate AS 'Yearly Rate',
DWZ4.LetterFrmt AS 'Letter Formant',
DWZ4.MinBlan AS 'Min. Balance',
DWZ4.GrpMethod AS 'Group Method',
DWZ4.DocEntry AS 'DocEntry',
DWZ4.DocRate AS 'Exchange Rate on Document',
DWZ4.FeeCurr AS 'Fee Currency',
DWZ4.OrigFee AS 'Original Fee on Dunning Term',
DWZ4.MinBalCurr AS 'Minimum Balance Currency',
DWZ4.LvlUpdated AS 'Level Updated',
DWZ4.DunAddr AS 'Dunning Address',
DWZ4.DocText AS 'Doc. Text',
DWZ4.ParentId AS 'Parent Id'
FROM DWZ4 AS DWZ4
Related information
Business Partner OCRD SQL Table
Dunning Wizard ODWZ SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates