Freshmark replication server

freshmark-canonical

Cross-schema map

Metadata, menu storage, and security groups

This view ties together what lives in the metadata schema and what actually stores live menu rows.

Subsystems

ZW_SUBSYS
D Debtor
M Menu

Database registry

ZB_DB
ACH_UMT_D MySQL Provider=MSDASQL;Data Source=ACH_UMT_D
ACH_UMT_U MySQL Provider=MSDASQL;Data Source=ACH_UMT_U
APA_ARCH MySQL Provider=MSDASQL;Data Source=APA_ARCH
APA_FMS MySQL Provider=MSDASQL;Data Source=APA_FMS
ARCHIVE MySQL Provider=MSDASQL;Data Source=ARCHIVE
DEV MySQL Provider=MSDASQL;Data Source=DEV
DEVZ MySQL Provider=MSDASQL;Data Source=DEVZ
FMS MySQL Provider=MSDASQL;Data Source=FMS
FMSX MySQL Provider=MSDASQL;Data Source=FMSX
FMSZ MySQL Provider=MSDASQL;Data Source=FMSZ
FMSZZ MySQL Provider=MSDASQL;Data Source=FMSZZ
HLPD MySQL Provider=MSDASQL;Data Source=HLPD
HLPDX MySQL Provider=MSDASQL;Data Source=HLPD
HLPDZ MySQL Provider=MSDASQL;Data Source=HLPDZ
UMT_FMSX_D MySQL Provider=MSDASQL;Data Source=UMT_FMSX_D
UMT_FMSX_U MySQL Provider=MSDASQL;Data Source=UMT_FMSX_U
UMT_FMS_D MySQL Provider=MSDASQL;Data Source=UMT_FMS_D
UMT_FMS_U MySQL Provider=MSDASQL;Data Source=UMT_FMS_U
VER MySQL Provider=MSDASQL;Data Source=VER
VERX MySQL Provider=MSDASQL;Data Source=VERX
VERZ MySQL Provider=MSDASQL;Data Source=VERZ

Menu security groups

ZC_SEC_GROUP
ABS ABSA -> MAINMENU
AGF AGENTS FLOOR -> MAINMENU
AGJ AGENTS OFFICE JACO -> MAINMENU
AGN AGENTS -> MAINMENU
BEL BELINDA -> MAINMENU
BYC BUYERS CARD -> MAINMENU
CAB CASHIERS -> MAINMENU
CAC CONSIGNMENT CONTROL -> MAINMENU
CAD CASHIERS CONNIE -> MAINMENU
CAE CASHIERS -> MAINMENU
CAS CASHIERS -> MAINMENU
CAX CASHIERS SPECIAL -> MAINMENU
CBC CONSIGNMENT CONTROL -> MAINMENU
CCC CONSIGNMENT CONTROL -> MAINMENU
CHP CHEP -> MAINMENU
CLD COLD STORE -> MAINMENU
COC CONSIGNMENT CONTROL -> MAINMENU
CTR CLIENT CENTRE -> MAINMENU

Menu type mix

ZM_MENU
P 763
G 698
R 208
M 117
A 73
E 5
X 5

Key table registry entries

