QuickBooks SQL Mirror: The 'purchaseorder' Table

qbsql_id
TxnID					(Read-only. You may make this up if you're inserting a new value, it will be updated when it syncs to QuickBooks.)
TimeCreated				(Read-only.)
TimeModified				(Read-only.)
EditSequence				(Read-only. Do not change this!)
TxnNumber				(Read-only.)
Vendor_ListID				
Vendor_FullName				(Either this or Vendor_ListID is required.)
Class_ListID
Class_FullName
ShipToEntity_ListID
ShipToEntity_FullName			(This can be a reference to either a Customer, a Vendor, or an Employee.)
Template_ListID
Template_FullName
TxnDate					(If this is left blank, today's date will be used.)
RefNumber
VendorAddress_Addr1
VendorAddress_Addr2
VendorAddress_Addr3
VendorAddress_Addr4
VendorAddress_Addr5
VendorAddress_City
VendorAddress_State
VendorAddress_PostalCode
VendorAddress_Country
VendorAddress_Note
VendorAddressBlock_Addr1		(Do not use any of the VendorAddressBlock_* fields.)
VendorAddressBlock_Addr2
VendorAddressBlock_Addr3
VendorAddressBlock_Addr4
VendorAddressBlock_Addr5
ShipAddress_Addr1
ShipAddress_Addr2
ShipAddress_Addr3
ShipAddress_Addr4
ShipAddress_Addr5
ShipAddress_City
ShipAddress_State
ShipAddress_PostalCode
ShipAddress_Country
ShipAddress_Note
ShipAddressBlock_Addr1			(Do not use any of the ShipAddressBlock_* fields.)
ShipAddressBlock_Addr2
ShipAddressBlock_Addr3
ShipAddressBlock_Addr4
ShipAddressBlock_Addr5
Terms_ListID
Terms_FullName				(This is a reference to the 'standardterms' table.)
DueDate					(If you leave this blank and provide a Terms reference, it will be auto-calculated based on the Terms chosen.)
ExpectedDate
ShipMethod_ListID
ShipMethod_FullName
FOB
TotalAmount				(Read-only. You may INSERT or UPDATE this, but it will not be transferred to QuickBooks, instead the total will be calculated from the line items.)
IsManuallyClosed			(This may only be used if the record already exists within QuickBooks.)
IsFullyReceived				(Read-only.)
Memo
VendorMsg
IsToBePrinted
IsToBeEmailed
Other1
Other2
quickbooks_integration_php_consolibyte_sqlmirror_table_purchaseorder.txt · Last modified: 2013/01/21 12:44 (external edit)