| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FIAPSAC_ATCH | Required Attachments for Payment Order | 2 | ORDTYP | Instance | nvarchar | 1 | 0 | | |
2 | FIAPSAC_ATCH_T | Required Attachments for Payment Order | 3 | ORDTYP | Instance | nvarchar | 1 | 0 | | |
3 | FIAPSAC_COCDNRN | KSA Company code to number range assignment | 3 | ORDTYP | Transaction Type for KSA | nvarchar | 1 | 0 | | |
4 | FIAPSAD_ACHMT_ID | Linking Attachment With the Document | 5 | ORDTYP | Instance | nvarchar | 1 | 0 | | |
5 | FIAPSAD_ATCHMT | Attachment details for Expenditure/Payment order | 5 | ORDTYP | Instance | nvarchar | 1 | 0 | | |
6 | FIAPSAD_ORDR_HD | Order Number Header KSA | 5 | ORDTYP | Instance | nvarchar | 1 | 0 | | |
7 | FIAPSAD_ORDR_LT | Line Item for Order Number KSA | 5 | ORDTYP | Instance | nvarchar | 1 | 0 | | |
8 | FIAPSAD_WF_STAT | Intermediate status of Expenditure Order/Payment approval | 5 | ORDTYP | Instance | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
9 | DFKKORDER | Requests: Header Data | 4 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
10 | DFKKORDERAPPROVE | Requests to be Approved | 4 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
11 | DFKKORDERRANGE | Assigning Number Ranges to Request Categories | 3 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
12 | DFKKORDERRANGE_S | Assign Number Ranges to Request Templates | 2 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
13 | DFKKORDERTYP | Request Category | 2 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
14 | DFKKORDERTYPT | Names of Request Types | 1 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
15 | DFKKORDER_S | Request Templates: Header Data | 4 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
16 | DFKKORDTYP | Request Category | 2 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
17 | DFKKORDTYPT | Names of Request Types | 2 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
18 | TFKKORDERAPPROVE | Settings for Approval of Requests | 3 | ORDTYP | Request Category | nvarchar | 1 | 0 | | |
TOPData Collection |
19 | CF500 | IDES Investment | 30 | ORDTYP | Order Type | nvarchar | 4 | 0 | | |