ZT_TABLE
Table Description Database Owner Audit table
ACCOUNT_TYPE ACCOUNT_TYPE FMS
AC_ACTIVITY AC_ACTIVITY FMS
ADDR_TYPE ADDR_TYPE FMS
AGENT_ARCHIVE AGENT_ARCHIVE FMS
AGENT_BANK AGENT_BANK FMS AUD_AGENT_BANK
AGENT_CHEP_BAL AGENT_CHEP_BAL FMS
AGENT_CHEQUE AGENT_CHEQUE FMS
AGENT_CREDIT_PAYMENTS AGENT_CREDIT_PAYMENTS FMS
AGENT_DAILY AGENT_DAILY FMS
AGENT_FAXES AGENT_FAXES FMS
AGENT_FAX_MESSAGE AGENT_FAX_MESSAGE FMS
AGENT_MAST AGENT_MAST FMS AUD_AGENT_MAST
AGENT_SURETY AGENT_SURETY FMS
AGENT_TYPE AGENT_TYPE FMS
AGNSECT_PALL_ACC AGNSECT_PALL_ACC FMS AUD_AGNSECT_PALL_ACC
AGN_FAX_SECT AGN_FAX_SECT FMS
AGN_FAX_SECT_SMAN AGN_FAX_SECT_SMAN FMS
AGN_PASSW AGN_PASSW FMS
AGN_ROOM_USAGE AGN_ROOM_USAGE FMS
AGN_SUPP_ZCOMM AGN_SUPP_ZCOMM FMS
AMENDED_STATS AMENDED_STATS FMS
API_CALLS API_CALLS FMS
APO_TEMP APO_TEMP FMS
ARCHIVE_AGN_PARMS ARCHIVE_AGN_PARMS FMS
ARCHIVE_AGN_REP ARCHIVE_AGN_REP FMS
ARCHIVE_AGN_REP_PATH ARCHIVE_AGN_REP_PATH FMS
ARCHIVE_MASTER ARCHIVE
ARCHIVE_PARMS ARCHIVE_PARMS FMS
ARCHIVE_RESULTS ARCHIVE_RESULTS FMS
AREA_MAST AREA_MAST FMS
AUD_AGENT_BANK AUD_AGENT_BANK FMS
AUD_AGENT_MAST AUD_AGENT_MAST FMS
AUD_AGNSECT_PALL_ACC AUD_AGNSECT_PALL_ACC FMS
AUD_BUYER_PALL_ACC AUD_BUYER_PALL_ACC FMS
AUD_BUYER_REFUND AUD_BUYER_REFUND FMS
AUD_BUYER_STAT_EMAIL_LST AUD_BUYER_STAT_EMAIL_LST FMS
AUD_BUYER_SUBS AUD_BUYER_SUBS FMS
AUD_CASH_DENOMINATION AUD_CASH_DENOMINATION FMS
AUD_CLASS_MAST AUD_CLASS_MAST FMS
AUD_CLIENT_MAST AUD_CLIENT_MAST FMS
AUD_COLOUR_MAST AUD_COLOUR_MAST FMS
AUD_COMMODITY_MAST AUD_COMMODITY_MAST FMS
AUD_COMM_PERC AUD_COMM_PERC FMS
AUD_CONT_MAST AUD_CONT_MAST FMS
AUD_CONT_RATE AUD_CONT_RATE FMS
AUD_COUNT_MAST AUD_COUNT_MAST FMS
AUD_CRLIMIT_PASSWORD AUD_CRLIMIT_PASSWORD FMS
AUD_DEBTOR_MAST AUD_DEBTOR_MAST FMS
AUD_DEBT_ADDR AUD_DEBT_ADDR FMS
AUD_DEDUCT_MAST AUD_DEDUCT_MAST FMS
AUD_FM_COMMODITY AUD_FM_COMMODITY FMS
AUD_FM_CONT AUD_FM_CONT FMS
aud_fm_ped_mast aud_fm_ped_mast FMS
AUD_FM_PERMIT_HOLDERS AUD_FM_PERMIT_HOLDERS FMS
AUD_FM_PRODUCT AUD_FM_PRODUCT FMS
AUD_FM_PRODUCT_MAST AUD_FM_PRODUCT_MAST FMS
AUD_FM_TABLES AUD_FM_TABLES FMS
AUD_FM_TARIFF AUD_FM_TARIFF FMS
AUD_FM_TRADER_TYPES AUD_FM_TRADER_TYPES FMS
AUD_IP_MAST AUD_IP_MAST FMS
AUD_ITEM_COLOUR AUD_ITEM_COLOUR FMS
AUD_LEVY_MAST AUD_LEVY_MAST FMS
AUD_LOCATION_MAST AUD_LOCATION_MAST FMS
AUD_LOC_REMARK AUD_LOC_REMARK FMS
AUD_LOC_TRANS AUD_LOC_TRANS FMS
AUD_PALL_CS_TARIFF AUD_PALL_CS_TARIFF FMS
AUD_PALL_DETS AUD_PALL_DETS FMS
AUD_PALL_MAST AUD_PALL_MAST FMS
AUD_PALL_RATE AUD_PALL_RATE FMS
AUD_PARAM_AGENT AUD_PARAM_AGENT FMS
AUD_PARAM_MKT AUD_PARAM_MKT FMS
AUD_PARAM_SECT AUD_PARAM_SECT FMS
AUD_PRODUCT_MAST AUD_PRODUCT_MAST FMS
AUD_PROHIBIT AUD_PROHIBIT FMS
AUD_PROV_BUYER_SMAN AUD_PROV_BUYER_SMAN FMS
AUD_PROV_MAST AUD_PROV_MAST FMS
AUD_REPRINTS AUD_REPRINTS FMS
AUD_ROUND AUD_ROUND FMS
AUD_SALESMAN_MAST AUD_SALESMAN_MAST FMS
AUD_SIZE_MAST AUD_SIZE_MAST FMS

