[Home] [Help] [Dependency Information]
Object Name: | FV_SBR_DEFINITIONS_ACCTS# |
---|---|
Object Type: | VIEW |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SBR_LINE_ACCT_ID | NUMBER | (15) | Yes | |
SBR_BALANCE_TYPE | VARCHAR2 | (4) | Yes | |
SBR_LINE_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
SBR_ADDITIONAL_INFO | VARCHAR2 | (100) | ||
SEGMENT1 | VARCHAR2 | (25) | ||
SEGMENT2 | VARCHAR2 | (25) | ||
SEGMENT3 | VARCHAR2 | (25) | ||
SEGMENT4 | VARCHAR2 | (25) | ||
SEGMENT5 | VARCHAR2 | (25) | ||
SEGMENT6 | VARCHAR2 | (25) | ||
SEGMENT7 | VARCHAR2 | (25) | ||
SEGMENT8 | VARCHAR2 | (25) | ||
SEGMENT9 | VARCHAR2 | (25) | ||
SEGMENT10 | VARCHAR2 | (25) | ||
SEGMENT11 | VARCHAR2 | (25) | ||
SEGMENT12 | VARCHAR2 | (25) | ||
SEGMENT13 | VARCHAR2 | (25) | ||
SEGMENT14 | VARCHAR2 | (25) | ||
SEGMENT15 | VARCHAR2 | (25) | ||
SEGMENT16 | VARCHAR2 | (25) | ||
SEGMENT17 | VARCHAR2 | (25) | ||
SEGMENT18 | VARCHAR2 | (25) | ||
SEGMENT19 | VARCHAR2 | (25) | ||
SEGMENT20 | VARCHAR2 | (25) | ||
SEGMENT21 | VARCHAR2 | (25) | ||
SEGMENT22 | VARCHAR2 | (25) | ||
SEGMENT23 | VARCHAR2 | (25) | ||
SEGMENT24 | VARCHAR2 | (25) | ||
SEGMENT25 | VARCHAR2 | (25) | ||
SEGMENT26 | VARCHAR2 | (25) | ||
SEGMENT27 | VARCHAR2 | (25) | ||
SEGMENT28 | VARCHAR2 | (25) | ||
SEGMENT29 | VARCHAR2 | (25) | ||
SEGMENT30 | VARCHAR2 | (25) | ||
COUNTER | NUMBER | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
ACCT_NUMBER | VARCHAR2 | (30) | Yes | |
DIRECT_OR_REIMB_CODE | VARCHAR2 | (1) | ||
APPORTIONMENT_CATEGORY_CODE | VARCHAR2 | (1) | ||
CATEGORY_B_CODE | NUMBER | (3) | ||
PRC_CODE | NUMBER | (3) | ||
ADVANCE_CODE | VARCHAR2 | (1) | ||
AVAILABILITY_TIME | VARCHAR2 | (1) | ||
BEA_CATEGORY_CODE | VARCHAR2 | (1) | ||
BORROWING_SOURCE_CODE | VARCHAR2 | (1) | ||
TRANSACTION_PARTNER | VARCHAR2 | (1) | ||
YEAR_OF_BUDGET_AUTHORITY | VARCHAR2 | (3) | ||
PRIOR_YEAR_ADJUSTMENT | VARCHAR2 | (1) | ||
TAFS_STATUS | VARCHAR2 | (1) | ||
AVAILABILITY_TYPE | VARCHAR2 | (1) | ||
EXPIRATION_FLAG | VARCHAR2 | (1) | ||
FINANCING_ACCOUNT_CODE | VARCHAR2 | (1) | ||
AUTHORITY_TYPE | VARCHAR2 | (1) | ||
FUND_TYPE | VARCHAR2 | (2) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
NBFA_COL | VARCHAR2 | (1) | ||
BUD_COL | VARCHAR2 | (1) | ||
SBR_TREASURY_SYMBOL_ID | NUMBER | (15) | ||
ATTRIBUTE13 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT SBR_LINE_ACCT_ID
, SBR_BALANCE_TYPE
, SBR_LINE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SBR_ADDITIONAL_INFO
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, COUNTER
, SET_OF_BOOKS_ID
, ACCT_NUMBER
, DIRECT_OR_REIMB_CODE
, APPORTIONMENT_CATEGORY_CODE
, CATEGORY_B_CODE
, PRC_CODE
, ADVANCE_CODE
, AVAILABILITY_TIME
, BEA_CATEGORY_CODE
, BORROWING_SOURCE_CODE
, TRANSACTION_PARTNER
, YEAR_OF_BUDGET_AUTHORITY
, PRIOR_YEAR_ADJUSTMENT
, TAFS_STATUS
, AVAILABILITY_TYPE
, EXPIRATION_FLAG
, FINANCING_ACCOUNT_CODE
, AUTHORITY_TYPE
, FUND_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE14
, ATTRIBUTE15
, NBFA_COL
, BUD_COL
, SBR_TREASURY_SYMBOL_ID
, ATTRIBUTE13
FROM FV.FV_SBR_DEFINITIONS_ACCTS#;
|
|
|