VPLAN_SalesOrder_row: itgen_aoe_vplan_salesorder_row |
Name: VPLAN_SalesOrder_row
Catalog: AfasOnline
Schema: GetConnector
Label: itgen_aoe_vplan_salesorder_row
Documentation:
VPLAN_SalesOrder_row
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): /connectors/VPLAN_SalesOrder_row
Insert Service URL (OData-specific): /connectors/VPLAN_SalesOrder_row
Update Service URL (OData-specific): /connectors/VPLAN_SalesOrder_row
Delete Service URL (OData-specific): /connectors/VPLAN_SalesOrder_row
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
afas_created_at |
datetime |
Aangemaakt op |
|
|
afas_updated_at |
datetime |
Gewijzigd op |
|
|
delivered_date |
datetime |
Afwijkende afleverdatum |
|
|
description |
string(255) |
Omschrijving |
|
|
external_ref |
string(38) |
GUID regel |
|
|
item |
string(40) |
Itemcode |
|
|
position |
int32 |
Volgnummer |
|
|
quantity |
decimal |
Aantal te leveren |
|
|
quantity_backorder |
decimal |
Aantal wachtorder |
|
|
quantity_delivered |
decimal |
Aantal geleverd |
|
|
quantity_original |
decimal |
Oorspronkelijk aantal |
|
|
salesorder |
string(12) |
Ordernummer |
|
|
status |
string(100) |
Status regel |
|
|
type |
int32 |
Type regel |
|
|
unit |
string(15) |
Eenheid |
|
|
07-10-2019 20:5017.33.149-BETA+2365