PurchaseOrder

< 1 min read

Sub tables:

LinkedTxnRet
PurchaseOrderLineRet
PurchaseOrderLineGroupRet

FIELD NAME	FIELD NAME (old)	QUERYABLE	UPDATEABLE	REQUIRED ON UPDATE	INSERTABLE	REQUIRED ON INSERT
TxnID		true
TimeCreated		true
TimeModified		true
EditSequence		true
TxnNumber		true
VendorRef_ListID		true
VendorRef_FullName		true
ClassRef_ListID		true
ClassRef_FullName		true
InvSiteRef_ListID		true
InvSiteRef_FullName		true
InvSiteLocRef_ListID		true
InvSiteLocRef_FullName		true
ShipToEntityRef_ListID		true
ShipToEntityRef_FullName		true
TemplateRef_ListID		true
TemplateRef_FullName		true
TxnDate		true
RefNumber		true
VendorAddress_Addr1		true
VendorAddress_Addr2		true
VendorAddress_Addr3		true
VendorAddress_Addr4		true
VendorAddress_Addr5		true
VendorAddress_City		true
VendorAddress_State		true
VendorAddress_PostalCode		true
VendorAddress_Country		true
VendorAddress_Note		true
ShipAddress_Addr1		true
ShipAddress_Addr2		true
ShipAddress_Addr3		true
ShipAddress_Addr4		true
ShipAddress_Addr5		true
ShipAddress_City		true
ShipAddress_State		true
ShipAddress_PostalCode		true
ShipAddress_Country		true
ShipAddress_Note		true
TermsRef_ListID		true
TermsRef_FullName		true
DueDate		true
ExpectedDate		true
ShipMethodRef_ListID		true
ShipMethodRef_FullName		true
FOB		true
TotalAmount		true
CurrencyRef_ListID		true
CurrencyRef_FullName		true
ExchangeRate		true
TotalAmountInHomeCurrency		true
Memo		true
VendorMsg		true
IsToBePrinted		true
IsToBeEmailed		true
IsTaxIncluded		true
SalesTaxCodeRef_ListID		true
SalesTaxCodeRef_FullName		true
Other1		true
Other2		true
IsManuallyClosed		true
IsFullyReceived		true
CustomField1		true
CustomField2		true
CustomField3		true
CustomField4		true
CustomField5		true
CustomField6		true
CustomField7		true
CustomField8		true
CustomField9		true
CustomField10		true
CustomField11		true
CustomField12		true
CustomField13		true
CustomField14		true
CustomField15		true
ExternalGUID		true
UserData	user field
Operation	add,update,delete