biuan SAP® BUSINESS ONE SDK
API CRD9
CRD9 - OCRD Extension Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CardCode KEY UNIQUEBP CodenVarChar
25OCRD
Business Partner
PRIMARYYes
ISTransModIntrastat Transport ModeInt
11ODCI
Intrastat Configuration
ISIncotermIntrastat IncotermsInt
11ODCI
Intrastat Configuration
ISStateIntrastat StateInt
11ODCI
Intrastat Configuration
ISNatTransIntrastat Nature of Trans.Int
11ODCI
Intrastat Configuration
ISStatProcIntrastat Statistical Proc.Int
11ODCI
Intrastat Configuration
ISCustProcIntrastat Customs Proc.Int
11ODCI
Intrastat Configuration
ISCRYOrigIntrastat Country OriginnVarChar
3OCRY
Countries
ISPortIntrastat Port of Entry/ExitInt
11ODCI
Intrastat Configuration
ISDomFrgldIntrastat Domestic/Foreign IDVarChar
1
ISRelevantIntrastat RelevantVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT CRD9.CardCode AS 'BP Code', CRD9.ISTransMod AS 'Intrastat Transport Mode', CRD9.ISIncoterm AS 'Intrastat Incoterms', CRD9.ISState AS 'Intrastat State', CRD9.ISNatTrans AS 'Intrastat Nature of Trans.', CRD9.ISStatProc AS 'Intrastat Statistical Proc.', CRD9.ISCustProc AS 'Intrastat Customs Proc.', CRD9.ISCRYOrig AS 'Intrastat Country Origin', CRD9.ISPort AS 'Intrastat Port of Entry/Exit', CRD9.ISDomFrgld AS 'Intrastat Domestic/Foreign ID', CRD9.ISRelevant AS 'Intrastat Relevant' FROM CRD9 AS CRD9

Related information


Business Partner OCRD SQL Table

Countries OCRY SQL Table

Intrastat Configuration ODCI 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