The POP_PO table contains the identifying document information for non-historical purchase orders.
Display Name Purchase Order Work
O/S Name POP10100
Field descriptions: (Required fields appear in bold and are underlined)
PO Number The unique identifying number of the document. (The document should not exist in Purchase Order history.)
PO Status Status assigned to the Purchase Order
1 = POP_POSTATUS_NEW
2 = POP_POSTATUS_RELEASED
3 = POP_POSTATUS_CHANGEORDER
4 = POP_POSTATUS_ RECEIVED
5 = POP_POSTATUS_CLOSED
6 = POP_POSTATUS_CANCELED
Status Group Assigned when the status of the purchase order changes and is used to group Purchase Orders by status types to enable ranging on active (New, Open or Modified) or closed (Canceled or Closed ) purchase orders.
1 = POP_ACTIVE
2 = POP_CLOSED
PO Type Type of Purchase Order
1 = Standard
2 = Drop Ship
3 = Blanket
4 = Blanket Drop Ship
User To Enter The User ID of the current user in the system when the purchase order document was created.
Confirm With Name or Initials of the person in company with whom the order should be authorized or approved
Document Date The date of the document. Changes to this date may also cause the payment terms to recalculate.
Last Edit Date Date the Purchase Order was last modified. This date is not updated when the PO is being printed, even if printing changes the status. It also is not updated when a PO with a New status is received against and the status is changed to Open.
Last Printed Date The last date the Purchase Order was printed.
Promised Date The Promised Date when your vendor promised you would have your merchandise.
Promised Ship Date The Promised Ship Date when your vendor promised to ship your merchandise.
Required Date Required Date by which you must receive the items.
Requisition Date Requisition Date for a Purchase Order.
Shipping Method The assigned shipping method for a purchase order.
Tax Registration Number The tax registration number is stored here. It is for user reference only.
Remaining Subtotal The sum of the originating remaining line item amounts in the related POP_POLine records converted to functional. Originating remaining line item amounts are calculated as follows: Quantity Remaining to Invoice * Originating Unit Cost. Quantity Remaining to Invoice = Quantity Ordered - Quantity Canceled - Posted to Date Invoiced - Unposted Invoiced
Subtotal The total of the originating extended costs of all line items converted to functional.
Trade Discount Amount The amount of the trade discount on this purchase order document.
Freight Amount The freight amount entered for a purchase order
Misc Charges Amount Used for Miscellaneous charges entered on a Purchase Order
Tax Amount The Tax Amount entered on the purchase order document.
Vendor ID The assigned Vendor ID for the purchase order.
Vendor Name The name of the vendor from the PM_Vendor_MSTR table for the Vendor ID assigned.
Minimum Order The Vendor’s Minimum Order Amount in functional.
Vendor Address Code - Purchase Address The Address Code for the Vendor Purchase Address ID
Company ID Company ID in which the Purchase Order was entered. It is used on reports to establish a relation to the Company location addresses. Found in the Company Master table (SY01500)
Primary Billto Address Code Address Code for the Bill To Address ID
Primary Shipto Address Code Address Code for the Ship To Address ID.
Company Name Company Name for the Ship To Address ID.
Contact Contact for the Ship To Address ID
Address 1 Line 1 of the Ship To Address ID
Address 2 Line 2 of the Ship To Address ID
Address 3 Line 3 of the Ship To Address ID
City City for the Ship To Address ID
State State for the Ship To Address ID.
ZipCode The Zip Code for the Ship To Address ID.
Country Code: Country Code to which this address belongs to.
Country Country for the Ship To Address ID
Phone 1 Phone 1 for the Ship To Address ID
Phone 2 Phone 2 Ship To Address ID
Phone 3 Phone 3 Ship To Address ID
Fax The Fax phone number for the Ship To Address ID
Payment Terms ID Used to calculate the Discount Amount Available
Discount Dollar Amount The discount available amount for payment terms when entered by the user and not calculated
Discount Percent Amount Used to determine the Discount Amount Available (Not used if Payment Term ID is being used)
Discount Amount Available The discount amount available for the assigned Payment Term ID
Discount Date The date the discount expires (required if discounts are calculated)
Due Date The date payment is due. It is set to document date if there are no payment terms.
Trade Discount Percent (Precise) Should be set to the percent (%) which will yield :
Trade Discount Percent (Precise) * Subtotal = Trade Discount Amount
Customer Number The assigned customer number for a drop-ship purchase order
Times Printed The number of times the purchase order document has been printed.
Created Date The system date of the first save of the purchase order
Modified Date Updated with system date each time document is saved. (Not updated.)
PO Note ID Array Note Index Array for all purchase order note indexes:
[1] PO Note Index - POP_PONOTEID_PO
[2] Buyer Note Index - POP_PONOTEID_BUYER
[3] Vendor ID Index - POP_PONOTEID_VENDOR
[4] Comment Note Index - POP_PONOTEID_COMMENT
[5] Payment Term ID Note Index - POP_PONOTEID_PAYTERM
Shipping Method Note Index - POP_PONOTEID_SHIPMETHOD
[7] Currency ID Index - POP_PONOTEID_CURRENCY
Tax Schedule Index - POP_PONOTEID_TAXSCHED
[9] Freight Tax Schedule Index - POP_PONOTEID_FREIGHTTAXSCHED
[10] Misc Tax Schedule Index - POP_PONOTEID_MISCTAXSCHED
[11] Contract Number Index - POP_PONOTEID_CONTRACTNUMBER
[12] not used at this time
[13] not used at this time
[14] not used at this time
[15] not used at this time
Comment ID The ID of the comment
Canceled Subtotal The originating extended cost for the canceled quantity for all line items converted to functional.
Currency ID Currency ID of the transaction. If not a multi-currency transaction,
leave blank.
Currency Index Currency index of the transaction. If not a multi-currency transaction,
leave blank.
Rate Type ID Rate Type ID of the transaction. If not a multi-currency transaction,
leave blank.
Exchange Table ID Exchange Table ID of the transaction. If not a multi-currency transaction, leave blank.
Exchange Rate Exchange Rate of the transaction. If not a multi-currency transaction,
leave blank. If there is triangulation and both rates are fixed, this is the originating to euro fixed rate. Otherwise, this is the variable rate.
Exchange Date Exchange Date of the transaction. If not a multi-currency transaction,
leave blank.
Time Time of the transaction, used for exchange rate purposes. If not a multi-currency transaction, leave blank.
Rate Calc Method Rate Calc Method of the transaction. If not a multi-currency transaction, leave blank.
0 = MULTIPLY
1 = DIVIDE
Denomination Exchange Rate Denomination Exchange Rate of the transaction. If there is triangulation, this is the fixed rate. If both rates are fixed, this is the euro to functional fixed rate. If there is no triangulation or a non multi-currency transaction, this is 0.0
MC Transaction State MC Transaction State of the transaction. If not a multi-currency transaction, leave blank. State the transaction was created in.
0 = Euro currency is not created or no denomination currencies are enabled.
1 = Originating is not a denomination; Functional is not a denomination
2 = Originating is not a denomination; Functional is the Euro currency.
3 = Originating is not a denomination; Functional is a denomination.
4 = Originating is a denomination; Functional is not a denomination.
5 = Originating is a denomination; Functional is a denomination.
6 = Originating is a denomination; Functional is the Euro currency.
7 = Originating is the Euro currency; Functional is a denomination.
8 = Originating is the Euro currency; Functional is not a denomination.
Originating Remaining Subtotal The sum of the remaining line item amounts in the related POP_POLine records. Remaining line item amounts are calculated as follows: Quantity Remaining to Invoice * Originating Unit Cost. Quantity Remaining to Invoice = Quantity Ordered - Quantity Canceled - Posted to Date Invoiced - Unposted Invoiced
Originating Subtotal The total of the originating extended costs of all line items.
The following fields must be imported regardless of if Multi-Currency is registered. If the transaction is
not a multi-currency transaction, then fill the field with the same value of the corresponding non-mc
field. Example: If Freight Amount = $3.00, then set Originating Freight Amount to
the same amount. If Freight Amount = $0. Then leave the Originating Freight Amount
Freight blank also.
Originating Canceled Subtotal
Originating Trade Discount Amount
Originating Freight Amount
Originating Misc Charges Amount
Originating Tax Amount
Originating Discount Dollar Amount
Originating Discount Amount Available
Buyer ID The username of the user that entered the POP TRx
On Order Amount The sum of the originating on order amounts in the related POP_POLine records converted to functional. Originating on order amounts are calculated as follows: ( Current Order Qty * Originating Unit Cost ) – Originating Posted Subtotal. Current Order Qty = QTY Ordered - QTY Canceled.
Originating On Order Amount The sum of the originating on order amounts in the related POP_POLine records converted to functional. Originating on order amounts are calculated as follows: ( Current Order Qty * Originating Unit Cost ) – Originating Posted Subtotal. Current Order Qty = QTY Ordered - QTY Canceled.
Hold Designates whether the Purchase Order document is on hold.
0 - False
1 – True
On Hold Date The date the purchase order document was placed on hold.
On Hold By The User ID of the current user in the system at the time the purchase order was placed on hold.
Hold Remove Date The date the purchase order document was taken off hold.
Hold Remove By The User ID of the current user in the system at the time the purchase order was taken off hold status.
Allow SO Commitments This field determines if Sales Order Processing documents are allowed to be committed to this Purchase Order document and whether the items purchased on this Purchase order may be reserved for a specific sales order.
0 - False
1 – True
Discount Grace Period The number of grace period days assigned to the vendor on the purchase order
Due Date Grace Period The due date for the discount grace period
Revision Number Used to print revision number on a revised PO. Leave empty for importing
Change Order Flag Will determine if “Change Order will print next time the order is printed. Leave empty for importing
PO Field Changes Used to determine which items have changes since the last time the PO was printed. Leave empty for importing
PO Status Orig The status of the PO
1 – New
2 – Released
3 – Change Order
4 – Received
5 – Closed
6 – Canceled
Tax Schedule ID: Default tax schedule used for transactions. The tax schedule should exist in the TX_Schedule_MSTR file.
Tax Schedule Source: Source of the tax schedule, the following source and constants are available.
Drop Ship - POP_POTAXSCHEDSOURCE_NONE
Vendor - POP_POTAXSCHEDSOURCE_PURCH
Company - POP_POTAXSCHEDSOURCE_COMPANY
Setup Single Tax Schedule - POP_POTAXSCHEDSOURCE_SINGLE
Tax Engine Called: Set to true. This field indicates whether the tax engine has been run.
Based On Invoice Total: This field contains information regarding whether the line item contains taxes which are based on the invoice total.
True = Line items contains taxes based on invoice total.
False = Line item does not contain taxes based on invoice total.
Purchase Freight Taxable: Value indicating how Freight amounts are taxed.
1 – Taxable
2 – Nontaxable
3 – Base on Vendor
Purchase Misc Taxable: Value indicating how Miscellaneous amounts are taxed.
1 – Taxable
2 – Nontaxable
3 – Base on Vendor
Freight Schedule ID: The schedule masked against the Tax Schedule ID to determine which tax details are applicable for the freight amount field. There must be a record in the TX_Schedule_MSTR file with this ID.
Misc Schedule ID:
Freight Tax Amount: The tax amount from the ‘Freight Amount’ field. This field is needed for backing out tax included with item price.
Originating Freight Tax Amount: The tax amount from the ‘Freight Amount’ field in the Originating Currency. Set to Freight Tax Amount for non-MC transactions.
Misc Tax Amount: The tax amount from the ‘Misc Charges Amount’ field. This field is needed for backing out tax included with item price.
Originating Misc Tax Amount: The tax amount from the ‘Misc Charges Amount’ field in the Originating Currency. Set to Misc Tax Amount for non-MC transactions.
Backout Tax Amount If there is a tax included with item price detail, this is the amount of the backout tax.
Originating Backout Tax Amount: This field must be imported regardless of if Multi-Currency is registered. If the transaction is not a multi-currency transaction, then fill the field with the same value of the corresponding non-MC field.
Backout Freight Tax Amount:
Originating Backout Freight Tax Amount:
Backout Misc Tax Amount:
Originating Backout Misc Tax Amount:
Flags: The Flags field is used to determine if the address attributes have been modified.
Backout Trade Discount Tax Amount: Amount of “Tax Included in Item Price” associated with the Trade Discount Amount.
Originating Backout Trade Discount
Tax Amount: Amount of “Tax Included in Item Price” associated with the Originating Trade Discount Amount.
POP Contract Number: Contract Number assigned to this Purchase Order.
Contract End Date: Date the contract will expire.
Control Blanket By: Blanket PO can be controlled by Item Quantities or Item Value. The following constants are provided.
POP_PO_CONTROL_BLANKET_BY_QTY - 0
POP_PO_CONTROL_BLANKET_BY_VALUE - 1
Purchase Company Name: Purchase Address Company Name
Purchase Contact: Purchase Address Contact
Purchase Address 1: Purchase Address 1
Purchase Address 2: Purchase Address 2
Purchase Address 3: Purchase Address 3
Purchase City: Purchase Address City
Purchase State: Purchase Address State
Purchase Zip Code: Purchase Address Zip Code
Purchase Country Code: Purchase Address Country Code
Purchase Country: Purchase Address Country
Purchase Phone 1: Purchase Address Phone 1
Purchase Phone 2: Purchase Address Phone 2
Purchase Phone 3: Purchase Address Phone 3
Purchase Fax: Purchase Address Fax
Total Blanket Line Ext Qty: Sum of all the Blanket Detail Line Quantities in Base U of M.
Cash Based VAT: True or False depending on whether the vendor is a cash based VAT or not.