|
|
API ODWZ
ODWZ - Dunning Wizard Table
ODWZ SQL Table
Dunning Letters ODUN SQL Table
Dunning Terms ODUT SQL Table
Documents Numbering - Series NNM1 SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WizardId KEY UNIQUE | Wizard ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| WizardName KEY | Wizard Name | nVarChar | 100 | SECONDARY | No | |||
| ToPayDate | To be paid by | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| Status | Wizard Status | VarChar | S) Saved Parameters R) Saved Recommendations E) Executed and Printed or Sent by E-Mail O) Executed, Not Yet Printed or Sent by E-Mail P) Partially Executed and Printed T) Partially Executed, Not Yet Printed or Sent by E-Mail | 1 | S | |||
| DunLevel | Dunning Level | nVarChar | 0 1) Level 1 2) Level 2 3) Level 3 4) Level 4 5) Level 5 6) Level 6 7) Level 7 8) Level 8 9) Level 9 10) Level 10 | 3 | ODUN Dunning Letters | 0 | ||
| CreditZero | Include BP with Credit | VarChar | Y) Yes N) No | 1 | N | |||
| PayNoBased | Payment on Account | VarChar | Y) Yes N) No | 1 | Y | |||
| CrdtNBased | Include Credit Not Based | VarChar | Y) Yes N) No | 1 | Y | |||
| DunTime | Dunning Time | nVarChar | 6 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| FromDate | From Date Filter | Date | 8 | |||||
| ToDate | Date To Filter | Date | 8 | |||||
| ManualJEs | Include Manual JEs | VarChar | N) No Y) Yes | 1 | N | |||
| DspOpnItms | Display Open Items | VarChar | Y) Yes N) No | 1 | N | |||
| AllowNegLt | Allow Negative Dunning Letter | VarChar | Y) Yes N) No | 1 | N | |||
| DunTerm | Dunning Term | nVarChar | 25 | ODUT Dunning Terms | -1 | |||
| FrmDueDate | From Due Date Filter | Date | 8 | |||||
| ToDueDate | To Due Date Filter | Date | 8 | |||||
| UpToDate | Include Payments Up To | Date | 8 | |||||
| InvPostDat | Invc. Posting Date | Date | 8 | |||||
| InvDueDate | Invc. Due Date | Date | 8 | |||||
| InvDocDate | Invc. Doc. Date | Date | 8 | |||||
| Project | Project | nVarChar | 20 | |||||
| OcrCode | Costing Code | nVarChar | 8 | |||||
| OcrCode2 | Costing Code 2 | nVarChar | 8 | |||||
| OcrCode3 | Costing Code 3 | nVarChar | 8 | |||||
| OcrCode4 | Costing Code 4 | nVarChar | 8 | |||||
| OcrCode5 | Costing Code 5 | nVarChar | 8 | |||||
| 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 | 20 | |||||
| AutoRmk | Auto Remark | VarChar | 1 | Y | ||||
| Remarks | Remarks | nVarChar | 127 | |||||
| Series | Series | Int | 6 | NNM1 Documents Numbering - Series | 0 | |||
| BPLId | BPL ID Assigned to Invoice | Int | 11 | |||||
| LocCode | Location Code | Int | 11 | |||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| OvrDueOnly | BPs with Overdue Item Only | VarChar | Y) Yes N) No | 1 | N | |||
| QuickDisp | Quick Display | VarChar | Y) Yes N) No | 1 | N | |||
| OPNoBased | Include Outgoing Payments | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
ODWZ.WizardId AS 'Wizard ID',
ODWZ.WizardName AS 'Wizard Name',
ODWZ.ToPayDate AS 'To be paid by',
ODWZ.CreateDate AS 'Creation Date',
ODWZ.Status AS 'Wizard Status',
ODWZ.DunLevel AS 'Dunning Level',
ODWZ.CreditZero AS 'Include BP with Credit',
ODWZ.PayNoBased AS 'Payment on Account',
ODWZ.CrdtNBased AS 'Include Credit Not Based',
ODWZ.DunTime AS 'Dunning Time',
ODWZ.UserSign AS 'User Signature',
ODWZ.FromDate AS 'From Date Filter',
ODWZ.ToDate AS 'Date To Filter',
ODWZ.ManualJEs AS 'Include Manual JEs',
ODWZ.DspOpnItms AS 'Display Open Items',
ODWZ.AllowNegLt AS 'Allow Negative Dunning Letter',
ODWZ.DunTerm AS 'Dunning Term',
ODWZ.FrmDueDate AS 'From Due Date Filter',
ODWZ.ToDueDate AS 'To Due Date Filter',
ODWZ.UpToDate AS 'Include Payments Up To',
ODWZ.InvPostDat AS 'Invc. Posting Date',
ODWZ.InvDueDate AS 'Invc. Due Date',
ODWZ.InvDocDate AS 'Invc. Doc. Date',
ODWZ.Project AS 'Project',
ODWZ.OcrCode AS 'Costing Code',
ODWZ.OcrCode2 AS 'Costing Code 2',
ODWZ.OcrCode3 AS 'Costing Code 3',
ODWZ.OcrCode4 AS 'Costing Code 4',
ODWZ.OcrCode5 AS 'Costing Code 5',
ODWZ.InVatGroup AS 'Interest VAT Group',
ODWZ.InTaxCode AS 'Interest Tax Code',
ODWZ.FeVatGroup AS 'Fee VAT Group',
ODWZ.FeTaxCode AS 'Fee Tax Code',
ODWZ.VatPrcnt AS 'VAT Percent',
ODWZ.AutoRmk AS 'Auto Remark',
ODWZ.Remarks AS 'Remarks',
ODWZ.Series AS 'Series',
ODWZ.BPLId AS 'BPL ID Assigned to Invoice',
ODWZ.LocCode AS 'Location Code',
ODWZ.VersionNum AS 'Version Number',
ODWZ.OvrDueOnly AS 'BPs with Overdue Item Only',
ODWZ.QuickDisp AS 'Quick Display',
ODWZ.OPNoBased AS 'Include Outgoing Payments'
FROM ODWZ AS ODWZ
Related information
ODWZ SQL Table
Dunning Letters ODUN SQL Table
Dunning Terms ODUT SQL Table
Documents Numbering - Series NNM1 SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates