biuan SAP® BUSINESS ONE SDK
API OGTM
OGTM - GTS Mapping Object Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
CreateDateCreate DateDate
8
GtsMapNumGTS Mapping No.nVarChar
20
InvMapEntyLink to Invoice Mapping IDInt
11OIVM
GTS Invoice Mapping Object
GtsInvNumLink to GTS Invoice ObjectInt
11OGTI
GTS Invoice
BpCodeBP CodenVarChar
15OCRD
Business Partner
BpNameBP NamenVarChar
100
BpTaxRegNoBP Tax Registration No.nVarChar
20
BpAddrTelBP Address and TelephonenVarChar
80
BpBankNumBP Bank NumbernVarChar
80
RemarkRemarksnVarChar
127
CheckerCheckernVarChar
80
PayeePayeenVarChar
80
DocAmountDocument Net AmountNum
20
AmtAftDsctAmount After DiscountNum
20
TaxAmountTax AmountNum
20
GtsStatusGTS StatusVarChar
1) Exported
2) Voided
3) Imported
1
1
ExportDateExport DateDate
8
VoidDateVoid DateDate
8
ImportDateImport DateDate
8

Table relationship map

SELECT statement

SELECT OGTM.AbsEntry AS 'Internal Number', OGTM.CreateDate AS 'Create Date', OGTM.GtsMapNum AS 'GTS Mapping No.', OGTM.InvMapEnty AS 'Link to Invoice Mapping ID', OGTM.GtsInvNum AS 'Link to GTS Invoice Object', OGTM.BpCode AS 'BP Code', OGTM.BpName AS 'BP Name', OGTM.BpTaxRegNo AS 'BP Tax Registration No.', OGTM.BpAddrTel AS 'BP Address and Telephone', OGTM.BpBankNum AS 'BP Bank Number', OGTM.Remark AS 'Remarks', OGTM.Checker AS 'Checker', OGTM.Payee AS 'Payee', OGTM.DocAmount AS 'Document Net Amount', OGTM.AmtAftDsct AS 'Amount After Discount', OGTM.TaxAmount AS 'Tax Amount', OGTM.GtsStatus AS 'GTS Status', OGTM.ExportDate AS 'Export Date', OGTM.VoidDate AS 'Void Date', OGTM.ImportDate AS 'Import Date' FROM OGTM AS OGTM

Related information


OGTM SQL Table

Business Partner OCRD SQL Table

GTS Invoice OGTI SQL Table

GTS Invoice Mapping Object OIVM 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