Skip Headers

Oracle Financials and Oracle Procurement Functional Upgrade Guide: Release 11i to Release 12
Release 12.1
Part Number E13482-03
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Global Descriptive Flexfield Migration

This appendix covers the following topics:

Financials for Asia/Pacific

This section lists the changes to the Global Descriptive Flexfields for Oracle Financials for Asia/Pacific Release 12.

JG_AP_CHECKS

Feature Area Description of Change
Additional Thailand Information (JA.TH.APXPAWKB.CHECKS) Thai feature is obsolete and the context is disabled. The context had the following segments:
  • GA1: Tax Invoice Number

  • GA2: Tax Invoice Date

  • GA3: Supplier Tax Invoice Number

  • GA4: Tax Accounting Period

  • GA5: Payment Delivery Date

JG_AP_EXPENSE_REPORT_HEADERS

Feature Area Description of Change
Thai Additional Expense Information (JA.TH.APXXXEER.REPORT_HEADERS) Thai feature is obsolete and the context is disabled. The context had the following segments:
  • GA1: Tax Invoice Number

  • GA2: Tax Invoice Date

  • GA3: Supplier Tax Invoice Number

  • GA4: Tax Accounting Period

JG_AP_INVOICES

Feature Area Description of Change
Singaporean Additional Invoice Information (JA.SG.APXINWKB.INVOICES) GA1: Supplier Exchange Rate is now a named column: AP_INVOICES.SUPPLIER_TAX_EXCHANGE_RATE.
Taiwanese Additional Invoice Information (JA.TW.APXINWKB.INVOICES) Following segments are disabled and are now named columns:
  • GA1: Government Uniform Invoice Type as ZX_LINES_DET_FACTORS.DOCUMENT_SUBTYPE

  • GA2: Wine/Cigarette as ZX_FC_TYPES_B.PRODUCT_CATEGORY, ZX_FC_CODES_B.PRODUCT_CATEGORY, ZX_FC_CODES_DENORM_B.PRODUCT_CATEGORY PRODUCT_CATEGORY, ZX_FC_TYPES_B.WINE_CIGARETTE, MTL_CATEGORY_SETS.WINE_CIGARETTE, and MTL_CAEGORIES.WINE_CIGARETTE

  • GA3: Deductible Type as ZX_FC_TYPES_B.TRX_BUSINESS_CATEGORY, ZX_FC_CODES_B.TRX_BUSINESS_CATEGORY, and ZX_FC_CODES_DENORM_B.TRX_BUSINESS_CATEGORY

Thai Additional Invoice Information (JA.TH.APXINWKB.INVOICES) Thai feature is obsolete and the context is disabled. The context had the following segments:
  • GA1: Tax Invoice Number

  • GA2: Tax Invoice Date

  • GA3: Supplier Tax Invoice Number

  • GA4: Tax Accounting Period

JG_AP_INVOICES_INTERFACE

Feature Area Description of Change
Taiwanese Additional Invoice Information (JA.TW.APXIISIM.INVOICES_FOLDER) Following segments are replaced with named columns:
  • GA1: Government Uniform Invoice Type with ZX_LINES_DET_FACTORS.DOCUMENT_SUBTYPE

  • GA2: Wine/Cigarette with AP_INVOICE_LINES_ALL.PRODUCT_CATEGORY and ZX_LINES_DET_FACTORS.PRODUCT_CATEGORY

  • GA3: Deductible Type with ZX_LINES_DET_FACTORS.TRANSACTION_BUSINESS_CATEGORY

Thai Additional Invoice Information (JA.TH.APXIISIM.INVOICES_INTF) Thai feature is obsolete and the context is disabled. The context had the following segments:
  • GA1: Tax Invoice Number

  • GA2: Tax Invoice Date

  • GA3: Supplier Tax Invoice Number

  • GA4: Tax Accounting Period

JG_AP_TAX_CODES

Feature Area Description of Change
Korean Additional Information (JA.KR.APXTADTC.WITHHOLDING) GA1: Location Code is now a named column, ZX_REPORT_CODES_ASSOC.KR_BUSINESS_LOCATIONS.
Taiwanese Additional Tax Code Information (JA.TW.APXTADTC.TAX_CODES) GA1: Government Tax Type is now named columns:
  • ZX_STATUS_B.TAX_STATUS_CODE

  • ZX_REPORT_CODES_ASSOC. TW_GOVERNMENT_TAX_TYPE

Thai Additional Tax Code Information(JA.TH.APXTADTC.TAX_CODES) GA1: Tax Invoice Location is replaced by ZX_RATES_B.DEF_REC-SETTLEMENT-OPTION_CODE

JG_AR_VAT_TAX

Feature Area Description of Change
Korean Additional Information (JA.KR.ARXSUVAT.VAT) GA1: Location is replaced with ZX_REPORT_CODES_ASSOC.KR_BUSINESS_LOCATIONS/ KR_LOCATION.
Taiwanese Additional Tax Information (JA.TW.ARXSUVAT.VAT_TAX) GA1: Government Tax Type is now named columns: ZX_STATUS.TAX_STATUS_CODE, ZX_REPORT_CODES_ASSOC.TW_GOVERNMENT_TAX_TYPE, and ZX_RATES.TAX_STATUS_CODE.

JG_HR_LOCATIONS

Feature Area Description of Change
Korean Additional Information (JA.KR.PERWSLOC.WITHHOLDING) The following segments are replaced by named columns:
  • GA1: Tax Registration Number by ZX_PARTY_TAX_PROFILE.REP_REGISTRATION_NUMBER and XLE_REGISTRATIONS.REGISTRATION_NUMBER

  • GA4: Taxable Person by HZ_PARTIES.PARTY_NAME.

  • GA5: Industry Subclassification by XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE and XLE_ETB_PROFILES.ACTIVITY_CODE

  • GA6: Industry Classification by XLE_ENTITY_PROFILES.ACTIVITY_CODE, XLE_ETB_PROFILES.ACTIVITY_CODE

  • GA11: Corporate Identification Number is disabled.

Singaporean Additional Information (JA.SG.PERWSLOC.LOC) The following segments are replaced by named columns:
  • GA2: Job Title is replaced by HZ_ORG_CONTACTS.JOB_TITLE

  • GA3: Title is replaced by HZ_ORG_CONTACTS.TITLE

  • GA4: Taxable Person by HZ_PARTIES.PARTY_NUMBER

Taiwanese Additional Location Information (JA.TW.PERWSLOC.LOC) The following segments are replaced with named columns:
  • GA1: Taxpayer ID with ZX_PARTY_TAX_PROFILE.REP_REGISTRATION_NUMBER and ZX_REGISTRATIONS.TAX_REGISTRATION_NUMBER

  • GA2: Taxable Person by HZ_PARTIES.PARTY_NAME

JG_RA_CUSTOMER_TRX

Feature Area Description of Change
Taiwanese Additional Transaction Information (JA.TW.ARXTWMAI.RA_CUSTOMER_TRX) Following segments are disabled and are now named columns:
  • GA1: Government Uniform Invoice Type as ZX_LINES_DET_FACTORS.DOCUMENT_SUBTYPE

  • GA2: Wine/Cigarette as ZX_FC_TYPES_B.PRODUCT_CATEGORY, ZX_FC_CODES_B.PRODUCT_CATEGORY, ZX_FC_CODES_DENORM_B.PRODUCT_CATEGORY PRODUCT_CATEGORY, ZX_FC_TYPES_B.WINE_CIGARETTE, MTL_CATEGORY_SETS.WINE_CIGARETTE, and MTL_CAEGORIES.WINE_CIGARETT

  • GA3: Deductible Type as ZX_FC_TYPES_B.TRX_BUSINESS_CATEGORY, ZX_FC_CODES_B.TRX_BUSINESS_CATEGORY, and ZX_FC_CODES_DENORM_B.TRX_BUSINESS_CATEGORY

JG_RA_CUST_TRX_TYPES

Feature Area Description of Change
Thai Additional Transaction Information (JA.TH.RAXSUCTT.CUST_TRX_TYPES) Thai feature is Obsolete, and the context is disabled.

Financials for Europe

This section lists the changes to the Global Descriptive Flexfields for Oracle Financials for Europe Release 12.

Invoice EFT Details

Feature Area Description of Change
Belgian EFT Payments (BE.EFT Payments) JGZZ_INVOICE_INFO1: IBLC Code is replaced by AP_INVOICES_ALL.PAYMENT_REASON_ID.
Invoice Reference Text (FI.Vapaa viite) JGZZ_INVOICE_INFO1: JEFI_REFERENCE_TEXT is replaced by AP_INVOICES_ALL.REMITTANCE_MESSAGE1.
Invoice Reference Number (FI.Konekielinen viite) JGZZ_INVOICE_INFO1:JEFI_REFERENCE_NO is replaced by AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFER.
JGZZ_INVOICE_INFO2: JEFI_REFERENCE_CHECK is replaced by AP_INVOICES_ALL.URI_CHECK_DIGIT.
Long Text (FI.Viesti) The following segments are replaced by named columns:
  • JGZZ_INVOICE_INFO2: JEFI_SHORT_MESSAGE by AP_INVOICES_ALL.REMITTANCE_MESSAGE1

  • JGZZ_INVOICE_INFO3: JEFI_LONG_MESSAGE_1 by AP_INVOICES_ALL.REMITTANCE_MESSAGE2

  • JGZZ_INVOICE_INFO4: JEFI_LONG_MESSAGE_2 by AP_INVOICES_ALL.REMITTANCE_MESSAGE3.

Netherlands EFT Information (NL.Foreign Payments) The following segments are replaced by named columns:
  • JGZZ_INVOICE_INFO1: Payment Category Code by AP_INVOICES_ALL.PAYMENT_REASON_ID

  • JGZZ_INVOICE_INFO10: Goods Code by AP_INVOICES_ALL.PAYMENT_REASON_COMMENTS

  • JGZZ_INVOICE_INFO11: Payment Nature by AP_INVOICES_ALL.PAYMENT_REASON_COMMENTS.

