Sales Order Cycle by nmf60775


More Info
									                                                                Interface Control Document (FUL-RPT-0016): Detail Field Mapping

                                                                           Required (R),
                                                                 State     Optional (O),
                                             Type      Length    Fields   Conditional, (C)      WBSCM xml Tags            ECOS xml Tags                                    Comments
                                                                                                                    Commodity-Code +
                                                                                                                    SDA-Code +
                                                                                                                    Delivery-Year +
 Sales Order Number                        CHAR         10         10                        SalesOrderNo           Order-Number                SAP Order Number
 Sold to                                   CHAR         10         7                         SoldToParty            SDA-Code                    State DA of the order.
 Sold to Description                       CHAR         40         40                        SoldToDesc                        N/A              Description text
                                                                                                                                                Ship to Warehouse - This is currently the PCIMS entity code.
 Ship to                                   CHAR         10         7                         ShipToParty            Entity-Code                 It represents the SHIP-To location.
 Ship to Description                       CHAR         40         40                        ShipToDesc                           N/A           Name of location identified in Ship-To
                                                                                                                                                WBSCM added field to identify the detail information of the
 Sales Order Line Item Number              NUMC         6          6                         SalesOrderitem                   N/A               order.
 Schedule line date                        CHAR         24         8                         ScheduleLineDt                   N/A                Requested date of delivery.
 Material Number                           CHAR         40         6                         MaterialNo             Commodity-Code              Material - this was the PCIMS 4 digit commodity code.
                                                                                                                    Commodity-Desc - From ND
 Material Description                      CHAR         40         40                        MaterialDesc           export                   Text description of the material

                                                                                                                                                Quantity will be defined as 10.3 with explicit decimal point.
                                                                                                                                                Sales Order qty will equal the total of the Requisition
                                                                                                                                                Quantities associated to each Line Item. The UOM for this
                                                                                                                                                amount will be the same as identified at the Requisition level.
                                                                                                                                                The UOM will be the Sales Unit of Measure for the Material
 Sales Order quantity                      QUAN         14         14                        OrderQty                             N/A           and can be found on the Material Sales Report.
                                                                                                                                                Use to associate non FTL sales orders together. Value is
                                                                                                                                                assigned during the Order Consolidation Process or can be
 Correlation ID                            CHAR         10         10                        CorrelationId                        N/A           uploaded through the Order Upload process.

 Destination City                          CHAR         40         40                        DestinationCity        Destination-City            City associated to Ship-To location

 Destination State                         CHAR          3         2                         DestinationState       Destination-State           State associated to Ship-To location
                                                                                                                    Standard-Rem1 +
                                                                                                                    Standard-Rem2 +
                                                                                                                    Standard-Rem3 +
                                                                                                                    Standard-Rem4 +
                                                                                                                    Standard-Rem5 +
 Remarks                                   unlimited            CHAR 75                      SORemarks              Free-Form-Rem               Additional remarks added to the Sales Order
                                                                                                                                                Will be the last average, actual or a Government cost
 Cost per pound                            CURR         12         12                        CostPerlb              Average-Cost-Per-Pound      estimate. 9.2 - SAP, explicit decimal point
 Purchase Order #                          CHAR         10         10                        PONumber               Notice-To-Delivery          Purchase Order created by the Procurement division
 Purchase Order Line item #                CHAR         5          5                         POLineNo                          N/A              Details of the PO are contained at the Line Item level

                                                                                                                                                Status code that identifies the Sales Order position within the
                                                                                                                                                procurement cycle.
 Status code of Sales Order                CHAR          4         4                         StatusCode             Status-Code                 Status codes can be found on FNS-WBSCM Information site.
                                                                                                                                                Status description to show the Sales Order status as it
 Status of Sales Order                     CHAR         20         20                        Status                               N/A           pertains to the ordering life cycle of WBSCM.

                                                                                                                                                Internal Order field will have entitlement or bonus indicator
 Entitlement or Bonus Identifier           CHAR          1         1                         EntitlementBonusFlag                 N/A           "B" or "E" to identify Bonus or Entitlement

8ea47654-376d-462d-9a15-74002b3ccc92.xls                                                              1/2                                                                                                8/1/2011
                                                                                                                5 digit program code the requisition is requesting the material.
                                                                                                                Program codes can be found on FNS-WBSCM Information
 Program Code                              CHAR        40   5    ProgramCode                  N/A               site.
 Program Description                       CHAR        40   40   ProgramDesc                  N/A               Text Description of the program
                                                                                                                SO/Line items value as to the Entitlement year affected.
                                                                                                                Format is YYYY.

                                                                                                                Entitlement Year contained is based on the ProgramCode and
                                                                                                                ScheduleLineDt tags.
                                                                                                                TEFAP:               Jan - Dec
                                                                                                                NSIP / SFSP:        Oct - Sep
                                                                                                                NSLP / CACFP: July - June
 Entitlement Year                           CHAR       4    4    EntitlementYear              N/A               CSFP / FDPIR: Jan - Dec
                                                                                                                Not applicable in WBSCM. This tag will remain but will be
 Program Year                               CHAR       4    4    ProgYear                       N/A             blank in all downloads.
 RA Identifier                             CHAR        60   40   raId              raIdentifier                 The states supplied RA Identifier
 RA Business Partner Identifier            CHAR        10   7    raBPId            Receipient-Agency-Id          This field is the WBSCM business partner number.
 Recipient Agency Name                     CHAR        40   40   RAName            Receipient-Agency-Name       Text description of the Recipient Agency
                                                                                                                Quantity expressed as 10.3 explicit decimal point.
                                                                                                                The total of the Requisition Quantities will equal the Sales
 Requisition Quantity                      QUAN        14   14   ReqQty            Requisition-Quantity         Order Quantity for the Line Item.
                                                                                                                Value will be CS for case or LB for pound.
                                                                                   Requisition-Quantity-Unit-   This UOM will also reflect the Uom for the Sales Order
 Requisition Quantity Unit of Measure      UNIT        3    3    ReqQtyUOM         Measure                      Quantity.
                                                                                                                Comments entered for the Sales Order Line Item.

                                                                                                                Function Modules can be used to store it. Its not stored in 1
                                                                                                                Table field but internally as a table cluster.

 Requisition Remarks                       Unlimited        75   ReqRemarks                   N/A               Requisition remarks from Quote.
 Requisition #                             CHAR        10   10   reqNo             Requistion-Line-Item         The initial requested entered at the Recipient level
 Requisition line item                     CHAR        5    3    ReqLineNo                    N/A               Line Item to identify the details of the requisition

8ea47654-376d-462d-9a15-74002b3ccc92.xls                                  2/2                                                                                          8/1/2011

To top