| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | DOC_NO | Document Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | J_1I_PM_DOCHDR | J_1I_DOC_NO | Allow NULL? |
| 3 | DOC_ITEM | Document Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | J_1I_DOC_ITEM | Allow NULL? |
| 4 | DOC_TYPE | Document ID | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | J_1I_EXIM_DOCID | Allow NULL? |
| 5 | REFDOC_NO | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | J_1I_REFDOC_NO | Allow NULL? |
| 6 | REFDOC_ITEM | Reference Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | J_1I_REFDOC_ITM | Allow NULL? |
| 7 | REFDOC_DT | Reference Document Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1I_REFDOC_DT | Allow NULL? |
| 8 | REFDOC_TYP | Reference Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | J_1I_REFDOC_TYP | Allow NULL? |
| 9 | REFDOC1_NO | Referencing Document1 Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | J_1I_REFDOC1_NO | Allow NULL? |
| 10 | REFDOC1_ITEM | Referencing Document1 Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | J_1I_REFDOC1_ITM | Allow NULL? |
| 11 | REFDOC1_TYP | Reference Document1 Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | J_1I_REFDOC1_TYP | Allow NULL? |
| 12 | VALUE | Reference Document Value in Document Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1I_REFDOC_VAL | |
| 13 | DOC_ITEMCUR | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | J_1IEXCCUR | Allow NULL? |
| 14 | WKURS | Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | WKURS | |
| 15 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 16 | MENGE | Quantity of Materials | decimal | 13 | 3 | QUAN | ((0)) | Yes | | J_1ILICMENGE | |
| 17 | MEINS | Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | J_1IMEINS | Allow NULL? |
| 18 | FOB_VAL | Free on Board Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1I_FOB_VAL | |
| 19 | FOB_VAL_INR | Free on Board Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1I_FOB_VAL | |
| 20 | REF_INV_FRT_VAL | Freight Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_FRT_VAL | |
| 21 | REF_INV_INS_VAL | Insurance Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_INS_VAL | |
| 22 | REF_INV_COMM_VAL | Commision Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_COMM_VAL | |
| 23 | REF_INV_DISC_VAL | Discount Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_DISC_VAL | |
| 24 | REF_INV_OTH_VAL | Others Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_OTH_VAL | |
| 25 | REF_INV_DED_VAL | Deductions Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_DED_VAL | |
| 26 | ENTT_VALUE | EXIM: Import Entitlement Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_ENTTVALUE | |
| 27 | ENTT_CURR | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | J_1IEXCCUR | Allow NULL? |
| 28 | EXP_TAR_NO | Export Tariff Item Number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | J_1I_TARIFF_SHP | Allow NULL? |
| 29 | MARK_NO | Mark Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | J_1I_MARK_NO | Allow NULL? |
| 30 | PACK_KIND | Kind of Pack | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | J_1I_PACK_KIND | Allow NULL? |
| 31 | CONTAINER_NO | Container Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | J_1I_CONT_NO | Allow NULL? |
| 32 | CONT_SIZE | Container Size | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | J_1I_CONT_SIZE | Allow NULL? |
| 33 | EXCISE_SL_NO | Excise Seal Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_1I_EXCISE_NO | Allow NULL? |
| 34 | NO_PACK | Pack Number | smallint | 5 | 0 | INT2 | ((0)) | Yes | | J_1I_PACK_NO | |
| 35 | EXCISE_DT | Excise Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1I_EXCISE_DT | Allow NULL? |
| 36 | ASS_VAL | Assessable Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_ASS_VAL | |
| 37 | DUTY_RATE | Duty Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | J_1I_DUTY_RATE | |
| 38 | DUTY_VAL | Duty Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_DUTY_VAL | |
| 39 | CESS_RATE | Cess Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | J_1I_CESS_RATE | |
| 40 | CESS_VAL | Cess Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_CESS_VAL | |
| 41 | DBK_QTY | Duty Drawback Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | J_1I_DBK_QTY | |
| 42 | DBK_FOB_VAL | Free on Board Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1I_FOB_VAL | |
| 43 | DBK_VAL | Duty Drawback Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1I_DBK_VAL | |
| 44 | DBK_POST_VAL | Duty Drawback Posting Value in Local Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1I_DBK_POSTVAL | |
| 45 | DBK_POST_VAL_F | Duty Drawback Posting Value in Local Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1I_DBK_POSTVAL | |
| 46 | DBK_CUS_RATE | Duty Drawback Custom Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | J_1I_DBK_CUST_RATE | |
| 47 | DBK_CUST_VAL | Duty Drawback Custom Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_DBK_CUST_VAL | |
| 48 | DBK_CUST_VAL_MAT | Duty Drawback Custom Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_DBK_CUST_VAL | |
| 49 | DBK_EXC_RATE | Duty Drawback Excise Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | J_1I_DBK_EXC_RT | |
| 50 | DBK_EXC_VAL | Duty Drawback Excise Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_DBK_EXC_VAL | |
| 51 | LCURR | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | J_1I_LCURR | Allow NULL? |
| 52 | SERV_RATE | Service Tax Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | J_1I_EXIM_RATE_SERV | |
| 53 | SERV_VAL | Service Tax Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1I_EXIM_SERV_VAL | |
| 54 | SHPL_TYPE | Shipper's Letter of Instruction Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | J_1ISHPL_TYPE | Allow NULL? |
| 55 | DIMENSION | Dimension | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | J_1IDIMENSION | Allow NULL? |
| 56 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EKKO | EBELN | Allow NULL? |
| 57 | BOL_NO | Bill of Lading Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | J_BOL_NO | Allow NULL? |
| 58 | BOL_DT | Bill of Lading Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1I_BOL_DT | Allow NULL? |
| 59 | EXP_RELZ_DATE | Export Realisation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1I_EXP_RELZ_DATE | Allow NULL? |
| 60 | BNK_REF_NO | Bank Reference Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | J_1I_BNK_REF | Allow NULL? |
| 61 | REF_CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 62 | CREA_DATE_TIME | Created Time | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | J_1I_CRTD_AT | Allow NULL? |
| 63 | CREA_UNAME | Created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | J_1I_CRTD_BY | Allow NULL? |
| 64 | LCHG_DATE_TIME | Changed Time | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | J_1I_CHNGD_AT | Allow NULL? |
| 65 | LCHG_UNAME | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | J_1I_CHNGD_BY | Allow NULL? |
