SalesAndPurchaseRet

SalesAndPurchaseRet (old ->SalesAndPurchaseDetail)

FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
SalesDesctrue
SalesPricetrue
IncomeAccountRef_ListIDtrue
IncomeAccountRef_FullNametrue
PurchaseDesctrue
PurchaseCosttrue
PurchaseTaxCodeRef_ListIDtrue
PurchaseTaxCodeRef_FullNametrue
ExpenseAccountRef_ListIDtrue
ExpenseAccountRef_FullNametrue
PrefVendorRef_ListIDtrue
PrefVendorRef_FullNametrue
PARENT_IDKEYIDKEY
SeqNumkeeps the seq

Parent tables:

  • ItemNonInventory
  • ItemOtherCharge
  • ItemService

Powered by BetterDocs