APP ~ Applications Control

May 7, 2024

Sections in this article

• Application Control Records
  • ALT_SRCE NOTES
  • ALTUNIT9
  • AUTO_EMAILREPORTS
  • BEST_FIT DEFAULTS
  • BLANKSPACEIE_CHAIN
  • BLANKSPACEIE_CUSTOMR
  • BLANKSPACEIE_ORDER#
  • CHECK_PR PROBATION
  • CHECK_RE RE_PROCESS
  • CHECK_U U1_U4 EXIT
  • COLLECT DEAL_LOG
  • COMP_SUPL F5=APPROVE
  • DELAY_DAYSPROCESSING
  • DENYCHANGE
  • EXCL_BUY BACK_OUT
  • EXCL_BUY CLR_RECORD
  • F1=HELP ENABLE
  • K_PRODLNK PROCESSING
  • K3S_C131 REVERSE
  • K3S_M080 EXCLUDE
  • K3S_M080 MIN_SEASON
  • K3S_PO
  • K3S_SLRP19LARGE_VALU
  • K3S_0010 BYRPERFORM
  • K3S_0010 F06ALLOW
  • K3S_0010 RMV_BORDER
  • K3S_1010 F2=ALL
  • K3S_1010 OCT_FILTER
  • K3S_1010 OSV_8_ALL
  • K3S_1010 USER_GROUP
  • K3S_1015 F17=
  • K3S_1015 SUPL_NAM
  • K3S_1020 APR_FILTER
  • K3S_1020 EXT_DEALS
  • K3S_1020 OC_WARNING
  • K3S_1030 VIEW_2_TYP
  • K3S_1030 VIEW_3_TYP
  • K3S_1040 FLIP
  • K3S_1040 LAST_21
  • K3S_1040 PROTECT
  • K3S_1040 SOQ_CHANGE
  • K3S_1050 BATCH_PO
  • K3S_1050 DLY_ARRIVE
  • K3S_1100 POTYPE_T
  • K3S_1220 EXC_DEALS
  • K3S_1500 ALL_FROZEN
  • K3S_1500 ALTSRC_ALL
  • K3S_1500 CAR_COUNT
  • K3S_1500 DELAY_FC
  • K3S_1500 DELAY_VOC
  • K3S_1500 G1_MINSVC
  • K3S_1500 K_DEALPER
  • K3S_1500 MAX_TO_MIN
  • K3S_1500 MUST_RECV
  • K3S_1500 RM_PRV_ORD
  • K3S_1500 SHUT_OFF
  • K3S_1810 DEAD_NET
  • K3S_1900 CMB_SPLITS
  • K3S_2000 ALLOW_DELT
  • K3S_2000 COMB_SUPL
  • K3S_2000 F21=
  • K3S_2000 SP_EXCLEAD
  • K3S_2000 SP_GROUP1
  • K3S_2000 SP_GROUP2
  • K3S_2000 SP_GROUP3
  • K3S_2000 SP_GROUP4
  • K3S_2000 SP_GROUP5
  • K3S_2000 WRITE_EXIT
  • K3S_3000 ALLOW_BOTH
  • K3S_3000 PO_SCRTEXT
  • K3S_3000 PR_BUYMULO
  • K3S_3010 COMBINE
  • K3S_3016 COPY_ALL
  • K3S_3016 DEFAULT_C
  • K3S_3020 DEV_UPDATE
  • K3S_3030 F20=
  • K3S_3030 NEW_PROB
  • K3S_3030 NO_FACTR_0
  • K3S_3030 SYSSTAT=N
  • K3S_3030 UP_STREAM
  • K3S_3050 CHANGE_PO#
  • K3S_3050 F19=GROUPS
  • K3S_3050 WEEKLYLIFT
  • K3S_3052 AT_LEAST_1
  • K3S_3070 WEEKEND
  • K3S_3090 BY_PASS_D
  • K3S_3100 LIB_FILE
  • K3S_3100 LIB_QRY
  • K3S_3200 FILTER
  • K3S_3200 MAX_DEV
  • K3S_3225 HEADING_2
  • K3S_3301 LONG_PROD
  • K3S_3433 COLLECT
  • K3S_3439 GEN_EXCPTN
  • K3S_36OO ALL_D_OVER
  • K3S_3600 BIRTH_TEST
  • K3S_3600 LAST_RECVD
  • K3S_3600 PR_BUYMULT
  • K3S_3600 PR_MAMINIU
  • K3S_3600 PR_MINQTY
  • K3S_3600 PR_QTYOORD
  • K3S_3600 PR_RFBIRTH
  • K3S_3615 DSPLY NAME
  • K3S_3715 EXCLUDE_D
  • K3S_3900 ORIG_ORDER
  • K3S_3920 COLLECT
  • K3S_3920 SHIFT
  • K3S_3920 SHIFT + (LOCATION ID)
  • K3S_3940 FORCE_LOST
  • K3S_3940 LC_DAILY=0
  • K3S_5030 BLOCK_SUPL
  • K3S_5030 VALID_USER
  • K3S_5050 ALLOW_PCT
  • K3S_5050 CUST_DEALS
  • K3S_5050 MMDD_ENTRY
  • K3S_5050 ONE_LOCN
  • K3S_5050 OVERLAP_OK
  • K3S_5050 REF_DUPS
  • K3S_5056 PROCESSING
  • K3S_5300 VALID_USER
  • K3S_8000 CURSOR_POS
  • K3S_8000 F5=PATH
  • K3S_8011 GET_COST
  • K3S_8011 SAVE_COST
  • K3S_8530 CPY_DEMAND
  • K3S_8540 NEW_SLOW
  • K3S_9010 BLOCK_ALTS
  • K3S_9010 CLR_PROMO
  • K3S_9010 CORP_PROF
  • K3S_9010 COST_0
  • K3S_9010 DAYS_OUT
  • K3S_9010 DAYS_OUT_2
  • K3S_9010 NEW_SLOW
  • K3S_9010 PE_SNPSHOT
  • K3S_9010 PE1FLTR
  • K3S_9010 PR_BIRTH
  • K3S_9010 PR_LSTRCVD
  • K3S_9010 PR_QTYPEND
  • K3S_9011 BLOCK_3037
  • K3S_9040 NEW_ENTRY
  • K3S_9702 K3S_SEND
  • LEAD_TIME ADJUSTMENT
  • LOWERCASE SUPL_NAME
  • METRICS INVENTORY
  • METRICS MFGOUT
  • METRICS USER
  • MIN_MAX AVERAGE=O
  • MIN_MAX STRAIGHT=1
  • NOTE_DSPLY
  • NT_SERVER BEING_USED
  • PE_WARNINGSYSTEM
  • PITCO
  • PRODUCT DISPLAY
  • PRODUCT RIGHT_ADJ
  • RESTRICT (USER)
  • SALES JOURNAL
  • SEASONAL ENTRY
  • SPECIAL MESSAGE
  • STORE LEVEL
  • USECHAINWITHORDER#

Application Control Records

Table Code Type: APP

K3S has several Application control records that allow management to control the working environment for the buyers.

ALT_SRCE NOTES

Description:

This table code gives the buyer the option to display the normal ‘supplier note’ for alternate source records.

Enable:

If Flag 1 = 1, then you would like gives the buyer the option to display the normal supplier note for alternate source records

If Flag 1 = 0, then you would like this feature turned off

Structure:

Table Code Value: ALT_SRCE NOTES
Table Code Description 1: Display regular supplier note?
Table Flag 1: 0

Programs Used In:

• K3S_1040
• K3S_1041
• K3S_3030
• K3S_3031

ALTUNIT9

Description:

This tablecode will control displaying the value of PR_DISUN9O (Unit 9 over-ride) instead of the Unit 9 calculation (SOQ x Unit 9) when enabled.

Enable:

If Flag 1 = 1, then you would like this feature enabled

If Flag 1 = 0, then you would like this feature turned off

Structure:

TA_CODETYP = APP
TA_CODEVAL = ALTUNIT9
TA_CODEDS1 = Display Unit 9 Over-ride value instead of calculation

TA_CODEDS2 = Enable with Flag1=1; Default Flag1 = 0

TA_FLAG1 = 0

AUTO_EMAILREPORTS

Description:

For an email application on your server such as MMAIL, this table code has the ability to automatically send out email reports to the users in PDF and CSV format.

Enable:

If Flag 1 = 1, then you would like for the system to automatically email reports to the users in either PDF and CSV format

If Flag 1 = 0, then you would like this feature turned off

Flag 2 will set it by email application:

• If Flag 2 is set to 0 = MMAIL
• If Flag 2 is set to 1 = EZEML400
• If Flag 2 is set to 2 = ESEND
• If Flag 2 is set to 3 = SNDSMTPEMM
• If Flag 2 is set to 4 = MAILTOOL
• If Flag 2 is set to 5 = ELITEMAIL

Structure:

Table Code Value: AUTO_EMAILREPORTS
Table Code Description 1: Automatically email reports to users?
Table Code Description 2: Set Flag1 = 1 for Yes or 0 = No
Table Code Description 3: Flag2 type: 0=MMAIL 1=EZEML400 2=ESEND 3=SNDSMTPEMM 4=MAILTOOL 5=ELITEMAIL
Table Flag 1: 0
Table Flag 2: 0

Programs Used In:

• K3S_FX540B
• K3S_EMLRPT
• K3S_LSTORD
• AR_EMLREPT
• AR_EXCER

BEST_FIT DEFAULTS

Description:

When splitting a PO, this table code will allow you to split order by the type and value. You can also set those defaults used by AR_DIVPROR.

Enable:

If Flag 1 = 1, then you would like to set up Best Fit Split on POs

If Flag 1 = 0, then you would like to disable this feature

For setting up a default value for the ‘Unit’ field, enter the default value in Table Number 1

For setting up a default value for the ‘Value’ field, enter the default value in Table Number 3

Structure:

Table Code Value: BEST_FIT DEFAULTS
Table Code Description 1: Set defaults for Best Fit Split used by AR_DIVPROR
Table Code Description 2: Number 1 contains unit
Table Code Description 3: Number 3 contains value; decimals must be zeros
Table Flag 1: 1
Table Flag 5: 0
Table Number 1 (5.0): 0
Table Number 3 (11.4): .0000

BLANKSPACEIE_CHAIN

Description:

This table code allows the ‘Customer Orders’ section to handle IE_CHAIN values with leading blanks.

Note: From GH issue Retalix right adjusted (so leading white space) characters for customer ID and order number #2321

Enable:

If Flag 1 = 1, then you would like to enable this feature

If Flag 1 = 0, then you would like to disable this feature

Structure:

Table code type.. APP

Description…… Applications control

Table code value. BLANKSPACE IE_CHAIN

Description 1…. Does K_INTDALY.IE_CHAIN have leading blank spaces?
Description 2…. Set Flag1=1 for Yes. Default Flag1=0 No.

Description 3…. Number 1 contains the size of field IE_CHAIN

Flag 1……….. 0

Number 1 (5.0)… 10

BLANKSPACEIE_CUSTOMR

Description:

This table code allows the ‘Customers Orders’ section to handle IE_CUSTOMR values with leading blanks.

Note: From GH issue Retalix right adjusted (so leading white space) characters for customer ID and order number #2321

Enable:

If Flag 1 = 1, then you would like to enable this feature

If Flag 1 = 0, then you would like to disable this feature

Structure:

Table code type.. APP

Description…… Applications control
Table code value. BLANKSPACE IE_CUSTOMR

Description 1…. Does K_INTDALY.IE_CUSTOMR have leading blank spaces?

Description 2…. Set Flag1=1 for Yes. Default Flag1=0 No.

Description 3…. Number 1 contains the size of field IE_CUSTOMR

Flag 1……….. 0
Number 1 (5.0)… 10

BLANKSPACEIE_ORDER#

Description:

This table code allows the ‘Customers Orders’ section to handle IE_ORDER# values with leading blanks

