Purchase Order

Purchase Order's Database

UI Name
Database
Type
Remarks

P/O No

String

Avoid using the same P/O No to prevent overwrite.

E.g.: PO-123456

P/O Key

Number

E.g.: 123456

Last Modified

String

E.g.: 2024-12-19T08:57:37.557

Creditor

String

Creditor must match existing creditor code, and they must be active state.

E.g.: 400-C001

Name

String

E.g.: ABC SUPPLIER

Supplier DO No

String

E.g.: DO-654321

Address [Line 1]

String

E.g.: 123 INDUSTRIAL PARK

Address [Line 2]

String

E.g.: ZONE 4

Address [Line 3]

String

E.g.: CITY, STATE 12345

Address [Line 4]

String

E.g.: null

Date

String

E.g.: 2024-12-19T00:00:00

Branch

String

E.g.: BR001

Credit Term

String

E.g.: NET 30

Purchase Location

String

Must have existing Purchase Location in the accounting system.

E.g.: NY

Purchase Agent

String

E.g.: JOHN SMITH

Ship Via

String

E.g.: AIR

Ship Info

String

E.g.: EXPRESS

Total (ex)

Number

E.g.: 1000

Inclusive

String

E.g.: T

Taxable Amount

Number

E.g.: 100

Tax

Number

E.g.: 10

Currency

String

E.g.: USD

Rate

Number

E.g.: 1.0

Local Total

Number

E.g.: 1100

Total

Number

E.g.: 1100

Sequence

Number

E.g.: 1

Item Code

String

E.g.: ITEM-001

Description

String

E.g.: ITEM DESCRIPTION

Description 2

String

E.g.: ADDITIONAL INFO

Delivery Date

String

E.g.: 2024-12-20T00:00:00

Location

String

E.g.: WAREHOUSE 1

UOM

String

E.g.: PCS

Quantity

Number

Value must be number, and value cannot be negative.

E.g.: 10

Unit Price

Number

Value must be number, and value cannot be negative.

E.g.: 100

Discount

String

E.g.: 10%

C/N Amt.

String

E.g.: 50

Subtotal

Number

E.g.: 900

Subtotal (ex)

Number

E.g.: 800

Detail Tax

Number

E.g.: 80

Ref Document No

String

E.g.: DOC-001

UDF Description 2

String

E.g.: CUSTOM FIELD

Purchase Order's Sample Code

Remember to change any { } to the correct field before proceeding to run the script.

This is a sample SQL, may not be as same as your database.

SELECT TOP (10)
    Doc AS Document,
    DocKey AS DocumentKey,
    LastModified,
    CreditorCode,
    CreditorName,
    InvAddr1,
    InvAddr2,
    InvAddr3,
    InvAddr4,
    DocDate,
    BranchCode,
    DisplayTerm,
    PurchaseLocation,
    PurchaseAgent,
    ShipVia,
    ShipInfo,
    TotalExTax,
    InclusiveTax,
    TaxableAmt,
    Tax,
    CurrencyCode,
    CurrencyRate,
    LocalNetTotal,
    NetTotal,
    Seq,
    ItemCode,
    Description,
    Desc2,
    DeliveryDate,
    Location,
    UOM,
    Qty,
    UnitPrice,
    Discount,
    SubTotal,
    SubTotalExTax,
    DtlTax,
    FromSODocList,
    FurtherDescription,
    LastModified
FROM PurchaseOrders
WHERE LastModified > "{LAST_MODIFIED_DATE_TIME}";
PreviousDebtorNextGood Receive

Last updated