Norwegian EFT Information (NO.Norway) The following segments are replaced by named columns:
  • JGZZ_INVOICE_INFO1: KID by AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFER

  • JGZZ_INVOICE_INFO2: Declaration Code by AP_INVOICES_ALL.PAYMENT_REASON_ID

  • JGZZ_INVOICE_INFO3: Declaration Descr. by AP_INVOICES_ALL.PAYMENT_REASON_COMMENTS

  • JGZZ_INVOICE_INFO4: Urgency Called by AP_INVOICES_ALL.SETTLEMENT_PRIORITY

  • JGZZ_INVOICE_INFO5: Message to Vendor by AP_INVOICES_ALL.REMITTANCE_MESSAGE1.

Swedish EFT Bankgiro Inland (SE.Bankgiro Inland),Swedish EFT Postgiro Inland (SE.Postgiro Inland) The following segments are replaced by named columns:
  • JGZZ_INVOICE_INFO1: Message Row 1 by AP_INVOICES_ALL.REMITTANCE_MESSAGE1

  • JGZZ_INVOICE_INFO4: Message Row 2 by AP_INVOICES_ALL.REMITTANCE_MESSAGE2

Swedish EFT Bankgiro SISU (SE.Bankgiro SISU) and Swedish EFT Bankgiro UTLI (SE.Bankgiro UTLI) The following segments are replaced by named columns:
  • JGZZ_INVOICE_INFO1: Federal Reserve Code by AP_INVOICES_INTERFACE.PAYMENT_REASON_ID

  • JGZZ_INVOICE_INFO2: Express Invoice by AP_INVOICES_ALL.SETTLEMENT_PRIORITY


JGZZ_INVOICE_INFO3: Invoice Charge Code and JGZZ_INVOICE_INFO4: Future Contract are obsolete.
Swedish EFT Postgiro Utland The following segments are replaced by named columns:
  • JGZZ_INVOICE_INFO1: Federal Reserve Code by AP_INVOICES_INTERFACE.PAYMENT_REASON_ID

  • JGZZ_INVOICE_INFO2: Express Payment by AP_INVOICES_ALL.SETTLEMENT_PRIORITY


JGZZ_INVOICE_INFO3: Future Contract Postgiro is obsolete.
Swiss DTA EFT Invoice Format (CH.Swiss DTA Payment)Swiss SAD EFT Invoice Format (CH.Swiss SAD Payment) JGZZ_INVOICE_INFO1: ESR Number is replaced by AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFER.
Tax (FI.Vero) The following segments are replaced by named columns:
  • JGZZ_INVOICE_INFO1: JEFI_TAX_REFERENCE by AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFER.

  • JGZZ_INVOICE_INFO2: JEFI_TAX_TEXT by AP_INVOICES_ALL.REMITTANCE_MESSAGE1

  • JGZZ_INVOICE_INFO3: JEFI_SHORT_MESSAGE by AP_INVOICES_ALL.REMITTANCE_MESSAGE2.

  • JGZZ_INVOICE_INFO4: JEFI_LONG_MESSAGE by AP_INVOICES_ALL.REMITTANCE_MESSAGE3.

JG_AP_BANK_ACCOUNTS

Feature Area Description of Change
Additional Bank Account Information (JE.DE.APXSUMBA.DD_CODE) GA1: DD_CODE is replaced by IBY_EXT_PAYERS_GLB.DIRECT_DEBIT_BANK_INSTRUCTION.
Additional EDI Information for Denmark (JE.DK.APXSUMBA.INT.EDI_INFO) The following segments are replaced by named columns:
  • GA1: Communication Agreement ID by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • GA2: Bank Code by HZ_ORGANIZATION_PROFILES.BANK_CODE.

  • GA3: JEDK_EDI_UBT_NUMBER is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE.

  • GA4: JEDK_EDI_USER_NAME is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE.

  • GA5: JEDK_EDI_PASSWORD is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE.

  • GA6: JEDK_EDI_SENDER_ID is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE.

Additional EDI Information for Denmark (JE.DK.APXSUMBA.SUP.EDI_INFO) The following segments are obsolete:
  • GA1: JEDK_EDI_SEQUENCE_NUMBER

  • GA 2: JEDK_EDI_PAYMENT_CHANNEL

  • GA6: JEDK_EDI_AGREEMENT_TYPE

  • GA7: JEDK_EDI_AGREEMENT_NUMBER

  • GA 18: JEDK_EDI_SEQUENCE_NUMBER

  • GA 19: JEDK_EDI_DUMMY


The following segments are replaced by named columns:
  • GA3: JEDK_EDI_COUNTRY_CODE by: HZ_PARTIES.HOME_COUNTRY, HZ_ORGANIZATION_PROFILES.HOME_COUNTRY, and HZ_PARTIES.COUNTRY.

  • GA4: JEDK_EDI_BANK_CODE by HZ_ORGANIZATION_PROFILES.BANK_CODE.

  • GA5: JEDK_EDI_IMPORT_CODE by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_REASON_ID

  • GA8: JEDK_EDI_SETTLEMENT_CODE by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER

  • GA9: JEDK_EDI_SHORT_NOTICE by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_TEXT_MESSAGE1

  • GA10: JEDK_EDI_BANK_NOTICE by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_TEXT_MESSAGE2

  • GA20: JEDK_EDI_PAYMENT_CATEGORY by payment method field on supplier.

Swedish EFT Processes (JE.SE.APXSUMBA.PAYMENT_TYPE) GA1: Payment type is replaced by a named column, IBY_EXT_PAYEE_ATTRIBS.DELIVERY_CHANNEL_ID.

JG_AP_BANK_BRANCHES

Feature Area Description of Change
Bank Taxpayer ID Info (JE.ES.APXSUMBA.BANK_INFO) GA1: Taxpayer ID is replaced by a named column, HZ_PARTIES.JGZZ_FISCAL_CODE.

JG_AP_INVOICE_DISTRIBUTIONS

Feature Area Description of Change
Additional Info. for Spanish Invoice Distributions (JE.ES.APXINWKB_DISTS.INV_DIST) The following segments are obsolete:
  • GA1: Corrected Distribution

  • GA2: Year Corrected

  • GA3: Period Corrected

Additional Invoice Distribution Information (JE.HU.APXINWKB.STAT_CODE) The following segments are obsolete:
  • GA1: Tax Date

  • GA2: Start Date

  • GA3: End Date

  • GA4: Balancing Segment

  • GA5: Tax Origin


GA6: STAT_CODE is replaced by PRODUCT_FISC_CLASSIFICATION in the following tables:
  • AP_INVOICE_LINES_ALL

  • ZX_LINES_DET_FACTORS


GA6: STAT_CODE is replaced by STATISTICAL_CODE, in the following tables:
  • ZX_FC_TYPES_B

  • MTL_CATEGORIES_SETS

  • MTL_CATEGORIES


GA6: STAT_CODE is replaced by PRODUCT_CATEGORY in the following tables:
  • ZX_FC_TYPES_B

  • ZX_FC_CODES_B

  • ZX_FC_CODES_DENORM_B

Additional Invoice Distribution Information (JE.IT.APXINWKB.DISTRIBUTIONS) GA1: Taxable Amount is replaced by a named column, ASSESSABLE_VALUE, in tables:
  • AP_INVOICE_LINES_ALL

  • ZX_LINES_DET_FACTORS.

Additional Invoice Distribution Information (JE.PL.APXINWKB.STAT_CODE) GA1: STAT_CODE is replaced by a named column, STATISTICAL_CODE, in the following tables:
  • ZX_FC_TYPES_B

  • MTL_CATEGORIES_SETS

  • MTL_CATEGORIES


GA1: STAT_CODE is replaced by PRODUCT_CATEGORY in the following tables:
ZX_FC_TYPES_B
ZX_FC_CODES_B
ZX_FC_CODES_DENORM_B
Czech Invoice Distribution Information (JE.CZ.APINXWKB.FINAL) GA1: Final VAT Register Request ID is obsolete.
Hungarian Invoice Distribution Information (JE.HU.APINXWKB.FINAL) The following segments are obsolete:
  • GA1: Final VAT Register Request ID

  • GA2: Statistical Code

JG_AP_INVOICE_LINES_INTERFACE

Feature Area Description of Change
Czech Invoice Distribution Information (JE.CZ.APXIISIM.FINAL),Hungarian Invoice Distribution Information (JE.HU.APXIISIM.FINAL),Polish Invoice Distribution Information (JE.PL.APXIISIM.FINAL), andSlovak Invoice Distribution Information (JE.SK.APXIISIM.FINAL) GA1: Final VAT Register Request ID is replaced by the named column, JG_ZZ_VAT_TRX_DETAILS.FINAL_REPORTING_ID.
HungarianAdditional Invoice Distribution Information (JE.HU.APXIISIM.STAT_CODE) The following segments are obsolete:
  • GA1: Tax Type

  • GA2: Start Date

  • GA3: End Date

  • GA4: Tax Origin


GA5: Statistical Code is replaced by AP_INVOICE_LINES_ALL.PRODUCT CATEGORY and ZX_LINES_DET_FACTORS.PRODUCT_CATEGORY.
Italian Invoice Distribution Information (JE.IT.APXIISIM.DISTRIBUTIONS) The following segments are replaced by named columns:
  • GA1: Taxable Amount by ZX_LINES_DET_FACTORS.ASSESSABLE_VALUE

  • GA2: Deferred Expense by AP_INVOICE_LINES_ALL.DEFERRED_ACCTG_FLAG

  • GA3: Deferred Expense Account by AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID

  • GA4: Deferred Expense Date by AP_INVOICE_LINES_ALL.DEF_ACCTG_START_DATE

Polish Invoice Distribution Information (JE.PL.APINXWKB.FINAL) and Slovak Invoice Distribution Information (JE.SK.APINXWKB.FINAL) GA1: Final VAT Register Request ID is obsolete.
Polish Additional Invoice Distribution Information (JE.PL.APXIISIM.STAT_CODE) GA1: Statistical Code is replaced by AP_INVOICE_LINES_ALL.PRODUCT CATEGORY and ZX_LINES_DET_FACTORS.PRODUCT_CATEGORY.

