|
|
API ITR1
ITR1 - Internal Reconciliation - Rows Table
G/L Accounts OACT SQL Table
Currency Codes OCRN SQL Table
Internal Reconciliation OITR SQL Table
Journal Entry OJDT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ReconNum KEY UNIQUE | Reconciliation Number | Int | 11 | OITR Internal Reconciliation | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineSeq | Row Number | Int | 11 | |||||
| ShortName | BP/Account Code | nVarChar | 15 | |||||
| TransId KEY | Transaction Internal ID | Int | 11 | OJDT Journal Entry | Journal | No | ||
| TransRowId | Transaction Row Number | Int | 11 | |||||
| SrcObjTyp KEY | Source Object Type | nVarChar | 30) Journal Transactions 13) Invoices 18) Purchases 24) Receipts 46) Outgoing Payments 14) Revert Invoices 19) Revert Purchases 203) Down Payment Incoming 204) Down Payment Outgoing 163) Correction A/P Invoice 164) Correction A/P Invoice Reversals 165) Correction A/R Invoice 166) Correction A/R Invoice Reversals | 20 | Object | No | ||
| SrcObjAbs | Source Object Internal ID | Int | 11 | |||||
| ReconSum | Reconciliation Amount | Num | 20 | |||||
| ReconSumFC | Reconciliation Amount (FC) | Num | 20 | |||||
| ReconSumSC | Reconciliation Amount (SC) | Num | 20 | |||||
| FrgnCurr | Foreign Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| SumMthCurr | Amt in Reconciliation Currency | Num | 20 | |||||
| IsCredit | Credit or Debit | VarChar | C) Credit D) Debit | 1 | ||||
| Account | Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| CashDisSum | Cash Discount Amount | Num | 20 | |||||
| WTSum | Withholding Tax Amount | Num | 20 | |||||
| WTSumFC | Withholding Tax Amount (FC) | Num | 20 | |||||
| WTSumSC | Withholding Tax Amount (SC) | Num | 20 | |||||
| ExpSum | Freight Amount | Num | 20 | |||||
| ExpSumFC | Freight Amount (FC) | Num | 20 | |||||
| ExpSumSC | Freight Amount (SC) | Num | 20 | |||||
| netBefDisc | Net Before Discount Sum | Num | 20 | |||||
| MIEntry | MI Entry Include this Recon. | Int | 11 | 0 | ||||
| MIType | MI Type Include this Recon. | nVarChar | 270) A/R Monthly Invoice 140000014) A/P Monthly Invoice | 20 |
Table relationship map
SELECT statement
SELECT
ITR1.ReconNum AS 'Reconciliation Number',
ITR1.LineSeq AS 'Row Number',
ITR1.ShortName AS 'BP/Account Code',
ITR1.TransId AS 'Transaction Internal ID',
ITR1.TransRowId AS 'Transaction Row Number',
ITR1.SrcObjTyp AS 'Source Object Type',
ITR1.SrcObjAbs AS 'Source Object Internal ID',
ITR1.ReconSum AS 'Reconciliation Amount',
ITR1.ReconSumFC AS 'Reconciliation Amount (FC)',
ITR1.ReconSumSC AS 'Reconciliation Amount (SC)',
ITR1.FrgnCurr AS 'Foreign Currency',
ITR1.SumMthCurr AS 'Amt in Reconciliation Currency',
ITR1.IsCredit AS 'Credit or Debit',
ITR1.Account AS 'Account Code',
ITR1.CashDisSum AS 'Cash Discount Amount',
ITR1.WTSum AS 'Withholding Tax Amount',
ITR1.WTSumFC AS 'Withholding Tax Amount (FC)',
ITR1.WTSumSC AS 'Withholding Tax Amount (SC)',
ITR1.ExpSum AS 'Freight Amount',
ITR1.ExpSumFC AS 'Freight Amount (FC)',
ITR1.ExpSumSC AS 'Freight Amount (SC)',
ITR1.netBefDisc AS 'Net Before Discount Sum',
ITR1.MIEntry AS 'MI Entry Include this Recon.',
ITR1.MIType AS 'MI Type Include this Recon.'
FROM ITR1 AS ITR1
Related information
G/L Accounts OACT SQL Table
Currency Codes OCRN SQL Table
Internal Reconciliation OITR SQL Table
Journal Entry OJDT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
