PO Sync

EBJ_BUSCODE

String

32

Yes

No

The Plant Business Code

EBJ_ITEMNO

String

128

Yes

No

Item Code

OrderNum

String

32

Yes

No

Purchase Order Number

OrderLineNum

Number

N/A

Yes

No

Purchase Order Line Number

OrderReleaseNum

String

32

No

Yes

Purchase Order Release Line Number

OrderReleaseLineNum

String

32

No

Yes

Purchase Order Release Line Number

H_EffectiveFrom

DateTime

N/A

No

Yes

Header Effective From

H_EffectiveTo

DateTime

N/A

No

Yes

Header Effective To

H_OrderCrTime

DateTime

N/A

No

Yes

PO Header Creation Time

H_OrderCreatedBy

String

128

No

Yes

PO Created By User Login Name

H_POType

String

32

No

Yes

PO Type: STANDARD or BLANKET

H_ShipViaCode

String

64

No

Yes

PO Ship Via Code/ Carrier Value

H_FOBCode

String

64

No

Yes

PO Header FOB Code

H_FreightTermsCode

String

64

No

Yes

PO Freight Terms

H_NoteToAuthorizer

String

512

No

Yes

Note to Authorizer

H_NoteToVendor

String

1024

No

Yes

Note to Vendor

H_NoteToReceiver

String

1024

No

Yes

Note to Receiver

H_Comments

String

512

No

Yes

Purchase Order Comments

H_CurrencyCode

String

16

No

Yes

Currency Code. Eg.USD. Must be valid ISO Currency Code

H_BlanketTotalAmt

Number

N/A

No

Yes

Total amount for Blanket Purchase Order

H_AuthStatus

String

32

No

Yes

PO Authorization Status

H_RevisionNum

Number

N/A

No

Yes

PO Revision Number

H_RevisedDate

DateTime

N/A

No

Yes

PO Revision Date

H_ApprovedDate

DateTime

N/A

No

Yes

PO Approved Date

H_AcceptanceReqdFlag

String

2

No

Yes

PO Acceptance flag. 'Y' or 'N'

H_AcceptanceDueDate

DateTime

N/A

No

Yes

Due date for PO Acceptance

H_ClosedDate

DateTime

N/A

No

Yes

Purchase Order Closed date.

H_FrozenFlag

String

2

No

Yes

PO is on hold/frozen. 'Y' or 'N'

H_Attribute1

String

256

No

Yes

Extra value at PO Header document level

H_Attribute2

String

256

No

Yes

Extra value at PO Header document level

H_Attribute3

String

256

No

Yes

Extra value at PO Header document level

H_Attribute4

String

256

No

Yes

Extra value at PO Header document level

H_Attribute5

String

256

No

Yes

Extra value at PO Header document level

H_ClosedCode

String

32

No

Yes

PO Closed Code

H_ReferenceNum

String

64

No

Yes

Reference Number for Purchase Order

H_ConsignedConsumptionFlag

String

2

No

Yes

PO Consignment Consumption Flag. 'Y' or 'N'

H_VendorCode

String

32

Yes

No

Vendor Code

H_VendorSiteCode

String

32

No

Yes

Vendor Site Code

H_SupplierContactLastName

String

64

No

Yes

Supplier contact (Last Name)

H_SupplierContactFirstName

String

64

No

Yes

Supplier contact (First Name)

H_PaymentTermsCode

String

128

No

Yes

PO Payment Terms Code

H_PaymentTermsDescription

String

512

No

Yes

PO Payment Terms Description

H_DeliverToPerson

String

128

No

Yes

Deliver to person name

H_BuyerAgentName

String

128

No

Yes

Ultriva login name should match with buyer agent login name.

L_CreationDate

DateTime

N/A

No

Yes

Purchase Order Line Creation Date

L_CreatedBy

String

128

No

Yes

PO Line Created By User Login Name

L_ItemRevision

String

8

No

Yes

PO Line Item Revision No.

L_ItemDescription

String

512

No

Yes

PO Line Item Description

L_UnitDescription

String

32

Yes

No

PO Line Item Unit Description

L_QuantityCommitted

Number

N/A

No

Yes

PO Line Quantity Committed

L_CommittedAmount

Number

N/A

No

Yes

PO Line Committed Amount

L_UnitPrice

Number

N/A

Yes

No

PO Line Unit Price

L_Quantity

Number

N/A

Yes

No

PO Line Quantity

L_NoteToVendor

String

1024

No

Yes

PO Line (Note to Vendor)

L_ClosedFlag

String

2

No

Yes

PO Line Closed

L_CancelFlag

String

2

No

Yes

PO Line Cancel Flag. 'Y' or 'N'

L_CancelledBy

String

128

No

Yes

PO Line Cancelled By User Login Name

L_CancelDate

DateTime

N/A

No

Yes

PO Line Cancel Date

L_CancelReason

String

512

No

Yes

PO Line Cancellation Reason

L_Attribute1

String

256

No

Yes

Extra value at PO Line level

L_Attribute2

String

256

No

Yes

Extra value at PO Line level

L_Attribute3

String

256

No

Yes

Extra value at PO Line level

L_Attribute4

String

256

No

Yes

Extra value at PO Line level

L_Attribute5

String

256

No

Yes

Extra value at PO Line level

L_ReferenceNum

String

64

No

Yes

PO Line Reference No

L_ClosedCode

String

32

No

Yes

PO Line Closed Code

L_ClosedDate

DateTime

N/A

No

Yes

PO Line Closed Date

L_ClosedReason

String

256

No

Yes

PO Line Closed Reason

L_ClosedBy

String

128

No

Yes

PO Line Closed By User Login Name

L_ProjectCode

String

64

No

Yes

