| 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 | WBLNR | Internal Number for asset movement way bills | nvarchar | 8 | 0 | CHAR | (N' ') | No | | J_1AAWBLNR | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 4 | J_1ASNR | Branch of sender object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | J_1ASNR | J_1AASESNR | Allow NULL? |
| 5 | J_1APRTCHR | Character to be printed on the document | char | 1 | 0 | CHAR | (N' ') | Yes | J_1APRTCHR | J_1APCHAR | Allow NULL? |
| 6 | J_1ADOCCLS | Document Class | char | 1 | 0 | CHAR | (N' ') | Yes | J_1ADOCCLS | J_1ADOCCL_ | Allow NULL? |
| 7 | J_1AOFFNUM | Official document number for Argentina | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | J_1AOFFNUM | Allow NULL? |
| 8 | REASON | Type of movement - reason for numbering | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1AAREASN | Allow NULL? |
| 9 | SANLN1 | Sender asset main number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ANLH | J_1AASANL1 | Allow NULL? |
| 10 | SANLN2 | Sender Asset Sub number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ANLA | J_1AASANL2 | Allow NULL? |
| 11 | SINVNR | Inventory number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | INVNR_ANLA | Allow NULL? |
| 12 | STXT50 | Asset description | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TXA50_ANLT | Allow NULL? |
| 13 | STEXT | Error message text - long text of the error | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | TEXT70 | Allow NULL? |
| 14 | MOVDT | Document date for way bill | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1AAMOVDT | Allow NULL? |
| 15 | RBUKRS | Receiver company code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | J_1AARBUKR | Allow NULL? |
| 16 | J_1ARNR | Branch of receiver object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | J_1BBRANCH | J_1AARCSNR | Allow NULL? |
| 17 | RANLN1 | Receiver Asset main number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ANLH | J_1AARANL1 | Allow NULL? |
| 18 | RANLN2 | Receiver Asset sub number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ANLA | J_1AARANL2 | Allow NULL? |
| 19 | RINVNR | Inventory number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | INVNR_ANLA | Allow NULL? |
| 20 | RTXT50 | Asset description | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TXA50_ANLT | Allow NULL? |
| 21 | RTEXT | Error message text - long text of the error | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | TEXT70 | Allow NULL? |
| 22 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 23 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 24 | CHANGENR | Document change number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CDCHANGENR | Allow NULL? |
| 25 | TEXT70 | Error message text - long text of the error | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | TEXT70 | Allow NULL? |
| 26 | ANRED | Title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ANRED | Allow NULL? |
| 27 | NAME1 | Name 1 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME1_GP | Allow NULL? |
| 28 | NAME2 | Name 2 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME2_GP | Allow NULL? |
| 29 | STRAS | House number and street | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | STRAS_GP | Allow NULL? |
| 30 | ORT01 | City | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | ORT01_GP | Allow NULL? |
| 31 | ORT02 | District | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | ORT02_GP | Allow NULL? |
| 32 | PFACH | PO Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PFACH | Allow NULL? |
| 33 | PSTL2 | P.O. Box Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTL2 | Allow NULL? |
| 34 | PSTLZ | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTLZ | Allow NULL? |
| 35 | REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REGIO | Allow NULL? |
| 36 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1_GP | Allow NULL? |
| 37 | J_1ATODC | Tax Number Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_1ATOID | Allow NULL? |
| 38 | STKZN | Natural Person | char | 1 | 0 | CHAR | (N' ') | Yes | | STKZN | Allow NULL? |
| 39 | J_1AFOP | Tax Code for Foreign Nationals | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | J_1AFOPID | Allow NULL? |
| 40 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | STCD1 | Allow NULL? |
| 41 | STCD2 | Tax Number 2 | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | STCD2 | Allow NULL? |
| 42 | J_1AFITP | Tax type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_1AFITP_D | Allow NULL? |
| 43 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 44 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 45 | PRDAT | Printing date for asset accounting way bill | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1AAPRTDT | Allow NULL? |
| 46 | XLOEV | Deletion flag | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1AAXLOEV | Allow NULL? |
| 47 | LIFNR | Forwarding agent/carrier | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | J_1ACAREER | Allow NULL? |