Note: From GH issue Retalix right adjusted (so leading white space) characters for customer ID and order number #2321

Enable:

If Flag 1 = 1, then you would like to enable this feature

If Flag 1 = 0, then you would like to disable this feature

Structure:

Table code type.. APP
Description…… Applications control

Table code value. BLANKSPACE IE_ORDER#

Description 1…. Does K_INTDALY.IE_ORDER# have leading blank spaces?

Description 2…. Set Flag1=1 for Yes. Default Flag1=0 No.

Description 3…. Number 1 contains the size of field IE_ORDER#

Flag 1……….. 0

Number 1 (5.0)… 10

CHECK_PR PROBATION

Description:

This table code lets you control whether or not PR checks (for products with a ‘Probation’ status) should occur only during the last 10 days of their probationary status or all throughout probation.

Enable:

If Flag 1 = 1, then PR checks will only show during the last 10 days of their probationary status

If Flag 1 = 0, then the PR checks will show all throughout their probation

Structure:

Table Code Value: CHECK_PR PROBATION
Table Code Description 1: PR check during last 10 days?
Table Flag 1: 0

Programs Used In:

• K3S_1500
• K3S_3030
• K3S_3031
• AR_STSPROR
• AR_UAVPROR

CHECK_RE RE_PROCESS

Description:

This table code allows you to control whether or not RE check processing (for products with a ‘Reminder’ status) should occur at all.

Enable:

If Flag 1 = 1, products with the status of Reminder, will be tagged under Suggested Orders

If Flag 1 = 0, this feature will be turned off

Structure:

Table Code Value: CHECK_RE RE_PROCESS
Table Code Description 1: Perform RE Check processing?
Table Flag 1: 1

Programs Used In:

• K3S_1500

CHECK_U U1_U4 EXIT

Description:

U checks are user defined checks that, if enabled, will be displayed on the Home page. This table code allows you to control whether or not the system will identify U1-U4 checks in suggested orders. If you would like U check processing to occur, then program K3S_1530 is the program that can be modified to determine what logic a product must meet to be a U1, U2, U3 or U4 check.

Enable:

If Flag 1 = 1, U checks 1-4 will be enabled

If Flag 1 = 0, U checks will be disabled

Structure:

Table Code Value: CHECK_U U1_U4_EXIT
Table Code Description 1: Exit to U1 - U4 processing?
Table Flag 1: 1

Programs Used In:

• K3S_FX500K
• K3S_FX504A
• K3S_1500

COLLECT DEAL_LOG

Description:

When displaying a list of all deals for a buy group, this table code controls whether or not the deal history log will be collected and displayed. Recorded infomation will be found in file K_DEALLOG.

Enable:

If Flag 1 = 1, then you will be able to view the deal and see any changes were made to deal information

If Flag 1 = 0, this will disable this feature

Structure:

Table Code Value: COLLECT DEAL_LOG
Table Code Description 1: Collect deal log information?
Table Flag 1: 1

Programs Used In:

• K3S_2001
• K3S_5040
• K3S_5050
• K3S_5051
• K3S_5055
• K3S_5056
• K3S_5057
• K3S_5110
• K3S_5111
• AR_ADADELW
• AR_ADDDEAL
• AR_ADDDELW
• AR_ALLDEAL
• AR_APRDEAL
• AR_CPRDEAL
• AR_CPYDEAL
• AR_CPYDELW
• AR_CPYSUPL
• AR_DAPDEAL
• AR_DELDEAL
• AR_DPRDEAL
• AR_PRODEAL
• AR_ULNDELW
• AR_UPDDEAL
• AR_UPDDELW
• AR_UPRDEAL

COMP_SUPL F5=APPROVE

Description:

When you have an order that has a combined supplier (subcode ‘h’), you can control whether or not a buyer can approve an order for a combined supplier without splitting the order. For Flag 2, this will allow you to control whether or not a buyer can approve an order for mixed suppliers without splitting the order.

Enable:

If Flag 1 = 1, then you would like to allow for approval without splitting the order

If Flag 1 = 0, then you would not like to allow for approval on the order

If Flag 2 = 1, allow mixed suppliers without splitting the order

If Flag 2 = 0, then you would not like for a buyer to be able to approved a mixed supplier without splitting set

Structure:

Table Code Value: COMB_SUPL F5=APPROVE
Table Code Description 1: Allow F5 approve without split
Table Code Description 2: Flag 2=1 allow mixed suppliers
Table Flag 1: 0
Table Flag 2: 0

Programs Used In:

• K3S_POPARM

DELAY_DAYSPROCESSING

Description:

This table code checks to see if the ‘delay days’ logic should be used. Delay days processing refers to setting a minimum number of days to have the system wait before suggesting to order a product once it has fallen below the order point. Auto parts distributors are well suited for the delay days processing environment and should turn this feature ON.

Enable:

If Flag 1 = 1, the Delay Days logic will be used

If Flag 1 = 0, the Delay Days logic will not be used

Structure:

Table Code Value: DELAY_DAYSPROCESSING
Table Code Description 1: Perform delay days processing?
Table Flag 1: 1

Programs Used In:

• K3S_9010

DENYCHANGE

Description:

This table code gives you the option to hide the ‘Change Supplier’ button on the PO approval screen.

Enable:

If Flag 1 = 1, then you would like to hide the ‘Change Supplier’ button

If Flag 1 = 0, then you would not like to show the ‘Change Supplier’ button

Structure:

Table Code Value: DENYCHANGE
Table Code Description 1: This value will deny change supplier when approving an order if Flag 1 = 1
Table Flag 1: 1

Programs Used In:

All logic used in the graphical interface.

EXCL_BUY BACK_OUT

Description:

This table code allows you to control whether or not the system will suggest buying a product if a back out quantity exists.

Note: Auto parts distributors are advised to turn Flag 1 to 1=ON.

Enable:

If Flag 1 = 1, it will exclude buying when a back out quantity exists

If Flag 1 = 0, it will allow you to buy a product even when a back out quantity exists

Structure:

Table Code Value: EXCL_BUY BACK_OUT
Table Code Description 1: Exclude buying with back out?
Table Code Description 2: Auto parts set flag1 to a 1
Table Flag 1: 0

Programs Used In:

• K3S_1500
• K3S_1510

EXCL_BUY CLR_RECORD

Description:

This table code allows you to control whether or not the system will clear out the ‘Exclude Buying Until’ field once the date has expired.

Enable:

If Flag 1 = 1, you would like for this field to be cleared once the date expires

If Flag 1 = 0, you would not like for this field to be cleared once the date expires

Structure:

Table Code Value: EXCL_BUY CLR_RECORD
Table Code Description 1: Exclude buying clear records?
Table Code Description 2: Clear PR_EXCUNTL after expire
Table Flag 1: 0

Programs Used In:

• K3S_1500
• K3S_1510
• K3S_9010

F1=HELP ENABLE

Obsolete APP. No longer valid in R6.

K_PRODLNK PROCESSING

Description:

This table code checks the PO processing type to see if the product is active and should be used for the following programs:

• K3S_2041 - Order Cycle Analysis
• K3S_3340 - Ranking Report
• K3S_3600 - Overstocked Products Calculation

Enable:

If Flag 1 = 1, you would like for it to be checked for it to be used for those programs

If Flag 1 = 0, you would not like for it to be checked

Structure:

Table Code Value: K_PRODLNK PROCESSING
Table Code Description 1: Use K_PRODLNK in 2041, 3340?
Table Code Description 2: also 3600
Table Flag 1: 1

Programs Used In:

• K3S_2041
• K3S_3340
• K3S_3600
• AR_CALORCY
• AR_LTUORCY
• AR_OVSTK
• BK_OVSTK

K3S_C131 REVERSE

Description:

The Manual Min/Max sequence is defaulted to first show ‘units’ and then ‘days’. However, if this table code is turned on, it will first calculate the ‘days’ and then the ‘units’.

Enable:

If Flag 1 = 1, then first calculate the days and then the units

If Flag 1 = 0, then first calculate the units and then the days

Structure:

Table Code Value: K3S_C131 REVERSE
Table Code Description 1: Reverse Manual Min/Max sequence to Days 1st, Units 2nd ?
Table Flag 1: 0

Programs Used In:

• K3S_1500
• K3S_1510
• K3S_3025
• AR_CALPROP

K3S_M080 EXCLUDE

No use found

K3S_M080 MIN_SEASON

Description:

This table code checks to see if the ‘minimum seasonal factor’ is in use. It must have a reasonable value that is between .01 and .50 or special logic will not be used.

Enable:

If Flag 1 = 1, then check to see if the Minimum Seasonal Factor is being used

If Flag 1 = 0, then don’t check to see if the Minimum Seasonal Factor is being used

Structure:

Table Code Value: K3S_M080 MIN_SEASON
Table Code Description 1: Min seasonal factor for update
Table Code Description 2: Use Flag 1 and Number 2
Table Flag 1: 0
Table Number 2: .00

Programs Used In:

• K3S_3035
• K3S_9010

K3S_PO

Description:

This table code is viewing to see if whether or not K3S purchase orders have been installed for this customer.

Enable:

If Flag 1 = 1, then the K3S PO system is currently installed

If Flag 1 = 0, then the customer is not using the K3S PO system

Structure:

Table Code Value: K3S_PO
Table Code Description 1: P.O. System installed?
Table Flag 1: 0

Programs Used In:

• K3S_0010
• K3S_2000

K3S_SLRP19LARGE_VALU

Description:

This table code is used for the store level only on reported large inventory.

Enable:

If Flag 1 = 1, you would like large inventory to be reported on the store level report

If Flag 1 = 0, you would like this feature to be disabled

Table Number 2 holds Supplier Ratio

Table Number 3 holds Product Ratio

Programs Used In:

• K3S_7202

Structure:

Table Code Value: K3S_SLRP19LARGE_VALU
Table Code Description 1: Large Inventory Report values
Table Code Description 2: Number 2 holds Supplier Ratio
Table Code Description 3: Number 3 holds Product Ratio
Table Flag 1: 0
Table Number 2 (7.2): 1.40
Table Number 3 (11.4): 3.0000

K3S_0010 BYRPERFORM

Obsolete APP. No longer valid in R6.

K3S_0010 F06ALLOW

Obsolete APP. No longer valid in R6.

K3S_0010 RMV_BORDER

Obsolete APP. No longer valid in R6.

K3S_1010 F2=ALL

Obsolete APP. No longer valid in R6.

K3S_1010 OCT_FILTER

Obsolete APP. No longer valid in R6.

K3S_1010 OSV_8_ALL

Obsolete APP. No longer valid in R6.

K3S_1010 USER_GROUP

Description:

Checks to see what group or authority is the user under. If your company’s environment has it where a buyer approves orders for suppliers under several different buyer numbers, then it will be good to have this table code enabled, allowing that user’s ID to be grouped by the suppliers.

Enable:

If Flag 1 = 1, you would like this feature on

If Flag 1 = 0, you would not like this feature on

Structure:

Table Code Value: K3S_1010 USER_GROUP
Table Code Description 1: Suggested orders by User ID?
Table Flag 1: 0

Programs Used In:

• K3S_1010
• K3S_9040
• K3S_9540

K3S_1015 F17=

Obsolete APP. No longer valid in R6.

K3S_1015 SUPL_NAM

Obsolete APP. No longer valid in R6.

K3S_1020 APR_FILTER

Obsolete APP. No longer valid in R6.

K3S_1020 EXT_DEALS

Description:

This table code is the External Deal flag. When recalculating the order, this table code will refresh any deals that might be held in place from the ERP system or your company’s host computer.

Enable:

If Flag 1 = 1, then you like this feature turned on

If Flag 1 = 0, then you would not like this feature turned on

Structure:

Table Code Value: K3S_1020 EXT_DEALS
Table Code Description 1: Pull deals from ext. source?
Table Flag 1: 0

Programs Used In:

• K3S_1020
• AR_CALORDR

