|
|
DTW Payment Draft - Invoices
API Payments Invoices / Applied FC
PDF2 - Payment Draft - Invoices Table
Applied FC AppliedFC Property· Table: PDF2
Parent: Payments Invoices Payments_Invoices Object· Table: RCT2 PDF2 VPM2
Payment Draft OPDF SQL Table
Journal Entry OJDT SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocNum KEY UNIQUE | Document Number | Int | 11 | OPDF Payment Draft | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| InvoiceId | Sequence No. | Int | 11 | |||||
| DocEntry | Invoice Key | Int | 11 | |||||
| SumApplied | Paid to Invoice | Num | 20 | |||||
| AppliedFC | Paid in FC | Num | 20 | |||||
| AppliedSys | Paid in SC | Num | 20 | |||||
| InvType | Invoice Category | nVarChar | 203) A/R Down Payment 13) A/R Invoice 14) A/R Credit Memo 204) A/P Down Payment 18) A/P Invoice 19) A/P Credit Memo 24) Incoming Payment 25) Deposit 46) Payment Advice 57) Checks for Payment 76) Postdated Deposit -2) Opening Balance -3) Closing Balance 30) Journal Entry -1) All Transactions 163) A/P Correction Invoice 165) A/R Correction Invoice 0 | 20 | 13 | |||
| DocRate | Document Rate | Num | 20 | |||||
| Flags | Flags | Int | 11 | 0 | ||||
| IntrsStat | Interest Letter Status | VarChar | U) Not Sent S) Sent C) Closed | 1 | U | |||
| DocLine | Row Key | Int | 11 | 0 | ||||
| vatApplied | Tax Definition | Num | 20 | |||||
| vatAppldFC | Tax Paid in FC | Num | 20 | |||||
| vatAppldSy | Tax Paid in SC | Num | 20 | |||||
| selfInv | Autom. Invoice | VarChar | N) No Y) Yes | 1 | N | |||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| Dcount | Discount % | Num | 20 | |||||
| DcntSum | Discount Amount | Num | 20 | |||||
| DcntSumFC | Discount Amount (FC) | Num | 20 | |||||
| DcntSumSy | Discount Amount (SC) | Num | 20 | |||||
| BfDcntSum | Amount Before Discount | Num | 20 | |||||
| BfDcntSumF | Amount Before Discount (FC) | Num | 20 | |||||
| BfDcntSumS | Amount Before Discount (SC) | Num | 20 | |||||
| BfNetDcnt | Net Amount Bef. Discount | Num | 20 | |||||
| BfNetDcntF | Net Amount Bef. Discount (FC) | Num | 20 | |||||
| BfNetDcntS | Net Amount Bef. Discount (SC) | Num | 20 | |||||
| PaidSum | Amount Paid (LC) | Num | 20 | |||||
| ExpAppld | Freight applied | Num | 20 | |||||
| ExpAppldFC | Freight applied FC | Num | 20 | |||||
| ExpAppldSC | Freight applied SC | Num | 20 | |||||
| Rounddiff | Rounding Diff. | Num | 20 | |||||
| RounddifFc | Rounding Diff. (FC) | Num | 20 | |||||
| RounddifSc | Rounding Diff. (SC) | Num | 20 | |||||
| InstId | Installment ID | Int | 6 | 1 | ||||
| WtAppld | Applied WTax | Num | 20 | |||||
| WtAppldFC | Applied WTax (FC) | Num | 20 | |||||
| WtAppldSC | Applied WTax (SC) | Num | 20 | |||||
| LinkDate | Link Date | Date | 8 | |||||
| AmtDifPst | Amount Diffs. Posting Date | Date | 8 | |||||
| PaidDpm | Paid Down Payment | VarChar | N) No Y) Yes | 1 | N | |||
| DpmPosted | Link Date | VarChar | 1 | |||||
| ExpVatSum | VAT on Expenses Sum | Num | 20 | |||||
| ExpVatSumF | VAT on Expenses Sum (FC) | Num | 20 | |||||
| ExpVatSumS | VAT on Expenses Sum (SC) | Num | 20 | |||||
| IsRateDiff | Is Exchange Rate | VarChar | 1 | N | ||||
| WtInvCatS | Withholding Tax Invoice Categ. | Num | 20 | |||||
| WtInvCatSF | Withholding Tax Invoice Categ. | Num | 20 | |||||
| WtInvCatSS | Withholding Tax Invoice Categ. | Num | 20 | |||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| DocTransId KEY | Trans. ID of Paid Document | Int | 11 | OJDT Journal Entry | JDT | No | ||
| MIEntry | MI Entry Include this Payment | Int | 11 | 0 | ||||
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| IsSelected | Is Record Selected | VarChar | Y) Yes N) No | 1 | N | |||
| WTOnHold | Withholding Tax On Hold | Num | 20 | |||||
| WTOnhldPst | Withholding Tax Posted | Num | 20 | |||||
| baseAbs | Base Document Number | Int | 11 | |||||
| MIType | MI Type Include this Payment | nVarChar | 270) A/R Monthly Invoice 140000014) A/P Monthly Invoice | 20 |
Table relationship map
SELECT statement
SELECT
PDF2.DocNum AS 'Document Number',
PDF2.InvoiceId AS 'Sequence No.',
PDF2.DocEntry AS 'Invoice Key',
PDF2.SumApplied AS 'Paid to Invoice',
PDF2.AppliedFC AS 'Paid in FC',
PDF2.AppliedSys AS 'Paid in SC',
PDF2.InvType AS 'Invoice Category',
PDF2.DocRate AS 'Document Rate',
PDF2.Flags AS 'Flags',
PDF2.IntrsStat AS 'Interest Letter Status',
PDF2.DocLine AS 'Row Key',
PDF2.vatApplied AS 'Tax Definition',
PDF2.vatAppldFC AS 'Tax Paid in FC',
PDF2.vatAppldSy AS 'Tax Paid in SC',
PDF2.selfInv AS 'Autom. Invoice',
PDF2.ObjType AS 'Object Type',
PDF2.LogInstanc AS 'Log Instance',
PDF2.Dcount AS 'Discount %',
PDF2.DcntSum AS 'Discount Amount',
PDF2.DcntSumFC AS 'Discount Amount (FC)',
PDF2.DcntSumSy AS 'Discount Amount (SC)',
PDF2.BfDcntSum AS 'Amount Before Discount',
PDF2.BfDcntSumF AS 'Amount Before Discount (FC)',
PDF2.BfDcntSumS AS 'Amount Before Discount (SC)',
PDF2.BfNetDcnt AS 'Net Amount Bef. Discount',
PDF2.BfNetDcntF AS 'Net Amount Bef. Discount (FC)',
PDF2.BfNetDcntS AS 'Net Amount Bef. Discount (SC)',
PDF2.PaidSum AS 'Amount Paid (LC)',
PDF2.ExpAppld AS 'Freight applied',
PDF2.ExpAppldFC AS 'Freight applied FC',
PDF2.ExpAppldSC AS 'Freight applied SC',
PDF2.Rounddiff AS 'Rounding Diff.',
PDF2.RounddifFc AS 'Rounding Diff. (FC)',
PDF2.RounddifSc AS 'Rounding Diff. (SC)',
PDF2.InstId AS 'Installment ID',
PDF2.WtAppld AS 'Applied WTax',
PDF2.WtAppldFC AS 'Applied WTax (FC)',
PDF2.WtAppldSC AS 'Applied WTax (SC)',
PDF2.LinkDate AS 'Link Date',
PDF2.AmtDifPst AS 'Amount Diffs. Posting Date',
PDF2.PaidDpm AS 'Paid Down Payment',
PDF2.DpmPosted AS 'Link Date',
PDF2.ExpVatSum AS 'VAT on Expenses Sum',
PDF2.ExpVatSumF AS 'VAT on Expenses Sum (FC)',
PDF2.ExpVatSumS AS 'VAT on Expenses Sum (SC)',
PDF2.IsRateDiff AS 'Is Exchange Rate',
PDF2.WtInvCatS AS 'Withholding Tax Invoice Categ.',
PDF2.WtInvCatSF AS 'Withholding Tax Invoice Categ.',
PDF2.WtInvCatSS AS 'Withholding Tax Invoice Categ.',
PDF2.OcrCode AS 'Distribution Rule',
PDF2.DocTransId AS 'Trans. ID of Paid Document',
PDF2.MIEntry AS 'MI Entry Include this Payment',
PDF2.OcrCode2 AS 'Distribution Rule2',
PDF2.OcrCode3 AS 'Distribution Rule3',
PDF2.OcrCode4 AS 'Distribution Rule4',
PDF2.OcrCode5 AS 'Distribution Rule5',
PDF2.IsSelected AS 'Is Record Selected',
PDF2.WTOnHold AS 'Withholding Tax On Hold',
PDF2.WTOnhldPst AS 'Withholding Tax Posted',
PDF2.baseAbs AS 'Base Document Number',
PDF2.MIType AS 'MI Type Include this Payment'
FROM PDF2 AS PDF2
Related information
Applied FC AppliedFC Property· Table: PDF2
Sets or returns the amount paid in foreign currency. Field name: AppliedFC.
· Table: RCT2 PDF2 VPM2 Parent: Payments Invoices Payments_Invoices Object· Table: RCT2 PDF2 VPM2 Payment Draft OPDF SQL Table
Journal Entry OJDT SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
Payments_Invoices
Property
AppliedFC
Enumeration
Method
Property
AppliedFC
DTW DB
DiscountPercent
DTW DB
DistributionRule
DTW DB
DistributionRule2
DTW DB
DistributionRule3
DTW DB
DistributionRule4
DTW DB
DistributionRule5
DTW DB
DocEntry
DTW DB
DocLine
DTW DB
InstallmentId
DTW DB
InvoiceType
DTW DB
LineNum
DTW DB
LinkDate
DB
PaidSum
DTW DB
SumApplied
DTW DB
TotalDiscount
DTW DB
TotalDiscountFC
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
