| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | VERS | Portugal: SAF-T Version | nvarchar | 10 | 0 | CHAR | (N' ') | No | | SAFTPT_VERS | Allow NULL? |
| 2 | ID | Portugal: SAF-T Element ID | nvarchar | 32 | 0 | CHAR | (N' ') | No | | SAFTPT_GUID | Allow NULL? |
| 3 | PARENT_ID | Portugal: SAF-T Parent element ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SAFTPT_GUID_PARENT | Allow NULL? |
| 4 | GROUP_ID | Portugal: SAF-T Group ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SAFTPT_GUID_GROUP | Allow NULL? |
| 5 | DEPTH | Portugal: SAF-T Element level (depth) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SAFTPT_DEPTH | Allow NULL? |
| 6 | REQUIRED | Portugal: SAF-T Required field | char | 1 | 0 | CHAR | (N' ') | Yes | | SAFTPT_REQUIRED | Allow NULL? |
| 7 | MAPPED | Portugal: SAF-T Mapped field | char | 1 | 0 | CHAR | (N' ') | Yes | | SAFTPT_MAPPED | Allow NULL? |
| 8 | CHOICE | Portugal: SAF-T Choice element | char | 1 | 0 | CHAR | (N' ') | Yes | | SAFTPT_CHOICE | Allow NULL? |
| 9 | POS | Portugal: SAF-T Element position | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SAFTPT_POSITION | Allow NULL? |
| 10 | CHILD_EXIST | Portugal: SAF-T Structure indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SAFTPT_CHILD_EXIST | Allow NULL? |
| 11 | NAME | Portugal: SAF-T Element name | nvarchar | 100 | 0 | CHAR | (N' ') | Yes | | SAFTPT_ELEMENT | Allow NULL? |
| 12 | PARENT_NAME | Portugal: SAF-T Parent element name | nvarchar | 100 | 0 | CHAR | (N' ') | Yes | | SAFTPT_ELEMENT_PARENT | Allow NULL? |
| 13 | LOGIC_ID | Portugal: SAF-T Logic determinator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SAFTPT_LOGIC | Allow NULL? |
| 14 | CREATE_ON | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |