Table of Contents
- List of Examples
- List of Figures
- Title and Copyright Information
- Send Us Your Comments
- Preface
- 1 Introduction
-
2
RIB Publication Designs
- Allocations Publication API
-
ASNOUT Publication API
- Functional Area
- Business Overview
-
Package Impact
- Business Object ID
- Package name: RMSMFM_SHIPMENT
- Function Level Description - GETNXT
- Function Level Description - PUB_RETRY
- Function Level Description - PROCESS_QUEUE_RECORD (local)
- Function Level Description - BUILD_HEADER_OBJECT (local)
- Function Level Description - BUILD_DETAIL_OBJECTS (local)
- Function Level Description - LOCK_THE_BLOCK (local)
- Function Level Description - HANDLE_ERRORS (local)
- Function Level Description - UPDATE_QUEUE_REC (local)
- Trigger Impact
- Message XSD
- Design Assumptions
- Table Impact
- Available Inventory for Store and Warehouse Publication API
- Available Inventory for Store Publication API
- Banner Publication API
- Codes and Diff Types
- Company Closed Publication API
- Countries
- Customer Order Fulfillment Confirmation
- Delivery Slot Publication API
- Diff Group Publication API
- Differentiators Publication API
-
Item Publication API
- Functional Area
-
Business Overview
- Deposit items
- Catch-Weight Items
- Receiving and inventory movement impact on catch-weight items
- Item Transformation
- Item and Item Component Descriptions
- New Item Message Processes
- Basic Item Message
- New Item Message Publication
- Subordinate Data and XML Tags
- Modify and Delete Messages
- Modify Messages
- Delete messages
- Design Overview
- Business Object Records
-
Package Impact
- Business Object ID
- Package Specification - Global Variables
- Function Level Description - ADDTOQ
- Function Level Description - GETNXT
- Function Level Description - PUB_RETRY
- Function Level Description - PROCESS_QUEUE_RECORD (local)
- Function Level Description - MAKE_CREATE (local)
- Function Level Description - HANDLE_ERRORS (local)
- Function Level Description - BUILD_MESSAGE
- Function Level Description - BUILD_DELETE_MESSAGE
- Function Level Description - BUILD_HEADER_OBJECT (local)
- Function Level Description - BUILD DETAIL functions (all local)
- Function Level Description - GET_ITEM_INFO (local)
- Function Level Description - BUILD_DIMENSION_DESCRIPTIONS (local)
- Function Level Description - BUILD_ITEM_MASTER_CFA_EXT (local)
- Function Level Description - BUILD_ITEM_SUPPLIER_CFA_EXT (local)
- Function Level Description - BUILD_ITEM_SUPP_CTRY_CFA_EXT (local)
- Trigger Impact
- Message XSD
- Table Impact
- Design Assumptions
-
Item Location
- Functional Area
- Integration Type
- Business Overview
-
New Item Location Relationship
- Item/Location Description
- Item/Location Physical Location Details
- Item/Location Virtual Location Details
- Custom Flex Attributes
- Item/Location Virtual Location Replenishment Details
- Modified Item Location Relationship
- Deleted Item Location Relationship
- Item Replenishment Attributes
- Custom Flex Attributes
- Error Handling
- Message XSD
- Merchandise Hierarchy Publication API
- Organizational Hierarchy Publication API
-
Partner Publication API
- Functional Area
- Business Overview
-
Package Impact
- Function Level Description - ADDTOQ
- Function Level Description - PUB_RETRY
- Function Level Description - PROCESS_QUEUE_RECORD (local)
- Function Level Description - MAKE_CREATE (local)
- Function Level Description - BUILD_HEADER_OBJECT (local)
- Function Level Description - BUILD_HEADER_OBJECT (local)
- Function Level Description - BUILD_DETAIL_OBJECTS (local)
- Function Level Description - BUILD_SINGLE_DETAIL (local)
- Function Level Description - BUILD_DETAIL_CHANGE_OBJECTS (local)
- Function Level Description - BUILD_DETAIL_DELETE_OBJECTS (local)
- Function Level Description - LOCK_THE_BLOCK (local)
- Function Level Description - HANDLE_ERRORS (local)
- Function Level Description - DELETE_QUEUE_REC (local)
- Function Level Description – BUILD_PARTNER_CFA_EXT (local)
- Function Level Description - BUILD_ ADDR _CFA_EXT (local)
- Message XSD
- Design Assumptions
- Table Impact
- Purchase Orders
- Receiver Unit Adjustment Publication API
- RTV Request Publication API
- Seasons and Phases Publication API
-
Store Publication API
- Functional Area
- Business Overview
-
Package Impact
- Package Specification - Global Variables
- Public Type
- Function Level Description - ADDTOQ
- Function Level Description - GETNXT
- Function Level Description - PUB_RETRY
- Function Level Description - PROCESS_QUEUE_RECORD (local)
- Function Level Description - MAKE_CREATE (local)
- Function Level Description - BUILD_HEADER_OBJECT (local)
- Function Level Description - BUILD_DETAIL_OBJECTS (local)
- Function Level Description - BUILD_SINGLE_DETAIL (local)
- Function Level Description - BUILD_DETAIL_CHANGE_OBJECTS (local)
- Function Level Description - BUILD_DETAIL_DELETE_OBJECTS (local)
- Function Level Description - LOCK_THE_BLOCK (local)
- Function Level Description - HANDLE_ERRORS (local)
- Function Level Description - BUILD_STORE_CFA_EXT (local)
- Function Level Description - BUILD_ ADDR _CFA_EXT (local)
- Function Level Description - BUILD_STORE_HOURS_OBJECT (local)
- Message XSD
- Table Impact
- Design Assumptions
- Transfers Publication API
- UDA Publication API
- Vendor Publication API
-
Warehouse Publication API
- Functional Area
- Business Overview
-
Package Impact
- Function Level Description - ADDTOQ
- Function Level Description - GETNXT
- Function Level Description - PUB_RETRY
- Function Level Description - PROCESS_QUEUE_RECORD (local)
- Function Level Description - DELETE_QUEUE_REC (local)
- Function Level Description - MAKE_CREATE (local)
- Function Level Description - BUILD_HEADER_OBJECT (local)
- Function Level Description - BUILD_HEADER_OBJECT (local)
- Function Level Description - BUILD_DETAIL_OBJECTS (local)
- Function Level Description - BUILD_SINGLE_DETAIL (local)
- Function Level Description - BUILD_DETAIL_CHANGE_OBJECTS (local)
- Function Level Description - BUILD_DETAIL_DELETE_OBJECTS (local)
- Function Level Description - LOCK_THE_BLOCK (local)
- Function Level Description - HANDLE_ERRORS (local)
- Function Level Description - BUILD_WH_CFA_EXT (local)
- Function Level Description - BUILD_ ADDR _CFA_EXT (local)
- Message XSD
- Design Assumptions
- Table Impact
- Work Orders In Publication API
- Work Orders Out Publication API
-
3
RIB Subscription Designs
- Allocation Subscription API
- Appointments Subscription API
- ASNIN Subscription API
- COGS Subscription API
- Cost Change Subscription
- Currency Exchange Rates Subscription API
- Customer Order Fulfillment Subscription API
- Diff Group Subscription API
- Differentiator Subscription API
- Direct Ship Receipt Subscription API
- DSD Deals Subscription API
- DSD Receipt Subscription API
- Freight Terms Subscription API
- GL Chart of Accounts Subscription API
- GL Chart of Account Validation Service
- Inventory Adjustment Subscription API
- Inventory Request Subscription API
- Item Subscription API
- Item Location Subscription API
- Item Reclassification Subscription API
- Location Trait Subscription API
-
Merchandise Hierarchy Subscription API
- Functional Area
- Integration Type
- Business Overview
- Creating a Company
- Updating a Company
- Creating Divisions
- Updating Divisions
- Deleting Divisions
- Creating Groups
- Updating Groups
- Deleting Groups
- Creating Departments
- Updating Departments
- Deleting Departments
- Creating VAT Information for Departments
- Updating VAT Information for Departments
- Creating Up-charges for Departments
- Updating Up-charges for Departments
- Deleting Up-charges for Departments
- Creating Classes
- Updating Classes
- Deleting Classes
- Creating Subclasses
- Updating Subclasses
- Deleting Subclasses
- Error Handling
- Message XSD
- Merchandise Hierarchy Reclassification Subscription API
- Organizational Hierarchy Subscription API
- Outbound ASNs
- Payment Terms Subscription API
-
PO Subscription API
- Functional Area
- Integration Type
- Business Overview
- Creating Purchase Orders
- Updating Purchase Orders
- Deleting Purchase Orders
- Creating a Purchase Order Letter of Credit
- Updating a Purchase Order Letter of Credit
- Deleting a Purchase Order Letter of Credit
- Creating Expenses
- Updating Expenses
- Deleting Expenses
- Creating HTS and Assessments
- Updating HTS and Assessments
- Deleting HTS and Assessments
- Publishing Updates
- Flex Attributes
- Error Handling
- Message XSD
- Receiving Subscription API
- RTV Subscription API
- Stock Order Status Subscription API
- Stock Count Schedule Subscription API
- Store Subscription API
- Transfer Subscription API
- Vendor Subscription API
- Work Order Status Subscription API
-
4
SOAP Web Services
- Using SOAP Services During Batch Window
- Common Characteristics of Merchandising SOAP Services
-
Provider Services
- Allocation Service
- Average Cost Service
- Cost Change Service
- Customer Credit Check Service
- Customer Order Fulfillment Service
- Customer Order Item Substitution Service
- Diff Management Service
- Inventory Back Order Service
- Inventory Lookup Service
- Item Management Service
- Pay Term Service
- Pricing Cost Service
- Purchase Order Management Service
- Report Locator Service
- Store Order Service
- Supplier Service
- Transfer Service
- Consumer Services
-
5
ReSTful Web Services
- Introduction
- Common Characteristics
-
Merchandising ReSTful Web Services
- Merchandising Common Services
- Book Transfer ReSTful Web Service
- Code Detail Service
- Create Inventory Transfer Services
- Create Purchase Order Services
- Recent Inventory Transfer Services
-
Recent Purchase Order Services
- Functional Area
- Business Overview
- Cancel Reason Code List
- Origin Code List
- Purchase Order Status List
- Search Purchase Order User ID
- Purchase Order Search
- Get Purchase Order Summary
- Get Purchase Order Items
- Get Purchase Order Item Locations
- Update Purchase Orders Date
- Cancel Purchase Orders
- Approve Purchase Orders
- Reject Purchase Orders
- Replenishment Schedule Services
- Allocation Detail Service
- Background Process Configuration
- Currency Rates Service
- Data Privacy Access Service
- Data Privacy Forget Service
- Diff Detail Service
- EOW Run Signal Service
- Half Data Budget Service
- Inventory Adjustment Service
- Item Detail Service
- Item Loc Inventory Detail Service
- MerchHierarchy Detail Service
- Obligations Upload Services
- Purchase Order Detail Service
- Reclass Detail Service
- Shipment Detail Service
- Stock Count Detail Service
- Store Day User Service
- Store Detail Service
- Supplier Detail Service
- Transfer Detail Service
- VAT Detail Service
- Warehouse Detail Service
- Sales Audit ReSTful Web Services
-
6
Scheduled Integration
- File-based Integration Overview
- Bulk Data Integration Overview
-
Outbound Scheduled Integration
-
Foundation Data
- Brand Publication API (BDI_Brand_Fnd_PF_From_RMS_EOW_JOB)
- Calendar Publication API (BDI_Calendar_Fnd_PF_From_RMS_EOW_JOB)
- Code Detail Publication API (BDI_CodeDetail_Fnd_PF_From_RMS_JOB)
- Code Head Publication API (BDI_CodeHead_Fnd_PF_From_RMS_JOB)
- Company-wide Closings and Company Closed Exceptions (BDI_CompanyClosed_Fnd_PF_From_RMS_JOB)
- Currency Conversion Rates Publication API (BDI_CurrConvRates_Fnd_PF_From_RMS_EOW_JOB)
- Delivery Slot Publication API (BDI_DeliverySlot_Fnd_PF_From_RMS_JOB)
- Diff Group Export (export_diffgrp.ksh)
- Diff Group Publication API (BDI_DiffGrp_Fnd_PF_From_RMS_JOB)
- Diff ID and Type Export (export_diffs.ksh)
- Diff ID Publication API (BDI_Diff_Fnd_PF_From_RMS_JOB)
- Finisher Address Publication API (BDI_FinisherAddr_Fnd_PF_From_RMS_JOB)
- Location Closed Publication API (BDI_LocClosed_Fnd_PF_From_RMS_JOB)
- Merch Hierarchy Publication API (BDI_MerchHier_Fnd_PF_From_RMS_JOB)
- Merchandise Hierarchy Export (export_merchhier.ksh)
- Organization Hierarchy Publication API (BDI_OrgHier_Fnd_PF_From_RMS_JOB)
- Organizational Hierarchy Export (export_orghier.ksh)
- Partner Address Publication API (BDI_PartnerAddr_Fnd_PF_From_RMS_JOB)
- Partner Org Unit Publication API (BDI_PartOrgUnit_Fnd_PF_From_RMS_JOB)
- Partner Publication API (BDI_Partner_Fnd_PF_From_RMS_JOB)
- Store Address Publication API (BDI_StoreAddr_Fnd_PF_From_RMS_JOB)
- Store Hours Publication API (BDI_StoreHours_Fnd_PF_From_RMS_JOB)
- Store Publication API (BDI_Store_Fnd_PF_From_RMS_JOB)
- Stores Export (export_stores.ksh)
- Supplier Address Publication API (BDI_SupplierAddr_Fnd_PF_From_RMS_JOB)
- Sups Publication API (BDI_Supplier_Fnd_PF_From_RMS_JOB)
- Tax Download - Brazil (taxdnld)
- Ticket Download (tcktdnld)
- UDA Publication API (BDI_Uda_Fnd_PF_From_RMS_JOB)
- UDA Values Publication API (BDI_UdaValues_Fnd_PF_From_RMS_JOB)
- UOM Class Publication API (BDI_UomClass_Fnd_PF_From_RMS_JOB)
- UOM Conversion Publication API (BDI_UomConversion_Fnd_PF_From_RMS_JOB)
- VAT Codes, Regions, and Rates Export (export_vat.ksh)
- VAT Publication API (BDI_Vat_Fnd_PF_From_RMS_JOB)
- Warehouse (BDI_Wh_Fnd_PF_From_RMS_JOB)
- Warehouse Address Publication API (BDI_WhAddr_Fnd_PF_From_RMS_JOB)
-
Items
- Item Image Publication API (BDI_ItemImage_Fnd_PF_From_RMS_JOB)
- Item Location Export (export_itemloc.ksh)
- Item Location Publication API (BDI_ItemLoc_Fnd_PF_From_RMS_JOB)
- Item Master Export (export_itemmaster.ksh)
- Item Master Publication API (BDI_ItemHdr_Fnd_PF_From_RMS_JOB)
- Item Supplier Country Dimensions Publication API (BDI_ItSupCtryDim_Fnd_PF_From_RMS_JOB)
- Item Supplier Country Publication API (BDI_ItSupCtry_Fnd_PF_From_RMS_JOB)
- Item Supplier Manufacturing Country Publication API (BDI_ItSupManCtry_Fnd_PF_From_RMS_JOB)
- Item Supplier Publication API (BDI_ItemSupp_Fnd_PF_From_RMS_JOB)
- Item Supplier UOM Publication API (BDI_ItemSuppUom_Fnd_PF_From_RMS_JOB)
- Item VAT Rates Export (export_itemvat.ksh)
- Pack Item Publication API (BDI_PckitemBrkout_Fnd_PF_From_RMS_JOB)
- POS Configuration Data to 3rd Party POS (poscdnld)
- Price History Publication API (BDI_PriceHist_Fnd_PF_From_RMS_JOB)
- Related Items Export (export_relitem.ksh)
- Related Item Publication API (BDI_RelatedItem_Fnd_PF_From_RMS_JOB)
- UDA Item Date Publication API (BDI_UdaItemDate_Fnd_PF_From_RMS_JOB)
- UDA Item FF Publication API (BDI_UdaItemFF_Fnd_PF_From_RMS_JOB)
- UDA Item LOV Publication API (BDI_UdaItemLov_Fnd_From_RMS_JOB)
-
Financials
- Daily or Weekly Donwload of Stock Ledger Data (stlgdnld)
- Finance General Ledger to RFI (BDI_RFI_FinGenLdgr_Tx_PF_From_RMS_JOB)
- Fixed Deal Income (dealfinc)
- Franchise Billing Extract (wfbillex.ksh)
- Item/Location Daily Stock Ledger Transactions (fifgldn1)
- Monthly Stock Ledger Transactions (fifgldn3)
- Open to Buy Download Stock Ledger (otbdlsal)
- Rolled Up Daily Stock Ledger Transactions (fifgldn2)
- Stage G/L Extracts (gl_extract.ksh)
- Tran Data Publication (BDI_TranData_Tx_PF_From_RMS_EOW_JOB)
-
Ordering and Inventory
-
Purchasing
- Download Contracts to Suppliers (edidlcon)
- Download Current & Future OTB by Subclass (otbdnld)
- Download Purchase Orders to Suppliers (edidlord)
- Download Summary of Outstanding Orders on OTB by Subclass (otbdlord)
- On Order Publication API (BDI_OnOrder_Tx_PF_From_RMS_EOW_JOB)
- Replenishment Item Location Publication API (BDI_ReplItemLoc_Fnd_PF_From_RMS_JOB)
- Import Management
- Invoices
-
Inventory
- Download Sales and Stock on Hand to Suppliers (edidlprd)
- Future Available Inventory Publication API (BDI_COFutureAvail_Tx_PF_From_RMS_JOB)
- Inventory Publication API (BDI_Inventory_Tx_PF_From_RMS_EOW_JOB)
- Item Location History (BDI_ItemLocHist_Tx_PF_From_RMS_JOB)
- Reject POSU Transactions (salesgenrej.ksh)
- Store Available Inventory Publication API (BDI_InvAvailStore_Tx_PF_From_RMS_JOB)
- Warehouse Inventory Publication API (BDI_InvAvailWh_Tx_PF_From_RMS_JOB)
-
Purchasing
-
Planning and Forecasting
- Brand Extract to Planning (BDI_RPAS_Brand_Fnd_PF_From_RMS_JOB)
- Calendar Extract to Planning and Forecasting (BDI_RPAS_Calendar_Fnd_PF_From_RMS_JOB)
- Currency Rates Extract to Planning and Forecasting (BDI_RPAS_CurrConvRates_Fnd_PF_From_RMS_JOB)
- Differentiator Extract to Planning (BDI_RPAS_Diff_Fnd_PF_From_RMS_JOB)
- Inventory Extract to Planning (BDI_MFP_Inventory_Tx_PF_From_RMS_JOB)
- Merchandise Hierarchy and Item Extract to Planning and Forecasting (BDI_RPAS_MerchHier_Fnd_PF_From_RMS_JOB)
- On Order Extract to Planning (BDI_MFP_OnOrder_Tx_PF_From_RMS_JOB)
- Organization Hierarchy Extract to Planning and Forecasting (BDI_RPAS_OrgHier_Fnd_PF_From_RMS_JOB)
- Out of Stock Extract to Forecasting (BDI_RDF_StockOut_Tx_PF_From_RMS_JOB)
- Store Extract to Planning and Forecasting (BDI_RPAS_Store_Fnd_PF_From_RMS_JOB)
- Supplier Extract to Planning (BDI_RPAS_Supplier_Fnd_PF_From_RMS_JOB)
- Transaction Data Extract to Planning (BDI_MFP_TranData_Tx_PF_From_RMS_JOB)
- UDA Extract to Planning (BDI_RPAS_UdaAndUdaValues_Fnd_PF_From_RMS_JOB)
- UDA Item Extract to Planning and Forecasting (BDI_RDF_UdaItemLov_Fnd_From_RMS_JOB)
- Weekly Sales Extract to Forecasting (BDI_RDF_WeeklySales_Tx_PF_From_RMS_JOB)
-
Sales Audit
- Download from Sales Audit to Account Clearing House (ACH) System (saexpach)
- Download of Escheated Vouchers from Sales Audit for Payment (saescheat)
- Export DSD and Escheatment from Sales Audit to Invoice Matching (saexpim)
-
Export from Sales Audit to Oracle Retail Insights (saexpdw)
- Schedule
- Design Overview
- Restart/Recovery
-
I/O Specification
- Sales Audit - File Layout - Retail Analytics
- RDWT File
- Transaction Item Information Produced by saexpdw.pc after Translation by resa2dw
- RDWF File
- Retail Analytics Form of Payment File after Translation by resa2dw
- RDWS File
- Store Totals Information after Translation by resa2dw
- RDWC File
- Cashier/ Register Totals Information after Translation by resa2dw
- Design Assumptions
- Export Inventory Reservation/Release for In Store Customer Order & Layaway Transactions (saordinvexp)
- Export of POS transactions from Sales Audit to Merchandising (saexprms)
- Export of Revised Sale/Return Transactions from ReSA to SIM/SIOCS (saexpsim)
- Export to Universal Account Reconciliation System from Sales Audit (saexpuar)
- Extract of POS Transactions by Store/Date from Sales Audit for Web Search (ang_saplgen)
- Post User Defined Totals from Sales Audit to General Ledger (saexpgl)
-
Foundation Data
-
Inbound Scheduled Integration
- Item, Cost, and Price
-
Ordering and Inventory
- Purchasing
-
Import Management
- Harmonized Tariff Schedule Upload (htsupld)
- Letter of Credit Confirmation Upload (lcupld)
- Letter of Credit Drawdowns and Charges Upload (lcup798)
- SWIFT File Conversion - Letter of Credit Confirmation (lcmt730)
- SWIFT File Conversion - Letter of Credit Drawdowns and Charges (lcmt798)
- Transportation Upload (tranupld)
- Stock Counts
- Franchise
- Other Inventory
-
Sales Processing
- Sales Audit
- Sales Posting
- Forecasting