Entity: PAYMENT

Top

This entity records information about all Payments recorded for Orders.

Attributes
ID PRIMARY KEY
Payment_No Payment number that Store associates with the Payment. Cannot have two payments with the same Payment_No. NOT NULL UNIQUE
Order_ID Lookup for the Order for which the payment was recorded. NOT NULL
Amount Total amount calculated for Order payment. The ORDER_HEADER.Total attribute and the PAYMENT.Amount attribute should have the same value. See Subject Area: ORDER , Entity: ORDER_HEADER for more information. NOT NULL
Payment_Time Timestamp when payment was registered. The ORDER_HEADER.Payment_Time attribute and the PAYMENT.Payment_Time attribute should have the same value. See Subject Area: ORDER , Entity: ORDER_HEADER for more information. NOT NULL
Is_Canceled Flag to indicate if the Payment is Canceled. If an already paid Order is Canceled, then the associated Payment is also Canceled. See Subject Area: ORDER - Order Process and Status, Step: CANCEL Order for more information. NOT NULL
Canceled_Time Timestamp when Payment was Canceled. NULL
Cancel_Reason Payment cancel reason. The PAYMENT.Is_Canceled, PAYMENT.Canceled_Time and PAYMENT.Canceled_Reason attributes should have the same values with ORDER_HEADER.Is_Canceled, ORDER_HEADER.Canceled_Time and ORDER_HEADER.Canceled_Reason attributes for the Order for which the Payment was recorded and then Canceled. See Subject Area: ORDER - Order Process and Status, Step: CANCEL Order for more information. NULL
Comments Internal notes used for clarifications on record content. Can be seen and edited only by Store Employees. NULL

Entity: INVOICE

Top

This entity records information about all Invoices recorded for Payments.

Attributes
ID PRIMARY KEY
Invoice_No Invoice number that Store associates with the Invoice. Cannot have two invoices with se same Invoices_No. NOT NULL UNIQUE
Payment_ID Lookup for the Payment for which the Invoice was recorded. NOT NULL
Subtotal Invoice Subtotal (without taxes) . NOT NULL
Tax Invoice Tax. NOT NULL
Total Invoice Total. The INVOICE.Subtotal, INVOICE.Tax and INVOICE.Total attributes should have the same values as ORDER_HEADER.Subtotal, ORDER_HEADER.Tax and ORDER_HEADER.Total attributes for the Order for which the Invoice was recorded. See Subject Area: ORDER , Entity: ORDER_HEADER for more information. NOT NULL
Invoice_Time Timestamp when Invoice was registered. NOT NULL
Is_Canceled Flag to indicate if the Invoice is Canceled. If an Order payment is Canceled, then the associated Invoice is also Canceled. See Subject Area: ORDER - Order Process and Status, Step: CANCEL Order for more information. NOT NULL
Canceled_Time Timestamp when Invoice was Canceled. NULL
Cancel_Reason Invoice cancel reason. The INVOICE.Is_Canceled, INVOICE.Canceled_Time and INVOICE.Canceled_Reason attributes should have the same values with PAYMENT.Is_Canceled, PAYMENT.Canceled_Time and PAYMENT.Canceled_Reason attributes for the Payment for which the Invoice was recorded and then Canceled. See Subject Area: ORDER - Order Process and Status, Step: CANCEL Order for more information. NULL
Comments Internal notes used for clarifications on record content. Can be seen and edited only by Store Employees. NULL

Entity: INVOICE_LINE

Top

This entity records information about all the Invoice Lines of an Invoice.

Attributes
ID PRIMARY KEY
Invoice_ID Lookup for the Invoice for which the Invoice line is recorded. NOT NULL
Order_Line_ID Lookup for the Order Line for which the Invoice Line is recorded. Each Invoice Line is recorded for an Order Line. NOT NULL
Line_No The sequential number of an Invoice Line. An Invoice can have many lines. Each Invoice Line has a sequential number: 1, 2, 3 etc. This attribute can help to sort the Invoice lines and also to reference an Invoice Line (for example when Store Employee and Customer review an Invoice) etc. NOT NULL
Is_Canceled Flag to indicate if the Invoice Line is Canceled. If an Invoice is Canceled, then the associated Invoice Line is also Canceled. NOT NULL
Canceled_Time Timestamp when Invoice Line was Canceled. NULL
Cancel_Reason Invoice Line cancel reason. The INVOICE_LINE.Is_Canceled, INVOICE_LINE.Canceled_Time and INVOICE_LINE.Canceled_Reason attributes should have the same values with INVOICE.Is_Canceled, INVOICE.Canceled_Time and INVOICE.Canceled_Reason attributes for the Invoice for which the Invoice Line was recorded and then Canceled. NULL
Comments Internal notes used for clarifications on record content. Can be seen and edited only by Store Employees
Top