REM ======================================================================
REM ===   Sql Script for Database : Hutzler/Oracle db
REM ===
REM === Build : 301
REM ======================================================================

CREATE TABLE I_Shipper
  (
    I_Shipper_ID              NUMBER(10,0)      NOT NULL,
    M_Shipper_ID              NUMBER(10,0),
    AD_Client_Value           NVARCHAR2(40),
    AD_Client_ID              NUMBER(10,0)      NOT NULL,
    AD_Org_Value              NVARCHAR2(40),
    AD_Org_ID                 NUMBER(10,0)      NOT NULL,
    IsActive_Value            NVARCHAR2(40),
    IsActive                  CHAR(1)           DEFAULT 'Y' NOT NULL,
    Created                   DATE              DEFAULT SYSDATE NOT NULL,
    CreatedBy                 NUMBER(10,0)      NOT NULL,
    Updated                   DATE              DEFAULT SYSDATE NOT NULL,
    UpdatedBy                 NUMBER(10,0)      NOT NULL,
    Value                     NVARCHAR2(40),
    Name                      NVARCHAR2(60),
    Description               NVARCHAR2(255),
    I_IsImported              CHAR(1)           DEFAULT 'N' NOT NULL,
    I_ErrorMsg                NVARCHAR2(2000),
    Processing                CHAR(1),
    Processed                 CHAR(1)           DEFAULT 'N' NOT NULL,
    C_BPartner_Value          NVARCHAR2(40),
    C_BPartner_ID             NUMBER(10,0),
    TrackingURL               NVARCHAR2(120),
    Phone                     NVARCHAR2(40),
    PrintBillOfLadding_Value  NVARCHAR2(40),
    PrintBillOfLadding        CHAR(1),
    PrintCartoonLabels_Value  NVARCHAR2(40),
    PrintCartoonLabels        CHAR(1),
    primary key(I_Shipper_ID),
    CHECK(IsActive IN ('Y', 'N')),
    CHECK(I_IsImported IN ('Y', 'N')),
    CHECK(Processed IN ('Y', 'N')),
    CHECK(PrintBillOfLadding IN ('Y', 'N')),
    CHECK(PrintCartoonLabels IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE I_ImpFormat
  (
    I_ImpFormat_ID      NUMBER(10,0)      NOT NULL,
    AD_ImpFormat_ID     NUMBER(10,0),
    AD_Client_Value     NVARCHAR2(40),
    AD_Client_ID        NUMBER(10,0)      NOT NULL,
    AD_Org_Value        NVARCHAR2(40),
    AD_Org_ID           NUMBER(10,0),
    IsActive            CHAR(1)           DEFAULT 'Y' NOT NULL,
    Created             DATE              DEFAULT SYSDATE NOT NULL,
    CreatedBy           NUMBER(10,0)      NOT NULL,
    Updated             DATE              DEFAULT SYSDATE NOT NULL,
    UpdatedBy           NUMBER(10,0)      NOT NULL,
    Name                NVARCHAR2(60),
    Description         NVARCHAR2(255),
    AD_Table_TableName  NVARCHAR2(40),
    AD_Table_ID         NUMBER(10,0),
    FormatType_Value    NVARCHAR2(60),
    FormatType          CHAR(1),
    I_IsImported        CHAR(1)           DEFAULT 'N' NOT NULL,
    I_ErrorMsg          NVARCHAR2(2000),
    Processing          CHAR(1),
    Processed           CHAR(1)           DEFAULT 'N',
    primary key(I_ImpFormat_ID),
    CHECK(IsActive IN ('Y', 'N')),
    CHECK(I_IsImported IN ('Y', 'N')),
    CHECK(Processed IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE I_ImpFormat_Row
  (
    I_ImpFormat_Row_ID    NUMBER(10,0)      NOT NULL,
    AD_ImpFormat_Row_ID   NUMBER(10,0),
    AD_Client_Value       NVARCHAR2(40),
    AD_Client_ID          NUMBER(10,0)      NOT NULL,
    AD_Org_Value          NVARCHAR2(40),
    AD_Org_ID             NUMBER(10,0),
    IsActive              CHAR(1)           DEFAULT 'Y' NOT NULL,
    Created               DATE              DEFAULT SYSDATE NOT NULL,
    CreatedBy             NUMBER(10,0)      NOT NULL,
    Updated               DATE              DEFAULT SYSDATE NOT NULL,
    UpdatedBy             NUMBER(10,0)      NOT NULL,
    AD_ImpFormat_Name     NVARCHAR2(60),
    AD_ImpFormat_ID       NUMBER(10,0),
    SeqNo                 NUMBER(22),
    Name                  NVARCHAR2(60),
    AD_Column_ColumnName  NVARCHAR2(60),
    AD_Column_ID          NUMBER(10,0),
    StartNo               NUMBER(10,0),
    EndNo                 NUMBER(10,0),
    DataType_Value        NVARCHAR2(40),
    DataType              CHAR(1)           DEFAULT 'S' NOT NULL,
    DataFormat            NVARCHAR2(20),
    DecimalPoint          CHAR(1)           DEFAULT '.' NOT NULL,
    DivideBy100_Value     NVARCHAR2(20),
    DivideBy100           CHAR(1)           DEFAULT 'N' NOT NULL,
    ConstantValue         NVARCHAR2(60),
    Callout               NVARCHAR2(60),
    Script                NVARCHAR2(2000),
    I_IsImported          CHAR(1)           DEFAULT 'N' NOT NULL,
    I_ErrorMsg            NVARCHAR2(2000),
    Processing            CHAR(1),
    Processed             CHAR(1)           DEFAULT 'N',
    primary key(I_ImpFormat_Row_ID),
    CHECK(IsActive IN ('Y', 'N')),
    CHECK(I_IsImported IN ('Y', 'N')),
    CHECK(Processed IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE SlidingTable
  (
    SlidingTable_ID  NUMBER(10,0)     NOT NULL,
    AD_Client_ID     NUMBER(10,0)     NOT NULL,
    AD_Org_ID        NUMBER(10,0)     NOT NULL,
    IsActive         CHAR(1)          DEFAULT 'Y' NOT NULL,
    Created          DATE             DEFAULT SYSDATE NOT NULL,
    CreatedBy        NUMBER(10,0)     NOT NULL,
    Updated          DATE             DEFAULT SYSDATE NOT NULL,
    UpdatedBy        NUMBER(10,0)     NOT NULL,
    Name             NVARCHAR2(60)    NOT NULL,
    Description      NVARCHAR2(255),
    Processed        CHAR(1),
    primary key(SlidingTable_ID),
    CHECK(IsActive IN ('Y', 'N')),
    CHECK(Processed IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE SlidingRule
  (
    SlidingRule_ID   NUMBER(10,0)   NOT NULL,
    AD_Client_ID     NUMBER(10,0)   NOT NULL,
    AD_Org_ID        NUMBER(10,0)   NOT NULL,
    IsActive         CHAR(1)        DEFAULT 'Y' NOT NULL,
    Created          DATE           DEFAULT SYSDATE NOT NULL,
    CreatedBy        NUMBER(10,0)   NOT NULL,
    Updated          DATE           DEFAULT SYSDATE NOT NULL,
    UpdatedBy        NUMBER(10,0)   NOT NULL,
    SlidingTable_ID  NUMBER(10,0),
    StartRange       NUMBER,
    EndRange         NUMBER,
    Commission       NUMBER,
    Processed        CHAR(1),
    primary key(SlidingRule_ID),
    CHECK(IsActive IN ('Y', 'N')),
    CHECK(Processed IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE I_PrintFormat
  (
    I_PrintFormat_ID          NUMBER(10,0)      NOT NULL,
    AD_PrintFormat_ID         NUMBER(10,0),
    AD_Client_Value           NVARCHAR2(40),
    AD_Client_ID              NUMBER(10,0)      NOT NULL,
    AD_Org_Value              NVARCHAR2(40),
    AD_Org_ID                 NUMBER(10,0)      NOT NULL,
    IsActive                  CHAR(1)           DEFAULT 'Y' NOT NULL,
    Created                   DATE              DEFAULT SYSDATE NOT NULL,
    CreatedBy                 NUMBER(10,0)      NOT NULL,
    Updated                   DATE              DEFAULT SYSDATE NOT NULL,
    UpdatedBy                 NUMBER(10,0)      NOT NULL,
    Name                      NVARCHAR2(60),
    Description               NVARCHAR2(255),
    I_IsImported              CHAR(1)           DEFAULT 'N' NOT NULL,
    I_ErrorMsg                NVARCHAR2(2000),
    Processing                CHAR(1),
    Processed                 CHAR(1)           DEFAULT 'N' NOT NULL,
    PrinterName               NVARCHAR2(40),
    AD_ReportView_ID          NUMBER(10,0),
    AD_ReportView_Name        NVARCHAR2(60),
    AD_Table_ID               NUMBER(10,0),
    AD_Table_TableName        NVARCHAR2(40),
    AD_PrintPaper_ID          NUMBER(10,0),
    AD_PrintPaper_Name        NVARCHAR2(60),
    AD_PrintColor_ID          NUMBER(10,0),
    AD_PrintColor_Name        NVARCHAR2(60),
    AD_PrintFont_ID           NUMBER(10,0),
    AD_PrintFont_Name         NVARCHAR2(60),
    HeaderMargin              NUMBER(10),
    FooterMargin              NUMBER(10),
    AD_PrintTableFormat_ID    NUMBER(10,0),
    AD_PrintTableFormat_Name  NVARCHAR2(60),
    IsDefault                 CHAR(1),
    IsForm                    CHAR(1),
    IsStandardHeaderFooter    CHAR(1)           DEFAULT 'Y',
    IsTableBased              CHAR(1)           DEFAULT 'Y',
    primary key(I_PrintFormat_ID),
    CHECK(IsActive IN ('Y', 'N')),
    CHECK(I_IsImported IN ('Y', 'N')),
    CHECK(Processed IN ('Y', 'N')),
    CHECK(IsDefault IN ('Y', 'N')),
    CHECK(IsForm IN ('Y', 'N')),
    CHECK(IsStandardHeaderFooter IN ('Y', 'N')),
    CHECK(IsTableBased IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE I_PrintFormatItem
  (
    I_PrintFormatItem_ID      NUMBER(10,0)      NOT NULL,
    AD_PrintFormatItem_ID     NUMBER(10,0),
    AD_Client_Value           NVARCHAR2(40),
    AD_Client_ID              NUMBER(10,0)      NOT NULL,
    AD_Org_Value              NVARCHAR2(40),
    AD_Org_ID                 NUMBER(10,0)      NOT NULL,
    IsActive                  CHAR(1)           DEFAULT 'Y' NOT NULL,
    Created                   DATE              DEFAULT SYSDATE NOT NULL,
    CreatedBy                 NUMBER(10,0)      NOT NULL,
    Updated                   DATE              DEFAULT SYSDATE NOT NULL,
    UpdatedBy                 NUMBER(10,0)      NOT NULL,
    Name                      NVARCHAR2(60),
    I_IsImported              CHAR(1)           DEFAULT 'N' NOT NULL,
    I_ErrorMsg                NVARCHAR2(2000),
    Processing                CHAR(1),
    Processed                 CHAR(1)           DEFAULT 'N' NOT NULL,
    AD_PrintFormat_ID         NUMBER(10,0),
    AD_PrintFormat_Name       NVARCHAR2(60),
    PrintName                 NVARCHAR2(2000),
    PrintNameSuffix           NVARCHAR2(60),
    PrintAreaType             CHAR(1),
    PrintAreaType_Name        NVARCHAR2(60),
    SeqNo                     NUMBER(10),
    PrintFormatType           CHAR(1),
    PrintFormatType_Name      NVARCHAR2(60),
    AD_Column_ID              NUMBER(10,0),
    AD_Column_ColumnName      NVARCHAR2(40),
    AD_PrintFormatChild_ID    NUMBER(10,0),
    AD_PrintFormatChild_Name  NVARCHAR2(60),
    AD_PrintGraph_ID          NUMBER(10,0),
    AD_PrintGraph_Name        NVARCHAR2(60),
    BelowColumn               NUMBER(22),
    Xspace                    NUMBER(22),
    Yspace                    NUMBER(22),
    Xposition                 NUMBER(22),
    Yposition                 NUMBER(22),
    MaxWidth                  NUMBER(22),
    MaxHeight                 NUMBER(22),
    FieldAlignmentType        CHAR(1)           DEFAULT 'D',
    LineAlignmentType         CHAR(1)           DEFAULT 'X',
    AD_PrintColor_ID          NUMBER(10,0),
    AD_PrintColor_Name        NVARCHAR2(60),
    AD_PrintFont_ID           NUMBER(10,0),
    AD_PrintFont_Name         NVARCHAR2(60),
    SortNo                    NUMBER(22),
    RunningTotalLines         NUMBER(22),
    ImageURL                  NVARCHAR2(120),
    IsFilledRectangle         CHAR(1)           DEFAULT 'N',
    LineWidth                 NUMBER(22)        DEFAULT 1,
    ArcDiameter               NUMBER(22)        DEFAULT 0,
    ShapeType                 CHAR(1),
    primary key(I_PrintFormatItem_ID),
    CHECK(IsActive IN ('Y', 'N')),
    CHECK(I_IsImported IN ('Y', 'N')),
    CHECK(Processed IN ('Y', 'N')),
    CHECK(IsFilledRectangle IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE C_BPartner
  (
    IsBackOrderAllowed  CHAR(1),
    DateLastOrder       DATE,
    SendPostalMail      CHAR(1),
    ShippingComment     NVARCHAR2(255),
    PO_FlatDiscount     NUMBER,
    C_PaymentTerm_ID    NUMBER(10,0),
    FreightCostRule     CHAR(1),
    M_Shipper_ID        NUMBER(10,0),
    CHECK(IsBackOrderAllowed IN ('Y', 'N')),
    CHECK(SendPostalMail IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE C_BPartner_Location
  (
    AreaPhoneCode    NVARCHAR2(40),
    FreightCostRule  CHAR(1),
    ShippingComment  NVARCHAR2(40),
    Value            NVARCHAR2(40),
    M_Shipper_ID     NUMBER(10,0)
  );

REM ======================================================================

CREATE TABLE M_Shipper
  (
    Value               NVARCHAR2(40),
    Phone               NVARCHAR2(40),
    PrintBillOfLadding  CHAR(1),
    PrintCartoonLabels  CHAR(1),
    CHECK(PrintBillOfLadding IN ('Y', 'N')),
    CHECK(PrintCartoonLabels IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE I_BPartner
  (
    IsActive_Value             NVARCHAR2(40),
    AD_Org_Value               NVARCHAR2(40),
    Address3                   NVARCHAR2(60),
    AreaPhoneCode              NVARCHAR2(40),
    IsBackOrderAllowed_Value   NVARCHAR2(40),
    IsBackOrderAllowed         CHAR(1),
    C_PaymentTerm_Value        NVARCHAR2(40),
    C_PaymentTerm_ID           NUMBER(10,0),
    SO_CreditLimit             NUMBER,
    DateLastOrder              DATE,
    CarrierCode                NVARCHAR2(40),
    FreightCode                NVARCHAR2(40),
    ShippingComment            NVARCHAR2(40),
    IsVendor_Value             NVARCHAR2(40),
    IsVendor                   CHAR(1),
    IsCustomer_Value           NVARCHAR2(40),
    IsCustomer                 CHAR(1),
    IsEmployee_Value           NVARCHAR2(40),
    IsEmployee                 CHAR(1),
    V_Liability_Acct_Value     NVARCHAR2(40),
    V_Liability_Acct           NUMBER(10,0),
    PO_FlatDiscount            NUMBER,
    C_BPartner_Location_Name   NVARCHAR2(60),
    IsBillTo_Value             NVARCHAR2(40),
    IsBillTo                   CHAR(1),
    IsShipTo_Value             NVARCHAR2(40),
    IsShipTo                   CHAR(1),
    IsPayFrom_Value            NVARCHAR2(40),
    IsPayFrom                  CHAR(1),
    IsRemitTo_Value            NVARCHAR2(40),
    IsRemitTo                  CHAR(1),
    FreightCode                NVARCHAR2(40),
    IsSummary_Value            NVARCHAR2(40),
    IsSummary                  CHAR(1),
    InvoiceRule_Value          NVARCHAR2(40),
    InvoiceRule                CHAR(1),
    DeliveryRule_Value         NVARCHAR2(40),
    DeliveryRule               CHAR(1),
    PaymentRule_Value          NVARCHAR2(40),
    PaymentRule                CHAR(1),
    SO_Description             NVARCHAR2(255),
    IsTaxExempt_Value          NVARCHAR2(40),
    IsTaxExempt                CHAR(1),
    SendPostalMail_Value       NVARCHAR2(40),
    SendPostalMail             CHAR(1),
    IsProspect                 CHAR(1),
    IsProspect_Value           NVARCHAR2(40),
    Invoice_PrintFormat_Value  NVARCHAR2(40),
    Invoice_PrintFormat_ID     NUMBER(10,0),
    M_PriceList_Value          NVARCHAR2(40),
    M_PriceList_ID             NUMBER(10,0),
    M_DiscountSchema_Value     NVARCHAR2(40),
    M_DiscountSchema_ID        NUMBER(10,0),
    PaymentRulePO_Value        NVARCHAR2(40),
    PaymentRulePO              CHAR(1),
    FlatDiscount               NUMBER,
    C_PaymentTerm_Name         NVARCHAR2(60),
    SalesRep_Value             NVARCHAR2(40),
    IsSalesRep                 CHAR(1)          DEFAULT 'N',
    C_BPartner_Location_Value  NVARCHAR2(40),
    SalesRep_ID                NUMBER(10,0),
    C_AcctSchema_Name          NVARCHAR2(60),
    C_AcctSchema_ID            NUMBER(10,0),
    Account_ID                 NUMBER(10,0),
    DeliveryViaRule            CHAR(1),
    M_Shipper_ID               NUMBER(10,0),
    CHECK(IsBackOrderAllowed IN ('Y', 'N')),
    CHECK(IsVendor IN ('Y', 'N')),
    CHECK(IsCustomer IN ('Y', 'N')),
    CHECK(IsEmployee IN ('Y', 'N')),
    CHECK(IsBillTo IN ('Y', 'N')),
    CHECK(IsShipTo IN ('Y', 'N')),
    CHECK(IsPayFrom IN ('Y', 'N')),
    CHECK(IsRemitTo IN ('Y', 'N')),
    CHECK(IsSummary IN ('Y', 'N')),
    CHECK(IsTaxExempt IN ('Y', 'N')),
    CHECK(SendPostalMail IN ('Y', 'N')),
    CHECK(IsProspect IN ('Y', 'N')),
    CHECK(IsSalesRep IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE I_Order
  (
    IsActive_Value             NVARCHAR2(40),
    AD_Org_Value               NVARCHAR2(40),
    IsSOTrx_Value              NVARCHAR2(40),
    POReference                NVARCHAR2(20),
    M_Shipper_Value            NVARCHAR2(40),
    DeliveryViaRule_Value      NVARCHAR2(40),
    DeliveryViaRule            CHAR(1),
    DatePromised               DATE,
    C_PaymentTerm_Name         NVARCHAR2(60),
    C_BPartner_Name            NVARCHAR2(60),
    Description1               NVARCHAR2(255),
    Description2               NVARCHAR2(255),
    Description3               NVARCHAR2(255),
    Address3                   NVARCHAR2(60),
    IsBackOrderAllowed         CHAR(1),
    C_UOM_X12DE355             NVARCHAR2(4),
    C_BPartner_Location_Value  NVARCHAR2(40),
    DateEntered                DATE,
    DateRequestedNoLater       DATE,
    DateRequestedNoEarlier     DATE,
    TaxIndicator               NVARCHAR2(10),
    IsBackOrderAllowed_Value   NVARCHAR2(40),
    SalesRep_Value             NVARCHAR2(40),
    FreightCostRule            CHAR(1),
    FreightCostRule_Value      NVARCHAR2(40),
    LineDescription1           NVARCHAR2(255),
    LineDescription2           NVARCHAR2(255),
    LineDescription3           NVARCHAR2(255),
    IsBillTo_Value             NVARCHAR2(40),
    IsBillTo                   CHAR(1),
    IsShipTo_Value             NVARCHAR2(40),
    IsShipTo                   CHAR(1),
    CHECK(IsBackOrderAllowed IN ('Y', 'N')),
    CHECK(IsBillTo IN ('Y', 'N')),
    CHECK(IsShipTo IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE I_Product
  (
    IsSummary         CHAR(1)         DEFAULT 'N',
    C_TaxCategory_ID  NUMBER(10,0),
    Weight            NUMBER,
    WHSLC             NVARCHAR2(40),
    ITTYP             NVARCHAR2(40),
    PACKC             NVARCHAR2(40),
    CHECK(IsSummary IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE M_Product
  (
    WHSLC  NVARCHAR2(40),
    ITTYP  NVARCHAR2(40),
    PACKC  NVARCHAR2(40)
  );

REM ======================================================================

CREATE TABLE C_Order
  (
    SalesRep2               NUMBER(10,0),
    C_PaymentTerm_ID        NUMBER(10,0)    NOT NULL,
    SalesComm               NUMBER,
    DateEntered             DATE,
    DateRequestedNoLater    DATE,
    DateRequestedNoEarlier  DATE,
    IsReceiveDate           CHAR(1),
    ShippingComment         NVARCHAR2(40),
    IsBackOrderAllowed      CHAR(1),
    CHECK(IsReceiveDate IN ('Y', 'N')),
    CHECK(IsBackOrderAllowed IN ('Y', 'N'))
  );

REM ======================================================================

CREATE TABLE C_Invoice
  (
    C_PaymentTerm_ID  NUMBER(10,0)   NOT NULL,
    SalesRep2         NUMBER(10,0)
  );

REM ======================================================================

CREATE TABLE M_Package
  (
    FreightRule  NVARCHAR2(4)
  );

REM ======================================================================

CREATE TABLE I_Invoice
  (
    AD_Org_Value       NVARCHAR2(40),
    CountryCode        CHAR(2),
    M_PriceList_Value  NVARCHAR2(40)
  );

REM ======================================================================