JG_AP_INVOICES

Feature Area Description of Change
Additional EDI Information for Denmark (JE.DK.APXINWKB.EDI_INFO) The following segments are obsolete:
  • GA1: JEDK_EDI_PAYMENT_MEANS

  • GA2: JEDK_EDI_PAYMENT_CHANNEL

  • GA3: JEDK_EDI_COUNTRY_CODEGA18: JEDK_EDI_SEQUENCE_NUMBER

  • GA19: JEDK_EDI_DUMMY


The following segments are replaced by named columns:
  • GA4: JEDK_EDI_PARTY_ID by AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFIER

  • GA5: JEDK_EDI_IMPORT_CODE by AP_INVOICES_ALL.PAYMENT_REASON_ID

  • GA6: JEDK_EDI_SUPPLIER_MESSAGE by AP_INVOICES_ALL.REMITTANCE_MESSAGE1

  • GA7: JEDK_EDI_IMPORT_TEXT by AP_INVOICES_ALL.PAYMENT_REASON_COMMENTS

  • GA8: JEDK_EDI_SETTLEMENT_CODE by AP_INVOICES_ALL.BANK_CHARGE_BEARER

  • GA20: JEDK_EDI_PAYMENT_CATEGORY by AP_INVOICES_ALL.PAYMENT_METHOD

Additional Invoice Information (JE.CZ.APXINWKB.INVOICE_INFO) The following segments are obsolete:
  • GA2: VAT_REGISTER_TRX

  • GA5: Data Type

  • GA6: Constant Symbol

  • GA7: Specific Symbol


GA1: TAX_DATE is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE.
GA3: IMPORT_DOC_NUM is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_NUMBER.
Additional Invoice Information (JE.HU.APXINWKB.TAX_DATE) GA1: Tax Date is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE.
Additional Invoice Information for France (JE.FR.APXINWKB.TAX_RULE) GA1: Deduction Tax Rule is replaced by ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE.
Additional Information for Spanish Invoices (JE.ES.APXINWKB.INVOICE_INFO) The following segments are obsolete:
  • GA1: Invoice Type

  • GA2: Modelo 349 - Correction Year

  • GA3: Modelo 349 - Correction Period

Additional Tax Information (JE.PL.APXINWKB.INVOICE_INFO) GA2: VAT_REGISTER is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE
Slovak Additional Invoice Information (JE.SK.APXINWKB.INVOICE_INFO) GA1: Tax Date is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE.
Social Insurance Information (JE.PL.APXINWKB.INSURANCE_INFO) GA1: Insurance Premium Type is replaced by AP_INVOICES_ALL.PAYMENT_REASON_ID.
Spanish Payables Operations with Third Party Extract - Modelo 347 (JE.ES.APXINWKB.MODELO347PR),
Spanish Payables Inter-EU Operations Summary Data Extract - Modelo 349(JE.ES.APXINWKB.MODELO349),
Spanish Payables Canary Islands Annual Operations Data Extract -Modelo 415(JE.ES.APXINWKB.MODELO415),
Spanish Payables Operations with Third Party Extract − Modelo 347 and Spanish Payables Canary Islands Annual Operations − Modelo 415 (JE.ES.APXINWKB.MODELO415_347),
Spanish Payables Operations with Third Party Extract − Modelo 347 and Spanish Payables Canary Islands Annual Operations − Modelo 415 (JE.ES.APXINWKB.MODELO415_347PR), and
Spanish Receivables Invoice Type : Other (JE.ES.ARXTWMAI.OTHER)
GA1: Invoice Type is replaced by TRX_BUSINESS_CATEGORY in the following tables:
  • ZX_FC_TYPES_B

  • ZX_FC_CODES_B

  • ZX_FC_CODES_DENORM_B

  • ZX_LINES_DET_FACTORS

JG_AP_INVOICES_INTERFACE

Feature Area Description of Change
Additional EDI Information for Denmark (JE.DK.APXIISIM.EDI_INFO) The following segments are obsolete:
  • GA1: JEDK_EDI_PAYMENT_MEANS

  • GA2: JEDK_EDI_PAYMENT_CHANNEL

  • GA3: JEDK_EDI_COUNTRY_CODE

  • GA18: JEDK_EDI_SEQUENCE_NUMBER

  • GA19: JEDK_EDI_DUMMY


The following segments are replaced by named columns:
  • GA4: JEDK_EDI_PARTY_ID by AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFIER

  • GA5: JEDK_EDI_IMPORT_CODE by AP_INVOICES_INTERFACE.PAYMENT_REASON_ID

  • GA6: JEDK_EDI_SUPPLIER_MESSAGE by AP_INVOICES_INTERFACE.REMITTANCE_MESSAGE1

  • GA7: JEDK_EDI_IMPORT_TEXT by AP_INVOICES_ALL.PAYMENT_REASON_COMMENTS

  • GA8: JEDK_EDI_SETTLEMENT_CODE by AP_INVOICES_ALL.BANK_CHARGE_BEARER

  • GA20: JEDK_EDI_PAYMENT_CATEGORY by AP_INVOICES_INTERFACE.PAYMENT_METHOD

Additional Invoice Information (JE.CZ.APXIISIM.INVOICE_INFO) GA1: TAX_DATE is replaced by AP_INVOICES_ALL.TAX_INVOICE_RECORDING_DATE.GA3: IMPORT_DOC_NUM is replaced by AP.TAX_INVOICE_INTERNAL_SEQ
The following segments are obsolete:
  • GA4: IMPORT_DOC_DATE

  • GA5: Data Type

  • GA6: Constant Symbol

  • GA7: Specific Symbol

Additional Invoice Information (JE.HU.APXIISIM.TAX_DATE) GA1: TAX_DATE is replaced by AP_INVOICES_ALL.TAX_INVOICE_RECORDING_DATE.
Additional Invoice Information for France (JE.FR.APXIISIM.TAX_RULE) GA1: Deduction Tax Rule is replaced by ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE.
Additional Tax Information (JE.PL.APXIISIM.INVOICE_INFO) The following segments are replaced by named columns:
  • GA1: Message Row 1 by AP_INVOICES_INTERFACE.REMITTANCE_MESSAGE1

  • GA2: Message Row 1 by AP_INVOICES_INTERFACE.REMITTANCE_MESSAGE2

Belgium EFT Payments (JE.BE.APXIISIM.EFT) GA1: IBLC Code is replaced by named column, AP_INVOICES_INTERFACE.PAYMENT_REASON_ID.
Invoice Reference Number (JE.FI.APXIISIM.KKL_VIITE) The following segments are replaced by named columns:
  • GA1: JEFI_REFERENCE_NO by AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFIER

  • GA2: JEFI_REFERENCE_CHECK by AP_INVOICES_ALL.URI_CHECK_DIGIT.

Invoice Reference Text (JE.FI.APXIISIM.VAPAA_VIITE) GA1: JEFI_REFERENCE_TEXT is replaced by AP_INVOICES_INERFACE.REMITTANCE_MESSAGE1.
Netherlands EFT Information (JE.NL.APXIISIM.FOREIGN) The following segments are replaced by named columns:
  • GA1: Payment Category Code is replaced by AP_INVOICES_ALL.PAYMENT_REASON_ID

  • GA10: Goods Code by AP_INVOICES_ALL.PAYMENT_REASON_COMMENTS.

  • GA11: Payment Nature by AP_INVOICES_ALL.PAYMENT_REASON_COMMENTS.

Norwegian EFT Information (JE.NO.APXIISIM.NORWAY) The following segments are replaced by named columns:
  • GA1: Invoice Number by AP_INVOICES_INTERFACE.UNIQUE_REMITTANCE_IDENTIFER

  • GA2: Declaration Code by AP_INVOICES_ALL.PAYMENT_REASON_ID

  • GA3: Declaration Desc by AP_INVOICES_ALL.PAYMENT_REASON_COMMENTS

  • GA4: Urgency Called by AP_INVOICES_ALL.SETTLEMENT_PRIORITY

  • GA5: Message to Supplier by AP_INVOICES_INTERFACE.REMITTANCE_MESSAGE1

Slovak Invoice Interface Information (JE.SK.APXIISIM.INVOICE_INFO) GA1: Tax Date is replaced by AP.TAX_INVOICE_RECORDING_DATE.GA2: Check VAT Amount Paid is obsolete.
Spanish Invoice Type: Modelo 347 (JE.ES.APXIISIM.MODELO347),
Spanish Invoice Type: Modelo 347 - Property Rental (JE.ES.APXIISIM.MODELO347PR),
Spanish Invoice Type: Modelo 349(JE.ES.APXIISIM.MODELO349)
GA1: Invoice Type is replaced by TRX_BUSINESS_CATEGORY.ZX_LINES_DET_FACTORS.
Spanish Invoice Type: Modelo 347 (JE.ES.APXINWKB.MODELO347),
Spanish Invoice Type: Modelo 349(JE.ES.APXINWKB.MODELO349),
Spanish Invoice Type: Other (JE.ES.APXINWKB.OTHER)
GA1: Invoice Type is obsolete.
Spanish Invoice Type: Modelo 349 (JE.ES.APXINWKB.MODELO349) GA2: Correction Year and GA3: Correction Period are obsolete.
Social Insurance Information (JE.PL.APXIISIM.INSURANCE_INFO) GA1: Insurance Premium Type is replaced by AP.TAX_INVOICE_RECORDING_DATE
Swedish EFT Bankgiro SISU (JE.SE.APXIISIM.BANK_SISU) Swedish EFT Bankgiro UTLI (JE.SE.APXIISIM.BANK_UTLI) The following segments are replaced by named columns:
  • GA1: Federal Reserve Code by AP_INVOICES_INTERFACE.PAYMENT_REASON_ID

  • GA2: Express Invoice by AP_INVOICES_INTERFACE.SETTLEMENT_PRIORITY


GA3: Invoice Charge Code and GA4: Future Contract are obsolete.
Swedish EFT Postgiro Utland (JE.SE.APXIISIM.POST_UTLAND) The following segments are replaced by named columns:
  • GA1: Federal Reserve Code by AP_INVOICES_INTERFACE.PAYMENT_REASON_ID

  • GA2: Express Payment by AP_INVOICES_INTERFACE.SETTLEMENT_PRIORITY


