| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/KPCC_LOG | Log Credit Card Interface | 2 | REFNO | Reference | nvarchar | 19 | 0 | | |
2 | P2FI_CSI | Social ins & result structure for Finland | 13 | REFNO | Reference number for payments | nvarchar | 20 | 0 | | |
3 | P2FI_SI | Social ins & result structure for Finland | 13 | REFNO | Reference number for payments | nvarchar | 20 | 0 | | |
4 | P2RG_COURT | Types of Court Order (GB) | 11 | REFNO | Reference number (GB) | nvarchar | 20 | 0 | | |
5 | T7ID1R | Employee Reference Number for Tax Form 1721-A1 | 5 | REFNO | Employee Reference No. for Tax form 1721-A1 | nvarchar | 7 | 0 | | |
TOPBank Customer Accounts |
6 | BKKPOGISL | EDI Payments: Reporting Data to Clearing, Seg. E1IDT02 | 4 | REFNO | Reference no. | nvarchar | 3 | 0 | | |
7 | BKKPOREFA | References for EDI Payments, Position, Amount Segment | 5 | REFNO | Reference no. | nvarchar | 3 | 0 | | |
8 | BKKPOREFD | References to EDI Payments, Item, Date Segment | 5 | REFNO | Reference no. | nvarchar | 3 | 0 | | |
9 | BKKPOREFL | References for EDI Payments, Header data, Long Texts | 4 | REFNO | Reference no. | nvarchar | 3 | 0 | | |
10 | BKKPOREFR | References for EDI Payments, Position, Ref. Data Segment | 5 | REFNO | Reference no. | nvarchar | 3 | 0 | | |
TOPClaims Management |
11 | ICLITEM | Claim Item | 59 | REFNO | External Reference Number | nvarchar | 15 | 0 | | |
12 | ICLITEMAU | Damaged Vehicle | 73 | REFNO | External Reference Number | nvarchar | 15 | 0 | | |
13 | ICLITEMSV | Salvage Item Evaluation | 12 | REFNO | Reference number | nvarchar | 10 | 0 | | |
14 | ICLPAYI | Claim Payment Item | 25 | REFNO | External Reference Number | nvarchar | 15 | 0 | | |
15 | ICLREF | Coverage Referral in Claim | 6 | REFNO | Coverage Referral Number | nvarchar | 3 | 0 | | |
16 | ICSITEM | Claim Item | 59 | REFNO | External Reference Number | nvarchar | 15 | 0 | | |
17 | ICSITEMAU | Damaged Vehicle | 73 | REFNO | External Reference Number | nvarchar | 15 | 0 | | |
18 | ICSITEMSV | Salvage Item Evaluation | 12 | REFNO | Reference number | nvarchar | 10 | 0 | | |
19 | ICSPAYI | Payment Item | 25 | REFNO | External Reference Number | nvarchar | 15 | 0 | | |
20 | ICSREF | Coverage Referral in Claim | 6 | REFNO | Coverage Referral Number | nvarchar | 3 | 0 | | |
TOPCorporate Performance Monitor |
21 | UMK_MB020 | Measure Hierarchy | 4 | REFNO | Reference Number | nvarchar | 32 | 0 | | |
TOPFinland |
22 | T7FI02 | Pension insurance table (Finland) | 7 | REFNO | Reference number for payments | nvarchar | 20 | 0 | | |
TOPForeign Trade |
23 | /SAPSLL/OBJIDX | SLL: R/3 BS: Index of Documents Not Transferred | 4 | REFNO | Reference Number of a Document from Backend System for SLL | nvarchar | 40 | 0 | | |
24 | /SAPSLL/OBJSSF | GTS: R/3 FS: Index of Documents to Be Released | 3 | REFNO | Reference Number of a Document from Backend System for SLL | nvarchar | 40 | 0 | | |
25 | /SAPSLL/OBJSYNC | GTS: R/3 Feeder System: Index of Generated Documents | 2 | REFNO | Reference Number of a Document from Backend System for SLL | nvarchar | 40 | 0 | | |
TOPGlobal Trade Services |
26 | /SAPSLL/CORREF | Reference Data | 6 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
27 | /SAPSLL/CWLPCP | Worklist: Installation Statement FC w/PEU | 3 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
28 | /SAPSLL/KMATWL | GTS: KMAT Worklist | 6 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
29 | /SAPSLL/LEGCOL | Container Management in Safekeeping | 7 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
30 | /SAPSLL/LEGCOM | SLL: Customs Document: Communiation Numbers | 6 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
31 | /SAPSLL/LEGMES | SLL: Customs Document: Messages for Each Activity | 27 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
32 | /SAPSLL/LEGPEU | Closing of Free Circulation with Prescribed End Use | 4 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
33 | /SAPSLL/LEGREF | SLL: Customs Document: External Reference Objects | 6 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
34 | /SAPSLL/MODKMAT | SLL: KMAT Model | 5 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
35 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 5 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
36 | /SAPSLL/PREVDH | Preference: Long-Term Vendor Declaration Header | 29 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
37 | /SAPSLL/PREVDWLO | SLL: Preference: Vend.Decl. f. Cust. Purp. - Worklist | 6 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
38 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 30 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
39 | /SAPSLL/SPLAUDR | Audit Trail for SPL Screening - Additional Object References | 17 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
40 | /SAPSLL/VDOWL | Worklist: Vendor Declaration for Customer's Purpose | 10 | REFNO | Reference Number | nvarchar | 40 | 0 | | |
TOPGreat Britain |
41 | PA0070 | HR Master Record: Infotype 0070 (Court Orders - GB) | 24 | REFNO | Reference number (GB) | nvarchar | 20 | 0 | | |
TOPHong Kong |
42 | T7HK3B | Entitlement plan attributes | 6 | REFNO | Provider's plan reference number | nvarchar | 20 | 0 | | |
TOPIndonesia |
43 | PA0241 | Indonesian Tax Data | 27 | REFNO | Unemployment Reference Number | nvarchar | 30 | 0 | | |
TOPIntercompany Data Exchange |
44 | IUEEDPPLOTATREF | Distr. Aggr. Payments: Ref. btwn MR and Distributed Objects | 4 | REFNO | Consecutive Number for Referencing a Payment Lot Item | nvarchar | 3 | 0 | | |
45 | IUEEDPPLOTATREF1 | Distr. Aggr. Payments: Ref. Between Pymt St. and Aggr. Pymt | 4 | REFNO | Consecutive Number for Referencing a Payment Lot Item | nvarchar | 3 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
46 | T8JDK | JV EDI Inbound: 819 Cost Object (Ref) Mapping Table | 6 | REFNO | Reference Number | nvarchar | 30 | 0 | | |
47 | T8JDL | JV EDI Inbound: 819 Cost Object (Ref + Class) Mapping | 6 | REFNO | Reference Number | nvarchar | 30 | 0 | | |
48 | T8JDM | JV EDI Inbound: 819 Cost Object (Ref, Class, Subclass A) | 6 | REFNO | Reference Number | nvarchar | 30 | 0 | | |
49 | T8JDP | JV EDI Inbound: Memo AFE Table | 5 | REFNO | Reference Number | nvarchar | 30 | 0 | | |
TOPMalaysia |
50 | T5LES | ESS Malaysia: TP1 TP2 | 8 | REFNO | Reference No. | nvarchar | 17 | 0 | | |
TOPNew Zealand |
51 | T7NZSF | Superannuation Fund Code Designation NZ | 6 | REFNO | Superannuation Fund Employer Number | nvarchar | 15 | 0 | | |
TOPPersonnel Administration |
52 | PA0811 | HR Master Record: Infotype 0811 | 26 | REFNO | Pension Reference Number | nvarchar | 10 | 0 | | |
TOPPublic Sector |
53 | PA0487 | HR-SG-PS: Security / medical Clearance | 27 | REFNO | MINDEF Reference Number | nvarchar | 20 | 0 | | |
54 | PA0502 | Letter of appointment | 28 | REFNO | MINDEF Reference Number | nvarchar | 20 | 0 | | |
55 | PB0502 | Letter of appointment | 28 | REFNO | MINDEF Reference Number | nvarchar | 20 | 0 | | |
TOPSecurity Deposits |
56 | FKK_SEC_N | Noncash Security Deposit | 5 | REFNO | Reference number for non-cash security deposit | nvarchar | 40 | 0 | | |
TOPSouth Africa |
57 | PA0149 | HR Master Record Infotype 0149 (Tax Data South Africa) | 25 | REFNO | Tax Reference Number ZA | nvarchar | 10 | 0 | | |
58 | T5WER | South Africa - IRP5 Company Contact Person Details | 2 | REFNO | Tax Reference Number ZA | nvarchar | 10 | 0 | | |
59 | T5WITA88 | ITA88 Transaction Table | 14 | REFNO | Tax Reference Number ZA | nvarchar | 10 | 0 | | |
TOPWarranty Claim Processing |
60 | PNWTYH | Warranty Claim Header (PVS Node) | 8 | REFNO | External Number of Claim | nvarchar | 40 | 0 | | |
61 | WTY_ARCH_IDX | Index Table for Archiving Warranty Claims | 4 | REFNO | External Number of Claim | nvarchar | 40 | 0 | | |