CFS90 Campuses Configuration Data Values PO Module - CMS

Document Sample
CFS90 Campuses Configuration Data Values PO Module - CMS Powered By Docstoc
					COMMON
Setup Financials/Supply Chain > Common Definitions > Shipping and
Receiving > Freight Terms


FREIGHT_TERMS - Freight Terms Codes Definition
SetID    Freight Trm      Descr                                     Short Desc   Title Pass   CIF Paid
CICMP      DA                 FOB-Destination Prepay & Add          Dest PPA     B            B
FLCMP      DA                 FOB-Destination Pre Pay & Add         Dest PPA     B            B
HMCMP      DA                 FOB Destination Prepay & Add          Dest PPA     B            B
CICMP      FOB                FOB-Destination                       FOB-Destin   B            S
FLCMP      FOB                FOB-Destination                       FOB-Destin   B            S
HMCMP      FOB                FOB-Destination                       FOB-Destin   B            S
Terms 1
COMMON
Setup Financials/Supply Chain > Common Defintions >
Shipping and Receiving > Ship Via Codes


SHIP_METHOD - Shipping Method Table
SetID      Ship Via         Descr                     Short Desc   Pick Up Weight Volume
                                                                         Max    Max               Minimum Volume UOM
                                                                                        Minimum Weight      Weight
CICMP      AIRBORNE         Airborne                  Airborne     N      0.0000 0.0000    0.0000    0.0000
FLCMP      AIRBORNE         Airborne                  Airborne     N      0.0000 0.0000    0.0000    0.0000
HMCMP      AIRBORNE         Airborne                  Airborne     N      0.0000 0.0000    0.0000    0.0000
CICMP      BESTMETHOD       Best Method               BestMethod   N      0.0000 0.0000    0.0000    0.0000
FLCMP      BESTMETHOD       Best Method               BestMethod   N      0.0000 0.0000    0.0000    0.0000
HMCMP      BESTMETHOD       Best Method               BestMethod   N      0.0000 0.0000    0.0000    0.0000
Volume Transport Mode
       4
       4
       4
       3
       3
       3
CAMPUS
Setup Financials/Supply Chain > Product Related > Procurement
Options > Purchasing > Manufacturers


MANUFACTURER - Manufacturer Table
SetID      Mfg ID             Short Desc          Descr         UPN Type   Owned
COMMON Channel Islands
Setup Financials/Supply Chain > Product Related > Procurement Options >
Charges/Costs > Misc Charge/Landed Cost Defn


CM_LC_COMPONENT
SetID    Misc Chg             Descr                         Type          Prorate   LC Comp
HMCMP       FREIGHT           Prorated Freight              FRG           Y         N
HMCMP       MISC              Prorated Misc Charges         MISC          Y         N
HMCMP       SALESTAX          Prorated Sales Tax            STX           Y         N
HMCMP       USETAX            Prorated Use Tax              UTX           Y         N
Calc Method   Alloc Method   Merch Vendor   Cost Elmnt   Accrue Charge   Group ID
FL            MAT            Y                           N
FL            MAT            Y                           N
STX           MAT            Y                           N
UTX           MAT            Y                           N
Rcv Tol %          % Ext Tol          RTV Credit
            0.00               0.00   N
            0.00               0.00   N
            0.00               0.00   N
            0.00               0.00   N
CAMPUS
Setup Financials/Supply Chain >Product Related > Procurement
Options > Purchasing > Ship To Locations

Purchasing Dfn needs to be setup before Receiving BU points to xxCMP
                  Change Eff Date to 1/1/2000

SHIPTO_VNDR_LOC - Shipto Vendor Priority
SetID         Ship To              Apply All            Vndr SetID Vendor           Order VndrSetID
HMCMP              ALAMEDA              N               HMCMP
HMCMP              EUREKA               N               HMCMP                       HMCMP


SUT_DFLT_TBL - Sales/Use Tax Default Table
SetID           Ship To              Sort Seq No. Item SetID Item                   Category
HMCMP              ALAMEDA                         17
HMCMP              EUREKA                           9


SUT_EXCPTN_TBL - SUT Exception
SetID         Ship To                   Eff Date        Status    SUT Excptn Type   SUT Excptn Cert
HMCMP              ALAMEDA                  1/1/2000 A            N
HMCMP              EUREKA                   1/1/2000 A            N


SHIPTO_TBL - Shipping Locations
SetID              Ship To              Eff Date        Status    Short Desc        Descr
HMCMP              ALAMEDA                  1/1/2000 A            ALAMEDA CO        ALAMEDA COUNTY
HMCMP              EUREKA                   1/1/2000 A            EUREKA            EUREKA
Vendor            Order Loc ID   SUT Flag
                                 N
                                 N