GA3: Future Contract Postgiro is obsolete.
Swiss DTA EFT Invoice Format (JE.CH.APXIISIM.DTA) and Swiss SAD EFT Invoice Format (JE.CH.APXIISIM.SAD) GA1: ESR Number is replaced by named column, AP_INVOICES_ALL.UNIQUE_REMITTANCE_IDENTIFER.

JG_AP_REPORTING_ENTITIES

Feature Area Description of Change
Reporting Entity Information (JE.PT.APXTRDRE.TAX_INFO) The following segments are replaced by named columns:
  • GA1: Tax Office Location by HZ_LOCATIONS.CITY

  • GA2: Tax Office Code by HZ_LOCATIONS.ADDRESS_LINE_3

  • GA3: Tax Office Number by HZ_LOCATIONS.ADDRESS_LINE_2

  • GA4: SIC Code by XLE_ENTITY_PROFILES.ACTIVITY_CODE and XLE_ETB_PROFILES.ACTIVITY_CODE.

JG_AP_SYSTEM_PARAMETERS

Feature Area Description of Change
Italian Additional Information (JE.IT.APXCUMSP.SYS_PARAMETER) GA1: EXEMPTION_LIMIT_TAX_TAG is obsolete.
Netherlands Additional Information (JE.NL.APXCUMSP.SYS_PARAMETER) GA1: EFT_PAYMENT_SEPARATION is obsolete.

JG_AP_TAX_CODES

Feature Area Description of Change
Additional Swiss Tax Code Information (JE.CH.APXTADTC.TAX_INFO) GA1: Tax Regime is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.CH_VAT_REGIME.
Additional Tax Information (JE.CZ.APXTADTC.TAX_ORIGIN) GA1: Tax Origin is replaced by named columns, Z ZX_TAXES_B.TAX and X_REPORT_CODES_ASSOC.CZ_TAX_ORIGIN.
Additional Tax Information (JE.HU.APXTADTC.TAX_ORIGIN) GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.HU_TAX_ORIGIN.
Additional Tax Information (JE.PL.APXTADTC.TAX_ORIGIN) GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.PL_TAX_ORIGIN.
Portuguese Tax Box Information (JE.PT.APXTADTC.TAX_INFO) The following segments are replaced by named columns:
  • GA1: Location by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_LOCATION.

  • GA2: Periodic Taxable Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_PRD_TAXABLE_BOX.

  • GA3: Periodic: Recoverable Tax Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_PRD_REC_TAX_BOX.

  • GA4: Annual: Total Taxable Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_TTL_TAXABLE_BOX.

  • GA5: Annual: Recoverable Taxable by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_REC_TAXABLE.

  • GA6: Annual: Non Recoverable Taxable by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_NON_REC_TAXABLE.

  • GA7: Annual: Recoverable Tax Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_REC_TAX_BOX.

JG_AR_MEMO_LINES

Feature Area Description of Change
Additional Memo Line Information (JE.HU.ARXSTDML.STAT_CODE) and Additional Memo Line Information (JE.PL.ARXSTDML.STAT_CODE) GA1: STAT_CODE is replaced by STATISTICAL_CODE in the following tables:
  • ZX_FC_TYPES_B

  • MTL_CATEGORIES_SETS

  • MTL_CATEGORIES


GA1: STAT_CODE is replaced by PRODUCT_CATEGORY in the following tables:
  • AR_MEMO_LINES_ALL_B

  • ZX_FC_TYPES_B

  • ZX_FC_CODES_B

  • ZX_FC_CODES_DENORM_B

JG_AR_VAT_TAX

Feature Area Description of Change
Additional Tax Information (JE.CZ.ARXSUVAT.TAX_ORIGIN) GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.CZ_TAX_ORIGIN.
Additional Tax Information (JE.HU.ARXSUVAT.TAX_ORIGIN) GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.HU_TAX_ORIGIN.
Additional Tax Information (JE.PL.ARXSUVAT.TAX_ORIGIN) GA1: Tax Origin is replaced by named columns, ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.PL_TAX_ORIGIN.
Portuguese Tax Box Information (JE.PT.ARXSUVAT.TAX_INFO) The following segments are replaced by named columns:
GA1: Location by ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.PT_LOCATION.
GA2: Periodic Taxable Box by ZX_TAXES_B.TAX and ZX_REPORT_CODES_ASSOC.PT_PRD_TAXABLE_BOX.
GA3: Periodic: Recoverable Tax Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_PRD_REC_TAX_BOX.
GA4: Annual: Total Taxable Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_TTL_TAXABLE_BOX.
GA5: Annual: Recoverable Taxable by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_REC_TAXABLE.
GA6: Annual: Non Recoverable Taxable by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_NON_REC_TAXABLE.
GA7: Annual: Recoverable Tax Box by ZX_REPORTING_TYPES_B.REPORTING_TYPE_CODE, ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE, and ZX_REPORT_CODES_ASSOC.PT_ANL_REC_TAX_BOX.

JG_FA_ADDITIONS

Feature Area Description of Change
Greek Asset Information (JE.GR.FAXASSET.ASSET) The following segments are replaced by named columns:
  • GA1: Commitment by FA_ADDITIONS_B.COMMITMENT

  • GA2: Investment Law by FA_ADDITIONS_B.INVESTMENT_LAW

JG_GL_JE_HEADERS

Feature Area Description of Change
Greek Journal Information (JE.GR.GLXJEENT.HEADER) GA1: Accounting Sequence Name and GA2: Accounting Sequence Number are obsolete.

JG_GL_JE_LINES_INFO

Feature Area Description of Change
Czech Journal Lines Information (JE.CZ.GLXJEENT.SEQUENCE),
Hungarian Journal Lines Information (JE.HU.GLXJEENT.SEQUENCE),
Poland Information (JE.PL.GLXJEENT.SEQUENCE), and
Slovak Journal Lines Information (JE.SK.GLXJEENT.SEQUENCE)
GA3: Final Vat Register Request Id is replaced by JG_ZZ_VAT_TRX_DETAILS.FINAL_REPORTING_ID.
Poland Information (JE.PL.GLXJEENT.SEQUENCE) GA1: Journal Line Sequence and GA2: Journal Line Country are obsolete.
Turkey Information (JE.TR.GLXJEENT.SEQUENCE) GA2: Journal Line Country is obsolete.

JG_GL_SETS_OF_BOOKS

Feature Area Description of Change
Czech Set of Books Information (JE.CZ.GLXSTBKS.BOOKS), Hungarian Set of Books Information (JE.HU.GLXSTBKS.BOOKS),
Poland Set of Books Information (JE.PL.GLXSTBKS.BOOKS),
Slovakia Set of Books Information (JE.SK.GLXSTBKS.BOOKS)
GA1: VAT Reporting Calendar is replaced by JG_ZZ_VAT_REP_ENTITIES.TAX_CALENDAR_NAME.GA2: VAT Register Sequencing is replaced by JG_ZZ_VAT_REP_ENTITIES.ENABLE_REPORT_SEQUENCE_FLAG.
Greek Set of Books Information (JE.GR.GLXSTBKS.BOOKS) The following segments are obsolete:
  • GA1: Default Cutoff Days

  • GA2: Sequence GL Journals from AX?

  • GA3: Prefix with Sequence?

JG_HR_LOCATIONS

Feature Area Description of Change
Greek Location Information (JE.GR.PERWSLOC.LOC) The following segments are replaced by named columns:
  • GA1: Fiscal Company by XLE_ENTITY_PROFILES.NAME and XLE_ETB_PROFILES.NAME

  • GA2: VAT Number by ZX_PARTY_TAX_PROFILE.REP_REGISTRATION_NUMBER and XLE_REGISTRATIONS.REGISTRATION_NUMBER

  • GA3: Tax Office by XLE_REGISTRATIONS.ISSUING_AUTHORITY_ID

  • GA4: Tax Area by XLE_REGISTRATIONS.ISSUING_AUTHORITY_SITE_ID

  • GA5: Company Activity by XLE_ENTITY_PROFILES.ACTIVITY_CODE and XLE_ETB_PROFILES.ACTIVITY_CODE

  • GA6: Electronic File Number by XLE_REGISTRATIONS.REGISTRATION_NUMBER.

Italian Location Information (JE.IT.PERWSLOC.LOC) The following segments are replaced by named columns:
  • GA1: Company Name by XLE_ENTITY_PROFILES.NAME and XLE_ETB_PROFILES.NAME.

  • GA2: Fiscal Code is replaced by XLE_REGISTRATIONS.REGISTRATION_NUMBER.

JG_HZ_CUST_SITE_USES

Feature Area Description of Change
Spanish Customer Information (JE.ES.ARXCUDCI.RA) GA1: Charges Bearer is replaced by IBY_EXT_PAYERS_GLB.BANK_CHARGE_BEARER.

JG_MTL_PARAMETERS

Feature Area Description of Change
AX NPI Organization Accounts (JE.IT.INVSDOIO.NPI parameters) GA19: Invoices to be received and GA20: PO Mirror are obsolete.

JG_MTL_SYSTEM_ITEMS

Feature Area Description of Change
Additional Item Information (JE.HU.INVIDITM.STAT_CODE) and Additional Item Information (JE.PL.INVIDITM.STAT_CODE) GA1: STAT_CODE is replaced by a named column, STATISTICAL_CODE, in the following tables:
  • ZX_FC_TYPES_B

  • MTL_CATEGORIES_SETS

  • MTL_CATEGORIES


GA1: STAT_CODE is replaced by PRODUCT_CATEGORY in the following tables:
  • ZX_FC_TYPES_B

  • ZX_FC_CODES_B

  • ZX_FC_CODES_DENORM_B


GA1: STAT_CODE is replaced by MTL_CATEGORIES.SEGMENT1.
AX NPI Item Accounts (JE.IT.INVIDITM.NPI_SYSTEM_ITEM) The following segments are obsolete:
  • GA7: Fiscal IPV credit

  • GA8: Fiscal IPV debit

  • GA9: Fiscal Return

  • GA10: Fiscal Expense

