ADO.NET Provider for Sage Intacct

Build 24.0.9175

PODocument

Stores comprehensive details for Purchase Order (PO) documents, capturing statuses, associated vendors, and workflow data.

Table Specific Information

Insert

Insert is only supported when UseLegacy=True. The following example illustrates how to insert into PODocument table: 

INSERT INTO PODocument (Docparid, Whencreated, Custvendid, Contact_contactname, Billto_contactname, Itemaggregate) VALUES ('Purchase Order', '06/19/2013', 'myVendorId', '', '', '<potransitem><itemid>0001</itemid><warehouseid>WH1</warehouseid><quantity>15</quantity><unit>Each</unit><price>100.99</price></potransitem>')

Columns

Name Type Description
Recordno [KEY] String The unique identifier for the PO Document.
Docno [KEY] String The document number for the PO Document.
Docid String The document ID for the PO Document.
Createdfrom String The source document from which this PO was created.
State String The current state of the PO Document (e.g., Draft, Approved).
Closed Bool Indicates whether the PO Document is closed.
Whencreated Date The date when the PO Document was created.
Auwhencreated Datetime The timestamp when the PO Document was created for auditing purposes.
Createdby Long The user who created the PO Document.
Modifiedby Long The user who last modified the PO Document.
Whenmodified Datetime The date and time when the PO Document was last modified.
Whendue Date The due date for the PO Document.
Status String The status of the PO Document (e.g., Active, Inactive).
Ponumber String The purchase order number associated with the document.
Vendordocno String The vendor's document number associated with the PO Document.
Docparid String The document template ID used for the PO Document.
Docparkey String The key of the document template used for the PO Document.
Docparclass String The class of the document template used for the PO Document.
Updates_inv String Indicates whether the PO Document updates inventory.
Term_name String The payment terms associated with the PO Document.
Note String A note or comment associated with the PO Document.
Warehouse_locationid String The default warehouse location associated with the PO Document.
Shipvia String The shipping method used for the PO Document.
User String The user associated with the PO Document.
Createduser String The user who created the PO Document.
Userid String The ID of the user who last modified the PO Document.
Createduserid String The ID of the user who created the PO Document.
Contact_contactname String The name of the vendor contact associated with the PO Document.
Contact_prefix String The prefix (e.g., Mr., Ms.) of the vendor contact associated with the PO Document.
Contact_firstname String The first name of the vendor contact associated with the PO Document.
Contact_initial String The middle initial of the vendor contact associated with the PO Document.
Contact_lastname String The last name of the vendor contact associated with the PO Document.
Contact_companyname String The company name of the vendor associated with the PO Document.
Contact_printas String The name of the vendor contact as it should appear on official documents.
Contact_phone1 String The primary phone number of the vendor contact associated with the PO Document.
Contact_phone2 String The secondary phone number of the vendor contact associated with the PO Document.
Contact_cellphone String The mobile phone number of the vendor contact associated with the PO Document.
Contact_pager String The pager number of the vendor contact associated with the PO Document.
Contact_fax String The fax number of the vendor contact associated with the PO Document.
Contact_email1 String The primary email address of the vendor contact associated with the PO Document.
Contact_email2 String The secondary email address of the vendor contact associated with the PO Document.
Contact_url1 String The primary website URL of the vendor contact associated with the PO Document.
Contact_url2 String The secondary website URL of the vendor contact associated with the PO Document.
Contact_visible Bool Indicates whether the vendor contact associated with the PO Document is visible.
Contact_mailaddress_address1 String The first line of the mailing address for the vendor contact.
Contact_mailaddress_address2 String The second line of the mailing address for the vendor contact.
Contact_mailaddress_city String The city of the mailing address for the vendor contact.
Contact_mailaddress_state String The state or territory of the mailing address for the vendor contact.
Contact_mailaddress_zip String The ZIP or postal code of the mailing address for the vendor contact.
Contact_mailaddress_country String The country of the mailing address for the vendor contact.
Contact_mailaddress_countrycode String The country code of the mailing address for the vendor contact.
Shiptokey String The key identifying the shipping destination for the PO Document.
Shipto_contactname String The contact name for the shipping destination associated with the PO Document.
Shipto_prefix String The prefix (e.g., Mr., Ms.) for the shipping contact associated with the PO Document.
Shipto_firstname String The first name of the shipping contact associated with the PO Document.
Shipto_initial String The middle initial of the shipping contact associated with the PO Document.
Shipto_lastname String The last name of the shipping contact associated with the PO Document.
Shipto_companyname String The company name of the shipping contact associated with the PO Document.
Shipto_printas String The name of the shipping contact as it should appear on official documents.
Shipto_phone1 String The primary phone number of the shipping contact associated with the PO Document.
Shipto_phone2 String The secondary phone number of the shipping contact associated with the PO Document.
Shipto_cellphone String The mobile phone number of the shipping contact associated with the PO Document.
Shipto_pager String The pager number of the shipping contact associated with the PO Document.
Shipto_fax String The fax number of the shipping contact associated with the PO Document.
Shipto_email1 String The primary email address of the shipping contact associated with the PO Document.
Shipto_email2 String The secondary email address of the shipping contact associated with the PO Document.
Shipto_url1 String The primary website URL of the shipping contact associated with the PO Document.
Shipto_url2 String The secondary website URL of the shipping contact associated with the PO Document.
Shipto_visible Bool Indicates whether the shipping contact associated with the PO Document is visible.
Shipto_mailaddress_address1 String The first line of the mailing address for the shipping contact.
Shipto_mailaddress_address2 String The second line of the mailing address for the shipping contact.
Shipto_mailaddress_city String The city of the mailing address for the shipping contact.
Shipto_mailaddress_state String The state or territory of the mailing address for the shipping contact.
Shipto_mailaddress_zip String The ZIP or postal code of the mailing address for the shipping contact.
Shipto_mailaddress_country String The country of the mailing address for the shipping contact.
Shipto_mailaddress_countrycode String The country code of the mailing address for the shipping contact.
Billtokey String The key identifying the billing destination for the PO Document.
Billto_contactname String The contact name for the billing destination associated with the PO Document.
Billto_prefix String The prefix (e.g., Mr., Ms.) for the billing contact associated with the PO Document.
Billto_firstname String The first name of the billing contact associated with the PO Document.
Billto_initial String The middle initial of the billing contact associated with the PO Document.
Billto_lastname String The last name of the billing contact associated with the PO Document.
Billto_companyname String The company name of the billing contact associated with the PO Document.
Billto_printas String The name of the billing contact as it should appear on official documents.
Billto_phone1 String The primary phone number of the billing contact associated with the PO Document.
Billto_phone2 String The secondary phone number of the billing contact associated with the PO Document.
Billto_cellphone String The mobile phone number of the billing contact associated with the PO Document.
Billto_pager String The pager number of the billing contact associated with the PO Document.
Billto_fax String The fax number of the billing contact associated with the PO Document.
Billto_email1 String The primary email address of the billing contact associated with the PO Document.
Billto_email2 String The secondary email address of the billing contact associated with the PO Document.
Billto_url1 String The primary website URL of the billing contact associated with the PO Document.
Billto_url2 String The secondary website URL of the billing contact associated with the PO Document.
Billto_visible Bool Indicates whether the billing contact associated with the PO Document is visible.
Billto_mailaddress_address1 String The first line of the mailing address for the billing contact.
Billto_mailaddress_address2 String The second line of the mailing address for the billing contact.
Billto_mailaddress_city String The city of the mailing address for the billing contact.
Billto_mailaddress_state String The state or territory of the mailing address for the billing contact.
Billto_mailaddress_zip String The ZIP or postal code of the mailing address for the billing contact.
Billto_mailaddress_country String The country of the mailing address for the billing contact.
Billto_mailaddress_countrycode String The country code of the mailing address for the billing contact.
Message String A message or note associated with the PO Document.
Prrecordkey Long The key identifying the associated record in a related process.
Invbatchkey String The inventory batch key associated with the PO Document.
Prinvbatchkey String The previous inventory batch key linked to the PO Document.
Addglbatchkey String The GL batch key for additional processing related to the PO Document.
Printed String Indicates whether the PO Document has been printed.
Backorder String Indicates if there are backorders related to the PO Document.
Subtotal Decimal The subtotal amount for the PO Document.
Total Decimal The total amount for the PO Document, including taxes and other charges.
Entglgroup Long The entity GL group associated with the PO Document.
Currency String The default currency for the PO Document.
Exchratedate Date The date for the applied exchange rate in the PO Document.
Exchratetypes_name String The name of the exchange rate type applied to the PO Document.
Exchrate Decimal The exchange rate applied to the PO Document.
Schopkey String The scheduling operation key related to the PO Document.
Salescontract String Indicates if a sales contract is associated with the PO Document.
Usedascontract String Indicates if the PO Document is used as a contract.
Trx_subtotal Decimal The transaction subtotal amount for the PO Document.
Trx_total Decimal The transaction total amount for the PO Document, including all charges.
Exch_rate_type_id String The ID of the exchange rate type applied to the PO Document.
Reneweddoc String Indicates if the PO Document has been renewed.
Basecurr String The base currency for the PO Document.
Systemgenerated String Indicates if the PO Document was system-generated.
Invoicerunkey Long The key identifying the invoice run associated with the PO Document.
Docpar_in_out String Indicates if the PO Document increases or decreases inventory.
Whenposted Date The date the PO Document was posted to the general ledger.
Printeduserid String The ID of the user who last delivered the PO Document.
Dateprinted Datetime The date the PO Document was last delivered or printed.
Printedby Long The ID of the user who printed the PO Document.
Adj Bool Indicates if the PO Document contains adjustments.
Taxsolutionid String The ID of the tax solution applied to the PO Document.
Delivertokey String The key identifying the delivery contact associated with the PO Document.
Deliverto_contactname String The contact name for the delivery destination associated with the PO Document.
Deliverto_companyname String The company name of the delivery contact associated with the PO Document.
Deliverto_prefix String The prefix (e.g., Mr., Ms.) for the delivery contact associated with the PO Document.
Deliverto_firstname String The first name of the delivery contact associated with the PO Document.
Deliverto_lastname String The last name of the delivery contact associated with the PO Document.
Deliverto_initial String The middle initial of the delivery contact associated with the PO Document.
Deliverto_printas String The name of the delivery contact as it should appear on official documents.
Deliverto_phone1 String The primary phone number of the delivery contact associated with the PO Document.
Deliverto_phone2 String The secondary phone number of the delivery contact associated with the PO Document.
Deliverto_cellphone String The mobile phone number of the delivery contact associated with the PO Document.
Deliverto_pager String The pager number of the delivery contact associated with the PO Document.
Deliverto_fax String The fax number of the delivery contact associated with the PO Document.
Deliverto_email1 String The primary email address of the delivery contact associated with the PO Document.
Deliverto_email2 String The secondary email address of the delivery contact associated with the PO Document.
Deliverto_url1 String The primary website URL of the delivery contact associated with the PO Document.
Deliverto_url2 String The secondary website URL of the delivery contact associated with the PO Document.
Deliverto_visible Bool Indicates whether the delivery contact associated with the PO Document is visible.
Deliverto_mailaddress_address1 String The first line of the mailing address for the delivery contact.
Deliverto_mailaddress_address2 String The second line of the mailing address for the delivery contact.
Deliverto_mailaddress_city String The city of the mailing address for the delivery contact.
Deliverto_mailaddress_state String The state or territory of the mailing address for the delivery contact.
Deliverto_mailaddress_zip String The ZIP or postal code of the mailing address for the delivery contact.
Deliverto_mailaddress_country String The country of the mailing address for the delivery contact.
Deliverto_mailaddress_countrycode String The country code of the mailing address for the delivery contact.
Retainagepercentage String The retainage percentage applied to the PO Document.
Scope String The scope of work or services specified in the PO Document.
Inclusions String Details of items or services included in the PO Document.
Exclusions String Details of items or services excluded from the PO Document.
Terms String The terms and conditions specified in the PO Document.
Schedulestartdate Date The scheduled start date for the PO Document's activities.
Actualstartdate Date The actual start date for the PO Document's activities.
Scheduledcompletiondate Date The scheduled completion date for the PO Document's activities.
Revisedcompletiondate Date The revised completion date for the PO Document's activities.
Substantialcompletiondate Date The date when substantial completion of the PO Document's activities was achieved.
Actualcompletiondate Date The actual completion date for the PO Document's activities.
Noticetoproceed Date The date when the notice to proceed was issued for the PO Document.
Responsedue Date The date by which a response is due for the PO Document.
Executedon Date The date the PO Document was executed.
Scheduleimpact String Indicates if the schedule was impacted due to changes in the PO Document.
Internalrefno String The internal reference number associated with the PO Document.
Internalinitiatedbykey String The key identifying the user who initiated the PO Document internally.
Internalinitiatedby String The name of the user who initiated the PO Document internally.
Internalinitiatedbyname String The full name of the user who initiated the PO Document internally.
Internalverbalbykey String The key identifying the user who provided verbal authorization internally for the PO Document.
Internalverbalby String The name of the user who provided verbal authorization internally for the PO Document.
Internalverbalbyname String The full name of the user who provided verbal authorization internally for the PO Document.
Internalissuedbykey String The key identifying the user who issued the PO Document internally.
Internalissuedby String The name of the user who issued the PO Document internally.
Internalissuedbyname String The full name of the user who issued the PO Document internally.
Internalissuedon Date The date the PO Document was issued internally.
Internalapprovedbykey String The key identifying the user who approved the PO Document internally.
Internalapprovedby String The name of the user who approved the PO Document internally.
Internalapprovedbyname String The full name of the user who approved the PO Document internally.
Internalapprovedon Date The date the PO Document was approved internally.
Internalsignedbykey String The key identifying the user who signed the PO Document internally.
Internalsignedby String The name of the user who signed the PO Document internally.
Internalsignedbyname String The full name of the user who signed the PO Document internally.
Internalsignedon Date The date the PO Document was signed internally.
Internalsource String The internal source system or origin of the PO Document.
Internalsourcerefno String The reference number for the internal source of the PO Document.
Externalrefno String The external reference number associated with the PO Document.
Externalverbalbykey String The key identifying the external user who provided verbal authorization for the PO Document.
Externalverbalby String The name of the external user who provided verbal authorization for the PO Document.
Externalapprovedbykey String The key identifying the external user who approved the PO Document.
Externalapprovedby String The name of the external user who approved the PO Document.
Externalapprovedon Date The date the PO Document was approved externally.
Externalsignedbykey String The key identifying the external user who signed the PO Document.
Externalsignedby String The name of the external user who signed the PO Document.
Externalsignedon Date The date the PO Document was signed externally.
Performancebondrequired Bool Indicates whether a performance bond is required for the PO Document.
Performancebondreceived Bool Indicates whether the performance bond has been received for the PO Document.
Performancebondamount Decimal The amount of the performance bond for the PO Document.
Performancesuretycompanykey String The key identifying the surety company providing the performance bond for the PO Document.
Performancesuretycompany String The name of the surety company providing the performance bond for the PO Document.
Performancesuretycompanyname String The full name of the surety company providing the performance bond for the PO Document.
Paymentbondrequired Bool Indicates whether a payment bond is required for the PO Document.
Paymentbondreceived Bool Indicates whether the payment bond has been received for the PO Document.
Paymentbondamount Decimal The amount of the payment bond for the PO Document.
Paymentsuretycompanykey String The key identifying the surety company providing the payment bond for the PO Document.
Paymentsuretycompany String The name of the surety company providing the payment bond for the PO Document.
Paymentsuretycompanyname String The full name of the surety company providing the payment bond for the PO Document.
Haschange Bool Indicates whether the PO Document has undergone changes.
Revisedtotal Decimal The revised total amount of the PO Document after changes.
Revisedsubtotal Decimal The revised subtotal amount of the PO Document after changes.
Trx_revisedtotal Decimal The revised total transaction amount of the PO Document after changes.
Trx_revisedsubtotal Decimal The revised subtotal transaction amount of the PO Document after changes.
Postedchangestotal Decimal The total amount of changes posted to the PO Document.
Relateddocno String The document number of a related document linked to the PO Document.
Changelognumber Long The number identifying the change log entry for the PO Document.
Projectkey Long The key identifying the project associated with the PO Document.
Project String The project ID associated with the PO Document.
Projectname String The full name of the project associated with the PO Document.
Custvendid String The customer or vendor ID associated with the PO Document.
Custvendname String The full name of the customer or vendor associated with the PO Document.
Trx_totalpaid Decimal The total transaction amount paid for the PO Document.
Totalpaid Decimal The total amount paid for the PO Document, including exchange rate adjustments.
Trx_totalentered Decimal The total transaction amount entered for the PO Document.
Totalentered Decimal The total base amount entered for the PO Document.
Trx_totaldue Decimal The total transaction amount due for the PO Document.
Totaldue Decimal The total base amount due for the PO Document.
Paymentstatus String The payment status of the PO Document.
Needbydate Date The date by which the items or services in the PO Document are needed.
Donotshipbeforedate Date The date before which the items or services in the PO Document should not be shipped.
Donotshipafterdate Date The date after which the items or services in the PO Document should not be shipped.
Promiseddate Date The date the items or services in the PO Document were promised to be delivered.
Contractstartdate Date The start date of the contract related to the PO Document.
Contractenddate Date The end date of the contract related to the PO Document.
Cancelafterdate Date The date after which the PO Document is considered canceled.
Megaentitykey Long The key identifying the mega entity associated with the PO Document.
Megaentityid String The identifier for the mega entity associated with the PO Document.
Megaentityname String The name of the mega entity associated with the PO Document.
Rseminar String Additional seminar-related metadata associated with the PO Document.
Warehouse_recordno [KEY] Long The record number of the warehouse associated with the PO Document.
Userinfo_recordno [KEY] Long The record number of the user information associated with the PO Document.
Contact_contactname [KEY] String The name of the contact associated with the PO Document.
Vendor_recordno [KEY] Long The record number of the vendor associated with the PO Document.
Apbill_recordno [KEY] Long The record number of the accounts payable bill associated with the PO Document.
Project_recordno [KEY] Long The record number of the project associated with the PO Document.
Itemaggregate String Additional aggregated item metadata associated with the PO Document.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175