Project Code value at PO line level

L_ExpirationDate

DateTime

N/A

No

Yes

PO Line Expiration Date

R_ReleaseDate

DateTime

N/A

No

Yes

Purchase Order Release Date(Blanket PO Releases)

R_CreationDate

DateTime

N/A

No

Yes

PO Release Creation Date

R_CreatedBy

String

128

No

Yes

PO Release Created By User Login Name

R_RevisionNum

Number

N/A

No

Yes

PO Release Revision Num

R_RevisedDate

DateTime

N/A

No

Yes

PO Release Revised Date

R_ApprovedDate

DateTime

N/A

No

Yes

PO Release Approved Date

R_AcceptanceRequiredFlag

String

2

No

Yes

PO Release Acceptance Required.'Y' or 'N'

R_AcceptanceDueDate

DateTime

N/A

No

Yes

PO Release Acceptance Due Date

R_CancelFlag

String

2

No

Yes

PO Release Cancel Flag. 'Y' or 'N'

R_CancelledBy

String

128

No

Yes

PO Release Cancelled By User Login Name

R_CancelDate

DateTime

N/A

No

Yes

PO Release Cancel Date

R_CancelReason

String

512

No

Yes

PO Release Cancellation Reason

R_Attribute1

String

256

No

Yes

Extra value at PO Release level

R_Attribute2

String

256

No

Yes

Extra value at PO Release level

R_Attribute3

String

256

No

Yes

Extra value at PO Release level

R_Attribute4

String

256

No

Yes

Extra value at PO Release level

R_Attribute5

String

256

No

Yes

Extra value at PO Release level

R_AuthorizationStatus

String

32

No

Yes

PO Release Authorization Status

R_ClosedCode

String

32

No

Yes

PO Release Closed Code

R_ReleaseType

String

32

No

Yes

PO Release Type

R_NoteToVendor

String

1024

No

Yes

PO Release (Note to Vendor)

S_CreationDate

DateTime

N/A

No

Yes

PO Shipment line Creation Date

S_CreatedBy

String

128

No

Yes

PO Shipment line created by user login name

S_Quantity

Number

N/A

No

Yes

PO Shipment Line Quantity

S_QuantityReceived

Number

N/A

No

Yes

PO Shipment Line Received Qty.

S_QuantityAccepted

Number

N/A

No

Yes

PO Shipment Line Accepted Qty.

S_QuantityRejected

Number

N/A

No

Yes

PO Shipment Line Rejected Qty.

S_QuantityBilled

Number

N/A

No

Yes

PO Shipment Line Billed Qty.

S_QuantityCancelled

Number

N/A

No

Yes

PO Shipment Line Cancelled Qty.

S_ShipCode

String

64

No

Yes

PO Shipment Line Ship Code

S_NeedByDate

DateTime

N/A

No

Yes

PO Shipment Line Need By Date

S_PromisedDate

DateTime

N/A

No

Yes

PO Shipment Line Promised Date

S_PriceOverride

Number

N/A

No

Yes

Price OverRide

S_FOBCode

String

64

No

Yes

PO Shipment Line FOB Code

S_FreightTermsCode

String

64

No

Yes

PO Shipment Line Freight Terms Code

S_ApprovedDate

DateTime

N/A

No

Yes

PO Shipment Line Approved Date

S_ClosedFlag

String

2

No

Yes

PO Shipment Line Closed Flag.'Y' or 'N'

S_CancelFlag

String

2

No

Yes

PO Shipment Line Cancel Flag.'Y' or 'N'

S_CancelledBy

String

128

No

Yes

PO Shipment Line Cancelled By User Login Name

S_CancelDate

DateTime

N/A

No

Yes

PO Shipment Line Cancel Date

S_CancelReason

String

512

No

Yes

PO Shipment Line Cancellation Reason

S_Attribute1

String

256

No

Yes

Extra value at PO Shipment Line level

S_Attribute2

String

256

No

Yes

Extra value at PO Shipment Line level

S_Attribute3

String

256

No

Yes

Extra value at PO Shipment Line level

S_Attribute4

String

256

No

Yes

Extra value at PO Shipment Line level

S_Attribute5

String

256

No

Yes

Extra value at PO Shipment Line level

S_ShipmentType

String

32

No

Yes

PO Shipment Line Type

S_ClosedCode

String

32

No

Yes

PO Shipment Line Closed Code

S_AccrueOnReceiptFlag

String

2

No

Yes

PO Shipment Line Accrue on Receipt Flag.'Y' or 'N'

S_ClosedReason

String

512

No

Yes

PO Shipment Line Closed Reason

S_ClosedDate

DateTime

N/A

No

Yes

PO Shipment Line Closed Date

S_ClosedBy

String

128

No

Yes

PO Shipment Line Closed By User Login Name

S_QuantityShipped

Number

N/A

No

Yes

PO Shipment Line Shipped Qty.

S_ChangePromiseDateReason

String

512

No

Yes

PO Shipment Line Change Promised Date Reason

S_NoteToReceiver

String

1024

No

Yes

PO Shipment Line (Note to Receiver)

S_ConsignedFlag

String

2

No

Yes

PO Shipment Line Consigned Flag. 'Y' or 'N'

S_Amount

Number

N/A

No

Yes

PO Shipment Line Amount

S_ShipmentClosedDate

DateTime

N/A

No

Yes

PO Shipment Line Closed Date

S_ClosedForReceivingDate

DateTime

N/A

No

Yes

PO Shipment Line Closed for Receiving Date

S_ClosedForInvoiceDate

DateTime

N/A

No

Yes

PO Shipment Line Closed for Invoice Date

S_TaxableFlag

String

2

No

Yes

PO Shipment Line Taxable Flag. 'Y' or 'N'