	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

VIM_1HEAD TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting
1	ERP EHP7	6.0	/OPT/VIM_1HEAD	249	7	Document Header	Financial Accounting

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DOCID, DOCTYPE, ARCHIV_ID, ARC_DOC_ID, AR_OBJECT, EDI_DOCNUM, ARCHIVE_DATE, ARCHIVE_TIME, ARCHIVE_USER, INDEX_DATE, INDEX_TIME, INDEX_USER, CHANGE_DATE, CHANGE_TIME, CHANGE_USER, BUS_OBJTYPE, BUS_OBJKEY, STATUS, CURR_ROLE, CURR_PROC_TYPE, RESCANID, DELREASON, SCAN_LOCATION, PRIORITY, NOFIRSTPASS, CHECKRULE, CHECKDUPS, CONFIRMED_NO_DUP, DUP_CHK_RUN, TARGET_SYSTEM, BUKRS, BELNR, GJAHR, BLART, BLDAT, BUDAT, XBLNR, RMWWR, WAERS, LIFNR, VEND_NAME, VEND_NAME2, EBELN, RECIPIENT_NAME, REQUISITIONER, EMAIL_ID, WINDOWS_ID, WINDOWS_DOMAIN, SKIP_STACK, BLOCK_PA, PAS_ACTIVE, ALTERNATIVE, DISTR_TYPE, EASYMATCH, SCAN_DATE, SCAN_TIME, SCAN_LOC, BATCHNUMBER, CREDIT_MEMO, VORGANG, CLASSIFIER, WERKS, WMWST, BEZNK, REMIT_STREET, REMIT_HSNM1, REMIT_PSTLZ, REMIT_LAND1, REMIT_AD_CITY1, REMIT_REGIO, REMIT_PO_BOX, REMIT_PSTL2, SHIPTO_STREET, SHIPTO_HSNM1, SHIPTO_PSTLZ, SHIPTO_LAND1, SHIPTO_AD_CITY1, SHIPTO_REGIO, SHIPTO_PO_BOX, BKTXT, SGTXT, PRORITY_FLAG, NET_AMOUNT, GROSS_AMOUNT, F_TAX_AMOUNT, S_TAX_AMOUNT, VAT_AMOUNT, TOT_TAX_AMOUNT, FREIGHT_AMOUNT, HANDLING_CHARGES, UN_ALLOCATED_EXP, EXPENSE_TYPE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, TAX_CODE, AUTO_CALC, TAX_CODE_WH, SUPPLY_DATE, VENDOR_VAT_NO, VENDOR_TAX_NO, RECEPIENT_VAT_NO, FISCAL_REP_VAT_N, PYMNT_TERMS, PYMNT_TERMS_TEXT, ISR, CM_REF_NO, CM_REF_DAT, TAX_RATE, SIRET_NO, ZERO_TAX_RATE, DOC_ARC_DOC_ID, TRNG_LEARN, FEEDB_LEARN, CHANNEL_ID, CUSTOM_FIELD4, CUSTOM_FIELD5, CUSTOM_FIELD6, CUSTOM_FIELD7, CUSTOM_FIELD8, CUSTOM_FIELD9, CUSTOM_FIELD0, PAYMENT_METHOD, PAY_METHOD_TEXT, KIDNO, INV_CAT, TAX_EXEMPT_TEXT, IMPORT_TEXT, TRI_TEXT, ORG_NUMBER, DISCOUNT, TAXRATE_1, TAXRATE_2, TAXRATE_3, TAXRATE_4, TAXAMT_1, TAXAMT_2, TAXAMT_3, TAXAMT_4, SCB_IND, TAX_INVOICE, POST_DATE_DET, ZFBDT_DET, NF_TYPE, BUPLA, TAX_LAWS, SUPCOUNTRY, BVTYP, IBAN, BANKL, BANKA, BANKN, BKREF, BANKS, BKONT, GSBER, RESTART, LAND1, BARCODE, ZFBDT, ZBD1T, ZBD1P, ZBD2T, ZBD2P, ZBD3T, SWIFT, HBKID, HKTID, ZUONR, DTAWS, DTAMS, FITYP, STCDT, STKZN, STKZU, STKZA, EMPFB, WHT_TYPE, ENRICH_FLAG, DUE_DATE, DUE_DATE1, DUE_DATE2, VAT_INV_IDENT, SECRET_CODE1, SECRET_CODE2, SECRET_CODE3, SECRET_CODE4, INVOICE_CODE, VALIDATION_CODE, NOT_HAND_WRITTEN, AFTCS_VALIDATION, USER_ID, TIME_STAMP, TAX_DESC, PAN_NO, STC_NO, TIN_TOT, LST_NO, CST_NO, ECC_NO, EDC_CESS, EXC_DUTY, SAHE_CESS, MODEL, SERIES, NFNUM, CGC, XMLVERS, AUTHCOD, DOCNUM9, ACCESSKEY, NFNUM9, CDV, TRANSPAYMENT, NFTOT, REFNFENUM, ACTION_DATE, ACTION_TIME, DOCDAT, PARID, STCD1, FLAG_ENFE, FLAG_SNFE, FLAG_SIG_VALID, ORG_NUM, ORG_DATE, REV_NUM, REV_DATE, REV_NUM_COR, REV_DATE_COR, BSTYP, CONTRACT, RETRY_NO1, RETRY_NO2, RFC_DUP, RETRY_COUNT_EXT, ORIG_AR_OBJECT, SCAN_TIMESTAMP, DOC_ARCHIV_ID, SKIP_DETERMINE, REG_ID, OTYPE, ACTORID, RTV_REASON, VATDATE, MWSKZ_BNK, TXJCD_BNK FROM /OPT/VIM_1HEAD

