K_ERPXREF - ERP Product Cross Reference Table

Nov 5, 2024

File Name . . . . K_ERPXREF
Library . . . .   K3S_5DTA
Format Descr. . . ERP Product Cross Reference Table
Format Name . . . RK_ERPXREF
File Type . . . . PF            Unique Keys-  Y

 Field Name FMT Start Lngth Dec Key Field Description
 EP_COMP    A      1     5        Y  Company ID
 EP_LOCN    A      6     5        Y  Location ID
 EP_ERP     A     11     3           Products Current ERP
 EP_BUYR    A     14     5           Buyer ID
 EP_CORPID  A     19    25        Y  Corporate Product ID
 EP_ERP1ID  A     44    25           ERP 1 Product ID
 EP_ERP2ID  A     69    25           ERP 2 Product ID
 EP_ERP3ID  A     94    25           ERP 3 Product ID
 EP_ERP4ID  A    119    25           ERP 4 Product ID
 EP_ERP5ID  A    144    25           ERP 5 Product ID
 EP_ERP6ID  A    169    25           ERP 6 Product ID
 EP_ERP7ID  A    194    25           ERP 7 Product ID
 EP_ERP8ID  A    219    25           ERP 8 Product ID
 EP_ERP9ID  A    244    25           ERP 9 Product ID
 EP_CORPTX  A    269     3           Corp ID Product Text
 EP_ERP1TX  A    272     3           ERP 1 Product Text
 EP_ERP2TX  A    275     3           ERP 2 Product Text
 EP_ERP3TX  A    278     3           ERP 3 Product Text
 EP_ERP4TX  A    281     3           ERP 4 Product Text
 EP_ERP5TX  A    284     3           ERP 5 Product Text
 EP_ERP6TX  A    287     3           ERP 6 Product Text
 EP_ERP7TX  A    290     3           ERP 7 Product Text
 EP_ERP8TX  A    293     3           ERP 8 Product Text
 EP_ERP9TX  A    296     3           ERP 9 Product Text
 EP_BIRTH   L    299    10           Record Birth Date
 EP_LSTUPD  L    309    10           Record Last Update Date
 EP_UPDFLG  A    319     1           Update Flag
 EP_STATUS  A    320     1           Record Status
 EP_USERA1  A    321     1           User defined alpha 1
 EP_USERA2  A    322     3           User defined alpha 2
 EP_USERA3  A    325    10           User defined alpha 3
 EP_USERA4  A    335    25           User defined alpha 4
 EP_USERA5  A    360    50           User defined alpha 5
 EP_USERN1  P    410     5   0       User defined number 1
 EP_USERN2  P    415     7   0       User defined number 2
 EP_USERN3  P    422     9   2       User defined number 3
 EP_USERN4  P    431    11   4       User defined number 4
 EP_USERN5  P    442    11   4       User defined number 5

---