| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OTTM/BL_T_ERA | E-Receipt assignments | 6 | ITEM_NO | Item number of meta data | nvarchar | 3 | 0 | | |
2 | /OTTM/BL_T_ERM | E-Receipt metadata | 6 | ITEM_NO | Item number of meta data | nvarchar | 3 | 0 | | |
3 | /SYCLO/PSH02 | Syclo Push Register - Instance items | 4 | ITEM_NO | Record Id | int | 10 | 0 | | |
4 | /SYCLO/SC001 | Syclo Security Check Profile | 4 | ITEM_NO | Item no. | nvarchar | 4 | 0 | | |
5 | CMCBD_BGT_CLAIM | Budget claims based on suggest level | 9 | ITEM_NO | Item No. in Budget Claim | nvarchar | 5 | 0 | | |
6 | CMCBD_CONSUME | Cash Budgeting Consumption | 10 | ITEM_NO | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
TOPComplaints and Returns |
7 | /SPE/INSPECRESC | Inspection Outcome: Item Codes | 3 | ITEM_NO | Inspection Item Number | nvarchar | 4 | 0 | | |
8 | /SPE/INSPECRESP | Inspection Outcome: Item | 3 | ITEM_NO | Inspection Item Number | nvarchar | 4 | 0 | | |
TOPCRM Accruals |
9 | CRM_ACE_OH_DATA | CRM Accruals: Object Header | 11 | ITEM_NO | Item Number in CRM Document | nvarchar | 10 | 0 | | |
10 | CRM_ACE_OI_DATA | CRM Accruals: Item Detail Data of Object | 14 | ITEM_NO | Item Number in CRM Document | nvarchar | 10 | 0 | | |
11 | CRM_ACE_REFKEY | CRM Accruals: REFKEY Decryption | 5 | ITEM_NO | Item Number in CRM Document | nvarchar | 10 | 0 | | |
TOPFinancial Supply Chain Management |
12 | BNK_BATCH_ITEM | Batch Payment Items | 3 | ITEM_NO | Item Count Number | nvarchar | 5 | 0 | | |
13 | BNK_BTCH_STREF | Status reference | 6 | ITEM_NO | Item Count Number | nvarchar | 5 | 0 | | |
TOPGoods Issue Process |
14 | /SPE/CRMD_PO_MAP | Correlation Table Third Party PO <-> CRM Sales Order | 7 | ITEM_NO | Item | nvarchar | 10 | 0 | | |
15 | /SPE/CRMD_PR_MAP | Mapping Table Purchase Requisition <-> CRM Sales Order | 7 | ITEM_NO | Item | nvarchar | 10 | 0 | | |
TOPJapan |
16 | T7JPCP_DTFLSTR | Define Data File Structure | 6 | ITEM_NO | Item Number | nvarchar | 3 | 0 | | |
TOPLogistics - General |
17 | CRMD_CO_ITEM | CO Account Assignment of Sales Items | 3 | ITEM_NO | Item | nvarchar | 10 | 0 | | |
18 | CRM_SRV_LOG_SC | CRM Service: Logistics Scenarios | 8 | ITEM_NO | Character Field Length = 10 | nvarchar | 10 | 0 | | |
TOPNetwork Operations |
19 | GHO_PP_PTABLE_IT | Item Table for Results of GHO Planning Table | 3 | ITEM_NO | Item Number for OPM Planning Table Results | nvarchar | 6 | 0 | | |
20 | GHO_PP_PTABLE_IV | Item-Validity Table for GHO Planning Table | 3 | ITEM_NO | Item Number for OPM Planning Table Results | nvarchar | 6 | 0 | | |
21 | GHO_PP_PTABLE_LN | Schedule Lines Table for Results of GHO Planning Table | 4 | ITEM_NO | Item Number for OPM Planning Table Results | nvarchar | 6 | 0 | | |
TOPOwnership |
22 | OIUOW_DTD | DOI Transfer Change Detail | 4 | ITEM_NO | Request item number | nvarchar | 6 | 0 | | |
23 | OIUOW_RTD | RD DOI Transferee Detail | 19 | ITEM_NO | Request item number | nvarchar | 6 | 0 | | |
24 | OIUOW_RTD_WK | RD DOI Transferee Detail Worktable | 19 | ITEM_NO | Request item number | nvarchar | 6 | 0 | | |
TOPPayment Item |
25 | BKKPAYMEX_IT | EFT Management: Items in Outgoing Payment Transactions | 4 | ITEM_NO | Sequential Number (5-Figure) | nvarchar | 5 | 0 | | |
26 | BKKPAYMEX_PYNOT | Payment Notes in Outgoing Payment Transactions | 4 | ITEM_NO | Sequential Number (5-Figure) | nvarchar | 5 | 0 | | |
27 | BKKPAYMIN_IT | Table of Imported Items | 5 | ITEM_NO | Sequential Number (5-Figure) | nvarchar | 5 | 0 | | |
28 | BKKPAYMIN_PYNOT | BCA: Table of Payment Notes | 5 | ITEM_NO | Sequential Number (5-Figure) | nvarchar | 5 | 0 | | |
TOPProduction and Revenue Accounting |
29 | OIU_PM_XREF | Cross reference for PRA / PM entities | 5 | ITEM_NO | Sequence number | nvarchar | 3 | 0 | | |
TOPReusable Components of Business Suite Foundation |
30 | /BOBF/DM_SORD_IT | Sales Order Item | 5 | ITEM_NO | Item No | nvarchar | 3 | 0 | | |
31 | /BOFU/DDMOSORDIT | Sales Order Item | 5 | ITEM_NO | Item No | nvarchar | 3 | 0 | | |
32 | /BOFU/DEM_D_ITEM | Delivery Document Item | 5 | ITEM_NO | Item No | nvarchar | 3 | 0 | | |
33 | /BOFU/DTSTSORDIT | Sales Order Item | 4 | ITEM_NO | Item No | nvarchar | 3 | 0 | | |
TOPSAP NetWeaver Mobile - Use subcomponents |
34 | MEREP_TORDERITEM | Sales Order item | 3 | ITEM_NO | Item number | nvarchar | 10 | 0 | | |
35 | MEREP_TORDERITM | Sales Order item | 3 | ITEM_NO | Item number | nvarchar | 10 | 0 | | |