Microsoft Access AUFKR (Orders)You should read the table from top to bottom to see the order in which the data fields are stored in the data records in the Access database.
Field name is the name of the field in the table. Type shows the field’s attribute and length gives the length of the data field. Text indicates the type of data.
Field name |
Type |
Length |
Text |
ARNUMMER |
NUMC |
6 |
Archiving run |
VSGRUPPE |
CHAR |
20 |
Version group |
VSNUMMER |
CHAR |
12 |
Version key |
PRCTR |
CHAR |
10 |
Profit center |
PRNAM |
CHAR |
8 |
Capital investment program |
PRPOS |
CHAR |
24 |
Item ID |
PSPID |
CHAR |
24 |
Project definition |
POSID |
CHAR |
24 |
WBS element |
KDAUF |
CHAR |
10 |
Sales document |
KDPOS |
NUMC |
6 |
Sales item |
AUFNR |
CHAR |
12 |
Order |
AUART |
CHAR |
4 |
Order type |
AUARTTXT |
CHAR |
20 |
Order type |
AUTYPTXT |
CHAR |
40 |
Order type |
REFNR |
CHAR |
12 |
Reference order |
KTEXT |
CHAR |
40 |
Short text |
TXTKZ |
CHAR |
1 |
Long text exists |
LTEXT |
CHAR |
1 |
Long text exists |
BUKRS |
CHAR |
4 |
Company code |
WERKS |
CHAR |
4 |
Plant |
GSBER |
CHAR |
4 |
Business area |
KOKRS |
CHAR |
4 |
Controlling area |
KOSTV |
CHAR |
10 |
Responsible cost center |
WAERS |
CUKY |
5 |
Currency |
KALSM |
CHAR |
6 |
Costing profile |
ZSCHL |
CHAR |
6 |
Overhead key |
USER0 |
CHAR |
20 |
Applicant |
USER1 |
CHAR |
20 |
Telephone |
USER2 |
CHAR |
20 |
Responsible person |
USER3 |
CHAR |
20 |
Telephone |
USER4 |
CURR |
14 |
Estimated costs |
USER5 |
DATS |
10 |
Created on |
USER6 |
CHAR |
15 |
Department |
USER7 |
DATS |
10 |
Work start |
USER8 |
DATS |
10 |
Work finish |
USER9 |
CHAR |
1 |
Work permit |
AWSLS |
CHAR |
6 |
Variance key |
ABGSL |
CHAR |
6 |
Results analysis key |
TXJCD |
CHAR |
15 |
Jurisdiction code |
SCOPE |
CHAR |
5 |
Object class |
AUFEX |
CHAR |
20 |
External order number |
FLG_MLTPS |
CHAR |
1 |
Multi–item |
AKSTL |
CHAR |
10 |
Required cost center |
GLTRP |
DATS |
10 |
Basic finish date |
GSTRP |
DATS |
10 |
Basic start date |
FTRMS |
DATS |
10 |
Scheduled release date |
GLTRS |
DATS |
10 |
Scheduled finish |
GSTRS |
DATS |
10 |
Scheduled start |
GSTRI |
DATS |
10 |
Actual start date |
GETRI |
DATS |
10 |
Confirmed finish date |
GLTRI |
DATS |
10 |
Actual finish date |
FTRMI |
DATS |
10 |
Actual release date |
FTRMP |
DATS |
10 |
Planned release date |
RSNUM |
NUMC |
10 |
Reservation number |
GASMG |
QUAN |
17 |
Total scrap |
GAMNG |
QUAN |
17 |
Target quantity |
GMEIN |
UNIT |
3 |
Base unit of measure |
PLNBEZ |
CHAR |
18 |
Material plan |
PLNTY |
CHAR |
1 |
Task list type |
PLNNR |
CHAR |
8 |
Group |
PLNAL |
CHAR |
2 |
Group counter |
PLSVB |
QUAN |
17 |
Lot size to (planned) |
PLNME |
UNIT |
3 |
Unit of measure (planned) |
PLSVN |
QUAN |
17 |
Lot size from (planned) |
PDATV |
DATS |
10 |
Valid from (planned) |
PAENR |
CHAR |
12 |
Change number (planned) |
PLGRP |
CHAR |
3 |
Planner group |
STLTY |
CHAR |
1 |
BOM category |
STLBEZ |
CHAR |
18 |
Material BOM |
STLST |
NUMC |
2 |
BOM status |
STLNR |
CHAR |
8 |
Bill of material (BOM) |
SDATV |
DATS |
10 |
Valid from (BOM) |
SBMNG |
QUAN |
17 |
Base quantity |
SBMEH |
UNIT |
3 |
Base unit of measure |
SAENR |
CHAR |
12 |
Change number (BOM) |
STLAL |
CHAR |
2 |
BOM alternative |
STLAN |
CHAR |
1 |
BOM usage |
SLSVN |
QUAN |
17 |
Lot size from (BOM) |
SLSBS |
QUAN |
17 |
Lot size to (BOM) |
AUFLD |
DATS |
10 |
Explosion date |
DISPO |
CHAR |
3 |
MRP group |
DSNAM |
CHAR |
18 |
MRP controller |
FEVOR |
CHAR |
3 |
Production scheduler |
FHORI |
CHAR |
3 |
Scheduling margin key |
TERKZ |
CHAR |
1 |
Scheduling type |
REDKZ |
CHAR |
1 |
Reduction indicator |
APRIO |
CHAR |
1 |
Order priority |
VORGZ |
NUMC |
3 |
Float before production |
SICHZ |
NUMC |
3 |
Float after production |
FREIZ |
NUMC |
3 |
Release period |
KLVARP |
CHAR |
4 |
Costing variant (planned) |
KLVARI |
CHAR |
4 |
Costing variant (actual) |
GLTPP |
DATS |
10 |
Forecast finish date |
GSTPP |
DATS |
10 |
Forecast start date |
GLTPS |
DATS |
10 |
Scheduled finish (forecast) |
GSTPS |
DATS |
10 |
Scheduled start (forecast) |
FTRPS |
DATS |
10 |
Scheduled release (forecast) |
RDKZP |
CHAR |
1 |
Reduction indicator (forecast) |
TRKZP |
CHAR |
1 |
Scheduling type (forecast) |
GLUZS |
TIMS |
8 |
Sched. finish time (basic) |
GSUZS |
TIMS |
8 |
Sched. start time (basic) |
NAUTERM |
CHAR |
1 |
Scheduling not automatic |
NAUCOST |
CHAR |
1 |
Costing not automatic |
STUFE |
DEC |
2 |
Level |
WEGXX |
DEC |
5 |
Path |
VWEGX |
DEC |
5 |
Path |
MAUFNR |
CHAR |
12 |
Superior order |
PRODNET |
CHAR |
1 |
Collective order |
IASMG |
QUAN |
17 |
Confirmed scrap |
ABARB |
NUMC |
3 |
Degree of processing |
AUFNT |
CHAR |
12 |
Subnetwork for network |
VORNT |
CHAR |
4 |
Subnetwork for activity |
BREAKS |
CHAR |
1 |
Breaks |
VORGZ_TRM |
DEC |
7 |
Sched. float before production |
SICHZ_TRM |
DEC |
7 |
Sched. float after production |
TRMDT |
DATS |
10 |
Scheduled on |
GLUZP |
TIMS |
8 |
Basic finish time |
GSUZP |
TIMS |
8 |
Basic start time |
GSUZI |
TIMS |
8 |
Actual start time |
GEUZI |
TIMS |
8 |
Actual finish time |
GLUPP |
TIMS |
8 |
Forecast finish time |
GSUPP |
TIMS |
8 |
Forecast start time |
GLUPS |
TIMS |
8 |
Sched. finish time (forecast) |
GSUPS |
TIMS |
8 |
Sched. start time (forecast) |
CHSCH |
CHAR |
6 |
Search procedure |
KAPT_VORGZ |
NUMC |
3 |
Remaining float before production |
KAPT_SICHZ |
NUMC |
3 |
Remaining float after production |
LEAD_AUFNR |
CHAR |
12 |
Leading order |
PNETSTARTD |
DATS |
10 |
Outline start date |
PNETSTARTT |
TIMS |
8 |
Outline start time |
PNETENDD |
DATS |
10 |
Outline finish date |
PNETENDT |
TIMS |
8 |
Outline finish time |
STRMP |
DATS |
10 |
Planned start date |
ETRMP |
DATS |
10 |
Planned creation date |
KDEIN |
NUMC |
4 |
Schedule line: sales order |
WEMNG |
QUAN |
17 |
Goods receipt quantity |
IAMNG |
QUAN |
17 |
Actual scrap quantity |
AMEIN |
UNIT |
3 |
In–house prod. unit of measure |
MEINS |
UNIT |
3 |
Base unit of measure |
MATNR |
CHAR |
18 |
Material number |
MTEXT |
CHAR |
40 |
Material short text |
PAMNG |
QUAN |
17 |
Scrap quantity |
PGMNG |
QUAN |
17 |
Planned order quantity |
LTRMI |
DATS |
10 |
Actual delivery date |
LTRMP |
DATS |
10 |
Planned delivery date |
KALNR |
NUMC |
12 |
Unit costing number |
UEBTO |
DEC |
4 |
Overdelivery tolerance |
UEBTK |
CHAR |
1 |
Unlimited overdelivery |
UNTTO |
DEC |
4 |
Underdelivery tolerance |
INSMK |
CHAR |
1 |
Quality inspection |
WEPOS |
CHAR |
1 |
Goods receipt |
BWTAR |
CHAR |
10 |
Valuation type |
PWERK |
CHAR |
4 |
Planning plant |
LGORT |
CHAR |
4 |
Storage location |
VERTO |
CHAR |
4 |
Distribution key |
WEBAZ |
DEC |
3 |
Goods receipt processing |
ELIKZ |
CHAR |
1 |
Final delivery |
SERNR |
CHAR |
8 |
Serial number |
WEUNB |
CHAR |
1 |
Non–valuated goods receipt |
ABLAD |
CHAR |
25 |
Unloading point |
WEMPF |
CHAR |
12 |
Ship–to party |
CHARG |
CHAR |
10 |
Batch |
STATXT |
CHAR |
40 |
Status |
FRUEHER |
QUAN |
7 |
Earlier |
SPAETER |
QUAN |
7 |
Later |
VERZUG |
QUAN |
7 |
Delay |
VORBEI |
QUAN |
7 |
Past |
VEINH |
UNIT |
3 |
Unit |