[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JAI_CMN_INVENTORY_ORGS |
|---|---|
| Object Type: | TABLE |
| Owner: | JA |
| FND Design Data: |  JA.JAI_CMN_INVENTORY_ORGS
|
| Subobject Name: | |
| Status: | VALID |
Setup table, which stores information of Organizations/Locations, EC Code and also Accounting Information for Localization.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JAI_CMN_INVENTORY_ORGS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ORG_UNIT_ID
|
| JAI_CMN_INVENTORY_ORGS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
|
| JAI_CMN_INVENTORY_ORGS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOCATION_ID
ORGANIZATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORG_UNIT_ID | NUMBER | (15) | Yes | Indicates a Unique Field for each Record. |
| ORGANIZATION_ID | NUMBER | (15) | Yes | Organization Identifier. |
| LOCATION_ID | NUMBER | (15) | Yes | Location Identifier. |
| SCRAP_COST_ACCOUNT_ID | NUMBER | (15) | Indicates the Scrap Cost Account Identifier. | |
| EXCISE_RETURN_DAYS | NUMBER | (15) | Indicates the Days for Excise Return. | |
| EXCISE_DUTY_REGION | VARCHAR2 | (50) | Indicates the Excise Duty Region for Manufacturing Organization. | |
| EXCISE_DUTY_ZONE | VARCHAR2 | (50) | Indicates the Excise Duty Zone for Manufacturing Organization. | |
| EXCISE_DUTY_REG_NO | VARCHAR2 | (50) | Indicates the Excise Duty Registration No for Manufacturing Organization. | |
| EXCISE_DUTY_RANGE | VARCHAR2 | (50) | Indicates the Excise Duty Range for Manufacturing Organization. | |
| EXCISE_DUTY_DIVISION | VARCHAR2 | (50) | Indicates the Excise Duty Division for Manufacturing Organization. | |
| EXCISE_DUTY_CIRCLE | VARCHAR2 | (50) | Indicates the Excise Duty Circle for Manufacturing Organization. | |
| EXCISE_DUTY_COMM | VARCHAR2 | (50) | Indicates the Excise Duty Commissionerate for Manufacturing Organization. | |
| EC_CODE | VARCHAR2 | (50) | Indicates the EC Code for Manufacturing Organization. | |
| ST_REG_NO | VARCHAR2 | (50) | Indicates the Sales Tax Registration No for the Organization. | |
| CST_REG_NO | VARCHAR2 | (50) | Indicates the Central Sales Tax Registration No for the Organization. | |
| EXCISE_EXPENSE_ACCOUNT | NUMBER | (15) | Indicates the Excise Expense Account. | |
| EXCISE_PAID_ACCOUNT | NUMBER | (15) | Indicates the Excise Paid Account. | |
| EXCISE_RCVBLE_ACCOUNT | NUMBER | (15) | Indicates the Excise Receivable Account. | |
| PAN_NO | VARCHAR2 | (30) | Indicates the Permanent Account Number of the Organization. | |
| TAN_NO | VARCHAR2 | (30) | Indicates the Tax Account Number of the Organization. | |
| WARD_NO | VARCHAR2 | (50) | Indicates the Ward Number of the Organization. | |
| MODVAT_RM_ACCOUNT_ID | NUMBER | (15) | Indicates the Modvat (Raw Materials) Account Identifier. | |
| MODVAT_CG_ACCOUNT_ID | NUMBER | (15) | Indicates the Modvat (Capital Goods) Account Identifier. | |
| MODVAT_PLA_ACCOUNT_ID | NUMBER | (15) | Indicates the Modvat (PLA) Account Identifier. | |
| BOE_ACCOUNT_ID | NUMBER | (15) | Indicates the Bill of Entry Account Identifier. | |
| PREF_RG23A | NUMBER | (9) | The Preference for RG23A Register (Possible Values 1,2,3,Null). | |
| PREF_RG23C | NUMBER | (9) | The Preference for RG23C Register (Possible Values 1,2,3,Null). | |
| PREF_PLA | NUMBER | (9) | The Preference for PLA Register (Possible Values 1,2,3,Null). | |
| OSP_RETURN_DAYS | NUMBER | (15) | Indicates the Days before which the Material is to be Returned for Outside Processing. | |
| OSP_EXCISE_PERCENT | NUMBER | Indicates the Excise Percent for the Outside Processing Transaction. | ||
| SALES_RETURN_DAYS | NUMBER | (15) | Indicates the Days for the Sales Return. | |
| RECEIPT_MODIFY_FLAG | VARCHAR2 | (1) | Indicates whether the Receipt Created in this Organization can be Modified or not(Possible Values Y and N). | |
| SSI_UNIT_FLAG | VARCHAR2 | (1) | This column is being used for tracking allow negative PLA flag. | |
| DAYS_ALLOWED_173L | NUMBER | (15) | Indicates the Days Allowed for 173L. | |
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| TR_EXCISE_DUTY_REGION | VARCHAR2 | (50) | Indicates the Excise Region for Trading Organization. | |
| TR_EXCISE_DUTY_ZONE | VARCHAR2 | (50) | Indicates the Excise Zone for Trading Organization. | |
| TR_EXCISE_DUTY_REG_NO | VARCHAR2 | (50) | Indicates the Excise Registration Number for Trading Organization. | |
| TR_EXCISE_DUTY_RANGE | VARCHAR2 | (50) | Indicates the Excise Range for Trading Organization. | |
| TR_EXCISE_DUTY_DIVISION | VARCHAR2 | (50) | Indicates the Excise Division for Trading Organization. | |
| TR_EXCISE_DUTY_CIRCLE | VARCHAR2 | (50) | Indicates the Excise Circle for Trading Organization. | |
| TR_EXCISE_DUTY_COMM | VARCHAR2 | (50) | Indicates the Excise Commissionerate for Trading Organization. | |
| TR_EC_CODE | VARCHAR2 | (50) | Indicates the EC code for Trading Organization. | |
| TRADING | VARCHAR2 | (2) | Indicates whether it is a Trading Organization(Possible Values Y,N or Null). | |
| MANUFACTURING | VARCHAR2 | (2) | Indicates whether it is a Manufacturing Organization(Possible Values Y,N or Null). | |
| EXCISE_23D_ACCOUNT | NUMBER | (15) | Indicates the RG23D Account. | |
| MODVAT_REVERSE_ACCOUNT_ID | NUMBER | (15) | Indicates the Modvat Reversal Account Identifier. | |
| MODVAT_REVERSE_PERCENT | NUMBER | (15) | Indicates the Modvat Reverse Percent. | |
| CUSTOMS_WRITE_OFF_ACCOUNT | NUMBER | (15) | Customs Write Off Account. | |
| CENVAT_RCVBLE_ACCOUNT | NUMBER | (15) | Cenvat Receivable Account. | |
| MASTER_ORG_FLAG | VARCHAR2 | (1) | Master Org Flag(Possible Values Y and N). | |
| MASTER_ORGANIZATION_ID | NUMBER | (15) | Master Organization Identifier. | |
| RTV_ACCOUNT_FLAG | VARCHAR2 | (1) | RTV Account Flag(Possible Values Y and N). | |
| RTV_EXPENSE_ACCOUNT_ID | NUMBER | (15) | RTV Expense Account Identifier. | |
| COST_FLAG | VARCHAR2 | (1) | Cost Flag (Possible Values Y and N). | |
| EXPORT_ORIENTED_UNIT | VARCHAR2 | (2) | Indicates whether the Organization-Location Combination is an Export Oriented Unit (Possible Values Y and N). | |
| EXCISE_INVNO_AT_EC_CODE | VARCHAR2 | (2) | Indicates whether Excise Invoice Number is to be Generated at EC Code Level(Possible Values Y and N). | |
| VAT_REG_NO | VARCHAR2 | (50) | VAT Registration Number of the Organization. | |
| CURRENT_NUMBER | NUMBER | The Current Number for VAT Invoice Number. | ||
| JUMP_BY | NUMBER | The Increment Number for VAT Invoice Number. | ||
| PREFIX | VARCHAR2 | (50) | The Prefix for VAT Invoice Number. | |
| EXCISE_IN_RG23D | VARCHAR2 | (2) | Indicates whether Excise needs to be added to Inventory cost or should be accounted. (Possible Values are Y and N) | |
| ORDER_PRICE_EXCISE_INCLUSIVE | VARCHAR2 | (2) | Indicates whether Order Price includes the excise type of taxes | |
| RG_ROUNDING_ACCOUNT_ID | NUMBER | (15) | RG Rounding account identifier | |
| CESS_PAID_PAYABLE_ACCOUNT_ID | NUMBER | (15) | Indicates the Cess Account | |
| EXCISE_EDU_CESS_RM_ACCOUNT | NUMBER | (15) | Excise Education Cess account for RM Items | |
| EXCISE_EDU_CESS_CG_ACCOUNT | NUMBER | (15) | Excise Education Cess account for CG Items | |
| EXCISE_EDU_CESS_RCVBLE_ACCNT | NUMBER | (15) | Intermediate account for Excise amount incase of CG items and ISO cases | |
| EXCISE_EDU_CESS_RND_ACCNT | NUMBER | (15) | Indicates the Rounding account for Excise | |
| DEFAULT_LOCATION_BILL_ONLY | NUMBER | Location Used for AR Invoice created through Bill Only work flow | ||
| TAX_CHANGE_ON_OPEN_INT_RECPTS | VARCHAR2 | (2) | If value is "Y", taxes will be allowed to changed on receipts imported through Receipts Open Interface. If "N", taxes will not be allowed to change | |
| TAX_CHANGE_ON_WMS_RECPTS | VARCHAR2 | (2) | If value is "Y", taxes will be allowed to changed on receipts created from Warehouse Management. If "N", taxes will not be allowed to change | |
| VAT_RETURN_DAYS | NUMBER | (15) | RMA Credit can be availed only if it happened before this many number of days after shipment | |
| OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
| DSPTCH_EXCEED_ORG_QTY_FLAG | VARCHAR2 | (1) | Flag which indicates whether dispatch quantity can exceed original quantity | |
| QUANTITY_REGISTER_UPDATE_EVENT | VARCHAR2 | (30) | Indicates the event when quantity register should be updated | |
| SH_CESS_CG_ACCOUNT_ID | NUMBER | Indicates the SH Cess accounting code combination identifier for Capital Goods | ||
| SH_CESS_PAID_PAYABLE_ACCT_ID | NUMBER | Indicates the SH Cess payable accounting code combination identifier | ||
| SH_CESS_RCVBLE_ACCT_ID | NUMBER | Indicates the SH Cess receivable accounting code combination identifier | ||
| SH_CESS_RM_ACCOUNT | NUMBER | Indicates the SH Cess accounting code combination identifier for Raw Materials | ||
| SH_CESS_RND_ACCOUNT_ID | NUMBER | Indicates the SH Cess rounding accounting code combination identifier | ||
| EXC_SHPT_WO_EXC_TAX_FLAG | VARCHAR2 | (1) | This column reflects if system should allow a excise shipment without excise taxes | |
| ALLOW_NEGATIVE_RG_FLAG | VARCHAR2 | (1) | Option to allow negative quanitity balance in RG | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context field | |
| CENVAT_CR_REVRSL_FLAG | VARCHAR2 | (1) | CVD credit reversal for Return to Vendor Transaction |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_UNIT_ID
, ORGANIZATION_ID
, LOCATION_ID
, SCRAP_COST_ACCOUNT_ID
, EXCISE_RETURN_DAYS
, EXCISE_DUTY_REGION
, EXCISE_DUTY_ZONE
, EXCISE_DUTY_REG_NO
, EXCISE_DUTY_RANGE
, EXCISE_DUTY_DIVISION
, EXCISE_DUTY_CIRCLE
, EXCISE_DUTY_COMM
, EC_CODE
, ST_REG_NO
, CST_REG_NO
, EXCISE_EXPENSE_ACCOUNT
, EXCISE_PAID_ACCOUNT
, EXCISE_RCVBLE_ACCOUNT
, PAN_NO
, TAN_NO
, WARD_NO
, MODVAT_RM_ACCOUNT_ID
, MODVAT_CG_ACCOUNT_ID
, MODVAT_PLA_ACCOUNT_ID
, BOE_ACCOUNT_ID
, PREF_RG23A
, PREF_RG23C
, PREF_PLA
, OSP_RETURN_DAYS
, OSP_EXCISE_PERCENT
, SALES_RETURN_DAYS
, RECEIPT_MODIFY_FLAG
, SSI_UNIT_FLAG
, DAYS_ALLOWED_173L
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TR_EXCISE_DUTY_REGION
, TR_EXCISE_DUTY_ZONE
, TR_EXCISE_DUTY_REG_NO
, TR_EXCISE_DUTY_RANGE
, TR_EXCISE_DUTY_DIVISION
, TR_EXCISE_DUTY_CIRCLE
, TR_EXCISE_DUTY_COMM
, TR_EC_CODE
, TRADING
, MANUFACTURING
, EXCISE_23D_ACCOUNT
, MODVAT_REVERSE_ACCOUNT_ID
, MODVAT_REVERSE_PERCENT
, CUSTOMS_WRITE_OFF_ACCOUNT
, CENVAT_RCVBLE_ACCOUNT
, MASTER_ORG_FLAG
, MASTER_ORGANIZATION_ID
, RTV_ACCOUNT_FLAG
, RTV_EXPENSE_ACCOUNT_ID
, COST_FLAG
, EXPORT_ORIENTED_UNIT
, EXCISE_INVNO_AT_EC_CODE
, VAT_REG_NO
, CURRENT_NUMBER
, JUMP_BY
, PREFIX
, EXCISE_IN_RG23D
, ORDER_PRICE_EXCISE_INCLUSIVE
, RG_ROUNDING_ACCOUNT_ID
, CESS_PAID_PAYABLE_ACCOUNT_ID
, EXCISE_EDU_CESS_RM_ACCOUNT
, EXCISE_EDU_CESS_CG_ACCOUNT
, EXCISE_EDU_CESS_RCVBLE_ACCNT
, EXCISE_EDU_CESS_RND_ACCNT
, DEFAULT_LOCATION_BILL_ONLY
, TAX_CHANGE_ON_OPEN_INT_RECPTS
, TAX_CHANGE_ON_WMS_RECPTS
, VAT_RETURN_DAYS
, OBJECT_VERSION_NUMBER
, DSPTCH_EXCEED_ORG_QTY_FLAG
, QUANTITY_REGISTER_UPDATE_EVENT
, SH_CESS_CG_ACCOUNT_ID
, SH_CESS_PAID_PAYABLE_ACCT_ID
, SH_CESS_RCVBLE_ACCT_ID
, SH_CESS_RM_ACCOUNT
, SH_CESS_RND_ACCOUNT_ID
, EXC_SHPT_WO_EXC_TAX_FLAG
, ALLOW_NEGATIVE_RG_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, CENVAT_CR_REVRSL_FLAG
FROM JA.JAI_CMN_INVENTORY_ORGS;
JA.JAI_CMN_INVENTORY_ORGS does not reference any database object
JA.JAI_CMN_INVENTORY_ORGS is referenced by following:
JA
JAI_CMN_INVENTORY_ORGS#
|
|
|
|