• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

table

  1. N

    Reading from Flat file (XML) and adding substrings as data to table

    Hi everyone , I need help.I want to use an UBE to read an XML as a flat file , and by using Fetch next Line from flat file , cut a substring between the <MS1:MsgId> to </MS1:MsgId> for example , and store it in a custom table , already built to match the type of the data we are going to...
  2. N

    Importing csv data into custom table in jde

    HI everyone , I just had my training on jde, and as i am still fresh i need some help. I have a custom table , based on F4141 . The whole point is , i am supposed to receive a csv file , check the quantity , and if it's different than the original that was stored on the F4141 , to update the...
  3. C

    business view on same tables

    Hi all. I need to write a price audit report. The BA says the business view need to be a left outer join on F42199 and F42199 (ledger). (not a typo) Has anyone done a business view with the same tables? BSVW designs let me do it. I'm wondering if there is anything I need to watch out for and...
  4. J

    is it possible to populate PY tables but not DV or PD ??

    is it possible to populate PY tables but not DV or PD ?? -- Company is not using JDE budgeting tables... can the PY tables loaded with external data to do "mock-up" budgeting and forecasting?
  5. S

    back end JDE question regarding GL

    So when I do some work on the front end of JDE in the GL what occurs as a result in the back end? Regarding the tables for example.
  6. T

    Prevent JDE from creating Long data type in Oracle in table generation

    Hi We are (unfortunately) still using JDE B7334 with an Oracle 11G1 database. We are currently implementing a mobile application and we have a new table that acts as an interface between JDE and the mobile app. The application requires a Notes field which we would like to be at least 4000...
  7. U

    Adding field in table

    Dear All, I got the requirement to add new field to existing table. Table in already in PD and it has data in it. as per my knowledge we have to create index and generate the table in PD once the modified table in promoted to PD from PY. now I am in confusion, after adding the field I will...
  8. R

    Need DD for storing IP Address

    I have a requirement to store IP addresses in a JDE table. I am having trouble defining the data element to do so. I am sure that this is an easy question, but can anyone share a DD item that can store the IP address (of the form 10.1.1.1)? I should be able to use a text field, but when I enter...
  9. Alex_Pastuhov

    Table Export 2 XML

    We've just released a new free tool, which as the name suggests, allows you to export whole JDE tables into XML. It uses JDE functionality, so the resulting files are compatible with and importable with R98403XA. 1) The export process is remarkably fast, so this process can be used for DB...
  10. Alex_Pastuhov

    JDE Table Export 2 XML

    We've just released a new free tool, which as the name suggests, allows you to export whole JDE tables into XML. It uses JDE functionality, so the resulting files are compatible with and importable with R98403XA. 1) The export process is remarkably fast, so this process can be used for DB...
  11. B

    Unable to Check In Tables

    We are on XE and have a developer set up who can check most objects in and out but with regard to tables, he can check them out but not back in. Anyone know how to rectify this?
  12. A

    Trigger on Table not running from Table Conversion

    Hi, I have a Table with a Trigger on the BeforeRecordIsInserted event. I'm using this table on a Table Conversion as the output table, so that event should be executed in every insert. However, it is not doing this, the table conversion inserts the table but never calls the trigger. From other...
  13. A

    Index on Table Conversion

    Hi, If you create a Table Conversion for copying data from one table (F0911) to another (F55911) and with a data selection, for example GLPOST='P', my question is, will the database use the appropriate index by GLPOST although you are not pointing to it becase you only selected F0911 as Input...
Top