JG_PO_VENDOR_SITES

Feature Area Description of Change
Addition Vendor Site Information for Israel (JE.IL.APXVDMVD.TAXPAYER_ID) GA1: TAXPAYER_ID is obsolete.
Additional Information (JE.CZ.APXVDMVD.PO_VENDORS) GA1: SPECIFIC_SYMBOL is obsolete.
Additional Supplier Site Information for Italy (JE.IT.APXVDMVD.DOC_CATEGORY) GA1: JEIT_DOCUMENT_CATEGORY_NAME is obsolete.

JG_RA_CUSTOMER_TRX

Feature Area Description of Change
Additional Information for Spanish Invoices (JE.ES.ARXTWMAI.INVOICE_INFO) The following segments are obsolete:
  • GA1: Invoice Type

  • GA2: Modelo 347 - Property Location

  • GA3: Modelo 349 - Correction Year

  • GA4: Modelo 349 - Correction Period

  • GA5: Modelo 349 - Triangulation

Additional Transaction Information (JE.CZ.ARXTWMAI.TAX_DATE) GA2: VAT_REGISTER_TRX is obsolete
Additional Transaction Information (JE.HU.ARXTWMAI.TAX_DATE),
Additional Transaction Information (JE.SK.ARXTWMAI.TAX_DATE),
Additional Transaction Information (JE.PL.ARXTWMAI.TAX_DATE), and
Additional Transaction Information (JE.CZ.ARXTWMAI.TAX_DATE)
GA1: Tax Date is replaced by ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE.
Additional Transaction Information (JE.PL.ARXTWMAI.TAX_DATE) GA2: VAT_REGISTER_TRX is obsolete
Spanish Receivables Invoice Type : Modelo 347 - Property Rental (JE.ES.ARXTWMAI.MODELO347PR),
Spanish Receivables Invoice Type : Modelo 349 (JE.ES.ARXTWMAI.MODELO349),
Spanish Receivables Invoice Type : Modelo 415 (JE.ES.ARXTWMAI.MODELO415),
Spanish Receivables Invoice Type : Modelo 415 & Modelo 347 (JE.ES.ARXTWMAI.MODELO415_347), and
Spanish Receivables Invoice Type : Modelo 415 & Modelo 347 - Property Rental (JE.ES.ARXTWMAI.MODELO415_347PR)
GA1: Invoice Type is replaced by a named column, TRX_BUSINESS_CATEGORY, in the following tables:•
  • ZX_FC_TYPES_B

  • ZX_FC_CODES_B

  • ZX_FC_CODES_DENORM_B


GA1: Invoice Type is replaced by ZX_LINES_DET_FACTORS.TRX_BUSINESS_CATEGORY.
Spanish Receivables Invoice Type : Modelo 349 (JE.ES.ARXTWMAI.MODELO349) GA5: Triangulation is replaced by ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE.
Spanish Receivables Invoice Type : Other (JE.EX.ARXTWMAI.OTHER) GA1: Invoice Type is obsolete.

JG_RA_CUSTOMER_TRX_LINES

Feature Area Description of Change
CZ Receivables VAT Register Informations (JE.CZ.ARXTWMAI.REGISTER_INFO),
HU Receivables VAT Register Informations (JE.HU.ARXTWMAI.REGISTER_INFO),
PL Receivables VAT Register Informations (JE.PL.ARXTWMAI.REGISTER_INFO), and
SK Receivables VAT Register Informations (JE.SK.ARXTWMAI.REGISTER_INFO)
GA1: Final Vat Register Request ID is replaced by JG_ZZ_VAT_TRX_DETAILS.FINAL_REPORTING_ID.
HU Receivables VAT Register Informations (JE.HU.ARXTWMAI.REGISTER_INFO) The following segments are obsolete:
  • GA1: FINAL_VAT_REQUEST_ID

  • GA2: Start Date

  • GA3: End Date

  • GA4: Balancing Segment

  • GA5: Tax Origin

JG_RA_CUST_TRX_TYPES

Feature Area Description of Change
Additional Transaction Type Information (JE.ES.RAXSUCTT.INV_TYPE) GA10: INV_TYPE is obsolete.
Additional Transaction Type Information (JE.HU.RAXSUCTT.REVALUATION) GA1: Revaluate Transaction type is obsolete.

Payment Format EFT Details

Feature Area Description of Change
LMP Format (LI.LMP) JGZZ_FORMAT_INFO2: JEFI_ILLEGAL_CHARS and JGZZ_FORMAT_INFO3: JEFI_LEGAL_CHARS are obsolete.
JGZZ_FORMAT_INFO5: JEFI_EDI_IDENTIFIER is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE.
JGZZ_FORMAT_INFO6: JEFI_PROCESSING is replaced by IBY_PAYMENT_PROFILES.BANK_INSTRUCTION1_ID.
LUM2 Format (FI.LUM2) JGZZ_FORMAT_INFO1: JEFI_CONTRACT_NO is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_VALUE.
JGZZ_FORMAT_INFO7: JEFI_EFT_NUMBER_LUM2 is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE.
JGZZ_FORMAT_INFO2: JEFI_ILLEGAL_CHARS and JGZZ_FORMAT_INFO3: JEFI_LEGAL_CHARS are obsolete.
ULMP Format (FI.ULMP) JGZZ_FORMAT_INFO1: JEFI_CONTRACT_NO is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_VALUE.
The following segments are obsolete:
  • JGZZ_FORMAT_INFO2: JEFI_ILLEGAL_CHARS.

  • JGZZ_FORMAT_INFO3: JEFI_LEGAL_CHARS.

  • JGZZ_FORMAT_INFO7: JEFI_EFT_NUMBER.

Scheduled Payment EFT Details

Feature Area Description of Change
German Payment Schedule Level Declaration (DE.U) The following segments are obsolete:
  • JGZZ_PS_INFO1: COUNTRY_CODE

  • JGZZ_PS_INFO9: Alpha

  • JGZZ_PS_INFO17: Numeric


JGZZ_PS_INFO3: DECLARATION_FLAG is replaced by columns on the IBY_PAYMENT_PROFILES table. (For examples, DECLARATION_THRESH_AMOUNT and DECLARATION_OPTION_FLAG).
German Payment Schedule Level Declaration (DE.V) The following segments are obsolete:
  • JGZZ_PS_INFO1: Export Country

  • JGZZ_PS_INFO8: Import Country

  • JGZZ_PS_INFO9: Transit Goods

  • JGZZ_PS_INFO10: Money Due Date

  • JGZZ_PS_INFO11: Import Numeric

  • JGZZ_PS_INFO12: Selling Cost

  • JGZZ_PS_INFO17: Goods No.

  • JGZZ_PS_INFO18: Export Alpha

  • JGZZ_PS_INFO19: Export Numeric

  • JGZZ_PS_INFO20: Purchase Cost

  • JGZZ_PS_INFO21: Passing Trade

  • JGZZ_PS_INFO22: Goods Separated

  • JGZZ_PS_INFO23: Stored Inland

  • JGZZ_PS_INFO24: Stored Abroad

  • JGZZ_PS_INFO25: Export Goods

  • JGZZ_PS_INFO26: Export No

  • JGZZ_PS_INFO27: Import Alpha

  • JGZZ_PS_INFO28: Buyers Address


JGZZ_PS_INFO3: DECLARATION_FLAG is replaced by columns on the IBY_PAYMENT_PROFILES table. (For examples, DECLARATION_THRESH_AMOUNT, and DECLARATION_OPTION_FLAG).
German Payment Schedule Level Declaration (DE.W) The following segments are obsolete:
JGZZ_PS_INFO1: Country Name
JGZZ_PS_INFO9: Record Type
JGZZ_PS_INFO17: Reason
JGZZ_PS_INFO18: Alpha
JGZZ_PS_INFO19: Numeric
JGZZ_PS_INFO28: Buyers Address
JGZZ_PS_INFO20: Explanation is replaced byAP_INVOICES_ALL.REMITTANCE_MESSAGE1.
JGZZ_PS_INFO3: DECLARATION_FLAG is replaced by columns on the IBY_PAYMENT_PROFILES table. (For example, DECLARATION_THRESH_AMOUNT and DECLARATION_OPTION_FLAG)

Supplier Site EFT Details

Feature Area Description of Change
Austrian Vendor Site EFT Information (AT) JGZZ_SITE_INFO1: BANK_CHARGE_CODE is replaced by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER.
Belgium Vendor Site EFT Information (BE) JGZZ_SITE_INFO1: IBLC/BLIW Trade is replaced by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_REASON_ID.
JGZZ_SITE_INFO1: Foreign Payment Cost Code is replaced by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER.
Finnish Vendor Site EFT Information (FI) The following segments are replaced by named columns:
  • JGZZ_SITE_INFO1: JEFI_FORMAT by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_FORMAT_ID.

  • JGZZ_SITE_INFO3: JEFI_PAYMENT_TYPE by IBY_EXT_PAYEE_ATTRIBS.DELIVERY_CHANNEL_ID.

  • JGZZ_SITE_INFO4: JEFI_SHORT_MESSAGE by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_TEXT_MESSAGE1.

  • JGZZ_SITE_INFO5: JEFI_LONG_MESSAGE_1 by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_TEXT_MESSAGE2.

  • JGZZ_SITE_INFO6: JEFI_LONG_MESSAGE_2 by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_TEXT_MESSAGE3.

  • JGZZ_SITE_INFO10: JEFI_AP_BANK_EXPENSE by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER.


