|
|
API ARC2
ARC2 - Incoming Payment - Invoices - History Table
Outgoing Payments OVPM 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 | OVPM Outgoing Payments | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| InvoiceId | Sequence No. | Int | 11 | |||||
| DocEntry | Invoice Key | Int | 11 | |||||
| SumApplied | Paid (LC) | Num | 20 | |||||
| AppliedFC | Paid (FC) | Num | 20 | |||||
| AppliedSys | Paid (SC) | Num | 20 | |||||
| InvType | Document Type | 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 | Auto. 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 Bef. Discount | Num | 20 | |||||
| BfDcntSumF | Amount Bef. Discount (FC) | Num | 20 | |||||
| BfDcntSumS | Amount Bef. 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 WT (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 | Trans. ID of Paid Document | Int | 11 | OJDT Journal Entry | ||||
| 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
ARC2.DocNum AS 'Document Number',
ARC2.InvoiceId AS 'Sequence No.',
ARC2.DocEntry AS 'Invoice Key',
ARC2.SumApplied AS 'Paid (LC)',
ARC2.AppliedFC AS 'Paid (FC)',
ARC2.AppliedSys AS 'Paid (SC)',
ARC2.InvType AS 'Document Type',
ARC2.DocRate AS 'Document Rate',
ARC2.Flags AS 'Flags',
ARC2.IntrsStat AS 'Interest Letter Status',
ARC2.DocLine AS 'Row Key',
ARC2.vatApplied AS 'Tax Definition',
ARC2.vatAppldFC AS 'Tax Paid (FC)',
ARC2.vatAppldSy AS 'Tax Paid (SC)',
ARC2.selfInv AS 'Auto. Invoice',
ARC2.ObjType AS 'Object Type',
ARC2.LogInstanc AS 'Log Instance',
ARC2.Dcount AS 'Discount',
ARC2.DcntSum AS 'Discount Amount',
ARC2.DcntSumFC AS 'Discount Amount (FC)',
ARC2.DcntSumSy AS 'Discount Amount (SC)',
ARC2.BfDcntSum AS 'Amount Bef. Discount',
ARC2.BfDcntSumF AS 'Amount Bef. Discount (FC)',
ARC2.BfDcntSumS AS 'Amount Bef. Discount (SC)',
ARC2.BfNetDcnt AS 'Net Amount Bef. Discount',
ARC2.BfNetDcntF AS 'Net Amount Bef. Discount (FC)',
ARC2.BfNetDcntS AS 'Net Amount Bef. Discount (SC)',
ARC2.PaidSum AS 'Amount Paid (LC)',
ARC2.ExpAppld AS 'Freight applied',
ARC2.ExpAppldFC AS 'Freight applied FC',
ARC2.ExpAppldSC AS 'Freight applied SC',
ARC2.Rounddiff AS 'Rounding Diff.',
ARC2.RounddifFc AS 'Rounding Diff. (FC)',
ARC2.RounddifSc AS 'Rounding Diff. (SC)',
ARC2.InstId AS 'Installment ID',
ARC2.WtAppld AS 'Applied WTax',
ARC2.WtAppldFC AS 'Applied WT (FC)',
ARC2.WtAppldSC AS 'Applied WTax (SC)',
ARC2.LinkDate AS 'Link Date',
ARC2.AmtDifPst AS 'Amount Diffs. Posting Date',
ARC2.PaidDpm AS 'Paid Down Payment',
ARC2.DpmPosted AS 'Link Date',
ARC2.ExpVatSum AS 'VAT on Expenses Sum',
ARC2.ExpVatSumF AS 'VAT on Expenses Sum (FC)',
ARC2.ExpVatSumS AS 'VAT on Expenses Sum (SC)',
ARC2.IsRateDiff AS 'Is Exchange Rate',
ARC2.WtInvCatS AS 'Withholding Tax Invoice Categ.',
ARC2.WtInvCatSF AS 'Withholding Tax Invoice Categ.',
ARC2.WtInvCatSS AS 'Withholding Tax Invoice Categ.',
ARC2.OcrCode AS 'Distribution Rule',
ARC2.DocTransId AS 'Trans. ID of Paid Document',
ARC2.MIEntry AS 'MI Entry Include this Payment',
ARC2.OcrCode2 AS 'Distribution Rule2',
ARC2.OcrCode3 AS 'Distribution Rule3',
ARC2.OcrCode4 AS 'Distribution Rule4',
ARC2.OcrCode5 AS 'Distribution Rule5',
ARC2.IsSelected AS 'Is Record Selected',
ARC2.WTOnHold AS 'Withholding Tax On Hold',
ARC2.WTOnhldPst AS 'Withholding Tax Posted',
ARC2.baseAbs AS 'Base Document Number',
ARC2.MIType AS 'MI Type Include this Payment'
FROM ARC2 AS ARC2
Related information
Outgoing Payments OVPM SQL Table
Journal Entry OJDT SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
