|
|
DTW Incoming Payments - Invoices
API Payments Invoices / Applied FC
RCT2 - Incoming Payments - Invoices Table
Applied FC AppliedFC Property· Table: RCT2
Parent: Payments Invoices Payments_Invoices Object· Table: RCT2 PDF2 VPM2
Incoming Payment ORCT 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 | ORCT Incoming Payment | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| InvoiceId | Sequence No. | Int | 11 | |||||
| DocEntry | Invoice Key | Int | 11 | |||||
| SumApplied | Paid to Invoice | Num | 20 | |||||
| AppliedFC | Paid (FC) | Num | 20 | |||||
| AppliedSys | Paid (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 (FC) | Num | 20 | |||||
| vatAppldSy | Tax Paid (SC) | Num | 20 | |||||
| selfInv | Autom. Invoice | VarChar | N) No Y) Yes | 1 | N | |||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 24 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| Dcount | Discount Rate | 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 Before Discount | Num | 20 | |||||
| BfNetDcntF | Net Amt Before Discount (FC) | Num | 20 | |||||
| BfNetDcntS | Net Amt Before Discount (SC) | Num | 20 | |||||
| PaidSum | Paid Amount (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 Freight Sum | Num | 20 | |||||
| ExpVatSumF | VAT on Freight Sum (FC) | Num | 20 | |||||
| ExpVatSumS | VAT on Freight 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 Rule 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule 5 | 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
RCT2.DocNum AS 'Document Number',
RCT2.InvoiceId AS 'Sequence No.',
RCT2.DocEntry AS 'Invoice Key',
RCT2.SumApplied AS 'Paid to Invoice',
RCT2.AppliedFC AS 'Paid (FC)',
RCT2.AppliedSys AS 'Paid (SC)',
RCT2.InvType AS 'Invoice Category',
RCT2.DocRate AS 'Document Rate',
RCT2.Flags AS 'Flags',
RCT2.IntrsStat AS 'Interest Letter Status',
RCT2.DocLine AS 'Row Key',
RCT2.vatApplied AS 'Tax Definition',
RCT2.vatAppldFC AS 'Tax Paid (FC)',
RCT2.vatAppldSy AS 'Tax Paid (SC)',
RCT2.selfInv AS 'Autom. Invoice',
RCT2.ObjType AS 'Object Type',
RCT2.LogInstanc AS 'Log Instance',
RCT2.Dcount AS 'Discount Rate',
RCT2.DcntSum AS 'Discount Amount',
RCT2.DcntSumFC AS 'Discount Amount (FC)',
RCT2.DcntSumSy AS 'Discount Amount (SC)',
RCT2.BfDcntSum AS 'Amount Before Discount',
RCT2.BfDcntSumF AS 'Amount Before Discount (FC)',
RCT2.BfDcntSumS AS 'Amount Before Discount (SC)',
RCT2.BfNetDcnt AS 'Net Amount Before Discount',
RCT2.BfNetDcntF AS 'Net Amt Before Discount (FC)',
RCT2.BfNetDcntS AS 'Net Amt Before Discount (SC)',
RCT2.PaidSum AS 'Paid Amount (LC)',
RCT2.ExpAppld AS 'Freight applied',
RCT2.ExpAppldFC AS 'Freight applied FC',
RCT2.ExpAppldSC AS 'Freight applied SC',
RCT2.Rounddiff AS 'Rounding Diff.',
RCT2.RounddifFc AS 'Rounding Diff. (FC)',
RCT2.RounddifSc AS 'Rounding Diff. (SC)',
RCT2.InstId AS 'Installment ID',
RCT2.WtAppld AS 'Applied WTax',
RCT2.WtAppldFC AS 'Applied WTax (FC)',
RCT2.WtAppldSC AS 'Applied WTax (SC)',
RCT2.LinkDate AS 'Link Date',
RCT2.AmtDifPst AS 'Amount Diffs. Posting Date',
RCT2.PaidDpm AS 'Paid Down Payment',
RCT2.DpmPosted AS 'Link Date',
RCT2.ExpVatSum AS 'VAT on Freight Sum',
RCT2.ExpVatSumF AS 'VAT on Freight Sum (FC)',
RCT2.ExpVatSumS AS 'VAT on Freight Sum (SC)',
RCT2.IsRateDiff AS 'Is Exchange Rate',
RCT2.WtInvCatS AS 'Withholding Tax Invoice Categ.',
RCT2.WtInvCatSF AS 'Withholding Tax Invoice Categ.',
RCT2.WtInvCatSS AS 'Withholding Tax Invoice Categ.',
RCT2.OcrCode AS 'Distribution Rule',
RCT2.DocTransId AS 'Trans. ID of Paid Document',
RCT2.MIEntry AS 'MI Entry Include this Payment',
RCT2.OcrCode2 AS 'Distribution Rule 2',
RCT2.OcrCode3 AS 'Distribution Rule 3',
RCT2.OcrCode4 AS 'Distribution Rule 4',
RCT2.OcrCode5 AS 'Distribution Rule 5',
RCT2.IsSelected AS 'Is Record Selected',
RCT2.WTOnHold AS 'Withholding Tax On Hold',
RCT2.WTOnhldPst AS 'Withholding Tax Posted',
RCT2.baseAbs AS 'Base Document Number',
RCT2.MIType AS 'MI Type Include this Payment'
FROM RCT2 AS RCT2
Related information
Applied FC AppliedFC Property· Table: RCT2
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 Incoming Payment ORCT 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