JGZZ_SITE_INFO2: JEFI_DEPENDENCE is obsolete.
German Vendor Site Level EFT Parameters (DE) The following segments are replaced by named columns:
  • JGZZ_SITE_INFO1: DECLARATION_FLAG by IBY_PAYMENT_PROFILES at high level.

  • JGZZ_SITE_INFO3: BANK_INSTRUCTION by IBY_EXT_PAYEE_ATTRIBS.BANK_INSTRUCTION1_ID.

  • JGZZ_SITE_INFO4: CHARGE_CODE by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER.

  • JGZZ_SITE_INFO5: PAYMENT_METHOD by IBY_EXT_PAYEE_ATTRIBS.DELIVERY_CHANNEL_ID.

  • JGZZ_SITE_INFO6: EXPLANATION by Payment Text Messages.

  • JGZZ_SITE_INFO7: INSTRUCTION_DETAILS by IBY_EXT_PAYEE_ATTRIBS.BANK_INSTRUCTION_DETAILS.


The following segments are obsolete:
  • JGZZ_SITE_INFO2:

  • JGZZ_SITE_INFO10:

  • JGZZ_SITE_INFO11:

  • JGZZ_SITE_INFO12:

  • JGZZ_SITE_INFO19:

  • JGZZ_SITE_INFO11:

Netherlands EFT Vendor Site Formats (NL) The following segments are replaced by named columns:
  • JGZZ_SITE_INFO1: Crossed Cheque by IBY_EXT_PAYEE_ATTRIBS.BANK_INSTRUCTION1_ID

  • JGZZ_SITE_INFO10: Cheque Forwarding Code by IBY_EXT_PAYEE_ATTRIBS.BANK_INSTRUCTION2_ID

  • JGZZ_SITE_INFO11: Domestic Costs Code by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER

  • JGZZ_SITE_INFO12: Correspondents Costs Code by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER

  • JGZZ_SITE_INFO13: Urgency Code by IBY_EXT_PAYEE_ATTRIBS.DELIVERY_CHANNEL_ID

Super set of NO's EFT vendor formats (NO) The following segments are replaced by named columns:
  • JGZZ_SITE_INFO6: Foreign cost by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER

  • JGZZ_SITE_INFO7: Norwegian cost by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER

Swedish Vendor Site Format (SE) The following segments are replaced by named columns:
  • JGZZ_SITE_INFO2: Federal Reserve Code by IBY_EXT_PAYEE_ATTRIBS.PAYMENT_REASON_ID

  • JGZZ_SITE_INFO4: Payment Expense Code by IBY_EXT_PAYEE_ATTRIBS.BANK_CHARGE_BEARER

  • JGZZ_SITE_INFO5: UTLI Header Code by IBY_EXT_PAYEE_ATTRIBS.BANK_INSTRUCTION1_ID

  • JGZZ_SITE_INFO6: OCR Customer Reference by IBY_EXT_PAYEE_ATTRIBS.BANK_INSTRUCTION_DETAILS


JGZZ_SITE_INFO1: Receiver Name is obsolete.
Swiss Vendor Site EFT Information (CH) JGZZ_SITE_INFO2: Payment Type is replaced by IBY_EXT_PAYEE_ATTRIBS.DELIVERY_CHANNEL_ID.

System Format

Feature Area Description of Change
DTA Payment Format for Switzerland (CH.JECHRDTA) The following segments are obsolete:
  • JGZZ_SYSTEM_INFO1: Company ID

  • JGZZ_SYSTEM_INFO2: Company Name

  • JGZZ_SYSTEM_INFO3: Company Address Line 1

  • JGZZ_SYSTEM_INFO4: Company Address Line 2

  • JGZZ_SYSTEM_INFO5: Company City


JGZZ_SYSTEM_INFO6: Company TELEKURS ID and JGZZ_SYSTEM_INFO7: Department TELEKURS ID are replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE.
EFT format for Bankgiro Foreign SISU Sweden (SE.JESEPBSI) and EFT format for Bankgiro Foreign UTLI Sweden (SE.JESEPBUT) JGZZ_SYSTEM_INFO8: EFT File Directory is replaced by IBY_PAYMENT_PROFILES.OUTBOUND_PMT_FILE_DIRECTORY.
The following segments are obsolete:
  • JGZZ_SYSTEM_INFO2: Senders Name

  • JGZZ_SYSTEM_INFO3: Senders Address

  • JGZZ_SYSTEM_INFO4: Report Code

  • JGZZ_SYSTEM_INFO5: Sort Code

  • JGZZ_SYSTEM_INFO6: Invoice Option

  • JGZZ_SYSTEM_INFO7: Federal Code

  • JGZZ_SYSTEM_INFO9: Credit Days

  • JGZZ_SYSTEM_INFO13: Payment Date

EFT format for Bankgiro Inland Sweden (SE.JESEPBAI) The following segments are replaced by named columns:
  • JGZZ_SYSTEM_INFO3: Invoice Info by IBY_PAYMENT_PROFILES.PAYMENT_TEXT_MESSAGE2

  • JGZZ_SYSTEM_INFO5: Invoice Title by IBY_PAYMENT_PROFILES.PAYMENT_TEXT_MESSAGE1

  • JGZZ_SYSTEM_INFO10: EFT File Directory by IBY_PAYMENT_PROFILES.OUTBOUND_PMT_FILE_DIRECTORY


The following segments are obsolete:
  • JGZZ_SYSTEM_INFO6: Amount Header

  • JGZZ_SYSTEM_INFO4: Invoice Enddate

  • JGZZ_SYSTEM_INFO8: Credit Code

  • JGZZ_SYSTEM_INFO7: Account Code

  • JGZZ_SYSTEM_INFO9: Credit Days

  • JGZZ_SYSTEM_INFO13: Payment Date

EFT Format for Netherlands Foreign Payments (NL.JENLFFGN) The following segments are replaced by named columns:
  • JGZZ_SYSTEM_INFO1: DNB Registration Num by HZ_ORGANIZATION_PROFILES.BRANCH_NUMBER

  • JGZZ_SYSTEM_INFO10: Trader Number by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO11: Authorised Bank by HZ_CONTACT_POINTS.EFT_SWIFT_CODE

  • JGZZ_SYSTEM_INFO12: Business Sector by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE


JGZZ_SYSTEM_INFO13: EFT Rate Type is obsolete.
EFT format for Postgiro Foreign Sweden (SE.JESEPPOU) The following segments are replaced by named columns:
  • JGZZ_SYSTEM_INFO2: Customer Number by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO10: EFT File Directory by IBY_PAYMENT_PROFILES.OUTBOUND_PMT_FILE_DIRECTORY

  • JGZZ_SYSTEM_INFO11: Payment Date IBY_PAYMENT_PROFILES at high level


The following segments are obsolete:
  • JGZZ_SYSTEM_INFO3: Senders Name

  • JGZZ_SYSTEM_INFO4: Sender Address

  • JGZZ_SYSTEM_INFO5: Senders Postal Address

  • JGZZ_SYSTEM_INFO6: Federal Reserve Code

  • JGZZ_SYSTEM_INFO7: Sort Option

  • JGZZ_SYSTEM_INFO8: Report Code

  • JGZZ_SYSTEM_INFO9: Credit Days

  • JGZZ_SYSTEM_INFO13: Payment Date

EFT format for Postgiro Inland Sweden (SE.JESEPPOI) The following segments are replaced by named columns:
  • JGZZ_SYSTEM_INFO1: Customer Number by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO11: EFT File Directory by IBY_PAYMENT_PROFILES.OUTBOUND_PMT_FILE_DIRECTORY


The following segments are obsolete:
  • JGZZ_SYSTEM_INFO2: Credit Days

  • JGZZ_SYSTEM_INFO3: Sender Info 1

  • JGZZ_SYSTEM_INFO4: Sender Info 2

  • JGZZ_SYSTEM_INFO6: Sort Option

  • JGZZ_SYSTEM_INFO7: Accounting Code

  • JGZZ_SYSTEM_INFO8: Envelope

  • JGZZ_SYSTEM_INFO9: Sender Code

  • JGZZ_SYSTEM_INFO12: Date + Sequence

  • JGZZ_SYSTEM_INFO13: Payment Date

German System Level EFT Parameters (DE.JEDEDEFI) The following segments are replaced by named columns:
  • JGZZ_SYSTEM_INFO1: LZB_AREA_NUMBER by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO2: COMPANY_NUMBER by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO3: DECLARATION_FLAG by columns on the IBY_PAYMENT_PROFILES table (e.g., DECLARATION_THRESH_AMOUNT, DECLARATION_OPTION_FLAG).

  • JGZZ_SYSTEM_INFO5: DECLARATION_LIMIT by columns on the IBY_PAYMENT_PROFILES table. (Fore examples, DECLARATION_THRESH_AMOUNT and DECLARATION_OPTION_FLAG).

Norwegian BBS (NO.JENOPBDR) The following segments are replaced by named columns:
  • JGZZ_SYSTEM_INFO1: customerid by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO2: Agreement ID by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO3: Last sequence number by IBY_PAYMENT_PROFILES at high level

  • JGZZ_SYSTEM_INFO5: Last Num sent to BBS by IBY_PAYMENT_PROFILES at high level


The following segments are obsolete:
  • JGZZ_SYSTEM_INFO4

  • JGZZ_SYSTEM_INFO6

  • JGZZ_SYSTEM_INFO7

Norwegian Datadialog (NO.JENOPDDG) JGZZ_SYSTEM_INFO1: Customer ID is replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE.
The following segments are obsolete:
  • JGZZ_SYSTEM_INFO2: Return Cod

  • JGZZ_SYSTEM_INFO3: Department

  • JGZZ_SYSTEM_INFO4: Alt. bankaccount

  • JGZZ_SYSTEM_INFO5: File ID

  • JGZZ_SYSTEM_INFO6: Password

  • JGZZ_SYSTEM_INFO7: Status

  • JGZZ_SYSTEM_INFO8: Record length

  • JGZZ_SYSTEM_INFO9: Filenumber

Norwegian Telepay (NO.JENOPTGN) The following segments are replaced by named columns:
  • JGZZ_SYSTEM_INFO1: NIF-value by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO2: Division by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO3: Password by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO4: IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE

  • JGZZ_SYSTEM_INFO8: Trans Seq. nr by IBY_PAYMENT_PROFILES at high level

  • JGZZ_SYSTEM_INFO10: Seq. control by IBY_PAYMENT_PROFILES at high level

