Description: Deal Information from K3S-Replenish(R) to your PO System In the program you are developing that will read K3S approved purchase orders (files K_INTORDB header, K_INTORDD detail), you can access the 'bill back' information by reading the K3S Deal files. You will see two logical files against K_INTORDD giving you a choice of the sequence to populate your PO detail file. K_INTORDDA if you need PO lines by your product ID sequence K_INTORDDB if you need PO lines by your product sequence field As you read a detail record in the K_INTORDD file, you'll see a field ID_DEAL. When that field is not blank, it will signal to you a deal is active for that product, and below are the deal files. K_DEALSUM Deal summary information K_DEALDET Deal detail information (products in deal) K_DEALALW Deal allowance information File K_DEALSUM will provide the Begin and End dates for the deal. Logical file K_DEALSUMA can be used with key DM_KEY DM_COMP populate with 'A' for ABC Distributing DM_DEAL populate with ID_DEAL File K_DEALALW will provide many of the values you are after for that product Logical file K_DEALALWA can be used with DA_KEY DA_COMP populate with 'A’ for ABC Distributing DA_LOCN populate with 'MIA' for Miami DA_DEAL populate with ID_DEAL DA_PROD populate with ID_PROD Next you will want to READE with DA_KEY, since that product could have multiple 'bill back' allowances on the same deal. The information you are after will be in the fields: DA_APPLY 'B' for 'bill back' or 'O' for 'off invoice' DA_FACTTYP '%' for percentage, 'D' for dollar difference, '$' for dollar value DA_FACTVAL contains the deal amount, either a percentage or dollar value DA_UNIT the cost divisor when not using '%' percentage DA_TYPE when DA_APPLY is 'B' for 'bill back', this will have your 3 types of '01 Advertising' or '02 Merchandising' or '03 Slotting' The K3S deal files are time phased, with a Begin and End date. Physical file – K_DEALPER for permanent deal information K3S also contains a file called K_DEALPER where Permanent Deals can be stored. These would remain in the file until a user removes them. K3S customers can re-populate this file from their own database, or enter permanent deals through the K3S screens. DR_COMP 1 COLHDG('Company' 'ID') DR_LOCN 5 COLHDG('Location' 'ID') DR_SUPL 10 COLHDG('Supplier' 'ID') DR_SUPLSUB 10 COLHDG('Sub' 'supplier' 'ID') DR_PROD 25 COLHDG('Product' 'ID') DR_BIRTH L COLHDG('Perm' 'deal' 'birth') DR_LASTUPD L COLHDG('Perm' 'deal' 'last') DR_MEMO 15 COLHDG('Memo') DR_PERMTYP 2 COLHDG('Permanent' 'type') DR_TYPE 2 COLHDG('Deal' 'type') DR_APPLY 1 COLHDG('Bill/Off/Auto' 'code') DR_FACTTYP 1 COLHDG('Factor' 'type' '$,D,%') DR_FACTVAL 9 4 COLHDG('Factor' 'value') DR_UNIT 5 0 COLHDG('Unit for' 'dollars') Field explanations: DR_COMP 1 COLHDG('Company' 'ID') This 1 character value is used throughout the K3S-Replenish system to identify the company being processed. Examples: B for Bindley Western J for JT Davenport D for Dimmick Auto DR_LOCN 5 COLHDG('Location' 'ID') This 5 character value is used to identify the distribution center where this product is being replenished. Examples: Loc ID Location name 01 Charlotte, NC 02 Raleigh, NC 001 Columbia, SC 002 New York, NY TEX01 Houston, TX TEX02 Dallas, TX DR_SUPL 10 COLHDG('Supplier' 'ID') This value contains the product’s regular supplier ID. Examples: Supplier ID Supplier Name ABCDEFGHIJ ABC Company 00010 Wizzard Mfg DR_SUPLSUB 10 COLHDG('Sub' 'supplier' 'ID') This value will allow a supplier to be sub-divided into separate sections for review purposes. Leave this value blank if all products are to be reviewed together. Examples: Supplier ID Sub ID Supplier Name ABCDEFGHIJ FROZEN ABC Company A -Frozen ABCDEFGHIJ FRIDGE ABC Company B -Fridge ABCDEFGHIJ DRY ABC Company C -Dry 00010 PINTS Wizzard Mfg 3 -Pints 00010 QUARTS Wizzard Mfg 2 -Quarts 00010 GALLONS Wizzard Mfg 1 -Gallons DR_PROD 25 COLHDG('Product' 'ID') This value contains the product ID. Examples: Product ID Product description 200578 Dial soap 397346 Tooth paste ABC-10/XYZ.047 Wrench BCI*984/1Z497 Screw Driver DR_BIRTH L COLHDG('Daily' 'trans' 'birth') This value contains an *ISO date for the day this record was created. Examples: *ISO Birth date 1998-06-08 2003-04-23 DR_LASTUPD L COLHDG('Daily' 'trans' 'last') This value contains an *ISO date for the day this record was last updated. It will contain the same value as the field IP_BIRTH. DR_MEMO 15 COLHDG('Memo') This field represents a place for the user to enter a memo to describe the permanent deal. DR_PERMTYP 2 COLHDG('Permanent' 'type') L1 Location – all products Type L1 will apply the deal to all products at a specified location. P1 Product - all locations Type P1 will apply the deal to a specified product at all locations. P2 Product - this location Type P2 will apply the deal to a specified product at a specific location. S1 Supplier – all locations Type S1 will apply the deal to a specified supplier at all locations. S2 Supplier – this location Type S2 will apply the deal to a specified supplier at specified location. DR_TYPE 2 COLHDG('Deal' 'type') There are several deal allowance types to choose from. See types below: AD Advertising OT Other BA Buying allowance PI Price increase BB Billback supplier PR Promotional DS Display QD Quantity discount HA Handling OI Off invoice ND New distribution DR_APPLY 1 COLHDG('Bill/Off/Auto' 'code') This value is the deal application type; it tells you how the deal is to be applied. There are four choices: A Automatic B Bill back O Off invoice P Price increase DR_FACTTYP 1 COLHDG('Factor' 'type' '$,D,%') The factor type defines how the value in field DR_FACTVAL is to be processed. $ - the entry is the actual deal value D – the entry is the actual difference from regular % - the entry is a percentage value DR_FACTVAL 9 4 COLHDG('Factor' 'value') The factor value is the deal amount, described by DR_FACTTYP. DR_UNIT 5 0 COLHDG('Unit for' 'dollars') The unit field works with the field DR_FACTVAL when it is a dollar value, and not a percentage value. Example: $2.50 per 12 |
|
|
Deal Information From K3S-Replenish® to your PO System |