Bewerken: Purchase

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id | UltimoString | PCHID | 9 | false |  |
| Account | Account | PCHACCID |  | true |  |
| AdviceDate | DateTime? | PCHADVICEDATE |  | true |  |
| AdviceEmployee | Employee | PCHADVICEEMPID |  | true |  |
| BookDate | Date? | PCHBOOKDATE |  | true |  |
| Comment1 | UltimoString | PCHCMNT1 | 41 | true |  |
| Comment2 | UltimoString | PCHCMNT2 | 41 | true |  |
| Contact | Employee | PCHCONTACTEMPID |  | true |  |
| Context | Context | PCHCONTEXT |  | false | 1 |
| CostCenter | CostCenter | PCHCCRID |  | true |  |
| Currency | Currency | PCHCURID |  | false |  |
| CurrencyConversionFactor | Int16 | PCHCURCONVFACTOR |  | false |  |
| CurrencyRate | Decimal | PCHCURRATE |  | false |  |
| DataProvider | UltimoString | PCHDATAPROVIDER | 50 | true |  |
| DeliveryAddress | DeliveryAddress | PCHDLVAID |  | true | A |
| DeliveryDate | Date? | PCHDLVDATE |  | true |  |
| DeliveryTerms | DeliveryTerms | PCHDLVTID |  | true |  |
| Department | Department | PCHDEPID |  | true |  |
| Description | UltimoString | PCHDESCR | 200 | true |  |
| Exported | Boolean | PCHEXPORTED |  | false |  |
| ExternalId | UltimoString | PCHEXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | PCHEXTERNALSTATUS | 50 | true |  |
| Extra1 | Int16 | PCHEXTRA1 |  | false |  |
| Extra2 | Int16 | PCHEXTRA2 |  | false |  |
| Extra3 | Int32 | PCHEXTRA3 |  | false |  |
| Extra4 | Int32 | PCHEXTRA4 |  | false |  |
| Extra5 | UltimoString | PCHEXTRA5 | 15 | true |  |
| Extra6 | UltimoString | PCHEXTRA6 | 15 | true |  |
| Extra7 | UltimoString | PCHEXTRA7 | 15 | true |  |
| InvoiceLines | List[InvoiceLine] | INVLPCHID |  | true |  |
| Job | Job | PCHJOBID |  | true |  |
| Language | Language | PCHLNGID |  | true |  |
| NowInvoice | CompanyMoney | PCHNOWINV |  | false | 0 |
| NowInvoiceIncludingVat | CompanyMoney | PCHNOWINVINCLVAT |  | false | 0 |
| NumberOfLines | Int32 | PCHNUMBEROFLINES |  | false | 0 |
| PaymentTerms | PaymentTerms | PCHPYMTID |  | true |  |
| ProviderMutationDate | DateTime? | PCHPROVIDERMUTDATE |  | true |  |
| PurchaseLines | List[PurchaseLine] | PCHLPCHID |  | false |  |
| PurchaseMethod | PurchaseMethod | PCHPCHMID |  | true | S |
| Receipts | List[Receipt] | RCPPCHID |  | true |  |
| RecordChangeDate | DateTime? | PCHRECCHANGEDATE |  | true |  |
| RecordCreateDate | DateTime? | PCHRECCREATEDATE |  | true | SYSDATETIME |
| Reference | UltimoString | PCHREFERENCE | 41 | true |  |
| RequestEmployee | Employee | PCHREQUESTEMPID |  | true |  |
| Site | Site | PCHSITID |  | true |  |
| StandardTotalPriceIncludingVat | CompanyMoney | PCHSTDTOTPRICEINCLVAT |  | false | 0 |
| StandardVatPrice | CompanyMoney | PCHSTDVATPRICE |  | false | 0 |
| Status | Status | PCHRECSTATUS |  | false |  |
| StatusActiveDate | DateTime? | PCHDATE |  | true |  |
| StatusActiveEmployee | Employee | PCHEMPID |  | true |  |
| StatusApprovedDate | DateTime? | PCHAPPRVDATE |  | true |  |
| StatusApprovedEmployee | Employee | PCHAPPRVEMPID |  | true |  |
| StatusCanceledDate | DateTime? | PCHCANCELDATE |  | true |  |
| StatusCanceledEmployee | Employee | PCHCANCELEMPID |  | true |  |
| StatusClosedDate | DateTime? | PCHCLOSEDATE |  | true |  |
| StatusClosedEmployee | Employee | PCHCLOSEEMPID |  | true |  |
| StatusConceptualDate | DateTime? | PCHCONCEPTDATE |  | true |  |
| StatusConceptualEmployee | Employee | PCHCONCEPTEMPID |  | true |  |
| StatusCreatedDate | DateTime? | PCHCREATEDDATE |  | true | SYSDATETIME |
| StatusCreatedEmployee | Employee | PCHCREATEDEMPID |  | true | USERID |
| StatusPartialReceivedDate | DateTime? | PCHPARTRECEIVEDDATE |  | true |  |
| StatusPartialReceivedEmployee | Employee | PCHPARTRECEIVEDEMPID |  | true |  |
| StatusReceivedDate | DateTime? | PCHRECEIVEDDATE |  | true |  |
| StatusReceivedEmployee | Employee | PCHRECEIVEDEMPID |  | true |  |
| SystemCompany | Company | PCHCOMPID |  | false |  |
| TenderRequest | RequestForQuotation | PCHRFQID |  | true |  |
| Text | UltimoString | PCHTEXT |  | true |  |
| Total | CompanyMoney | PCHTOTAL |  | false | 0 |
| TransferNextTime | Boolean | PCHTRANSFERNEXTTIME |  | false |  |
| UseFixedExchangeRate | Boolean | PCHUSEFIXEDEXCHANGERATE |  | false | 1 |
| Vendor | Vendor | PCHVDRID |  | true |  |
| Warehouse | Warehouse | PCHWHSID |  | true |  |