SAD Payment Format for Switzerland (CH.JECHRSAD) The following segments are obsolete:
  • JGZZ_SYSTEM_INFO1: Company ID

  • JGZZ_SYSTEM_INFO2: Company Name

  • JGZZ_SYSTEM_INFO3: Company Address Line 1

  • JGZZ_SYSTEM_INFO4: Company Address Line 2

  • JGZZ_SYSTEM_INFO5: Company City

  • JGZZ_SYSTEM_INFO6: Company Postal Code


JGZZ_SYSTEM_INFO7: Company PTT File ID replaced by IBY_BEP_ACCT_OPT_VALS.ACCOUNT_OPTION_CODE.

Financials for the Americas

This section lists the changes to the Global Descriptive Flexfields for Oracle Financials for the Americas Release 12.

JG_AP_BANK_ACCOUNTS

Feature Area Description of Change
Brazilian Additional Information (JL.BR.APXSUMBA.AR.Additional) GA3: Country Code is replaced by named columns:
  • HZ_PARTIES.HOME_COUNTRY

  • HZ_ORGANIZATION_PROFILES.HOME_COUNTRY


GA7: Company Code for Bank is replaced by a named column, CE_BANK_ACCOUNTS.SECONDARY_ACCOUNT_REFERENCE.

JG_AP_BANK_BRANCHES

Feature Area Description of Change
Columbian Bank Information (JL.CO.APXSUMBA.BANKS) GA11: Primary ID Number is replaced by a named column, HZ_PARTIES.JGZZ_FISCAL_CODE.
GA3: Country Code is replaced by named columns:
  • HZ_PARTIES.HOME_COUNTRY

  • HZ_ORGANIZATION_PROFILES.HOME_COUNTRY

JG_AP_INVOICE_DISTRIBUTIONS

Feature Area Description of Change
Argentine Distribution Information (JL.AR.APXINWKB.DISTRIBUTIONS) GA3: Ship To Location is replaced by named columns:
  • AP_INVOICE_LINES_ALL.SHIP_TO_LOCATION_ID

  • ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID

Brazilian Additional Tax Information (JL.BR.APXINWKB.D_SUM_FOLDER) GA1: Operation Fiscal Code is replaced by the named columns:
  • ZX_FC_TYPES_B.TRX_BUSINESS_CATEGORY

  • ZX_FC_CODES_B.TRX_BUSINESS_CATEGORY

  • ZX_FC_CODES_DENORM_B.TRX_BUSINESS_CATEGORY

  • AP_INVOICE_LINES_ALL.USER_DEFINED_FISC_CLASS

  • ZX_LINES_DET_FACTORS.USER_DEFINED_FISC_CLASS

  • ZX_LINES_DET_FACTORS.TRANSACTION_BUSINESS_CATEGORY

Columbian Distribution Information (JL.CO.APXINWKB.DISTRIBUTIONS) GA3: Ship To Location is replaced by named columns:
  • AP_INVOICE_LINES_ALL.SHIP_TO_LOCATION_ID

  • ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID

JG_AP_INVOICE_LINES_INTERFACE

Feature Area Description of Change
Argentine Open Interface Invoice Lines Information (JL.AR.APXIISIM.LINES_FOLDERPayables) and Columbian Open Interface Invoice Lines Information (JL.CO.APXIISIM.LINES_FOLDER) GA3: Ship To Location is obsolete.
Brazilian Open Interface Invoice Lines Information (JL.BR.APXIISIM.LINES_FOLDER) GA1: Operation Fiscal Code is replaced with a named column:
ZX_LINES_DET_FACTORS.TRANSACTION_BUSINESS_CATEGORY.

JG_AP_INVOICES

Feature Area Description of Change
Additional Information (JL.BR.APXINWKB.AP_INVOICES) GA2: Operation Fiscal Code is replaced by the named columns:
  • ZX_FC_TYPES_B.TRX_BUSINESS_CATEGORY, ZX_FC_CODES_B.TRX_BUSINESS_CATEGORY, and ZX_FC_CODES_DENORM_B.TRX_BUSINESS_CATEGORY

  • ZX_LINES_DET_FACTORS.TRANSACTION_BUSINESS_CATEGORY.


Brazilian AP/PO feature is obsolete and the following segments are obsolete:
  • GA5: ICMS Base Amount

  • GA6: ICMS Name

  • GA7: ICMS Amount

  • GA8: IPI Amount

Argentine Invoice Information (JL.AR.APXINWKB.INVOICES) The following segments are replaced with the named columns:
  • GA10: Destination Code with AP_INVOICE_LINES_ALL.PRIMARY_INTENDED_USE and ZX_LINES_DET_FACTORS.PRIMARY_INTENDED_USE

  • GA18: Ship To Location with AP_INVOICE_LINES_ALL.SHIP_TO_LOCATION_ID and ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID

Columbian Invoices Information (JL.CO.APXINWKB.INVOICES) GA18: Ship To Location is replaced by named columns:
  • AP_INVOICE_LINES_ALL.SHIP_TO_LOCATION_ID

  • ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID

JG_AP_INVOICES_INTERFACE

Feature Area Description of Change
Brazilian Open Interface Information (JL.BR.APXIISIM.INVOICES_FOLDER) GA2: Operation Fiscal Code is replaced by a named column:
ZX_LINES_DET_FACTORS.TRANSACTION_BUSINESS_CATEGORY.
Brazilian AP/PO feature is obsolete and the following segments are obsolete:
  • GA5: ICMS Base Amount

  • GA6: ICMS Name

  • GA7: ICMS Amount

  • GA8: IPI Amount

JG_AP_SYSTEM_PARAMETERS

Feature Area Description of Change
Brazilian Additional Information (JL.BR.APXCUMSP.SYS_PARAMETER) GA4: Payment Location is renamed to Payment Location City.
The following segments added. Previously, they were profiles:
  • GA6: Payment Due Date Derivation Method

  • GA7: Payment Location

  • GA8: Change Payment Due Date Automatically

JG_AP_TAX_CODES

Feature Area Description of Change
Argentine Tax Names Information (JL.AR.APXTADTC.TAX_NAMES) GA4: Withholding Type is replaced by ZX_REPORT_CODES_ASSOC.AR_DGI_TRX_CODE.
Chilean Tax Information (JL.CL.APXTADTC.AP_TAX_CODES) GA19: Tax Category is replaced by a named column, ZX_REPORT_CODES_ASSOC.CL_TAX_CODE_CLASSIF.

JG_AR_MEMO_LINES

Feature Area Description of Change
Argentine Standard Memo Lines Information (JL.AR.ARXSTDML.AR_MEMO_LINES), Brazilian Additional Information (JL.BR.ARXSTDML.Additional),
Columbian Standard Memo Lines Information (JL.CO.ARXSTDML.AR_MEMO_LINES), and
Fiscal Classification Code (JL.BR.ARXSDML.Additional)
GA1: Fiscal Classification Code is replaced by the named columns:
  • ZX_FC_TYPES_B.PRODUCT_CATEGORY

  • ZX_FC_CODES_B.PRODUCT_CATEGORY

  • ZX_FC_CODES_DENORM_B.PRODUCT_CATEGORY

  • ZX_FC_TYPES_B.FISCAL_CLASSIFICATION

  • MTL_CATEGORY_SETS.FISCAL_CLASSIFICATION

  • MTL_CATEGORIES.FISCAL_CLASSIFICATION

JG_AR_RECEIPT_CLASSES

Feature Area Description of Change
Chilean Receipt Class Information (JL.CL.ARXSUDRC.RECEIPT_CLASS) The following segments are obsolete:
  • GA2: Bills of Exchange

  • GA3: Tax Code

JG_AR_SYSTEM_PARAMETERS

Feature Area Description of Change
Brazilian Additional Information (JL.BR.ARXSYSPA.Additional Info) The following segments are obsolete:
  • GA2: Interest Type

  • GA3: Interest Rate Amount

  • GA4: Interest Period

  • GA5: Interest Formula

  • GA6: Grace Days

  • GA7: Penalty Type

  • GA8: Penalty Rate Amount

JG_AR_VAT_TAX

Feature Area Description of Change
Argentina Tax Codes and Rates (JL.AR.ARXSUVAT.AR_VAT_TAX) The following segments are replaced by named columns:
  • GA1: Tax Category by ZX_TAXES_B.TAX

  • GA2: Print Tax Line by ZX_REPORT_CODES_ASSOC.PRINT TAX LINE

  • GA4: DGI Transaction Code by ZX_REPORT_CODES_ASSOC.AR_DGI_TRX_CODE

  • GA5: Turnover Jurisdiction Code by ZX_REPORT_CODES_ASSOC.AR_TURN_OVER_JUR_CODE

  • GA6: Municipal Jurisdiction by ZX_REPORT_CODES_ASSOC.AR_MUNICIPAL_JUR

Brazilian Tax Information (JL.BR.ARXSUVAT.Tax Information) andColumbian Tax Codes and Rates (JL.CO.ARXSUVAT.AR_VAT_TAX) The following segments are replaced by named columns:
  • GA1: Tax Category by ZX_TAXES_B.TAX

  • GA2: Print Tax Line by ZX_REPORT_CODES_ASSOC.PRINT TAX LINE

Chilean Tax Codes and Rates Information (JL.CL.ARXSUVAT.VAT_TAX) The following segments are replaced by named columns:
  • GA4: Tax Code Classification by ZX_REPORT_CODES_ASSOC. CL_TAX_CODE_CLASSIF

  • GA5: Debit Account by ZX_RATES_B.NON_REC_ACCOUNT_CCID, ZX_REPORT_CODES_ASSOC. CL_DEBIT_ACCOUNT

  • GA6: Bills of Exchange Tax by ZX_REPORT_CODES_ASSOC. CL_BILLS_OF_EXCH_TAX.

JG_GL_JE_LINES_INFO

Feature Area Description of Change
Columbian Additional Information (JL.CO.GLXJEENT.THIRDPARTY) GA1: Third Party ID is replaced with a named column:
GL_JE_LINES.CO_THIRD_PARTY.

JG_HR_LOCATIONS

