biuan SAP® BUSINESS ONE SDK
API RIN21
RIN21 - A/R Credit Memo - Document Reference Information Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEYInternal NumberInt
11
DOC_ENTRYNo
ObjectTypeObject TypenVarChar
20
14
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 RIN21.DocEntry AS 'Internal Number', RIN21.ObjectType AS 'Object Type', RIN21.LogInstanc AS 'Log Instance', RIN21.RefType AS 'Reference Types', RIN21.LineNum AS 'Line Number', RIN21.RefDocEntr AS 'Referenced Internal Number', RIN21.RefDocNum AS 'Referenced Document Number', RIN21.RefObjType AS 'Referenced Object Type', RIN21.AccessKey AS 'Access Key', RIN21.IssueDate AS 'Date of Issue', RIN21.IssuerCNPJ AS 'Issuer CNPJ', RIN21.IssuerCode AS 'Fiscal Document Issuer UF Code', RIN21.Model AS 'Fiscal Document Model', RIN21.Series AS 'Fiscal Document Series', RIN21.Number AS 'Fiscal Document Number', RIN21.RefAccKey AS 'Referenced CT-e Access Key', RIN21.RefAmount AS 'Referenced Amount', RIN21.SubSeries AS 'Fiscal Document Subseries' FROM RIN21 AS RIN21

Related information




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