Menu sample: MAINMENU

45 rows
Seq Description Lvl Type Program Before After Groups
005 Late Collections 1 M LATE LCM
010 Statistics 0 M STATS STS, MKT, CCC, CAC, COC, SAD, BEL, INS, BYC
020 Wholesale 1 M WSALE SAD, CAC, COC
025 Short Menu 1 M SHORT AGF
030 Sales 1 M SALES AGF, AGN, HEC, JUS, CTR, INF, COC, BEL, CAS, HEA, DEB, SAD, CCC, EXT, BYC, AGJ
040 Deliveries 1 M AGN_DELS AGF, MKT, AGN, CCC, CAC, MOA, MOF, CBC, COC, INF, INS, BEL, SAD, CLD, BYC, AGJ, DEV
050 Buyers 1 M BUYERS INF, MKT, RGN, CAD, HEC, HEA, DEB, BEL, CAX, AGF, CAS, SAD, AGN, DEV, BYC, AGJ
080 Faxes 1 M FAXES AGF, AGN, dev, CAC, DEV, SAD
090 Pallets 1 M PALLS AGF, SAD, DEV, AGN
100 &Sales 1 M COMM_SALES DEV, TST, SUP, CTR, EXP, CAX, CAC, HEA, DEB, SAD, CAS
110 Provisional Sales 1 M PROFORMA_SALES INF, DEB, CAS, HEA, BEL, AGN, SAD, BYC
120 &Deliveries 1 M DELIVERIES TST, SUP, DEL, CLD, CAC, MOC
125 &Deliveries 1 M NEW_DEL GAT, CAC
130 Master Files 1 M MASTFILES AGN, BEL, BYC
140 Stock Reports 1 M STOCK_REPORTS CAC
150 D&ebtors 1 M DEBTORS DEV, TST, SUP, DEB, ABS, SAD, STS, CAX, CAD, HEC, MOA, CAB, CAE, BEL, CAS, INF, HEA, AGF, AGN, BYC
160 &Location Control 1 M LOCATIONS ,
180 Cold &Storage 1 M COLDSTORAGE TST, SAD, CLD, AGN, MKT, DEV, AGF, BEL, BYC, AGJ
200 Administrator 1 M ADMINISTRATOR2 DEV, TST, SAD, SUP, DEB, MOA, BEL, INF, HEA, CCC, COC, INS, AGN, EXT, BYC
220 Administrator 1 M ADMINISTRATOR DEV, TST
240 Document Archive 1 M DOCUMENT_ARCHIVE ,
280 Agents 1 M AGENTS TST, AGN, DEV, AGF, COC, BEL, CCC, SAD, BYC, AGJ
300 C&ashiers 1 M CASHIERSMNU TST, SAD, CAS, HEA, SUP, CAD, HEC, CAB, CAE, DEB
320 &Pallets 1 M PALLMAIN TST, PAL, CAC, SAD

Menu sample: ADMINI_REPS