K3S_1020 OC_WARNING

Obsolete APP. No longer valid in R6.

K3S_1030 VIEW_2_TYP

Obsolete APP. No longer valid in R6.

K3S_1030 VIEW_3_TYP

*Obsolete APP. No longer valid in R6.

K3S_1040 FLIP

*Obsolete APP. No longer valid in R6.

K3S_1040 LAST_21

Description:

This table code, if turned on, will display information for the last 21 days in demand.

Enable:

If Flag 1 = 1, then you would like to display information for the last 21 days in demand

If Flag 1 = 0, then you would not like to display information for the last 21 days in demand

If Flag 2 = 1, then you do not want last year’s information to be displayed

If Flag 2 = 0, then you do want to see last year’s information to be displayed

If Flag 3 = 1, then you would like to control what user is able to see the last 21 days demand information

Structure:

Table Code Value: K3S_1040 LAST_21
Table Code Description 1: Display last 21 days demand?
Table Code Description 2: Do not display last year information? Flag2=1
Table Code Description 3: Control display using PR_USERA1=Y Flag3=1
Table Flag 1: 1
Table Flag 2: 0
Table Flag 3: 0

Programs Used In:

• K3S_FX510D
• K3S_1040
• K3S_1041

K3S_1040 PROTECT

Obsolete APP. No longer valid in R6.

K3S_1040 SOQ_CHANGE

Obsolete APP. No longer valid in R6.

K3S_1050 BATCH_PO

Description:

During the approval process this table code will check to see if there is a pending approval in the batch order.

Enable:

If Flag 1 = 1, then check to see if there is a pending approval in the batch order

If Flag 1 = 0, then do not check to see if there is a pending approval in the batch order

Structure:

Table Code Value: K3S_1050 BATCH_PO
Table Code Description 1: Use of PB Pending batch orders
Table Flag 1: 0

Programs Used In:

• K3S_1010
• K3S_1050
• K3S_1054
• AR_APRORDR
• AR_DFTORDR
• AR_DFTORDS
• AR_DFTORDT

K3S_1050 DLY_ARRIVE

Description:

This table code will gather information from daily replenishment to calculate the arrival date.

Enable:

If Flag 1 = 1, then you would like to gather information from Daily Replenishment to calculate the Arrival Date

If Flag 1 = 0, then you would not like to gather information from Daily Replenishment to calculate the Arrival Date

Structure:

Table Code Value: K3S_1050 DLY_ARRIVE
Table Code Description 1: Calculate arrival for daily?
Table Flag 1: 1

Programs Used In:

• K3S_1050
• AR_DFTORDR
• AR_DFTORDS
• AR_DFTORDT
• AR_PODORDR

K3S_1100 POTYPE_T

Description:

This table code, when approving an order, and if it is a type ‘T’ (transfer update), and warehouse B is taking from warehouse A, then should the system include that demand from warehouse A?

Enable:

If Flag 1 = 1, then you would like to include that demand

If Flag 1 = 0, then you would not like to include that demand

Structure:

Table Code Value: K3S_1100 POTYPE_T
Table Code Description 1: Accumulate Transfer Demand?
Table Flag 1: 1

Programs Used In:

• K3S_1100
• K3S_1101

K3S_1220 EXC_DEALS

Description:

When obtaining a bracket level cost for an entire order, this table code checks to see if any deals, both time phased and permanent, are in affect. If so, would you like to exclude deals from the retrieve process?

Enable:

If Flag 1 = 1, then you would like to exclude deals from the retrieve process if there is a bracket level

If Flag 1 = 0, then you would not like this feature

Structure:

Table Code Value: K3S_1220 EXC_DEALS
Table Code Description 1: Exclude all deals from Retrieve process?
Table Flag 1: 1

Programs Used In:

• K3S_1220
• AR_RTRBKTL

K3S_1500 ALL_FROZEN

Description:

This table code is for products that have a frozen forecast of 0. If there is an order on a product, this will trigger an ‘Order Due’ on a supplier, even if it is set up with all products ‘F’ or frozen with PR_FORCAST = 0. A reason why you would want to freeze the average to 0 is because you would not want K3S to suggest in ordering it or to forcast it out. This is used for special orders for products where you would not want to store in the warehouse, but are still available for special order. Even if just one product is needing an SOQ, then it will force the supplier order as due. If this table code is off, K3S will not suggest to buy.

Enable:

If Flag 1 = 1, then means feature is active, it will suggest for special orders

If Flag 1 = 0, then means this feature is not active

Structure:

Table Code Value: K3S_1500 ALL_FROZEN
Table Code Description 1: Force order as Due for any product SOQ?
Table Code Description 2: All products in supplier are Frozen with Average = 0
Table Flag 1: 1

Programs Used In:

• K3S_1500

K3S_1500 ALTSRC_ALL

Description:

When building an order, this table code will look at all products for possible ordering from alternate sources based on each product’s existing suggested order quantity. If you are well stocked on a specific product and you do not need to order it from the regular supplier for another two weeks, do you still want that product considered when buying from an alternate source supplier?

Enable:

If Flag 1 = 1, this means that all products will be looked at for possible ordering from alternate source suppliers, not just where SOQ > 0

If Flag 1 = 0, this means that the system would look at buying products from an alternate source supplier who have an existing SOQ from their regular supplier

Structure:

Table Code Value: K3S_1500 ALTSRC_ALL
Table Code Description 1: Look at all products?
Table Code Description 2: Not just PQ_SOQACT > 0
Table Flag 1: 1

Programs Used In:

• K3S_1500

K3S_1500 CAR_COUNT

Description:

The K3S_1500 program is in charge of building orders. This table code checks to see if car logic is being used or not. Auto parts distributors are well suited for the car count processing environment, for this would allow orders, such as tires, to be organized in pairs.

Enable:

If Flag 1 = 1, then you would like for the product to car logic

If Flag 1 = 0, then you would not like for the product to use car logic

If Flag 2 = 1, then you would like to update file K_PRODUCT from file K_INTPROD AND K_INTPRDD

If Flag 2 = 0, then you would not like to update file K_PRODUCT from file K_INTPROD AND K_INTPRDD

Structure:

Table Code Value: K3S_1500 CAR_COUNT
Table Code Description 1: Car count logic being used?
Table Code Description 2: Update PR_CARCOUN from IP_CARCOUN and IY_CARCOUN? use Flag 2
Table Flag 1: 0
Table Flag 2: 0

Programs Used In:

• K3S_1500
• AR_CALPROR

K3S_1500 DELAY_FC

Description:

This table code, when creating a supplier suggested order, will check if ‘delay fixed cycle suppliers’ has an ‘until due’ date.

Enable:

If Flag 1 = 1, this means yes, do delay Fixed Cycle orders until exact date

If Flag 1 = 0, then this means no, do NOT delay and prompt early if requirement exists

Structure:

Table Code Value: K3S_1500 DELAY_FC
Table Code Description 1: Delay Fixed Cycle Suppliers until Due Date?
Table Flag 1: 0

Programs Used In:

• K3S_1500

K3S_1500 DELAY_VOC

Description:

This table code, when creating a supplier suggested order, will check if ‘delay variable order cycle suppliers’ has an ‘until due’ date.

Enable:

If Flag 1 = 1,then this means yes, do delay VOC supplier orders until exact date

If Flag 1 = 0, then this means no, do NOT delay and prompt early if requirement exists

Structure:

Table Code Value: K3S_1500 DELAY_VOC
Table Code Description 1: Delay Variable Order Cycle Suppliers until Due Date?
Table Flag 1: 0

Programs Used In:

• K3S_FX540A
• K3S_1500

K3S_1500 G1_MINSVC

Description:

This table code is for, when creating a supplier suggested order, will check to see if the product group service record is in use.

Enable:

If Flag 1 = 1, then this means that the product group service level record is being used

If Flag 1 = 0, then this means that the product group service level record is NOT being used, which also means that our original Buy Group method is in use

Structure:

Table Code Value: K3S_1500 G1_MINSVC
Table Code Description 1: Product group for SV check?
Table Flag 1: 1

Programs Used In:

• K3S_1500

K3S_1500 K_DEALPER

Description:

This table code will include permanent deals in the ‘off invoice’ testing for a ‘P2’ type only.

Enable:

If Flag 1 = 1, then Apply permanent deal to PO cost and Deal allowance when the Permanent Deal Type = ‘P2’ (product) and the Deal Application Type = ‘O’ (Off Invoice)

If Flag 1 = 0, then this feature would be disabled

Structure:

Table Code Value: K3S_1500 K_DEALPER
Table Code Description 1: Include perm deals ‘off inv’?
Table Flag 1: 0

Programs Used In:

• K3S_1500

K3S_1500 MAX_TO_MIN

Description:

This table code will force ‘calculated maximum’ to ‘calculated minimum’ if turned on.

Enable:

If Flag 1 = 1, then this will change maximum to minimum

If Flag 1 = 0, then it will use normal EOQ logic

Structure:

Table Code Value: K3S_1500 MAX_TO_MIN
Table Code Description 1: Force maximum to minimum flag?
Table Flag 1: 0

Programs Used In:

• AR_CALPROR
• AR_DADPROR

K3S_1500 MUST_RECV

Description:

This table code has it where there must be a ‘received product’ in place before the suggested quantity is generated. There is some added logic to test ‘quantity on order’ for that product.

Enable:

If Flag 1 = 1, then this means this feature is active, so the product must be received

If Flag 1 = 0, then this means this feature is not active

Structure:

Table Code Value: K3S_1500 MUST_RECV
Table Code Description 1: Must receive before Sug Qty?
Table Flag 1: 0

Programs Used In:

• K3S_1040
• K3S_1041
• K3S_1500
• K3S_1510

K3S_1500 RM_PRV_ORD

Description:

This table code stands for Remove Previous Orders, for the store level environment only.
Enable:

If Flag 1 = 1, then you would like to remove previous orders at the store level environment

If Flag 1 = 0, then you would not like to remove previous orders at the store level environment

Structure:

Table Code Value: K3S_1500 RM_PRV_ORD
Table Code Description 1: Remove previous orders?
Table Code Description 2: Store Level (K3S_1500SP)
Table Flag 1: 0

K3S_1500 SHUT_OFF

Description:

This table code will shut off SOQ under special condition. This will include a product that has seasonal profile, and we are in a period with a factor of 0, and a Manual Minimum Units > 0.

Enable:

If Flag 1 = 1, then you would like to test to set SOQ to 0

If Flag 1 = 0, then this means that this feature is not active

Table Number 1 will hold the value of the number of days. Max number is 15

Structure:

Table Code Value: K3S_1500 SHUT_OFF
Table Code Description 1: Shut Off SOQ when Factor=0 and Manl Min Unit > 0
Table Code Description 2: Number 1 field holds days to look ahead. Maximum 15 days
Table Flag 1: 1
Table Number 1 (5.0): 0

Programs Used In:

• K3S_1040
• K3S_1041
• K3S_1500

K3S_1810 DEAD_NET

No use found

K3S_1900 CMB_SPLITS

Description:

This table code determines if the company should allow split orders on temporary or permanent split codes for combined suppliers.

Enable:

If Flag 1 = 1, then you would like to allow split order temporary or permanent split codes for combined suppliers

If Flag 1 = 0, then you would like to allow split order temporary or permanent split codes for combined suppliers

Structure:

Table Code Value: K3S_1900 CMB_SPLITS
Table Code Description 1: Allow STM or SPR split on combined supls?
Table Flag 1: 1

Programs Used In:

• AR_CMBSPLT
• AR_DPRSPLT
• AR_DQTSPLT
• AR_EXTSPLT
• AR_LINSPLT
• AR_LOCSPLT
• AR_MSSSPLT
• AR_PG1SPLT
• AR_PG2SPLT
• AR_PG3SPLT
• AR_PG4SPLT
• AR_PG5SPLT
• AR_REQSPLT
• AR_SELSPLT
• AR_SPRSPLT
• AR_STMSPLT
• AR_USDSPLT
• AR_USPSPLT

