OEB_PO_DISTRIBUTIONS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PO_DISTRIBUTION_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 PO_HEADER_ID BIGINT 8
5 PO_LINE_ID BIGINT 8
6 LINE_LOCATION_ID BIGINT 8
7 SET_OF_BOOKS_ID BIGINT 8
8 CODE_COMBINATION_ID BIGINT 8
9 QUANTITY_ORDERED NUMERIC(18,2) 19
10 LAST_UPDATE_LOGIN BIGINT 8
11 CREATION_DATE TIMESTAMP 8
12 CREATED_BY BIGINT 8
13 PO_RELEASE_ID BIGINT 8
14 QUANTITY_DELIVERED NUMERIC(18,2) 19
15 QUANTITY_BILLED NUMERIC(18,2) 19
16 QUANTITY_CANCELLED NUMERIC(18,2) 19
17 REQ_HEADER_REFERENCE_NUM CHARACTER VARYING(25) 25
18 REQ_LINE_REFERENCE_NUM CHARACTER VARYING(25) 25
19 REQ_DISTRIBUTION_ID BIGINT 8
20 DELIVER_TO_LOCATION_ID BIGINT 8
21 DELIVER_TO_PERSON_ID BIGINT 8
22 RATE_DATE TIMESTAMP 8
23 RATE NUMERIC(18,2) 19
24 AMOUNT_BILLED NUMERIC(18,2) 19
25 ACCRUED_FLAG CHARACTER VARYING(1) 1
26 ENCUMBERED_FLAG CHARACTER VARYING(1) 1
27 ENCUMBERED_AMOUNT NUMERIC(18,2) 19
28 UNENCUMBERED_QUANTITY NUMERIC(18,2) 19
29 UNENCUMBERED_AMOUNT NUMERIC(18,2) 19
30 FAILED_FUNDS_LOOKUP_CODE CHARACTER VARYING(25) 25
31 GL_ENCUMBERED_DATE TIMESTAMP 8
32 GL_ENCUMBERED_PERIOD_NAME CHARACTER VARYING(15) 15
33 GL_CANCELLED_DATE TIMESTAMP 8
34 DESTINATION_TYPE_CODE CHARACTER VARYING(25) 25
35 DESTINATION_ORGANIZATION_ID BIGINT 8
36 DESTINATION_SUBINVENTORY CHARACTER VARYING(10) 10
37 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
38 ATTRIBUTE1 CHARACTER VARYING(150) 150
39 ATTRIBUTE2 CHARACTER VARYING(150) 150
40 ATTRIBUTE3 CHARACTER VARYING(150) 150
41 ATTRIBUTE4 CHARACTER VARYING(150) 150
42 ATTRIBUTE5 CHARACTER VARYING(150) 150
43 ATTRIBUTE6 CHARACTER VARYING(150) 150
44 ATTRIBUTE7 CHARACTER VARYING(150) 150
45 ATTRIBUTE8 CHARACTER VARYING(150) 150
46 ATTRIBUTE9 CHARACTER VARYING(150) 150
47 ATTRIBUTE10 CHARACTER VARYING(150) 150
48 ATTRIBUTE11 CHARACTER VARYING(150) 150
49 ATTRIBUTE12 CHARACTER VARYING(150) 150
50 ATTRIBUTE13 CHARACTER VARYING(150) 150
51 ATTRIBUTE14 CHARACTER VARYING(150) 150
52 ATTRIBUTE15 CHARACTER VARYING(150) 150
53 WIP_ENTITY_ID BIGINT 8
54 WIP_OPERATION_SEQ_NUM BIGINT 8
55 WIP_RESOURCE_SEQ_NUM BIGINT 8
56 WIP_REPETITIVE_SCHEDULE_ID BIGINT 8
57 WIP_LINE_ID BIGINT 8
58 BOM_RESOURCE_ID BIGINT 8
59 BUDGET_ACCOUNT_ID BIGINT 8
60 ACCRUAL_ACCOUNT_ID BIGINT 8
61 VARIANCE_ACCOUNT_ID BIGINT 8
62 PREVENT_ENCUMBRANCE_FLAG CHARACTER VARYING(1) 1
63 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
64 GOVERNMENT_CONTEXT CHARACTER VARYING(30) 30
65 DESTINATION_CONTEXT CHARACTER VARYING(30) 30
66 DISTRIBUTION_NUM BIGINT 8
67 SOURCE_DISTRIBUTION_ID BIGINT 8
68 REQUEST_ID BIGINT 8
69 PROGRAM_APPLICATION_ID BIGINT 8
70 PROGRAM_ID BIGINT 8
71 PROGRAM_UPDATE_DATE TIMESTAMP 8
72 PROJECT_ID BIGINT 8
73 TASK_ID BIGINT 8
74 EXPENDITURE_TYPE CHARACTER VARYING(30) 30
75 PROJECT_ACCOUNTING_CONTEXT CHARACTER VARYING(30) 30
76 EXPENDITURE_ORGANIZATION_ID BIGINT 8
77 GL_CLOSED_DATE TIMESTAMP 8
78 ACCRUE_ON_RECEIPT_FLAG CHARACTER VARYING(1) 1
79 EXPENDITURE_ITEM_DATE TIMESTAMP 8
80 ORG_ID BIGINT 8
81 KANBAN_CARD_ID BIGINT 8
82 AWARD_ID BIGINT 8
83 MRC_RATE_DATE CHARACTER VARYING(1000) 1000
84 MRC_RATE CHARACTER VARYING(1000) 1000
85 MRC_ENCUMBERED_AMOUNT CHARACTER VARYING(1000) 1000
86 MRC_UNENCUMBERED_AMOUNT CHARACTER VARYING(1000) 1000
87 END_ITEM_UNIT_NUMBER CHARACTER VARYING(30) 30
88 TAX_RECOVERY_OVERRIDE_FLAG CHARACTER VARYING(1) 1
89 RECOVERABLE_TAX NUMERIC(18,2) 19
90 NONRECOVERABLE_TAX NUMERIC(18,2) 19
91 RECOVERY_RATE NUMERIC(18,2) 19
92 OKE_CONTRACT_LINE_ID BIGINT 8
93 OKE_CONTRACT_DELIVERABLE_ID BIGINT 8
94 AMOUNT_ORDERED NUMERIC(18,2) 19
95 AMOUNT_DELIVERED NUMERIC(18,2) 19
96 AMOUNT_CANCELLED NUMERIC(18,2) 19
97 DISTRIBUTION_TYPE CHARACTER VARYING(25) 25
98 AMOUNT_TO_ENCUMBER NUMERIC(18,2) 19
99 INVOICE_ADJUSTMENT_FLAG CHARACTER VARYING(1) 1
100 DEST_CHARGE_ACCOUNT_ID BIGINT 8
101 DEST_VARIANCE_ACCOUNT_ID BIGINT 8
102 QUANTITY_FINANCED NUMERIC(18,2) 19
103 AMOUNT_FINANCED NUMERIC(18,2) 19
104 QUANTITY_RECOUPED NUMERIC(18,2) 19
105 AMOUNT_RECOUPED NUMERIC(18,2) 19
106 RETAINAGE_WITHHELD_AMOUNT NUMERIC(18,2) 19
107 RETAINAGE_RELEASED_AMOUNT NUMERIC(18,2) 19
108 WF_ITEM_KEY CHARACTER VARYING(240) 240
109 INVOICED_VAL_IN_NTFN NUMERIC(18,2) 19
110 TAX_ATTRIBUTE_UPDATE_CODE CHARACTER VARYING(15) 15
111 INTERFACE_DISTRIBUTION_REF CHARACTER VARYING(240) 240
112 LCM_FLAG CHARACTER VARYING(1) 1
113 GROUP_LINE_ID BIGINT 8
114 UDA_TEMPLATE_ID BIGINT 8
115 DRAFT_ID BIGINT 8
116 AMOUNT_FUNDED NUMERIC(18,2) 19
117 FUNDED_VALUE NUMERIC(18,2) 19
118 PARTIAL_FUNDED_FLAG CHARACTER VARYING(1) 1
119 QUANTITY_FUNDED NUMERIC(18,2) 19
120 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
121 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
122 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
123 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8