120 rows
Seq Description Lvl Type Program Before After Groups
001 Chep Reports 1 M CHEPPAL
003 Outstanding Buyer Returns 1 P BUYERS_OS_PALLETS DEV, AGN
005 Buyer Purchases by Turnover 1 G BUYER_PURCH_TRNOVR DEV
010 Cheque Payment Listing 1 G CHEQUE_TRANS DEV
012 STOCK SHEETS MANUAL 1 P CONSIGN_STOCK_PRT DEV
015 Refund Authorisation Report 1 G REFUND_AUTH_REPORT DEV
016 JD CHEP MONTHLY MOVEMENT 1 G CHEP_MONTHLY_MOVE DEV
017 JD CHEP BUYERS OS PALLETS 1 G BUYERS_OS_PALLETS DEV
018 JD CHEP WRITEOFF ENQUIRY 1 G WRITE_OFF_ENQ DEV
020 New Consignment Listing 1 G NEW_CONS_LIST DEV, TST, AGN, AGF, AGJ
022 New Consignment Listing by Sales Section 1 G NEW_CONS_SEC_PTA AGN, DEV, AGF, AGJ
025 New Consignment Listing By Supplier 1 G NEW_CONS_LIST_SUPPL DEV, AGN, AGF, AGJ
030 Detailed Daily Salesman Report 1 G DAILY_SMAN_DETAILED DEV, AGN, TST, SAD, AGF, AGJ
032 Monthly Market Docket Usage 1 P MKT_DOC_USAGE DEV, AGN, AGJ
033 Summarized Daily Salesman Report 1 G DAILY_SMAN_REPORT DEV, TST, SAD, AGF
034 Summ. Daily Sman - NO Comm 1 G DAILY_SMAN_REPORT_NC DEV, AGN, AGJ
035 Sales Transaction by Salesman 1 R SALES_TRANS_BY_SMAN DEV, SAD, BEL, BYC
036 Sales Summary by Salesman 1 G SALES_SUMM_BY_SMAN DEV, AGN, AGF, AGJ
039 New Pallet Consign Listing 1 G NEW_PALL_CONS DEV, TST, SAD, AGN
040 Amended Pallet Consign List 1 G AMENDED_PALL_CONS DEV, TST, SAD
045 Deleted Pallet Consign List 1 G DELETED_PALL_CONS DEV, TST, SAD, AGF
050 Pallet Deliveries Received 1 G PALL_DELS_RECEIVED DEV, TST, SAD, AGN, AGJ
051 Pallet Deliveries Received- by Supplier 1 G PALL_DELS_REC_RSA DEV, SAD
055 Cashier Pall Refund Cancel List 1 G CSH_REF_CANCEL_LIST DEV, TST, SAD

Menu sample: DEBTORS

89 rows
Seq Description Lvl Type Program Before After Groups
010 DOCNO ENQUIRY 1 G DOCNO_ENQ DEV
030 Credit Limit Changed 1 P CRED_LIM_CHANGED DEV, DEB, HEA
040 Debtor Deletion 1 P DEBTOR_DELETION DEV
050 Buyers Sms Facility 1 P BUYER_SMS_FACILITY DEV, TST
070 Clear Buyer Refund 1 P CLEAR_BUYER_REF DEV
080 Debtor Type Maintenance 1 P DEBTOR_TYPE_MAN DEV, TST
090 Debtor Address Maintenance 1 A DEBT_ADDR_MAN DEV, TST, SAD, DEB, HEC, BYC
100 Account Type Maintenance 1 P ACC_TYPE DEV
110 Entry Type 1 P ENTRY_TYPE DEV, TST
120 Business Type 1 P BUSINESS_TYPE DEV, TST
130 Buyer Purchases Summary 1 P BUYER_PURCH_SUMM DEV
140 Annual DR/CR Balance Listing 1 P ANNUAL_BALANCES DEV
150 Debtor Maintenance 1 A DEBTOR_MAN DEV, TST, SAD, DEB, SUP, STS, CAD, HEC, MOA, BYC, BEL
155 Credit Buyer Maintenance 1 A CREDIT_BUYER_MAN DEB, DEV
160 Buyer Credit Limit Maintenance 1 P DEBTOR_CRLIMIT_MAN DEV, TST, DEB, HEA
165 Surety Buyer Maintenance 1 A BUYERS_SURETY_AGN DEB, DEV
170 Buyer Account Journals 1 P SINGLE_JOURNAL DEV, TST
175 Provisional Buyer Setup 1 P BUYERS_SURETY DEB, DEV
180 Buyer Statements 1 P BUYER_STATEMENTS N N DEV, TST
190 Buyer Statements (Bulk Email) 1 P BUYER_STAT_EMAIL DEV, TST, HEC
200 Debtor Transaction Listing 1 P BUYER_TRANS_LISTING DEV, SUP
210 Debtor Balance Listing 1 R DEBTOR_LISTING DEV, SAD, DEB, SUP, INS
220 Buyer Purchases Summary 1 R BUYER_PURCHASES_SUM DEV, SUP
230 Buyer Sales Transactions By Buyer 1 R SALES_TRANS_BY_BUYER DEV, SUP, ABS, CAD, HEC, CAB, CAE

