Invoicing System

Comparison between versions 2.7 and 3.0

• New
  • INMEMO
    • Fields
      • 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

      • Memo ID new

        Name:	Memo ID
        Type:	AutoInc
        Required:	true

      • Memo Date new

        Name:	Memo Date
        Type:	Date
        Required:	true

      • Memo Time new

        Name:	Memo Time
        Type:	Time

      • Subject new

        Name:	Subject
        Type:	String
        Domain:	Description
        Size:	60

      • Reference new

        Name:	Reference
        Type:	String
        Domain:	Reference
        Size:	20

      • Memo Type new

        Name:	Memo Type
        Type:	String
        Domain:	MemoType
        Size:	1
        Required:	true
        Upper:	true

      • Action On Date new

        Name:	Action On Date
        Type:	Date

      • Action On Time new

        Name:	Action On Time
        Type:	Time

      • Target User Code new

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

      • Category 1 new

        Name:	Category 1
        Type:	String
        Domain:	CO Memo Category 1 Code
        Size:	8
        Upper:	true

      • Category 2 new

        Name:	Category 2
        Type:	String
        Domain:	CO Memo Category 2 Code
        Size:	8
        Upper:	true

      • Custom 1 new

        Name:	Custom 1
        Type:	String
        Domain:	Short Custom Text
        Size:	30

      • Custom 2 new

        Name:	Custom 2
        Type:	String
        Domain:	Short Custom Text
        Size:	30

      • Inactive new

        Name:	Inactive
        Type:	Boolean

      • 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

      • Modified User Code new

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

      • Modified Date new

        Name:	Modified Date
        Type:	Date

      • Modified Time new

        Name:	Modified Time
        Type:	Time

    • Indices
      • File Code Type Memo new

        Name:	File Code Type Memo
        Unique:	true
        Parts:	Account File;Account Code;Memo Type;Memo ID

      • Active File Code Type Memo new

        Name:	Active File Code Type Memo
        Unique:	true
        Parts:	Inactive;Account File;Account Code;Memo Type;Memo ID

      • Memo new

        Name:	Memo
        Unique:	true
        Parts:	Memo ID

      • Active Type ActionDateTime new

        Name:	Active Type ActionDateTime
        Parts:	Inactive;Memo Type;Action On Date;Action On Time

      • File Type Code Memo new

        Name:	File Type Code Memo
        Unique:	true
        Parts:	Account File;Memo Type;Account Code;Memo ID

      • Active File Type Code Memo new

        Name:	Active File Type Code Memo
        Unique:	true
        Parts:	Inactive;Account File;Memo Type;Account Code;Memo ID

      • Type File Code Memo new

        Name:	Type File Code Memo
        Unique:	true
        Parts:	Memo Type;Account File;Account Code;Memo ID

      • Active Type File Code Memo new

        Name:	Active Type File Code Memo
        Unique:	true
        Parts:	Inactive;Memo Type;Account File;Account Code;Memo ID

  • INMEMOLN
    • Fields
      • Memo ID new

        Name:	Memo ID
        Type:	RowID
        Required:	true

      • Line No new

        Name:	Line No
        Type:	Integer
        Required:	true

      • Line Text new

        Name:	Line Text
        Type:	String
        Domain:	Memo Line Text
        Size:	78

    • Indices
      • Memo Line new

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

