PurchaseOrderslines
PurchaseOrderslines
Columns
Name | Type | Description |
PurchaseOrdersPOHeaderId [KEY] | Long | PurchaseOrdersPOHeaderId of PurchaseOrderslines |
POLineId [KEY] | Long | POLineId of PurchaseOrderslines |
POHeaderId | Long | POHeaderId of PurchaseOrderslines |
LineNumber | Decimal | LineNumber of PurchaseOrderslines |
OrderNumber | String | OrderNumber of PurchaseOrderslines |
LineTypeId | Long | LineTypeId of PurchaseOrderslines |
LineType | String | LineType of PurchaseOrderslines |
ItemId | Long | ItemId of PurchaseOrderslines |
Item | String | Item of PurchaseOrderslines |
ConsignmentLineFlag | Bool | ConsignmentLineFlag of PurchaseOrderslines |
ItemRevision | String | ItemRevision of PurchaseOrderslines |
Description | String | Description of PurchaseOrderslines |
SupplierItem | String | SupplierItem of PurchaseOrderslines |
SupplierConfigurationId | String | SupplierConfigurationId of PurchaseOrderslines |
CategoryId | Long | CategoryId of PurchaseOrderslines |
CategoryCode | String | CategoryCode of PurchaseOrderslines |
Category | String | Category of PurchaseOrderslines |
StatusCode | String | StatusCode of PurchaseOrderslines |
Status | String | Status of PurchaseOrderslines |
UOMCode | String | UOMCode of PurchaseOrderslines |
UOM | String | UOM of PurchaseOrderslines |
Quantity | Decimal | Quantity of PurchaseOrderslines |
BasePrice | Decimal | BasePrice of PurchaseOrderslines |
DiscountType | String | DiscountType of PurchaseOrderslines |
Discount | Decimal | Discount of PurchaseOrderslines |
DiscountReason | String | DiscountReason of PurchaseOrderslines |
Price | Decimal | Price of PurchaseOrderslines |
NegotiatedFlag | Bool | NegotiatedFlag of PurchaseOrderslines |
CurrencyCode | String | CurrencyCode of PurchaseOrderslines |
Currency | String | Currency of PurchaseOrderslines |
WorkOrderProduct | String | WorkOrderProduct of PurchaseOrderslines |
NoteToSupplier | String | NoteToSupplier of PurchaseOrderslines |
UNNumberId | Long | UNNumberId of PurchaseOrderslines |
UNNumber | String | UNNumber of PurchaseOrderslines |
UNNumberDescription | String | UNNumberDescription of PurchaseOrderslines |
HazardClassCode | String | HazardClassCode of PurchaseOrderslines |
HazardClassId | Long | HazardClassId of PurchaseOrderslines |
HazardClass | String | HazardClass of PurchaseOrderslines |
Ordered | Decimal | Ordered of PurchaseOrderslines |
TotalTax | Decimal | TotalTax of PurchaseOrderslines |
Total | Decimal | Total of PurchaseOrderslines |
SourceAgreementId | Long | SourceAgreementId of PurchaseOrderslines |
SourceAgreementNumber | String | SourceAgreementNumber of PurchaseOrderslines |
SourceAgreementLineId | Long | SourceAgreementLineId of PurchaseOrderslines |
SourceAgreementLine | Decimal | SourceAgreementLine of PurchaseOrderslines |
SourceAgreementTypeCode | String | SourceAgreementTypeCode of PurchaseOrderslines |
SourceAgreementType | String | SourceAgreementType of PurchaseOrderslines |
SourceAgreementProcurementBUId | Long | SourceAgreementProcurementBUId of PurchaseOrderslines |
SourceAgreementProcurementBU | String | SourceAgreementProcurementBU of PurchaseOrderslines |
MaximumRetainageAmount | Decimal | MaximumRetainageAmount of PurchaseOrderslines |
Manufacturer | String | Manufacturer of PurchaseOrderslines |
ManufacturerPartNumber | String | ManufacturerPartNumber of PurchaseOrderslines |
CreationDate | Datetime | CreationDate of PurchaseOrderslines |
CreatedBy | String | CreatedBy of PurchaseOrderslines |
LastUpdateDate | Datetime | LastUpdateDate of PurchaseOrderslines |
LastUpdatedBy | String | LastUpdatedBy of PurchaseOrderslines |
PricingUOM | String | PricingUOM of PurchaseOrderslines |
PricingUOMCode | String | PricingUOMCode of PurchaseOrderslines |
SecondaryUOM | String | SecondaryUOM of PurchaseOrderslines |
SecondaryUOMCode | String | SecondaryUOMCode of PurchaseOrderslines |
SecondaryQuantity | String | SecondaryQuantity of PurchaseOrderslines |
Finder | String | Finder of PurchaseOrderslines |
Intent | String | Intent of PurchaseOrderslines |
SysEffectiveDate | String | SysEffectiveDate of PurchaseOrderslines |