OEB_PO_REQ_DISTRIBUTIONS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DISTRIBUTION_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 REQUISITION_LINE_ID BIGINT 8
5 SET_OF_BOOKS_ID BIGINT 8
6 CODE_COMBINATION_ID BIGINT 8
7 REQ_LINE_QUANTITY NUMERIC(18,2) 19
8 LAST_UPDATE_LOGIN BIGINT 8
9 CREATION_DATE TIMESTAMP 8
10 CREATED_BY BIGINT 8
11 ENCUMBERED_FLAG CHARACTER VARYING(1) 1
12 GL_ENCUMBERED_DATE TIMESTAMP 8
13 GL_ENCUMBERED_PERIOD_NAME CHARACTER VARYING(15) 15
14 GL_CANCELLED_DATE TIMESTAMP 8
15 FAILED_FUNDS_LOOKUP_CODE CHARACTER VARYING(25) 25
16 ENCUMBERED_AMOUNT NUMERIC(18,2) 19
17 BUDGET_ACCOUNT_ID BIGINT 8
18 ACCRUAL_ACCOUNT_ID BIGINT 8
19 VARIANCE_ACCOUNT_ID BIGINT 8
20 PREVENT_ENCUMBRANCE_FLAG CHARACTER VARYING(1) 1
21 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
22 ATTRIBUTE1 CHARACTER VARYING(150) 150
23 ATTRIBUTE2 CHARACTER VARYING(150) 150
24 ATTRIBUTE3 CHARACTER VARYING(150) 150
25 ATTRIBUTE4 CHARACTER VARYING(150) 150
26 ATTRIBUTE5 CHARACTER VARYING(150) 150
27 ATTRIBUTE6 CHARACTER VARYING(150) 150
28 ATTRIBUTE7 CHARACTER VARYING(150) 150
29 ATTRIBUTE8 CHARACTER VARYING(150) 150
30 ATTRIBUTE9 CHARACTER VARYING(150) 150
31 ATTRIBUTE10 CHARACTER VARYING(150) 150
32 ATTRIBUTE11 CHARACTER VARYING(150) 150
33 ATTRIBUTE12 CHARACTER VARYING(150) 150
34 ATTRIBUTE13 CHARACTER VARYING(150) 150
35 ATTRIBUTE14 CHARACTER VARYING(150) 150
36 ATTRIBUTE15 CHARACTER VARYING(150) 150
37 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
38 GOVERNMENT_CONTEXT CHARACTER VARYING(30) 30
39 REQUEST_ID BIGINT 8
40 PROGRAM_APPLICATION_ID BIGINT 8
41 PROGRAM_ID BIGINT 8
42 PROGRAM_UPDATE_DATE TIMESTAMP 8
43 PROJECT_ID BIGINT 8
44 TASK_ID BIGINT 8
45 EXPENDITURE_TYPE CHARACTER VARYING(30) 30
46 PROJECT_ACCOUNTING_CONTEXT CHARACTER VARYING(30) 30
47 EXPENDITURE_ORGANIZATION_ID BIGINT 8
48 GL_CLOSED_DATE TIMESTAMP 8
49 SOURCE_REQ_DISTRIBUTION_ID BIGINT 8
50 DISTRIBUTION_NUM BIGINT 8
51 ALLOCATION_TYPE CHARACTER VARYING(25) 25
52 ALLOCATION_VALUE NUMERIC(18,2) 19
53 PROJECT_RELATED_FLAG CHARACTER VARYING(1) 1
54 EXPENDITURE_ITEM_DATE TIMESTAMP 8
55 ORG_ID BIGINT 8
56 AWARD_ID BIGINT 8
57 END_ITEM_UNIT_NUMBER CHARACTER VARYING(30) 30
58 RECOVERABLE_TAX NUMERIC(18,2) 19
59 NONRECOVERABLE_TAX NUMERIC(18,2) 19
60 RECOVERY_RATE NUMERIC(18,2) 19
61 TAX_RECOVERY_OVERRIDE_FLAG CHARACTER VARYING(1) 1
62 OKE_CONTRACT_LINE_ID BIGINT 8
63 OKE_CONTRACT_DELIVERABLE_ID BIGINT 8
64 REQ_LINE_AMOUNT NUMERIC(18,2) 19
65 REQ_LINE_CURRENCY_AMOUNT NUMERIC(18,2) 19
66 REQ_AWARD_ID BIGINT 8
67 EVENT_ID BIGINT 8
68 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
69 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
70 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
71 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8