|
|
API AJD1
AJD1 - Journal Entry - History - Rows Table
G/L Accounts OACT SQL Table
Journal Vouchers List OBTD SQL Table
Business Place OBPL SQL Table
CIG Codes OCIG 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
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 KEY | Account Code | nVarChar | 15 | OACT G/L Accounts | ACCOUNT | No | ||
| Debit | Debit Amount | Num | 20 | |||||
| Credit | Credit Amount | Num | 20 | |||||
| SYSCred | Credit Amount (SC) | Num | 20 | |||||
| SYSDeb | Debit Amount (SC) | Num | 20 | |||||
| FCDebit | Debit Amount (FC) | Num | 20 | |||||
| FCCredit | Credit Amount (FC) | Num | 20 | |||||
| FCCurrency KEY | Foreign Currency | nVarChar | 3 | CURRENCY | No | |||
| DueDate KEY | Value Date | Date | 8 | DUEDATE | No | |||
| SourceID | Source Key | Int | 11 | |||||
| SourceLine | Source Row No. | Int | 6 | |||||
| ShortName KEY | G/L Acc./BP Code | nVarChar | 15 | SHORT_NAME | No | |||
| IntrnMatch | Internal Reconciliation No. | Int | 11 | 0 | ||||
| ExtrMatch | External Reconciliation No. | Int | 11 | 0 | ||||
| ContraAct | Counter Account | nVarChar | 15 | |||||
| LineMemo | Row Details | nVarChar | 50 | |||||
| Ref3Line | Reference 3 | nVarChar | 27 | |||||
| TransType KEY | 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 | TRANS_TYPE | No | |
| RefDate KEY | Posting Date | Date | 8 | REFDATE | No | |||
| Ref2Date | Posting Date 3 | Date | 8 | |||||
| Ref1 | Ref. 1 | nVarChar | 100 | |||||
| Ref2 | Ref. 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 | Tax Date | Date | 8 | |||||
| SystemRate | Price (SC) | 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 | Tax Date | Date | 8 | |||||
| PaymentRef | Payment Reference | nVarChar | 27 | |||||
| SYSBaseSum | System Base Amount | Num | 20 | |||||
| MultMatch | Multiple BP Reconciliation No. | Int | 11 | 0 | ||||
| VatLine | VAT Line | 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 | Check Abs | Int | 11 | |||||
| LineType | LineType | 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 | Is Net | 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 | 0 | ||||
| MIVEntry | A/P Monthly Invoice | Int | 11 | 0 | ||||
| ClsInTP | Tax Payment Wizard | Int | 11 | 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
AJD1.TransId AS 'Transaction Key',
AJD1.Line_ID AS 'Row Number',
AJD1.Account AS 'Account Code',
AJD1.Debit AS 'Debit Amount',
AJD1.Credit AS 'Credit Amount',
AJD1.SYSCred AS 'Credit Amount (SC)',
AJD1.SYSDeb AS 'Debit Amount (SC)',
AJD1.FCDebit AS 'Debit Amount (FC)',
AJD1.FCCredit AS 'Credit Amount (FC)',
AJD1.FCCurrency AS 'Foreign Currency',
AJD1.DueDate AS 'Value Date',
AJD1.SourceID AS 'Source Key',
AJD1.SourceLine AS 'Source Row No.',
AJD1.ShortName AS 'G/L Acc./BP Code',
AJD1.IntrnMatch AS 'Internal Reconciliation No.',
AJD1.ExtrMatch AS 'External Reconciliation No.',
AJD1.ContraAct AS 'Counter Account',
AJD1.LineMemo AS 'Row Details',
AJD1.Ref3Line AS 'Reference 3',
AJD1.TransType AS 'Original Journal',
AJD1.RefDate AS 'Posting Date',
AJD1.Ref2Date AS 'Posting Date 3',
AJD1.Ref1 AS 'Ref. 1',
AJD1.Ref2 AS 'Ref. 2',
AJD1.CreatedBy AS 'Origin',
AJD1.BaseRef AS 'Base Reference',
AJD1.Project AS 'Project Code',
AJD1.TransCode AS 'Transaction Code',
AJD1.ProfitCode AS 'Distribution Rule',
AJD1.TaxDate AS 'Tax Date',
AJD1.SystemRate AS 'Price (SC)',
AJD1.MthDate AS 'Reconciliation Date',
AJD1.ToMthSum AS 'Reconciliation Total',
AJD1.UserSign AS 'User Signature',
AJD1.BatchNum AS 'Journal Voucher No.',
AJD1.FinncPriod AS 'Posting Period',
AJD1.RelTransId AS 'Linked Transaction Key',
AJD1.RelLineID AS 'Linked Row No.',
AJD1.RelType AS 'Link Type',
AJD1.LogInstanc AS 'Log Instance',
AJD1.VatGroup AS 'Tax Group',
AJD1.BaseSum AS 'Base Amount',
AJD1.VatRate AS 'Tax %',
AJD1.Indicator AS 'Indicator Code',
AJD1.AdjTran AS 'Adjusting Trans. (Period 13)',
AJD1.RevSource AS 'Revaluation Source',
AJD1.ObjType AS 'Object Type',
AJD1.VatDate AS 'Tax Date',
AJD1.PaymentRef AS 'Payment Reference',
AJD1.SYSBaseSum AS 'System Base Amount',
AJD1.MultMatch AS 'Multiple BP Reconciliation No.',
AJD1.VatLine AS 'VAT Line',
AJD1.VatAmount AS 'VAT Amount',
AJD1.SYSVatSum AS 'System VAT Amount',
AJD1.Closed AS 'Closed',
AJD1.GrossValue AS 'Gross Value',
AJD1.CheckAbs AS 'Check Abs',
AJD1.LineType AS 'LineType',
AJD1.DebCred AS 'Debit Credit Line Indicator',
AJD1.SequenceNr AS 'Assigned Sequence No.',
AJD1.StornoAcc AS 'Storno Account Code',
AJD1.BalDueDeb AS 'Balance Due - Debit',
AJD1.BalDueCred AS 'Balance Due - Credit',
AJD1.BalFcDeb AS 'Balance Due FC - Debit',
AJD1.BalFcCred AS 'Balance Due FC - Credit',
AJD1.BalScDeb AS 'Balance Due SC - Debit',
AJD1.BalScCred AS 'Balance Due SC - Credit',
AJD1.IsNet AS 'Is Net',
AJD1.DunWizBlck AS 'Wizard Dunning Block',
AJD1.DunnLevel AS 'Dunning Level',
AJD1.DunDate AS 'Last Dunning Date',
AJD1.TaxType AS 'Tax Type',
AJD1.TaxPostAcc AS 'Tax Posting Account',
AJD1.StaCode AS 'Authority Code',
AJD1.StaType AS 'Authority Type',
AJD1.TaxCode AS 'Tax Code',
AJD1.ValidFrom AS 'Valid From',
AJD1.GrossValFc AS 'Gross Value (FC)',
AJD1.LvlUpdDate AS 'Dunning Level Update Date',
AJD1.OcrCode2 AS 'Costing Code 2',
AJD1.OcrCode3 AS 'Costing Code 3',
AJD1.OcrCode4 AS 'Costing Code 4',
AJD1.OcrCode5 AS 'Costing Code 5',
AJD1.MIEntry AS 'MI Entry when include this OB',
AJD1.MIVEntry AS 'A/P Monthly Invoice',
AJD1.ClsInTP AS 'Tax Payment Wizard',
AJD1.CenVatCom AS 'CENVAT Component',
AJD1.MatType AS 'Material Type',
AJD1.PstngType AS 'Posting Type',
AJD1.ValidFrom2 AS 'Valid from2',
AJD1.ValidFrom3 AS 'Valid from3',
AJD1.ValidFrom4 AS 'Valid from4',
AJD1.ValidFrom5 AS 'Valid from5',
AJD1.Location AS 'Loc.',
AJD1.WTaxCode AS 'Withholding Tax Code',
AJD1.EquVatRate AS 'Equalization Tax %',
AJD1.EquVatSum AS 'Equalization Tax Amount',
AJD1.SYSEquSum AS 'System Equalization Tax Amount',
AJD1.TotalVat AS 'Total Tax',
AJD1.SYSTVat AS 'System Total Tax',
AJD1.WTLiable AS 'WTax-Liable',
AJD1.WTLine AS 'WTax Row',
AJD1.WTApplied AS 'Applied WTax',
AJD1.WTAppliedS AS 'Applied WTax (SC)',
AJD1.WTAppliedF AS 'Applied WTax (FC)',
AJD1.WTSum AS 'WTax Amount',
AJD1.WTSumFC AS 'WTax Amount (FC)',
AJD1.WTSumSC AS 'WTax Amount (SC)',
AJD1.PayBlock AS 'Payment Block',
AJD1.PayBlckRef AS 'Payment Block Abs Entry',
AJD1.LicTradNum AS 'Federal Tax ID',
AJD1.InterimTyp AS 'Interim Account Type',
AJD1.DprId AS 'Down Payment Request Key',
AJD1.MatchRef AS 'Reconciliation Reference',
AJD1.Ordered AS 'Payment Ordered',
AJD1.CUP AS 'Unique Code of Project',
AJD1.CIG AS 'Contract Code Identification',
AJD1.BPLId AS 'Branch',
AJD1.BPLName AS 'Branch Name',
AJD1.VatRegNum AS 'VAT Reg. Number',
AJD1.SLEDGERF AS 'Subledger Flag',
AJD1.ExTransId AS 'Exposed Transaction ID',
AJD1.InitRef2 AS 'Initial Reference 2',
AJD1.InitRef3Ln AS 'Initial Reference 3'
FROM AJD1 AS AJD1
Related information
G/L Accounts OACT SQL Table
Journal Vouchers List OBTD SQL Table
Business Place OBPL SQL Table
CIG Codes OCIG 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
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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
