FA_CARDHISTORY

FA_CARDHISTORY_BACKUP
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	ACCUDEP	NUMBER	28	8			√
2	ACCUDEP_CAL	NUMBER	28	8			√
3	ACCUDEP_GLOBAL	NUMBER	28	8			√
4	ACCUDEP_GROUP	NUMBER	28	8			√
5	ACCUWORKLOAN	NUMBER	28	8			√
6	ACCYEAR	VARCHAR2	4				√
7	ALLWORKLOAN	NUMBER	28	8			√
8	ASSET_STATE	VARCHAR2	20				√
9	BUSINESS_FLAG	CHAR	1				√
10	CARD_NUM	NUMBER	38	0			√
11	CURRYEARDEP	NUMBER	28	8			√
12	CURRYEARDEP_GLOBAL	NUMBER	28	8			√
13	CURRYEARDEP_GROUP	NUMBER	28	8			√
14	DEP_END_DATE	CHAR	19				√
15	DEP_START_DATE	CHAR	19				√
16	DEPAMOUNT	NUMBER	28	8			√
17	DEPAMOUNT_GLOBAL	NUMBER	28	8			√
18	DEPAMOUNT_GROUP	NUMBER	28	8			√
19	DEPRATE	NUMBER	28	13			√
20	DEPUNIT	NUMBER	28	8			√
21	DEPUNIT_GLOBAL	NUMBER	28	8			√
22	DEPUNIT_GROUP	NUMBER	28	8			√
23	DR	NUMBER	10	0			√	0
24	HERIT_FLAG	CHAR	1				√
25	LASTSTATE_FLAG	CHAR	1				√
26	LOCALCURR_RATE	NUMBER	28	8			√
27	LOCALORIGIN_COUNT	NUMBER	28	8			√
28	LOCALORIGINVALUE	NUMBER	28	8			√
29	LOCALORIGINVALUE_GLOBAL	NUMBER	28	8			√
30	LOCALORIGINVALUE_GROUP	NUMBER	28	8			√
31	MONTHWORKLOAN	NUMBER	28	8			√
32	NATUREMONTH	NUMBER	38	0			√
33	NEWASSET_FLAG	NUMBER	38	0			√
34	ORIGINVALUE	NUMBER	28	8			√
35	ORIGINVALUE_CAL	NUMBER	28	8			√
36	PAYDEPT_FLAG	VARCHAR2	40				√
37	PERIOD	VARCHAR2	2				√
38	PK_ACCBOOK	VARCHAR2	20				√	'~'
39	PK_CARD	CHAR	20
40	PK_CARDHISTORY	CHAR	20		√
41	PK_CATEGORY	VARCHAR2	20				√	'~'
42	PK_CATEGORY_OLD	VARCHAR2	20				√
43	PK_COSTCENTER	VARCHAR2	20				√
44	PK_COSTCENTER_OLD	VARCHAR2	20				√
45	PK_DEPMETHOD	VARCHAR2	20				√	'~'
46	PK_DEPMETHOD_OLD	VARCHAR2	20				√
47	PK_EQUIPORG	VARCHAR2	20				√	'~'
48	PK_EQUIPORG_V	VARCHAR2	20				√	'~'
49	PK_GROUP	VARCHAR2	20				√	'~'
50	PK_JOBMNGFIL	VARCHAR2	20				√	'~'
51	PK_JOBMNGFIL_OLD	VARCHAR2	20				√
52	PK_MANDEPT	VARCHAR2	20				√	'~'
53	PK_MANDEPT_OLD	VARCHAR2	20				√
54	PK_MANDEPT_V	VARCHAR2	20				√	'~'
55	PK_ORG	VARCHAR2	20				√	'~'
56	PK_ORG_V	VARCHAR2	20				√	'~'
57	PK_OWNERORG	VARCHAR2	20				√
58	PK_OWNERORG_V	VARCHAR2	20				√
59	PK_USEDEPT	VARCHAR2	20				√	'~'
60	PK_USEDEPT_OLD	VARCHAR2	20				√
61	PK_USINGSTATUS	VARCHAR2	20				√	'~'
62	PK_USINGSTATUS_OLD	VARCHAR2	20				√
63	PREDEVALUATE	NUMBER	28	8			√
64	PREDEVALUATE_GLOBAL	NUMBER	28	8			√
65	PREDEVALUATE_GROUP	NUMBER	28	8			√
66	SALVAGE	NUMBER	28	8			√
67	SALVAGE_GLOBAL	NUMBER	28	8			√
68	SALVAGE_GROUP	NUMBER	28	8			√
69	SALVAGERATE	NUMBER	28	8			√
70	SERVICEMONTH	NUMBER	38	0			√
71	SERVICEMONTH_CAL	NUMBER	38	0			√
72	TAX_INPUT	NUMBER	28	8			√
73	TAX_INPUT_GLOBAL	NUMBER	28	8			√
74	TAX_INPUT_GROUP	NUMBER	28	8			√
75	TAXINPUT_FLAG	CHAR	1				√
76	TS	CHAR	19				√	to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')
77	USEDEP_FLAG	CHAR	1				√
78	USEDMONTH	NUMBER	38	0			√
79	USEDMONTH_CAL	NUMBER	38	0			√
80	WORKLOANUNIT	VARCHAR2	80				√