OEB_PO_RELEASES_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PO_RELEASE_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 PO_HEADER_ID BIGINT 8
5 RELEASE_NUM NUMERIC(18,2) 19
6 AGENT_ID BIGINT 8
7 RELEASE_DATE TIMESTAMP 8
8 LAST_UPDATE_LOGIN BIGINT 8
9 CREATION_DATE TIMESTAMP 8
10 CREATED_BY BIGINT 8
11 REVISION_NUM NUMERIC(18,2) 19
12 REVISED_DATE TIMESTAMP 8
13 APPROVED_FLAG CHARACTER VARYING(1) 1
14 APPROVED_DATE TIMESTAMP 8
15 PRINT_COUNT NUMERIC(18,2) 19
16 PRINTED_DATE TIMESTAMP 8
17 ACCEPTANCE_REQUIRED_FLAG CHARACTER VARYING(1) 1
18 ACCEPTANCE_DUE_DATE TIMESTAMP 8
19 HOLD_BY BIGINT 8
20 HOLD_DATE TIMESTAMP 8
21 HOLD_REASON CHARACTER VARYING(240) 240
22 HOLD_FLAG CHARACTER VARYING(1) 1
23 CANCEL_FLAG CHARACTER VARYING(1) 1
24 CANCELLED_BY BIGINT 8
25 CANCEL_DATE TIMESTAMP 8
26 CANCEL_REASON CHARACTER VARYING(240) 240
27 FIRM_STATUS_LOOKUP_CODE CHARACTER VARYING(25) 25
28 FIRM_DATE TIMESTAMP 8
29 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
30 ATTRIBUTE1 CHARACTER VARYING(150) 150
31 ATTRIBUTE2 CHARACTER VARYING(150) 150
32 ATTRIBUTE3 CHARACTER VARYING(150) 150
33 ATTRIBUTE4 CHARACTER VARYING(150) 150
34 ATTRIBUTE5 CHARACTER VARYING(150) 150
35 ATTRIBUTE6 CHARACTER VARYING(150) 150
36 ATTRIBUTE7 CHARACTER VARYING(150) 150
37 ATTRIBUTE8 CHARACTER VARYING(150) 150
38 ATTRIBUTE9 CHARACTER VARYING(150) 150
39 ATTRIBUTE10 CHARACTER VARYING(150) 150
40 ATTRIBUTE11 CHARACTER VARYING(150) 150
41 ATTRIBUTE12 CHARACTER VARYING(150) 150
42 ATTRIBUTE13 CHARACTER VARYING(150) 150
43 ATTRIBUTE14 CHARACTER VARYING(150) 150
44 ATTRIBUTE15 CHARACTER VARYING(150) 150
45 AUTHORIZATION_STATUS CHARACTER VARYING(25) 25
46 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
47 GOVERNMENT_CONTEXT CHARACTER VARYING(30) 30
48 REQUEST_ID BIGINT 8
49 PROGRAM_APPLICATION_ID BIGINT 8
50 PROGRAM_ID BIGINT 8
51 PROGRAM_UPDATE_DATE TIMESTAMP 8
52 CLOSED_CODE CHARACTER VARYING(25) 25
53 FROZEN_FLAG CHARACTER VARYING(1) 1
54 RELEASE_TYPE CHARACTER VARYING(25) 25
55 NOTE_TO_VENDOR CHARACTER VARYING(480) 480
56 ORG_ID BIGINT 8
57 EDI_PROCESSED_FLAG CHARACTER VARYING(1) 1
58 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
59 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
60 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
61 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
62 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
63 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
64 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
65 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
66 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
67 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
68 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
69 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
70 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
71 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
72 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
73 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
74 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
75 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
76 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
77 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
78 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
79 WF_ITEM_TYPE CHARACTER VARYING(8) 8
80 WF_ITEM_KEY CHARACTER VARYING(240) 240
81 PCARD_ID BIGINT 8
82 PAY_ON_CODE CHARACTER VARYING(25) 25
83 XML_FLAG CHARACTER VARYING(3) 3
84 XML_SEND_DATE TIMESTAMP 8
85 XML_CHANGE_SEND_DATE TIMESTAMP 8
86 CONSIGNED_CONSUMPTION_FLAG CHARACTER VARYING(1) 1
87 CBC_ACCOUNTING_DATE TIMESTAMP 8
88 CHANGE_REQUESTED_BY CHARACTER VARYING(20) 20
89 SHIPPING_CONTROL CHARACTER VARYING(30) 30
90 CHANGE_SUMMARY CHARACTER VARYING(1000) 1000
91 VENDOR_ORDER_NUM CHARACTER VARYING(25) 25
92 DOCUMENT_CREATION_METHOD CHARACTER VARYING(30) 30
93 SUBMIT_DATE TIMESTAMP 8
94 TAX_ATTRIBUTE_UPDATE_CODE CHARACTER VARYING(15) 15
95 COMM_REV_NUM BIGINT 8
96 OTM_STATUS_CODE CHARACTER VARYING(40) 40
97 OTM_RECOVERY_FLAG CHARACTER VARYING(1) 1
98 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
99 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
100 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
101 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8