File Name . . . . K_INTPRDD
Library . . . . K3S_5DTA
Format Descr. . . Interface for Products
Format Name . . . RK_INTPRDD
File Type . . . . PF Unique Keys- N
Field Name FMT Start Lngth Dec Key Field Description
IY_COMP A 1 1 Company ID
IY_LOCN A 2 5 Location ID
IY_BIRTH L 7 10 Daily trans birth
IY_LASTUPD L 17 10 Daily trans last
IY_SUPL A 27 10 Supplier ID
IY_SUPLSUB A 37 10 Sub supplier ID
IY_SUPLUSR A 47 10 Supplier user system
IY_SUPLUSB A 57 10 Supplier user sub
IY_PROD A 67 25 Product ID
IY_PRODSEQ A 92 40 Product sequence #
IY_DESC1 A 132 40 Product description 1
IY_DESC2 A 172 40 Product description 2
IY_MFG A 212 25 Manufactor ID
IY_NDC_UPC A 237 25 NDC/UPC code
IY_UOM A 262 4 Unit of measure
IY_PACKSIZ A 266 10 Pack /size
IY_TIHI A 276 10 Ti /hi
IY_STATUS A 286 1 Status R,D
IY_MINQTY P 287 7 0 Minimum quantity
IY_BUYMULT P 291 7 0 Buy multiple
IY_GROUP1 A 295 10 Group 1
IY_GROUP2 A 305 10 Group 2
IY_GROUP3 A 315 10 Group 3
IY_GROUP4 A 325 10 Group 4
IY_GROUP5 A 335 10 Group 5
IY_WHSLOCN A 345 10 Warehouse location
IY_COSTREG P 355 11 4 Product cost regular
IY_COSTDIV P 361 5 0 Product cost divisor
IY_SALES P 364 11 4 Product sales price
IY_SALESLW P 370 11 4 Sales under cost
IY_QTYOHND P 376 7 0 Quantity on hand
IY_QTYOORD P 380 7 0 Quantity on order
IY_QTYBACK P 384 7 0 Quantity back ordered
IY_WEIGHT P 388 7 3 Unit weight
IY_WEIGHTD P 392 5 0 Weight divisor
IY_VOLUME P 395 7 3 Unit volume
IY_VOLUMED P 399 5 0 Volume divisor
IY_DLYSALE P 402 7 0 Daily /or PTD sales
IY_DLYOUTS P 406 7 0 Daily /or PTD outs
IY_TRNOORD P 410 7 0 Transfer on order
IY_ALTOORD P 414 7 0 Alt source on order
IY_FORCTYP P 418 1 0 Forecast interval type
IY_CONVPAK P 419 7 0 Convenience pack
IY_PURINCR P 423 5 0 Purchase increment
IY_CONTFLG P 426 1 0 Contract exists flag
IY_REBATE P 427 3 1 Rebate factor %
IY_PROCALT P 429 1 0 Process alt srce flag
IY_MFGOUT P 430 1 0 Mfg out of stock flag
IY_DLYTYP1 P 431 7 0 Daily /or PTD type 1
IY_DLYTYP2 P 435 7 0 Daily /or PTD type 2
IY_DLYTYP3 P 439 7 0 Daily /or PTD type 3
IY_DLYTYP4 P 443 7 0 Daily /or PTD type 4
IY_DLYTYP5 P 447 7 0 Daily /or PTD type 5
IY_DLYTYP6 P 451 7 0 Daily /or PTD type 6
IY_DLYTYP7 P 455 7 0 Daily /or PTD type 7
IY_DLYTYP8 P 459 7 0 Daily /or PTD type 8
IY_DLYTYP9 P 463 7 0 Daily /or PTD type 9
IY_CARCOUN P 467 1 0 Car count flag
IY_USERA1 A 468 1 User defined alpha 1
IY_USERA2 A 469 3 User defined alpha 2
IY_USERA3 A 472 10 User defined alpha 3
IY_USERN1 P 482 5 0 User defined number 1
IY_USERN2 P 485 7 2 User defined number 2
IY_USERN3 P 489 11 4 User defined number 3
IY_DISOTHR P 495 9 4 Bracket build other
IY_DISUNT7 P 500 9 4 Bracket build unit 7
IY_DISUNT8 P 505 9 4 Bracket build unit 8
IY_DISUNT9 P 510 9 4 Bracket build unit 9