📚 SAP Business One SDK Help

Table Name: OJDT

Table Description: Journal Entry

Field Description Type Size Related Default Value Constraints
BatchNum Journal Voucher No. Int 11 OBTD      
TransId Transaction Number Int 11 -      
BtfStatus Status VarChar 1 - O O Open
            C Closed
TransType Origin nVarChar 20 - -1 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
            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
            140000009 Outgoing Excise Invoice
            140000010 Incoming Excise Invoice
            254000065 Self Invoice
            254000066 Self Credit Memo
            10000079 TDS Adjustment
            24 Incoming Payment
            25 Deposit
            46 Outgoing Payment
            57 Checks for Payment
            76 Postdated Deposit
            182 BoE Transaction
            -2 Opening Balance
            -3 Closing Balance
            321 Internal Reconciliation
            10000046 Data Archive
            30 Journal Entry
            58 Inventory List
            59 Goods Receipt
            60 Goods Issue
            67 Inventory Transfers
            68 Work Instructions
            162 Inventory Valuation
            202 Production Order
            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
            1470000071 Depreciation Run
            -1 All Transactions
            310000001 Inventory Opening Balance
            10000071 Inventory Posting
            254000061 Input Service Distribution Invoice
            254000062 Input Service Distribution Recipient Invoice
            254000063 Input Service Distribution Credit Memo
            254000064 Input Service Distribution Recipient Credit Memo
            -4 Adj. for Manual Ext. Reconciliation
BaseRef Origin No. nVarChar 11 -      
RefDate Posting Date Date 8 -      
Memo Remarks nVarChar 254 -      
Ref1 Reference 1 nVarChar 200 -      
Ref2 Reference 2 nVarChar 200 -      
CreatedBy Original Int 11 -      
LocTotal Total in Local Currency Num 19.6 -      
FcTotal Total in Foreign Currency Num 19.6 -      
SysTotal Total in System Currency Num 19.6 -      
TransCode Transaction Code nVarChar 4 OTRC      
OrignCurr Revaluation Currency nVarChar 3 OCRN      
TransRate Revaluation Rate Num 19.6 -      
BtfLine Row in Voucher Int 11 -      
TransCurr Transaction Currency nVarChar 3 -      
Project Project Code nVarChar 20 OPRJ      
DueDate Due Date Date 8 -      
TaxDate Document Date Date 8 -      
PCAddition PC Addition VarChar 1 - N Y Yes
            N No
FinncPriod Posting Period Int 11 OFPR      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UpdateDate Date of Update Date 8 -      
CreateDate Recording Date Date 8 -      
UserSign User Signature Int 6 OUSR      
UserSign2 Updating User Int 6 OUSR      
RefndRprt Repayment Report VarChar 1 - N Y Yes
            N No
LogInstanc Log Instance Int 11 - 0    
ObjType Object Type nVarChar 20 ADP1 30    
Indicator Indicator Code nVarChar 2 OIDC      
AdjTran Adjusting Transaction VarChar 1 - N Y Yes
            N No
RevSource Revaluation Source VarChar 1 - N F FC
            S System
            N No
StornoDate Reversal Date Date 8 -      
StornoToTr Reverse Transaction Int 11 -      
AutoStorno Use Auto-Reverse VarChar 1 - N Y Yes
            N No
Corisptivi Transaction Values VarChar 1 - N Y Yes
            N No
VatDate VAT Date Date 8 -      
StampTax Stamp Tax VarChar 1 - N Y Yes
            N No
Series Series Int 11 - 0    
Number Number Int 11 -      
AutoVAT Automatic Tax VarChar 1 - N Y Yes
            N No
DocSeries Document Series Int 11 -      
FolioPref Folio Prefix String nVarChar 4 -      
FolioNum Folio Number Int 11 -      
CreateTime Generation Time Int 6 -      
BlockDunn Block Dunning Letter VarChar 1 - N N No
            Y Yes
ReportEU Include in EU Report VarChar 1 - N Y Yes
            N No
Report347 Include in 347 Report VarChar 1 - N Y Yes
            N No
Printed Printed VarChar 1 - N Y Yes
            N No
DocType Document Type nVarChar 60 OJET      
AttNum Number of Attachments Int 11 - 0    
GenRegNo Generate Reg. No. or Not VarChar 1 - N Y Yes
            N No
RG23APart2 RG23A Part2 No Int 11 -      
RG23CPart2 RG23C Part2 No Int 11 -      
MatType Material Type Int 11 -      
Creator Creator Name nVarChar 155 -      
Approver Approver Name nVarChar 155 -      
Location Loc. Int 11 OLCT      
SeqCode Sequence Code Int 6 -      
Serial Serial Number Int 11 -      
SeriesStr Series String nVarChar 3 -      
SubStr Subseries String nVarChar 3 -      
AutoWT Automatic WTax VarChar 1 - N Y Yes
            N No
