Tabel SAP B1 - ORCT - Incoming Payment
List \ ORCT
Berikut ini adalah kolom yang terdapat pada tabel ORCT di SAP B1
Update: 2026-07-22
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | DocEntry | Integer | ||
| 2. | DocNum | Integer | ||
| 3. | DocType | NVarchar (1) | ||
| 4. | Canceled | NVarchar (1) | ||
| 5. | Handwrtten | NVarchar (1) | ||
| 6. | Printed | NVarchar (1) | ||
| 7. | DocDate | Time Stamp | ||
| 8. | DocDueDate | Time Stamp | ||
| 9. | CardCode | NVarchar (15) | OCRD | |
| 10. | CardName | NVarchar (100) | ||
| 11. | Address | NVarchar (254) | ||
| 12. | DdctPrcnt | Decimal (21, 6) | ||
| 13. | DdctSum | Decimal (21, 6) | ||
| 14. | DdctSumFC | Decimal (21, 6) | ||
| 15. | CashAcct | NVarchar (15) | OACT | |
| 16. | CashSum | Decimal (21, 6) | ||
| 17. | CashSumFC | Decimal (21, 6) | ||
| 18. | CreditSum | Decimal (21, 6) | ||
| 19. | CredSumFC | Decimal (21, 6) | ||
| 20. | CheckAcct | NVarchar (15) | OACT | |
| 21. | CheckSum | Decimal (21, 6) | ||
| 22. | CheckSumFC | Decimal (21, 6) | ||
| 23. | TrsfrAcct | NVarchar (15) | OACT | |
| 24. | TrsfrSum | Decimal (21, 6) | ||
| 25. | TrsfrSumFC | Decimal (21, 6) | ||
| 26. | TrsfrDate | Time Stamp | ||
| 27. | TrsfrRef | NVarchar (27) | ||
| 28. | PayNoDoc | NVarchar (1) | ||
| 29. | NoDocSum | Decimal (21, 6) | ||
| 30. | NoDocSumFC | Decimal (21, 6) | ||
| 31. | DocCurr | NVarchar (3) | ||
| 32. | DiffCurr | NVarchar (1) | ||
| 33. | DocRate | Decimal (21, 6) | ||
| 34. | SysRate | Decimal (21, 6) | ||
| 35. | DocTotal | Decimal (21, 6) | ||
| 36. | DocTotalFC | Decimal (21, 6) | ||
| 37. | Ref1 | NVarchar (11) | ||
| 38. | Ref2 | NVarchar (50) | ||
| 39. | CounterRef | NVarchar (50) | ||
| 40. | Comments | NVarchar (254) | ||
| 41. | JrnlMemo | NVarchar (254) | ||
| 42. | TransId | Integer | ||
| 43. | DocTime | Smallint | ||
| 44. | ShowAtCard | NVarchar (1) | ||
| 45. | SpiltTrans | NVarchar (1) | ||
| 46. | CreateTran | NVarchar (1) | ||
| 47. | Flags | Integer | ||
| 48. | CntctCode | Integer | ||
| 49. | DdctSumSy | Decimal (21, 6) | ||
| 50. | CashSumSy | Decimal (21, 6) | ||
| 51. | CredSumSy | Decimal (21, 6) | ||
| 52. | CheckSumSy | Decimal (21, 6) | ||
| 53. | TrsfrSumSy | Decimal (21, 6) | ||
| 54. | NoDocSumSy | Decimal (21, 6) | ||
| 55. | DocTotalSy | Decimal (21, 6) | ||
| 56. | ObjType | NVarchar (20) | ||
| 57. | StornoRate | Decimal (21, 6) | ||
| 58. | UpdateDate | Time Stamp | ||
| 59. | CreateDate | Time Stamp | ||
| 60. | ApplyVAT | NVarchar (1) | ||
| 61. | TaxDate | Time Stamp | ||
| 62. | Series | Integer | ||
| 63. | confirmed | NVarchar (1) | ||
| 64. | ShowJDT | NVarchar (1) | ||
| 65. | BankCode | NVarchar (30) | ||
| 66. | BankAcct | NVarchar (50) | ||
| 67. | DataSource | NVarchar (1) | ||
| 68. | UserSign | Smallint | ||
| 69. | LogInstanc | Integer | ||
| 70. | VatGroup | NVarchar (8) | ||
| 71. | VatSum | Decimal (21, 6) | ||
| 72. | VatSumFC | Decimal (21, 6) | ||
| 73. | VatSumSy | Decimal (21, 6) | ||
| 74. | FinncPriod | Integer | ||
| 75. | VatPrcnt | Decimal (21, 6) | ||
| 76. | Dcount | Decimal (21, 6) | ||
| 77. | DcntSum | Decimal (21, 6) | ||
| 78. | DcntSumFC | Decimal (21, 6) | ||
| 79. | DcntSumSy | Decimal (21, 6) | ||
| 80. | SpltCredLn | NVarchar (1) | ||
| 81. | PrjCode | NVarchar (20) | ||
| 82. | PaymentRef | NVarchar (27) | ||
| 83. | Submitted | NVarchar (1) | ||
| 84. | Status | NVarchar (1) | ||
| 85. | PayMth | NVarchar (15) | ||
| 86. | BankCountr | NVarchar (3) | ||
| 87. | FreightSum | Decimal (21, 6) | ||
| 88. | FreigtFC | Decimal (21, 6) | ||
| 89. | FreigtSC | Decimal (21, 6) | ||
| 90. | BoeAcc | NVarchar (15) | ||
| 91. | BoeNum | Integer | ||
| 92. | BoeSum | Decimal (21, 6) | ||
| 93. | BoeSumFc | Decimal (21, 6) | ||
| 94. | BoeSumSc | Decimal (21, 6) | ||
| 95. | BoeAgent | NVarchar (32) | ||
| 96. | BoeStatus | NVarchar (1) | ||
| 97. | WtCode | NVarchar (4) | ||
| 98. | WtSum | Decimal (21, 6) | ||
| 99. | WtSumFrgn | Decimal (21, 6) | ||
| 100. | WtSumSys | Decimal (21, 6) | ||
| 101. | WtAccount | NVarchar (15) | ||
| 102. | WtBaseAmnt | Decimal (21, 6) | ||
| 103. | Proforma | NVarchar (1) | ||
| 104. | BoeAbs | Integer | ||
| 105. | BpAct | NVarchar (15) | ||
| 106. | BcgSum | Decimal (21, 6) | ||
| 107. | BcgSumFC | Decimal (21, 6) | ||
| 108. | BcgSumSy | Decimal (21, 6) | ||
| 109. | PIndicator | NVarchar (10) | ||
| 110. | PaPriority | NVarchar (1) | ||
| 111. | PayToCode | NVarchar (50) | ||
| 112. | IsPaytoBnk | NVarchar (1) | ||
| 113. | PBnkCnt | NVarchar (3) | ||
| 114. | PBnkCode | NVarchar (30) | ||
| 115. | PBnkAccnt | NVarchar (50) | ||
| 116. | PBnkBranch | NVarchar (50) | ||
| 117. | WizDunBlck | NVarchar (1) | ||
| 118. | WtBaseSum | Decimal (21, 6) | ||
| 119. | WtBaseSumF | Decimal (21, 6) | ||
| 120. | WtBaseSumS | Decimal (21, 6) | ||
| 121. | UndOvDiff | Decimal (21, 6) | ||
| 122. | UndOvDiffS | Decimal (21, 6) | ||
| 123. | BankActKey | Integer | ||
| 124. | VersionNum | NVarchar (13) | ||
| 125. | VatDate | Time Stamp | ||
| 126. | TransCode | NVarchar (4) | ||
| 127. | PaymType | NVarchar (1) | ||
| 128. | TfrRealAmt | Decimal (21, 6) | ||
| 129. | CancelDate | Time Stamp | ||
| 130. | OpenBal | Decimal (21, 6) | ||
| 131. | OpenBalFc | Decimal (21, 6) | ||
| 132. | OpenBalSc | Decimal (21, 6) | ||
| 133. | BcgTaxSum | Decimal (21, 6) | ||
| 134. | BcgTaxSumF | Decimal (21, 6) | ||
| 135. | BcgTaxSumS | Decimal (21, 6) | ||
| 136. | TpwID | Integer | ||
| 137. | ChallanNo | NVarchar (32) | ||
| 138. | ChallanBak | NVarchar (60) | ||
| 139. | ChallanDat | Time Stamp | ||
| 140. | WddStatus | NVarchar (1) | ||
| 141. | BcgVatGrp | NVarchar (8) | ||
| 142. | BcgVatPcnt | Decimal (21, 6) | ||
| 143. | SeqCode | Smallint | ||
| 144. | Serial | Integer | ||
| 145. | SeriesStr | NVarchar (3) | ||
| 146. | SubStr | NVarchar (3) | ||
| 147. | BSRCode | NVarchar (25) | ||
| 148. | LocCode | Integer | ||
| 149. | WTOnhldPst | Decimal (21, 6) | ||
| 150. | UserSign2 | Smallint | ||
| 151. | BuildDesc | NVarchar (50) | ||
| 152. | ResidenNum | NVarchar (1) | ||
| 153. | OperatCode | NVarchar (1) | ||
| 154. | UndOvDiffF | Decimal (21, 6) | ||
| 155. | MIEntry | Integer | ||
| 156. | FreeText1 | NVarchar (254) | ||
| 157. | FreeText2 | NVarchar (254) | ||
| 158. | FreeText3 | NVarchar (254) | ||
| 159. | ShowDocNo | NVarchar (1) | ||
| 160. | TDSInterst | Decimal (21, 6) | ||
| 161. | TDSCharges | Decimal (21, 6) | ||
| 162. | CUP | Integer | ||
| 163. | CIG | Integer | ||
| 164. | MIType | NVarchar (20) | ||
| 165. | SupplCode | NVarchar (254) | ||
| 166. | BPLId | Integer | ||
| 167. | BPLName | NVarchar (100) | ||
| 168. | VATRegNum | NVarchar (32) | ||
| 169. | BPLCentPmt | NVarchar (1) | ||
| 170. | DraftKey | Integer | ||
| 171. | TDSFee | Decimal (21, 6) | ||
| 172. | MinHeadCL | Integer | ||
| 173. | SEPADate | Time Stamp | ||
| 174. | OwnerCode | Integer | ||
| 175. | AgrNo | Integer | ||
| 176. | CreateTS | Integer | ||
| 177. | UpdateTS | Integer | ||
| 178. | TDSType | NVarchar (1) | ||
| 179. | DrNo | NVarchar (32) | ||
| 180. | PmntWTCert | NVarchar (1) | ||
| 181. | EnPBnkAcct | NClob | ||
| 182. | EncryptIV | NVarchar (100) | ||
| 183. | DPPStatus | NVarchar (1) | ||
| 184. | PriceMode | NVarchar (1) | ||
| 185. | AtcEntry | Integer | ||
| 186. | Attachment | NClob | ||
| 187. | EnblDpmTax | NVarchar (1) | ||
| 188. | SignMsg | NClob | ||
| 189. | SignDigest | NClob | ||
| 190. | CertifNum | NVarchar (50) | ||
| 191. | KeyVersion | Integer | ||
| 192. | QRCodeSPGn | NClob | ||
| 193. | DataVers | Integer |
