Purpose To copy data from old JVA PSC tables to the new ones. Old tables beginwith T8PSC and PSC. The new ones begin with T8PSA and PSA Features Some new tables contain fields that are not found in the old tables.In majority cases these fields (look below) will have initial values.But in some tables they have to be defaulted to the values specifiedbelow. The information is given in the following order: Table Name, NewField Name, Field Value (initial if it says so) and Comments (if any): PSACR,,,,,,PSC_VOLUME,,,,initial PSAHD,,,,,,RLDNR,,,,,,initial ,,,,,,,,RRCTY,,,,,,initial ,,,,,,,,RVERS,,,,,,initial ,,,,,,,,TYPE,,,,,,,,initial ,,,,,,,,GOVERNMENT,,,,initial ,,,,,,,,OPERATOR,,,,,,initial ,,,,,,,,NO_EG_PSC,,,,initial ,,,,,,,,PSC_CUR_TYPE,,,,initial PSAIT,,,,,,,,PSA_GROUP,,,,initial ,,,,,,,,VOLUME_TYPE,,,,initial T8PSA_CAL,,,,,,CAL_CURR,,,,,,initial T8PSA_CSA,,,,,,PSC_EG,,,,,,initial ,,,,,,,,PSA_EQUAL_PRIO,,,,initial T8PSA_INPUT,,,,RRCTY,,,,,,'0' ,,,,,,,,RVERS,,,,,,'001' T8PSA_LIFT_VOL,,,,TERM,,,,,,,,initial,,,,Despite TERM is a key field,it's blank as ,,,,,,,,,,,,,,,,,,,,the configuration table has appearedonly in ,,,,,,,,,,,,,,,,,,,,,,,,this release. You may want to copyexisting ,,,,,,,,,,,,,,,,,,,,,,,,records, choose 'NEW ENTRY' pushbutton,,,,,,,,,,,,,,,,,,,,,,,,and paste them changing the Terminal Code to,,,,,,,,,,,,,,,,,,,,,,any value found in master table for Terminal,,,,,,,,,,,,,,,,,,,,,,,,Code ,,,,,,,,VOLUME_TYPE,,,,initial ,,,,,,,,CUSTOMER,,,,,,initial ,,,,,,,,LIFT_BY_NOC,,,,initial ,,,,,,,,PSC_PPU,,,,,,initial ,,,,,,,,PRICE_CURR,,,,initial T8PSA_PROD_VOL,,BTU_FACTOR,,,,initial T8PSA_PSC,,,,,,FIRST_OIL,,,,,,initial ,,,,,,,,LPERFR,,,,,,initial ,,,,,,,,LPERTO,,,,,,initial ,,,,,,,,NO_EG_PSC,,,,initial ,,,,,,,,GOVERNMENT,,,,initial,,,,,,This field as well as the next onemust be filled ,,,,,,,,,,,,,,,,,,,,,,before production system goes lifeas they play ,,,,,,,,,,,,,,,,,,,,,,an important role, e.g. in SalesPrice ,,,,,,,,,,,,,,,,,,,,,,,,,,calculation etc. T8PSA_SRC_LA,,,,LDNR_REP,,,,,,'4R' or '4S',,,,The value of this fielddepends on the value of ,,,,,,,,,,,,,,,,,,,,,,LDNR_SRC (Ledger Source)field. If source is ,,,,,,,,,,,,,,,,,,,,,,'4A' --> '4R' is stored. Ifsource is '4C' --> '4S' is ,,,,,,,,,,,,,,,,,,,,,,stored ,,,,,,,,OPERATOR,,,,,,initial ,, Output Data copied from the old ones to the new ones. If a record with thesame key exist in a new one, it will not be overwritten Activities Run the program Example T8PSCINPUT --> T8PSA_INPUT |