K3S_2000 ALLOW_DELT

Description:

If this table code is turned on, it will allow deletion for a supplier upon active products. Normally, we would not allow deletion for a supplier with active products. This is crucial because once a supplier has been deleted, all information for that supplier is erased from the K3S system and the products will be erased from the system as well

Enable:

If Flag 1 = 1, then you would like to allow deletion for a supplier with active products

If Flag 1 = 0, then you would not like to allow deletion for a supplier with active products

Structure:

Table Code Value: K3S_2000 ALLOW_DELT
Table Code Description 1: Allow delete with active prod?
Table Flag 1: 0

Programs Used In:

• K3S_2000
• AR_DELSUPL
• AR_DELSUPM
• AR_DELSUPN

K3S_2000 COMB_SUPL

Description:

This table code will allow the buyer to combine suppliers into one shell for an order. Can be sequenced in the ‘combined supplier products sequence’.

Enable:

If Flag 1 = 1, then you would like to combine suppliers into one shell for an order

If Flag 1 = 0, then you would not like to combine suppliers into one shell for an order

Structure:

Table Code Value: K3S_2000 COMB_SUPL
Table Code Description 1: Default for product sequence
Table Flag 1: 1

Programs Used In:

• K3S_2000
• AR_ADDSUPD
• AR_ADDSUPE
• AR_ADDSUPL
• AR_DFTSUPL
• AR_UPDSUPZ

K3S_2000 F21=

Obsolete APP. No longer valid in R6.

K3S_2000 SP_EXCLEAD

Description:

This table code allows you to control whether product and supplier lead times are excluded from automatic updates. The default is for the system to recalculate and update supplier and product lead limes once each month based upon past receipts.

Enable:

If Flag 1 = 1, then it will exclude updating of automatic lead time

If Flag 1 = 0, then it will not exclude updating of automatic lead time

Structure:

Table Code Value: K3S_2000 SP_EXCLEAD
Table Code Description 1: LT - Exclude auto updating?
Table Flag 1: 0

Programs Used In:

• K3S_2000
• AR_DFTSUPL

K3S_2000 SP_GROUP1

Description:

This table code allows this field to be customized to contain information to fit your company’s environment. If turned on, it will allow default value in supplier Group 1 found in product settings.

Enable:

If Flag 1 = 1, then give a default value in supplier Group 1

If Flag 1 = 0, then you would like this feature disabled

Structure:

Table Code Value: K3S_2000 SP_GROUP1
Table Code Description 1: Require specific GROUP1 values
Table Code Description 2: XXXXXXXXXX <— mask only
Table Code Description 3: MCCARTNEY <— use Desc 3
Table Flag 1: 0

Programs Used In:

• K3S_FX500I
• K3S_2000
• AR_ADDSUPD
• AR_ADDSUPE
• AR_ADDSUPL
• AR_DFTSUPL
• AR_UPDSUPL
• AR_UPDSUPZ

K3S_2000 SP_GROUP2

Description:

This table code allows this field to be customized to contain information to fit your company’s environment. If turned on, it will allow default value in supplier Group 2 found in product settings.

Enable:

If Flag 1 = 1, then give a default value in supplier Group 2

If Flag 1 = 0, then you would like this feature disabled

Structure:

Table Code Value: K3S_2000 SP_GROUP2
Table Code Description 1: Require specific GROUP2 values
Table Code Description 2: XXXXXXXXXX <— mask only
Table Flag 1: 0

Programs Used In:

• K3S_FX500I
• K3S_2000
• AR_ADDSUPD
• AR_ADDSUPE
• AR_ADDSUPL
• AR_DFTSUPL
• AR_UPDSUPL
• AR_UPDSUPZ

K3S_2000 SP_GROUP3

Description:

This table code allows this field to be customized to contain information to fit your company’s environment. If turned on, it will allow default value in supplier Group 3 found in product settings.

Enable:

If Flag 1 = 1, then give a default value in supplier Group 3

If Flag 1 = 0, then you would like this feature disabled

Structure:

Table Code Value: K3S_2000 SP_GROUP3
Table Code Description 1: Require specific GROUP3 values
Table Code Description 2: XXXXXXXXXX <— mask only
Table Code Description 3: ?????????? <— use Desc 3
Table Flag 1: 0

Programs Used In:

• K3S_FX500I
• K3S_2000
• AR_ADDSUPD
• AR_ADDSUPE
• AR_ADDSUPL
• AR_DFTSUPL
• AR_UPDSUPL
• AR_UPDSUPZ

K3S_2000 SP_GROUP4

Description:

This table code allows this field to be customized to contain information to fit your company’s environment. If turned on, it will allow default value in supplier Group 4 found in product settings.

Enable:

If Flag 1 = 1, then give a default value in supplier Group 4

If Flag 1 = 0, then you would like this feature disabled

Structure:

Table Code Value: K3S_2000 SP_GROUP4
Table Code Description 1: Require specific GROUP4 values
Table Code Description 2: XXXXXXXXXX <— mask only
Table Code Description 3: ?????????? <— use Desc 3
Table Flag 1: 0

Programs Used In:

• K3S_FX500I
• K3S_2000
• AR_ADDSUPD
• AR_ADDSUPE
• AR_ADDSUPL
• AR_DFTSUPL
• AR_UPDSUPL
• AR_UPDSUPZ

K3S_2000 SP_GROUP5

Description:

This table code allows this field to be customized to contain information to fit your company’s environment. If turned on, it will allow default value in supplier Group 5 found in product settings.

Enable:

If Flag 1 = 1, then give a default value in supplier Group 5

If Flag 1 = 0, then you would like this feature disabled

Structure:

Table Code Value: K3S_2000 SP_GROUP5
Table Code Description 1: Require specific GROUP5 values
Table Code Description 2: XXXXXXXXXX <— mask only
Table Code Description 3: ?????????? <— use Desc 3
Table Flag 1: 0

Programs Used In:

• K3S_FX500I
• K3S_2000
• AR_ADDSUPD
• AR_ADDSUPE
• AR_ADDSUPL
• AR_DFTSUPL
• AR_UPDSUPL
• AR_UPDSUPZ

K3S_2000 WRITE_EXIT

Obsolete APP. No longer valid in R6.

K3S_3000 ALLOW_BOTH

Description:

This table code will allow both manual min/max in days and units, in the product settings -> SOQ components screen

Enable:

If Flag 1 = 1, then allow both manual min/max in days and units

If Flag 1 = 0, then you don’t want to allow both manual min/max in days and units

Structure:

Table Code Value: K3S_3000 ALLOW_BOTH
Table Code Description 1: Allow both manual min/max days and units?
Table Code Description 2: This feature can be used in ReStore
Table Flag 1: 0

Programs Used In:

• K3S_3000
• AR_UPDPROD

K3S_3000 PO_SCRTEXT

This table code will gather the PO field headings and right adjust info.

Enable:

If Flag 1 = 1, then gather the PO field heading

If Flag 1 = 0, then disable this feature

Flag 2 is no long valid in R6

Structure:

Table Code Value: K3S_3000 PO_SCRTEXT
Table Code Description 1: Text for 2 P.O. fields
Table Code Description 2: Qty divisor…Unit of measure.
Table Code Description 3: Flag2=1 for PO_UOM Right Adj
Table Flag 1: 0

Programs Used In:

• K3S_3000

K3S_3000 PR_BUYMULO

Description:

This table code allows you to control how the system reacts when a buyer tries to override the system with a value that is inconsistent with the current buy multiple being passed from your company’s host computer. If this table code is flagged on, can flag a warning to the user who is entering an inconsistent value.

Enable:

If Flag 1 = 2, then it will not allow the buyer to override the system

If Flag 1 = 1, then it will allow the buyer to override the system, but will display a warning

If Flag 1 = 0, then it will allow the buyer to override the system

Structure:

Table Code Value: K3S_3000 PR_BUYMULO
Table Code Description 1: Buy Multiple Over-ride edits
Table Code Description 2: Flag1=0 no edits, =1 warning,
Table Code Description 3: =2 do not allow update
Table Flag 1: 0

Programs Used In:

• K3S_3000
• AR_UPDPROD
• AR_UPDPROF
• AR_UPDPROG
• AR_UPDPROH
• OL_UPDPROD

K3S_3010 COMBINE

Description:

This table code determines if updating the combined supplier product record is needed.

Enable:

If Flag 1 = 1, then the Combined Supplier Product record will be updated

If Flag 1 = 0, then the Combined Supplier Product record will not be updated

Structure:

Table Code Value: K3S_3010 COMBINE
Table Code Description 1: Update Combined Supplier Product record?
Table Code Description 2: With Flag1=1 program K3S_3013 is called from K3S_3010 online only
Table Flag 1: 0

Programs Used In:

• K3S_3010

K3S_3016 COPY_ALL

Description:

Determines if the product should copy product history across all locations. Can also view and determine whether or not to bypass writing to the file K_PRODLNK records when the from/to products DON’T exist in the system.

Enable:

If Flag 1 = 1, then copy product history across all locations

If Flag 1 = 0, then don’t copy product history across all locations

If Flag 2 = 1, then there is a default value

If Flag 2 = 0, then there is no default value

If Flag 3 = 1, then skip writing links for locations where FROM/TO products arent found

If Flag 3 = 0, then don’t skip writing links for locations where FROM/TO products arent found

Structure:

Table Code Value: K3S_3016 COPY_ALL
Table Code Description 1: Generate records for all locations?
Table Code Description 2: Flag2 has default value 0=No, 1=Yes
Table Code Description 3: If Flag1=1 use Flag3 to skip writing links for locns where FROM/TO products arent found 0=No, 1=Yes
Table Flag 1: 0
Table Flag 2: 0
Table Flag 3: 0

Programs Used In:

• K3S_FX530A
• K3S_3016
• AR_ADDLINK
• AR_CHGLINK
• AR_CPYLINK
• AR_DELLINK
• AR_UPDLINK

K3S_3016 DEFAULT_C

Obsolete table code. No longer in use.

K3S_3020 DEV_UPDATE

Description:

This table code will allow the deviation percentage to be updated during the product safety stock simulation.

Enable:

If Flag 1 = 1, then allow the deviation percentage to be updated

If Flag 1 = 0, then don’t allow the deviation percentage to be updated

Structure:

Table Code Value: K3S_3020 DEV_UPDATE
Table Code Description 1: Allow Deviation % update?
Table Flag 1: 0

Programs Used In:

• K3S_3020

K3S_3030 F20=

Obsolete APP. No longer valid in R6.

K3S_3030 NEW_PROB

Description:

This table code will change new products (‘N’) to a probation status (‘P’) when the user gives a new product an average.

Enable:

If Flag 1 = 2, then the number of days to put on P status default is 180

If Flag 1 = 1, then you would like to Change New products (‘N’) to a Probation status (‘P’) for a number of days

If Flag 1 = 0, then you would not like to Change New products (‘N’) to a Probation status (‘P’)

Table Number 1 will hold the value of the number of days the product will be on Probation

Structure:

Table Code Value: K3S_3030 NEW_PROB
Table Code Description 1: Change New products to Probation status?
Table Code Description 2: Use Number 1 for # of days on Probation
Table Flag 1: 0
Table Number 1 (5.0): 180

Programs Used In:

• K3S_3030
• K3S_3031
• AR_UAVPROR
• AR_UPDPAVG

K3S_3030 NO_FACTR_0

Description:

This table code will not allow a Seasonal Profile to be added with a factor of .00.

Enable:

If Flag 1 = 1, then this means that you do not want to allow a Seasonal Profile to be added with a factor of .00

If Flag 1 = 0, then this means that the system will allow a Seasonal Profile to be added with a factor of .00

Structure:

Table Code Value: K3S_3030 NO_FACTR_0
Table Code Description 1: Do not allow a Seasonal Profile to be added with a Factor of .00 ?
Table Flag 1: 0