Menu sample: SALES

36 rows
Seq Description Lvl Type Program Before After Groups
010 Agent Sales 1 P AGENT_SALES AS AGF, EXT
020 Reserved stock docket print 1 P RESERVATION_MAN_PRT
021 Mobile Sales 1 P AGENT_SALES MS MOF
022 Mobile Sales Docket Print 1 P PRINT_MOBI_SALES DEV, AGF, AGR, GAT, EXT
025 Reservation Confirmation 1 P BUYER_RESER_CONF_PRT DEV
030 Agent Reserved Stock Enquiry 1 G AGENT_RES_STK_ENQ AGF, AGN, AGJ
040 Agent Reserved Stock Enq By Consignment 1 G AGN_RES_STK_ENQ_CONS AGF, AGN, DEV, AGJ
050 Stock Reservations Buyer Transfer 1 P TRANSFER_RESERV
060 Stock Reservation Transfer by Docket No 1 P TRANSFER_RESERVATION DEV
070 Buyer Pallet Return (CHEP) 1 P BUY_POOL_RET_MAN A
080 Condensed Buyer Sales Enquiry 1 G BUYER_TRANS_SUMM2 HEC, INF
090 Consignment Enquiry 1 G CONS_ENQUIRY AGF, AGN, JUS, SAD, AGJ
100 Unpaid Sales Listing 1 G UNPAID_SALES_LIST AGN, INF, AGF, AGJ
110 Deleted Sales Report 1 R SALES_DELETIONS AGN, AGJ
120 Clear Unpaid Sales 1 P CLEAR_RESERVED_STK
125 Clear Unpaid Sales 1 P CLEAR_UNPAID_SALES DEV, AGF
130 Sales Deletion 1 P SALES_DEL_MAN: D
140 Sales Docket Reprints 1 P AGN_DKT_REPRINTS_NEW DEV
170 Late Collection Sales 1 P LATE_COLLECTION DEV
200 Release Consignment Locks 1 P LOCK_RELEASE_MAN
205 Reprint Credit Note 1 P REPRINT_CREDIT_NOTE SAD, HEA, DEB
210 Docket Reprints 1 G DOCKET_REPRINTS_NEW CAD, DEV, HEC, DEB, SAD
220 Reprint Sales Summary 1 G REPRINT_SALES_SUMM CAD, HEC
230 Sales Deletion and Transfer 1 P SALES_DEL_MAN: T DEV, AGF

Menu sample: ADMINISTRATOR

