PurchaseOrderLines: Exact Online Inkooporderregels |
Catalogus: ExactOnlineREST
Schema: PurchaseOrder
Primaire Sleutels: ID
Label: Inkooporderregels
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel PurchaseOrderLines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
AmountDC |
double |
Bedrag Administratie Munteenheid |
☐ |
Amount in the default currency of the company. |
AmountFC |
double |
Bedrag Vreemde Valuta |
☐ |
Amount in the currency of the transaction. |
CostCenter |
string(8) |
Kostenplaats |
☐ |
Reference to Cost center. |
CostCenterDescription |
string(60) |
Kostenplaats Omschrijving |
☐ |
Description of CostCenter. |
CostUnit |
string(8) |
Kostendrager |
☐ |
Reference to Cost unit. |
CostUnitDescription |
string(60) |
Kostendrager Omschrijving |
☐ |
Description of CostUnit. |
Created |
datetime |
Gemaakt |
☐ |
Creation date. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Aanmaker Volledige Naam |
☐ |
Name of creator. |
CustomField |
string |
{res:itgen_eol_customfield} |
☐ |
|
Description |
string |
Omschrijving |
☐ |
Description of the purchase order line. |
Discount |
double |
Korting |
☐ |
Discount in percentage for item. |
Division |
int32 |
Divisie |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
Expense |
guid |
Uitgave |
☐ |
Expense related to the Work Breakdown Structure of the selected project. Only available with a professional service license. |
ExpenseDescription |
string |
Uitgave Omschrijving |
☐ |
Description of expense. Only available with a professional service license. |
ID |
guid |
ID |
☑ |
Primary key. |
InStock |
double |
Op Voorraad |
☐ |
The current stock level of items shown in stock unit. The information is displayed only for items with the stock property selected. |
InvoicedQuantity |
double |
Gefactureerde Hoeveelheid |
☐ |
Quantity of item that has been invoiced. |
IsBatchNumberItem |
int16 |
Is Batch-Nummer Item |
☑ |
|
IsSerialNumberItem |
int16 |
Is Serienummer Artikel |
☑ |
|
Item |
guid |
Artikel |
☐ |
Reference to the item for purchase order. |
ItemBarcode |
string |
Artikelbarcode |
☐ |
|
ItemBarcodeAdditional |
string |
{res:itgen_eol_itembarcodeadditional} |
☐ |
|
ItemCode |
string(30) |
Artikelcode |
☐ |
Item code. |
ItemDescription |
string(255) |
Artikelomschrijving |
☐ |
Description of item. |
ItemDivisable |
boolean |
Splitsbaar Artikel |
☐ |
Indicates if fractional quantities of the item can be used, for example quantity = 0.4. |
LineNumber |
int32 |
Regelnummer |
☐ |
Line number. |
Modified |
datetime |
Gewijzigd |
☐ |
Last modified date. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
NetPrice |
double |
Netto Prijs |
☐ |
The net price is the unit price (VAT code taken into account) with any discount applied. |
Notes |
string |
Notities |
☐ |
Notes. |
Project |
guid |
Project |
☐ |
Reference to project. Only available with a professional service license. |
ProjectCode |
string(20) |
Projectcode |
☐ |
Project code. Only available with a professional service license. |
ProjectDescription |
string(60) |
Projectomschrijving |
☐ |
Description of the project. Only available with a professional service license. |
ProjectedStock |
double |
Geprojecteerde Voorraad |
☐ |
The current stock level + the planned quantity to be received - the planned quantity to deliver shown in stock unit. |
PurchaseOrderID |
guid |
Inkoopopdracht ID |
☑ |
Identifies the purchase order. All the lines of a purchase order have the same PurchaseOrderID. |
Quantity |
double |
Aantal |
☐ |
Quantity in item units. |
QuantityInPurchaseUnits |
double |
Hoeveelheid in Inkoopeenheden |
☐ |
Quantity in purchase units. Use this field when creating a purchase order. |
Rebill |
boolean |
Opnieuw Factureren |
☐ |
Indicates whether the purchase order line needs to be rebilled. Only available with a professional service license. |
ReceiptDate |
datetime |
Ontvangstdatum |
☐ |
Date the goods are expected to be received. |
ReceivedQuantity |
double |
Ontvangen Hoeveelheid |
☐ |
Quantity of goods received. |
SalesOrder |
guid |
Verkooporder |
☐ |
Sales order that is linked to a back to back sales order in purchase order. |
SalesOrderLine |
guid |
Verkooporderregel |
☐ |
Sales order line of the sales order that is linked to a back to back sales order in purchase order. |
SalesOrderLineNumber |
int32 |
Verkooporder Regelnummer |
☐ |
Number of the sales order line. |
SalesOrderNumber |
int32 |
Verkoopordernummer |
☐ |
Number of the sales order. |
ShopOrder |
guid |
Productieorder |
☐ |
|
ShopOrderMaterialPlan |
guid |
{res:itgen_eol_shopordermaterialplan} |
☐ |
|
ShopOrderMaterialPlanLineNumber |
int32 |
{res:itgen_eol_shopordermaterialplanlinenumber} |
☐ |
|
ShopOrderNumber |
int32 |
Productieordernummer |
☐ |
|
ShopOrderRoutingStepPlan |
guid |
{res:itgen_eol_shoporderroutingstepplan} |
☐ |
|
ShopOrderRoutingStepPlanLineNumber |
int32 |
{res:itgen_eol_shoporderroutingstepplanlinenumber} |
☐ |
|
SupplierItemCode |
string(240) |
Leverancier Artikelcode |
☐ |
Code the supplier uses for this item. |
SupplierItemCopyRemarks |
int16 |
{res:itgen_eol_supplieritemcopyremarks} |
☑ |
Indicate if the notes content should be copied from SupplierItem's remarks. The default follows the CopyRemarks value from SupplierItem. Values: 0 = Do not copy remark, 1 = Copy remark. |
Unit |
string(8) |
Unit |
☐ |
Code of item unit. |
UnitDescription |
string(60) |
Omschrijving Unit |
☐ |
Description of unit. |
UnitPrice |
double |
Prijs per Eenheid |
☐ |
Item price per purchase unit. |
VATAmount |
double |
BTW-bedrag |
☐ |
Amount of VAT charges calculated from total amount and vat percentage. |
VATCode |
string(3) |
BTW-code |
☐ |
The VAT code used when the invoice was registered. |
VATDescription |
string(60) |
BTW Omschrijving |
☐ |
Description of the VAT code. |
VATPercentage |
double |
BTW-percentage |
☐ |
The VAT percentage of the VAT code. This is the percentage at the moment the invoice is created. It's also used by the default calculation of VAT amounts and VAT base amounts. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455