|
|
API DWZ2
DWZ2 - Dunning Wizard Array 2-Invoice Filter Table
Business Partner OCRD SQL Table
Currency Codes OCRN SQL Table
Dunning Wizard ODWZ SQL Table
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 |
|---|---|---|---|---|---|---|---|---|
| CardCode | BP Card Code | nVarChar | 15 | OCRD Business Partner | ||||
| LetterNum | Letter Number | Int | 11 | |||||
| TotalFee | Total Fee | Num | 20 | |||||
| FeeCurr | Total Fee Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| TtlopnIntr | Sum of Open Sum+Interest | Num | 20 | |||||
| EDunLevel | Edited Dunning Level | nVarChar | 3 | |||||
| OpnIntrCrr | Total Open + Interest Currency | nVarChar | 3 | |||||
| DocAbs | Document Internal Number | Int | 11 | |||||
| DocNum | Doc. No. | Int | 11 | |||||
| InstlmntID | Installment ID | Int | 6 | |||||
| IntrstPC | Interest Percent | Num | 20 | |||||
| IntrstAmnt | Interest Amount | Num | 20 | |||||
| IntrstCurr | Interest Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| ChckLine | Checked Row | VarChar | Y) Yes N) No | 1 | N | |||
| IntrstDays | Interest Days | Int | 11 | |||||
| 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 46) Outgoing Payments | 11 | ||||
| DueDate | Due Date | Date | 8 | |||||
| LetterLvl | Letter Level | nVarChar | 3 | 0 | ||||
| OpenSum | Open Sum | Num | 20 | |||||
| OpenCurr | Open Sum Currency | nVarChar | 3 | |||||
| sumIntrClc | Sum for Interest Calculation | Num | 20 | |||||
| folioNum | Folio Number | nVarChar | 14 | |||||
| LvlUpdated | Level Updated Flag | VarChar | Y) Yes N) No | 1 | N | |||
| TotalFeeFC | Total Fee in Document Currency | Num | 20 | |||||
| TotalFeeLC | Total Fee in Local Currency | Num | 20 | |||||
| TotalFeeSC | Total Fee in System Currency | Num | 20 | |||||
| TtlopnInFC | Sum of Open Sum+Interest FC | Num | 20 | |||||
| TtlopnInSC | Sum of Open Sum+Interest SC | Num | 20 | |||||
| IntrAmtFC | Interest Amount (FC) | Num | 20 | |||||
| IntrAmtSC | Interest Amount (SC) | Num | 20 | |||||
| OpenSumFC | Open Sum (FC) | Num | 20 | |||||
| OpenSumSC | Open Sum (SC) | Num | 20 | |||||
| ExeChkLine | Executed Checked Row | VarChar | Y) Yes N) No | 1 | N | |||
| AutoPost | Automatic Posting | VarChar | N) No B) Interest and Fee I) Interest Only F) Fee Only | 1 | N | |||
| DocRate | Document Rate | Num | 20 | |||||
| UnpaidBoEV | Unpaid BoE Value | Num | 20 | |||||
| BoENumber | BoE Number | Int | 11 | |||||
| BoEStatus | BoE Status | VarChar | 1 | |||||
| BoEDate | BoE Date | Date | 8 | |||||
| BoEKey | BoE Key | Int | 11 |
Table relationship map
SELECT statement
SELECT
DWZ2.WizardId AS 'Wizard ID',
DWZ2.CardCode AS 'BP Card Code',
DWZ2.LetterNum AS 'Letter Number',
DWZ2.TotalFee AS 'Total Fee',
DWZ2.FeeCurr AS 'Total Fee Currency',
DWZ2.TtlopnIntr AS 'Sum of Open Sum+Interest',
DWZ2.EDunLevel AS 'Edited Dunning Level',
DWZ2.OpnIntrCrr AS 'Total Open + Interest Currency',
DWZ2.DocAbs AS 'Document Internal Number',
DWZ2.DocNum AS 'Doc. No.',
DWZ2.InstlmntID AS 'Installment ID',
DWZ2.IntrstPC AS 'Interest Percent',
DWZ2.IntrstAmnt AS 'Interest Amount',
DWZ2.IntrstCurr AS 'Interest Currency',
DWZ2.ChckLine AS 'Checked Row',
DWZ2.IntrstDays AS 'Interest Days',
DWZ2.DocType AS 'Source Table',
DWZ2.DueDate AS 'Due Date',
DWZ2.LetterLvl AS 'Letter Level',
DWZ2.OpenSum AS 'Open Sum',
DWZ2.OpenCurr AS 'Open Sum Currency',
DWZ2.sumIntrClc AS 'Sum for Interest Calculation',
DWZ2.folioNum AS 'Folio Number',
DWZ2.LvlUpdated AS 'Level Updated Flag',
DWZ2.TotalFeeFC AS 'Total Fee in Document Currency',
DWZ2.TotalFeeLC AS 'Total Fee in Local Currency',
DWZ2.TotalFeeSC AS 'Total Fee in System Currency',
DWZ2.TtlopnInFC AS 'Sum of Open Sum+Interest FC',
DWZ2.TtlopnInSC AS 'Sum of Open Sum+Interest SC',
DWZ2.IntrAmtFC AS 'Interest Amount (FC)',
DWZ2.IntrAmtSC AS 'Interest Amount (SC)',
DWZ2.OpenSumFC AS 'Open Sum (FC)',
DWZ2.OpenSumSC AS 'Open Sum (SC)',
DWZ2.ExeChkLine AS 'Executed Checked Row',
DWZ2.AutoPost AS 'Automatic Posting',
DWZ2.DocRate AS 'Document Rate',
DWZ2.UnpaidBoEV AS 'Unpaid BoE Value',
DWZ2.BoENumber AS 'BoE Number',
DWZ2.BoEStatus AS 'BoE Status',
DWZ2.BoEDate AS 'BoE Date',
DWZ2.BoEKey AS 'BoE Key'
FROM DWZ2 AS DWZ2
Related information
Business Partner OCRD SQL Table
Currency Codes OCRN 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