biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Incoming Excise Invoice - Document Reference Information
API IEI21
IEI21 - Incoming Excise Invoice - Document Reference Information Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEYInternal NumberInt
11
DOC_ENTRYNo
ObjectTypeObject TypenVarChar
20
140000010
LogInstancLog InstanceInt
11
0
RefTypeReference TypesVarChar
S) System Document
E) External Document
1
S
LineNumLine NumberInt
11
RefDocEntrReferenced Internal NumberInt
11
RefDocNumReferenced Document NumberInt
11
RefObjTypeReferenced Object TypenVarChar
20
AccessKeyAccess KeynVarChar
100
IssueDateDate of IssueDate
8
IssuerCNPJIssuer CNPJnVarChar
100
IssuerCodeFiscal Document Issuer UF CodenVarChar
10
ModelFiscal Document ModelnVarChar
6
SeriesFiscal Document SeriesnVarChar
3
NumberFiscal Document NumberInt
11
RefAccKeyReferenced CT-e Access KeynVarChar
100
RefAmountReferenced AmountNum
20
SubSeriesFiscal Document SubseriesnVarChar
3

SELECT statement

SELECT IEI21.DocEntry AS 'Internal Number', IEI21.ObjectType AS 'Object Type', IEI21.LogInstanc AS 'Log Instance', IEI21.RefType AS 'Reference Types', IEI21.LineNum AS 'Line Number', IEI21.RefDocEntr AS 'Referenced Internal Number', IEI21.RefDocNum AS 'Referenced Document Number', IEI21.RefObjType AS 'Referenced Object Type', IEI21.AccessKey AS 'Access Key', IEI21.IssueDate AS 'Date of Issue', IEI21.IssuerCNPJ AS 'Issuer CNPJ', IEI21.IssuerCode AS 'Fiscal Document Issuer UF Code', IEI21.Model AS 'Fiscal Document Model', IEI21.Series AS 'Fiscal Document Series', IEI21.Number AS 'Fiscal Document Number', IEI21.RefAccKey AS 'Referenced CT-e Access Key', IEI21.RefAmount AS 'Referenced Amount', IEI21.SubSeries AS 'Fiscal Document Subseries' FROM IEI21 AS IEI21

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