|
|
SQL Finance / Journal Entry - Rows
DTW Financials / Journal Entry
API Reconciliation Journal Entry Lines / Reconciliation Journal Entry Line
JDT1 - Journal Entry - Rows Table
Reconciliation Journal Entry Line ReconciliationJournalEntryLine Object· Table: JDT1
Parent: Reconciliation Journal Entry Lines ReconciliationJournalEntryLines Collection
G/L Accounts OACT SQL Table
Journal Vouchers List OBTD SQL Table
Business Place OBPL SQL Table
CIG Codes OCIG SQL Table
Tax Payment Wizard OTPW SQL Table
CUP Codes OCUP SQL Table
Dunning Letters ODUN SQL Table
Posting Period OFPR SQL Table
Indicator OIDC SQL Table
Location OLCT SQL Table
A/R Monthly Invoice OMIN SQL Table
A/P Monthly Invoice OMIV SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
Payment Block OPYB SQL Table
Project Codes OPRJ SQL Table
Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
Sales Tax Codes OSTC SQL Table
Journal Entry Codes OTRC SQL Table
Journal Entry OJDT SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
Withholding Tax OWHT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TransId KEY UNIQUE | Transaction Key | Int | 11 | OJDT Journal Entry | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Line_ID | Row Number | Int | 11 | 0 | ||||
| Account | Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| Debit | Debit Amount | Num | 20 | |||||
| Credit | Credit Amount | Num | 20 | |||||
| SYSCred | System Credit Amount | Num | 20 | |||||
| SYSDeb | System Debit Amount | Num | 20 | |||||
| FCDebit | Debit Amount (FC) | Num | 20 | |||||
| FCCredit | Credit Amount (FC) | Num | 20 | |||||
| FCCurrency KEY | Foreign Currency | nVarChar | 3 | CURRENCY | No | |||
| DueDate KEY | Due Date | Date | 8 | DUEDATE | No | |||
| SourceID | Source Key | Int | 11 | |||||
| SourceLine | Source Row Number | Int | 6 | |||||
| ShortName KEY | BP/Account Code | nVarChar | 15 | INTRNMATCH | No | |||
| IntrnMatch | Internal Reconciliation No. | Int | 11 | 0 | ||||
| ExtrMatch | External Reconciliation No. | Int | 11 | 0 | ||||
| ContraAct | Offset Account | nVarChar | 15 | |||||
| LineMemo | Row Details | nVarChar | 50 | |||||
| Ref3Line | Reference 3 | nVarChar | 27 | |||||
| TransType | Original Journal | nVarChar | 15) Delivery 16) Returns 203) A/R Down Payment 13) A/R Invoice 14) A/R Credit Memo 132) Correction Invoice (-0) (- 20) Goods Receipt 21) Goods Return 204) A/P Down Payment 18) A/P Invoice 19) A/P Credit Memo 69) Landed Costs 163) A/P Correction Invoice (-1) (- 24) Incoming Payment 25) Deposit 46) Vendor Payment 57) Checks for Payment 76) Postdated Deposit 182) BoE Transaction (-2) (- -2) Opening Balance -3) Closing Balance 30) Journal Entry (-3) (- 58) Stock Update 59) Goods Receipt 60) Goods Issue 67) Inventory Transfers 68) Work Instructions 162) Inventory Valuation (-4) (- -1) All Transactions 321) Internal Reconciliation 140000009) Outgoing Excise Invoice 10000079) TDS Adjustment 164) A/P Correction Invoice Reversal 165) A/R Correction Invoice 166) A/R Correction Invoice Reversal 140000010) Incoming Excise Invoice (-5) (- 202) Production Order | 20 | -1 | |||
| RefDate KEY | Posting Date | Date | 8 | REFDATE | No | |||
| Ref2Date | Posting Date 3 | Date | 8 | |||||
| Ref1 | Reference 1 | nVarChar | 100 | |||||
| Ref2 | Reference 2 | nVarChar | 100 | |||||
| CreatedBy | Origin | Int | 11 | |||||
| BaseRef | Base Reference | nVarChar | 11 | |||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| TransCode | Transaction Code | nVarChar | 4 | OTRC Journal Entry Codes | ||||
| ProfitCode KEY | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | PROFIT_ID | No | ||
| TaxDate | Document Date | Date | 8 | |||||
| SystemRate | System Price | Num | 20 | |||||
| MthDate | Reconciliation Date | Date | 8 | |||||
| ToMthSum | Reconciliation Total | Num | 20 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| BatchNum | Journal Voucher No. | Int | 11 | OBTD Journal Vouchers List | ||||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| RelTransId | Linked Transaction Key | Int | 11 | -1 | ||||
| RelLineID | Linked Row No. | Int | 11 | -1 | ||||
| RelType | Link Type | VarChar | N) Without Link D) WTax Deduction - Correction | 1 | N | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| VatGroup | Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| BaseSum | Base Amount | Num | 20 | |||||
| VatRate | Tax % | Num | 20 | |||||
| Indicator | Indicator Code | nVarChar | 2 | OIDC Indicator | ||||
| AdjTran | Adjusting Trans. (Period 13) | VarChar | Y) Yes N) No | 1 | N | |||
| RevSource | Revaluation Source | VarChar | F) Foreign Currency S) System N) No | 1 | N | |||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 30 | |||
| VatDate | Document Date | Date | 8 | |||||
| PaymentRef | Payment Reference No. | nVarChar | 27 | |||||
| SYSBaseSum | System Base Amount | Num | 20 | |||||
| MultMatch | Multiple BP Reconciliation No. | Int | 11 | 0 | ||||
| VatLine | VAT Row | VarChar | Y) Yes N) No | 1 | N | |||
| VatAmount | VAT Amount | Num | 20 | |||||
| SYSVatSum | System VAT Amount | Num | 20 | |||||
| Closed | Closed | VarChar | 1 | N | ||||
| GrossValue | Gross Value | Num | 20 | |||||
| CheckAbs KEY | Internal Check Number | Int | 11 | JDT1CHECKA | No | |||
| LineType | Line Type | Int | 11 | 0 | ||||
| DebCred | Debit Credit Line Indicator | VarChar | D) Debit C) Credit | 1 | ||||
| SequenceNr | Assigned Sequence No. | Int | 11 | 0 | ||||
| StornoAcc | Storno Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| BalDueDeb | Balance Due - Debit | Num | 20 | |||||
| BalDueCred | Balance Due - Credit | Num | 20 | |||||
| BalFcDeb | Balance Due (FC) - Debit | Num | 20 | |||||
| BalFcCred | Balance Due (FC) - Credit | Num | 20 | |||||
| BalScDeb | Balance Due (SC) - Debit | Num | 20 | |||||
| BalScCred | Balance Due (SC) - Credit | Num | 20 | |||||
| IsNet | Use Net Amount | VarChar | Y) Yes N) No | 1 | Y | |||
| DunWizBlck | Wizard Dunning Block | VarChar | N) No Y) Yes | 1 | N | |||
| DunnLevel | Dunning Level | Int | 11 | ODUN Dunning Letters | 0 | |||
| DunDate | Last Dunning Date | Date | 8 | |||||
| TaxType | Tax Type | Int | 6 | 0 | ||||
| TaxPostAcc | Tax Posting Account | VarChar | N) R) Sales Tax Account P) Purchasing Tax Account | 1 | N | |||
| StaCode | Authority Code | nVarChar | 8 | OSTA Sales Tax Authorities | ||||
| StaType | Authority Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| TaxCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| ValidFrom | Valid From | Date | 8 | 19000101 | ||||
| GrossValFc | Gross Value (FC) | Num | 20 | |||||
| LvlUpdDate | Dunning Level Update Date | Date | 8 | |||||
| OcrCode2 | Costing Code 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Costing Code 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Costing Code 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Costing Code 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| MIEntry | MI Entry when include this OB | Int | 11 | OMIN A/R Monthly Invoice | 0 | |||
| MIVEntry | A/P Monthly Invoice | Int | 11 | OMIV A/P Monthly Invoice | 0 | |||
| ClsInTP | Tax Payment Wizard | Int | 11 | OTPW Tax Payment Wizard | 0 | |||
| CenVatCom | CENVAT Component | Int | 11 | -1 | ||||
| MatType | Material Type | Int | 11 | -1 | ||||
| PstngType | Posting Type | Int | 11 | 0 | ||||
| ValidFrom2 | Valid from2 | Date | 8 | 19000101 | ||||
| ValidFrom3 | Valid from3 | Date | 8 | 19000101 | ||||
| ValidFrom4 | Valid from4 | Date | 8 | 19000101 | ||||
| ValidFrom5 | Valid from5 | Date | 8 | 19000101 | ||||
| Location | Loc. | Int | 11 | OLCT Location | ||||
| WTaxCode | Withholding Tax Code | nVarChar | 4 | OWHT Withholding Tax | ||||
| EquVatRate | Equalization Tax % | Num | 20 | |||||
| EquVatSum | Equalization Tax Amount | Num | 20 | |||||
| SYSEquSum | System Equalization Tax Amount | Num | 20 | |||||
| TotalVat | Total Tax | Num | 20 | |||||
| SYSTVat | System Total Tax | Num | 20 | |||||
| WTLiable | WTax-Liable | VarChar | Y) Yes N) No | 1 | N | |||
| WTLine | WTax Row | VarChar | Y) Yes N) No | 1 | N | |||
| WTApplied | Applied WTax | Num | 20 | |||||
| WTAppliedS | Applied WTax (SC) | Num | 20 | |||||
| WTAppliedF | Applied WTax (FC) | Num | 20 | |||||
| WTSum | WTax Amount | Num | 20 | |||||
| WTSumFC | WTax Amount (FC) | Num | 20 | |||||
| WTSumSC | WTax Amount (SC) | Num | 20 | |||||
| PayBlock | Payment Block | VarChar | Y) Yes N) No | 1 | N | |||
| PayBlckRef | Payment Block Abs Entry | Int | 11 | OPYB Payment Block | ||||
| LicTradNum | Federal Tax ID | nVarChar | 32 | |||||
| InterimTyp | Interim Account Type | Int | 11 | 0 | ||||
| DprId | Down Payment Request Key | Int | 11 | |||||
| MatchRef | Reconciliation Reference | nVarChar | 20 | |||||
| Ordered | Payment Ordered | VarChar | Y) Yes N) No | 1 | N | |||
| CUP | Unique Code of Project | Int | 11 | OCUP CUP Codes | ||||
| CIG | Contract Code Identification | Int | 11 | OCIG CIG Codes | ||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| VatRegNum | VAT Reg. Number | nVarChar | 32 | |||||
| SLEDGERF | Subledger Flag | VarChar | 1 | |||||
| ExTransId | Exposed Transaction ID | Int | 11 | |||||
| InitRef2 | Initial Reference 2 | nVarChar | 100 | |||||
| InitRef3Ln | Initial Reference 3 | nVarChar | 27 |
Table relationship map
SELECT statement
SELECT
JDT1.TransId AS 'Transaction Key',
JDT1.Line_ID AS 'Row Number',
JDT1.Account AS 'Account Code',
JDT1.Debit AS 'Debit Amount',
JDT1.Credit AS 'Credit Amount',
JDT1.SYSCred AS 'System Credit Amount',
JDT1.SYSDeb AS 'System Debit Amount',
JDT1.FCDebit AS 'Debit Amount (FC)',
JDT1.FCCredit AS 'Credit Amount (FC)',
JDT1.FCCurrency AS 'Foreign Currency',
JDT1.DueDate AS 'Due Date',
JDT1.SourceID AS 'Source Key',
JDT1.SourceLine AS 'Source Row Number',
JDT1.ShortName AS 'BP/Account Code',
JDT1.IntrnMatch AS 'Internal Reconciliation No.',
JDT1.ExtrMatch AS 'External Reconciliation No.',
JDT1.ContraAct AS 'Offset Account',
JDT1.LineMemo AS 'Row Details',
JDT1.Ref3Line AS 'Reference 3',
JDT1.TransType AS 'Original Journal',
JDT1.RefDate AS 'Posting Date',
JDT1.Ref2Date AS 'Posting Date 3',
JDT1.Ref1 AS 'Reference 1',
JDT1.Ref2 AS 'Reference 2',
JDT1.CreatedBy AS 'Origin',
JDT1.BaseRef AS 'Base Reference',
JDT1.Project AS 'Project Code',
JDT1.TransCode AS 'Transaction Code',
JDT1.ProfitCode AS 'Distribution Rule',
JDT1.TaxDate AS 'Document Date',
JDT1.SystemRate AS 'System Price',
JDT1.MthDate AS 'Reconciliation Date',
JDT1.ToMthSum AS 'Reconciliation Total',
JDT1.UserSign AS 'User Signature',
JDT1.BatchNum AS 'Journal Voucher No.',
JDT1.FinncPriod AS 'Posting Period',
JDT1.RelTransId AS 'Linked Transaction Key',
JDT1.RelLineID AS 'Linked Row No.',
JDT1.RelType AS 'Link Type',
JDT1.LogInstanc AS 'Log Instance',
JDT1.VatGroup AS 'Tax Group',
JDT1.BaseSum AS 'Base Amount',
JDT1.VatRate AS 'Tax %',
JDT1.Indicator AS 'Indicator Code',
JDT1.AdjTran AS 'Adjusting Trans. (Period 13)',
JDT1.RevSource AS 'Revaluation Source',
JDT1.ObjType AS 'Object Type',
JDT1.VatDate AS 'Document Date',
JDT1.PaymentRef AS 'Payment Reference No.',
JDT1.SYSBaseSum AS 'System Base Amount',
JDT1.MultMatch AS 'Multiple BP Reconciliation No.',
JDT1.VatLine AS 'VAT Row',
JDT1.VatAmount AS 'VAT Amount',
JDT1.SYSVatSum AS 'System VAT Amount',
JDT1.Closed AS 'Closed',
JDT1.GrossValue AS 'Gross Value',
JDT1.CheckAbs AS 'Internal Check Number',
JDT1.LineType AS 'Line Type',
JDT1.DebCred AS 'Debit Credit Line Indicator',
JDT1.SequenceNr AS 'Assigned Sequence No.',
JDT1.StornoAcc AS 'Storno Account Code',
JDT1.BalDueDeb AS 'Balance Due - Debit',
JDT1.BalDueCred AS 'Balance Due - Credit',
JDT1.BalFcDeb AS 'Balance Due (FC) - Debit',
JDT1.BalFcCred AS 'Balance Due (FC) - Credit',
JDT1.BalScDeb AS 'Balance Due (SC) - Debit',
JDT1.BalScCred AS 'Balance Due (SC) - Credit',
JDT1.IsNet AS 'Use Net Amount',
JDT1.DunWizBlck AS 'Wizard Dunning Block',
JDT1.DunnLevel AS 'Dunning Level',
JDT1.DunDate AS 'Last Dunning Date',
JDT1.TaxType AS 'Tax Type',
JDT1.TaxPostAcc AS 'Tax Posting Account',
JDT1.StaCode AS 'Authority Code',
JDT1.StaType AS 'Authority Type',
JDT1.TaxCode AS 'Tax Code',
JDT1.ValidFrom AS 'Valid From',
JDT1.GrossValFc AS 'Gross Value (FC)',
JDT1.LvlUpdDate AS 'Dunning Level Update Date',
JDT1.OcrCode2 AS 'Costing Code 2',
JDT1.OcrCode3 AS 'Costing Code 3',
JDT1.OcrCode4 AS 'Costing Code 4',
JDT1.OcrCode5 AS 'Costing Code 5',
JDT1.MIEntry AS 'MI Entry when include this OB',
JDT1.MIVEntry AS 'A/P Monthly Invoice',
JDT1.ClsInTP AS 'Tax Payment Wizard',
JDT1.CenVatCom AS 'CENVAT Component',
JDT1.MatType AS 'Material Type',
JDT1.PstngType AS 'Posting Type',
JDT1.ValidFrom2 AS 'Valid from2',
JDT1.ValidFrom3 AS 'Valid from3',
JDT1.ValidFrom4 AS 'Valid from4',
JDT1.ValidFrom5 AS 'Valid from5',
JDT1.Location AS 'Loc.',
JDT1.WTaxCode AS 'Withholding Tax Code',
JDT1.EquVatRate AS 'Equalization Tax %',
JDT1.EquVatSum AS 'Equalization Tax Amount',
JDT1.SYSEquSum AS 'System Equalization Tax Amount',
JDT1.TotalVat AS 'Total Tax',
JDT1.SYSTVat AS 'System Total Tax',
JDT1.WTLiable AS 'WTax-Liable',
JDT1.WTLine AS 'WTax Row',
JDT1.WTApplied AS 'Applied WTax',
JDT1.WTAppliedS AS 'Applied WTax (SC)',
JDT1.WTAppliedF AS 'Applied WTax (FC)',
JDT1.WTSum AS 'WTax Amount',
JDT1.WTSumFC AS 'WTax Amount (FC)',
JDT1.WTSumSC AS 'WTax Amount (SC)',
JDT1.PayBlock AS 'Payment Block',
JDT1.PayBlckRef AS 'Payment Block Abs Entry',
JDT1.LicTradNum AS 'Federal Tax ID',
JDT1.InterimTyp AS 'Interim Account Type',
JDT1.DprId AS 'Down Payment Request Key',
JDT1.MatchRef AS 'Reconciliation Reference',
JDT1.Ordered AS 'Payment Ordered',
JDT1.CUP AS 'Unique Code of Project',
JDT1.CIG AS 'Contract Code Identification',
JDT1.BPLId AS 'Branch',
JDT1.BPLName AS 'Branch Name',
JDT1.VatRegNum AS 'VAT Reg. Number',
JDT1.SLEDGERF AS 'Subledger Flag',
JDT1.ExTransId AS 'Exposed Transaction ID',
JDT1.InitRef2 AS 'Initial Reference 2',
JDT1.InitRef3Ln AS 'Initial Reference 3'
FROM JDT1 AS JDT1
Related information
Reconciliation Journal Entry Line ReconciliationJournalEntryLine Object· Table: JDT1
Represents open transactions to be reconciled in journal entry. ReconciliationJournalEntryLine is a child object of the ExternalReconciliation object.
Source table: JDT1.
Parent: Reconciliation Journal Entry Lines ReconciliationJournalEntryLines CollectionG/L Accounts OACT SQL Table
Journal Vouchers List OBTD SQL Table
Business Place OBPL SQL Table
CIG Codes OCIG SQL Table
Tax Payment Wizard OTPW SQL Table
CUP Codes OCUP SQL Table
Dunning Letters ODUN SQL Table
Posting Period OFPR SQL Table
Indicator OIDC SQL Table
Location OLCT SQL Table
A/R Monthly Invoice OMIN SQL Table
A/P Monthly Invoice OMIV SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
Payment Block OPYB SQL Table
Project Codes OPRJ SQL Table
Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
Sales Tax Codes OSTC SQL Table
Journal Entry Codes OTRC SQL Table
Journal Entry OJDT SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
Withholding Tax OWHT SQL Table
ReconciliationJournalEntryLines
Object
ReconciliationJournalEntryLine
Method
Property
CreditAmount
DB
DebitAmount
DB
Details
DB
DueDate
DB
PostingDate
DB
Ref1
DB
Ref2
DB
Ref3
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