42 rows
Seq Description Lvl Type Program Before After Groups
010 Prohibit Sales 1 G PROHIBIT_SALES TST, DEV
011 Market Calender Maintenance 1 P CALENDER_MAN DEV
012 New Dily Stats by Item JD 1 R DAILY_STATS_NEW DEV
013 COMMP FIX 1 P COMMP_FIX DEV
020 Reports 1 M ADMIN_REPORTS DEV, CLD, SAD, INF
030 IP Control 1 P IP_CONTROL_MAN DEV, TST
040 IP Maintenance 1 P IP_MAST_MAN DEV, TST
050 Change Data Authorization 1 P CHANGE_AUTH_MAN DEV
051 Buyer Pins and Rescan Reset 1 P BUYER_PINS DEV
052 Fix Deldate 1 P FIX_DELDATE DEV
058 Janet Levy Fix 1 P JANET_LEVY_FIX DEV
060 Janet Grade and Count Conversion 1 P JANET_CONV DEV
061 Language Conversion 1 P LANG_CONVERSION DEV
062 Debtor Balances Takeon 1 P DEBTOR_BAL_TAKEON DEV
063 Payments vs Sales check 1 P PMT_VS_SLS DEV
064 Debtor Trans vs Stk Trans Sales 1 P DT_VS_STK DEV
065 Laz Debtor Trans Reset 1 P LAZ_DEBTOR_TRANS DEV
066 RK Docarch Run with Date Range 1 P DOCARCH_RUN_DTE_RANG DEV
067 Dot Payments Check 1 G DOT_DOCKET_CHECK DEV
068 JD CS TFR TO FLOOR 1 P TRANS_ALL_TO_FLR DEV
070 Release Consignment Locks 1 P LOCK_RELEASE_MAN DEV
080 Stock Balance Discrepancies 1 P STK_BAL_ENQ DEV
090 Change User Password 1 P CHANGE_PASSWORD DEV
100 Recovery Procedures 1 P RECOVERY_PROCEDURES DEV

Menu sample: COLDSTORAGE

57 rows
Seq Description Lvl Type Program Before After Groups
010 Deposit Confirmation 1 P CS_CONF DEV
030 Deposit Confirmation by Docket 1 P CS_CONFIRM_SINGLE DEV, CLD
035 Delete All Unconfirmed Deposits 1 P CLEAR_UNCONF_DEPS DEV, CLD
040 Confirm Issues 1 P CS_CONF_ISS_PRE DEV
100 Tax Docket Reprint 1 P TAX_DOCKET_REPRINT DEV, TST
110 Location Rate Maintenance 1 P LOC_RATE_MAN DEV, TST
115 Cold Storage Stock Report and Dump 1 P CS_STKSHEET_CPT DEV, AGN, AGJ
120 Cold Storage Stock Listing 1 R COLD_STORAGE_STK DEV, SUP, AGN, AGJ
130 Cold Storage Stock Sheet 1 P CS_STKSHEET_CPT DEV, AGF
140 Cold Storage Agent Deposits 1 P CS_AGENT_DEP_MAN DEV, TST, CLD, AGF
160 Cold Storage Agent Issues 1 P CS_AGENT_ISS_MAN DEV, TST, CLD
170 Cold Storage Deposit Deletions 1 P CS_DEP_DELETIONS DEV, CLD, AGF, BEL, BYC
180 Cold Storage Issue Deletions 1 P CS_DOC_DELETIONS DEV, TST, CLD
200 Other Deposits (By Consignment) 1 P CS_OTHER_DEP_MAN DEV, TST
220 Cold Storage Daily Charges 1 P CS_DAILY_CHARGES DEV
240 Room Class Maintenance 1 P ROOM_CLASS_MAN DEV, TST
260 L&ocation Maintenance 1 P COLD_STORAGE_MAN DEV, TST
280 Document Reprints 1 P DOCUMENT_REPRINT DEV, TST
300 Label Printing 1 P LABEL_PRINTING DEV, TST
320 Cold Storage Internal Movements 1 P CS_INT_MOVEMENTS_MAN DEV, TST
340 Cold Storage Agent Deposit - Amendments 1 P CS_AGDEP_AMD_MAN DEV, TST, CLD
360 Cold Storage Docket Reprints 1 P DOCKET_CS_REPRINTS DEV, CLD
370 Docket Reprints by Deposit no 1 G CS_DOC_REPRINTS_DEP DEV, CLD
380 Static Listing 1 P CS_STATIC_LISTING DEV, CLD, MKT