|
|
SQL Banking / Payment Wizard
API OPWZ
OPWZ - Payment Wizard Table
OPWZ SQL Table
Bill of Exchange for Payment OBOE SQL Table
Business Place OBPL SQL Table
CIG Codes OCIG SQL Table
CUP Codes OCUP 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 | IdNumber KEY UNIQUE | ID Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PmntDate | Date of Payment Run | Date | 8 | |||||
| NextDate | A/P Due Date To | Date | 8 | |||||
| OutgoType | Outgoing Type | VarChar | Y) Yes N) No | 1 | N | |||
| IncomType | Incoming Type | VarChar | Y) Yes N) No | 1 | N | |||
| CheckPmntM | Check Payment Terms | VarChar | Y) Yes N) No | 1 | N | |||
| BnkTrnsPmM | Bank Transfer Payment Terms | VarChar | Y) Yes N) No | 1 | N | |||
| FilePath | File Path | Text | 16 | |||||
| PostDtFrom | Posting Date From | Date | 8 | |||||
| PostDtTo | Posting Date To | Date | 8 | |||||
| ValDteFrom | Due Date From | Date | 8 | |||||
| ValDateTo | Due Date To | Date | 8 | |||||
| ApInvAmntF | A/P Invoice Amount From | Num | 20 | |||||
| ApInvAmntT | A/P Invoice Amount To | Num | 20 | |||||
| PchNoFrom | A/P Invoice No. From | Int | 11 | |||||
| PchNoTo | A/P Invoice No. To | Int | 11 | |||||
| InvNoFrom | A/R Invoice No. From | Int | 11 | |||||
| InvNoTo | A/R Invoice No. To | Int | 11 | |||||
| SelPriorit | Selection Priority | Int | 11 | |||||
| Status | Object Status | VarChar | S) Saved Wizard R) Recommended Wizard E) Executed Wizard | 1 | S | |||
| WizardName KEY UNIQUE | Wizard Name | nVarChar | 100 | NAME | Yes | |||
| StatusDisc | Status | nVarChar | 100 | |||||
| Canceled | Canceled | VarChar | 1 | N | ||||
| BoePmnMn | Bill of Exchange Paymt Method | VarChar | Y) Yes N) No | 1 | N | |||
| SeriesOut | Outgoing Series | Int | 6 | NNM1 Documents Numbering - Series | 0 | |||
| SeriesIn | Incoming Series | Int | 6 | NNM1 Documents Numbering - Series | 0 | |||
| TotalOut | Total Outgoing | Num | 20 | |||||
| TotalIn | Total Incoming | Num | 20 | |||||
| ViewIntBal | Include Interim Acct Balance | VarChar | Y) Yes N) No | 1 | N | |||
| SelMthd | Selection Method | VarChar | M) By Monthly Invoice D) By Document Property | 1 | D | |||
| MINumFrom | Monthly Invoice No. From | Int | 11 | |||||
| MINumTo | Monthly Invoice No. To | Int | 11 | |||||
| MIDateFrom | Monthly Invoice Issued Date From | Date | 8 | |||||
| MIDateTo | Monthly Invoice Issued Date To | Date | 8 | |||||
| MIVNumFrom | A/P Monthly Invoice No. From | Int | 11 | |||||
| MIVNumTo | A/P Monthly Invoice No. To | Int | 11 | |||||
| MIVDateFro | A/P Monthly Invoice Date From | Date | 8 | |||||
| MIVDateTo | A/P Monthly Invoice Date To | Date | 8 | |||||
| APDocDtFrm | A/P Document Date From | Date | 8 | |||||
| APDocDtTo | A/P Document Date To | Date | 8 | |||||
| APDueDtFrm | A/P Due Date From | Date | 8 | |||||
| NxtPmntDat | Next Payment Run Date | Date | 8 | |||||
| MinPayAR | Minimum Incoming Payment | Num | 20 | |||||
| MinPayAP | Minimum Outgoing Payment | Num | 20 | |||||
| ShowAtCard | Display BP Ref. No. | VarChar | Y) Yes N) No | 1 | N | |||
| TolerDays | Tolerance Days | Int | 6 | |||||
| MinCashDis | Min. Cash Discount | Num | 20 | |||||
| NegBalBP | Include Negative Balance BP | VarChar | Y) Yes N) No | 1 | N | |||
| ManualJE | Include Manual JEs | VarChar | Y) Yes N) No | 1 | Y | |||
| NegTrans | Include Negative Transactions | VarChar | Y) Yes N) No | 1 | Y | |||
| CDTransApp | Apply to Cash Discount Trans. | VarChar | Y) Yes N) No | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| CigTo | Contract Code ID To | Int | 11 | OCIG CIG Codes | ||||
| CupFrom | Unique Code of Project From | Int | 11 | OCUP CUP Codes | ||||
| CupTo | Unique Code of Project To | Int | 11 | OCUP CUP Codes | ||||
| CigFrom | Contract Code ID From | Int | 11 | OCIG CIG Codes | ||||
| BPLId | Active Branch | Int | 11 | OBPL Business Place | ||||
| BoeDDFrom | BoE Due Date From | Date | 8 | |||||
| BoeDDTo | BoE Due Date To | Date | 8 | |||||
| BoeNumFrom | BoE No. From | Int | 11 | OBOE Bill of Exchange for Payment | ||||
| BoeNumTo | BoE No. To | Int | 11 | OBOE Bill of Exchange for Payment | ||||
| BoeStatus | Bill of Exchange Status | nVarChar | 32 | |||||
| HaExistBoe | Handle Existing BoE | VarChar | Y) Yes N) No | 1 | N | |||
| SeriesPOO | Outgoing Payment Order Series | Int | 6 | NNM1 Documents Numbering - Series | 0 | |||
| SeriesPOI | Incoming Payment Order Series | Int | 6 | NNM1 Documents Numbering - Series | 0 | |||
| SeqType | Sequence Type | nVarChar | 4 | |||||
| PayDueDate | Payment Due Date Determination | VarChar | R) Run Date D) Document Due Date | 1 | R |
Table relationship map
SELECT statement
SELECT
OPWZ.IdNumber AS 'ID Number',
OPWZ.PmntDate AS 'Date of Payment Run',
OPWZ.NextDate AS 'A/P Due Date To',
OPWZ.OutgoType AS 'Outgoing Type',
OPWZ.IncomType AS 'Incoming Type',
OPWZ.CheckPmntM AS 'Check Payment Terms',
OPWZ.BnkTrnsPmM AS 'Bank Transfer Payment Terms',
OPWZ.FilePath AS 'File Path',
OPWZ.PostDtFrom AS 'Posting Date From',
OPWZ.PostDtTo AS 'Posting Date To',
OPWZ.ValDteFrom AS 'Due Date From',
OPWZ.ValDateTo AS 'Due Date To',
OPWZ.ApInvAmntF AS 'A/P Invoice Amount From',
OPWZ.ApInvAmntT AS 'A/P Invoice Amount To',
OPWZ.PchNoFrom AS 'A/P Invoice No. From',
OPWZ.PchNoTo AS 'A/P Invoice No. To',
OPWZ.InvNoFrom AS 'A/R Invoice No. From',
OPWZ.InvNoTo AS 'A/R Invoice No. To',
OPWZ.SelPriorit AS 'Selection Priority',
OPWZ.Status AS 'Object Status',
OPWZ.WizardName AS 'Wizard Name',
OPWZ.StatusDisc AS 'Status',
OPWZ.Canceled AS 'Canceled',
OPWZ.BoePmnMn AS 'Bill of Exchange Paymt Method',
OPWZ.SeriesOut AS 'Outgoing Series',
OPWZ.SeriesIn AS 'Incoming Series',
OPWZ.TotalOut AS 'Total Outgoing',
OPWZ.TotalIn AS 'Total Incoming',
OPWZ.ViewIntBal AS 'Include Interim Acct Balance',
OPWZ.SelMthd AS 'Selection Method',
OPWZ.MINumFrom AS 'Monthly Invoice No. From',
OPWZ.MINumTo AS 'Monthly Invoice No. To',
OPWZ.MIDateFrom AS 'Monthly Invoice Issued Date From',
OPWZ.MIDateTo AS 'Monthly Invoice Issued Date To',
OPWZ.MIVNumFrom AS 'A/P Monthly Invoice No. From',
OPWZ.MIVNumTo AS 'A/P Monthly Invoice No. To',
OPWZ.MIVDateFro AS 'A/P Monthly Invoice Date From',
OPWZ.MIVDateTo AS 'A/P Monthly Invoice Date To',
OPWZ.APDocDtFrm AS 'A/P Document Date From',
OPWZ.APDocDtTo AS 'A/P Document Date To',
OPWZ.APDueDtFrm AS 'A/P Due Date From',
OPWZ.NxtPmntDat AS 'Next Payment Run Date',
OPWZ.MinPayAR AS 'Minimum Incoming Payment',
OPWZ.MinPayAP AS 'Minimum Outgoing Payment',
OPWZ.ShowAtCard AS 'Display BP Ref. No.',
OPWZ.TolerDays AS 'Tolerance Days',
OPWZ.MinCashDis AS 'Min. Cash Discount',
OPWZ.NegBalBP AS 'Include Negative Balance BP',
OPWZ.ManualJE AS 'Include Manual JEs',
OPWZ.NegTrans AS 'Include Negative Transactions',
OPWZ.CDTransApp AS 'Apply to Cash Discount Trans.',
OPWZ.UserSign AS 'User Signature',
OPWZ.CigTo AS 'Contract Code ID To',
OPWZ.CupFrom AS 'Unique Code of Project From',
OPWZ.CupTo AS 'Unique Code of Project To',
OPWZ.CigFrom AS 'Contract Code ID From',
OPWZ.BPLId AS 'Active Branch',
OPWZ.BoeDDFrom AS 'BoE Due Date From',
OPWZ.BoeDDTo AS 'BoE Due Date To',
OPWZ.BoeNumFrom AS 'BoE No. From',
OPWZ.BoeNumTo AS 'BoE No. To',
OPWZ.BoeStatus AS 'Bill of Exchange Status',
OPWZ.HaExistBoe AS 'Handle Existing BoE',
OPWZ.SeriesPOO AS 'Outgoing Payment Order Series',
OPWZ.SeriesPOI AS 'Incoming Payment Order Series',
OPWZ.SeqType AS 'Sequence Type',
OPWZ.PayDueDate AS 'Payment Due Date Determination'
FROM OPWZ AS OPWZ
Related information
OPWZ SQL Table
Bill of Exchange for Payment OBOE SQL Table
Business Place OBPL SQL Table
CIG Codes OCIG SQL Table
CUP Codes OCUP 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
