|
|
API AJDT
AJDT - Journal Entry - History Table
AJDT SQL Table
Blanket Agreement OOAT SQL Table
Journal Vouchers List OBTD SQL Table
CIG Codes OCIG SQL Table
CUP Codes OCUP SQL Table
JE Document Type OJET SQL Table
Posting Period OFPR SQL Table
Indicator OIDC SQL Table
Location OLCT SQL Table
Object Settings - History ADP1 SQL Table
Currency Codes OCRN SQL Table
Project Codes OPRJ SQL Table
Journal Entry Codes OTRC SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BatchNum | Journal Voucher No. | Int | 11 | OBTD Journal Vouchers List |
|---|---|---|---|---|---|---|---|---|
| TransId KEY UNIQUE | Transaction Number | Int | 11 | PRIMARY | Yes | |||
| BtfStatus | Status | VarChar | O) Open C) Closed | 1 | O | |||
| TransType KEY | Original Journal | nVarChar | 16) Returns 203) A/R Down Payment 15) Delivery 13) A/R Invoice 165) A/R Correction Invoice 166) A/R Correction Invoice Reversal 14) A/R Credit Memo 132) Correction Invoice (-0) (- 20) Goods Receipt PO 21) Goods Return 204) A/P Down Payment 18) A/P Invoice 163) A/P Correction Invoice 164) A/P Correction Invoice Reversal 19) A/P Credit Memo 281) A/P Tax Invoice 69) Landed Costs (-1) (- 140000009) Outgoing Excise Invoice 140000010) Incoming Excise Invoice 10000079) TDS Adjustment (-2) (- 24) Incoming Payment 25) Deposit 46) Vendor Payment 57) Checks for Payment 76) Postdated Deposit 182) BoE Transaction (-3) (- -2) Opening Balance -3) Closing Balance 321) Internal Reconciliation 10000046) Data Archive 30) Journal Entry (-4) (- 58) Inventory List 59) Goods Receipt 60) Goods Issue 67) Inventory Transfers 68) Work Instructions 162) Inventory Valuation 202) Production Order (-5) (- 1470000049) Fixed Asset Capitalization 1470000060) Fixed Asset Capitalization Credit Memo 1470000094) Fixed Asset Retirement 1470000075) Fixed Asset Manual Depreciation 1470000090) Fixed Asset Transfer 1470000085) Fixed Asset Revaluation (-6) (- -1) All Transactions 310000001) Inventory Opening Balance 10000071) Inventory Posting | 20 | -1 | TRANS_TYPE | No | |
| BaseRef | Base Reference | nVarChar | 11 | |||||
| RefDate KEY | Posting Date | Date | 8 | REFDATE | No | |||
| Memo | Details | nVarChar | 50 | |||||
| Ref1 | Ref. 1 | nVarChar | 100 | |||||
| Ref2 | Ref. 2 | nVarChar | 100 | |||||
| CreatedBy | Original | Int | 11 | |||||
| LocTotal | Total (LC) | Num | 20 | |||||
| FcTotal | Total (FC) | Num | 20 | |||||
| SysTotal | Total (SC) | Num | 20 | |||||
| TransCode | Transaction Code | nVarChar | 4 | OTRC Journal Entry Codes | ||||
| OrignCurr | Revaluation Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| TransRate | Revaluation Rate | Num | 20 | |||||
| BtfLine | Row No. in Voucher | Int | 11 | |||||
| TransCurr | Transaction Currency | nVarChar | 3 | |||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| DueDate | Due Date | Date | 8 | |||||
| TaxDate | Document Date | Date | 8 | |||||
| PCAddition | PC Addition | VarChar | Y) Yes N) No | 1 | N | |||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updated by | Int | 6 | OUSR Users | ||||
| RefndRprt | Reported in 874 | VarChar | Y) Yes N) No | 1 | N | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | ||||
| Indicator | Indicator Code | nVarChar | 2 | OIDC Indicator | ||||
| AdjTran | Adjusting Transaction | VarChar | Y) Yes N) No | 1 | N | |||
| RevSource | Revaluation Source | VarChar | F) Foreign Currency S) System N) No | 1 | N | |||
| StornoDate | Reversal Date | Date | 8 | |||||
| StornoToTr KEY | Reversed Transaction | Int | 11 | STORNO_TRA | No | |||
| AutoStorno | Use Auto-Reverse | VarChar | Y) Yes N) No | 1 | N | |||
| Corisptivi | Transaction Values | VarChar | Y) Yes N) No | 1 | N | |||
| VatDate | VAT Date | Date | 8 | |||||
| StampTax | Stamp Tax | VarChar | Y) Yes N) No | 1 | N | |||
| Series | Series | Int | 6 | 0 | ||||
| Number | Number | Int | 11 | |||||
| AutoVAT | Auto VAT | VarChar | Y) Yes N) No | 1 | N | |||
| DocSeries | Document Series | Int | 6 | |||||
| FolioPref | Folio Prefix String | nVarChar | 4 | |||||
| FolioNum | Folio Number | Int | 11 | |||||
| CreateTime | Generation Time | Int | 6 | |||||
| BlockDunn | Block Dunning Letter | VarChar | N) No Y) Yes | 1 | N | |||
| ReportEU | Include in EU Report | VarChar | Y) Yes N) No | 1 | N | |||
| Report347 | Include in 347 Report | VarChar | Y) Yes N) No | 1 | N | |||
| Printed | Printed | VarChar | Y) Yes N) No | 1 | N | |||
| DocType | Document Type | nVarChar | 60 | OJET JE Document Type | ||||
| AttNum | Number of Attachments | Int | 11 | 0 | ||||
| GenRegNo | Generate Reg. No. or Not | VarChar | Y) Yes N) No | 1 | N | |||
| RG23APart2 | RG23A Part2 No | Int | 11 | |||||
| RG23CPart2 | RG23C Part2 No | Int | 11 | |||||
| MatType | Material Type | Int | 11 | |||||
| Creator | Creator Name | nVarChar | 127 | |||||
| Approver | Approver Name | nVarChar | 127 | |||||
| Location | Loc. | Int | 11 | OLCT Location | ||||
| SeqCode | Sequence Code | Int | 6 | |||||
| Serial | Serial Number | Int | 11 | |||||
| SeriesStr | Series String | nVarChar | 3 | |||||
| SubStr | Subseries String | nVarChar | 3 | |||||
| AutoWT | Automatic WTax | VarChar | Y) Yes N) No | 1 | N | |||
| WTSum | WTax Amount | Num | 20 | |||||
| WTSumSC | WTax Amount (SC) | Num | 20 | |||||
| WTSumFC | WTax Amount (FC) | Num | 20 | |||||
| WTApplied | Applied WTax | Num | 20 | |||||
| WTAppliedS | Applied WTax (SC) | Num | 20 | |||||
| WTAppliedF | Applied WTax (FC) | Num | 20 | |||||
| BaseAmnt | Base Amount | Num | 20 | |||||
| BaseAmntSC | Base Amount (SC) | Num | 20 | |||||
| BaseAmntFC | Base Amount (FC) | Num | 20 | |||||
| BaseVtAt | WTax Base VAT Amount | Num | 20 | |||||
| BaseVtAtSC | WTax Base VAT Amount (SC) | Num | 20 | |||||
| BaseVtAtFC | WTax Base VAT Amount (FC) | Num | 20 | |||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| BaseTrans | Base Transaction Number | Int | 11 | |||||
| ResidenNum | Residence Number | VarChar | 1) Spanish Fiscal ID 2) VAT Registration Number 3) Passport 4) Fiscal ID Issued by the Country of Residence 5) Certificate of Fiscal Residence 6) Other Document | 1 | 1 | |||
| OperatCode | Operation Code | VarChar | 1 | |||||
| Ref3 | Reference 3 | nVarChar | 27 | |||||
| SSIExmpt | SSI Exemption | VarChar | Y) Yes N) No | 1 | ||||
| SignMsg | Signature Input Message | Text | 16 | |||||
| SignDigest | Signature Digest | Text | 16 | |||||
| CertifNum | Certification Number | nVarChar | 50 | |||||
| KeyVersion | Private Key Version | Int | 11 | |||||
| CUP | Unique Code of Project | Int | 11 | OCUP CUP Codes | ||||
| CIG | Contract Code Identification | Int | 11 | OCIG CIG Codes | ||||
| SupplCode | Supplementary Code | nVarChar | 127 | |||||
| SPSrcType | Service Posting Source Type | Int | 11 | |||||
| SPSrcID | Service Posting Source ID | Int | 11 | |||||
| SPSrcDLN | Service Post. Source Delivery | Int | 11 | |||||
| DeferedTax | Deferred Tax | VarChar | Y) Yes N) No | 1 | N | |||
| AgrNo | Blanket Agreement Number | Int | 11 | OOAT Blanket Agreement | ||||
| SeqNum | Sequence Number | Int | 11 | |||||
| ECDPosTyp | ECD Posting Type | VarChar | N) Normal E) Statement | 1 | N | |||
| RptPeriod | Reporting Period | nVarChar | 5 | |||||
| RptMonth | Reporting Month | Date | 8 | |||||
| ExTransId | Exposed Transaction ID | Int | 11 |
Table relationship map
SELECT statement
SELECT
AJDT.BatchNum AS 'Journal Voucher No.',
AJDT.TransId AS 'Transaction Number',
AJDT.BtfStatus AS 'Status',
AJDT.TransType AS 'Original Journal',
AJDT.BaseRef AS 'Base Reference',
AJDT.RefDate AS 'Posting Date',
AJDT.Memo AS 'Details',
AJDT.Ref1 AS 'Ref. 1',
AJDT.Ref2 AS 'Ref. 2',
AJDT.CreatedBy AS 'Original',
AJDT.LocTotal AS 'Total (LC)',
AJDT.FcTotal AS 'Total (FC)',
AJDT.SysTotal AS 'Total (SC)',
AJDT.TransCode AS 'Transaction Code',
AJDT.OrignCurr AS 'Revaluation Currency',
AJDT.TransRate AS 'Revaluation Rate',
AJDT.BtfLine AS 'Row No. in Voucher',
AJDT.TransCurr AS 'Transaction Currency',
AJDT.Project AS 'Project Code',
AJDT.DueDate AS 'Due Date',
AJDT.TaxDate AS 'Document Date',
AJDT.PCAddition AS 'PC Addition',
AJDT.FinncPriod AS 'Posting Period',
AJDT.DataSource AS 'Data Source',
AJDT.UpdateDate AS 'Date of Update',
AJDT.CreateDate AS 'Creation Date',
AJDT.UserSign AS 'User Signature',
AJDT.UserSign2 AS 'Updated by',
AJDT.RefndRprt AS 'Reported in 874',
AJDT.LogInstanc AS 'Log Instance',
AJDT.ObjType AS 'Object Type',
AJDT.Indicator AS 'Indicator Code',
AJDT.AdjTran AS 'Adjusting Transaction',
AJDT.RevSource AS 'Revaluation Source',
AJDT.StornoDate AS 'Reversal Date',
AJDT.StornoToTr AS 'Reversed Transaction',
AJDT.AutoStorno AS 'Use Auto-Reverse',
AJDT.Corisptivi AS 'Transaction Values',
AJDT.VatDate AS 'VAT Date',
AJDT.StampTax AS 'Stamp Tax',
AJDT.Series AS 'Series',
AJDT.Number AS 'Number',
AJDT.AutoVAT AS 'Auto VAT',
AJDT.DocSeries AS 'Document Series',
AJDT.FolioPref AS 'Folio Prefix String',
AJDT.FolioNum AS 'Folio Number',
AJDT.CreateTime AS 'Generation Time',
AJDT.BlockDunn AS 'Block Dunning Letter',
AJDT.ReportEU AS 'Include in EU Report',
AJDT.Report347 AS 'Include in 347 Report',
AJDT.Printed AS 'Printed',
AJDT.DocType AS 'Document Type',
AJDT.AttNum AS 'Number of Attachments',
AJDT.GenRegNo AS 'Generate Reg. No. or Not',
AJDT.RG23APart2 AS 'RG23A Part2 No',
AJDT.RG23CPart2 AS 'RG23C Part2 No',
AJDT.MatType AS 'Material Type',
AJDT.Creator AS 'Creator Name',
AJDT.Approver AS 'Approver Name',
AJDT.Location AS 'Loc.',
AJDT.SeqCode AS 'Sequence Code',
AJDT.Serial AS 'Serial Number',
AJDT.SeriesStr AS 'Series String',
AJDT.SubStr AS 'Subseries String',
AJDT.AutoWT AS 'Automatic WTax',
AJDT.WTSum AS 'WTax Amount',
AJDT.WTSumSC AS 'WTax Amount (SC)',
AJDT.WTSumFC AS 'WTax Amount (FC)',
AJDT.WTApplied AS 'Applied WTax',
AJDT.WTAppliedS AS 'Applied WTax (SC)',
AJDT.WTAppliedF AS 'Applied WTax (FC)',
AJDT.BaseAmnt AS 'Base Amount',
AJDT.BaseAmntSC AS 'Base Amount (SC)',
AJDT.BaseAmntFC AS 'Base Amount (FC)',
AJDT.BaseVtAt AS 'WTax Base VAT Amount',
AJDT.BaseVtAtSC AS 'WTax Base VAT Amount (SC)',
AJDT.BaseVtAtFC AS 'WTax Base VAT Amount (FC)',
AJDT.VersionNum AS 'Version Number',
AJDT.BaseTrans AS 'Base Transaction Number',
AJDT.ResidenNum AS 'Residence Number',
AJDT.OperatCode AS 'Operation Code',
AJDT.Ref3 AS 'Reference 3',
AJDT.SSIExmpt AS 'SSI Exemption',
AJDT.SignMsg AS 'Signature Input Message',
AJDT.SignDigest AS 'Signature Digest',
AJDT.CertifNum AS 'Certification Number',
AJDT.KeyVersion AS 'Private Key Version',
AJDT.CUP AS 'Unique Code of Project',
AJDT.CIG AS 'Contract Code Identification',
AJDT.SupplCode AS 'Supplementary Code',
AJDT.SPSrcType AS 'Service Posting Source Type',
AJDT.SPSrcID AS 'Service Posting Source ID',
AJDT.SPSrcDLN AS 'Service Post. Source Delivery',
AJDT.DeferedTax AS 'Deferred Tax',
AJDT.AgrNo AS 'Blanket Agreement Number',
AJDT.SeqNum AS 'Sequence Number',
AJDT.ECDPosTyp AS 'ECD Posting Type',
AJDT.RptPeriod AS 'Reporting Period',
AJDT.RptMonth AS 'Reporting Month',
AJDT.ExTransId AS 'Exposed Transaction ID'
FROM AJDT AS AJDT
Related information
AJDT SQL Table
Blanket Agreement OOAT SQL Table
Journal Vouchers List OBTD SQL Table
CIG Codes OCIG SQL Table
CUP Codes OCUP SQL Table
JE Document Type OJET SQL Table
Posting Period OFPR SQL Table
Indicator OIDC SQL Table
Location OLCT SQL Table
Object Settings - History ADP1 SQL Table
Currency Codes OCRN SQL Table
Project Codes OPRJ SQL Table
Journal Entry Codes OTRC SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
