File Name . . . . K_PURCHIS Library . . . . K3S_5DTA Format Descr. . . Purchase History Format Name . . . RK_PURCHIS File Type . . . . PF Unique Keys- N Field Name FMT Start Lngth Dec Key Field Description PS_COMP A 1 1 Company ID PS_BUYR A 2 5 Buy group ID PS_REGN A 7 5 Region ID PS_LOCN A 12 5 Location ID PS_PO A 17 10 Purchase order ID PS_SUPL A 27 10 Supplier ID PS_SUPLSUB A 37 10 Sub supplier ID PS_SUPLUSR A 47 10 Supplier user system PS_SUPLUSB A 57 10 Supplier user sub PS_PROD A 67 25 Product ID PS_PRODSEQ A 92 40 Product sequence # PS_DESC1 A 132 40 Product description 1 PS_DESC2 A 172 40 Product description 2 PS_NDC_UPC A 212 25 NDC/UPC code PS_MFG A 237 25 Manufactor ID PS_UOM A 262 4 Unit of measure PS_PACKSIZ A 266 10 Pack /size PS_TIHI A 276 10 Ti /hi PS_GROUP1 A 286 10 Group 1 PS_GROUP2 A 296 10 Group 2 PS_GROUP3 A 306 10 Group 3 PS_GROUP4 A 316 10 Group 4 PS_GROUP5 A 326 10 Group 5 PS_WHSLOCN A 336 10 Warehouse location PS_BIRTH L 346 10 Purch hst birth date PS_LASTUPD L 356 10 Purch hst last update PS_LEADTM P 366 3 0 Lead time in days PS_LEADTMO P 368 3 0 Lead time orders PS_OPOINTU P 370 7 0 Order point units PS_OPOINTD P 374 3 0 Order point days PS_ORUPTOU P 376 7 0 Order up to units PS_ORUPTOD P 380 3 0 Order up to days PS_COSTREG P 382 11 4 Product cost regular PS_COSTDIV P 388 5 0 Product cost divisor PS_COSTEAC P 391 13 6 Product cost each PS_COSTORD P 398 11 4 Product cost orders PS_COSTLST P 404 11 4 Product cost last PS_COSTLDT L 410 10 Product cost last chg PS_SALES P 420 11 4 Product sales price PS_QTYOHND P 426 7 0 Quantity on hand PS_QTYOORD P 430 7 0 Quantity on order PS_QTYBACK P 434 7 0 Quantity back ordered PS_QTYHOLD P 438 7 0 Quantity hold out PS_QTYPEND P 442 7 0 Quantity transfer pend PS_QTYBALN P 446 7 0 Quantity balance PS_PROMQTY P 450 7 0 Promotional quantity PS_PROMBEG L 454 10 Promotional begin date PS_PROMEND L 464 10 Promotional end date PS_PTDDEM P 474 7 0 Period to date demand PS_BUYSTAT A 478 1 Buy grp status D,M,W PS_SYSSTAT A 479 1 Sys status N,R,L,S PS_SOQSRVC P 480 7 0 Suggested qty service PS_SOQNITE P 484 7 0 Suggested qty night PS_SOQACT P 488 7 0 Suggested qty actual PS_SOQOVRD L 492 10 Suggested qty ovr-ride PS_FORCAST P 502 9 2 Demand forecast PS_FORFREZ L 507 10 Forecast freeze until PS_PROBDAT L 517 10 On probation until PS_FORDEVP P 527 3 1 Demand forecast DEV % PS_FORSERR P 529 3 3 Demand forecast SERR PS_FORCHG A 531 1 Source forecast chg PS_MINQTY P 532 7 0 Minimum quantity PS_BUYMULT P 536 7 0 Buy multiple PS_BUYMULO P 540 7 0 Buy mult over-ride PS_CONVPAK P 544 7 0 Convenience pack PS_DAYSOUT P 548 3 0 Days out this period PS_DAYSUNT P 550 3 0 Days out point units PS_INTRVAL P 552 5 0 Econ ordr intrval days PS_OTIMFAC P 555 3 0 Order time factor PS_DELAY P 557 3 0 Product delay days PS_MAXDAYS P 559 3 0 Maximum frw buy days PS_MAMINID P 561 3 0 Manual minimum days PS_MAMAXID P 563 3 0 Manual maximum days PS_MAMINIU P 565 7 0 Manual minimum units PS_MAMAXIU P 569 7 0 Manual maximum units PS_SSTFDAY P 573 3 0 Safety stock days PS_FBXDAYS P 575 3 0 ForBuy extra days PS_ADD_DAY P 577 3 0 Add days order point PS_ANSALE$ P 579 13 2 Annual sales dollars PS_ANSALEU P 586 13 2 Annual sales units PS_DEVTIMF P 593 7 3 DEV time factor PS_SSTIMEF P 597 9 3 SS time factor PS_SAFESUM P 602 11 3 SS sum of components PS_VOLUME P 608 7 3 Unit volume PS_VOLUMEO P 612 7 3 Unit volume over-ride PS_VOLUMED P 616 5 0 Volume divisor PS_VOLUMDO P 619 5 0 Volume divisor ovrride PS_WEIGHT P 622 7 3 Unit weight PS_WEIGHTO P 626 7 3 Unit weight over-ride PS_WEIGHTD P 630 5 0 Weight divisor PS_WEIGHDO P 633 5 0 Weight divisor ovrride PS_PURINCR P 636 7 0 Purchase increment PS_DISOTHR P 640 9 4 Bracket build other PS_SEASONL A 645 10 Seasonal profile ID PS_SVCELVL P 655 3 1 Serv level target % PS_SVCEORD P 657 3 1 Serv level orders % PS_SVCEPRV P 659 5 2 Serv level prv perd % PS_FORCINT P 662 3 0 Forecast interval PS_FORCPER P 664 3 0 Forecast period PS_SOQSEQ# P 666 5 0 Suggest order seq # PS_SOQRPER P 669 3 1 SOQ rounding % PS_LONGTRN P 671 3 2 Long term trend rate PS_DELTCNT P 673 1 0 Delete count days PS_SPLTPER P 674 1 0 Split code permanent PS_SPLTTMP P 675 1 0 Split code temporary PS_ENDPER P 676 1 0 End of period code PS_ENDPERS P 677 1 0 End of period code sav PS_FBUYDAT L 678 10 Forward bought date PS_LORDDAT L 688 10 Last ordered date PS_LRCVDAT L 698 10 Last received date PS_LSTXDAT L 708 10 Last interface date PS_SELFBPI P 718 5 3 Selct frd buy pri incr PS_SELFBDS P 721 5 3 Selct frd buy discount PS_SELFBMD P 724 5 3 Selct frd buy mnl days PS_SELFBXD P 727 5 3 Selct frd buy xtr days PS_ACCSALE P 730 7 0 Accumulated sales PTD PS_ACCOUTS P 734 7 0 Accumulated outs PTD PS_RNKBUY$ P 738 7 0 Prod rank buyr dollars PS_RNKBUYU P 742 7 0 Prod rank buyr units PS_RNKLOC$ P 746 7 0 Prod rank locn dollars PS_RNKLOCU P 750 7 0 Prod rank locn units PS_RNKCOM$ P 754 7 0 Prod rank comp dollars PS_RNKCOMU P 758 7 0 Prod rank comp units PS_RNKDATE L 762 10 Prod rank last update PS_POQTYDV P 772 5 0 PO qty divisor PS_POQTYUM A 775 4 PO unit of measure PS_SOQSSO P 779 13 3 SOQ specified stck out PS_SOQESO1 P 786 13 3 SOQ expected stck out1 PS_SOQESO2 P 793 13 3 SOQ expected stck out2 PS_SOQESO3 P 800 13 3 SOQ expected stck out3 PS_SOQESO4 P 807 13 3 SOQ expected stck out4 PS_SOQESO5 P 814 13 3 SOQ expected stck out5 PS_SOQESO6 P 821 13 3 SOQ expected stck out6 PS_DEAL A 828 7 Current deal number PS_DEALBEG L 835 10 Deal begin date PS_DEALEND L 845 10 Deal end date PS_DEALALW P 855 3 0 Deal buys allowed PS_DEALUSE P 857 3 0 Deal buys used |
|
|
K_PURCHIS - Purchase History |