Tabel SAP B1 - OCRD - Business Partner

List \ OCRD

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

Update: 2026-07-23

No Nama Kolom Tipe Data Keterangan Referensi
1. CardCode NVarchar (15) BP Code
2. CardName NVarchar (100) BP Name
3. CardType NVarchar (1) BP Type
4. GroupCode Smallint Group Code OCRG
5. CmpPrivate NVarchar (1) Company/Private/Government
6. Address NVarchar (100) Bill-to Street
7. ZipCode NVarchar (20) Bill-to Zip Code
8. MailAddres NVarchar (100) Ship-to Street
9. MailZipCod NVarchar (20) Ship-to Zip Code
10. Phone1 NVarchar (50) Telephone 1
11. Phone2 NVarchar (50) Telephone 2
12. Fax NVarchar (50) Fax Number
13. CntctPrsn NVarchar (90) Contact Person
14. Notes NVarchar (100) Remarks
15. Balance Decimal (21, ) Account Balance
16. ChecksBal Decimal (21, ) Open Checks Balance
17. DNotesBal Decimal (21, ) Open Del. NotesGRPO Balance
18. OrdersBal Decimal (21, ) Open Orders Balance
19. GroupNum Smallint Payment Terms Code
20. CreditLine Decimal (21, ) Credit Limit
21. DebtLine Decimal (21, ) Payable Limit
22. Discount Decimal (21, ) Discount %
23. VatStatus NVarchar (1) Tax Definition
24. LicTradNum NVarchar (32) Federal Tax ID
25. DdctStatus NVarchar (1) Liable for Ded. at Source
26. DdctPrcnt Decimal (21, ) Withholding Tax Deduction %
27. ValidUntil Time Stamp Expiration Date for -% of Deduction
28. Chrctrstcs Integer Properties
29. ExMatchNum Integer Last Ext. Reconciliation No.
30. InMatchNum Integer Last Int. Reconciliation No.
31. ListNum Smallint Price List No. OPLN
32. DNoteBalFC Decimal (21, ) Open DN Balance in BP Curr.
33. OrderBalFC Decimal (21, ) Open Orders Bal. in BP Curr.
34. DNoteBalSy Decimal (21, ) Open DN Balance in SC
35. OrderBalSy Decimal (21, ) Open Orders Bal. in SC
36. Transfered NVarchar (1) Year Transfer
37. BalTrnsfrd NVarchar (1) Balances transferred
38. IntrstRate Decimal (21, ) Interest % on Liabilities
39. Commission Decimal (21, ) Commission % for Customer
40. CommGrCode Smallint
41. Free_Text NClob Free Text
42. SlpCode Integer Sales Employee Code OSLP
43. PrevYearAc NVarchar (1) Previous Year Balance
44. Currency NVarchar (3)
45. RateDifAct NVarchar (15) Rate Differences Account OACT
46. BalanceSys Decimal (21, ) Balance in Account Currency
47. BalanceFC Decimal (21, ) BP Balance in FC
48. Protected NVarchar (1) Protected BP
49. Cellular NVarchar (50) Mobile Phone
50. AvrageLate Smallint Average Payment Delay in Days
51. City NVarchar (100) Bill-to City
52. County NVarchar (100) Bill-to County
53. Country NVarchar (3) Bill-to Country
54. MailCity NVarchar (100) Ship-to City
55. MailCounty NVarchar (100) Ship-to County
56. MailCountr NVarchar (3) Ship-to Country
57. E_Mail NVarchar (100) E-Mail
58. Picture NVarchar (200) Picture
59. DflAccount NVarchar (50) Default Account
60. DflBranch NVarchar (50) Default Branch
61. BankCode NVarchar (30) Default Bank
62. AddID NVarchar (64) Additional ID No.
63. Pager NVarchar (30) Pager
64. FatherCard NVarchar (15)
65. CardFName NVarchar (100) Foreign Name
66. FatherType NVarchar (1) Parent Summary Type
67. QryGroup1 NVarchar (1) Property 1
68. QryGroup2 NVarchar (1) Property 2
69. QryGroup3 NVarchar (1) Property 3
70. QryGroup4 NVarchar (1) Property 4
71. QryGroup5 NVarchar (1) Property 5
72. QryGroup6 NVarchar (1) Property 6
73. QryGroup7 NVarchar (1) Property 7
74. QryGroup8 NVarchar (1) Property 8
75. QryGroup9 NVarchar (1) Property 9
76. QryGroup10 NVarchar (1) Property 10
77. QryGroup11 NVarchar (1) Property 11
78. QryGroup12 NVarchar (1) Property 12
79. QryGroup13 NVarchar (1) Property 13
80. QryGroup14 NVarchar (1) Property 14
81. QryGroup15 NVarchar (1) Property 15
82. QryGroup16 NVarchar (1) Property 16
83. QryGroup17 NVarchar (1) Property 17
84. QryGroup18 NVarchar (1) Property 18
85. QryGroup19 NVarchar (1) Property 19
86. QryGroup20 NVarchar (1) Property 20
87. QryGroup21 NVarchar (1) Property 21
88. QryGroup22 NVarchar (1) Property 22
89. QryGroup23 NVarchar (1) Property 23
90. QryGroup24 NVarchar (1) Property 24
91. QryGroup25 NVarchar (1) Property 25
92. QryGroup26 NVarchar (1) Property 26
93. QryGroup27 NVarchar (1) Property 27
94. QryGroup28 NVarchar (1) Property 28
95. QryGroup29 NVarchar (1) Property 29
96. QryGroup30 NVarchar (1) Property 30
97. QryGroup31 NVarchar (1) Property 31
98. QryGroup32 NVarchar (1) Property 32
99. QryGroup33 NVarchar (1) Property 33
100. QryGroup34 NVarchar (1) Property 34
101. QryGroup35 NVarchar (1) Property 35
102. QryGroup36 NVarchar (1) Property 36
103. QryGroup37 NVarchar (1) Property 37
104. QryGroup38 NVarchar (1) Property 38
105. QryGroup39 NVarchar (1) Property 39
106. QryGroup40 NVarchar (1) Property 40
107. QryGroup41 NVarchar (1) Property 41
108. QryGroup42 NVarchar (1) Property 42
109. QryGroup43 NVarchar (1) Property 43
110. QryGroup44 NVarchar (1) Property 44
111. QryGroup45 NVarchar (1) Property 45
112. QryGroup46 NVarchar (1) Property 46
113. QryGroup47 NVarchar (1) Property 47
114. QryGroup48 NVarchar (1) Property 48
115. QryGroup49 NVarchar (1) Property 49
116. QryGroup50 NVarchar (1) Property 50
117. QryGroup51 NVarchar (1) Property 51
118. QryGroup52 NVarchar (1) Property 52
119. QryGroup53 NVarchar (1) Property 53
120. QryGroup54 NVarchar (1) Property 54
121. QryGroup55 NVarchar (1) Property 55
122. QryGroup56 NVarchar (1) Property 56
123. QryGroup57 NVarchar (1) Property 57
124. QryGroup58 NVarchar (1) Property 58
125. QryGroup59 NVarchar (1) Property 59
126. QryGroup60 NVarchar (1) Property 60
127. QryGroup61 NVarchar (1) Property 61
128. QryGroup62 NVarchar (1) Property 62
129. QryGroup63 NVarchar (1) Property 63
130. QryGroup64 NVarchar (1) Property 64
131. DdctOffice NVarchar (10) Deduction Approval Office
132. CreateDate Time Stamp Creation Date
133. UpdateDate Time Stamp Date of Update
134. ExportCode NVarchar (8) Data Export Code
135. DscntObjct Smallint Object for Discounts
136. DscntRel NVarchar (1) Discounts Ratio
137. SPGCounter Smallint SPG Counter
138. SPPCounter Integer SPP Counter
139. DdctFileNo NVarchar (9) Tax Deduction File Number
140. SCNCounter Smallint SCN Counter
141. MinIntrst Decimal (21, ) Min. Interest Letter Amount
142. DataSource NVarchar (1) Data Source
143. OprCount Integer Open Opportunities
144. ExemptNo NVarchar (50) Exempt No.
145. Priority Integer Priority
146. CreditCard Smallint Credit Cards
147. CrCardNum NVarchar (64) Credit Card No.
148. CardValid Time Stamp Credit Card Validity
149. UserSign Smallint User Signature OUSR
150. LocMth NVarchar (1) LC Reconciliation
151. validFor NVarchar (1) Active
152. validFrom Time Stamp Active From
153. validTo Time Stamp Active To
154. frozenFor NVarchar (1) Inactive
155. frozenFrom Time Stamp Inactive From
156. frozenTo Time Stamp Inactive To
157. sEmployed NVarchar (1) Self-Employed
158. MTHCounter Integer MTH Counter
159. BNKCounter Integer BNK Counter
160. DdgKey Integer Withholding Tax Deduction Grp
161. DdtKey Integer Current Deduction Hierarchy
162. ValidComm NVarchar (30) Active Remarks
163. FrozenComm NVarchar (30) Inactive Remarks
164. chainStore NVarchar (1) Belongs to Retail Store
165. DiscInRet NVarchar (1) Allow Doc Discount in Returns
166. State1 NVarchar (3) Bill-to State
167. State2 NVarchar (3) Ship-to State
168. VatGroup NVarchar (8) Tax Code
169. LogInstanc Integer Log Instance
170. ObjType NVarchar (20) Object Type
171. Indicator NVarchar (2) Indicator
172. ShipType Smallint Shipping Type
173. DebPayAcct NVarchar (15) Accounts Receivable/Payable OACT
174. ShipToDef NVarchar (50) Ship-to-Default
175. Block NVarchar (100) Bill-to Block
176. MailBlock NVarchar (100) Ship-to Block
177. Password NVarchar (32) Password
178. ECVatGroup NVarchar (8) Tax Group
179. Deleted NVarchar (1) Deleted
180. IBAN NVarchar (50) IBAN
181. DocEntry Integer Internal Number
182. FormCode Integer 1099 Form Code
183. Box1099 NVarchar (20) 1099 Box
184. PymCode NVarchar (15) Payment Method Code
185. BackOrder NVarchar (1) Backorder
186. PartDelivr NVarchar (1) Partial Delivery
187. DunnLevel Integer Dunning Level
188. DunnDate Time Stamp Dunning Date
189. BlockDunn NVarchar (1) Block Dunning
190. BankCountr NVarchar (3) Bank Country
191. CollecAuth NVarchar (1) Collection Authorization
192. DME NVarchar (5) DME Identification
193. InstrucKey NVarchar (30) Instruction Key
194. SinglePaym NVarchar (1) Single Payment
195. ISRBillId NVarchar (9) ISR Biller ID
196. PaymBlock NVarchar (1) Payment Block
197. RefDetails NVarchar (20) Reference Details
198. HouseBank NVarchar (30) House Bank
199. OwnerIdNum NVarchar (15) ID Number
200. PyBlckDesc Integer Payment Block Description
201. HousBnkCry NVarchar (3) House Bank Country
202. HousBnkAct NVarchar (50) House Bank Account
203. HousBnkBrn NVarchar (50) House Bank Branch
204. ProjectCod NVarchar (20) Project Code
205. SysMatchNo Integer Last Sys. Reconciliation No.
206. VatIdUnCmp NVarchar (32) Unified Federal Tax ID
207. AgentCode NVarchar (32) Agent Code
208. TolrncDays Smallint Tolerance Days
209. SelfInvoic NVarchar (1) Self Invoice
210. DeferrTax NVarchar (1) Deferred Tax
211. LetterNum NVarchar (50) Tax Exemption Letter No.
212. MaxAmount Decimal (21, ) Max. Exemption Amount
213. FromDate Time Stamp Exemption Validity Date From
214. ToDate Time Stamp Exemption Validity Date To
215. WTLiable NVarchar (1) Subject to Withholding Tax
216. CrtfcateNO NVarchar (20) Certificate No.
217. ExpireDate Time Stamp Expiration Date
218. NINum NVarchar (20) Registration No.
219. AccCritria NVarchar (1) Accrual
220. WTCode NVarchar (4) WTax Code
221. Equ NVarchar (1) Equalization Tax
222. HldCode NVarchar (20) Holidays Name
223. ConnBP NVarchar (15) Linked Business Partner
224. MltMthNum Integer Last Multi. Reconciliation No.
225. TypWTReprt NVarchar (1) BP Type for WTax Report
226. VATRegNum NVarchar (32) VAT Reg. Number
227. RepName NVarchar (15) Representative Name
228. Industry NClob Industry
229. Business NClob Business
230. WTTaxCat NClob Withholding Tax Cat.
231. IsDomestic NVarchar (1) Is Domestic
232. IsResident NVarchar (1) Is Resident
233. AutoCalBCG NVarchar (1) Auto Calculated Bank Charges
234. OtrCtlAcct NVarchar (15) Other Receivable/Payable
235. AliasName NClob Alias Name
236. Building NClob Bill-to Building/Floor/Room
237. MailBuildi NClob Ship to Building/Floor/Room
238. BoEPrsnt NVarchar (15) Customer Bill of Exchang Pres
239. BoEDiscnt NVarchar (15) Customer BoE Discounted
240. BoEOnClct NVarchar (15) Bill of Exchange on Collection
241. UnpaidBoE NVarchar (15) Unpaid Bill of Exchange
242. ITWTCode NVarchar (4) Income Tax WTax Code
243. DunTerm NVarchar (25) Dunning Term
244. ChannlBP NVarchar (15) Channel BP
245. DfTcnician Integer Default Technician
246. Territory Integer Territory
247. BillToDef NVarchar (50) Bill-to Default
248. DpmClear NVarchar (15) Payment Advances
249. IntrntSite NVarchar (100) Web Site
250. LangCode Integer Language Code
251. HousActKey Integer House Bank Account Key
252. Profession NVarchar (50) Profession
253. CDPNum Smallint Closing Date Procedure Number
254. DflBankKey Integer Default Bank Key
255. BCACode NVarchar (3) Bank Charges Allocation Codes
256. UseShpdGd NVarchar (1) Use Shipped Goods Account
257. RegNum NVarchar (32) Company Reg. No. (CRN)
258. VerifNum NVarchar (32) WTax Verification No.
259. BankCtlKey NVarchar (2) Default Bank Internal ID
260. HousCtlKey NVarchar (2) House Bank Control Number
261. AddrType NVarchar (100) Bill-to Address Type
262. InsurOp347 NVarchar (1) 347 Insurance Operation
263. MailAddrTy NVarchar (100) Ship-to Address Type
264. StreetNo NVarchar (100) Bill-to Street No.
265. MailStrNo NVarchar (100) Ship-to Street No.
266. TaxRndRule NVarchar (1) Tax Rounding Rule
267. VendTID Integer Vender Type ID
268. ThreshOver NVarchar (1) Threshold Overlook
269. SurOver NVarchar (1) Surcharge Overlook
270. VendorOcup NVarchar (15) Vendor Occupation
271. OpCode347 NVarchar (1) 347 Operation Code
272. DpmIntAct NVarchar (15) DPM Interim Account
273. ResidenNum NVarchar (1) Residence Number
274. UserSign2 Smallint Updating User OUSR
275. PlngGroup NVarchar (10) Planning Group
276. VatIDNum NVarchar (32) VAT ID Number
277. Affiliate NVarchar (1) Affiliate
278. MivzExpSts NVarchar (1) Mivzak Export Status
279. HierchDdct NVarchar (1) Hierarchical Deduction
280. CertWHT NVarchar (1) Withholding Tax Certified
281. CertBKeep NVarchar (1) Bookkeeping Certified
282. WHShaamGrp NVarchar (1) Withholding Shaam Group
283. IndustryC Integer Industry
284. DatevAcct NVarchar (9) DATEV Account
285. DatevFirst NVarchar (1) First Data Entry
286. GTSRegNum NVarchar (20) GTS Registration Number
287. GTSBankAct NVarchar (80) GTS Bank Account
288. GTSBilAddr NVarchar (80) GTS Billing Address
289. HsBnkSwift NVarchar (50) House Bank BIC/SWIFT Code
290. HsBnkIBAN NVarchar (50) House Bank IBAN
291. DflSwift NVarchar (50) Default Bank BIC/SWIFT Code
292. AutoPost NVarchar (1) Automatic Posting
293. IntrAcc NVarchar (15) Interest Account
294. FeeAcc NVarchar (15) Fee Account
295. CpnNo Integer Campaign No.
296. NTSWebSite Smallint E-Tax Web Site
297. DflIBAN NVarchar (50) Default Bank IBAN
298. Series Integer Series
299. Number Integer Number
300. EDocExpFrm Integer Electronic Doc. Export Format
301. TaxIdIdent NVarchar (1) Tax ID Category
302. Attachment NClob Attachment
303. AtcEntry Integer Attachment Entry
304. DiscRel NVarchar (1) Disc. Relations
305. NoDiscount NVarchar (1) No Discounts
306. SCAdjust NVarchar (1) SC Adjustment
307. DflAgrmnt Integer Default Blanket Agreement No.
308. GlblLocNum NVarchar (50) Global Location Number
309. SenderID NVarchar (50) EDI Message Sender ID
310. RcpntID NVarchar (50) EDI Message Recipient ID
311. MainUsage Integer Main Usage
312. SefazCheck NVarchar (1) Check BP Status on SEFAZ
313. ChecksBalL Decimal (21, )
314. ChecksBalS Decimal (21, )
315. DateFrom Time Stamp Relationship Initial Date
316. DateTill Time Stamp Relationship Final Date
317. RelCode NVarchar (2) Relationship Code
318. OKATO NVarchar (11) OKATO
319. OKTMO NVarchar (12) OKTMO
320. KBKCode NVarchar (20) KBK Budget Classification Code
321. TypeOfOp NVarchar (1) Type of Operation
322. OwnerCode Integer
323. MandateID NVarchar (35) Mandate ID
324. SignDate Time Stamp Date of Signature
325. Remark1 Integer Remark 1
326. ConCerti NVarchar (20) Concessional Certificate
327. TpCusPres Integer Type of End-User Presence
328. RoleTypCod NVarchar (2) Role Type Code
329. BlockComm NVarchar (1) Block Sending Marketing
330. EmplymntCt NVarchar (3) Employment Category
331. ExcptnlEvt NVarchar (2) Exceptional Event
332. ExpnPrfFnd Decimal (21, ) Professional Funds Expenses
333. EdrsFromBP NVarchar (1)
334. EdrsToBP NVarchar (1)
335. CreateTS Integer
336. UpdateTS Integer
337. EDocGenTyp NVarchar (1)
338. eStreet NVarchar (38)
339. eStreetNum NVarchar (4)
340. eBuildnNum Integer
341. eZipCode NVarchar (10)
342. eCityTown NVarchar (48)
343. eCountry NVarchar (3)
344. eDistrict NVarchar (3)
345. RepFName NVarchar (20)
346. RepSName NVarchar (36)
347. RepCmpName NVarchar (36)
348. RepFisCode NVarchar (16)
349. RepAddID NVarchar (28)
350. PECAddr NVarchar (254)
351. IPACodePA NVarchar (32)
352. PriceMode NVarchar (1)
353. EffecPrice NVarchar (1)
354. TxExMxVdTp NVarchar (1)
355. MerchantID NVarchar (15)
356. UseBilAddr NVarchar (1)
357. NaturalPer NVarchar (1)
358. DPPStatus NVarchar (1)
359. EnAddID NClob
360. EncryptIV NVarchar (100)
361. EnDflAccnt NClob
362. EnDflIBAN NClob
363. EnERD4In NVarchar (1)
364. EnERD4Out NVarchar (1)
365. DflCustomr NVarchar (1)
366. TspEntry Integer
367. TspLine Integer
368. FCERelevnt NVarchar (1)
369. FCEVldte NVarchar (1)
370. AggregDoc NVarchar (1)
371. EffcAllSrc NVarchar (1)
372. EBVatExCau Integer
373. DataVers Integer
374. LegalText NVarchar (254)
375. VatResDate Time Stamp
376. VatResCode Integer
377. EnIBAN NClob
378. DefaultCur NVarchar (3)
379. VatResName NVarchar (254)
380. VatResAddr NVarchar (254)
381. CertDetail NVarchar (100)
382. EORINumber NVarchar (17)
383. FCEPmnMean NVarchar (1)
384. DefCommDDt NVarchar (1)
385. DefCommMon Smallint
386. DefCommDay Smallint
387. ExLettDate Time Stamp
388. NotRel4MI NVarchar (1)

Postingan populer dari blog ini

SMS Penipuan PT Centrall Cell

Apa itu "Pejwan"