This creates one creditmemo with three lines. Note the FQSaveToCache field, set to True except on the last one.
INSERT INTO "CreditMemoLine" ("CustomerRefListID", "ARAccountRefListID", "TxnDate", "RefNumber", "Memo", "CreditMemoLineItemRefListID", "CreditMemoLineDesc", "CreditMemoLineQuantity", "CreditMemoLineRate", "FQSaveToCache") VALUES ('180000-933272658', '40000-933270541', {d'2003-12-15'}, '1', 'Test Memo 1', '1E0000-933272656', 'Test Desc 1', 1.0, 11.1, 1)
INSERT INTO "CreditMemoLine" ("CustomerRefListID", "ARAccountRefListID", "TxnDate", "RefNumber", "Memo", "CreditMemoLineItemRefListID", "CreditMemoLineDesc", "CreditMemoLineQuantity", "CreditMemoLineRate", "FQSaveToCache") VALUES ('180000-933272658', '40000-933270541', {d'2003-12-15'}, '1', 'Test Memo 2', '1E0000-933272656', 'Test Desc 2', 2.0, 22.2, 1)
INSERT INTO "CreditMemoLine" ("CustomerRefListID", "ARAccountRefListID", "TxnDate", "RefNumber", "Memo", "CreditMemoLineItemRefListID", "CreditMemoLineDesc", "CreditMemoLineQuantity", "CreditMemoLineRate", "FQSaveToCache") VALUES ('180000-933272658', '40000-933270541', {d'2003-12-15'}, '1', 'Test Memo 3', '1E0000-933272656', 'Test Desc 3', 3.0, 33.3, 0)
This creates three creditmemos with one line each. Note the FQSaveToCache field is not specified (or can be set to false)
INSERT INTO "CreditMemoLine" ("CustomerRefListID", "ARAccountRefListID", "TxnDate", "RefNumber", "Memo", "CreditMemoLineItemRefListID", "CreditMemoLineDesc", "CreditMemoLineQuantity", "CreditMemoLineRate") VALUES ('180000-933272658', '40000-933270541', {d'2003-12-15'}, '1', 'Test Memo 1', '1E0000-933272656', 'Test Desc 1', 1.0, 11.1)
INSERT INTO "CreditMemoLine" ("CustomerRefListID", "ARAccountRefListID", "TxnDate", "RefNumber", "Memo", "CreditMemoLineItemRefListID", "CreditMemoLineDesc", "CreditMemoLineQuantity", "CreditMemoLineRate") VALUES ('180000-933272658', '40000-933270541', {d'2003-12-15'}, '1', 'Test Memo 2', '1E0000-933272656', 'Test Desc 2', 2.0, 22.2)
INSERT INTO "CreditMemoLine" ("CustomerRefListID", "ARAccountRefListID", "TxnDate", "RefNumber", "Memo", "CreditMemoLineItemRefListID", "CreditMemoLineDesc", "CreditMemoLineQuantity", "CreditMemoLineRate") VALUES ('180000-933272658', '40000-933270541', {d'2003-12-15'}, '1', 'Test Memo 3', '1E0000-933272656', 'Test Desc 3', 3.0, 33.3)
This creates one CreditMemo with three lines. Note the FQSaveToCache field, set to True. Saving the CreditMemo saves the lines with it.
INSERT INTO "CreditMemoLine" ("CreditMemoLineItemRefListID", "CreditMemoLineDesc", "CreditMemoLineQuantity", "CreditMemoLineRate", "FQSaveToCache") VALUES ('1E0000-933272656', 'Test Desc 1', 1.0, 11.1, 1)
INSERT INTO "CreditMemoLine" ("CreditMemoLineItemRefListID", "CreditMemoLineDesc", "CreditMemoLineQuantity", "CreditMemoLineRate", "FQSaveToCache") VALUES ('1E0000-933272656', 'Test Desc 2', 2.0, 22.2, 1)
INSERT INTO "CreditMemoLine" ("CreditMemoLineItemRefListID", "CreditMemoLineDesc", "CreditMemoLineQuantity", "CreditMemoLineRate", "FQSaveToCache") VALUES ('1E0000-933272656', 'Test Desc 3', 3.0, 33.3, 1)
INSERT INTO "CreditMemo" ("CustomerRefListID", "ARAccountRefListID", "TxnDate", "RefNumber", "Memo") VALUES ('180000-933272658', '40000-933270541', {d'2003-12-15'}, '1', 'Test Memo') |