FCT_FIN_GINZ_GL_TRANSACTION_SUMMARY_V

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 LEDGER_ID BIGINT 8
2 ENTITY_CODE CHARACTER VARYING(512) 512
3 PERIOD_NAME CHARACTER VARYING(512) 512
4 PRODUCT_CODE CHARACTER VARYING(512) 512
5 CHANNEL_CODE CHARACTER VARYING(512) 512
6 ACCOUNT_CODE CHARACTER VARYING(512) 512
7 PROJECT_CODE CHARACTER VARYING(512) 512
8 COST_CENTRE_CODE CHARACTER VARYING(512) 512
9 ACTUAL_FLAG CHARACTER VARYING(512) 512
10 CURRENCY_CODE CHARACTER VARYING(512) 512
11 LAST_REFRESHED_TIMESTAMP TIMESTAMP 8
12 AMOUNT NUMERIC(25,4) 19
13 CATEGORY_CODE CHARACTER VARYING(512) 512