biuan SAP® BUSINESS ONE SDK
SQL Administration / Cargo Customs Declaration Numbers / Cargo Customs Declaration Numbers
DTW Administration / Setup / Financials / Tax / Withholding Tax Definition / Cargo Customs Declaration Numbers
API Customs Declaration Service / Customs Declaration
OCCD - Cargo Customs Declaration Numbers Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CCDNum KEY UNIQUECCD NumbernVarChar
40
PRIMARYYes
DateDateDate
8
CustBrokerCustoms BrokernVarChar
15
DocNumImp./Exp. Document NumbernVarChar
20
DocDateImp./Exp. Document DateDate
8
SupNumSupply Agreement NumbernVarChar
20
SupDateSupply Agreement DateDate
8
CustTermCustoms TerminalnVarChar
15
PayKeyPayment Internal IDnVarChar
4

SELECT statement

SELECT OCCD.CCDNum AS 'CCD Number', OCCD.Date AS 'Date', OCCD.CustBroker AS 'Customs Broker', OCCD.DocNum AS 'Imp./Exp. Document Number', OCCD.DocDate AS 'Imp./Exp. Document Date', OCCD.SupNum AS 'Supply Agreement Number', OCCD.SupDate AS 'Supply Agreement Date', OCCD.CustTerm AS 'Customs Terminal', OCCD.PayKey AS 'Payment Internal ID' FROM OCCD AS OCCD

Related information


Customs Declaration CustomsDeclaration Object· Table: OCCD
A data structure related with the CustomsDeclarationService holding the information about a Cargo Customs Declaration (CCD). Source table: OCCD.
   Parent: Customs Declaration Service CustomsDeclarationService Service· Table: OCCD

Customs Declaration Service CustomsDeclarationService Service· Table: OCCD
The CustomsDeclarationService enables to manage the Cargo Customs Declarations (CCD). The service enables to add, update, get and delete CCDs. Mandatory properties: CCDNum (primary key). Source table: OCCD.
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