Purchase Orders

Comparison between versions 2.7 and 3.0

• New
  • POMEMO
    • 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
        Required:	true

      • 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

  • POMEMOLN
    • 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
  • POAUTHOR
    • Fields
      • New
        • 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

      • Modified
        • Authorisation Name

          Domain:

          Short Description

        • Password
          • Deleted
            • Upper
          • Modified

            Size:

            changed from

            8

            to

            32

        • Role

          Domain:

          Role

  • POCTRL
    • Fields
      • Name modified

        Domain:

        Control Name

  • POHEAD
    • 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

        • Default Cost Centre Code

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

        • Default Component Code

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

        • 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

        • Ordered Amount Bs

          Name:	Ordered Amount Bs
          Type:	Float
          Domain:	Amount

        • Ordered Gst Bs

          Name:	Ordered Gst Bs
          Type:	Float
          Domain:	Amount

        • Receipted Amount Bs

          Name:	Receipted Amount Bs
          Type:	Float
          Domain:	Amount

        • Invoiced Amount Bs

          Name:	Invoiced Amount Bs
          Type:	Float
          Domain:	Amount

        • Quantity Shipped

          Name:	Quantity Shipped
          Type:	Float
          Domain:	Quantity

        • Valuation Date

          Name:	Valuation Date
          Type:	Date

        • Quantity Pending Invoice

          Name:	Quantity Pending Invoice
          Type:	Float
          Domain:	Quantity

        • Pending Invoice Amount

          Name:	Pending Invoice Amount
          Type:	Float
          Domain:	FX Amount

        • Pending Invoice Amount Bs

          Name:	Pending Invoice Amount Bs
          Type:	Float
          Domain:	Amount

        • Shipped Amount

          Name:	Shipped Amount
          Type:	Float
          Domain:	FX Amount

        • Shipped Amount Bs

          Name:	Shipped Amount Bs
          Type:	Float
          Domain:	Amount

        • Quantity Outstanding Receipt

          Name:	Quantity Outstanding Receipt
          Type:	Float
          Domain:	Quantity

        • Quantity Outstanding Invoice

          Name:	Quantity Outstanding Invoice
          Type:	Float
          Domain:	Quantity

        • Outstanding Amount Receipt

          Name:	Outstanding Amount Receipt
          Type:	Float
          Domain:	FX Amount

        • Outstanding Amount Receipt Bs

          Name:	Outstanding Amount Receipt Bs
          Type:	Float
          Domain:	Amount

        • Outstanding Amount Invoice

          Name:	Outstanding Amount Invoice
          Type:	Float
          Domain:	FX Amount

        • Outstanding Amount Invoice Bs

          Name:	Outstanding Amount Invoice 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

        • Comment

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

      • Modified
        • Document Type

          Domain:

          changed from

          Character

          to

          DocumentType

        • Document Class

          Domain:

          changed from

          Character

          to

          POOrderType

        • Post Status

          Domain:

          changed from

          Character

          to

          POPostStatus

        • Print Status

          Domain:

          changed from

          Character

          to

          POPrintStatus

        • Internal Reference

          Size:

          changed from

          12

          to

          20

        • Quotation Reference

          Size:

          changed from

          12

          to

          20

        • Delivery Code

          Domain:

          changed from

          AR Delivery Code

          to

          CO Delivery Code

        • Ordered Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Ordered Gst

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Receipted Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Invoiced Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Custom 1

          Domain:

          Short Custom Text

        • Custom 2

          Domain:

          Short Custom Text

  • POLINE
    • Fields
      • New
        • Currency Code

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

        • Quantity Shipped

          Name:	Quantity Shipped
          Type:	Float
          Domain:	Quantity

        • Cost Price Bs

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

        • Ordered Amount Bs

          Name:	Ordered Amount Bs
          Type:	Float
          Domain:	Amount

        • Ordered Gst Bs

          Name:	Ordered Gst Bs
          Type:	Float
          Domain:	Amount

        • Receipted Amount Bs

          Name:	Receipted Amount Bs
          Type:	Float
          Domain:	Amount

        • Invoiced Amount Bs

          Name:	Invoiced Amount Bs
          Type:	Float
          Domain:	Amount

        • JC Transaction Type

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

        • Sell Currency Code

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

        • Sell Rate Type

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

        • Sell Exchange Rate

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

        • Sell Price

          Name:	Sell Price
          Type:	Float
          Domain:	FX Sell Price

        • Sell Price Bs

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

        • 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

        • Quantity Pending Invoice

          Name:	Quantity Pending Invoice
          Type:	Float
          Domain:	Quantity

        • Pending Invoice Amount

          Name:	Pending Invoice Amount
          Type:	Float
          Domain:	FX Amount

        • Pending Invoice Amount Bs

          Name:	Pending Invoice Amount Bs
          Type:	Float
          Domain:	Amount

        • Shipped Amount

          Name:	Shipped Amount
          Type:	Float
          Domain:	FX Amount

        • Shipped Amount Bs

          Name:	Shipped Amount Bs
          Type:	Float
          Domain:	Amount

        • Quantity Outstanding Receipt

          Name:	Quantity Outstanding Receipt
          Type:	Float
          Domain:	Quantity

        • Quantity Outstanding Invoice

          Name:	Quantity Outstanding Invoice
          Type:	Float
          Domain:	Quantity

        • Outstanding Amount Receipt

          Name:	Outstanding Amount Receipt
          Type:	Float
          Domain:	FX Amount

        • Outstanding Amount Receipt Bs

          Name:	Outstanding Amount Receipt Bs
          Type:	Float
          Domain:	Amount

        • Outstanding Amount Invoice

          Name:	Outstanding Amount Invoice
          Type:	Float
          Domain:	FX Amount

        • Outstanding Amount Invoice Bs

          Name:	Outstanding Amount Invoice Bs
          Type:	Float
          Domain:	Amount

        • Comment

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

      • Modified
        • Line Type

          Domain:

          changed from

          Character

          to

          POLineType

        • Cost Price

          Domain:

          changed from

          Price

          to

          FX Cost Price

        • Gst Code

          Domain:

          changed from

          Character

          to

          CO Gst Code

        • Ordered Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Ordered Gst

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Receipted Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Invoiced Amount

          Domain:

          changed from

          Amount

          to

          FX Amount

        • Cost Centre Code

          Size:

          changed from

          4

          to

          8

        • Component Code

          Size:

          changed from

          4

          to

          8

        • Line Status

          Domain:

          changed from

          Character

          to

          POLineStatus

        • Custom 1

          Domain:

          Short Custom Text

        • Custom 2

          Domain:

          Short Custom Text

    • Indices
      • New
        • Job

          Name:	Job
          Parts:	Job Code

        • Product

          Name:	Product
          Parts:	Product Code

      • Deleted
        • Job Status Line