SDE Maintenance
The
SDE Maintenance
screen can be used to manually add new Chinese Standard Declarable Elements (SDEs) or modify existing SDEs. This screen can be opened by choosing SDE Maintenance
from the Classification
menu.To display a product’s SDE details, enter a product number into the
Product Number
field and then click Search
.
Clicking
Search
will filter the grid to only show the selected product, along with any corresponding SDEs.
Maintain SDE Information on Screen Manually
To expand the grid to view SDE Header and Detail information, choose a product from the grid and click its corresponding arrow on the far left.
Clicking the expansion arrow will display header information for all available SDE sets for the product. Clicking the second expansion arrow will open the detail information.
To modify an existing SDE, choose and expand a product on the grid.
Click the Edit (
) icon on the SDE Header.
) icon on the SDE Header.
Clicking the Edit icon will open the
Edit SDE
pop-up for the selected SDE.Options | Description |
|---|---|
Sort Order | Determines the sort order of the declarable elements. |
Declarable Elements | Displays all updated SDE requirements from China Customs. |
Detail Value | This read/write textbox makes it possible to update or enter new values for any SDE. |
important
All mandatory element values must be entered.
Make any necessary changes, check the
Set as Active
box, and then click Save
to proceed. If you have not entered mandatory values, the system will make the SDE 'Inactive'.
After performing changes, the following warning message will be displayed when
Set as Active
is selected: The SDE value change will overwrite the SDE values in all related invoices, please review SDE values in invoices.To add a new SDE, choose a Product Number from the
SDE Maintenance
grid. Once a product has been chosen, click its corresponding +
on the left side of the grid.
Clicking this button will open the
Add SDE
pop-up.important
All element values must be entered except for '品牌类型', '出口享惠情况', 'GTIN', 'CAS' and '其他. A validation message will be shown if any mandatory field is left blank.
Each Product Number can only have one (1) Active SDE set at a time. To see which SDE is currently active, choose and expand a product on the grid.
The currently active
SDE
will show as (Active). If this is correct, no further action is required.
Maintain SDE by Using Spreadsheet Upload
SDE Template Download
SDEs can be updated en masse via Spreadsheet Upload.
A blank template can be downloaded by clicking on the
SDE Template Download
link on the top of the SDE Maintenance
screen.
You will be redirected to a lookup screen with the
Template – Product Spreadsheet Upload
dock preselected. Click the Extract
button.
The system will then generate an Excel document with the system’s existing SDE data. This file can then be downloaded to your local drive.
The downloaded SDE template will contain all product records already maintained in the system. Although the user can make any necessary changes, they will need to maintain the SDE value (Column H) associated with the Product Number and content SDE accordingly.
SDE Spreadsheet Upload
important
The following warning message will be displayed: The spreadsheet upload will overwrite the SDE values in all related invoices, please review SDE values in invoices.
After modifying the excel file, return to the system, and click the
SDE Spreadsheet Upload
button.
The
SDE Spreadsheet Upload
pop-up window will open. You can download the excel template by clicking Download Excel Template
. After doing that, the template is downloaded from the system and can be saved and opened on your local drive.Click on the
Choose File
button and select an Excel file from the local drive that matches the template parameters.
Once the Excel file has been selected, the file name will appear on the screen.
Refresh the page and you will see your file listed in the
Process Flow Execution Status
grid.Upload and Import Data
To import the Excel file data into the master product database.
- Click theChoose Filebutton and select an Excel file from the local drive that matches the template parameters.
- ClickUpload and Import Data.
- A validation message will be displayed.
important
If you have not entered mandatory SDE values in the SDE Spreadsheet Upload, for both China SDE Extract standard and China SDE Extract comparison, when successfully uploading, the system will save the record and make the SDE 'Inactive'. A warning message will be displayed if this happens.
Process Flow Execution Status
You can view the spreadsheets you have uploaded in the
Process Flow Execution Status
grid. Click Refresh
to reload the page and view possible updates.
Fields | Descriptions |
|---|---|
User Name | The username of the person who uploaded the spreadsheet. |
File Name | The name of the excel spreadsheet file. |
Effective Date | The date the spreadsheet was uploaded in the format: YYYY-MM-DD HH:MM |
Status | The status of the spreadsheet can be:
|
Process Flow Summary | If there are errors in the spreadsheet upload, you will see a warning message on this column. |
Error Count | If there are errors in the spreadsheet upload, you will see the a number indicating the quantity of errors found on this upload. Click the number on the column to open the Spreadsheet Upload Validation Errors pop-up where you can view and extract the validation messages associated to this spreadsheet. Spreadsheet validation error messages are kept for up to 120 days and deleted past that period. |
You can refine your search by selecting a date on the
Apply Filter
line or using the filter icon next to the column headers on the grid. There are multiple filter options, you can select the one that fits your preference the best.
Related Content
-
Global Classification
Format:
Article