Results for “dr_invoice_date”
44 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JAI_CMN_RG_PLA_TRXS is a transaction register table owned by the JA schema within the Oracle E-Business Suite Asia/Pacific Localizations product (JA). In Oracle EBS 12.1.1 and 12.2.2 it stores the transaction information of the PLA (Price List Adjustment / excise-related register used in Indian localization scope) Register. Each row captures a register entry recording opening and closing balances, credit and debit components of excise duty, and associated document, vendor, item, bank, and accounting references.
Under a heuristic Data Vault classification derived from the foreign-key structure, this table leans toward a satellite. The primary key JAI_CMN_RG_PLA_TRXS_PK on REGISTER_ID acts as a surrogate key, and the many outbound foreign keys to reference and master data (items, parties, locations, GL accounts) suggest it functions primarily as a descriptive transactional record linked to core EBS master entities rather than acting as a hub or link itself.
Key Information Stored
The table contains 69 documented columns. The most significant are:
- REGISTER_ID — the surrogate primary key identifying each PLA register transaction row.
- FIN_YEAR, ORGANIZATION_ID, LOCATION_ID, SLNO — business-key candidate combination enforced by unique index JAI_CMN_RG_PLA_TRXS_UK1, scoping a transaction to a financial year, inventory organization, and location.
- TRANSACTION_DATE, ENTRY_DATE — the transactional and bookkeeping dates.
- INVENTORY_ITEM_ID — the item involved, referencing JAI_INV_ITM_SETUPS.
- VENDOR_ID, VENDOR_SITE_ID, VENDOR_CUST_FLAG — vendor/customer identification and party type.
- OPENING_BALANCE, CLOSING_BALANCE and the split BASIC/ADDITIONAL/OTHER OPENING and CLOSING BALANCE columns — duty balance positions by tax component.
- CR_BASIC_ED, CR_ADDITIONAL_ED, CR_OTHER_ED and DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED — credit and debit excise-duty amounts.
- TR6_CHALLAN_NO, TR6_CHALLAN_DATE, EXCISE_INVOICE_NO, DR_INVOICE_NO, DR_INVOICE_DATE, REF_DOCUMENT_ID, REF_DOCUMENT_DATE — excise document and challan references.
- CHARGE_ACCOUNT_ID — the GL accounting flexfield, referencing GL_CODE_COMBINATIONS.
- ROUNDING_ID, BOL_ID, BOLLINE_NO — links to rounding headers and bill-of-lading lines.
- POSTED_FLAG, MASTER_FLAG, ISSUE_TYPE, TRANSACTION_SOURCE_NUM — status and source control.
Common Use Cases and Queries
Typical usage covers excise/PLA register reporting, duty balance reconciliation, and posting control. A representative query retrieves register transactions for an organization and financial year:
- SELECT register_id, financial_year, slno, transaction_date, opening_balance, closing_balance, posted_flag FROM ja.jai_cmn_rg_pla_trxs WHERE organization_id = :org AND fin_year = :year ORDER BY slno;
- Balance reconciliation joins the item and party masters to validate closing balances and duty splits.
- Unposted transaction extraction: WHERE posted_flag = 'N' to identify entries pending posting.
- Excise document tracing by TR6_CHALLAN_NO or EXCISE_INVOICE_NO for statutory audit trails.
- Duty accounting analysis mapping CHARGE_ACCOUNT_ID to GL_CODE_COMBINATIONS for account-level summaries.
Related Objects
The table maintains significant relationships with the following objects:
- JAI_CMN_RG_PLA_CMP_DTLS — its detail table, joined on REGISTER_ID.
- JAI_INV_ITM_SETUPS (INVENTORY_ITEM_ID) and JAI_CMN_FIN_YEARS (ORGANIZATION_ID, FIN_YEAR) — item and financial-year masters.
- GL_CODE_COMBINATIONS (CHARGE_ACCOUNT_ID) — accounting flexfield values.
- HR_LOCATIONS_ALL (LOCATION_ID) — location master.
- HZ_PARTIES (VENDOR_ID) and HZ_PARTY_SITES (VENDOR_SITE_ID) — vendor party and site data.
- CE_BANK_ACCT_USES_ALL (BANK_BRANCH_ID) — bank account usage.
- JAI_CMN_RG_ROUND_HDRS (ROUNDING_ID) — rounding headers.
- OP_BILL_LAD (BOL_ID) — bill-of-lading line association.
-
Stores the Transaction Information of PLA Register.
-
Stores the Transaction Information of PLA Register.
-
View: JAI_RCV_RG_AMOUNT_V 12.2.2
APPS.JAI_RCV_RG_AMOUNT_V·↳ JAI_CMN_RG_23AC_II_TRXS·↳ JAI_CMN_RG_PLA_TRXS·Explore JA module →
-
View: JAI_RCV_RG_AMOUNT_V 12.1.1
APPS.JAI_RCV_RG_AMOUNT_V·↳ JAI_CMN_RG_23AC_II_TRXS·↳ JAI_CMN_RG_PLA_TRXS·Explore JA module →
-
eTRM - JA Tables and Views 12.1.1
The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table.
-
eTRM - JA Tables and Views 12.2.2
The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.