Programs Used In:

• K3S_3030
• K3S_3031
• AR_ADDSZ12
• AR_ADDSZ13
• AR_UPDSZ12
• AR_UPDSZ13

K3S_3030 SYSSTAT=N

Description:

This table code allows you to control whether new products, which are coded with a system status of ‘N’ for new, will keep the ‘N’ status until a buyer gives the product a starting average. This is used for so that user know that there is a new product, and that it needs to be assigned an average in order for the system to give them an accurate suggestion when ordering.

Enable:

If Flag 1 = 1, then keep the ‘N’ status until a buyer gives the product a starting average

If Flag 1 = 0, then this will disable that feature

Structure:

Table Code Value: K3S_3030 SYSSTAT=N
Table Code Description 1: PR_SYSSTAT Keep N with ENTER?
Table Flag 1: 0

Programs Used In:

• K3S_3030
• K3S_3031

K3S_3030 UP_STREAM

Description:

This will determine if there needs to be an adjustment in the averages upstream. If the flag is turned on, the window will pop open so that the buyer can adjust the average at the upstream locations as well.

Enable:

If Flag 1 = 1, then you would like to adjust the averages upstream

If Flag 1 = 0, then you would not like to adjust the averages upstream

Structure:

Table Code Value: K3S_3030 UP_STREAM
Table Code Description 1: Adjust Averages Upstream?
Table Flag 1: 1

Programs Used In:

• K3S_3032

K3S_3050 CHANGE_PO#

Description:

This table code will allow the PO number to be changed.

Enable:

If Flag 1 = 1, then enable this feature

If Flag 1 = 0, then disable this feature

Structure:

Table Code Value: K3S_3050 CHANGE_PO#
Table Code Description 1: Allow changing of PO#?
Table Flag 1: 0

Programs Used In:

• K3S_3050
• K3S_3051
• K3S_3054

K3S_3050 F19=GROUPS

Obsolete APP. No longer valid in R6.

K3S_3050 WEEKLYLIFT

Description:

When generating hold out entries, this table code will check to see if the weekly lift percent flag is entered. This is important because the user has the option of entering a percentage to increase each item’s inventory by each week. For the store level environment only.

Enable:

If Flag 1 = 1, then check to see if the weekly lift percent flag is entered

If Flag 1 = 0, then don’t check to see if the weekly lift percent flag is entered

Structure:

Table Code Value: K3S_3050 WEEKLYLIFT
Table Code Description 1: Enter weekly lift % flag?
Table Flag 1: 0

Programs Used In:

• K3S_3050
• K3S_3052

K3S_3052 AT_LEAST_1

Description:

For hold out entries, this table code will make ‘quantity’ a hold out record for at least 1 unit for items that are slow movers. Very slow moving products will generate hold out quantities that are less than 1, so turning this feature on will ensure that all items generate a hold out quantity of at least 1.

Enable:

If Flag 1 = 1, then make the quantity a hold out record for at least 1 unit for items that are slow movers

If Flag 1 = 0, then disable this feature

Structure:

Table Code Value: K3S_3052 AT_LEAST_1
Table Code Description 1: Make quantity at least 1 flag?
Table Flag 1: 0

Programs Used In:

• K32_3052

K3S_3070 WEEKEND

Description:

When displaying certain products, chosen by the user for a batch program, this table code will check to see if there was activity on the product during the weekend.

Enable:

If Flag 1 = 1, then will check if there was activity on the product during the weekend

If Flag 1 = 0, then activity on the product during the weekend will not be checked

Structure:

Table Code Value: K3S_3070 WEEKEND
Table Code Description 1: Turn off weekend activity default?
Table Flag 1: 0

Programs Used In:

• K3S_3070
• AR_RETNITE

K3S_3090 BY_PASS_D

Description:

When displaying certain products, chosen by the user for a batch program, this table code will check to see if it should include products that have been discontinued.

Enable:

If Flag 1 = 1, then it will check if it should include products that have been discontinued for the batch program

If Flag 1 = 0, then it will not check if it should include products that have been discontinued for the batch program

Structure:

Table Code Value: K3S_3090 BY_PASS_D
Table Code Description 1: By-pass D Discontinued products?
Table Flag 1: 0

Programs Used In:

• K3S_3090
• AR_CHKBACH
• AR_LCKBACH
• AR_RVWBACH

K3S_3100 LIB_FILE

Obsolete APP. No longer valid in R6.

K3S_3100 LIB_QRY

Obsolete APP. No longer valid in R6.

K3S_3200 FILTER

Description

When creating a Customer Usage batch, this table code will allow it so that you can identify an exception in the report by creating thresholds on the product. You can change the filter on the multiplier, dollar amount and/or quantity.

Enable

If Flag 1 = 1, then you would like to have custom default values for the multiplier, dollar amount and/or quantity

If Flag 1 = 0, then you would like to have different default values for the multiplier, dollar amount and/or quantity. You would like to continue having the following default values. For the multiplier, the value of 1.50. For the dollar amount, the value 25. For the quantity, the value of 5.

Table Number 1 will allow you to change the default value for the dollar amount

Table Number 2 will allow you to change the default value for the multiplier

Table Number 3 will allow you to change the default value for the quantity

Structure

Table Code Value: K3S_3200 FILTER
Table Code Description 1: Over filter exception values
Table Code Description 2: # 1= $ # 2= Mult # 3= Units
Table Flag 1: 0
Table Number 1 (5.0): 25
Table Number 2 (7.2): 1.50
Table Number 3 (11.4): 5.0000

Programs Used In:

• K3S_3200
• AR_RVRCUSG

K3S_3200 MAX_DEV

Description:

When displaying a list of batches for a buyer group, this table code checks to see if there is a maximum deviation in place. If this flag is turned on, it will use the deviation percentage.

Enable:

If Flag 1 = 1, then check to see if there is a maximum deviation is allowed

If Flag 1 = 0, then check to see if there is a maximum deviation is allowed

If Flag 2 = 1, then will allow a default filter value for the maximum deviation percentage to be in place

If Flag 2 = 0, then don’t allow a default filter value for the maximum deviation percentage to be in place

If Flag 3 = 1, then allow edit entry on the minimum deviation

If Flag 3 = 0, then don’t allow edit entry on the minimum deviation

Structure:

Table Code Value: K3S_3200 MAX_DEV
Table Code Description 1: Maximum deviation % allowed?
Table Code Description 2: #2= Max % default filter value
Table Code Description 3: #3= Min % to edit entry
Table Flag 1: 0
Table Flag 2: 0
Table Flag 3: 0

Programs Used In:

• K3S_3200
• K3S_3220
• AR_ADDCUSG
• AR_CPYCUSG
• AR_UPDCUSG

K3S_3225 HEADING_2

Obsolete APP. No longer valid in R6.

K3S_3301 LONG_PROD

Description:

This table code allows a long product ID for those that have 25 characters or more.

Enable:

If Flag 1 = 1, then you have product IDs that are longer than 25 characters and will need to enable this feature

If Flag 1 = 0, then you do not have product IDs that are longer than 25 characters and will not need to enable this feature

Structure:

Table Code Value: K3S_3301 LONG_PROD
Table Code Description 1: Long Product ID show more product description?
Table Flag 1: 0

Programs Used In:

• K3S_3301

K3S_3433 COLLECT

Description:

This table code will allow you to control whether or not the system will collect weekly distribution values for a supplier. You can also control which day of the week the system will process this information.

Enable:

If Flag 1 = 1, then you would like for the system to collect weekly distribution values for a supplier

If Flag 1 = 0, then you would not like for the system to collect weekly distribution values for a supplier

If Flag 2 = 1-7, then you would like this feature to be processed on a certain day, starting with Sunday EQ 1, Monday EQ 2 and so forth

Structure:

Table Code Value: K3S_3433 COLLECT
Table Code Description 1: Collect weekly distribution?
Table Code Description 2: Flag2 for day to process
Table Code Description 3: 1=Sun,2=Mon,3-Tue
Table Flag 1: 0
Table Flag 2: 3

Programs Used In:

• K3S_1042
• K3S_1045
• K3S_1047
• K3S_3433

K3S_3439 GEN_EXCPTN

Description:

This table code allows you to control whether or not the system will build a selected products review batch of weekly distribution exceptions. If you would like the system to build you this type of batch, then you can also control the threshold values for which products will appear in the batch.

Enable:

If Flag 1 = 1, then the system will build a selected products review batch of weekly distribution exceptions

If Flag 1 = 0, then the system will not build a selected products review batch of weekly distribution exceptions

Table Number 1 will contain the minimum weekly average for WP2 - Weekly Exceptions for demand on products who have a 3% difference in expected demand

Table Number 2 will contain the exception percentage

Structure:

Table Code Value: K3S_3439 GEN_EXCPTN
Table Code Description 1: Generate wkly dist exceptions?
Table Code Description 2: Number 1 WP2 minimum wkly avg
Table Code Description 3: Number 2 contains exception %
Table Flag 1: 1
Table Number 1 (5.0): 30
Table Number 2 (7.2): 5.00
Table Number 3 (11.4): .0000

Programs Used In:

• K3S_3439

K3S_36OO ALL_D_OVER

Description:

The program K3S_3600 creates a batch of overstocked products. This table code will assign the product as ‘overstock’ if it is an item that is to be discontinued.

Enable:

If Flag 1 = 1, then all products that are discontinued will be assigned as Overstocked

If Flag 1 = 0, then this feature will be disabled

Structure:

Table Code Value: K3S_3600 ALL_D_OVER
Table Code Description 1: All inventory for Discontinued as Overstock?
Table Flag 1: 0

Programs Used In:

• K3S_3600
• AR_OVSTK
• BK_OVSTK

K3S_3600 BIRTH_TEST

Description:

This table code will save the number of days before overstock calculations apply to a product.

Enable:

If Flag 1 = 1, then save the number of days before overstock calculations apply to a product

If Flag 1 = 0, then don’t save the number of days before overstock calculations apply to a product

Table Number 1 will be the default value for the number of days

Structure:

Table Code Value: K3S_3600 BIRTH_TEST
Table Code Description 1: Number of days before testing?
Table Flag 1: 1
Table Number 1 (5.0): 90

Programs Used In:

• K3S_3600
• AR_OVSTK

K3S_3600 LAST_RECVD

Description:

If this table code is flagged on, it will use the ‘last received date’ to filter new products from the overstocked report.

Enable:

If Flag 1 = 1, then you would like to filter products that have not been received for batches with overstocked batches

If Flag 1 = 0, then you would not like to use this filter

Structure:

Table Code Value: K3S_3600 LAST_RECVD
Table Code Description 1: Filter products not received?
Table Flag 1: 0

Programs Used In:

• K3S_3600
• AR_OVSTK

K3S_3600 PR_BUYMULT

Description:

If this table code is flagged on, it will use the buy multiple to filter very large pack size on slow movers.

Enable:

If Flag 1 = 1, then when filtering large pack size on slow movers, you would like to include the buy multiple

If Flag 1 = 0, then when filtering large pack size on slow movers, you would NOT like to include the buy multiple

Structure:

Table Code Value: K3S_3600 PR_BUYMULT
Table Code Description 1: Include Buy Multiple in test?
Table Flag 1: 1

Programs Used In:

• K3S_3600
• AR_OVSTK

K3S_3600 PR_MAMINIU

Description:

This table code will use the manual minimum units to filter the overstocked products if flagged on.

Enable:

If Flag 1 = 1, then include Manual Minimum Units

If Flag 1 = 0, then do not include Manual Minimum Units

Structure:

Table Code Value: K3S_3600 PR_MAMINIU
Table Code Description 1: Include Man Min Units in test?
Table Flag 1: 1

Programs Used In:

• K3S_3600
• AR_OVSTK

K3S_3600 PR_MINQTY

Description:

This table code will use minimum quantity to filter the overstocked products where buyer has no choice.