Feature AreDescription of Changea
Argentine Locations Information (JL.AR.PERWSLOC.LOC),
Chilean Locations Information (JL.CL.PERWSLOC.LOC), and
Columbian Locations Information (JL.CO.PERWSLOC.LOC)
The following segments are replaced by named columns:
  • GA8: Company Name by XLE_ENTITY_PROFILES.NAME, XLE_ETB_PROFILES.NAME

  • GA9: Alternate Company Name is replaced by XLE_REGISTRATIONS.ALTERNATE_REGISTERED_NAME

  • GA11: Primary ID Number by ZX_PARTY_TAX_PROFILE.REP_REGISTRATION_NUMBER and ZX_REPORT_CODES_ASSOC. REG NUMBER

  • GA12: Primary ID Validation Digit by ZX_PARTY_TAX_PROFILE.REP_REGISTRATION_NUMBER and ZX_REPORT_CODES_ASSOC. REG NUMBER

Argentine Locations Information (JL.AR.PERWSLOC.LOC) GA14: Inception Date is replaced by XLE_ETB_PROFILES.EFFECTIVE_FROM
Chilean Locations Information (JL.CL.PERWSLOC.LOC) GA13: Inscription is replaced by XLE_ENTITY_PROFILES.ACTIVITY_CODE, XLE_ETB_PROFILES.ACTIVITY_CODE
GA14: Legal Representative to HZ_PARTIES_PARTY_NAME
GA15: Legal Representative ID is replaced by HZ_PARTIES.PARTY_NUMBER
Columbian Locations Information (JL.CO.PERWSLOC.LOC) GA4: Activity Code is replaced by XLE_ENTITY_PROFILES.ACTIVITY_CODE.
GA14: Economic Activity Code is replaced by XLE_ETB_PROFILES.ACTIVITY_CODE.

JG_MTL_ITEM_TEMPLATES

Feature Area Description of Change
Brazilian Fiscal Information (JL.BR.INVIDTMP.Fiscal) GA1: Fiscal Classification Code is replaced by the following named columns:
  • ZX_FC_TYPES_B.PRODUCT_CATEGORY

  • ZX_FC_CODES_B.PRODUCT_CATEGORY

  • ZX_FC_CODES_DENORM_B..PRODUCT_CATEGORY

  • ZX_FC_TYPES_B.FISCAL_CLASSIFICATION

  • MTL_CATEGORY_SETS.FISCAL_CLASSIFICATION

  • MTL_CATEGORIES.FISCAL_CLASSIFICATION

JG_MTL_SYSTEM_ITEMS

Feature Area Description of Change
Argentine Master Items Information(JL.AR.INVIDITM.SYSTEM_ITEMS),
Brazilian Fiscal Information (JL.BR.INVIDITM.XX.Fiscal), and
Columbian Master Item Information / Inflation Accts.( JL.CO.INVIDITM.SYSTEM_ITEMS)
GA1: Fiscal Classification Code is replaced by the following named columns:
  • ZX_FC_TYPES_B.PRODUCT_CATEGORY

  • ZX_FC_CODES_B.PRODUCT_CATEGORY

  • ZX_FC_CODES_DENORM_B..PRODUCT_CATEGORY

  • ZX_FC_TYPES_B.FISCAL_CLASSIFICATION

  • MTL_CATEGORY_SETS.FISCAL_CLASSIFICATION

  • MTL_CATEGORIES.FISCAL_CLASSIFICATION

JG_OE_ORDER_LINES

Feature Area Description of Change
Argentine Order Lines Information (JL.AR.OEXOEORD.LINES) and
Columbian Order Lines Information (JL.CO.OEXOEORD.LINES)
GA5: Fiscal Classification Code is replaced by the following named columns:
  • ZX_FC_TYPES_B.PRODUCT_CATEGORY

  • ZX_FC_CODES_B.PRODUCT_CATEGORY

  • ZX_FC_CODES_DENORM_B..PRODUCT_CATEGORY

  • ZX_FC_TYPES_B.FISCAL_CLASSIFICATION

  • MTL_CATEGORY_SETS.FISCAL_CLASSIFICATION

  • MTL_CATEGORIES.FISCAL_CLASSIFICATION

Brazilian Order Line Information (JL.BR.OEXOEORD.LINES) The following segments are replaced by the named columns:
  • GA1: Operation Fiscal Code by ZX_FC_TYPES_B.TRX_BUSINESS_CATEGORY, ZX_FC_CODES_B.TRX_BUSINESS_CATEGORY, and ZX_FC_CODES_DENORM_B.TRX_BUSINESS_CATEGORY

  • GA5: Fiscal Classification Code by ZX_FC_TYPES_B.PRODUCT_CATEGORY, ZX_FC_CODES_B.PRODUCT_CATEGORY, ZX_FC_CODES_DENORM_B..PRODUCT_CATEGORY, ZX_FC_TYPES_B.FISCAL_CLASSIFICATION, MTL_CATEGORY_SETS.FISCAL_CLASSIFICATION, and MTL_CATEGORIES.FISCAL_CLASSIFICATION


GA13: Default federal Tributary Situation is corrected as Default Federal Tributary Situation.
GA14: Default State Tributary is corrected as Default State Tributary Situation.

JG_RA_CUSTOMER_TRX_LINES

Feature Area Description of Change
Brazilian Additional Information (JL.BR.ARXTWMAI.Additional Info) The following segments are replaced by the named columns:
  • GA1: Operation Fiscal Code by ZX_FC_TYPES_B.TRX_BUSINESS_CATEGORY, ZX_FC_CODES_B.TRX_BUSINESS_CATEGORY, ZX_FC_CODES_DENORM_B.TRX_BUSINESS_CATEGORY, and ZX_LINES_DET_FACTORS.USER_DEFINED_FISC_CLASS

  • GA2: Fiscal Classification Code by ZX_FC_TYPES_B.PRODUCT_CATEGORY, ZX_FC_CODES_B.PRODUCT_CATEGORY, ZX_FC_CODES_DENORM_B..PRODUCT_CATEGORY, ZX_FC_TYPES_B.FISCAL_CLASSIFICATION, MTL_CATEGORY_SETS.FISCAL_CLASSIFICATION, MTL_CATEGORIES.FISCAL_CLASSIFICATION, ZX_LINES_DET_FACTORS.PRODUCT_FISC_CLASSIFICATION, and ZX_LINES_DET_FACTORS.PRODUCT_CATEGORY

  • GA3: Transaction Condition Class by ZX_LINES_DET_FACTORS.TRX_BUSINESS_CATEGORY

  • GA11: Tax Base Amount by ZX_LINES_DET_FACTORS.UNROUNDED_TAXABLE_AMT, ZX_LINES_DET_FACTORS.TAXABLE_AMT, ZX_LINES_DET_FACTORS. TAXABLE_AMT_TAX_CURR, and ZX_LINES_DET_FACTORS.TAXABLE_AMT_FUNCL_CURR

  • GA12: Tax Base Rate by ZX_LINES_DET_FACTORS.TAX_BASE_MODIFIER_RATE

  • GA19: Charged Tax Amount by ZX_LINES_DET_FACTORS.UNROUNDED_TAX_AMT, ZX_LINES_DET_FACTORS.TAX_AMT_TAX_CURR, and ZX_LINES_DET_FACTORS.TAX_AMT_FUNCL_CURR

  • GA20: Calculated Tax Amount by ZX_LINES_DET_FACTORS.CAL_TAX_AMT, ZX_LINES_DET_FACTORS.CAL_TAX_AMT_TAX_CURR, and ZX_LINES_DET_FACTORS.CAL_TAX_AMT_FUNCL_CURR

Argentine Invoice/Tax Lines (JL.AR.ARXTWMAI.LINES) and Columbian Invoice/Tax Lines (JL.CO.ARXTWMAI.LINES) The following segments are replaced by the named columns:
  • GA2: Fiscal Classification Code by: ZX_FC_TYPES_B.PRODUCT_CATEGORY, ZX_FC_CODES_B.PRODUCT_CATEGORY, ZX_FC_CODES_DENORM_B..PRODUCT_CATEGORY, ZX_FC_TYPES_B.FISCAL_CLASSIFICATION, MTL_CATEGORY_SETS.FISCAL_CLASSIFICATION, MTL_CATEGORIES.FISCAL_CLASSIFICATION, ZX_LINES_DET_FACTORS.PRODUCT_FISC_CLASSIFICATION, and ZX_LINES_DET_FACTORS.PRODUCT_CATEGORY

  • GA3: Transaction Condition Class by ZX_LINES_DET_FACTORS.TRX_BUSINESS_CATEGORY

  • GA11: Tax Base Amount by ZX_LINES_DET_FACTORS.UNROUNDED_TAXABLE_AMT, ZX_LINES_DET_FACTORS.TAXABLE_AMT, ZX_LINES_DET_FACTORS.TAXABLE_AMT_TAX_CURR, and ZX_LINES_DET_FACTORS.TAXABLE_AMT_FUNCL_CURR

  • GA12: Tax Base Rate by: ZX_LINES_DET_FACTORS.TAX_BASE_MODIFIER_RATE

  • GA19: Charged Tax Amount by ZX_LINES_DET_FACTORS.UNROUNDED_TAX_AMT, ZX_LINES_DET_FACTORS.TAX_AMT_TAX_CURR, and ZX_LINES_DET_FACTORS.TAX_AMT_FUNCL_CURR

  • GA20: Calculated Tax Amount by ZX_LINES_DET_FACTORS.CAL_TAX_AMT, ZX_LINES_DET_FACTORS.CAL_TAX_AMT_TAX_CURR, and ZX_LINES_DET_FACTORS.CAL_TAX_AMT_FUNCL_CURR

JG_RA_CUSTOMER_TRX

Feature Area Description of Change
Argentine Customer Transaction Information (JL.AR.ARXTWMAI.TGW_HEADER) The following segments are replaced by the named columns:
  • GA17: CAI Number by ZX_LINES_DET_FACTOR.TAX_INVOICE_NUMBER

  • GA18: CAI Due Date by ZX_LINES_DET_FACTOR.TAX_INVOICE_DATE