Vndr SetID        Vendor         Location   Ult Use Code   Code      Use Tax      Tax Applicabile
                                                           ALAMEDA   ALAMEDA      T
                                                           EUREKA    EUREKA       T




Excptn End Date




Copy              Vendor         DN Code    DN SetID       User      Comment ID   Random No         IN Unit
N                 N                                                                             0
N                 N                                                                             0
BU Recv   Send Receipt Regn SetID Region
HMSPF     N           HMSPF
HMCMP     N           HMCMP
CAMPUS
Setup Financials/Supply Chain >Product Related >
Procurement Options > Purchasing > Standard Comment
Type
            Change Eff Date to 1/1/2000

STD_COMM_TYP_PO - Std Comment Type Table - Purch
SetID    Std Type     Eff Date      Status       Descr                     Short Desc
HMCMP       BLK                1/1/2000 A             Blanket Orders       Blanket
HMCMP       CAS                1/1/2000 A             Cash                 CASH
HMCMP       HAZ                1/1/2000 A             Hazardous Comments   HAZ
CAMPUS
Setup Financials/Supply Chain >Product Related > Procurement            Campuses will need to manually add long
Options > Purchasing > Standard Comment                                 comments to each Comment ID
                            Change Eff Date to 1/1/2000
                            Delete data before uploading

STD_COMM_TBL_PO - Std Comments Table - Purch
SetID       Std Type Comment ID Eff Date                       Status   Descr                                     Short Desc
HMCMP            BLK        BLKT                 1/1/2000 A             Blanket PO Comment (All)                  Blanket PO
HMCMP            BLK        SBLK                 1/1/2000 A             Blanket Service Order Comment             Blanket SO
User   Comment ID   Random No
                                0
                                0
CAMPUS
Items > Define Controls > Item
Categories                                    Change Eff Date to 1/1/2000
                                              Upload Does not like quotations in description (Column F)
                                              Buyer - change to match new User ID or leave blank (Column X)
ITM_CAT_TBL - Category Codes
SetID     Type Code Category       Eff Date   Descr                                            Short Desc     Profile ID
HMCMP PSF            96800 00254      1/1/2000 PUBLIC WORKS RELATED SERVICE                    PUBLIC WKS
HMCMP PSF            90600 00219      1/1/2000 ARCHITECTURAL SVS/PROF                          ARCH PROF
Nbr Items       LT Days    Inspect   Insp UOM   Inspect ID   Rejct Days    Account   Alt Acct   Price Tol    % Prc Tol
            0             0N         S                                    0 605000                 0.00000          0.00
            0             0N         S                                    0 607002                 0.00000          0.00
Recv Reqd   Ext Tolrnc    % Ext Tol     Rcv Tol %   Rjct Ovr %   Buyer   Partial   Comments   Currency   Under
N               0.00000          0.00          0.00 N                    1                    USD                0
N               0.00000          0.00          0.00 N                    1                    USD                0
Src Method   LT Factor%     Pr Factor%     Shipto Factor%      Vndr Factor%      End Dt   Nbr Mnths       Start Date
B                    0.00           0.00                0.00              0.00                        0
B                    0.00           0.00                0.00              0.00                        0
Ttl Cat Amt     Start Month       Price Tol Under     % Prc Tol Under      Ext Tolrnc    % Ext Tol     Days Late
        0.000                 0             0.00000                 0.00       0.00000          0.00               0
        0.000                 0             0.00000                 0.00       0.00000          0.00               0
Accum Level   Status   Market Code   Nature   Where Performed   Ult Use Code   Over Price
              A        01            G                                         99999999.00000
              A        01            G                                         99999999.00000
Under Price      Over % Price     Under % Price   RFQ Req
99999999.00000           999.00            999.00 N
99999999.00000           999.00            999.00 N
CAMPUS
Setup Financials/Supply Chain
>Product Related > Procurement
Options > Purchasing > Inspection
Routings                                         Change Eff Date to 1/1/2000

ROUTING_HDR - Inspection Operations Header
SetID                               Inspect ID   Descr                         Short Desc




ROUTING_LN - Inspection Operations
SetID                               Inspect ID   Batch Seq                     Eff Date     Status   Run Time




ROUTING_SCR - Inspection Operations Scroll
SetID                               Inspect ID   Batch Seq
Time Type   Op Instr

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:18
posted:8/19/2012
language:
pages:23