Enable:

If Flag 1 = 1, then include the Minimum Qty

If Flag 1 = 0, then do not include the Minimum Qty

Structure:

Table Code Value: K3S_3600 PR_MINQTY
Table Code Description 1: Include Minimum Qty in test?
Table Flag 1: 1

Programs Used In:

• K3S_3600
• AR_OVSTK

K3S_3600 PR_QTYOORD

Description:

This table code will exclude ‘quantity on order’ from the balance calculation.

Enable:

If Flag 1 = 1, then this means exclude on order from balance calculation

If Flag 1 = 0, then this means do not exclude on order from balance

Structure:

Table Code Value: K3S_3600 PR_QTYOORD
Table Code Description 1: Exclude on order from balance?
Table Flag 1: 0

Programs Used In:

• K3S_3600
• AR_OVSTK

K3S_3600 PR_RFBIRTH

Description:

This table code, if flagged on, will filter any products with the ‘reference birth’ logic in play.

Enable:

If Flag 1 = 1, then you would like to filter any products with Reference Birth logic in play when calculating the overstocked products

If Flag 1 = 0, then you would NOT like to filter any products with Reference Birth logic in play when calculating the overstocked products

If Flag 2 = 1, then you would like the Birth of the record to be reference when determining a change in forecasting period

If Flag 2 = 0, then you would NOT like the Birth of the record to be reference when determining a change in forecasting period

Table Number 1 will contain the value of number of days to test

Structure:

Table Code Value: K3S_3600 PR_RFBIRTH
Table Code Description 1: Include Reference Birth in test?
Table Code Description 2: Use Flag2=1 to capture PR_RFBIRTH in K3S_9010
Table Code Description 3: Number 1 field contains number of days to test
Table Flag 1: 0
Table Flag 2: 1
Table Number 1 (5.0): 0

Programs Used In:

• K3S_3600
• K3S_9010
• AR_OVSTK

K3S_3615 DSPLY NAME

Description:

This table code will take the supplier name out of the product description in the Overstock Products report.

Enable:

If Flag 1 = 1, then yes, hide the supplier name in the report

If Flag 1 = 0, then no, do not hide the supplier name in the report

Structure:

Table Code Value: K3S_3615 DSPLY NAME
Table Code Description 1: Hide supl name in report?
Table Flag 1: 0

Programs Used In:

• K3S_3615

K3S_3715 EXCLUDE_D

Description:

The program K3S_3715 prints the Obsolete Products report. Table code EXCLUDE_D will determine if linked products are to be excluded when a daily record exists.

Enable:

If Flag 1 = 1, then link products are to be excluded when a daily record exists

If Flag 1 = 0, then do NOT link products are to be excluded when a daily record exists

Structure:

Table Code Value: K3S_3715 EXCLUDE_D
Table Code Description 1: Exclude linked “To product” when “D” Daily record exists?
Table Flag 1: 1

Programs Used In:

• K3S_3715

K3S_3900 ORIG_ORDER

Description:

For suppliers who are part of a combined supplier will have two orders existing for them, one regular (original) order and one order under the combined supplier. This table code, if turned on, will decide how to handle the original order.

Enable:

If Flag 1 = 2, then the system would delete the original order

If Flag 1 = 1, then the system would cancel the original order

If Flag 1 = 0, then the buyer could try to approve it

Structure:

Table Code Value: K3S_3900 ORIG_ORDER
Table Code Description 1: Ord:0=leave,1=cancel,2=delete
Table Flag 1: 0

Programs Used In:

• K3S_3900

K3S_3920 COLLECT

This flag will always be defaulted to 1, in which it will collect the daily product information from the K_INTPROD (Interface for Products) file into the K_DLYPROD (Daily Products Info Capture) file. For Flag 2, it will only write to K_DLYPROD file when there are sales on that product. That way we aren’t constantly writing records for customers who have larger files.

Enable:

If Flag 1 = 1, then collect the daily product information from the K_INTPROD (Interface for Products) file into the K_DLYPROD file (Daily Products Info Capture)

If Flag 1 = 0, then do not collect the daily product information from the K_INTPROD (Interface for Products) file into the K_DLYPROD file

If Flag 2 = 1, then it will only write to K_DLYPROD file when there are sales on that product, that way we aren’t constantly writing records for customers who have larger files

If Flag 2 = 0, then it will not write to K_DLYPROD file when there are sales on that product, that way we aren’t constantly writing records for customers who have larger files

Structure:

Table Code Value: K3S_3920 COLLECT
Table Code Description 1: Collect daily information?
Table Code Description 2: K_DLYPROD file population
Table Code Description 3: Flag2 controls DEMAND > 0
Table Flag 1: 1
Table Flag 2: 0

Programs Used In:

• K3S_1043
• K3S_3433
• K3S_3760
• K3S_3920
• AR_TRNREPT

K3S_3920 SHIFT

Description:

This table code checks to see if there is a location with a specific shift in place. If there is not, it will use the company shift. This will map the days of the week for weekly distribution based on the demand of that exact day. Monday’s data will be shifted 3 days. Tuesday-Saturday will only shift one day. Sunday will shift two days.

Enable:

If Flag 1 = 1, then you would like to use the company shift feature

If Flag 1 = 0, then you would like to disable this feature

Structure:

Table Code Value: K3S_3920 SHIFT
Table Code Description 1: Shift days for K_WEEKDIS?
Table Code Description 2: MTWTFSS <- Mon thru Sun
Table Code Description 3: 3111112 <- days to shift
Table Flag 1: 1

Programs Used In:

• K3S_3920

K3S_3920 SHIFT + (LOCATION ID)

Description:

This table code checks to see if there is a location with a specific shift in place. The location ID will go after ‘SHIFT’. This will map the days of the week for weekly distribution based on the demand of that exact day. Monday’s data will be shifted 2 days. Tuesday-Sunday will only shift one day.

Enable

If Flag 1 = 1, then you would like to use the location shift feature

If Flag 1 = 0, then you would like to disable this feature

Programs Used In:

• K3S_3920

Structure

Table Code Value: K3S_3920 SHIFT02
Table Code Description 1: Shift days for K_WEEKDIS? Location 02 Atlanta, GA
Table Code Description 2: MTWTFSS <- Mon thru Sun
Table Code Description 3: 2111111 <- days to shift
Table Flag 1: 1

K3S_3940 FORCE_LOST

No use found

K3S_3940 LC_DAILY=0

Description:

This table code will allow you to gather the total of the accumulated daily demand used for the month. This will be used by the program K3S_3940 to help populate demand correctly in file K_DLYSVCE at period end.

Enable:

If Flag 1 = 2, then you would like to enable the month-to-date processing schedule with a night job that runs 5 days a week

If Flag 1 = 1, then you would like to enable the month-to-date processing schedule with a night job that runs 7 days a week

If Flag 1 = 0, then PTD demand is being passed

Structure:

Table Code Value: K3S_3940 LC_DAILY=0
Table Code Description 1: Define month-to-date processing schedule
Table Code Description 2: Flag1=1 Schedule is 7 days per week
Table Code Description 3: Flag1=2 Schedule is 5 days per week
Table Flag 1: 0

K3S_5030 BLOCK_SUPL

Description:

If this flag is turned on, it will block the users from creating supplier level deal templates.

Enable:

If Flag 1 = 1, then you would like to block the user from creating supplier level deal templates

If Flag 1 = 0, then you would NOT like to block the user from creating supplier level deal templates

Structure:

Table Code Value: K3S_5030 BLOCK_SUPL
Table Code Description 1: Block supplier templates?
Table Flag 1: 0

Programs Used In:

• K3S_5030
• AR_ADDDEAL
• AR_ADDDELW
• AR_ALLDEAL
• AR_APRDEAL
• AR_DPADEAL
• AR_UPDDEAL
• AR_UPRDEAL

K3S_5030 VALID_USER

Description:

When adding templates for deal entry, this table code will check to see if the user is valid and if they have authority to manage the company deal templates.

Enable:

Put the Usernames in Description 2-4

Structure:

Table Code Value: K3S_5030 VALID_USER
Table Code Description 1: Valid users to manage Company Deal Template
Table Code Description 2: PETE <– Valid user 1
Table Code Description 3: KINGSTON <– Valid user 2
Table Code Description 4: KING3BBAL1<– Valid user 3

Programs Used In:

• K3S_5030
• K3S_5300
• AR_ADADELW
• AR_ADDDEAL
• AR_ADDDELW
• AR_ADTDEAL
• AR_ALLDEAL
• AR_APRDEAL
• AR_CPYDELW
• AR_DLTDEAL
• AR_DPADEAL
• AR_UPDDEAL
• AR_UPDDELW
• AR_UPRDEAL
• AR_UPTDEAL

K3S_5050 ALLOW_PCT

Description:

When creating new deals for a specified supplier, this table code will determine whether to use 2 decimals or 4 decimals for the allowance percent calculation.

Enable:

If ALLOW_PCT = 1, then this means that it will use 4 decimals for allowance percents

If ALLOW_PCT = 0, this means use the default of 2 decimals for allowance percents

Structure:

Table Code Value: K3S_5050 ALLOW_PCT
Table Code Description 1: Allowance percent to use 4 decimals?
Table Flag 1: 0

Programs Used In:

• K3S_M070
• K3S_5050
• K3S_5051
• AR_ADADELW
• AR_ADDDEAL
• AR_ADDDELW
• AR_ALLDEAL
• AR_DPADEAL
• AR_CPRDEAL
• AR_CPYDEAL
• AR_CPYDELW
• AR_DELDEAL
• AR_PRODEAL
• AR_ULNDELW
• AR_UPDDEAL
• AR_UPDDELW
• AR_UPRDEAL

K3S_5050 CUST_DEALS

Description:

This table code will save ‘write outs’ to customer deals. Not currently in use. If you would like this turned on, please contact K3S.

Enable:

If Flag 1 = 1, this means that it will write out data to file K_DEALCST

If Flag 1 = 0, this means that it will not pass the deal information

Structure:

Table Code Value: K3S_5050 CUST_DEALS
Table Code Description 1: Write out to customer deals?
Table Code Description 2:
Table Code Description 3: x– default text for note —x
Table Flag 1: 0

Programs Used In:

• K3S_5401
• K3S_5050
• K3S_5058
• AR_ADDDEAL
• AR_ALLDEAL
• AR_APRDEAL
• AR_DELDEAL
• AR_DPADEAL
• AR_IMPDEAL
• AR_UPDDEAL
• AR_UPRDEAL

K3S_5050 MMDD_ENTRY

Description:

This table code is for the MMDD entry format for Begin/End dates used for deals.

Enable:

If Flag 1 = 1, then this means that the customer does use MMDD format during entry

If Flag 1 = 0, then this means the customer uses standard date formats

Structure:

Table Code Value: K3S_5050 MMDD_ENTRY
Table Code Description 1: Begin/End dates MMDD entry?
Table Flag 1: 0

Programs Used In:

• K3S_5050

K3S_5050 ONE_LOCN

Description:

This flag has the capability that would be used for customers who have multiple locations but would like to perform de-central buying and therefore only want the default location to be used for building the subfile of possible products for entry.

Enable:

If Flag 1 = 1, then this means that only 1 location is to be used as the default, so display the single location field during entry. This still allows the user to clear field, so that all locations are considered for building the subfile

If Flag 1 = 0, then this means that all locations are used, and don’t display the single location field on entry

Structure:

Table Code Value: K3S_5050 ONE_LOCN
Table Code Description 1: One location specific select?
Table Flag 1: 0

**Programs Used In: **

• K3S_5050
• AR_ADADELW
• AR_ADDDEAL
• AR_ADDDELW
• AR_ALLDEAL
• AR_APRDEAL
• AR_CPRDEAL
• AR_CPYDEAL
• AR_CPYDELW
• AR_DELDEAL
• AR_PRODELW
• AR_ULNDELW
• AR_UPDDEAL
• AR_UPDDELW
• AR_UPRDEAL

