Logdump 316 >open /ogg/ora12c/dirdat/cd000006054 Current LogTrail is /ogg/ora12c/dirdat/cd000006054 Logdump 317 >filter inc filename CBS_CORE.CB_RECEIPTS Logdump 318 >pos 0 Reading forward from RBA 0 Logdump 319 >ghdr on Logdump 320 >detail data on Logdump 321 >n ___________________________________________________________________ Hdr-Ind : E (x45) Partition : . (x00) UndoFlag : . (x00) BeforeAfter: A (x41) RecLength : 4174 (x104e) IO Time : 2020/10/21 19:30:26.607.606 IOType : 170 (xaa) OrigNode : 2 (x02) TransInd : . (x01) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) DDR/TDR Idx: (001, 008) AuditPos : 8116576 Continued : N (x00) RecCount : 1 (x01) 2020/10/21 19:30:26.607.606 Metadata Len 4174 RBA 1450346 Name: CBS_CORE.CB_RECEIPTS * 1)Name 2)Data Type 3)External Length 4)Fetch Offset 5)Scale 6)Level 7)Null 8)Bump if Odd 9)Internal Length 10)Binary Length 11)Table Length 12)Most Sig DT 13)Least Sig DT 14)High Precision 15)Low Precision 16)Elementary Item 17)Occurs 18)Key Column 19)Sub DataType 20)Native DataType 21)Character Set 22)Character Length 23)LOB Type 24)Partial Type * TDR version: 11 Definition for table CBS_CORE.CB_RECEIPTS Record Length: 1690 Columns: 46 TRANS_NUM_V 64 20 0 0 0 1 0 20 20 0 0 0 0 0 1 0 1 0 1 -1 0 0 0 TRANS_DATE_D 192 36 26 0 0 1 0 36 36 36 0 8 0 0 1 0 0 0 188 -1 0 0 0 TRANS_OPTN_V 64 1 66 0 0 1 0 1 1 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 TRANS_REF_NO_V 64 20 72 0 0 1 0 20 20 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 LOCATION_CODE_V 64 10 98 0 0 1 0 10 10 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 CASH_BOX_NUMBER_N 134 11 114 0 0 1 0 8 8 8 0 0 0 0 1 0 0 3 2 -1 0 0 0 SALES_REGION_N 64 50 126 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 PAY_MODE_OPTN_V 64 2 182 0 0 1 0 2 2 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 ENTITY_TYPE_V 64 3 190 0 0 1 0 3 3 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 ACCOUNT_LINK_CODE_N 134 11 198 0 0 1 0 8 8 8 0 0 0 0 1 0 0 3 2 -1 0 0 0 SAP_SUB_AC_CODE_N 134 11 210 0 0 1 0 8 8 8 0 0 0 0 1 0 0 3 2 -1 0 0 0 TRANS_AMT_N 134 15 222 0 0 1 0 8 8 8 0 0 0 0 1 0 0 3 2 -1 0 0 0 DESCRIPTION_V 64 120 234 0 0 1 0 120 120 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 USER_CODE_N 134 11 360 0 0 1 0 8 8 8 0 0 0 0 1 0 0 3 2 -1 0 0 0 POSTED_TO_ACCOUNTS_N 134 8 372 0 0 1 0 8 8 8 0 0 0 0 1 0 0 3 2 -1 0 0 0 POSTED_TRANS_NUM_V 64 20 384 0 0 1 0 20 20 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 UPLOADED_DATE_D 192 36 410 0 0 1 0 36 36 36 0 8 0 0 1 0 0 0 188 -1 0 0 0 DISPLAY_REF_NO_V 64 20 450 0 0 1 0 20 20 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 CASH_BOX_COLL_TYPE_V 64 5 476 0 0 1 0 5 5 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 SALES_LINK_FLAG_V 64 1 486 0 0 1 0 1 1 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 SOURCE_CODE_V 64 31 492 0 0 1 0 31 31 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 ERLY_PYMT_TRANS_NUM_V 64 20 528 0 0 1 0 20 20 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 PREPAID_POSTPAID_FLAG_V 64 1 554 0 0 1 0 1 1 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 RECHARGE_TYPE_V 64 1 560 0 0 1 0 1 1 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 LAST_MODIFIED_DATE_D 192 36 566 0 0 1 0 36 36 36 0 8 0 0 1 0 0 0 188 -1 0 0 0 EXTERNAL_REFERENCE_V 64 30 606 0 0 1 0 30 30 0 0 0 0 0 1 0 0 0 1 -1 0 0 0 SYS_NC00027$ 192 29 642 0 0 1 0 29 29 29 0 6 0 0 1 0 0 0 187 -1 0 0 0 property: 0x0000000000010128 SYS_NC00028$ 192 29 674 0 0 1 0 29 29 29 0 6 0 0 1 0 0 0 187 -1 0 0 0 property: 0x0000000000010128 SYS_NC00029$ 192 29 706 0 0 1 0 29 29 29 0 6 0 0 1 0 0 0 187 -1 0 0 0 property: 0x0000000000010128 SYS_STS#ZT$7ZC9IV7W7DF_QB5ZN32 64 50 738 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STS130W2FP_DY46XHADV2CC_K1 64 50 794 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STS3UTNM6TZ#W56IJ2939UAX2_ 64 50 850 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STS545E#5JKVAPLLADF893JUUJ 64 50 906 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STS7M#OJC98IMVQSJSL1#2ZJE7 64 50 962 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STS7ZA81MJOBDNJCD$2$67_4J0 64 50 1018 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STS8MS8EZV7V3PGB12TVUUNHL7 64 50 1074 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STS8PFHJ5MO01BY0JPO0HJIDE6 64 50 1130 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STS8Y#KWXS0G9S6P9SMX223X$3 64 50 1186 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STSBJMYT0KWJQQSXJT94_7XV6H 64 50 1242 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STSBJTS99QI6VWL8V1LAT0O2X0 64 50 1298 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STSF94C030FMNIETZ$W8UK3KSH 64 50 1354 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STSI8NU3NVC1TO04CH45L824I2 64 50 1410 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STSJXRXPOLJMA9W505DMHGKNY0 64 50 1466 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STSTECC1#I1T0CAC$76GKO4EAF 64 50 1522 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STST_Y0G16H_0IQ#0QOE_0J5O9 64 50 1578 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 SYS_STSXSKLF#6KS7IT#VZ0N#FGXLL 64 50 1634 0 0 1 0 50 50 50 0 0 0 0 1 0 0 2 2 -1 0 0 0 property: 0x0000000000010028 End of definition Filtering suppressed 1785 records Logdump 322 >