[{ "AUFNR": "", "BKTXT": "MK123050403_A23013_戴唯", "BLART": "ZB", "BLDAT": "2023-05-29", "BSCHL": "40", "BUDAT": "2023-05-30", "BUKRS": "2010", "DMBTR": "50.00", "HKONT": "", "KOSTL": "201L007", "KURSF": "1", "MONAT": "2023-05-30", "MWSKZ": "", "POSN2": "", "PRCTR": "", "PROJK": "", "RMVCT": "", "RSTGR": "", "SAKNR": "70030015", "SGTXT": "A15456_陈沁_2023-05-21-2023-05-21_高铁/火车票", "UMSKZ": "", "VALUT": "", "VBEL2": "", "WAERS": "CNY", "WRBTR": "50.00", "XBLNR": "MK123050403", "XREF1": "", "XREF1_HD": "", "ZFBDT": "", "ZUONR": "", "ZZFI01": "", "ZZFI02": "101001007003", "expenseCode": "FA25680423260527740", "formType": "员工其他费用报销流程" }, { "AUFNR": "", "BKTXT": "MK123050403_A23013_戴唯", "BLART": "ZB", "BLDAT": "2023-05-29", "BSCHL": "50", "BUDAT": "2023-05-30", "BUKRS": "2010", "DMBTR": "50.00", "HKONT": "", "KOSTL": "201L007", "KURSF": "1", "MONAT": "2023-05-30", "MWSKZ": "", "POSN2": "", "PRCTR": "", "PROJK": "", "RMVCT": "", "RSTGR": "", "SAKNR": "70030022", "SGTXT": "A15456_陈沁_2023-05-21-2023-05-21_高铁/火车票", "UMSKZ": "", "VALUT": "", "VBEL2": "", "WAERS": "CNY", "WRBTR": "50.00", "XBLNR": "MK123050403", "XREF1": "", "XREF1_HD": "", "ZFBDT": "", "ZUONR": "", "ZZFI01": "", "ZZFI02": "101001007003", "expenseCode": "FA25680423260527740", "formType": "员工其他费用报销流程" }]
时间: 2023-07-03 19:22:25 浏览: 58
根据提供的JSON内容,可以将其解析成如下的数据库表:
| 字段名 | 数据类型 | 说明 |
| ------ | ------- | ---- |
| AUFNR | VARCHAR(50) | |
| BKTXT | VARCHAR(100) | |
| BLART | VARCHAR(10) | |
| BLDAT | DATE | |
| BSCHL | VARCHAR(10) | |
| BUDAT | DATE | |
| BUKRS | VARCHAR(10) | |
| DMBTR | DECIMAL(18,2) | |
| HKONT | VARCHAR(50) | |
| KOSTL | VARCHAR(50) | |
| KURSF | DECIMAL(18,2) | |
| MONAT | DATE | |
| MWSKZ | VARCHAR(10) | |
| POSN2 | VARCHAR(50) | |
| PRCTR | VARCHAR(50) | |
| PROJK | VARCHAR(50) | |
| RMVCT | VARCHAR(50) | |
| RSTGR | VARCHAR(50) | |
| SAKNR | VARCHAR(50) | |
| SGTXT | VARCHAR(200) | |
| UMSKZ | VARCHAR(10) | |
| VALUT | VARCHAR(10) | |
| VBEL2 | VARCHAR(50) | |
| WAERS | VARCHAR(10) | |
| WRBTR | DECIMAL(18,2) | |
| XBLNR | VARCHAR(50) | |
| XREF1 | VARCHAR(50) | |
| XREF1_HD | VARCHAR(50) | |
| ZFBDT | DATE | |
| ZUONR | VARCHAR(50) | |
| ZZFI01 | VARCHAR(50) | |
| ZZFI02 | VARCHAR(50) | |
| expenseCode | VARCHAR(50) | |
| formType | VARCHAR(50) | |
对应的SQL语句为:
```sql
CREATE TABLE expense (
AUFNR VARCHAR(50),
BKTXT VARCHAR(100),
BLART VARCHAR(10),
BLDAT DATE,
BSCHL VARCHAR(10),
BUDAT DATE,
BUKRS VARCHAR(10),
DMBTR DECIMAL(18,2),
HKONT VARCHAR(50),
KOSTL VARCHAR(50),
KURSF DECIMAL(18,2),
MONAT DATE,
MWSKZ VARCHAR(10),
POSN2 VARCHAR(50),
PRCTR VARCHAR(50),
PROJK VARCHAR(50),
RMVCT VARCHAR(50),
RSTGR VARCHAR(50),
SAKNR VARCHAR(50),
SGTXT VARCHAR(200),
UMSKZ VARCHAR(10),
VALUT VARCHAR(10),
VBEL2 VARCHAR(50),
WAERS VARCHAR(10),
WRBTR DECIMAL(18,2),
XBLNR VARCHAR(50),
XREF1 VARCHAR(50),
XREF1_HD VARCHAR(50),
ZFBDT DATE,
ZUONR VARCHAR(50),
ZZFI01 VARCHAR(50),
ZZFI02 VARCHAR(50),
expenseCode VARCHAR(50),
formType VARCHAR(50)
);
```