K3S_5050 OVERLAP_OK

Description:

If there is a new deal that is being entered this table code, if flagged on, will allow it to overlap with the old deal. If it is flagged off, then this means that the deal dates will not overlap with existing data.

Enable:

If Flag 1 = 1, then allow the new deal to overlap with the old deal

If Flag 1 = 0, then do NOT allow the new deal to overlap with the old deal

Structure:

Table Code Value: K3S_5050 OVERLAP_OK
Table Code Description 1: Deal dates overlap OK?
Table Flag 1: 0

Programs Used In:

• K3S_5050
• K3S_5055
• AR_ADADELW
• AR_ADDDEAL
• AR_ADDDELW
• AR_ALLDEAL
• AR_APRDEALL
• AR_CPRDEAL
• AR_CPYDEAL
• AR_CPYDELW
• AR_DELDEAL
• AR_PRODELW
• AR_ULNDELW
• AR_UPDDEAL
• AR_UPDDELW
• AR_UPRDEAL

K3S_5050 REF_DUPS

Description:

When creating new deals for a specified supplier, this table code is to tell whether or not deal reference IDs can be duplicated. In file K_DEALSUM for field DM_DEALREF must be unique. This is for when a company would like to use their own internal deal ID to be entered.

Enable:

If Flag 1 = 1, then you would like to use your own internal Deal ID to be entered and so we need to check for duplicates

If Flag 1 = 0, then you would not like to use your own internal Deal ID and so this feauture would not be useful

Structure:

Table Code Value: K3S_5050 REF_DUPS
Table Code Description 1: Deal Reference duplicates OK?
Table Flag 1: 0

Programs Used In:

• K3S_5050
• AR_ADADELW
• AR_ADADELW
• AR_ADDDEAL
• AR_ADDDELW
• AR_ALLDEAL
• AR_APRDEAL
• AR_CPRDEAL
• AR_CPYDEAL
• AR_CPYDELW
• AR_DELDEAL
• AR_ULNDELW
• AR_UPDDEAL
• AR_UPDDELW
• AR_UPRDEAL

K3S_5056 PROCESSING

Description:

This table code tells whether or not the ‘new product automatic deal copy’ logic will be used. When adding a new product into your ERP system, ‘auto set up deals’ will have it where it will immediately pull it in into K3S. If this flag is turned off, the night job will pick it up and on the next day it will be pulled in.

Enable:

If Flag 1 = 1, then you would like the auto set up deals will have it where it will immediately pull it in into K3S

If Flag 1 = 0,then you the night job will pick it up and in the next day it will be pulled in

Structure:

Table Code Value: K3S_5056 PROCESSING
Table Code Description 1: New product auto deal copy?
Table Flag 1: 1

Programs Used In:

• K3S_9010
• K3S_9011

K3S_5300 VALID_USER

Description:

This table code checks authority on the user creating permanent deals.

Enable:

If Flag 3 = 1, then you would like to check the authority

If Flag 3 = 0, then you would not like to check authority

Structure:

Table Code Value: K3S_5300 VALID_USER
Table Code Description 1: Valid users to create all Permanent Deal types
Table Code Description 2: QSECOFR <– Valid user 1
Table Code Description 3: KING3BBAL1<– Valid user 2
Table Code Description 4: GT_ <– Valid user 3
Table Flag 3: 0

Programs Used In:

• K3S_5300

K3S_8000 CURSOR_POS

Obsolete APP. No longer valid in R6.

K3S_8000 F5=PATH

Obsolete APP. No longer valid in R6.

K3S_8011 GET_COST

Description:

For a transfer request, this table code checks to see if the system will be getting the transfer cost from an external source.

Enable:

If Flag 1 = 1, then check to see if the system will be getting the transfer cost from an external source

If Flag 1 = 0, then check to see if the system will be getting the transfer cost from an external source

Structure:

Table Code Value: K3S_8011 GET_COST
Table Code Description 1: Get transfer cost from external source?
Table Flag 1: 0

Programs Used In:

• K3S_8011
• AR_CSTPRTR
• AR_TRFPRTR
• AR_UPDPRTR

K3S_8011 SAVE_COST

Description:

This table code will check to see if the saving product cost is in the over stock file.

Enable:

If Flag 1 = 1, then check to see if the saving product cost is in the Over Stock file

If Flag 1 = 0, then do NOT check to see if the saving product cost is in the Over Stock file

Structure:

Table Code Value: K3S_8011 SAVE_COST
Table Code Description 1: Product cost in PO_FRMEXCS?
Table Flag 1: 0

Programs Used In:

• K3S_8011
• AR_CSTPRTR
• AR_TRFPRTR
• AR_UPDPRTR

K3S_8530 CPY_DEMAND

Description:

This table code determines if the company is authorized to copy demand.

Enable:

If Flag 1 = 1, then you would like to turn this feature on

If Flag 1 = 0, then you would not like this feature turned on

Structure:

Table Code Value: K3S_8530 CPY_DEMAND
Table Code Description 1: Should demand be copied?
Table Flag 1: 0

Programs Used In:

• K3S_8510
• K3S_8520
• AR_APLHUBT
• AR_ASLHUBT
• AR_UPLHUBT
• AR_USLHUBT

K3S_8540 NEW_SLOW

Description:

This table code will automatically change ‘N’ new products to ‘S’ slow.

Enable:

If Flag 1 = 1, them this means that system status of ‘N’ changes to ‘S’

If Flag 1 = 0, then this means that no change made to system status

Structure:

Table Code Value: K3S_8540 NEW_SLOW
Table Code Description 1: System status of ‘N’ to ‘S’?
Table Flag 1: 1

Programs Used In:

• K3S_3014
• K3S_3017
• K3S_8540

K3S_9010 BLOCK_ALTS

Description:

This table code will block alternate source maintenance through the interface.

Enable:

If Flag 1 = 1, then this means that the user will maintain blocking via Product maintenance K3S_3000

If Flag 1 = 0, then this means that the user will maintain blocking via interface file K_INTPROD

Structure:

Table Code Value: K3S_9010 BLOCK_ALTS
Table Code Description 1: Block alt src from K_INTPROD?
Table Flag 1: 1

Programs Used In:

• K3S_3000
• K3S_9010
• K3S_9011

K3S_9010 CLR_PROMO

Description:

This table code will clear fields PR_PROMQTY (Promotional Quantity), PR_PROMBEG (Begin Date), and PR_PROMEND (End Date after expire) after expiration.

Enable:

If Flag 1 = 1, then this means that 3 fields should be cleared

If Flag 1 = 0, then this means to not execute logic

Structure:

Table Code Value: K3S_9010 CLR_PROMO
Table Code Description 1: Promo fields clear option?
Table Code Description 2: Clear Promotional Quantity, Begin Date, and End Date after expire
Table Flag 1: 0

Programs Used In:

• K3S_9010

K3S_9010 CORP_PROF

Description:

This table code is used for customers who use corporate profiles.

Enable:

If Flag 1 = 1, then this means customer does use Corporate Profiles

If Flag 1 = 0, then this means customer does not use Corporate Profiles

Structure:

Table Code Value: K3S_9010 CORP_PROF
Table Code Description 1: Corporate profile default?
Table Code Description 2: Use for all new products
Table Code Description 3: ………. <– Profile ID
Table Flag 1: 0

Programs Used In:

• K3S_9010
• K3S_9011

K3S_9010 COST_0

Description:

This table code will determine if a customer wants ‘cost sent as $0’ logged into the K_LOGPROD file as type ‘c’. This will appear in the night log. If the answer is yes, then see if the customer wants to use a default value for cost, stored in Number2 field.

Enable:

If Flag 1 = 1, then this means you would like to log if the cost was sent as $0 into the night log

If Flag 1 = 0, then this means you would not like to log if the cost was sent as $0 into the night log

If Flag 2 = 1, then this means that you would like to you to use a default cost

If Flag 2 = 0, then this means that you would not like to you to use a default cost

Table Number 2 will hold the default value for cost

Structure:

Table Code Value: K3S_9010 COST_0
Table Code Description 1: Log when cost sent as $0?
Table Code Description 2: Use Flag2=1 if you want to
Table Code Description 3: use default cost in Number2
Table Flag 1: 0
Table Flag 2: 0
Table Number 2 (7.2): .00

Programs Used In:

• K3S_9010
• K3S_9011

K3S_9010 DAYS_OUT

Description:

This table code will determine whether or not to include backorders in the ‘count days out’ logic.

Enable:

If Flag 1 = 1, then this means to include back orders in logic

If Flag 1 = 0, then this means to not include backorders in logic

Structure:

Table Code Value: K3S_9010 DAYS_OUT
Table Code Description 1: Include back orders in logic?
Table Flag 1: 0

Programs Used In:

• K3S_9010

K3S_9010 DAYS_OUT_2

Description:

This table code will determine whether or not to include lost sales in ‘count days out’ logic

Enable:

If Flag 1 = 1, then this means to include lost sales in logic

If Flag 1 = 0, then this means to not include lost sales in logic

Structure:

Table Code Value: K3S_9010 DAYS_OUT_2
Table Code Description 1: Include lost sales in logic?
Table Flag 1: 0

Programs Used In:

• K3S_9010

K3S_9010 NEW_SLOW

Description:

This table code, with a new product, will change the system status from ‘N’ to ‘S’ (New to Slow)

Enable:

If Flag 1 = 1, then this means that this product will automatically have system status changed from ‘N’ to ‘S’ (New to Slow) during add to system

If Flag 1 = 0, then this means no automatic change will be made to system status when New product added to system

If Flag 2 = 1, then this means that this product should use a default average

If Flag 2 = 0, then this means that this product will not use a defaulted value for the average

Table Number 2 will store this default average

Structure:

Table Code Value: K3S_9010 NEW_SLOW
Table Code Description 1: System status of ‘N’ to ‘S’?
Table Code Description 2: Flag 2=1 for average default (use Number 2 field)
Table Flag 1: 0
Table Flag 2: 0
Table Number 2 (7.2): 0

Programs Used In:

• K3S_FX510A
• K3S_9010
• K3S_9011

K3S_9010 PE_SNPSHOT

Description:

This table code will determine whether or not PE snapshots will be collected. This will be found in the History log. The system will do a before and after snapshot at period end. This will show if it was adjusted by the system.

Enable:

If Flag 1 = 1, then this means we do want to collect period ending snapshots

If Flag 1 = 0, then this means we do not want to collect pe snapshots

Flag 2 is obsolete

Structure:

Table Code Value: K3S_9010 PE_SNPSHOT
Table Code Description 1: Period End snapshots?
Table Code Description 2: Flag2=1 to Ignore type “G” Period End snapshots
Table Flag 1: 1
Table Flag 2: 0

Programs Used In:

• K3S_FX530B
• K3S_3040
• K3S_9010

K3S_9010 PE1FLTR

Description:

This table code checks to see if we want to filter PE1 checks who have a ‘manual minimum’ unit that is greater or equal to the demand.

Enable:

If Flag 1 = 1, then this means we do want to filter PE1 when Demand <= Manual Minimum Unit

If Flag 1 = 0, then this means we do not want to filter PE1 checks

Structure:

Table Code Value: K3S_9010 PE1_FLTR_1
Table Code Description 1: Filter PE1 when Demand <= Manual Minimum Unit?
Table Flag 1: 0

Program Used In:

• K3S_9010

K3S_9010 PR_BIRTH

Description:

This table code will determine if a customer wants the field PR_BIRTH to be populated using IP_BIRTH (from the K_INTPROD file) for new products.

Enable:

If Flag 1 = 1, then this mean that you would like for the new product to grab it’s ‘Birth Date’ from the interface file

If Flag 1 = 0, then this mean that you would not like for the new product to grab it’s ‘Birth Date’ from the interface file

Structure:

Table Code Value: K3S_9010 PR_BIRTH
Table Code Description 1: New products use IP_BIRTH?
Table Flag 1: 0

