biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Goods Return - Document Reference Information
API RPD21
RPD21 - Goods Return - Document Reference Information Table

SBO SQL database table details

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

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