|
|
DTW Journal Voucher Entry
API Journal Entries / Deferred Tax
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BatchNum KEY UNIQUE | Journal Voucher No. | Int | 11 | OBTD Journal Vouchers List | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TransId KEY | Transaction Number | Int | 11 | JDT_NUM | No | |||
| BtfStatus KEY | Status | VarChar | O) Open C) Closed | 1 | O | BTF_STATUS | No | |
| 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 | Posting Date | Date | 8 | |||||
| Memo | Details | nVarChar | 50 | |||||
| Ref1 | Reference 1 | nVarChar | 100 | |||||
| Ref2 | Reference 2 | nVarChar | 100 | |||||
| CreatedBy | Origin | Int | 11 | |||||
| LocTotal | Total in LC | Num | 20 | |||||
| FcTotal | Total in FC | Num | 20 | |||||
| SysTotal | Total in SC | Num | 20 | |||||
| TransCode | Transaction Code | nVarChar | 4 | OTRC Journal Entry Codes | ||||
| OrignCurr | Original Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| TransRate | Transaction Rate | Num | 20 | |||||
| BtfLine | Row in Voucher | Int | 11 | |||||
| TransCurr | Transaction Currency | nVarChar | 3 | |||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| DueDate | Value Date | Date | 8 | |||||
| TaxDate | Tax 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 | Update Date | Date | 8 | |||||
| CreateDate | Recording Date | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| RefndRprt | Repayment Report | VarChar | Y) Yes N) No | 1 | N | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 30 | |||
| Indicator | Indicator Code | nVarChar | 2 | OIDC Indicator | ||||
| AdjTran | Adjusting Transaction | VarChar | Y) Yes N) No | 1 | N | |||
| RevSource | Revaluation Source | VarChar | F) FC S) System N) No | 1 | N | |||
| StornoDate | Reversal Date | Date | 8 | |||||
| StornoToTr | Reverse Transaction | Int | 11 | |||||
| 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) VAT 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 | Transact. 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
OBTF.BatchNum AS 'Journal Voucher No.',
OBTF.TransId AS 'Transaction Number',
OBTF.BtfStatus AS 'Status',
OBTF.TransType AS 'Original Journal',
OBTF.BaseRef AS 'Base Reference',
OBTF.RefDate AS 'Posting Date',
OBTF.Memo AS 'Details',
OBTF.Ref1 AS 'Reference 1',
OBTF.Ref2 AS 'Reference 2',
OBTF.CreatedBy AS 'Origin',
OBTF.LocTotal AS 'Total in LC',
OBTF.FcTotal AS 'Total in FC',
OBTF.SysTotal AS 'Total in SC',
OBTF.TransCode AS 'Transaction Code',
OBTF.OrignCurr AS 'Original Currency',
OBTF.TransRate AS 'Transaction Rate',
OBTF.BtfLine AS 'Row in Voucher',
OBTF.TransCurr AS 'Transaction Currency',
OBTF.Project AS 'Project Code',
OBTF.DueDate AS 'Value Date',
OBTF.TaxDate AS 'Tax Date',
OBTF.PCAddition AS 'PC Addition',
OBTF.FinncPriod AS 'Posting Period',
OBTF.DataSource AS 'Data Source',
OBTF.UpdateDate AS 'Update Date',
OBTF.CreateDate AS 'Recording Date',
OBTF.UserSign AS 'User Signature',
OBTF.UserSign2 AS 'Updating User',
OBTF.RefndRprt AS 'Repayment Report',
OBTF.LogInstanc AS 'Log Instance',
OBTF.ObjType AS 'Object Type',
OBTF.Indicator AS 'Indicator Code',
OBTF.AdjTran AS 'Adjusting Transaction',
OBTF.RevSource AS 'Revaluation Source',
OBTF.StornoDate AS 'Reversal Date',
OBTF.StornoToTr AS 'Reverse Transaction',
OBTF.AutoStorno AS 'Use Auto-Reverse',
OBTF.Corisptivi AS 'Transaction Values',
OBTF.VatDate AS 'VAT Date',
OBTF.StampTax AS 'Stamp Tax',
OBTF.Series AS 'Series',
OBTF.Number AS 'Number',
OBTF.AutoVAT AS 'Auto VAT',
OBTF.DocSeries AS 'Document Series',
OBTF.FolioPref AS 'Folio Prefix String',
OBTF.FolioNum AS 'Folio Number',
OBTF.CreateTime AS 'Generation Time',
OBTF.BlockDunn AS 'Block Dunning Letter',
OBTF.ReportEU AS 'Include in EU Report',
OBTF.Report347 AS 'Include in 347 Report',
OBTF.Printed AS 'Printed',
OBTF.DocType AS 'Transact. Type',
OBTF.AttNum AS 'Number of Attachments',
OBTF.GenRegNo AS 'Generate Reg. No. or Not',
OBTF.RG23APart2 AS 'RG23A Part2 No',
OBTF.RG23CPart2 AS 'RG23C Part2 No',
OBTF.MatType AS 'Material Type',
OBTF.Creator AS 'Creator Name',
OBTF.Approver AS 'Approver Name',
OBTF.Location AS 'Loc.',
OBTF.SeqCode AS 'Sequence Code',
OBTF.Serial AS 'Serial Number',
OBTF.SeriesStr AS 'Series String',
OBTF.SubStr AS 'Subseries String',
OBTF.AutoWT AS 'Automatic WTax',
OBTF.WTSum AS 'WTax Amount',
OBTF.WTSumSC AS 'WTax Amount (SC)',
OBTF.WTSumFC AS 'WTax Amount (FC)',
OBTF.WTApplied AS 'Applied WTax',
OBTF.WTAppliedS AS 'Applied WTax (SC)',
OBTF.WTAppliedF AS 'Applied WTax (FC)',
OBTF.BaseAmnt AS 'Base Amount',
OBTF.BaseAmntSC AS 'Base Amount (SC)',
OBTF.BaseAmntFC AS 'Base Amount (FC)',
OBTF.BaseVtAt AS 'WTax Base VAT Amount',
OBTF.BaseVtAtSC AS 'WTax Base VAT Amount (SC)',
OBTF.BaseVtAtFC AS 'WTax Base VAT Amount (FC)',
OBTF.VersionNum AS 'Version Number',
OBTF.BaseTrans AS 'Base Transaction Number',
OBTF.ResidenNum AS 'Residence Number',
OBTF.OperatCode AS 'Operation Code',
OBTF.Ref3 AS 'Reference 3',
OBTF.SSIExmpt AS 'SSI Exemption',
OBTF.SignMsg AS 'Signature Input Message',
OBTF.SignDigest AS 'Signature Digest',
OBTF.CertifNum AS 'Certification Number',
OBTF.KeyVersion AS 'Private Key Version',
OBTF.CUP AS 'Unique Code of Project',
OBTF.CIG AS 'Contract Code Identification',
OBTF.SupplCode AS 'Supplementary Code',
OBTF.SPSrcType AS 'Service Posting Source Type',
OBTF.SPSrcID AS 'Service Posting Source ID',
OBTF.SPSrcDLN AS 'Service Post. Source Delivery',
OBTF.DeferedTax AS 'Deferred Tax',
OBTF.AgrNo AS 'Blanket Agreement Number',
OBTF.SeqNum AS 'Sequence Number',
OBTF.ECDPosTyp AS 'ECD Posting Type',
OBTF.RptPeriod AS 'Reporting Period',
OBTF.RptMonth AS 'Reporting Month',
OBTF.ExTransId AS 'Exposed Transaction ID'
FROM OBTF AS OBTF
Related information
Deferred Tax DeferredTax Property· Table: OBTF
Indicates whether to apply the deferred tax function associated with the selected tax group or tax code.
Field name: DeferredTax.
· Table: OBTF 
Parent: Journal Entries JournalEntries Object· Table: OJDT OBTF OBTF 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
JournalEntries
Property
DeferredTax
Enumeration
Method
Object
JournalEntries_Lines JDT1, BTF1
WithholdingTaxData JDT2, BTF2
Property
AutomaticWT
DTW DB
AutoVAT
DTW DB
BlockDunningLetter
DTW DB
Corisptivi
DTW DB
DeferredTax
DTW DB
DocumentType
DTW DB
DueDate
DTW DB
ECDPostingType
DTW DB
ExposedTransNumber
DTW DB
FolioNumber
DB
Indicator
DTW DB
JdtNum
DTW DB
LocationCode
DTW DB
Memo
DTW DB
Number
DB
OperationCode
DTW DB
Original
DB
ProjectCode
DTW DB
Reference
DTW DB
Reference2
DTW DB
Reference3
DTW DB
ReferenceDate
DTW DB
Report347
DTW DB
ReportEU
DTW DB
ResidenceNumberType
DTW DB
Series
DTW DB
StampTax
DTW DB
StornoDate
DTW DB
TaxDate
DTW DB
TransactionCode
DTW DB
UseAutoStorno
DTW DB
VatDate
DTW DB
WTSum
DB
WTSumFC
DB
WTSumSC
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates