[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference acadmy::tpas_notes

Title:	Transfer Price Administration System
Notice:	Conference has moved to ACADMY::TPAS_NOTES
Moderator:	ACADMY::MAGNI

Created:	Wed Jul 01 1992
Last Modified:	Fri Mar 21 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	102
Total number of notes:	459

24.0. "Ship to - Ship From data" by AWARD::MAGNI (IM&T - 223-9837) Wed Jan 27 1993 13:12

There seems to be some confusion around SHIP_TO and SHIP_FROM.
The following will try to bring some clarity around this issue.



The TPAS software requires a Ship To/From to calculate the transfer
price. The Ship To/From can be either Corporate Stockrooms, Corporate
Plant Mnemonics or Transfer Area. This is defined by the logicals
TPAS$SHIPPING_DATA, which would be S, P or T respectively. Both the
Ship To/From must be the same type of data.

If TPAS$SHIPPING_DATA = S then the Ship To/From are assumed to be stockrooms.
A lookup on the TPAS$STKRM_DB occurs and the Plant Mnemonic is obtained. The 
Plant Mnemonic then is used to find the Transfer Area on the TPAS$DB.

If TPAS$SHIPPING_DATA = P  then the Ship To/From are assumed to be plant
mnemonics. A lookup on the TPAS$DB occurs and the Transfer Area is obtained.

If TPAS$SHIPPING_DATA = T  then the Ship To/From are assumed to be transfer
areas. A lookup on the TPAS$DB occurs and the Transfer Area is validated.



The TPAS$STKRM_DB data is obtained from Corporate Cost Accounting. If you
look closely not all sites have corporate stockrooms. Also some of the GIA
sites have MO (FE Support Group here in the USA) as the plant mnemonic for
their outbound and inbound stockrooms for accounting purposes.

The TPAS$DB TRNSFR_AREA_TABLE ties the Plant Mnemonic to a Transfer Area.
As not all plants have a Corporate Plant Mnemonic, Corporate Tax has created 
Plant Mnemonics on the TPAS$DB TRANSFER_AREA_TABLE that go beyond what
Corporate Cost Accounting has on the Stockroom area.


Due to the disconnects in the Corporate Cost Account Stockroom Table TPAS had 
to allow sites to use Ship To/From as either stockroom, plant mnemonic or 
transfer area.  

So if you are shipping to or receiving from a site that either does not have a
corporate stockroom or has a stockroom pointing to a Plant mnemonic that does
not translate to that site, then change your TPAS$SHIPPING_DATA logical to 
either P or T and send in the appropriate data.

If all you have to enter at the terminal is a stockroom then accept that
data, write some code to pre-translate this Ship To/From data into the
plant mnemonic or transfer area as found on TPAS$DB. This translated Ship 
To/From is to be sent into the TPAS_CALC_TRNSFR_PRC. 


Sites must do analysis on the their SHIP_TO/SHIP_FROM data in terms of the
Corporate Cost Accounting Stockroom data and the Corporate Tax Transfer 
Area. The next replies are a cross of the two tables as of Jan 27, 1993. 
Please note that the data is not stagnant.

T.R	Title	User	Personal Name	Date	Lines
24.1	Corp Plant Mnemonics/Stockroom/Transfer area Report	AWARD::MAGNI	IM&T - 223-9837	`Wed Jan 27 1993 13:14`	428
	Corporate Corporate Plant Stockroom Transfer Plant Name Mnemonic Area AB 1 USA ALBUQUERQUE AB 4 AB 153 AB 158 AB 162 AB 183 AB 459 AB 461 AB 462 AB 463 AB 464 AB 465 AD 242 USA ANDOVE SCMT AG 174 SGO AGUADILLA AG 175 AG 176 AG 178 AG 179 AG 180 AG 181 AG 182 AG 360 AG 470 AG 831 AG 834 AG 978 AS 189 USA AUGUSTA AS 253 AS 531 AS 540 AS 710 AS 712 AS 713 AS 714 AS 715 AS 719 AS 848 AS 995 AT 92 USA LSI A&T AT 95 AT 103 AT 104 AT 105 AT 150 AT 456 AY 138 AY 143 AYO AYR SCOTLN AY 617 AY 618 AY 619 AY 620 AY 631 AY 632 AY 633 AY 634 AY 636 AY 639 AY 640 AY 641 AY 642 AY 647 AY 648 AY 649 AY 651 AY 653 AY 654 AY 655 AY 656 AY 657 AY 658 AY 660 AY 677 AY 678 AY 680 AY 689 AY 851 AY 856 BK 289 USA ED&TRA LOG BO 9 USA BOSTON BO 18 BO 125 BO 220 BO 301 BO 483 BO 484 BO 497 BO 498 BO 525 BO 527 BR 25 PCM BRAZIL BT 278 USA BURLINGTON BT 279 BT 280 BT 300 BT 317 BT 502 BT 503 BT 504 BT 700 BT 702 BT 703 BT 704 BT 723 BT 811 BT 815 BT 898 BT 954 CK 22 KAO EIC KANATA CK 800 CM 238 USA CORP/MFG CM 387 CO 37 USA CONTOOCOOK CO 38 CO 100 CO 109 CO 110 CO 113 CO 114 CO 130 CO 154 CO 155 CO 221 CO 226 CO 230 CO 234 CO 245 CO 255 CO 335 CO 344 CO 399 CO 404 CO 405 CO 543 CO 545 CO 711 CO 730 CO 806 CO 813 CO 909 CR 26 USA CUST RETURN CR 42 CR 69 CX 90 USA COLO SPRING CX 91 CX 98 CX 146 CX 148 CX 593 CX 595 CX 862 CX 900 EN 972 USA ENFIELD FS 17 USA FIELD SERV FS 71 FS 122 FS 127 FS 135 FS 571 FS 807 FX 897 USA GA 115 GAO GALWAY HK 30 HKO HONG KONG HK 31 HK 49 HL 51 USA HUDSON ICM HL 52 HL 290 HL 337 HL 338 HL 339 HL 455 HL 885 HL 886 HL 891 IL 976 GAO ESSG IRELAN JG 251 JGO FSLNIJMEGAN JG 820 JG 821 JG 822 JJ 13 JGO PSGNIJMEGAN JJ 270 JP 393 GYT JAPAN MFG KA 23 KAO KANATA KA 29 KA 131 KA 299 KA 519 KA 804 KB 343 KBO KAUFBEUREN KB 345 KB 347 KB 355 KC 796 KAO CDN DIS CTR KD 789 KAO KDC DIS CTR KR 401 CSS CSS FER MFG LG 12 USA LOGAN LG 137 LG 357 LG 506 LG 520 LG 670 LG 671 LG 975 LG 980 LJ 108 USA GIA PWB ERG LJ 394 LJ 500 LJ 669 LJ 741 LJ 795 MA 16 USA MAYNARD MA 50 MA 53 MA 60 MA 63 MA 374 MA 392 MA 901 MO 2 USA FE SUPT GRP MO 11 MO 46 MO 54 MO 55 MO 57 MO 58 MO 62 MO 67 MO 89 MO 107 MO 123 MO 133 MO 136 MO 142 MO 194 MO 198 MO 205 MO 256 MO 267 MO 269 MO 283 MO 291 MO 292 MO 340 MO 395 MO 396 MO 420 MO 771 MO 773 MO 774 MO 810 MO 817 MO 896 MO 919 MO 963 MO 964 MR 75 USA MARLBORO MR 177 MR 218 MR 237 MR 239 MR 243 MR 362 MR 370 MR 410 MU 581 CSS CSS MUNICH MX 28 MEX CHIHUAHUA MX 40 MX 241 ND 120 USA EUROPE LOGI NG 890 JGO EBUNIJMEGEN NI 20 USA EIS SALEM NI 27 NI 32 NI 33 NI 134 NI 296 NI 590 NI 591 NI 673 NQ 10 USA DECDIRECT NQ 124 NQ 128 NQ 997 NS 44 USA SALEM-NS NS 74 NS 85 NS 664 NS 682 NS 683 NS 684 NS 780 NS 783 NS 786 NS 913 NU 36 --- NU 536 OR 111 FGO OUDENRIJN OR 119 OR 610 PA 580 CSS CSS PARIS QF 129 AYO SQUEENSFERR RE 579 CSS CSS READING SG 47 SGO SAN GERMAN SG 77 SG 170 SG 171 SG 172 SG 173 SG 186 SG 187 SG 197 SG 352 SG 353 SG 354 SG 356 SG 358 SG 359 SG 466 SG 467 SG 474 SG 476 SG 477 SH 14 USA SHREWSBURY SH 21 SH 24 SH 61 SH 132 SH 284 SH 285 SH 287 SH 288 SH 368 SH 371 SH 663 SH 775 SH 998 SN 157 CSS CSS SYDNEY SN 584 SO 582 CSS CSS STCKHLM SP 39 USA SPRINGFIELD SP 45 SP 65 SP 80 SP 84 SP 149 SP 161 SP 163 SP 168 SP 203 SP 206 SP 207 SP 210 SP 306 SP 308 SP 315 SP 316 SP 400 SP 431 SP 432 SP 434 SP 437 SP 501 SP 801 SP 875 SP 879 SP 882 SP 912 SP 915 SP 916 SP 917 SP 950 SP 965 TF 34 USA TEMPE TF 117 TF 118 TF 509 TF 510 TF 512 TF 513 TF 767 TQ 583 GYT CSS TOKYO TR 8 USA TECH RESOUR TR 272 TR 558 TR 750 TR 903 TR 906 TW 86 TAO TAIWAN TW 87 TW 216 TW 217 UC 594 USA PALO ALTO VB 222 VBO VALBONNE VB 224 VB 302 WF 19 USA WESTFIELD WF 43 WF 59 WF 64 WF 78 WF 81 WF 94 WF 160 WF 165 WF 166 WF 200 WF 322 WF 324 WF 325 WF 332 WF 341 WF 346 WF 981 WF 982 WL 83 USA WILMINGTON WL 126 WM 35 USA WESTMINSTER WM 70 WM 101 WM 106 WM 265 YW 223 USA US AREA ZG 93 ZGO SINGAPORE ZG 102 ZG 227
24.2	Plant Mnemonics/Transfer Area without Corp Stockrooms	AWARD::MAGNI	IM&T - 223-9837	`Wed Jan 27 1993 13:15`	28
	Plant Mnemonics/Transfer Areas Without Corporate Stockrooms Plant Transfer Plant name Mnemonic Area BZ PCM BRAZIL DB GAO ERM DUBLIN ET USA EX PRO TECH GI USA FS-GIA GY GYT JAPAN MFG HD AMB HONGKONGDMS HE USA ******** IP USA US ADM PURC JD GYT JAPAN DMS ME USA MSB ENGINEE MV USA DECWEST ENG PW USA ******** SA USA SESA SD SNL AUSTRAL DMS SE USA SEG ENG T1 QRE INDIA T3 DEK KPC T4 PRC PRC T5 SGO SAN GERMAN T6 SGO AGUADILLA ZS USA SEATTLE ENG ZZ SGO INACTIVE PR
24.3	Stockrooms that have no owner (plant Mnemonic)	AWARD::MAGNI	IM&T - 223-9837	`Wed Jan 27 1993 13:16`	575
	Stockrooms without owners: 3 5 6 7 15 41 48 56 66 68 72 73 76 79 82 88 96 97 99 112 116 121 139 140 141 144 145 147 151 152 156 159 164 167 169 184 185 188 190 191 192 193 195 196 199 201 202 204 208 209 211 212 213 214 215 219 225 228 229 231 232 233 235 236 240 244 246 247 248 249 250 252 254 257 258 259 260 261 262 263 264 266 268 271 273 274 275 276 277 281 282 286 293 294 295 297 298 303 304 305 307 309 310 311 312 313 314 318 319 320 321 323 326 327 328 329 330 331 333 334 336 342 348 349 350 351 361 363 364 365 366 367 369 372 373 375 376 377 378 379 380 381 382 383 384 385 386 388 389 390 391 397 398 402 403 406 407 408 409 411 412 413 414 415 416 417 418 419 421 422 423 424 425 426 427 428 429 430 433 435 436 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 457 458 460 468 469 471 472 473 475 478 479 480 481 482 485 486 487 488 489 490 491 492 493 494 495 496 499 505 507 508 511 514 515 516 517 518 521 522 523 524 526 528 529 530 532 533 534 535 537 538 539 541 542 544 546 547 548 549 550 551 552 553 554 555 556 557 559 560 561 562 563 564 565 566 567 568 569 570 572 573 574 575 576 577 578 585 586 587 588 589 592 596 597 598 599 600 601 602 603 604 605 606 607 608 609 611 612 613 614 615 616 621 622 623 624 625 626 627 628 629 630 635 637 638 643 644 645 646 650 652 659 661 662 665 666 667 668 672 674 675 676 679 681 685 686 687 688 690 691 692 693 694 695 696 697 698 699 701 705 706 707 708 709 716 717 718 720 721 722 724 725 726 727 728 729 731 732 733 734 735 736 737 738 739 740 742 743 744 745 746 747 748 749 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 768 769 770 772 776 777 778 779 781 782 784 785 787 788 790 791 792 793 794 797 798 799 802 803 805 808 809 812 814 816 818 819 823 824 825 826 827 828 829 830 832 833 835 836 837 838 839 840 841 842 843 844 845 846 847 849 850 852 853 854 855 857 858 859 860 861 863 864 865 866 867 868 869 870 871 872 873 874 876 877 878 880 881 883 884 887 889 892 893 894 895 899 902 904 905 907 908 910 911 914 918 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 951 952 953 955 956 957 958 959 960 961 962 966 967 968 969 970 971 973 974 977 979 983 984 985 986 987 988 989 990 991 992 993 994 996 999

Conference acadmy::tpas_notes

24.0. "Ship to - Ship From data" by AWARD::MAGNI (IM&amp;T - 223-9837) Wed Jan 27 1993 13:12

24.0. "Ship to - Ship From data" by AWARD::MAGNI (IM&T - 223-9837) Wed Jan 27 1993 13:12