Tabel SAP B1 - OHEM - Employees
List \ OHEM
Berikut ini adalah kolom yang terdapat pada tabel OHEM di SAP B1
Update: 2026-07-28
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | empID | Integer | ||
| 2. | lastName | NVarchar (50) | ||
| 3. | firstName | NVarchar (50) | ||
| 4. | middleName | NVarchar (50) | ||
| 5. | sex | NVarchar (1) | ||
| 6. | jobTitle | NVarchar (20) | ||
| 7. | type | Integer | ||
| 8. | dept | Smallint | ||
| 9. | branch | Smallint | ||
| 10. | workStreet | NVarchar (100) | ||
| 11. | workBlock | NVarchar (100) | ||
| 12. | workZip | NVarchar (20) | ||
| 13. | workCity | NVarchar (100) | ||
| 14. | workCounty | NVarchar (100) | ||
| 15. | workCountr | NVarchar (3) | ||
| 16. | workState | NVarchar (3) | ||
| 17. | manager | Integer | ||
| 18. | userId | Integer | ||
| 19. | salesPrson | Integer | ||
| 20. | officeTel | NVarchar (50) | ||
| 21. | officeExt | NVarchar (50) | ||
| 22. | mobile | NVarchar (50) | ||
| 23. | pager | NVarchar (50) | ||
| 24. | homeTel | NVarchar (50) | ||
| 25. | fax | NVarchar (50) | ||
| 26. | NVarchar (100) | |||
| 27. | startDate | Time Stamp | ||
| 28. | status | Integer | ||
| 29. | salary | Decimal (21, 6) | ||
| 30. | salaryUnit | NVarchar (1) | ||
| 31. | emplCost | Decimal (21, 6) | ||
| 32. | empCostUnt | NVarchar (1) | ||
| 33. | termDate | Time Stamp | ||
| 34. | termReason | Integer | ||
| 35. | bankCode | NVarchar (30) | ||
| 36. | bankBranch | NVarchar (100) | ||
| 37. | bankBranNo | NVarchar (30) | ||
| 38. | bankAcount | NVarchar (100) | ||
| 39. | homeStreet | NVarchar (100) | ||
| 40. | homeBlock | NVarchar (100) | ||
| 41. | homeZip | NVarchar (20) | ||
| 42. | homeCity | NVarchar (100) | ||
| 43. | homeCounty | NVarchar (100) | ||
| 44. | homeCountr | NVarchar (3) | ||
| 45. | homeState | NVarchar (3) | ||
| 46. | birthDate | Time Stamp | ||
| 47. | brthCountr | NVarchar (3) | ||
| 48. | martStatus | NVarchar (1) | ||
| 49. | nChildren | Smallint | ||
| 50. | govID | NVarchar (64) | ||
| 51. | citizenshp | NVarchar (3) | ||
| 52. | passportNo | NVarchar (64) | ||
| 53. | passportEx | Time Stamp | ||
| 54. | picture | NVarchar (200) | ||
| 55. | remark | NClob | ||
| 56. | attachment | NClob | ||
| 57. | salaryCurr | NVarchar (3) | ||
| 58. | empCostCur | NVarchar (3) | ||
| 59. | WorkBuild | NClob | ||
| 60. | HomeBuild | NClob | ||
| 61. | position | Integer | ||
| 62. | AtcEntry | Integer | ||
| 63. | AddrTypeW | NVarchar (100) | ||
| 64. | AddrTypeH | NVarchar (100) | ||
| 65. | StreetNoW | NVarchar (100) | ||
| 66. | StreetNoH | NVarchar (100) | ||
| 67. | DispMidNam | NVarchar (1) | ||
| 68. | NamePos | NVarchar (1) | ||
| 69. | DispComma | NVarchar (1) | ||
| 70. | CostCenter | NVarchar (8) | ||
| 71. | CompanyNum | NVarchar (20) | ||
| 72. | VacPreYear | Integer | ||
| 73. | VacCurYear | Integer | ||
| 74. | MunKey | NVarchar (20) | ||
| 75. | TaxClass | NVarchar (2) | ||
| 76. | InTaxLiabi | NVarchar (2) | ||
| 77. | EmTaxCCode | NVarchar (9) | ||
| 78. | RelPartner | NVarchar (9) | ||
| 79. | ExemptAmnt | Decimal (21, 6) | ||
| 80. | ExemptUnit | NVarchar (20) | ||
| 81. | AddiAmnt | Decimal (21, 6) | ||
| 82. | AddiUnit | NVarchar (20) | ||
| 83. | TaxOName | NVarchar (50) | ||
| 84. | TaxONum | NVarchar (20) | ||
| 85. | HeaInsName | NVarchar (50) | ||
| 86. | HeaInsCode | NVarchar (50) | ||
| 87. | HeaInsType | NVarchar (20) | ||
| 88. | SInsurNum | NVarchar (20) | ||
| 89. | StatusOfP | NVarchar (2) | ||
| 90. | StatusOfE | NVarchar (2) | ||
| 91. | BCodeDateV | NVarchar (20) | ||
| 92. | DevBAOwner | NVarchar (1) | ||
| 93. | FNameSP | NVarchar (50) | ||
| 94. | SurnameSP | NVarchar (50) | ||
| 95. | LogInstanc | Integer | ||
| 96. | UserSign | Smallint | ||
| 97. | UserSign2 | Smallint | ||
| 98. | UpdateDate | Time Stamp | ||
| 99. | PersGroup | NVarchar (5) | ||
| 100. | JTCode | NVarchar (5) | ||
| 101. | ExtEmpNo | NVarchar (20) | ||
| 102. | BirthPlace | NVarchar (100) | ||
| 103. | PymMeth | NVarchar (2) | ||
| 104. | ExemptCurr | NVarchar (3) | ||
| 105. | AddiCurr | NVarchar (3) | ||
| 106. | STDCode | Integer | ||
| 107. | FatherName | NVarchar (150) | ||
| 108. | CPF | NVarchar (100) | ||
| 109. | CRC | NVarchar (20) | ||
| 110. | ContResp | NVarchar (1) | ||
| 111. | RepLegal | NVarchar (1) | ||
| 112. | DirfDeclar | NVarchar (1) | ||
| 113. | UF_CRC | NVarchar (3) | ||
| 114. | IDType | NVarchar (30) | ||
| 115. | Active | NVarchar (1) | ||
| 116. | BPLId | Integer | ||
| 117. | ManualNUM | NVarchar (60) | ||
| 118. | PassIssue | Time Stamp | ||
| 119. | PassIssuer | NVarchar (254) | ||
| 120. | QualCode | NVarchar (3) | ||
| 121. | PRWebAccss | NVarchar (1) | ||
| 122. | PrePRWeb | NVarchar (1) | ||
| 123. | BPLink | NVarchar (15) | ||
| 124. | NaturalPer | NVarchar (1) | ||
| 125. | DPPStatus | NVarchar (1) | ||
| 126. | EnRligion | NClob | ||
| 127. | EnRligionP | NClob | ||
| 128. | EncryptIV | NVarchar (100) | ||
| 129. | EnGovID | NClob | ||
| 130. | EnPassport | NClob | ||
| 131. | CreateDate | Time Stamp | ||
| 132. | CreateTS | Integer | ||
| 133. | UpdateTS | Integer | ||
| 134. | EnInsurNum | NClob | ||
| 135. | EnBnkAcct | NClob | ||
| 136. | Code | NVarchar (50) | ||
| 137. | ARetSEFAZ | NVarchar (1) |
