OEB_RCV_RECEIVING_SUB_LEDGER

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LAST_UPDATE_DATE TIMESTAMP 8
2 LAST_UPDATED_BY BIGINT 8
3 CREATION_DATE TIMESTAMP 8
4 CREATED_BY BIGINT 8
5 LAST_UPDATE_LOGIN BIGINT 8
6 RCV_TRANSACTION_ID BIGINT 8
7 CURRENCY_CODE CHARACTER VARYING(15) 15
8 ACTUAL_FLAG CHARACTER VARYING(1) 1
9 JE_SOURCE_NAME CHARACTER VARYING(25) 25
10 JE_CATEGORY_NAME CHARACTER VARYING(25) 25
11 SET_OF_BOOKS_ID BIGINT 8
12 ACCOUNTING_DATE TIMESTAMP 8
13 CODE_COMBINATION_ID BIGINT 8
14 ACCOUNTED_DR BIGINT 8
15 ACCOUNTED_CR BIGINT 8
16 ENCUMBRANCE_TYPE_ID BIGINT 8
17 ENTERED_DR BIGINT 8
18 ENTERED_CR BIGINT 8
19 BUDGET_VERSION_ID BIGINT 8
20 CURRENCY_CONVERSION_DATE TIMESTAMP 8
21 USER_CURRENCY_CONVERSION_TYPE CHARACTER VARYING(30) 30
22 CURRENCY_CONVERSION_RATE BIGINT 8
23 TRANSACTION_DATE TIMESTAMP 8
24 PERIOD_NAME CHARACTER VARYING(15) 15
25 CHART_OF_ACCOUNTS_ID BIGINT 8
26 FUNCTIONAL_CURRENCY_CODE CHARACTER VARYING(15) 15
27 DATE_CREATED_IN_GL TIMESTAMP 8
28 JE_BATCH_NAME CHARACTER VARYING(100) 100
29 JE_BATCH_DESCRIPTION CHARACTER VARYING(100) 100
30 JE_HEADER_NAME CHARACTER VARYING(100) 100
31 JE_LINE_DESCRIPTION CHARACTER VARYING(100) 100
32 REVERSE_JOURNAL_FLAG CHARACTER VARYING(1) 1
33 REVERSAL_PERIOD_NAME CHARACTER VARYING(15) 15
34 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
35 ATTRIBUTE1 CHARACTER VARYING(150) 150
36 ATTRIBUTE2 CHARACTER VARYING(150) 150
37 ATTRIBUTE3 CHARACTER VARYING(150) 150
38 ATTRIBUTE4 CHARACTER VARYING(150) 150
39 ATTRIBUTE5 CHARACTER VARYING(150) 150
40 ATTRIBUTE6 CHARACTER VARYING(150) 150
41 ATTRIBUTE7 CHARACTER VARYING(150) 150
42 ATTRIBUTE8 CHARACTER VARYING(150) 150
43 ATTRIBUTE9 CHARACTER VARYING(150) 150
44 ATTRIBUTE10 CHARACTER VARYING(150) 150
45 ATTRIBUTE11 CHARACTER VARYING(150) 150
46 ATTRIBUTE12 CHARACTER VARYING(150) 150
47 ATTRIBUTE13 CHARACTER VARYING(150) 150
48 ATTRIBUTE14 CHARACTER VARYING(150) 150
49 ATTRIBUTE15 CHARACTER VARYING(150) 150
50 REQUEST_ID BIGINT 8
51 PROGRAM_APPLICATION_ID BIGINT 8
52 PROGRAM_ID BIGINT 8
53 PROGRAM_UPDATE_DATE TIMESTAMP 8
54 SUBLEDGER_DOC_SEQUENCE_ID BIGINT 8
55 SUBLEDGER_DOC_SEQUENCE_VALUE BIGINT 8
56 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
57 REFERENCE1 CHARACTER VARYING(240) 240
58 REFERENCE2 CHARACTER VARYING(240) 240
59 REFERENCE3 CHARACTER VARYING(240) 240
60 REFERENCE4 CHARACTER VARYING(240) 240
61 REFERENCE5 CHARACTER VARYING(240) 240
62 REFERENCE6 CHARACTER VARYING(240) 240
63 REFERENCE7 CHARACTER VARYING(240) 240
64 REFERENCE8 CHARACTER VARYING(240) 240
65 REFERENCE9 CHARACTER VARYING(240) 240
66 REFERENCE10 CHARACTER VARYING(240) 240
67 SOURCE_DOC_QUANTITY BIGINT 8
68 ACCRUAL_METHOD_FLAG CHARACTER VARYING(1) 1
69 GL_SL_LINK_ID BIGINT 8
70 ENTERED_REC_TAX BIGINT 8
71 ENTERED_NR_TAX BIGINT 8
72 ACCOUNTED_REC_TAX BIGINT 8
73 ACCOUNTED_NR_TAX BIGINT 8
74 RCV_SUB_LEDGER_ID BIGINT 8
75 ACCOUNTING_EVENT_ID BIGINT 8
76 ACCOUNTING_LINE_TYPE CHARACTER VARYING(30) 30
77 PA_ADDITION_FLAG CHARACTER VARYING(1) 1
78 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
79 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
80 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
81 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8