File Data definitions Latest N ALL DDLS- Sample file.xlsx

	A	B	C	D	E	G	H	L
1	Field	File	Text	Type	Length
2	CUSTID	BKDINVSLS	DKALNB	NUMERIC	7	CUSTID	NUMBER(7,0)	NUMBER(38,0),
3	INVOICENBR	BKDINVSLS	DKBANB	NUMERIC	9	INVOICENBR	NUMBER(9,0)	NUMBER(38,0),
4	LINENBR	BKDINVSLS	DKAZNB	NUMERIC	3	LINENBR	NUMBER(3,0)	NUMBER(38,0),
5	VERSION	BKDINVSLS	T01.DKEXNB	NUMERIC	3	VERSION	NUMBER(3,0)	NUMBER(38,0),
6	TRANSTYPE	BKDINVSLS	DKGWST	CHAR	1	TRANSTYPE	VARCHAR(1)	VARCHAR(255),
7	AUDITDT	BKDINVSLS	T01.DKAGDT	NUMERIC	7	AUDITDT	NUMBER(7,0)	DATE,
8	SOLDLOC	BKDINVSLS	DKAACD	CHAR	3	SOLDLOC	VARCHAR(3)	VARCHAR(255),
9	EMPLOC	BKDINVSLS	APAACD	CHAR	3	EMPLOC	VARCHAR(3)	VARCHAR(255),
10	POSTEDYR	BKDINVSLS	T01.DKHRNB	NUMERIC	4	POSTEDYR	NUMBER(4,0)	NUMBER(38,0),
11	POSTEDMTH	BKDINVSLS	T01.DKHQNB	NUMERIC	2	POSTEDMTH	NUMBER(2,0)	NUMBER(38,0),
12	QTY	BKDINVSLS	DKA5NB	NUMERIC	5	QTY	NUMBER(5,0)	NUMBER(38,0),
13	MODELNBR	BKDINVSLS	DKAXTX	CHAR	20	MODELNBR	VARCHAR(20)	VARCHAR(255),
14	MODELDESC	BKDINVSLS	AXA2TX	CHAR	25	MODELDESC	VARCHAR(25)	VARCHAR(255),
15	VENDORID	BKDINVSLS	DKBLNB	CHAR	7	VENDORID	VARCHAR(7)	VARCHAR(255),
16	VENDORNAME	BKDINVSLS	AVNME	CHAR	30	VENDORNAME	VARCHAR(30)	VARCHAR(255),
17	SLSCLASS	BKDINVSLS	SLSCLASS04	CHAR	3	SLSCLASS	VARCHAR(3)	VARCHAR(255),
18	SLSCLSDESC	BKDINVSLS	BLA7TX	CHAR	20	SLSCLSDESC	VARCHAR(20)	VARCHAR(255),
19	PRODCAT	BKDINVSLS	DKAXCD	CHAR	3	PRODCAT	VARCHAR(3)	VARCHAR(255),
20	PRODCATDSC	BKDINVSLS	BKA6TX	CHAR	20	PRODCATDSC	VARCHAR(20)	VARCHAR(255),
21	MEREXTTAMT	BKDINVSLS	EXTTAMT	NUMERIC	9	MEREXTTAMT	NUMBER(9,2)	NUMBER(38,7),
22	PRCEXTTAMT	BKDINVSLS	T03.PRCEXTTA01	NUMERIC	12	PRCEXTTAMT	NUMBER(12,2)	NUMBER(38,0),
23	WAREXTTAMT	BKDINVSLS	EXTTAMT	NUMERIC	9	WAREXTTAMT	NUMBER(9,2)	NUMBER(38,7),
24	INSEXTTAMT	BKDINVSLS	EXTTAMT	NUMERIC	9	INSEXTTAMT	NUMBER(9,2)	NUMBER(38,0),
25	TOTEXTTAMT	BKDINVSLS	EXTTAMT01	NUMERIC	12	TOTEXTTAMT	NUMBER(12,2)	NUMBER(38,7),
26	TAXES	BKDINVSLS	d4oea$+d4ofa$+d4oga$+d4oha$	NUMERIC	7	TAXES	NUMBER(7,2)	NUMBER(38,7),
27	GRANDTOTLN	BKDINVSLS	T01.TOTEXTTAMT + T02.TAXES	NUMERIC	12	GRANDTOTLN	NUMBER(12,2)	NUMBER(38,7),
28	MEREXTCAMT	BKDINVSLS	EXTCAMT	NUMERIC	9	MEREXTCAMT	NUMBER(9,2)	NUMBER(38,0),
29	WAREXTCAMT	BKDINVSLS	EXTCAMT	NUMERIC	9	WAREXTCAMT	NUMBER(9,2)	NUMBER(38,0),
30	INSEXTCAMT	BKDINVSLS	EXTCAMT	NUMERIC	9	INSEXTCAMT	NUMBER(9,2)	NUMBER(38,0),
31	TOTEXTCAMT	BKDINVSLS	EXTCAMT01	NUMERIC	12	TOTEXTCAMT	NUMBER(12,2)	NUMBER(38,0),
32	MINSTALLCD	BKDINVSLS	INSTALLCD	CHAR	3	MINSTALLCD	VARCHAR(3)	VARCHAR(255),
33	IINSTALLCD	BKDINVSLS	INSTALLCD	CHAR	3	IINSTALLCD	VARCHAR(3)	VARCHAR(255),
34	EMPID	BKDINVSLS	MEREMPID	CHAR	5	EMPID	VARCHAR(5)	VARCHAR(255),
35	EMPNAME	BKDINVSLS	APA0TX	CHAR	30	EMPNAME	VARCHAR(30)	VARCHAR(255),
36	OBSCD	BKDINVSLS	'Y'	CHAR	1	OBSCD	VARCHAR(1)	VARCHAR(255),
37	OBSDT	BKDINVSLS	GGDBDT	NUMERIC	7	OBSDT	NUMBER(7,0)	DATE,
38	CUSTZIP	BKDINVSLS	T02.FGJ2XT	CHAR	10	CUSTZIP	VARCHAR(10)	VARCHAR(255),
39	TOTCONNAMT	BKDINVSLS	T01.TOTEXTTAMT * T02.CONNPCT	NUMERIC	10	TOTCONNAMT	NUMBER(10,2)	NUMBER(38,0),
40	TOTGEAMT	BKDINVSLS	T01.TOTEXTTAMT * T02.GEPCT	NUMERIC	10	TOTGEAMT	NUMBER(10,2),	NUMBER(38,0),
41	TOTRACAMT	BKDINVSLS	T01.TOTEXTTAMT * T02.RACPCT	NUMERIC	10	TOTRACAMT	NUMBER(10,2),	NUMBER(38,0),
42	TOTDPAMT	BKDINVSLS	T01.TOTEXTTAMT * T02.DPPCT	NUMERIC	10	TOTDPAMT	NUMBER(10,2)	NUMBER(38,7),
43	TOTCASHAMT	BKDINVSLS	T01.TOTEXTTAMT * T02.CASHPCT	NUMERIC	10	TOTCASHAMT	NUMBER(10,2),	NUMBER(38,0),
44	TOTCCAMT	BKDINVSLS	T01.TOTEXTTAMT * T02.CCPCT	NUMERIC	10	TOTCCAMT	NUMBER(10,2),	NUMBER(38,0),
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100