• Modified
  • INBANKLN
    • Fields
      • New
        • Currency Code

          Name:	Currency Code
          Type:	String
          Domain:	CO Currency Code
          Size:	3
          Required:	true
          Upper:	true

        • Banking Amount Bs

          Name:	Banking Amount Bs
          Type:	Float
          Domain:	Amount

      • Modified
        • Banking Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

    • Indices
      • New
        • Line

          Name:	Line
          Unique:	true
          Parts:	Line ID

      • Modified
        • Document Line

          Unique:

          true

  • INCTRL
    • Fields
      • Name modified

        Domain:

        Control Name

  • INHEAD
    • Fields
      • New
        • Currency Code

          Name:	Currency Code
          Type:	String
          Domain:	CO Currency Code
          Size:	3
          Required:	true
          Upper:	true

        • Rate Type

          Name:	Rate Type
          Type:	String
          Domain:	CO FX Rate Type Code
          Size:	8
          Required:	true
          Upper:	true

        • Exchange Rate

          Name:	Exchange Rate
          Type:	Float
          Domain:	Exchange Rate
          Required:	true

        • Fixed Rate

          Name:	Fixed Rate
          Type:	Boolean

        • Delivery Country Code

          Name:	Delivery Country Code
          Type:	String
          Domain:	CO Country Code
          Size:	2
          Upper:	true

        • Delivery Post Code

          Name:	Delivery Post Code
          Type:	String
          Domain:	Post Code
          Size:	10

        • Charge 1 Amount Bs

          Name:	Charge 1 Amount Bs
          Type:	Float
          Domain:	Amount

        • Charge 2 Amount Bs

          Name:	Charge 2 Amount Bs
          Type:	Float
          Domain:	Amount

        • Charge 3 Amount Bs

          Name:	Charge 3 Amount Bs
          Type:	Float
          Domain:	Amount

        • Charge 1 Gst Amount Bs

          Name:	Charge 1 Gst Amount Bs
          Type:	Float
          Domain:	Amount

        • Charge 2 Gst Amount Bs

          Name:	Charge 2 Gst Amount Bs
          Type:	Float
          Domain:	Amount

        • Charge 3 Gst Amount Bs

          Name:	Charge 3 Gst Amount Bs
          Type:	Float
          Domain:	Amount

        • Exclusive Cost Bs

          Name:	Exclusive Cost Bs
          Type:	Float
          Domain:	Amount

        • Exclusive Amount Bs

          Name:	Exclusive Amount Bs
          Type:	Float
          Domain:	Amount

        • Gst Amount Bs

          Name:	Gst Amount Bs
          Type:	Float
          Domain:	Amount

        • Rounding Amount Bs

          Name:	Rounding Amount Bs
          Type:	Float
          Domain:	Amount

        • Commission Amount Bs

          Name:	Commission Amount Bs
          Type:	Float
          Domain:	Amount

        • Default Job Code

          Name:	Default Job Code
          Type:	String
          Domain:	JC Job Code
          Size:	16
          Upper:	true

        • Job Amount Bs

          Name:	Job Amount Bs
          Type:	Float
          Domain:	Amount

        • Job Cost Bs

          Name:	Job Cost Bs
          Type:	Float
          Domain:	Amount

        • Total Weight

          Name:	Total Weight
          Type:	Float
          Domain:	Weight

        • Total Volume

          Name:	Total Volume
          Type:	Float
          Domain:	Volume

        • Created User Code

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

        • Created Date

          Name:	Created Date
          Type:	Date

        • Created Time

          Name:	Created Time
          Type:	Time

        • Modified User Code

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

        • Modified Date

          Name:	Modified Date
          Type:	Date

        • Modified Time

          Name:	Modified Time
          Type:	Time

        • Usage Cost

          Name:	Usage Cost
          Type:	Float
          Domain:	FX Amount

        • Usage Cost Bs

          Name:	Usage Cost Bs
          Type:	Float
          Domain:	Amount

        • Source Order ID

          Name:	Source Order ID
          Type:	RowID

        • Default Component Code

          Name:	Default Component Code
          Type:	String
          Domain:	JC Component Code
          Size:	8
          Upper:	true

        • Default Cost Centre Code

          Name:	Default Cost Centre Code
          Type:	String
          Domain:	JC Cost Centre Code
          Size:	8
          Upper:	true

      • Deleted
        • Job Code
      • Modified
        • Document Type

          Domain:

          changed from

          Character

          to

          DocumentType

        • Document Class

          Domain:

          changed from

          Character

          to

          INInvoiceType

        • Post Status

          Domain:

          changed from

          Character

          to

          INPostStatus

        • Print Status

          Domain:

          changed from

          Character

          to

          INPrintStatus

        • Sell Price Basis

          Domain:

          changed from

          Character

          to

          SellPriceBasis

        • Gst Override

          Domain:

          changed from

          Character

          to

          CO Gst Code

        • Internal Reference

          Size:

          changed from

          12

          to

          20

        • Quotation Reference

          Size:

          changed from

          12

          to

          20

        • Charge 1 Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Charge 2 Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Charge 3 Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Charge 1 Gst Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Charge 2 Gst Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Charge 3 Gst Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Charge 1 Gst Code

          Domain:

          changed from

          Character

          to

          CO Gst Code

        • Charge 2 Gst Code

          Domain:

          changed from

          Character

          to

          CO Gst Code

        • Charge 3 Gst Code

          Domain:

          changed from

          Character

          to

          CO Gst Code

        • Exclusive Cost

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Exclusive Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Gst Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Rounding Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Commission Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Custom 1

          Domain:

          Short Custom Text

        • Custom 2

          Domain:

          Short Custom Text

        • Job Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Job Cost

          Domain:

          changed from

          Amount

          to

          FX Amount

    • Indices
      • New
        • Source Order

          Name:	Source Order
          Parts:	Source Order ID;Document ID

      • Modified
        • Job Period Document

          Parts:

          changed from

          Job Code;Period ID;Document ID

          to

          Default Job Code;Period ID;Document ID

  • INLINE
    • Fields
      • New
        • Currency Code

          Name:	Currency Code
          Type:	String
          Domain:	CO Currency Code
          Size:	3
          Required:	true
          Upper:	true

        • Cost Price Bs

          Name:	Cost Price Bs
          Type:	Float
          Domain:	Cost Price

        • Selling Price Bs

          Name:	Selling Price Bs
          Type:	Float
          Domain:	Sell Price

        • Exclusive Discount Bs

          Name:	Exclusive Discount Bs
          Type:	Float
          Domain:	Amount

        • Entered Discount Bs

          Name:	Entered Discount Bs
          Type:	Float
          Domain:	Amount

        • Exclusive Cost Bs

          Name:	Exclusive Cost Bs
          Type:	Float
          Domain:	Amount

        • Exclusive Amount Bs

          Name:	Exclusive Amount Bs
          Type:	Float
          Domain:	Amount

        • Gst Amount Bs

          Name:	Gst Amount Bs
          Type:	Float
          Domain:	Amount

        • Commission Amount Bs

          Name:	Commission Amount Bs
          Type:	Float
          Domain:	Amount

        • Job Code

          Name:	Job Code
          Type:	String
          Domain:	JC Job Code
          Size:	16
          Upper:	true

        • JC Transaction Type

          Name:	JC Transaction Type
          Type:	String
          Domain:	JCTranType
          Size:	1
          Required:	true
          Upper:	true

        • Cost Centre Code

          Name:	Cost Centre Code
          Type:	String
          Domain:	JC Cost Centre Code
          Size:	8
          Upper:	true

        • Component Code

          Name:	Component Code
          Type:	String
          Domain:	JC Component Code
          Size:	8
          Upper:	true

        • JC Transaction ID

          Name:	JC Transaction ID
          Type:	RowID

        • Extended Weight

          Name:	Extended Weight
          Type:	Float
          Domain:	Weight

        • Extended Volume

          Name:	Extended Volume
          Type:	Float
          Domain:	Volume

        • Weight

          Name:	Weight
          Type:	Float
          Domain:	Weight

        • Volume

          Name:	Volume
          Type:	Float
          Domain:	Volume

        • Usage Cost

          Name:	Usage Cost
          Type:	Float
          Domain:	FX Amount

        • Usage Cost Bs

          Name:	Usage Cost Bs
          Type:	Float
          Domain:	Amount

        • Comment

          Name:	Comment
          Type:	String
          Domain:	Comment
          Size:	30

      • Deleted
        • Job Transaction ID
      • Modified
        • Line Type

          Domain:

          changed from

          Character

          to

          INLineType

        • Cost Price

          Domain:

          changed from

          Price

          to

          FX Cost Price

        • Selling Price

          Domain:

          changed from

          Price

          to

          FX Sell Price

        • Exclusive Discount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Entered Discount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Gst Code

          Domain:

          changed from

          Character

          to

          CO Gst Code

        • Exclusive Cost

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Exclusive Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Gst Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Commission Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Custom 1

          Domain:

          Short Custom Text

        • Custom 2

          Domain:

          Short Custom Text

    • Indices
      • New
        • Product

          Name:	Product
          Parts:	Product Code

      • Modified
        • Job Transaction

          Parts:

          changed from

          Job Transaction ID

          to

          Job Code;JC Transaction ID

  • INSHIP
    • Fields
      • Shipper Name modified

        Domain:

        Name

      • Custom 1 modified

        Domain:

        Short Custom Text

      • Custom 2 modified

        Domain:

        Short Custom Text

  • INSHIPLI
    • Fields
      • New
        • Custom 1

          Name:	Custom 1
          Type:	String
          Domain:	Short Custom Text
          Size:	30

        • Custom 2

          Name:	Custom 2
          Type:	String
          Domain:	Short Custom Text
          Size:	30

      • Modified
        • Shipper Code

          Required:

          true

        • Reference

          Domain:

          Shipper Reference

    • Indices
      • Line new

        Name:	Line
        Parts:	Line ID