	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	BSEG	345	Accounting Document Segment
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
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	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	DOCID	Document Ledger Number	nvarchar	12	0	NUMC	(N'000000000000')	No		/OPT/DOCID	Allow NULL?
3	DOCTYPE	Document Type	nvarchar	10	0	CHAR	(N' ')	No	/OPT/VIM_T100	/OPT/DOCTYPE	Allow NULL?
4	ARCHIV_ID	Content Repository Identification	nvarchar	2	0	CHAR	(N' ')	Yes	*	/OPT/SAEARCHIVI	Allow NULL?
5	ARC_DOC_ID	SAP ArchiveLink: Document ID	nvarchar	40	0	CHAR	(N' ')	Yes		/OPT/SAEARDOID	Allow NULL?
6	AR_OBJECT	Archive Document Type	nvarchar	10	0	CHAR	(N' ')	Yes	TOADV	/OPT/SAEOBJART_DE	Allow NULL?
7	EDI_DOCNUM	IDoc number	nvarchar	16	0	NUMC	(N'0000000000000000')	Yes		EDI_DOCNUM	Allow NULL?
8	ARCHIVE_DATE	Document Archive Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/ARDATE	Allow NULL?
9	ARCHIVE_TIME	Document Archive Time	nvarchar	6	0	TIMS	(N'000000')	Yes		/OPT/ARTIME	Allow NULL?
10	ARCHIVE_USER	Document Archive User	nvarchar	12	0	CHAR	(N' ')	Yes		/OPT/ARUSER	Allow NULL?
11	INDEX_DATE	Document Create Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/DOCCRDATE	Allow NULL?
12	INDEX_TIME	Document Create Time	nvarchar	6	0	TIMS	(N'000000')	Yes		/OPT/DOCCRTIME	Allow NULL?
13	INDEX_USER	User Responsible for Document Creation	nvarchar	12	0	CHAR	(N' ')	Yes		/OPT/DOCCRUSER	Allow NULL?
14	CHANGE_DATE	Document Change Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/DOCCHDATE	Allow NULL?
15	CHANGE_TIME	Document Change Time	nvarchar	6	0	TIMS	(N'000000')	Yes		/OPT/DOCCHTIME	Allow NULL?
16	CHANGE_USER	Document Data Change User	nvarchar	12	0	CHAR	(N' ')	Yes		/OPT/DOCCHUSER	Allow NULL?
17	BUS_OBJTYPE	Object Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	SWO_OBJTYP	Allow NULL?
18	BUS_OBJKEY	Object key	nvarchar	70	0	CHAR	(N' ')	Yes		SWO_TYPEID	Allow NULL?
19	STATUS	Document Status	nvarchar	2	0	CHAR	(N' ')	Yes	/OPT/VIM_T101	/OPT/DOCSTATUS	Allow NULL?
20	CURR_ROLE	To Actor	nvarchar	15	0	CHAR	(N' ')	Yes	/PTGWFI/W_ROLET	/OPT/TOACTOR	Allow NULL?
21	CURR_PROC_TYPE	Process Type	nvarchar	3	0	NUMC	(N'000')	Yes	/OPT/VIM_T800	/OPT/PROCESS_TYPE	Allow NULL?
22	RESCANID	Rescan Reason Code	nvarchar	2	0	CHAR	(N' ')	Yes	/OPT/VIM_T116	/OPT/RESCANID	Allow NULL?
23	DELREASON	Document Obsolete Reason Code	nvarchar	2	0	CHAR	(N' ')	Yes	/OPT/VIM_T117	/OPT/DELREASON	Allow NULL?
24	SCAN_LOCATION	Scan Location for Archiving	nvarchar	25	0	CHAR	(N' ')	Yes	/OPT/VIM_T121	/OPT/SCAN_LOCATION	Allow NULL?
25	PRIORITY	Document Priority	char	1	0	CHAR	(N' ')	Yes	/OPT/VIM_T122	/OPT/DOC_PRIORITY	Allow NULL?
26	NOFIRSTPASS	Not First Pass	char	1	0	CHAR	(N' ')	Yes		/OPT/NOFIRSTPASS	Allow NULL?
27	CHECKRULE	Check Rules to Determine Process Types Pending	char	1	0	CHAR	(N' ')	Yes		/OPT/DP_CHECKRULES	Allow NULL?
28	CHECKDUPS	Duplicate Check Run Pending	char	1	0	CHAR	(N' ')	Yes		/OPT/DP_CHECKDUPS	Allow NULL?
29	CONFIRMED_NO_DUP	Duplicate Check Run Pending	char	1	0	CHAR	(N' ')	Yes		/OPT/DP_CHECKDUPS	Allow NULL?
30	DUP_CHK_RUN	Duplicate Check Run Pending	char	1	0	CHAR	(N' ')	Yes		/OPT/DP_CHECKDUPS	Allow NULL?
31	TARGET_SYSTEM	OpenText: System ID	nvarchar	10	0	CHAR	(N' ')	Yes		/OPT/SYS_SID	Allow NULL?
32	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
33	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
34	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
35	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	T003	BLART	Allow NULL?
36	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
37	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
38	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR	Allow NULL?
39	RMWWR	Gross invoice amount in document currency	decimal	13	2	CURR	((0))	Yes		RMWWR
40	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
41	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	*	LIFNR	Allow NULL?
42	VEND_NAME	Name 1	nvarchar	35	0	CHAR	(N' ')	Yes		NAME1_GP	Allow NULL?
43	VEND_NAME2	Name 2	nvarchar	35	0	CHAR	(N' ')	Yes		NAME2_GP	Allow NULL?
44	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	/OPT/EBELN	Allow NULL?
45	RECIPIENT_NAME	Recipient Name	nvarchar	35	0	CHAR	(N' ')	Yes		/OPT/VIM_RECIPIENT_NAME	Allow NULL?
46	REQUISITIONER	Open Text User Mapping Object ID	nvarchar	35	0	CHAR	(N' ')	Yes	*	/ORS/UMOID	Allow NULL?
47	EMAIL_ID	E-Mail Address	nvarchar	80	0	CHAR	(N' ')	Yes		/OPT/EMAIL	Allow NULL?
48	WINDOWS_ID	Windows Id	nvarchar	30	0	CHAR	(N' ')	Yes		/OPT/WINID	Allow NULL?
49	WINDOWS_DOMAIN	Windows Domain	nvarchar	63	0	CHAR	(N' ')	Yes		/OPT/WINDOMAIN	Allow NULL?
50	SKIP_STACK	Skip Approval Stack	char	1	0	CHAR	(N' ')	Yes		/OPT/A_DESKIP_STACK	Allow NULL?
51	BLOCK_PA	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
52	PAS_ACTIVE	Activate PAS for whole process flow	char	1	0	CHAR	(N' ')	Yes		/OPT/A_DEAUT_PA	Allow NULL?
53	ALTERNATIVE	Cost handling alternative	nvarchar	2	0	CHAR	(N' ')	Yes		/OPT/ALTERNATIVE	Allow NULL?
54	DISTR_TYPE	Distribution Type for Unplanned Costs	char	1	0	CHAR	(N' ')	Yes		/OPT/COST_DISTRIB	Allow NULL?
55	EASYMATCH	Add. Cost Easymatch Flag	char	1	0	CHAR	(N' ')	Yes		/OPT/COST_EASYMATCH	Allow NULL?
56	SCAN_DATE	System Date	nvarchar	8	0	DATS	(N'00000000')	Yes		SYDATUM	Allow NULL?
57	SCAN_TIME	System Time	nvarchar	6	0	TIMS	(N'000000')	Yes		SYUZEIT	Allow NULL?
58	SCAN_LOC	Scan Location	nvarchar	25	0	CHAR	(N' ')	Yes	*	/OPT/VIM_BL_SLOC	Allow NULL?
59	BATCHNUMBER	Batch Number	nvarchar	40	0	CHAR	(N' ')	Yes		/OPT/VIM_BL_BN	Allow NULL?
60	CREDIT_MEMO	Credit Memo Indicator	char	1	0	CHAR	(N' ')	Yes		/OPT/VIM_BL_CM	Allow NULL?
61	VORGANG	List field: transaction/event	char	1	0	CHAR	(N' ')	Yes		MRM_VORGANG	Allow NULL?
62	CLASSIFIER	Classifier for VIM document types	nvarchar	2	0	CHAR	(N' ')	Yes		/OPT/VIM_CLASSIFIER_DE	Allow NULL?
63	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_D	Allow NULL?
64	WMWST	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		WMWST
65	BEZNK	Unplanned delivery costs	decimal	13	2	CURR	((0))	Yes		BEZNK
66	REMIT_STREET	Street	nvarchar	60	0	CHAR	(N' ')	Yes		AD_STREET	Allow NULL?
67	REMIT_HSNM1	House Number	nvarchar	10	0	CHAR	(N' ')	Yes		AD_HSNM1	Allow NULL?
68	REMIT_PSTLZ	City postal code	nvarchar	10	0	CHAR	(N' ')	Yes		AD_PSTCD1	Allow NULL?
69	REMIT_LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
70	REMIT_AD_CITY1	City	nvarchar	40	0	CHAR	(N' ')	Yes		AD_CITY1	Allow NULL?
71	REMIT_REGIO	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
72	REMIT_PO_BOX	PO Box	nvarchar	10	0	CHAR	(N' ')	Yes		AD_POBX	Allow NULL?
73	REMIT_PSTL2	P.O. Box Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTL2	Allow NULL?
74	SHIPTO_STREET	Street	nvarchar	60	0	CHAR	(N' ')	Yes		AD_STREET	Allow NULL?
75	SHIPTO_HSNM1	House Number	nvarchar	10	0	CHAR	(N' ')	Yes		AD_HSNM1	Allow NULL?
76	SHIPTO_PSTLZ	City postal code	nvarchar	10	0	CHAR	(N' ')	Yes		AD_PSTCD1	Allow NULL?
77	SHIPTO_LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
78	SHIPTO_AD_CITY1	City	nvarchar	40	0	CHAR	(N' ')	Yes		AD_CITY1	Allow NULL?
79	SHIPTO_REGIO	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
80	SHIPTO_PO_BOX	PO Box	nvarchar	10	0	CHAR	(N' ')	Yes		AD_POBX	Allow NULL?
81	BKTXT	Document Header Text	nvarchar	25	0	CHAR	(N' ')	Yes		BKTXT	Allow NULL?
82	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
83	PRORITY_FLAG	Document Priority	char	1	0	CHAR	(N' ')	Yes	*	/OPT/DOC_PRIORITY	Allow NULL?
84	NET_AMOUNT	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
85	GROSS_AMOUNT	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
86	F_TAX_AMOUNT	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
87	S_TAX_AMOUNT	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
88	VAT_AMOUNT	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
89	TOT_TAX_AMOUNT	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
90	FREIGHT_AMOUNT	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
91	HANDLING_CHARGES	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
92	UN_ALLOCATED_EXP	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
93	EXPENSE_TYPE	Invoice Approval Expense Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	/ORS/EXPENSE	Allow NULL?
94	ATTRIBUTE1	Character Field Length = 10	nvarchar	10	0	CHAR	(N' ')	Yes		CHAR10	Allow NULL?
95	ATTRIBUTE2	Character Field Length = 10	nvarchar	10	0	CHAR	(N' ')	Yes		CHAR10	Allow NULL?
96	ATTRIBUTE3	Char 20	nvarchar	20	0	CHAR	(N' ')	Yes		CHAR20	Allow NULL?
97	ATTRIBUTE4	Char 20	nvarchar	20	0	CHAR	(N' ')	Yes		CHAR20	Allow NULL?
98	TAX_CODE	Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	*	/OPT/VIM_TAX_CODE	Allow NULL?
99	AUTO_CALC	Calculate Tax Automatically	char	1	0	CHAR	(N' ')	Yes		/OPT/VIM_AUTO_CALC	Allow NULL?
100	TAX_CODE_WH	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	*	QSSKZ	Allow NULL?
101	SUPPLY_DATE	Date of Supply	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/VIM_SUP_DAT	Allow NULL?
102	VENDOR_VAT_NO	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
103	VENDOR_TAX_NO	Tax number at responsible tax office	nvarchar	18	0	CHAR	(N' ')	Yes		/OPT/VIM_VEND_TAX_NO	Allow NULL?
104	RECEPIENT_VAT_NO	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
105	FISCAL_REP_VAT_N	Fiscal Representative VAT Number	nvarchar	18	0	CHAR	(N' ')	Yes		/OPT/VIM_FIS_REP_VAT	Allow NULL?
106	PYMNT_TERMS	Terms of Payment Key	nvarchar	4	0	CHAR	(N' ')	Yes		DZTERM	Allow NULL?
107	PYMNT_TERMS_TEXT	Payment Terms text	nvarchar	40	0	CHAR	(N' ')	Yes		/OPT/PAY_TERM_TEXT	Allow NULL?
108	ISR	POR subscriber number	nvarchar	90	0	CHAR	(N' ')	Yes		/OPT/VIM_ESRNR	Allow NULL?
109	CM_REF_NO	Reference document number	nvarchar	16	0	CHAR	(N' ')	Yes		/OPT/VIM_REFNO	Allow NULL?
110	CM_REF_DAT	Credit Memo Ref Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/VIM_DAT	Allow NULL?
111	TAX_RATE	Data element for Tax rate	decimal	12	3	DEC	((0))	Yes		/OPT/VIM_TAX_RATE
112	SIRET_NO	Siret Number	nvarchar	14	0	CHAR	(N' ')	Yes		/OPT/VIM_SIRET_NO	Allow NULL?
113	ZERO_TAX_RATE	Character Field Length = 10	nvarchar	10	0	CHAR	(N' ')	Yes		CHAR10	Allow NULL?
114	DOC_ARC_DOC_ID	SAP ArchiveLink: Document ID	nvarchar	40	0	CHAR	(N' ')	Yes		SAEARDOID	Allow NULL?
115	TRNG_LEARN	Flag: Training/Learning required	char	1	0	CHAR	(N' ')	Yes		/OPT/TRNG_LEARN	Allow NULL?
116	FEEDB_LEARN	Flag: Feedback Learning	char	1	0	CHAR	(N' ')	Yes		/OPT/FEEDB_LEARN	Allow NULL?
117	CHANNEL_ID	Channel ID	nvarchar	10	0	CHAR	(N' ')	Yes	*	/OPT/CHANNEL_ID	Allow NULL?
118	CUSTOM_FIELD4	Character Field Length 1	char	1	0	CHAR	(N' ')	Yes		CHAR01	Allow NULL?
119	CUSTOM_FIELD5	Text Field of Length 60	nvarchar	60	0	CHAR	(N' ')	Yes		TEXT60	Allow NULL?
120	CUSTOM_FIELD6	Text (10 Characters)	nvarchar	10	0	CHAR	(N' ')	Yes		TEXT10	Allow NULL?
121	CUSTOM_FIELD7	Character Field Length 1	char	1	0	CHAR	(N' ')	Yes		CHAR01	Allow NULL?
122	CUSTOM_FIELD8	Text (10 Characters)	nvarchar	10	0	CHAR	(N' ')	Yes		TEXT10	Allow NULL?
123	CUSTOM_FIELD9	Text (20 Characters)	nvarchar	20	0	CHAR	(N' ')	Yes		TEXT20	Allow NULL?
124	CUSTOM_FIELD0	Text (20 Characters)	nvarchar	20	0	CHAR	(N' ')	Yes		TEXT20	Allow NULL?
125	PAYMENT_METHOD	Payment Method	char	1	0	CHAR	(N' ')	Yes	*	DZLSCH	Allow NULL?
126	PAY_METHOD_TEXT	Name of Payment Method in Language of the Country	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT1_042Z	Allow NULL?
127	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
128	INV_CAT	Invoice category	char	1	0	CHAR	(N' ')	Yes	*	/OPT/INVOICE_CATEGORY	Allow NULL?
129	TAX_EXEMPT_TEXT	Tax Exempt Text	nvarchar	50	0	CHAR	(N' ')	Yes		/OPT/TAX_E_TEXT	Allow NULL?
130	IMPORT_TEXT	Import Special Text	nvarchar	50	0	CHAR	(N' ')	Yes		/OPT/IMPORT_TEXT	Allow NULL?
131	TRI_TEXT	Triangulation Text	nvarchar	50	0	CHAR	(N' ')	Yes		/OPT/TRI_TEXT	Allow NULL?
132	ORG_NUMBER	Organization Number	nvarchar	20	0	CHAR	(N' ')	Yes		/OPT/ORG_NUMBER	Allow NULL?
133	DISCOUNT	Discount mentioned on the Invocie	decimal	11	2	CURR	((0))	Yes		/OPT/VIM_DISCOUNT
134	TAXRATE_1	Data element for Tax rate	decimal	12	3	DEC	((0))	Yes		/OPT/VIM_TAX_RATE
135	TAXRATE_2	Data element for Tax rate	decimal	12	3	DEC	((0))	Yes		/OPT/VIM_TAX_RATE
136	TAXRATE_3	Data element for Tax rate	decimal	12	3	DEC	((0))	Yes		/OPT/VIM_TAX_RATE
137	TAXRATE_4	Data element for Tax rate	decimal	12	3	DEC	((0))	Yes		/OPT/VIM_TAX_RATE
138	TAXAMT_1	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
139	TAXAMT_2	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
140	TAXAMT_3	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
141	TAXAMT_4	Amount	decimal	13	2	CURR	((0))	Yes		/OPT/RMWWR
142	SCB_IND	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	T015L	LZBKZ	Allow NULL?
143	TAX_INVOICE	Tax Invoice	char	1	0	CHAR	(N' ')	Yes		/OPT/VIM_TAX_INVOICE	Allow NULL?
144	POST_DATE_DET	Date to be used as Posting Date while creating the SAP Doc	char	1	0	CHAR	(N' ')	Yes		/OPT/VIM_POST_DT_DETERMINE	Allow NULL?
145	ZFBDT_DET	Baseline Date Determination Method	char	1	0	CHAR	(N' ')	Yes		/OPT/VIM_ZFBDT_DET_DE	Allow NULL?
146	NF_TYPE	Nota Fiscal Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1BNFTYPE	Allow NULL?
147	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUPLA	Allow NULL?
148	TAX_LAWS	Tax Laws - Brazil	nvarchar	20	0	CHAR	(N' ')	Yes		/OPT/VIM_TAX_LAWS	Allow NULL?
149	SUPCOUNTRY	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL	Allow NULL?
150	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
151	IBAN	IBAN (International Bank Account Number)	nvarchar	34	0	CHAR	(N' ')	Yes		IBAN	Allow NULL?
152	BANKL	Bank number	nvarchar	15	0	CHAR	(N' ')	Yes		BANKL	Allow NULL?
153	BANKA	Name of bank	nvarchar	60	0	CHAR	(N' ')	Yes		BANKA	Allow NULL?
154	BANKN	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
155	BKREF	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
156	BANKS	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
157	BKONT	Bank Control Key	nvarchar	2	0	CHAR	(N' ')	Yes		BKONT	Allow NULL?
158	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
159	RESTART	X: Restart	char	1	0	CHAR	(N' ')	Yes		RESTART	Allow NULL?
160	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	LAND1	Allow NULL?
161	BARCODE	Bar code	nvarchar	64	0	CHAR	(N' ')	Yes		BARCODE	Allow NULL?
162	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
163	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	Yes		DZBD1T
164	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	Yes		DZBD1P
165	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	Yes		DZBD2T
166	ZBD2P	Cash Discount Percentage 2	decimal	5	3	DEC	((0))	Yes		DZBD2P
167	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	Yes		DZBD3T
168	SWIFT	SWIFT/BIC for International Payments	nvarchar	11	0	CHAR	(N' ')	Yes		SWIFT	Allow NULL?
169	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	*	HBKID	Allow NULL?
170	HKTID	ID for account details	nvarchar	5	0	CHAR	(N' ')	Yes	*	HKTID	Allow NULL?
171	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
172	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	CHAR	(N' ')	Yes	*	DTAWS	Allow NULL?
173	DTAMS	Indicator for Data Medium Exchange	char	1	0	CHAR	(N' ')	Yes		DTAMS	Allow NULL?
174	FITYP	Tax type	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1AFITP_D	Allow NULL?
175	STCDT	Tax Number Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1ATOID	Allow NULL?
176	STKZN	Natural Person	char	1	0	CHAR	(N' ')	Yes		STKZN	Allow NULL?
177	STKZU	Liable for VAT	char	1	0	CHAR	(N' ')	Yes		STKZU	Allow NULL?
178	STKZA	Indicator: Business Partner Subject to Equalization Tax?	char	1	0	CHAR	(N' ')	Yes		STKZA	Allow NULL?
179	EMPFB	Vendor Permitted as Payee	nvarchar	10	0	CHAR	(N' ')	Yes	*	EMPFK	Allow NULL?
180	WHT_TYPE	Withholding Tax Processing Type	char	1	0	CHAR	(N' ')	Yes		/OPT/D_WHTAX_TYPE_DE	Allow NULL?
181	ENRICH_FLAG	Flag indicating data enrichment	char	1	0	CHAR	(N' ')	Yes		/OPT/VIM_FLAG_ENRICH_DE	Allow NULL?
182	DUE_DATE	Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/VIM_DUEDATE	Allow NULL?
183	DUE_DATE1	Due Date for Cash Discount 1	nvarchar	8	0	DATS	(N'00000000')	Yes		SK1DT	Allow NULL?
184	DUE_DATE2	Due Date for Cash Discount 2	nvarchar	8	0	DATS	(N'00000000')	Yes		SK2DT	Allow NULL?
185	VAT_INV_IDENT	VAT Invoice Identifier	nvarchar	10	0	CHAR	(N' ')	Yes		/OPT/VIM_VAT_INV_IDENTIFIER	Allow NULL?
186	SECRET_CODE1	Secret Code	nvarchar	27	0	CHAR	(N' ')	Yes		/OPT/VIM_SECRET_CODE	Allow NULL?
187	SECRET_CODE2	Secret Code	nvarchar	27	0	CHAR	(N' ')	Yes		/OPT/VIM_SECRET_CODE	Allow NULL?
188	SECRET_CODE3	Secret Code	nvarchar	27	0	CHAR	(N' ')	Yes		/OPT/VIM_SECRET_CODE	Allow NULL?
189	SECRET_CODE4	Secret Code	nvarchar	27	0	CHAR	(N' ')	Yes		/OPT/VIM_SECRET_CODE	Allow NULL?
190	INVOICE_CODE	Invoice Code	nvarchar	12	0	CHAR	(N' ')	Yes		/OPT/VIM_INVOICE_CODE	Allow NULL?
191	VALIDATION_CODE	Validation Code	nvarchar	30	0	CHAR	(N' ')	Yes		/OPT/VIM_VALIDATION_CODE	Allow NULL?
192	NOT_HAND_WRITTEN	Not a Hand Written Invoice	char	1	0	CHAR	(N' ')	Yes		/OPT/VIM_NO_HAND_WRITTEN	Allow NULL?
193	AFTCS_VALIDATION	AFTCS Validation Indicator	char	1	0	CHAR	(N' ')	Yes		/OPT/VIM_AFTCS_VALIDATION	Allow NULL?
194	USER_ID	User id that set the AFTCS Validation Indicator	nvarchar	12	0	CHAR	(N' ')	Yes		/OPT/VIM_USER_ID	Allow NULL?
195	TIME_STAMP	AFTCS Validation TimeStamp	decimal	15	0	DEC	((0))	Yes		/OPT/VIM_TIME_STAMP
196	TAX_DESC	Tax Description	char	1	0	CHAR	(N' ')	Yes		/OPT/VIM_TAXDESC	Allow NULL?
197	PAN_NO	Permanent Account Number	nvarchar	40	0	CHAR	(N' ')	Yes		/OPT/VIM_PAN	Allow NULL?
198	STC_NO	STC Number	nvarchar	30	0	CHAR	(N' ')	Yes		/OPT/VIM_STN	Allow NULL?
199	TIN_TOT	TIN/TOT Number	nvarchar	11	0	CHAR	(N' ')	Yes		/OPT/VIM_TIN	Allow NULL?
200	LST_NO	LST Number	nvarchar	40	0	CHAR	(N' ')	Yes		/OPT/VIM_LST	Allow NULL?
201	CST_NO	CST Number	nvarchar	40	0	CHAR	(N' ')	Yes		/OPT/VIM_CST	Allow NULL?
202	ECC_NO	ECC Number	nvarchar	40	0	CHAR	(N' ')	Yes		/OPT/VIM_ECC	Allow NULL?
203	EDC_CESS	Educational Cess	decimal	13	2	CURR	((0))	Yes		/OPT/VIM_EDU
204	EXC_DUTY	Excise Duty	decimal	13	2	CURR	((0))	Yes		/OPT/VIM_EXC_DUTY
205	SAHE_CESS	Secondary & Higher Educational Cess	decimal	13	2	CURR	((0))	Yes		/OPT/VIM_SAHE
206	MODEL	Model of Nota Fiscal	nvarchar	2	0	NUMC	(N'00')	Yes		J_1BMODEL	Allow NULL?
207	SERIES	Series	nvarchar	3	0	CHAR	(N' ')	Yes		J_1BSERIES	Allow NULL?
208	NFNUM	Nota Fiscal Number	nvarchar	6	0	NUMC	(N'000000')	Yes		J_1BNFNUMB	Allow NULL?
209	CGC	CNPJ Number	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		J_1BCGC	Allow NULL?
210	XMLVERS	NF-e: XML Version	decimal	4	2	DEC	((0))	Yes		/OPT/CIDH_1BNFEXMLVERSION_DE
211	AUTHCOD	NF-e: Protocol Number	nvarchar	15	0	CHAR	(N' ')	Yes		/OPT/CIDH_1BNFEAUTHCODE_DE	Allow NULL?
212	DOCNUM9	NF-e: Random Number	nvarchar	9	0	CHAR	(N' ')	Yes		/OPT/CIDH_1BDOCNUM9_DE	Allow NULL?
213	ACCESSKEY	NF-e: 44-Digit Access Key	nvarchar	44	0	CHAR	(N' ')	Yes		/OPT/CIDH_1B_NFE_ACCESS_KEY_DE	Allow NULL?
214	NFNUM9	Nine-Digit NF-e Number	nvarchar	9	0	CHAR	(N' ')	Yes		/OPT/CIDH_1BNFNUM9_DE	Allow NULL?
215	CDV	Check Digit for NF-e Access Key	char	1	0	CHAR	(N' ')	Yes		/OPT/CIDH_1BCHECKDIGIT_DE	Allow NULL?
216	TRANSPAYMENT	Payment flag	char	1	0	CHAR	(N' ')	Yes		ROIURV_PAY_FL	Allow NULL?
217	NFTOT	Total value including all taxes	decimal	15	2	CURR	((0))	Yes		J_1BNFTOT
218	REFNFENUM	Nine-Digit NF-e Number	nvarchar	9	0	CHAR	(N' ')	Yes		/OPT/CIDH_1BNFNUM9_DE	Allow NULL?
219	ACTION_DATE	NF-e Processing Timestamp - Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/CIDH_1BAUTHDATE_DE	Allow NULL?
220	ACTION_TIME	NF-e Processing Timestamp - Time	nvarchar	6	0	TIMS	(N'000000')	Yes		/OPT/CIDH_1BAUTHTIME_DE	Allow NULL?
221	DOCDAT	Document date	nvarchar	8	0	DATS	(N'00000000')	Yes		J_1BDOCDAT	Allow NULL?
222	PARID	Partner ID (Customer, Vendor, Business Place)	nvarchar	10	0	CHAR	(N' ')	Yes		J_1BPARID	Allow NULL?
223	STCD1	CNPJ Number	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		J_1BCGC	Allow NULL?
224	FLAG_ENFE	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
225	FLAG_SNFE	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
226	FLAG_SIG_VALID	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
227	ORG_NUM	Invoice Number of original invoice	nvarchar	16	0	CHAR	(N' ')	Yes		/OPT/VIM_ORGNUM	Allow NULL?
228	ORG_DATE	Date of original invoice	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/VIM_ORGDAT	Allow NULL?
229	REV_NUM	Revision number of invoice	nvarchar	16	0	CHAR	(N' ')	Yes		/OPT/VIM_REVNUM	Allow NULL?
230	REV_DATE	Date of revision invoice	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/VIM_REVDAT	Allow NULL?
231	REV_NUM_COR	Revision number of corrective invoice	nvarchar	16	0	CHAR	(N' ')	Yes		/OPT/VIM_REVNUM_COR	Allow NULL?
232	REV_DATE_COR	Revision date of corrective invoice	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/VIM_REVDAT_COR	Allow NULL?
233	BSTYP	Purchasing Document Category	char	1	0	CHAR	(N' ')	Yes		EBSTYP	Allow NULL?
234	CONTRACT	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	EBELN	Allow NULL?
235	RETRY_NO1	Extraction Retry	int	10	0	INT4	((0))	Yes		/OPT/EXTR_RETRY	Allow NULL?
236	RETRY_NO2	Validation Retry	int	10	0	INT4	((0))	Yes		/OPT/VALIDATION_RETRY	Allow NULL?
237	RFC_DUP	Duplicate Check Run Pending	char	1	0	CHAR	(N' ')	Yes		/OPT/DP_CHECKDUPS	Allow NULL?
238	RETRY_COUNT_EXT	Number of retries for external workflow	nvarchar	4	0	NUMC	(N'0000')	Yes		/OPT/VIM_RETRY_COUNTER	Allow NULL?
239	ORIG_AR_OBJECT	Original Archive Document Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	/OPT/ORIG_SAEOBJART_DE	Allow NULL?
240	SCAN_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0	DEC	((0))	Yes		TIMESTAMP
241	DOC_ARCHIV_ID	Content Repository Identification	nvarchar	2	0	CHAR	(N' ')	Yes	*	/OPT/SAEARCHIVI	Allow NULL?
242	SKIP_DETERMINE	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
243	REG_ID	Registration Number for incoming document handler	nvarchar	12	0	NUMC	(N'000000000000')	Yes		/OPT/CIDH_REGID_DE	Allow NULL?
244	OTYPE	Object Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
245	ACTORID	Agent ID in Organizational Management	nvarchar	12	0	CHAR	(N' ')	Yes		ACTORID	Allow NULL?
246	RTV_REASON	Return to Vendor - reasons	nvarchar	2	0	CHAR	(N' ')	Yes	*	/OPT/VIM_RTV_REASON_DE	Allow NULL?
247	VATDATE	VAT Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/OPT/VIM_VATDATE_DE	Allow NULL?
248	MWSKZ_BNK	Tax code for delivery costs	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ_BNK	Allow NULL?
249	TXJCD_BNK	Jurisdiction code for delivery costs	nvarchar	15	0	CHAR	(N' ')	Yes	*	TXJCD_BNK	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