[Home] [Help]
[Dependency Information]
Object Name: | JA_CN_SOURCES_ALL |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
The 'JA_CN_SOURCES_ALL' table stores information of the project accounting, supplier, customer and third party, including the project accounting details.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | Yes | Identifier of Ledger | |
ACCOUNTING_STRUCTURE_CODE | VARCHAR2 | (30) | Yes | The code of the accounting structure |
ACCOUNTING_STRUCTURE_ID | NUMBER | Yes | Identifier of accounting structure | |
PROJECT_NOT_CONSIDERD_FLAG | VARCHAR2 | (1) | Flag to identify whether the project is condiderd | |
PROJECT_MODULE_FLAG | VARCHAR2 | (1) | Flag to identify the project module | |
PROJECT_AC_CODE | VARCHAR2 | (30) | Code of project accounting | |
PROJECT_AC_DETAIL_CODE | VARCHAR2 | (30) | Code of project accounting details | |
COA_FLAG | VARCHAR2 | (1) | Flag to identify the chart of account | |
THIRD_PARTY_AC_CODE | VARCHAR2 | (30) | Yes | Code of third party accounting |
CUSTOMER_DETAIL_CODE | VARCHAR2 | (30) | Yes | Code of customer details |
SUPPLIER_DETAIL_CODE | VARCHAR2 | (30) | Yes | Code of supplier details |
PERSONNEL_AC_CODE | VARCHAR2 | (30) | Yes | Code of personnel accounting |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
COA_SEGMENT | VARCHAR2 | (30) | Store the information that which field has the COA data |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, ACCOUNTING_STRUCTURE_CODE
, ACCOUNTING_STRUCTURE_ID
, PROJECT_NOT_CONSIDERD_FLAG
, PROJECT_MODULE_FLAG
, PROJECT_AC_CODE
, PROJECT_AC_DETAIL_CODE
, COA_FLAG
, THIRD_PARTY_AC_CODE
, CUSTOMER_DETAIL_CODE
, SUPPLIER_DETAIL_CODE
, PERSONNEL_AC_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, COA_SEGMENT
FROM JA.JA_CN_SOURCES_ALL;
JA.JA_CN_SOURCES_ALL does not reference any database object
JA.JA_CN_SOURCES_ALL is referenced by following:
|
|
|