OEB_HST_AP_EXPENSE_REPORT_HEADERS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_HEADER_ID BIGINT 8
2 EMPLOYEE_ID BIGINT 8
3 WEEK_END_DATE TIMESTAMP 8
4 CREATION_DATE TIMESTAMP 8
5 CREATED_BY BIGINT 8
6 LAST_UPDATE_DATE TIMESTAMP 8
7 LAST_UPDATED_BY BIGINT 8
8 VOUCHNO BIGINT 8
9 TOTAL DOUBLE PRECISION 8
10 VENDOR_ID BIGINT 8
11 VENDOR_SITE_ID BIGINT 8
12 EXPENSE_CHECK_ADDRESS_FLAG CHARACTER VARYING(30) 30
13 REFERENCE_1 CHARACTER VARYING(30) 30
14 REFERENCE_2 CHARACTER VARYING(30) 30
15 INVOICE_NUM CHARACTER VARYING(50) 50
16 EXPENSE_REPORT_ID BIGINT 8
17 ACCTS_PAY_CODE_COMBINATION_ID BIGINT 8
18 SET_OF_BOOKS_ID BIGINT 8
19 SOURCE CHARACTER VARYING(25) 25
20 PURGEABLE_FLAG CHARACTER VARYING(1) 1
21 ACCOUNTING_DATE TIMESTAMP 8
22 MAXIMUM_AMOUNT_TO_APPLY DOUBLE PRECISION 8
23 ADVANCE_INVOICE_TO_APPLY BIGINT 8
24 APPLY_ADVANCES_DEFAULT CHARACTER VARYING(4) 4
25 EMPLOYEE_CCID BIGINT 8
26 DESCRIPTION CHARACTER VARYING(240) 240
27 REJECT_CODE CHARACTER VARYING(30) 30
28 HOLD_LOOKUP_CODE CHARACTER VARYING(25) 25
29 ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
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 DEFAULT_CURRENCY_CODE CHARACTER VARYING(15) 15
46 DEFAULT_EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
47 DEFAULT_EXCHANGE_RATE DOUBLE PRECISION 8
48 DEFAULT_EXCHANGE_DATE TIMESTAMP 8
49 LAST_UPDATE_LOGIN BIGINT 8
50 VOUCHER_NUM CHARACTER VARYING(50) 50
51 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
52 USSGL_TRX_CODE_CONTEXT CHARACTER VARYING(30) 30
53 DOC_CATEGORY_CODE CHARACTER VARYING(30) 30
54 AWT_GROUP_ID BIGINT 8
55 ORG_ID BIGINT 8
56 WORKFLOW_APPROVED_FLAG CHARACTER VARYING(1) 1
57 FLEX_CONCATENATED CHARACTER VARYING(240) 240
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 OVERRIDE_APPROVER_ID BIGINT 8
80 PAYMENT_CROSS_RATE_TYPE CHARACTER VARYING(30) 30
81 PAYMENT_CROSS_RATE_DATE TIMESTAMP 8
82 PAYMENT_CROSS_RATE DOUBLE PRECISION 8
83 PAYMENT_CURRENCY_CODE CHARACTER VARYING(15) 15
84 CORE_WF_STATUS_FLAG CHARACTER VARYING(1) 1
85 PREPAY_APPLY_FLAG CHARACTER VARYING(4) 4
86 PREPAY_NUM CHARACTER VARYING(50) 50
87 PREPAY_DIST_NUM BIGINT 8
88 PREPAY_APPLY_AMOUNT DOUBLE PRECISION 8
89 PREPAY_GL_DATE TIMESTAMP 8
90 BOTHPAY_PARENT_ID BIGINT 8
91 SHORTPAY_PARENT_ID BIGINT 8
92 PAID_ON_BEHALF_EMPLOYEE_ID BIGINT 8
93 OVERRIDE_APPROVER_NAME CHARACTER VARYING(240) 240
94 AMT_DUE_CCARD_COMPANY DOUBLE PRECISION 8
95 AMT_DUE_EMPLOYEE DOUBLE PRECISION 8
96 DEFAULT_RECEIPT_CURRENCY_CODE CHARACTER VARYING(15) 15
97 MULTIPLE_CURRENCIES_FLAG CHARACTER VARYING(1) 1
98 EXPENSE_STATUS_CODE CHARACTER VARYING(30) 30
99 EXPENSE_LAST_STATUS_DATE TIMESTAMP 8
100 EXPENSE_CURRENT_APPROVER_ID BIGINT 8
101 REPORT_FILING_NUMBER CHARACTER VARYING(240) 240
102 RECEIPTS_RECEIVED_DATE TIMESTAMP 8
103 AUDIT_CODE CHARACTER VARYING(30) 30
104 REPORT_SUBMITTED_DATE TIMESTAMP 8
105 LAST_AUDITED_BY BIGINT 8
106 RETURN_REASON_CODE CHARACTER VARYING(30) 30
107 RETURN_INSTRUCTION CHARACTER VARYING(4000) 4000
108 RECEIPTS_STATUS CHARACTER VARYING(30) 30
109 HOLDING_REPORT_HEADER_ID BIGINT 8
110 ADVANCES_JUSTIFICATION CHARACTER VARYING(240) 240
111 REQUEST_ID BIGINT 8
112 IMAGE_RECEIPTS_STATUS CHARACTER VARYING(30) 30
113 IMAGE_RECEIPTS_RECEIVED_DATE TIMESTAMP 8
114 MISSING_IMG_JUST CHARACTER VARYING(240) 240
115 APPROVAL_TYPE CHARACTER VARYING(10) 10
116 OVERDUE_REQUEST_ID BIGINT 8
117 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
118 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
119 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
120 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8