Tabel SAP B1 - OITM - Items

Oleh jurnal firman

List \ OITM

Berikut ini adalah kolom yang terdapat pada tabel OITM di SAP B1

Update: 2026-07-23

No Nama Kolom Tipe Data Keterangan Referensi
1. ItemCode NVarchar (50)
2. ItemName NVarchar (200)
3. FrgnName NVarchar (200)
4. ItmsGrpCod Smallint
5. CstGrpCode Smallint
6. VatGourpSa NVarchar (8)
7. CodeBars NVarchar (254)
8. VATLiable NVarchar (1)
9. PrchseItem NVarchar (1)
10. SellItem NVarchar (1)
11. InvntItem NVarchar (1)
12. OnHand Decimal (21, 6)
13. IsCommited Decimal (21, 6)
14. OnOrder Decimal (21, 6)
15. IncomeAcct NVarchar (15)
16. ExmptIncom NVarchar (15)
17. MaxLevel Decimal (21, 6)
18. DfltWH NVarchar (8)
19. CardCode NVarchar (15)
20. SuppCatNum NVarchar (50)
21. BuyUnitMsr NVarchar (100)
22. NumInBuy Decimal (21, 6)
23. ReorderQty Decimal (21, 6)
24. MinLevel Decimal (21, 6)
25. LstEvlPric Decimal (21, 6)
26. LstEvlDate Time Stamp
27. CustomPer Decimal (21, 6)
28. Canceled NVarchar (1)
29. MnufctTime Integer
30. WholSlsTax NVarchar (1)
31. RetilrTax NVarchar (1)
32. SpcialDisc Decimal (21, 6)
33. DscountCod Smallint
34. TrackSales NVarchar (1)
35. SalUnitMsr NVarchar (100)
36. NumInSale Decimal (21, 6)
37. Consig Decimal (21, 6)
38. QueryGroup Integer
39. Counted Decimal (21, 6)
40. OpenBlnc Decimal (21, 6)
41. EvalSystem NVarchar (1)
42. UserSign Smallint
43. FREE NVarchar (1)
44. PicturName NVarchar (200)
45. Transfered NVarchar (1)
46. BlncTrnsfr NVarchar (1)
47. UserText NClob
48. SerialNum NVarchar (17)
49. CommisPcnt Decimal (21, 6)
50. CommisSum Decimal (21, 6)
51. CommisGrp Smallint
52. TreeType NVarchar (1)
53. TreeQty Decimal (21, 6)
54. LastPurPrc Decimal (21, 6)
55. LastPurCur NVarchar (3)
56. LastPurDat Time Stamp
57. ExitCur NVarchar (3)
58. ExitPrice Decimal (21, 6)
59. ExitWH NVarchar (8)
60. AssetItem NVarchar (1)
61. WasCounted NVarchar (1)
62. ManSerNum NVarchar (1)
63. SHeight1 Decimal (21, 6)
64. SHght1Unit Smallint
65. SHeight2 Decimal (21, 6)
66. SHght2Unit Smallint
67. SWidth1 Decimal (21, 6)
68. SWdth1Unit Smallint
69. SWidth2 Decimal (21, 6)
70. SWdth2Unit Smallint
71. SLength1 Decimal (21, 6)
72. SLen1Unit Smallint
73. Slength2 Decimal (21, 6)
74. SLen2Unit Smallint
75. SVolume Decimal (21, 6)
76. SVolUnit Smallint
77. SWeight1 Decimal (21, 6)
78. SWght1Unit Smallint
79. SWeight2 Decimal (21, 6)
80. SWght2Unit Smallint
81. BHeight1 Decimal (21, 6)
82. BHght1Unit Smallint
83. BHeight2 Decimal (21, 6)
84. BHght2Unit Smallint
85. BWidth1 Decimal (21, 6)
86. BWdth1Unit Smallint
87. BWidth2 Decimal (21, 6)
88. BWdth2Unit Smallint
89. BLength1 Decimal (21, 6)
90. BLen1Unit Smallint
91. Blength2 Decimal (21, 6)
92. BLen2Unit Smallint
93. BVolume Decimal (21, 6)
94. BVolUnit Smallint
95. BWeight1 Decimal (21, 6)
96. BWght1Unit Smallint
97. BWeight2 Decimal (21, 6)
98. BWght2Unit Smallint
99. FixCurrCms NVarchar (3)
100. FirmCode Smallint
101. LstSalDate Time Stamp
102. QryGroup1 NVarchar (1)
103. QryGroup2 NVarchar (1)
104. QryGroup3 NVarchar (1)
105. QryGroup4 NVarchar (1)
106. QryGroup5 NVarchar (1)
107. QryGroup6 NVarchar (1)
108. QryGroup7 NVarchar (1)
109. QryGroup8 NVarchar (1)
110. QryGroup9 NVarchar (1)
111. QryGroup10 NVarchar (1)
112. QryGroup11 NVarchar (1)
113. QryGroup12 NVarchar (1)
114. QryGroup13 NVarchar (1)
115. QryGroup14 NVarchar (1)
116. QryGroup15 NVarchar (1)
117. QryGroup16 NVarchar (1)
118. QryGroup17 NVarchar (1)
119. QryGroup18 NVarchar (1)
120. QryGroup19 NVarchar (1)
121. QryGroup20 NVarchar (1)
122. QryGroup21 NVarchar (1)
123. QryGroup22 NVarchar (1)
124. QryGroup23 NVarchar (1)
125. QryGroup24 NVarchar (1)
126. QryGroup25 NVarchar (1)
127. QryGroup26 NVarchar (1)
128. QryGroup27 NVarchar (1)
129. QryGroup28 NVarchar (1)
130. QryGroup29 NVarchar (1)
131. QryGroup30 NVarchar (1)
132. QryGroup31 NVarchar (1)
133. QryGroup32 NVarchar (1)
134. QryGroup33 NVarchar (1)
135. QryGroup34 NVarchar (1)
136. QryGroup35 NVarchar (1)
137. QryGroup36 NVarchar (1)
138. QryGroup37 NVarchar (1)
139. QryGroup38 NVarchar (1)
140. QryGroup39 NVarchar (1)
141. QryGroup40 NVarchar (1)
142. QryGroup41 NVarchar (1)
143. QryGroup42 NVarchar (1)
144. QryGroup43 NVarchar (1)
145. QryGroup44 NVarchar (1)
146. QryGroup45 NVarchar (1)
147. QryGroup46 NVarchar (1)
148. QryGroup47 NVarchar (1)
149. QryGroup48 NVarchar (1)
150. QryGroup49 NVarchar (1)
151. QryGroup50 NVarchar (1)
152. QryGroup51 NVarchar (1)
153. QryGroup52 NVarchar (1)
154. QryGroup53 NVarchar (1)
155. QryGroup54 NVarchar (1)
156. QryGroup55 NVarchar (1)
157. QryGroup56 NVarchar (1)
158. QryGroup57 NVarchar (1)
159. QryGroup58 NVarchar (1)
160. QryGroup59 NVarchar (1)
161. QryGroup60 NVarchar (1)
162. QryGroup61 NVarchar (1)
163. QryGroup62 NVarchar (1)
164. QryGroup63 NVarchar (1)
165. QryGroup64 NVarchar (1)
166. CreateDate Time Stamp
167. UpdateDate Time Stamp
168. ExportCode NVarchar (20)
169. SalFactor1 Decimal (21, 6)
170. SalFactor2 Decimal (21, 6)
171. SalFactor3 Decimal (21, 6)
172. SalFactor4 Decimal (21, 6)
173. PurFactor1 Decimal (21, 6)
174. PurFactor2 Decimal (21, 6)
175. PurFactor3 Decimal (21, 6)
176. PurFactor4 Decimal (21, 6)
177. SalFormula NVarchar (40)
178. PurFormula NVarchar (40)
179. VatGroupPu NVarchar (8)
180. AvgPrice Decimal (21, 6)
181. PurPackMsr NVarchar (30)
182. PurPackUn Decimal (21, 6)
183. SalPackMsr NVarchar (30)
184. SalPackUn Decimal (21, 6)
185. SCNCounter Smallint
186. ManBtchNum NVarchar (1)
187. ManOutOnly NVarchar (1)
188. DataSource NVarchar (1)
189. validFor NVarchar (1)
190. validFrom Time Stamp
191. validTo Time Stamp
192. frozenFor NVarchar (1)
193. frozenFrom Time Stamp
194. frozenTo Time Stamp
195. BlockOut NVarchar (1)
196. ValidComm NVarchar (30)
197. FrozenComm NVarchar (30)
198. LogInstanc Integer
199. ObjType NVarchar (20)
200. SWW NVarchar (16)
201. Deleted NVarchar (1)
202. DocEntry Integer
203. ExpensAcct NVarchar (15)
204. FrgnInAcct NVarchar (15)
205. ShipType Smallint
206. GLMethod NVarchar (1)
207. ECInAcct NVarchar (15)
208. FrgnExpAcc NVarchar (15)
209. ECExpAcc NVarchar (15)
210. TaxType NVarchar (1)
211. ByWh NVarchar (1)
212. WTLiable NVarchar (1)
213. ItemType NVarchar (1)
214. WarrntTmpl NVarchar (20)
215. BaseUnit NVarchar (20)
216. CountryOrg NVarchar (3)
217. StockValue Decimal (21, 6)
218. Phantom NVarchar (1)
219. IssueMthd NVarchar (1)
220. FREE1 NVarchar (1)
221. PricingPrc Decimal (21, 6)
222. MngMethod NVarchar (1)
223. ReorderPnt Decimal (21, 6)
224. InvntryUom NVarchar (100)
225. PlaningSys NVarchar (1)
226. PrcrmntMtd NVarchar (1)
227. OrdrIntrvl Smallint
228. OrdrMulti Decimal (21, 6)
229. MinOrdrQty Decimal (21, 6)
230. LeadTime Integer
231. IndirctTax NVarchar (1)
232. TaxCodeAR NVarchar (8)
233. TaxCodeAP NVarchar (8)
234. OSvcCode Integer
235. ISvcCode Integer
236. ServiceGrp Integer
237. NCMCode Integer
238. MatType NVarchar (3)
239. MatGrp Integer
240. ProductSrc NVarchar (2)
241. ServiceCtg Integer
242. ItemClass NVarchar (1)
243. Excisable NVarchar (1)
244. ChapterID Integer
245. NotifyASN NVarchar (40)
246. ProAssNum NVarchar (20)
247. AssblValue Decimal (21, 6)
248. DNFEntry Integer
249. UserSign2 Smallint
250. Spec NVarchar (30)
251. TaxCtg NVarchar (4)
252. Series Integer
253. Number Integer
254. FuelCode Integer
255. BeverTblC NVarchar (2)
256. BeverGrpC NVarchar (2)
257. BeverTM Integer
258. Attachment NClob
259. AtcEntry Integer
260. ToleranDay Integer
261. UgpEntry Integer
262. PUoMEntry Integer
263. SUoMEntry Integer
264. IUoMEntry Integer
265. IssuePriBy Smallint
266. AssetClass NVarchar (20)
267. AssetGroup NVarchar (15)
268. InventryNo NVarchar (12)
269. Technician Integer
270. Employee Integer
271. Location Integer
272. StatAsset NVarchar (1)
273. Cession NVarchar (1)
274. DeacAftUL NVarchar (1)
275. AsstStatus NVarchar (1)
276. CapDate Time Stamp
277. AcqDate Time Stamp
278. RetDate Time Stamp
279. GLPickMeth NVarchar (1)
280. NoDiscount NVarchar (1)
281. MgrByQty NVarchar (1)
282. AssetRmk1 NVarchar (100)
283. AssetRmk2 NVarchar (100)
284. AssetAmnt1 Decimal (21, 6)
285. AssetAmnt2 Decimal (21, 6)
286. DeprGroup NVarchar (15)
287. AssetSerNo NVarchar (32)
288. CntUnitMsr NVarchar (100)
289. NumInCnt Decimal (21, 6)
290. INUoMEntry Integer
291. OneBOneRec NVarchar (1)
292. RuleCode NVarchar (2)
293. ScsCode NVarchar (10)
294. SpProdType NVarchar (2)
295. IWeight1 Decimal (21, 6)
296. IWght1Unit Smallint
297. IWeight2 Decimal (21, 6)
298. IWght2Unit Smallint
299. CompoWH NVarchar (1)
300. CreateTS Integer
301. UpdateTS Integer
302. VirtAstItm NVarchar (1)
303. SouVirAsst NVarchar (50)
304. InCostRoll NVarchar (1)
305. PrdStdCst Decimal (21, 6)
306. EnAstSeri NVarchar (1)
307. LinkRsc NVarchar (50)
308. OnHldPert Decimal (21, 6)
309. onHldLimt Decimal (21, 6)
310. PriceUnit Integer
311. GSTRelevnt NVarchar (1)
312. SACEntry Integer
313. GstTaxCtg NVarchar (1)
314. AssVal4WTR Decimal (21, 6)
315. ExcImpQUoM Integer
316. ExcFixAmnt Decimal (21, 6)
317. ExcRate Decimal (21, 6)
318. SOIExc NVarchar (1)
319. TNVED NVarchar (10)
320. Imported NVarchar (1)
321. AutoBatch NVarchar (1)
322. CstmActing NVarchar (1)
323. StdItemId Integer
324. CommClass Integer
325. TaxCatCode NVarchar (50)
326. DataVers Integer
327. NVECode NVarchar (6)
328. CESTCode Integer
329. CtrSealQty Decimal (21, 6)
330. LegalText NVarchar (250)
331. QRCodeSrc NClob
332. Traceable NVarchar (1)