TOP ERP 6.0 | /OPT/VIM_1HEAD COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DOCID	Document Ledger Number	nvarchar	12	0	Allow NULL?
3	DOCTYPE	Document Type	nvarchar	10	0	Allow NULL?
4	ARCHIV_ID	Content Repository Identification	nvarchar	2	0	Allow NULL?
5	ARC_DOC_ID	SAP ArchiveLink: Document ID	nvarchar	40	0	Allow NULL?
6	AR_OBJECT	Archive Document Type	nvarchar	10	0	Allow NULL?
7	EDI_DOCNUM	IDoc number	nvarchar	16	0	Allow NULL?
8	ARCHIVE_DATE	Document Archive Date	nvarchar	8	0	Allow NULL?
9	ARCHIVE_TIME	Document Archive Time	nvarchar	6	0	Allow NULL?
10	ARCHIVE_USER	Document Archive User	nvarchar	12	0	Allow NULL?
11	INDEX_DATE	Document Create Date	nvarchar	8	0	Allow NULL?
12	INDEX_TIME	Document Create Time	nvarchar	6	0	Allow NULL?
13	INDEX_USER	User Responsible for Document Creation	nvarchar	12	0	Allow NULL?
14	CHANGE_DATE	Document Change Date	nvarchar	8	0	Allow NULL?
15	CHANGE_TIME	Document Change Time	nvarchar	6	0	Allow NULL?
16	CHANGE_USER	Document Data Change User	nvarchar	12	0	Allow NULL?
17	BUS_OBJTYPE	Object Type	nvarchar	10	0	Allow NULL?
18	BUS_OBJKEY	Object key	nvarchar	70	0	Allow NULL?
19	STATUS	Document Status	nvarchar	2	0	Allow NULL?
20	CURR_ROLE	To Actor	nvarchar	15	0	Allow NULL?
21	CURR_PROC_TYPE	Process Type	nvarchar	3	0	Allow NULL?
22	RESCANID	Rescan Reason Code	nvarchar	2	0	Allow NULL?
23	DELREASON	Document Obsolete Reason Code	nvarchar	2	0	Allow NULL?
24	SCAN_LOCATION	Scan Location for Archiving	nvarchar	25	0	Allow NULL?
25	PRIORITY	Document Priority	char	1	0	Allow NULL?
26	NOFIRSTPASS	Not First Pass	char	1	0	Allow NULL?
27	CHECKRULE	Check Rules to Determine Process Types Pending	char	1	0	Allow NULL?
28	CHECKDUPS	Duplicate Check Run Pending	char	1	0	Allow NULL?
29	CONFIRMED_NO_DUP	Duplicate Check Run Pending	char	1	0	Allow NULL?
30	DUP_CHK_RUN	Duplicate Check Run Pending	char	1	0	Allow NULL?
31	TARGET_SYSTEM	OpenText: System ID	nvarchar	10	0	Allow NULL?
32	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
33	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
34	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
35	BLART	Document Type	nvarchar	2	0	Allow NULL?
36	BLDAT	Document Date in Document	nvarchar	8	0	Allow NULL?
37	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
38	XBLNR	Reference Document Number	nvarchar	16	0	Allow NULL?
39	RMWWR	Gross invoice amount in document currency	decimal	13	2
40	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
41	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
42	VEND_NAME	Name 1	nvarchar	35	0	Allow NULL?
43	VEND_NAME2	Name 2	nvarchar	35	0	Allow NULL?
44	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
45	RECIPIENT_NAME	Recipient Name	nvarchar	35	0	Allow NULL?
46	REQUISITIONER	Open Text User Mapping Object ID	nvarchar	35	0	Allow NULL?
47	EMAIL_ID	E-Mail Address	nvarchar	80	0	Allow NULL?
48	WINDOWS_ID	Windows Id	nvarchar	30	0	Allow NULL?
49	WINDOWS_DOMAIN	Windows Domain	nvarchar	63	0	Allow NULL?
50	SKIP_STACK	Skip Approval Stack	char	1	0	Allow NULL?
51	BLOCK_PA	Payment Block Key	char	1	0	Allow NULL?
52	PAS_ACTIVE	Activate PAS for whole process flow	char	1	0	Allow NULL?
53	ALTERNATIVE	Cost handling alternative	nvarchar	2	0	Allow NULL?
54	DISTR_TYPE	Distribution Type for Unplanned Costs	char	1	0	Allow NULL?
55	EASYMATCH	Add. Cost Easymatch Flag	char	1	0	Allow NULL?
56	SCAN_DATE	System Date	nvarchar	8	0	Allow NULL?
57	SCAN_TIME	System Time	nvarchar	6	0	Allow NULL?
58	SCAN_LOC	Scan Location	nvarchar	25	0	Allow NULL?
59	BATCHNUMBER	Batch Number	nvarchar	40	0	Allow NULL?
60	CREDIT_MEMO	Credit Memo Indicator	char	1	0	Allow NULL?
61	VORGANG	List field: transaction/event	char	1	0	Allow NULL?
62	CLASSIFIER	Classifier for VIM document types	nvarchar	2	0	Allow NULL?
63	WERKS	Plant	nvarchar	4	0	Allow NULL?
64	WMWST	Tax amount in document currency	decimal	13	2
65	BEZNK	Unplanned delivery costs	decimal	13	2
66	REMIT_STREET	Street	nvarchar	60	0	Allow NULL?
67	REMIT_HSNM1	House Number	nvarchar	10	0	Allow NULL?
68	REMIT_PSTLZ	City postal code	nvarchar	10	0	Allow NULL?
69	REMIT_LAND1	Country Key	nvarchar	3	0	Allow NULL?
70	REMIT_AD_CITY1	City	nvarchar	40	0	Allow NULL?
71	REMIT_REGIO	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
72	REMIT_PO_BOX	PO Box	nvarchar	10	0	Allow NULL?
73	REMIT_PSTL2	P.O. Box Postal Code	nvarchar	10	0	Allow NULL?
74	SHIPTO_STREET	Street	nvarchar	60	0	Allow NULL?
75	SHIPTO_HSNM1	House Number	nvarchar	10	0	Allow NULL?
76	SHIPTO_PSTLZ	City postal code	nvarchar	10	0	Allow NULL?
77	SHIPTO_LAND1	Country Key	nvarchar	3	0	Allow NULL?
78	SHIPTO_AD_CITY1	City	nvarchar	40	0	Allow NULL?
79	SHIPTO_REGIO	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
80	SHIPTO_PO_BOX	PO Box	nvarchar	10	0	Allow NULL?
81	BKTXT	Document Header Text	nvarchar	25	0	Allow NULL?
82	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
83	PRORITY_FLAG	Document Priority	char	1	0	Allow NULL?
84	NET_AMOUNT	Amount	decimal	13	2
85	GROSS_AMOUNT	Amount	decimal	13	2
86	F_TAX_AMOUNT	Amount	decimal	13	2
87	S_TAX_AMOUNT	Amount	decimal	13	2
88	VAT_AMOUNT	Amount	decimal	13	2
89	TOT_TAX_AMOUNT	Amount	decimal	13	2
90	FREIGHT_AMOUNT	Amount	decimal	13	2
91	HANDLING_CHARGES	Amount	decimal	13	2
92	UN_ALLOCATED_EXP	Amount	decimal	13	2
93	EXPENSE_TYPE	Invoice Approval Expense Type	nvarchar	2	0	Allow NULL?
94	ATTRIBUTE1	Character Field Length = 10	nvarchar	10	0	Allow NULL?
95	ATTRIBUTE2	Character Field Length = 10	nvarchar	10	0	Allow NULL?
96	ATTRIBUTE3	Char 20	nvarchar	20	0	Allow NULL?
97	ATTRIBUTE4	Char 20	nvarchar	20	0	Allow NULL?
98	TAX_CODE	Tax Code	nvarchar	2	0	Allow NULL?
99	AUTO_CALC	Calculate Tax Automatically	char	1	0	Allow NULL?
100	TAX_CODE_WH	Withholding Tax Code	nvarchar	2	0	Allow NULL?
101	SUPPLY_DATE	Date of Supply	nvarchar	8	0	Allow NULL?
102	VENDOR_VAT_NO	VAT Registration Number	nvarchar	20	0	Allow NULL?
103	VENDOR_TAX_NO	Tax number at responsible tax office	nvarchar	18	0	Allow NULL?
104	RECEPIENT_VAT_NO	VAT Registration Number	nvarchar	20	0	Allow NULL?
105	FISCAL_REP_VAT_N	Fiscal Representative VAT Number	nvarchar	18	0	Allow NULL?
106	PYMNT_TERMS	Terms of Payment Key	nvarchar	4	0	Allow NULL?
107	PYMNT_TERMS_TEXT	Payment Terms text	nvarchar	40	0	Allow NULL?
108	ISR	POR subscriber number	nvarchar	90	0	Allow NULL?
109	CM_REF_NO	Reference document number	nvarchar	16	0	Allow NULL?
110	CM_REF_DAT	Credit Memo Ref Date	nvarchar	8	0	Allow NULL?
111	TAX_RATE	Data element for Tax rate	decimal	12	3
112	SIRET_NO	Siret Number	nvarchar	14	0	Allow NULL?
113	ZERO_TAX_RATE	Character Field Length = 10	nvarchar	10	0	Allow NULL?
114	DOC_ARC_DOC_ID	SAP ArchiveLink: Document ID	nvarchar	40	0	Allow NULL?
115	TRNG_LEARN	Flag: Training/Learning required	char	1	0	Allow NULL?
116	FEEDB_LEARN	Flag: Feedback Learning	char	1	0	Allow NULL?
117	CHANNEL_ID	Channel ID	nvarchar	10	0	Allow NULL?
118	CUSTOM_FIELD4	Character Field Length 1	char	1	0	Allow NULL?
119	CUSTOM_FIELD5	Text Field of Length 60	nvarchar	60	0	Allow NULL?
120	CUSTOM_FIELD6	Text (10 Characters)	nvarchar	10	0	Allow NULL?
121	CUSTOM_FIELD7	Character Field Length 1	char	1	0	Allow NULL?
122	CUSTOM_FIELD8	Text (10 Characters)	nvarchar	10	0	Allow NULL?
123	CUSTOM_FIELD9	Text (20 Characters)	nvarchar	20	0	Allow NULL?
124	CUSTOM_FIELD0	Text (20 Characters)	nvarchar	20	0	Allow NULL?
125	PAYMENT_METHOD	Payment Method	char	1	0	Allow NULL?
126	PAY_METHOD_TEXT	Name of Payment Method in Language of the Country	nvarchar	30	0	Allow NULL?
127	KIDNO	Payment Reference	nvarchar	30	0	Allow NULL?
128	INV_CAT	Invoice category	char	1	0	Allow NULL?
129	TAX_EXEMPT_TEXT	Tax Exempt Text	nvarchar	50	0	Allow NULL?
130	IMPORT_TEXT	Import Special Text	nvarchar	50	0	Allow NULL?
131	TRI_TEXT	Triangulation Text	nvarchar	50	0	Allow NULL?
132	ORG_NUMBER	Organization Number	nvarchar	20	0	Allow NULL?
133	DISCOUNT	Discount mentioned on the Invocie	decimal	11	2
134	TAXRATE_1	Data element for Tax rate	decimal	12	3
135	TAXRATE_2	Data element for Tax rate	decimal	12	3
136	TAXRATE_3	Data element for Tax rate	decimal	12	3
137	TAXRATE_4	Data element for Tax rate	decimal	12	3
138	TAXAMT_1	Amount	decimal	13	2
139	TAXAMT_2	Amount	decimal	13	2
140	TAXAMT_3	Amount	decimal	13	2
141	TAXAMT_4	Amount	decimal	13	2
142	SCB_IND	State Central Bank Indicator	nvarchar	3	0	Allow NULL?
143	TAX_INVOICE	Tax Invoice	char	1	0	Allow NULL?
144	POST_DATE_DET	Date to be used as Posting Date while creating the SAP Doc	char	1	0	Allow NULL?
145	ZFBDT_DET	Baseline Date Determination Method	char	1	0	Allow NULL?
146	NF_TYPE	Nota Fiscal Type	nvarchar	2	0	Allow NULL?
147	BUPLA	Business Place	nvarchar	4	0	Allow NULL?
148	TAX_LAWS	Tax Laws - Brazil	nvarchar	20	0	Allow NULL?
149	SUPCOUNTRY	Supplying Country	nvarchar	3	0	Allow NULL?
150	BVTYP	Partner Bank Type	nvarchar	4	0	Allow NULL?
151	IBAN	IBAN (International Bank Account Number)	nvarchar	34	0	Allow NULL?
152	BANKL	Bank number	nvarchar	15	0	Allow NULL?
153	BANKA	Name of bank	nvarchar	60	0	Allow NULL?
154	BANKN	Bank account number	nvarchar	18	0	Allow NULL?
155	BKREF	Reference specifications for bank details	nvarchar	20	0	Allow NULL?
156	BANKS	Bank country key	nvarchar	3	0	Allow NULL?
157	BKONT	Bank Control Key	nvarchar	2	0	Allow NULL?
158	GSBER	Business Area	nvarchar	4	0	Allow NULL?
159	RESTART	X: Restart	char	1	0	Allow NULL?
160	LAND1	Country Key	nvarchar	3	0	Allow NULL?
161	BARCODE	Bar code	nvarchar	64	0	Allow NULL?
162	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	Allow NULL?
163	ZBD1T	Cash discount days 1	decimal	3	0
164	ZBD1P	Cash Discount Percentage 1	decimal	5	3
165	ZBD2T	Cash discount days 2	decimal	3	0
166	ZBD2P	Cash Discount Percentage 2	decimal	5	3
167	ZBD3T	Net Payment Terms Period	decimal	3	0
168	SWIFT	SWIFT/BIC for International Payments	nvarchar	11	0	Allow NULL?
169	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
170	HKTID	ID for account details	nvarchar	5	0	Allow NULL?
171	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
172	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	Allow NULL?
173	DTAMS	Indicator for Data Medium Exchange	char	1	0	Allow NULL?
174	FITYP	Tax type	nvarchar	2	0	Allow NULL?
175	STCDT	Tax Number Type	nvarchar	2	0	Allow NULL?
176	STKZN	Natural Person	char	1	0	Allow NULL?
177	STKZU	Liable for VAT	char	1	0	Allow NULL?
178	STKZA	Indicator: Business Partner Subject to Equalization Tax?	char	1	0	Allow NULL?
179	EMPFB	Vendor Permitted as Payee	nvarchar	10	0	Allow NULL?
180	WHT_TYPE	Withholding Tax Processing Type	char	1	0	Allow NULL?
181	ENRICH_FLAG	Flag indicating data enrichment	char	1	0	Allow NULL?
182	DUE_DATE	Due Date	nvarchar	8	0	Allow NULL?
183	DUE_DATE1	Due Date for Cash Discount 1	nvarchar	8	0	Allow NULL?
184	DUE_DATE2	Due Date for Cash Discount 2	nvarchar	8	0	Allow NULL?
185	VAT_INV_IDENT	VAT Invoice Identifier	nvarchar	10	0	Allow NULL?
186	SECRET_CODE1	Secret Code	nvarchar	27	0	Allow NULL?
187	SECRET_CODE2	Secret Code	nvarchar	27	0	Allow NULL?
188	SECRET_CODE3	Secret Code	nvarchar	27	0	Allow NULL?
189	SECRET_CODE4	Secret Code	nvarchar	27	0	Allow NULL?
190	INVOICE_CODE	Invoice Code	nvarchar	12	0	Allow NULL?
191	VALIDATION_CODE	Validation Code	nvarchar	30	0	Allow NULL?
192	NOT_HAND_WRITTEN	Not a Hand Written Invoice	char	1	0	Allow NULL?
193	AFTCS_VALIDATION	AFTCS Validation Indicator	char	1	0	Allow NULL?
194	USER_ID	User id that set the AFTCS Validation Indicator	nvarchar	12	0	Allow NULL?
195	TIME_STAMP	AFTCS Validation TimeStamp	decimal	15	0
196	TAX_DESC	Tax Description	char	1	0	Allow NULL?
197	PAN_NO	Permanent Account Number	nvarchar	40	0	Allow NULL?
198	STC_NO	STC Number	nvarchar	30	0	Allow NULL?
199	TIN_TOT	TIN/TOT Number	nvarchar	11	0	Allow NULL?
200	LST_NO	LST Number	nvarchar	40	0	Allow NULL?
201	CST_NO	CST Number	nvarchar	40	0	Allow NULL?
202	ECC_NO	ECC Number	nvarchar	40	0	Allow NULL?
203	EDC_CESS	Educational Cess	decimal	13	2
204	EXC_DUTY	Excise Duty	decimal	13	2
205	SAHE_CESS	Secondary & Higher Educational Cess	decimal	13	2
206	MODEL	Model of Nota Fiscal	nvarchar	2	0	Allow NULL?
207	SERIES	Series	nvarchar	3	0	Allow NULL?
208	NFNUM	Nota Fiscal Number	nvarchar	6	0	Allow NULL?
209	CGC	CNPJ Number	nvarchar	14	0	Allow NULL?
210	XMLVERS	NF-e: XML Version	decimal	4	2
211	AUTHCOD	NF-e: Protocol Number	nvarchar	15	0	Allow NULL?
212	DOCNUM9	NF-e: Random Number	nvarchar	9	0	Allow NULL?
213	ACCESSKEY	NF-e: 44-Digit Access Key	nvarchar	44	0	Allow NULL?
214	NFNUM9	Nine-Digit NF-e Number	nvarchar	9	0	Allow NULL?
215	CDV	Check Digit for NF-e Access Key	char	1	0	Allow NULL?
216	TRANSPAYMENT	Payment flag	char	1	0	Allow NULL?
217	NFTOT	Total value including all taxes	decimal	15	2
218	REFNFENUM	Nine-Digit NF-e Number	nvarchar	9	0	Allow NULL?
219	ACTION_DATE	NF-e Processing Timestamp - Date	nvarchar	8	0	Allow NULL?
220	ACTION_TIME	NF-e Processing Timestamp - Time	nvarchar	6	0	Allow NULL?
221	DOCDAT	Document date	nvarchar	8	0	Allow NULL?
222	PARID	Partner ID (Customer, Vendor, Business Place)	nvarchar	10	0	Allow NULL?
223	STCD1	CNPJ Number	nvarchar	14	0	Allow NULL?
224	FLAG_ENFE	Checkbox	char	1	0	Allow NULL?
225	FLAG_SNFE	Checkbox	char	1	0	Allow NULL?
226	FLAG_SIG_VALID	Checkbox	char	1	0	Allow NULL?
227	ORG_NUM	Invoice Number of original invoice	nvarchar	16	0	Allow NULL?
228	ORG_DATE	Date of original invoice	nvarchar	8	0	Allow NULL?
229	REV_NUM	Revision number of invoice	nvarchar	16	0	Allow NULL?
230	REV_DATE	Date of revision invoice	nvarchar	8	0	Allow NULL?
231	REV_NUM_COR	Revision number of corrective invoice	nvarchar	16	0	Allow NULL?
232	REV_DATE_COR	Revision date of corrective invoice	nvarchar	8	0	Allow NULL?
233	BSTYP	Purchasing Document Category	char	1	0	Allow NULL?
234	CONTRACT	Purchasing Document Number	nvarchar	10	0	Allow NULL?
235	RETRY_NO1	Extraction Retry	int	10	0	Allow NULL?
236	RETRY_NO2	Validation Retry	int	10	0	Allow NULL?
237	RFC_DUP	Duplicate Check Run Pending	char	1	0	Allow NULL?
238	RETRY_COUNT_EXT	Number of retries for external workflow	nvarchar	4	0	Allow NULL?
239	ORIG_AR_OBJECT	Original Archive Document Type	nvarchar	10	0	Allow NULL?
240	SCAN_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0
241	DOC_ARCHIV_ID	Content Repository Identification	nvarchar	2	0	Allow NULL?
242	SKIP_DETERMINE	General Flag	char	1	0	Allow NULL?
243	REG_ID	Registration Number for incoming document handler	nvarchar	12	0	Allow NULL?
244	OTYPE	Object Type	nvarchar	2	0	Allow NULL?
245	ACTORID	Agent ID in Organizational Management	nvarchar	12	0	Allow NULL?
246	RTV_REASON	Return to Vendor - reasons	nvarchar	2	0	Allow NULL?
247	VATDATE	VAT Date	nvarchar	8	0	Allow NULL?
248	MWSKZ_BNK	Tax code for delivery costs	nvarchar	2	0	Allow NULL?
249	TXJCD_BNK	Jurisdiction code for delivery costs	nvarchar	15	0	Allow NULL?