Program Used In:

• K3S_9010
• K3S_9011

K3S_9010 PR_LSTRCVD

Description:

This table code will determine if the customer wants the field PR_LSTRCVD (last received date) to update daily in program K3S_9010, which will then be used in program K3S_3600 to filter any products not received yet from the overstock report.

Enable:

If Flag 1 = 1, then you would like to update daily the last received date

If Flag 1 = 0, then you would not like to update daily the last received date

Structure:

Table Code Value: K3S_9010 PR_LSTRCVD
Table Code Description 1: Update last received date?
Table Flag 1: 0

Program Used In:

• K3S_9010

K3S_9010 PR_QTYPEND

Description:

This table code is for multi-location customers who can provide transfer information.

Enable:

If Flag 1 = 1, then the customer can provide passing transfer information via IP_TRNOORD

If Flag 1 = 0, then the customer is not able to provide passing transfer information

Structure:

Table Code Value: K3S_9010 PR_QTYPEND
Table Code Description 1: Update PR_QTYPEND from IP_TRNOORD?
Table Flag 1: 0

Program Used In:

• K3S_9010

K3S_9011 BLOCK_3037

Description:

This table code will block the CALL to K3S_3037. This program will grab the product history for a new item’s 1st sales period & year. This is to mark from which period have we started recording data for this product. For the store level processing environment, we do NOT want K3S_9011 to perform a CALL to K3S_3037, hence, we would like this flag to be turned on.

Enable:

If Flag 1 = 1, then you would like to block the call to K3S_3037

If Flag 1 = 0, then you would not like to block the call to K3S_3037

Structure:

Table Code Value: K3S_9011 BLOCK_3037
Table Code Description 1: Block the CALL to K3S_3037?
Table Flag 1: 0

Program Used In:

• K3S_9011

K3S_9040 NEW_ENTRY

Obsolete APP. No longer in use in R6.

K3S_9702 K3S_SEND

Description:

If your environment is set up so that multiple scheduled K3S jobs get backed up in the job queue, then you will run into a situation where some of the jobs get ended prematurely.

When the scheduled K3S jobs run, they will call program K3S_RMVJOB as an initial step. Program K3S_RMVJOB calls RPG program K3S_9702 which will look for any other K3S jobs that are in the queue. If it finds any, it will end them immediately. However, each job is protected from ending itself due to a MONMSG for CPF1342 in program K3S_9702CL.

So this table code then allows you to give the option to tell RPG program K3S_9702 the names of scheduled K3S jobs you do not want canceled in case several jobs are stacked up in the job queue.

Enable:

If Flag 1 = 1, then you would like to protect some of the jobs from ending itself

If Flag 1 = 0, then you would not like to protect some of the jobs from ending itself

Structure:

Table Code Value: K3S_9702 K3S_SEND
Table Code Description 1: Do not remove this job name
Table Flag 1: 0

Program Used In:

Contact K3S to help you set up those links.

LEAD_TIME ADJUSTMENT

Description:

This table code will always add a certain amount of days to the lead time. You can add the number of days in Table Number 2.

Enable:

Note: This table code will continue to work even if this flag is turned off. If you would not like to add a number of days to the lead time, then Table Number 2 should equal 0.

Structure:

Table Code Value: LEAD_TIME ADJUSTMENT
Table Code Description 1: Add Number2 value to lead time
Table Flag 1: 0
Table Number 2 (7.2): 1.00

Program Used In:

• K3S_3060
• K3S_3065

LOWERCASE SUPL_NAME

Description:

This table code will determine whether or not to allow lowercase in the supplier’s name.

Enable:

If Flag 1 = 1, then this means that you want to allow lowercase in the supplier’s name

If Flag 1 = 0, then this means that you don’t want to allow lowercase in the supplier’s name

Structure:

Table Code Value: LOWERCASE SUPL_NAME
Table Code Description 1: Lower case for supplier name?
Table Flag 1: 0

Program Used In:

• K3S_1010
• K3S_2000
• K3S_2070
• K3S_9520

METRICS INVENTORY

Description:

This table code checks to see if the inventory metrics is turned on.

Enable:

If Flag 1 = 1, then you would like to see the inventory metrics

If Flag 1 = 0, then you would not like to see the inventory metrics

Structure:

Table Code Value: METRICS INVENTORY
Table Code Description 1: Run inventory metrics at period end?
Table Code Description 2: Set Flag1=1 to turn on
Table Flag 1: 0

Program Used In:

• K3S_0101
• K3S_METTYP

METRICS MFGOUT

Description:

This table code checks to see if the MFG out of stock flag is being considered in calculations. Company view on service level, if they had lost sales, was it because the manufacture was out? We don’t want to lower the service level for your company because the manufacturer didn’t have the product.

Enable:

If Flag 1 = 1, then you would like to enable this feature

If Flag 1 = 0, then you would not like to enable this feature

Structure:

Table Code Value: METRICS MFGOUT
Table Code Description 1: Use MFGOUT flag for inventory metrics?
Table Code Description 2: Set Flag1=1 to turn on
Table Flag 1: 0

Program Used In:

• K3S_0101
• K3S_INVPRD
• K3S_INXPRD

METRICS USER

Description:

This table code checks to see if the User Metrics is turned on.

Enable:

If Flag 1 = 1, then you want the user metrics to be used

If Flag 1 = 0, then you do not want the user metrics to be used

Structure:

Table Code Value: METRICS USER
Table Code Description 1: Run user metrics at period end?
Table Code Description 2: Set Flag1=1 to turn on
Table Flag 1: 0

Program Used In:

• K3S_0101
• K3S_METTYP

MIN_MAX AVERAGE=O

Description:

This table code will calculate manual min/max Days and Units even when the PR_FORCAST = 0.

Enable:

If Flag 1 = 1, then this means to process min/max even when PR_FORCAST = 0

If Flag 1 = 0, then this means do not process min/max when PR_FORCAST = 0

Structure:

Table Code Value: MIN_MAX AVERAGE=0
Table Code Description 1: Manual MinMax if PR_FORCAST=0?
Table Flag 1: 0

Program Used In:

• K3S_1500
• K3S_1510
• K3S_3600

MIN_MAX STRAIGHT=1

Description:

This table code will save Straight manual min/max Days and Units processing flags. When this is on, K3S SOQ calculate is bypassed, and the SOQ will be forced to the min value or the max value found in the Product Settings.

Enable:

If Flag 1 = 1, then this means use straight days

If Flag 1 = 0, then this means do not use straight days

If Flag 2 = 1, then this means use straight units

If Flag 2 = 0, then this means do not use straight units

Structure:

Table Code Value: MIN_MAX STRAIGHT=1
Table Code Description 1: Flag 1 days, Flag 2 units
Table Flag 1: 0
Table Flag 2: 0

Program Used In:

• K3S_1500
• K3S_1510
• K3S_3025

NOTE_DSPLY

Description:

This table code will allow the customer to change TA_FLAG1 to control the sequence of notes.

Enable:

If Flag 1 = 1, then this means use straight days

If Flag 1 = 0, then this means do not use straight days

If Flag 2 = 1, then this means use straight units

If Flag 2 = 0, then this means do not use straight units

Structure:

Table Code Value: NOTE_DSPLY
Table Code Description 1: Control note sequence in R6
Table Code Description 2: Flag1=0 Note Sequence Ascending
Table Code Description 3: Flag1=1 Date added Descending
Table Flag 1: 0

NT_SERVER BEING_USED

Obsolete APP. No longer in use in R6

PE_WARNINGSYSTEM

Obsolete APP. No longer in use in R6

PITCO

Obsolete APP. No longer in use in R6

PRODUCT DISPLAY

Description:

This table code will add certain values infront of product display.

Enable:

If Flag 1 = 1, then it will grab the the value in table number 3, which will be the number of blanks added before the Product Display

If Flag 1 = 0, then you do not want anything to be added before the Product Display

Structure:

Table Code Value: PRODUCT DISPLAY
Table Code Description 1: Use for product & description?
Table Code Description 2: #1= Product ID key length
Table Code Description 3: #2= Start of key value
Table Code Description 4: #3= Number of blanks before data
Table Flag 1: 0
Table Number 1 (5.0): 25
Table Number 2 (7.2): 1.00
Table Number 3 (11.4): .0000

Program Used In:

• K3S_FX55BD
• K3S_1016
• K3S_1030
• K3S_1042
• K3S_1045
• K3S_1047
• K3S_3000
• K3S_3001
• K3S_3015
• K3S_3019
• K3S_3033
• K3S_3050
• K3S_3051
• K3S_3054
• K3S_3057
• K3S_3070
• K3S_3085
• K3S_3090
• K3S_3210
• K3S_3220
• K3S_3301
• K3S_3400
• K3S_3415
• K3S_3417
• K3S_3430
• K3S_3450
• K3S_3451
• K3S_3452
• K3S_3470
• K3S_3615
• K3S_3715
• K3S_3718
• K3S_3755
• K3S_3765
• K3S_4011
• K3S_5050
• K3S_5051
• K3S_5071
• K3S_5300
• K3S_5315
• K3S_8010
• K3S_8520
• K3S_8527
• K3S_9200

PRODUCT RIGHT_ADJ

Obsolete APP. No longer in use in R6

RESTRICT (USER)

Obsolete APP. No longer in use in R6

SALES JOURNAL

Description:

This table code is for displaying sales of products that were just partially sold, hence, needing the decimal point.

Enable:

If Flag 1 = 1, then you would like to display sales with a .00 decimal point

If Flag 1 = 0, then you would not like to display sales with a .00 decimal point

Structure:

Table Code Value: SALES JOURNAL
Table Code Description 1: Display quantity values with 2 decimals?
Table Flag 1: 0

Program Used In:

All logic used in the graphical interface.

SEASONAL ENTRY

Obsolete APP. No longer in use in R6

SPECIAL MESSAGE

Description:

This table code is for any special message that you would like to be displayed on the home screen. The message in which will be displayed will be entered in description 2.

Enable:

If Flag 1 = 1, then you would like a special message to be displayed on the home screen

If Flag 1 = 0, then you would not like a special message to be displayed on the home screen

Flag 2 is obsolete

Structure:

Table Code Value: SPECIAL MESSAGE
Table Code Description 1: Show message on main menu?
Table Code Description 2:
Table Code Description 3: support@k3s**.commdescription 2 and turn Flag 1 = 1
Table Code Description 4: Turn Flag 2 = 1 to highlight message
Table Code Description 5: Access To Legacy green screen / Presto ends Jan 1, 2020. Email support@k3s.com for R6 information
Table Flag 1: 0

Program Used In:

• K3S_0010

STORE LEVEL

Description:

If you are on a store level environment, please enable this table code.

Enable:

If Flag 1 = 1, then this is a store level environment

If Flag 1 = 0, then this is not a store level environment

Structure:

Table Code Value: STORE LEVEL
Table Code Description 1: Store Level switch on?
Table Flag 1: 0

Program Used In:

• K3S_0010
• K3S_1010
• K3S_1015
• K3S_1016
• K3S_1020
• K3S_1030
• K3S_1040
• K3S_1041
• K3S_2000
• K3S_2030
• K3S_2031
• K3S_2032
• K3S_3000
• K3S_3030
• K3S_3031
• K3S_3070
• K3S_9520
• K3S_9530

USECHAINWITHORDER#

Description:

From GH issue: https://github.com/K3S/R6/issues/2375

This will be used by customers who have leading white space on fields in K_INTDALY.

Enable:

If Flag 1 = 1, then you would like to enable this feature

If Flag 1 = 0, then you would like this feature disabled

Structure:

Table code type.. APP

Description…… Applications control
Table code value. USECHAINWI THORDER#

Description 1…. This will use or ignore the Chain ID when viewing Customer Orders
Description 2…. Set Flag1=1 to Enable the ignore of Chain ID. Default Flag1=0
Flag 1……….. 0

---