| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKSAFTINV_H | SAF-T Source Document: Header | 11 | INV_NO | Signature PT: Invoice Number (SAFT length) | nvarchar | 60 | 0 | | |
2 | ISM_PT_JFRK | Portugal: Digital Signature for Billing Document | 9 | INV_NO | Signature PT: Invoice Number | nvarchar | 20 | 0 | | |
3 | ISM_PT_JHTFK | Portugal: Digital Signature for M/AM Billing Document | 9 | INV_NO | Signature PT: Invoice Number | nvarchar | 20 | 0 | | |
TOPCheck Input |
4 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 74 | INV_NO | Invoice Number | nvarchar | 6 | 0 | | |
TOPCross-Application Components |
5 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 5 | INV_NO | Document Number of an Invoice Document | nvarchar | 10 | 0 | | |
6 | /OPT/S_INV_LIN | VSS Staging Table: Invoice lines | 7 | INV_NO | Document Number of an Invoice Document | nvarchar | 10 | 0 | | |
TOPDSD Connector |
7 | /DSD/ME_INV_HD | DSD CN: Billing Doc. Header Data | 4 | INV_NO | DSD Connector: Invoice Number | nvarchar | 10 | 0 | | |
8 | /DSD/ME_INV_ITM | DSD CN: Billing Doc. Items | 3 | INV_NO | DSD Connector: Invoice Number | nvarchar | 10 | 0 | | |
TOPLocalization |
9 | SIPT_BKPF | Portugal: Digital Signature for Accounting Documents | 11 | INV_NO | Signature PT: Invoice Number | nvarchar | 20 | 0 | | |
10 | SIPT_RBKP | Portugal: Digital Signature for Self Billing Document | 13 | INV_NO | Signature PT: Invoice Number | nvarchar | 20 | 0 | | |
11 | SIPT_VBRK | Portugal: Digital Signature for Billing Document | 9 | INV_NO | Signature PT: Invoice Number | nvarchar | 20 | 0 | | |
12 | VIXCPTSIPT | Digital Signature for Invoices | 12 | INV_NO | Signature PT: Invoice Number | nvarchar | 20 | 0 | | |
TOPPayment Transactions |
13 | FPRL_ITEM | Item Data | 172 | INV_NO | Document Number or Invoice Reference Number | nvarchar | 10 | 0 | | |
TOPRevenue |
14 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 75 | INV_NO | Invoice Number | nvarchar | 6 | 0 | | |
15 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 73 | INV_NO | Invoice Number | nvarchar | 6 | 0 | | |
16 | OIUH_RV_JEINTF | PRA Journal Entries | 74 | INV_NO | Invoice Number | nvarchar | 6 | 0 | | |
TOPValuation |
17 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 76 | INV_NO | Invoice Number | nvarchar | 6 | 0 | | |