| 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 | LCNUM | Letter of Credit Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | J1I_LCNUM | Allow NULL? |
| 3 | LCVER | Letter of Credit Version | nvarchar | 3 | 0 | NUMC | (N'000') | No | | J_1ILCVER | Allow NULL? |
| 4 | LCTYP | Letter of Credit Processing Type | char | 1 | 0 | CHAR | (N' ') | No | | J1I_LCTYP | Allow NULL? |
| 5 | LCDOCTYP | Letter of Credit Document Type | char | 1 | 0 | CHAR | (N' ') | Yes | | J1I_LCDOCTYP | Allow NULL? |
| 6 | LCSTAT | Letter of Credit Status | char | 1 | 0 | CHAR | (N' ') | Yes | J_1I_EXIMSTATUS | J1I_LCSTAT | Allow NULL? |
| 7 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 8 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNNR | Allow NULL? |
| 9 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LIFNR | Allow NULL? |
| 10 | SHIP_FROM | Shipping From | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | J1I_SHIP_FROM | Allow NULL? |
| 11 | SHIP_TO | Shipping To | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | J1I_SHIP_TO | Allow NULL? |
| 12 | LAND_ORIGIN | Country of Origin | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | J1I_ORIGIN_LAND | Allow NULL? |
| 13 | LAND_DEST | Destination Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | J1I_DEST_LAND | Allow NULL? |
| 14 | LCAMT | Letter of Credit Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | J1I_LCAMT | |
| 15 | LCBLK_AMT | Blocked Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | J1I_LCBLKAMT | |
| 16 | LCUTL_AMT | Utilized Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | J1I_LCUTLAMT | |
| 17 | LCCUR | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | J_1IEXCCUR | Allow NULL? |
| 18 | PAYMENT_TERMS | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 19 | PAYMENT_MODE | Letter of Credit Payment Mode | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1IMODE | Allow NULL? |
| 20 | SHIPTYPE | Partial Shipment | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1IPARTSHIP | Allow NULL? |
| 21 | TRANSHIPMENT | Transhipment | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1ITRANSHIP | Allow NULL? |
| 22 | KKURS | Condition exchange rate for conversion to local currency | decimal | 9 | 5 | DEC | ((0)) | Yes | | KKURS | |
| 23 | BAANR | Financial document processing: External financial doc. no. | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BAANR | Allow NULL? |
| 24 | EUPRZ | Tolerance Value( Percentage ) | decimal | 5 | 2 | DEC | ((0)) | Yes | | J1I_LC_TOL_VAL | |
| 25 | DATAI | Financial document processing: Opening date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAI | Allow NULL? |
| 26 | DATXA | Financial document processing: Validity end date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATXA | Allow NULL? |
| 27 | DATAY | Financial document processing: Latest shipping date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAY | Allow NULL? |
| 28 | DATAH | Financial doc. processing: Date when docs presented to bank | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAH | Allow NULL? |
| 29 | DATAA | Financial document processing: Request date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAA | Allow NULL? |
| 30 | DATAJ | Financial document processing: Date of receipt | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAJ | Allow NULL? |
| 31 | ANYTG | Number of Days for Document Submission | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | J_1IANYTG | Allow NULL? |
| 32 | LCGUID | Application GUID | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | J_1I_EXIM_APPGUID | Allow NULL? |
| 33 | ACTVER | Active Version | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1IACTVER | Allow NULL? |
| 34 | DOCSET_CHNG | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 35 | CREA_DATE_TIME | Created Time | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | J_1I_CRTD_AT | Allow NULL? |
| 36 | CREA_UNAME | Created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | J_1I_CRTD_BY | Allow NULL? |
| 37 | LCHG_DATE_TIME | Changed Time | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | J_1I_CHNGD_AT | Allow NULL? |
| 38 | LCHG_UNAME | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | J_1I_CHNGD_BY | Allow NULL? |
| 39 | EXP_DATE | Date of Expiry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J1I_DAT_EXP | Allow NULL? |
| 40 | EXP_PLACE | Place of Expiry | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | J1I_PLC_EXP | Allow NULL? |
| 41 | EUPRZ_LOW | Tolerance Value( Percentage ) | decimal | 5 | 2 | DEC | ((0)) | Yes | | J1I_LC_TOL_VAL | |
| 42 | CUST_NAME | Name 1 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME1 | Allow NULL? |
| 43 | BENF_NAME | Name 1 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME1 | Allow NULL? |
| 44 | CUST_ADDR_GUID | Application GUID | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | J_1I_EXIM_APPGUID | Allow NULL? |
| 45 | BENF_ADDR_GUID | Application GUID | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | J_1I_EXIM_APPGUID | Allow NULL? |
| 46 | SHIPCNT | Number of Partial Shipment(s) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | J_1I_EXIM_LCSHPCNT | Allow NULL? |
| 47 | DEL_PLACE | Place of Delivery | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | J1I_PLC_DEL | Allow NULL? |
| 48 | ADDITIONAL_1 | | nvarchar | 40 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 49 | ADDITIONAL_2 | | nvarchar | 40 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 50 | ADDITIONAL_3 | | nvarchar | 40 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 51 | ADDITIONAL_4 | | nvarchar | 40 | 0 | | (N' ') | Yes | | | Allow NULL? |
