biuan SAP® BUSINESS ONE SDK
DTW Sales Tax Invoice - Rows1
API Tax Invoices / Tax Invoice Lines
OTXD - Tax Invoice Draft Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEY UNIQUEDocument NumberInt
11
NUMYes
DocTypeDocument TypeVarChar
I) Invoice
P) Payment
J) Journal Entry
C) Correction Invoice
D) Down Payment
A) Alteration Invoice
B) Alteration Correction Invoice
1
I
CANCELEDCanceledVarChar
Y) Yes
N) No
1
N
HandWritenManual NumberingVarChar
Y) Yes
N) No
1
N
PrintedPrintedVarChar
Y) Yes
N) No
1
N
TransferedYear TransferVarChar
Y) Yes
N) No
1
N
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
194
DocDatePosting DateDate
8
CardCodeCustomer CodenVarChar
15OCRD
Business Partner
CreateDateCreation DateDate
8
UpdateDateDate of UpdateDate
8
DocDueDateDue DateDate
8
SeriesSeriesInt
6
0
SegmentSegmentInt
6
0
CntctCodeContact PersonInt
11OCPR
Contact Persons
VatDateDocument DateDate
8
CommentsRemarksnVarChar
127
TrnspCodeShipping TypeInt
6OSHP
Delivery Types
-1
ShipToCodeShip-to CodenVarChar
50
AddressBill tonVarChar
127
Address2Ship TonVarChar
127
LogInstancLog InstanceInt
11
0
CurSourceBase CurrencyVarChar
L) Local Currency
S) System Currency
C) BP Currency
1
C
DocCurDocument CurrencynVarChar
3
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
NumAtCardBP Reference No.nVarChar
100
CardNameCustomer/Vendor NamenVarChar
100
CancelDateCancel DateDate
8
DocTotalDocument TotalNum
20
VatSumTotal TaxNum
20
PayRefNoPayment Ref. No.nVarChar
16
PayRefDatePayment Ref. DateDate
8
TaxMethodTaxation MethodVarChar
S) On Shipment
P) On Payment
1
S
AtcEntryAttachment EntryInt
11
IsDpmIS Down PaymentVarChar
Y) Yes
N) No
1
N
AltRevAlteration RevisionInt
11
0
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
TransIdTransaction NumberInt
11OJDT
Journal Entry
JrnlMemoJournal RemarknVarChar
50
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
VATRegNumBranch Reg. No.nVarChar
32

Table relationship map

SELECT statement

SELECT OTXD.DocEntry AS 'Internal Number', OTXD.DocNum AS 'Document Number', OTXD.DocType AS 'Document Type', OTXD.CANCELED AS 'Canceled', OTXD.HandWriten AS 'Manual Numbering', OTXD.Printed AS 'Printed', OTXD.Transfered AS 'Year Transfer', OTXD.ObjType AS 'Object Type', OTXD.DocDate AS 'Posting Date', OTXD.CardCode AS 'Customer Code', OTXD.CreateDate AS 'Creation Date', OTXD.UpdateDate AS 'Date of Update', OTXD.DocDueDate AS 'Due Date', OTXD.Series AS 'Series', OTXD.Segment AS 'Segment', OTXD.CntctCode AS 'Contact Person', OTXD.VatDate AS 'Document Date', OTXD.Comments AS 'Remarks', OTXD.TrnspCode AS 'Shipping Type', OTXD.ShipToCode AS 'Ship-to Code', OTXD.Address AS 'Bill to', OTXD.Address2 AS 'Ship To', OTXD.LogInstanc AS 'Log Instance', OTXD.CurSource AS 'Base Currency', OTXD.DocCur AS 'Document Currency', OTXD.UserSign AS 'User Signature', OTXD.UserSign2 AS 'Updating User', OTXD.NumAtCard AS 'BP Reference No.', OTXD.CardName AS 'Customer/Vendor Name', OTXD.CancelDate AS 'Cancel Date', OTXD.DocTotal AS 'Document Total', OTXD.VatSum AS 'Total Tax', OTXD.PayRefNo AS 'Payment Ref. No.', OTXD.PayRefDate AS 'Payment Ref. Date', OTXD.TaxMethod AS 'Taxation Method', OTXD.AtcEntry AS 'Attachment Entry', OTXD.IsDpm AS 'IS Down Payment', OTXD.AltRev AS 'Alteration Revision', OTXD.PIndicator AS 'Period Indicator', OTXD.TransId AS 'Transaction Number', OTXD.JrnlMemo AS 'Journal Remark', OTXD.BPLId AS 'Branch', OTXD.BPLName AS 'Branch Name', OTXD.VATRegNum AS 'Branch Reg. No.' FROM OTXD AS OTXD

Related information


Tax Invoice Lines TaxInvoice_Lines Object· Table: TSI1
TaxInvoice_Lines is a child object of the TaxInvoices object that represents the line entries of each tax invoice document. Source table: TSI1 for sales invoices, TPI1 for purchase invoices, or TXD1 for journal entry.
   Parent: Tax Invoices TaxInvoices Object· Table: OTSI
Business Place OBPL SQL Table

Business Partner OCRD SQL Table

Contact Persons OCPR SQL Table

Object Settings - History ADP1 SQL Table

Period Indicator OPID SQL Table

Journal Entry OJDT SQL Table

Delivery Types OSHP SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates