Special Pricing

Comparison between versions 4.0 and 5.0

• New
  • SPDELTA
    • Fields
      • Delta ID new

        Name:	Delta ID
        Type:	AutoInc
        Domain:	SP Delta ID
        Required:	true

      • Account File new

        Name:	Account File
        Type:	String
        Domain:	Account File
        Size:	8
        Required:	true
        Upper:	true

      • Account Code new

        Name:	Account Code
        Type:	String
        Domain:	Account Code
        Size:	28
        Required:	true
        Upper:	true

      • Change Type new

        Name:	Change Type
        Type:	String
        Domain:	ChangeType
        Size:	1
        Required:	true
        Upper:	true

      • Change Heat new

        Name:	Change Heat
        Type:	Byte

      • Created User Code new

        Name:	Created User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Created Date new

        Name:	Created Date
        Type:	Date

      • Created Time new

        Name:	Created Time
        Type:	Time

    • Indices
      • Delta new

        Name:	Delta
        Unique:	true
        Parts:	Delta ID

      • File Delta new

        Name:	File Delta
        Unique:	true
        Parts:	Account File;Delta ID

      • Date Time Delta new

        Name:	Date Time Delta
        Unique:	true
        Parts:	Created Date;Created Time;Delta ID

  • SPDTFLD
    • Fields
      • Delta ID new

        Name:	Delta ID
        Type:	RowID
        Domain:	SP Delta ID
        Required:	true

      • Line No new

        Name:	Line No
        Type:	Smallint

      • Name new

        Name:	Name
        Type:	String
        Domain:	Table Field Name
        Size:	40
        Required:	true

      • Old Value new

        Name:	Old Value
        Type:	Variant
        Size:	120

      • New Value new

        Name:	New Value
        Type:	Variant
        Size:	120

    • Indices
      • Delta Line new

        Name:	Delta Line
        Unique:	true
        Parts:	Delta ID;Line No

• Modified
  • SPCTRL
    • Fields
      • New
        • Record Revision

          Name:	Record Revision
          Type:	Integer
          Domain:	Record Revision

      • Modified
        • Type

          Type:

          changed from

          Integer

          to

          Word

  • SPRULE
    • Fields
      • Has Quantity Breaks new

        Name:	Has Quantity Breaks
        Type:	Boolean