DMD_IU_DEF_INV

(SQL Table)
 Index Back

Interunit Trans Ownership Defn

GMG 02/1999 R-CJOHNS-0E8DU: Changes to peoplecode to handle InterCompany pair setup.

  • Parent Record Of DMD_CF_ACC2_TMP DMD_CF_ACC3_TMP DMD_CF_ACC4_TMP DMD_CF_ACC5_TMP DMD_CF_ACC6_TMP DMD_IU_ACC2_INV DMD_IU_ACC3_INV DMD_IU_ACC4_INV DMD_IU_ACC5_INV DMD_IU_ACC6_INV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BUIN_NONVW

    2 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

    Prompt Table: SP_BUIN_NONVW

    3 OWNERSHIP_BU Character(5) VARCHAR2(5) NOT NULL In-Transit Ownership Unit

    Prompt Table: SP_BUIN_NONVW

    4 AUTO_PUTAWAY_FLAG Character(1) VARCHAR2(1) NOT NULL Flag Items for Auto-Putaway

    Y/N Table Edit

    Default Value: N

    5 INTERCOMPANY_FLG Character(1) VARCHAR2(1) NOT NULL /* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/

    Y/N Table Edit

    Default Value: N

    6 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: CM_INTERUNIT_VW

    7 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

    Prompt Table: %EDITTABLE

    8 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: %EDITTABLE2

    9 ALLOW_ADDR_OVRRIDE Character(1) VARCHAR2(1) NOT NULL Allow Address Override

    Y/N Table Edit

    Default Value: N