| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | AITYP | Application identifier type | nvarchar | 10 | 0 | CHAR | (N' ') | No | T313G | T313DAITYP | Allow NULL? |
| 3 | AIVAL | Application identifier (AI) | nvarchar | 4 | 0 | CHAR | (N' ') | No | | T313DAIVAL | Allow NULL? |
| 4 | AISUB | Partial field / subdivision of an application identifier | char | 1 | 0 | NUMC | (N'0') | No | | T313DAISUB | Allow NULL? |
| 5 | AIDEF | Application identifier is defined | char | 1 | 0 | CHAR | (N' ') | Yes | | T313DAIDEF | Allow NULL? |
| 6 | AIFOR | Format of application identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | T313DAIFOR | Allow NULL? |
| 7 | AILEN | Length of application identified (AI) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | T313DAILEN | Allow NULL? |
| 8 | AIDEL | Delimiter for Variable Bar Code Lengths | char | 1 | 0 | CHAR | (N' ') | Yes | | T313DAIDEL | Allow NULL? |
| 9 | AIEVL | Variable length must be even | char | 1 | 0 | CHAR | (N' ') | Yes | | T313DAIEVL | Allow NULL? |
| 10 | AINKL | Number of places in AI for decimal figures | char | 1 | 0 | NUMC | (N'0') | Yes | | T313DAINKL | Allow NULL? |
| 11 | AIVLL | Number of places in AI for variable length specification | char | 1 | 0 | NUMC | (N'0') | Yes | | T313DAIVLL | Allow NULL? |
| 12 | AIVLM | Multiplier for AI length specification | char | 1 | 0 | NUMC | (N'0') | Yes | | T313DAIVLM | Allow NULL? |
| 13 | AIVLA | Addition factor for AI length specification | char | 1 | 0 | NUMC | (N'0') | Yes | | T313DAIVLA | Allow NULL? |
| 14 | AIVSC | AI is provided for logistical units with variable quantity | char | 1 | 0 | CHAR | (N' ') | Yes | | T313DAIVSC | Allow NULL? |
| 15 | AIUNIT | ISO code for unit of measurement | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T006I | ISOCD_UNIT | Allow NULL? |
| 16 | AICHK | Additional Checks for AI | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | T313DAICHK | Allow NULL? |
| 17 | APPLI | Application for bar code type | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | T313DAPPLI | Allow NULL? |