TOP ERP 6.0 | /OPT/VIM_1HEAD INDEXES

Name	Primary	Unique	Type	Columns
/OPT/VIM_1HEAD~0	Yes	Yes	CLUSTERED	DOCID, MANDT
/OPT/VIM_1HEAD~001	No	No	NONCLUSTERED	BUS_OBJTYPE, BUS_OBJKEY
/OPT/VIM_1HEAD~002	No	No	NONCLUSTERED	GROSS_AMOUNT, STATUS, RMWWR, LIFNR
/OPT/VIM_1HEAD~003	No	No	NONCLUSTERED	GJAHR, BELNR, BUKRS
/OPT/VIM_1HEAD~004	No	No	NONCLUSTERED	STATUS
/OPT/VIM_1HEAD~AX8	No	No	NONCLUSTERED	STATUS, DOCTYPE, ORIG_AR_OBJECT, CHANNEL_ID, DOCID
/OPT/VIM_1HEAD~VAL	No	No	NONCLUSTERED	STATUS, AR_OBJECT, DOCID

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

249 COLUMNS | 7 INDEXES | ERP 6.0 | /OPT/VIM_1HEAD TABLE

TOP ERP 6.0 | /OPT/VIM_1HEAD COLUMNS

TOP ERP 6.0 | /OPT/VIM_1HEAD INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

249 COLUMNS | 7 INDEXES | ERP 6.0 | /OPT/VIM_1HEAD TABLE

TOPERP 6.0 | /OPT/VIM_1HEAD COLUMNS

TOPERP 6.0 | /OPT/VIM_1HEAD INDEXES

TOP ERP 6.0 | /OPT/VIM_1HEAD COLUMNS

TOP ERP 6.0 | /OPT/VIM_1HEAD INDEXES