This creates one creditcardcharge with three lines. Note the FQSaveToCache field, set to True except on the last one.
INSERT INTO "CreditCardChargeItemLine" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber", "ItemLineItemRefListID", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount", "FQSaveToCache") VALUES ('D0000-933270541', '2C0000-933272658', {d'2003-12-15'}, '1', '1E0000-933272656', 'Test Desc 1', 1.0, 1.1, 1.1, 1)
INSERT INTO "CreditCardChargeItemLine" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber", "ItemLineItemRefListID", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount", "FQSaveToCache") VALUES ('D0000-933270541', '2C0000-933272658', {d'2003-12-15'}, '1', '3B0000-1071518615', 'Test Desc 2', 1.0, 1.1, 1.1, 1)
INSERT INTO "CreditCardChargeItemLine" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber", "ItemLineItemRefListID", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount", "FQSaveToCache") VALUES ('D0000-933270541', '2C0000-933272658', {d'2003-12-15'}, '1', '250000-933272656', 'Test Desc 3', 1.0, 1.1, 1.1, 0)
This creates three creditcardcharges with one line each. Note the FQSaveToCache field is not specified (or can be set to false)
INSERT INTO "CreditCardChargeItemLine" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber", "ItemLineItemRefListID", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount") VALUES ('D0000-933270541', '2C0000-933272658', {d'2003-12-15'}, '1', '1E0000-933272656', 'Test Desc 1', 1.0, 1.1, 1.1)
INSERT INTO "CreditCardChargeItemLine" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber", "ItemLineItemRefListID", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount") VALUES ('D0000-933270541', '2C0000-933272658', {d'2003-12-15'}, '1', '3B0000-1071518615', 'Test Desc 2', 1.0, 1.1, 1.1)
INSERT INTO "CreditCardChargeItemLine" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber", "ItemLineItemRefListID", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount") VALUES ('D0000-933270541', '2C0000-933272658', {d'2003-12-15'}, '1', '250000-933272656', 'Test Desc 3', 1.0, 1.1, 1.1)
This creates one creditcardcharge with three lines. Note the FQSaveToCache field, set to True except on the last one.
INSERT INTO "CreditCardChargeExpenseLine" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber", "ExpenseLineAccountRefListID", "ExpenseLineAmount", "FQSaveToCache") VALUES ('D0000-933270541', '2B0000-933272658', {d'2003-12-15'}, '1', '200000-933270542', 1.1, 1)
INSERT INTO "CreditCardChargeExpenseLine" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber", "ExpenseLineAccountRefListID", "ExpenseLineAmount", "FQSaveToCache") VALUES ('D0000-933270541', '2B0000-933272658', {d'2003-12-15'}, '1', '200000-933270542', 2.2, 1)
INSERT INTO "CreditCardChargeExpenseLine" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber", "ExpenseLineAccountREfListID", "ExpenseLineAmount", "FQSaveToCache") VALUES ('D0000-933270541', '2B0000-933272658', {d'2003-12-15'}, '1', '200000-933270542', 3.3, 0)
This creates one CreditCardCharge with three lines. Note the FQSaveToCache field, set to True. Saving the CreditCardCharge saves the lines with it.
INSERT INTO "CreditCardChargeItemLine" ("ItemLineItemRefListID", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount", "FQSaveToCache") VALUES ('1E0000-933272656', 'Test Desc 1', 1.0, 1.1, 1.1, 1)
INSERT INTO "CreditCardChargeItemLine" ("ItemLineItemRefListID", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount", "FQSaveToCache") VALUES ('3B0000-1071518615', 'Test Desc 2', 1.0, 1.1, 1.1, 1)
INSERT INTO "CreditCardChargeItemLine" ("ItemLineItemRefListID", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount", "FQSaveToCache") VALUES ('250000-933272656', 'Test Desc 3', 1.0, 1.1, 1.1, 1)
INSERT INTO "CreditCardCharge" ("AccountRefListID", "PayeeEntityRefListID", "TxnDate", "RefNumber") VALUES ('D0000-933270541', '2C0000-933272658', {d'2003-12-15'}, '1') |