OEB_RCV_ACCOUNTING_EVENTS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNTING_EVENT_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 LAST_UPDATE_LOGIN BIGINT 8
5 CREATION_DATE TIMESTAMP 8
6 CREATED_BY BIGINT 8
7 REQUEST_ID BIGINT 8
8 PROGRAM_APPLICATION_ID BIGINT 8
9 PROGRAM_ID BIGINT 8
10 PROGRAM_UDPATE_DATE TIMESTAMP 8
11 RCV_TRANSACTION_ID BIGINT 8
12 EVENT_TYPE_ID BIGINT 8
13 EVENT_SOURCE CHARACTER VARYING(25) 25
14 EVENT_SOURCE_ID BIGINT 8
15 SET_OF_BOOKS_ID BIGINT 8
16 ORG_ID BIGINT 8
17 TRANSFER_ORG_ID BIGINT 8
18 ORGANIZATION_ID BIGINT 8
19 TRANSFER_ORGANIZATION_ID BIGINT 8
20 DEBIT_ACCOUNT_ID BIGINT 8
21 CREDIT_ACCOUNT_ID BIGINT 8
22 TRANSACTION_DATE TIMESTAMP 8
23 TRANSACTION_QUANTITY BIGINT 8
24 TRANSACTION_UNIT_OF_MEASURE CHARACTER VARYING(25) 25
25 SOURCE_DOC_QUANTITY BIGINT 8
26 SOURCE_DOC_UNIT_OF_MEASURE CHARACTER VARYING(25) 25
27 PRIMARY_QUANTITY BIGINT 8
28 PRIMARY_UNIT_OF_MEASURE CHARACTER VARYING(25) 25
29 INVENTORY_ITEM_ID BIGINT 8
30 PO_HEADER_ID BIGINT 8
31 PO_RELEASE_ID BIGINT 8
32 PO_LINE_ID BIGINT 8
33 PO_LINE_LOCATION_ID BIGINT 8
34 PO_DISTRIBUTION_ID BIGINT 8
35 INTERCOMPANY_PRICING_OPTION BIGINT 8
36 UNIT_PRICE BIGINT 8
37 TRANSACTION_AMOUNT BIGINT 8
38 PRIOR_UNIT_PRICE BIGINT 8
39 NR_TAX BIGINT 8
40 REC_TAX BIGINT 8
41 NR_TAX_AMOUNT BIGINT 8
42 REC_TAX_AMOUNT BIGINT 8
43 PRIOR_NR_TAX BIGINT 8
44 PRIOR_REC_TAX BIGINT 8
45 CURRENCY_CODE CHARACTER VARYING(15) 15
46 CURRENCY_CONVERSION_TYPE CHARACTER VARYING(30) 30
47 CURRENCY_CONVERSION_RATE BIGINT 8
48 CURRENCY_CONVERSION_DATE TIMESTAMP 8
49 ACCOUNTED_FLAG CHARACTER VARYING(1) 1
50 PROCUREMENT_ORG_FLAG CHARACTER VARYING(1) 1
51 CROSS_OU_FLAG CHARACTER VARYING(1) 1
52 TRX_FLOW_HEADER_ID BIGINT 8
53 INVOICED_FLAG CHARACTER VARYING(1) 1
54 PA_ADDITION_FLAG CHARACTER VARYING(1) 1
55 USSGL_TRANSACTION_CODE CHARACTER VARYING(32) 32
56 GL_GROUP_ID BIGINT 8
57 QUANTITY_RECEIVED BIGINT 8
58 QUANTITY_INVOICED BIGINT 8
59 AMOUNT_RECEIVED BIGINT 8
60 AMOUNT_INVOICED BIGINT 8
61 LCM_ACCOUNT_ID BIGINT 8
62 UNIT_LANDED_COST BIGINT 8
63 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
64 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
65 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
66 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8