| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | REF_VENDOR | Reference Vendor Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | RELATION | Vendor Partner Relationship Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | CHECK_REF | Check Reference Vendor when search for Invoice or PO | char | 1 | 0 | | | | Allow NULL? |
| 7 | REF_ADDR | Reference Address ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | PO_INV_READ | Relevance Flag for PO Invoice Retrieval | char | 1 | 0 | | | | Allow NULL? |
| 9 | NPO_INV_READ | Relevance Flag for Non PO Invoice Retrieval | char | 1 | 0 | | | | Allow NULL? |
| 10 | PO_INV_ENTRY | Relevance Flag for PO Invoice Entry | char | 1 | 0 | | | | Allow NULL? |
| 11 | NPO_INV_ENTRY | Relevance Flag for Non PO Invoice Entry | char | 1 | 0 | | | | Allow NULL? |
| 12 | PO_READ | Relevance flag for PO retrieval | char | 1 | 0 | | | | Allow NULL? |
| 13 | ACTIVEFLAG | Flag to indicate whether the relationship is active | char | 1 | 0 | | | | Allow NULL? |
| 14 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | char | 1 | 0 | | | | Allow NULL? |
| 15 | DELETED | Deleted flag | char | 1 | 0 | | | | Allow NULL? |