WTSum WTax Amount Num 19.6 -      
WTSumSC WTax Amount (SC) Num 19.6 -      
WTSumFC WTax Amount (FC) Num 19.6 -      
WTApplied Applied WTax Num 19.6 -      
WTAppliedS Applied WTax (SC) Num 19.6 -      
WTAppliedF Applied WTax (FC) Num 19.6 -      
BaseAmnt Base Amount Num 19.6 -      
BaseAmntSC Base Amount (SC) Num 19.6 -      
BaseAmntFC Base Amount (FC) Num 19.6 -      
BaseVtAt WTax Base VAT Amount Num 19.6 -      
BaseVtAtSC WTax Base VAT Amount (SC) Num 19.6 -      
BaseVtAtFC WTax Base VAT Amount (FC) Num 19.6 -      
VersionNum Version Number nVarChar 13 -      
BaseTrans Base Transaction Number Int 11 -      
ResidenNum Residence Number VarChar 1 - 1 1 Spanish Fiscal ID
            2 VAT Registration Number
            3 Passport
            4 Fiscal ID Issued by the Country/Region of Residence
            5 Certificate of Fiscal Residence
            6 Other Document
OperatCode Operation Code VarChar 1 -      
            A Summary Invoices Entry
            B Summary Receipts Entry
            C Invoice with Several VAT Rates
            D Correction Invoice
            E Due VAT Pending Invoice Issuance
            F Expenses Incurred by Travel Agent for Customers
            G Special Regulation for VAT Group
            H Special Regulation for Gold Investment
            I Reverse Charge Procedure
            J Unsummarized Receipts
            K Identification of Error Transactions
            X Transactions with Entrepreneurs Issuing Receipts for Agricultural Compensation
            N Service Invoicing by Travel Agencies on Behalf of Third Parties
            R Business Office Rental
            S Subsidies
            T Incoming Payments for Industrial and Intellectual Property Rights
            U Insurance Transactions
            V Purchases from Travel Agencies
            W Transactions Subject to Production, Service, and Import Taxes in Ceuta and Melilla
            Z Deferred Tax - Special Regime
            1 Deferred Tax - Summary Invoices Entry
            2 Deferred Tax - Invoices with Several Entries (More Than One Tax Group)
            3 Deferred Tax - Correction Invoice
            4 Deferred Tax - Acquisitions Made by Travel Agencies in the Travelers Own Interest (Special Regime for Travel Agencies)
            5 Deferred Tax - Simplified Invoices
            6 Deferred Tax - Correction of Errata Entries
            7 Deferred Tax - Travel Agency Services on Behalf of Third Parties
            8 Deferred Tax - Rental of Business Premises
Ref3 Reference 3 nVarChar 200 -      
SSIExmpt SSI Exemption VarChar 1 -   Y Yes
            N No
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      
CIG Contract Code Identification Int 11 OCIG      
SupplCode Supplementary Code nVarChar 254 -      
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 1 - N Y Yes
            N No
AgrNo Blanket Agreement Number Int 11 OOAT      
SeqNum Sequence Number Int 11 -      
ECDPosTyp ECD Posting Type VarChar 1 - N N Normal
            E Statement
RptPeriod Reporting Period nVarChar 5 -      
RptMonth Reporting Month Date 8 -      
ExTransId Exposed Transaction ID Int 11 -      
PrlLinked Is JE linked by MX Payroll VarChar 1 - N Y Yes
            N No
PTICode POI Code nVarChar 5 OPTI      
Letter Letter VarChar 1 -      
FolNumFrom Folio Number From Int 11 -      
FolNumTo Folio Number To Int 11 -      
RepSection Reporting Section nVarChar 3 -      
ExclTaxRep Exclude from Control Statement VarChar 1 - N Y Yes
            N No
IsCoEntry Cost Center Transfer form VarChar 1 - N Y Yes
            N No
SAPPassprt Extended SAP Passport Text 16 -      
AtcEntry Attachment Entry Int 11 OATC      
Attachment Attachment Text 16 -      
EBookable E-Books Enabled VarChar 1 - N N No
            Y Yes
DataVers Data Version Int 11 - 1    
SAFTType SAF-T Transaction Type VarChar 1 - - - -
            N Normal
            R Adjustments of Tax Period
            A Measurement of Results
            J Adjustment
            I Do Not Export
AllocNum Allocation Number for IL nVarChar 50 -      
SAFTTypeEx SAF-T Transaction Type nVarChar 10 OSTE -    
Key Unique Field
PRIMARY Yes TransId
TRANS_TYPE No TransType
    CreatedBy
REFDATE No RefDate
STORNO_TRA No StornoToTr
SERIES Yes Series
    Number
STORNO No StornoDate
    AutoStorno
PROJECT No Project