Postingan populer dari blog ini

SMS Penipuan PT Centrall Cell

Oleh jurnal firman
Sebelum anda melanjutkan membaca artikel ini, hentikan segala aktifitas transfer yang akan anda lakukan setelah menerima SMS adanya penawaran agen pulsa dengan harga 4500, 8500 dan sejenisnya. Saya semalam mendapatkan SMS yang mengatasnamakan PT. CENTRAL CELL, dimana isi SMSnya adalah berupa penawaran agen pulsa elektrik dengan harga yang boleh dibilang, terlalu miring. Berikut ini detail SMS yang dikirim menggunakan Nomer 081998377179. "KAMI DARI PT.CENTRAL CELL Cari agen M.KIOS all operator V.5=4500 V.10=8500 V.20=18500 CARA PENDAFTARAN ketik: DAFTAR.NAMA.KOTA.NO HP# Kirim ke: 085341122822" Meski saya gak mudah percaya, tapi jujur saja, iklan tersebut cukup menarik minat saya. Apalagi saya juga pengusaha server pulsa elektrik , yang sekali lagi jujur saja, saya pun gak dapat harga segitu.
Read more »

Apa itu "Pejwan"

Oleh jurnal firman
Sering kali kita mendapati istilah "Pertamax" dan "Pejwan" dalam forum-forum diskusi ataupun komentar-komentar di sebuah blog. Untuk Pertamax istilah itu sekarang sudah cukup umum, yang artinya adalah seorang komentator yang mendapati peringkat pertama sebagai orang yang memberikan komentar pada konten yang bersangkutan. Sedangkan Pejwan tidak lain adalah "Page One", yaitu posisi komentar kita pada halaman pertama dari suatu konten yang kita komentari. Jadi, meskipun tidak mendapatkan Pertamax, Pejwan pun gak masalah, karena masih memiliki kemungkinan besar untuk memberikan pengaruh dalam mendatangkan pengunjung ke blog kita. Terima kasih untuk yang sudah mensupport halaman ini: infosia.my.id blog jitu inisurabaya.id halaqoh.id always.my.id
Read more »