Bewerken: PurchaseLine

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id.LineId | UltimoString | PCHLLINEID | 4 | false |  |
| Id.Purchase | Purchase | PCHLPCHID |  | false |  |
| Account | Account | PCHLACCID |  | true |  |
| Article | Article | PCHLARTID |  | true |  |
| ArticleVendorPurchaseCode | UltimoString | PCHLARTVDRPURCHCODE | 60 | true |  |
| ArticleWarehouseLocation | ArticleWarehouseLocation | PCHLARTWHSLARTID, PCHLARTWHSLWHSLWHSID, PCHLARTWHSLWHSLCODE |  | true | , ,  |
| BookCostOnServiceContract | Boolean | PCHLBOOKCOSTONSVC |  | false | 0 |
| CalculatedArticlePreparationQuantity | Decimal | PCHLCALCARTPREPQUANTITY |  | false |  |
| CalculatedArticlePurchaseQuantity | Decimal | PCHLCALCARTPURCHQUANTITY |  | false |  |
| CalculatedArticleRepairQuantity | Decimal | PCHLCALCARTREPQUANTITY |  | false |  |
| CalculateDeliveryDate | Boolean | PCHLCALCULATEDLVDATE |  | false |  |
| Call | UltimoString | PCHLCALL | 2 | true |  |
| Charge | Boolean | PCHLCHARGE |  | false | 0 |
| ChargeRaise | Raise | PCHLCHARGERSEID |  | true |  |
| Concept | Int16 | PCHLCONCEPT |  | false |  |
| Context | Context | PCHLCONTEXT |  | false |  |
| CostCenter | CostCenter | PCHLCCRID |  | true |  |
| Costs | List[Cost] | CSTPCHID, CSTPCHLID |  | true | ,  |
| CostType | CostType | PCHLCSTTID |  | true |  |
| Currency | Currency | PCHLCURID |  | false |  |
| Customer | Customer | PCHLCUSID |  | true |  |
| DataProvider | UltimoString | PCHLDATAPROVIDER | 50 | true |  |
| DeliveryDate | Date? | PCHLDLVDATE |  | true |  |
| Department | Department | PCHLDEPID |  | true |  |
| Description | UltimoString | PCHLDESCR | 200 | true |  |
| Discount | Decimal | PCHLDISCOUNT |  | false |  |
| Equipment | Equipment | PCHLEQMID |  | true |  |
| Exported | Boolean | PCHLEXPORTED |  | false |  |
| ExternalId | UltimoString | PCHLEXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | PCHLEXTERNALSTATUS | 50 | true |  |
| Extra1 | Int16 | PCHLEXTRA1 |  | false |  |
| Extra2 | Int16 | PCHLEXTRA2 |  | false |  |
| Extra3 | Int32 | PCHLEXTRA3 |  | false |  |
| Extra4 | Int32 | PCHLEXTRA4 |  | false |  |
| Extra5 | UltimoString | PCHLEXTRA5 | 15 | true |  |
| Extra6 | UltimoString | PCHLEXTRA6 | 15 | true |  |
| Extra7 | UltimoString | PCHLEXTRA7 | 15 | true |  |
| GrossPrice | TransactionMoney | PCHLGROSSPRICE |  | false | 0 |
| GrossTotalPrice | TransactionMoney | PCHLGROSSTOTPRICE |  | false | 0 |
| InputToReceiveQuantity | Decimal | PCHLINPTORCVQTY |  | false |  |
| InvoiceLine | InvoiceLine | PCHLINVID, PCHLINVLLINEID |  | true | ,  |
| InvoiceLines | List[InvoiceLine] | INVLPCHID, INVLPCHLID |  | true | ,  |
| InvoicePrice | CompanyMoney | PCHLINVPRICE |  | false | 0 |
| InvoiceQuantity | Decimal | PCHLINVQTY |  | false |  |
| Job | Job | PCHLJOBID |  | true |  |
| LeadTime | Int32 | PCHLLEADTIME |  | false |  |
| Price | TransactionMoney | PCHLPRICE |  | false | 0 |
| ProcessFunction | ProcessFunction | PCHLPRFID |  | true |  |
| Project | Project | PCHLPRJID |  | true |  |
| ProviderMutationDate | DateTime? | PCHLPROVIDERMUTDATE |  | true |  |
| PurchaseQuantity | Decimal | PCHLPURCHQTY |  | false | 1 |
| PurchaseRequestLines | List[PurchaseRequestLine] | PCHRLPCHID, PCHRLPCHLID |  | true | ,  |
| QuantityPurchaseUnit | Decimal | PCHLQTYPURCHUNT |  | false | 1 |
| ReceiptLine | ReceiptLine | PCHLRCPID, PCHLRCPLLINEID |  | true | ,  |
| ReceivedQuantity | Decimal | PCHLRCVQTY |  | false |  |
| RecordChangeDate | DateTime? | PCHLRECCHANGEDATE |  | true |  |
| RecordCreateDate | DateTime? | PCHLRECCREATEDATE |  | true | SYSDATETIME |
| RemainingCommitExcludingVat | CompanyMoney | PCHLREMAININGCOMMITEXCLVAT |  | false | 0 |
| RemainingCommitIncludingVat | CompanyMoney | PCHLREMAININGCOMMITINCLVAT |  | false | 0 |
| Repair | Boolean | PCHLREPAIR |  | false | 0 |
| Return | Decimal | PCHLRETOUR |  | false |  |
| ReturnToReceiveQuantity | Decimal | PCHLRETTORCVQTY |  | false |  |
| ServiceContractLine | ServiceContractLine | PCHLSVCID, PCHLSVCLLINEID |  | true | ,  |
| Site | Site | PCHLSITID |  | true |  |
| SkillCategory | SkillCategory | PCHLSKCID |  | true |  |
| StandardTotalCreditInvoicePrice | CompanyMoney | PCHLSTDTOTCREDINVPRICE |  | false | 0 |
| StandardTotalCreditInvoicePriceIncludingVat | CompanyMoney | PCHLSTDTOTCRDINVPRINCLVAT |  | false | 0 |
| StandardTotalCreditInvoiceQuantity | Decimal | PCHLSTDTOTCREDINVQTY |  | false |  |
| StandardTotalInvoicePrice | CompanyMoney | PCHLSTDTOTINVPRICE |  | false | 0 |
| StandardTotalInvoicePriceIncludingVat | CompanyMoney | PCHLSTDTOTINVPRICEINCLVAT |  | false | 0 |
| StandardTotalPrice | CompanyMoney | PCHLSTDTOTPRICE |  | false | 0 |
| StandardTotalPriceIncludingVat | CompanyMoney | PCHLSTDTOTPRICEINCLVAT |  | false | 0 |
| StandardVatPrice | CompanyMoney | PCHLSTDVATPRICE |  | false | 0 |
| Status | Status | PCHLRECSTATUS |  | false |  |
| StockArticle | Boolean | PCHLSTOCKART |  | false | 0 |
| SystemCompany | Company | PCHLCOMPID |  | false |  |
| Text | UltimoString | PCHLTEXT |  | true |  |
| Tool | UltimoString | PCHLTLS | 2 | true |  |
| ToReceiveQuantity | Decimal | PCHLTORCVQTY |  | false |  |
| TotalPrice | TransactionMoney | PCHLTOTPRICE |  | false | 0 |
| TotalPriceIncludingVat | TransactionMoney | PCHLTOTPRICEINCLVAT |  | false | 0 |
| TransferNextTime | Boolean | PCHLTRANSFERNEXTTIME |  | false |  |
| UnitDescription | UltimoString | PCHLUNTDESCR | 9 | true |  |
| Vat | Vat | PCHLVATID |  | true |  |
| VatPercentage | Decimal | PCHLVATPERCENTAGE |  | false |  |
| VatPrice | TransactionMoney | PCHLVATPRICE |  | false | 0 |
| Vendor | Vendor | PCHLVDRID |  | true |  |
| Warehouse | Warehouse | PCHLWHSID |  | true |  |