Изменение полей в таблицах БД iScala 3.4 по сравнению с iScala 3.2 / Difference between DB structure of iScala 3.4 and iScala 3.2

Имя таблицы / Table Name Название таблицы / Table Description Имя поля / Field Name Описание поля / Field Description Расширенный комментарий / Extended Comment Тип данных / Data Type Name Длина iScala 3.4 / iScala 3.4 Length Точность iScala 3.4 / iScala 3.4 Precision Длина iScala 3.2 / iScala 3.2 Length Точность iScala 3.2 / iScala 3.2 Precision Новое поле? / is a New Field?
CMH1 Contract History Master File CMH1040 CustPONo Customer Purchase Order Number NVARCHAR 30 20 —
CMH3 Contract Line History File CMH3119 QuantityPerMultiple Quantity Per Multiple NUMERIC 12 8 — — +
DI10 Invoice Head DI10003 OurReference Our Reference NVARCHAR 35 25 —
DI10 Invoice Head DI10004 YourReference Your Reference NVARCHAR 35 25 —
DIH0 Direct Invoice Header History DIH0003 OurReference OurReference NVARCHAR 35 25 —
DIH0 Direct Invoice Header History DIH0004 YourReference YourReference NVARCHAR 35 25 —
GL03 Segment Codes GL03003 Name Dimension Name NVARCHAR 100 25 —
GL03 Segment Codes GL03004 Description1 Description 1 NVARCHAR 100 35 —
GL03 Segment Codes GL03005 Description2 Description 2 NVARCHAR 100 35 —
GL06 Transactions GL06005 TransactTxt Transaction Text NVARCHAR 100 36 —
GL07 Daybook Transactions GL07011 Trantext Transaction Line Text NVARCHAR 100 36 —
GL07 Daybook Transactions GL07024 Linkcode Link Code NCHAR 8 5 —
GL07 Daybook Transactions GL07037 Trantxtocu Transaction Text Line Currency NVARCHAR 100 36 —
GL08 Opening Balances GL08011 Trantext Transaction Line Text NVARCHAR 100 36 —
GL08 Opening Balances GL08024 Linkcode Link Code NCHAR 8 5 —
GL08 Opening Balances GL08037 Trantxtocu Transaction Text Line Currency NVARCHAR 100 36 —
GL10 GL Parameters GL10085 Late Assignment Of Transaction Number Late Assignment Of Transaction Number NCHAR 1 — — +
GL10 GL Parameters GL10086 AmountValidation Bank Statement Amount Validation NCHAR 1 — — +
GL14 Closing Simulation GL14004 Text Text NVARCHAR 100 25 —
GL15 Transaction Workfile C GL15006 TransactTxt TransactTxt NVARCHAR 100 25 —
GL21 Project History GL21006 Text Text NVARCHAR 100 36 —
GL22 Transaction Workfile A GL22030 InstalmentNo Instalment Number INT 3 — — +
GL43 Reconciliations GL43010 TransText Text (First Currency) NVARCHAR 100 36 —
GL43 Reconciliations GL43019 TransactionText2 Text (Second Currency) NVARCHAR 100 36 —
GL53 Account Shedule GL53002 AccountName Account Name NVARCHAR 100 25 —
GL53 Account Shedule GL53010 DescrLine1 Account Description Line 1 NVARCHAR 100 40 —
GL53 Account Shedule GL53011 DescrLine2 Account Description Line 2 NVARCHAR 100 40 —
GL53 Account Shedule GL53012 DescrLine3 Account Description Line 3 NVARCHAR 100 40 —
GL53 Account Shedule GL53051 BalanceType Balance Type INT 1 — — +
GL55 Foreign Descriptions GL55004 Name Name NVARCHAR 100 25 —
GL55 Foreign Descriptions GL55005 DescrLine1 Description Line 1 NVARCHAR 100 40 —
GL55 Foreign Descriptions GL55006 DescrLine2 Description Line 2 NVARCHAR 100 40 —
GL55 Foreign Descriptions GL55007 DescrLine3 Description Line 3 NVARCHAR 100 40 —
GL59 Reconcilation Proposal GL59017 Line21 21Line NVARCHAR 6 2 —
GL59 Reconcilation Proposal GL59018 TransText TransText NVARCHAR 100 36 —
GL5D Multi-Link Statistical Account Balances GL5D001 StatAccountNo Statistical Account Number NCHAR 12 — — +
GL5D Multi-Link Statistical Account Balances GL5D002 LinkedAccountNo Linked Account Number NCHAR 12 — — +
GL5D Multi-Link Statistical Account Balances GL5D003 CurrencyCode Currency Code INT 2 — — +
GL5D Multi-Link Statistical Account Balances GL5D004 YearOpeningBalance Year Opening Balance NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D005 Period1DebitAmnt Period 1 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D006 Period2DebitAmnt Period 2 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D007 Period3DebitAmnt Period 3 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D008 Period4DebitAmnt Period 4 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D009 Period5DebitAmnt Period 5 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D010 Period6DebitAmnt Period 6 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D011 Period7DebitAmnt Period 7 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D012 Period8DebitAmnt Period 8 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D013 Period9DebitAmnt Period 9 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D014 Period10DebitAmnt Period 10 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D015 Period11DebitAmnt Period 11 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D016 Period12DebitAmnt Period 12 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D017 Period13DebitAmnt Period 13 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D018 Period14DebitAmnt Period 14 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D019 Period15DebitAmnt Period 15 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D020 Period16DebitAmnt Period 16 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D021 Period17DebitAmnt Period 17 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D022 Period18DebitAmnt Period 18 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D023 Period19DebitAmnt Period 19 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D024 Period20DebitAmnt Period 20 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D025 Period21DebitAmnt Period 21 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D026 Period22DebitAmnt Period 22 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D027 Period23DebitAmnt Period 23 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D028 Period24DebitAmnt Period 24 Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D029 ClosingPeriodDebitAmnt Closing Period Debit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D030 Period1CreditAmnt Period 1 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D031 Period2CreditAmnt Period 2 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D032 Period3CreditAmnt Period 3 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D033 Period4CreditAmnt Period 4 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D034 Period5CreditAmnt Period 5 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D035 Period6CreditAmnt Period 6 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D036 Period7CreditAmnt Period 7 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D037 Period8CreditAmnt Period 8 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D038 Period9CreditAmnt Period 9 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D039 Period10CreditAmnt Period 10 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D040 Period11CreditAmnt Period 11 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D041 Period12CreditAmnt Period 12 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D042 Period13CreditAmnt Period 13 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D043 Period14CreditAmnt Period 14 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D044 Period15CreditAmnt Period 15 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D045 Period16CreditAmnt Period 16 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D046 Period17CreditAmnt Period 17 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D047 Period18CreditAmnt Period 18 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D048 Period19CreditAmnt Period 19 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D049 Period20CreditAmnt Period 20 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D050 Period21CreditAmnt Period 21 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D051 Period22CreditAmnt Period 22 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D052 Period23CreditAmnt Period 23 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D053 Period24CreditAmnt Period 24 Credit Amount NUMERIC 20 8 — — +
GL5D Multi-Link Statistical Account Balances GL5D054 ClosingPeriodCreditAmnt Closing Period Credit Amount NUMERIC 20 8 — — +
GL60 Allocation Description File GL60048 TextCondensed Condensed Text NVARCHAR 100 36 —
GL62 Allocation Transaction File GL62010 Text Text NVARCHAR 100 25 —
GL80 Un-Authorized Transactions (Greece) GL80011 Trantext Transaction Line Text NVARCHAR 100 36 —
GL80 Un-Authorized Transactions (Greece) GL80024 Linkcode Link Code NCHAR 8 5 —
GL80 Un-Authorized Transactions (Greece) GL80037 Trantxtocu Transaction Text Line Currency NVARCHAR 100 36 —
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8029 TransNo Transaction Number NVARCHAR 9 — — +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8030 OrigRemittanceAmnt Original Remittance Amount NUMERIC 20 8 — — +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8031 OrigRemittanceNo Reference to the original structured remittance NVARCHAR 6 — — +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8032 GLCurrAcc Statistical GL Currency Account NVARCHAR 12 — — +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8033 RemittanceAmntLCU Remittance Amount LCU NUMERIC 20 8 — — +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8034 UsePrepaymentAcc Use Prepayment Account NCHAR 1 — — +
GLCW Compound Periodic Allocation Work File GLCW010 Text Text NVARCHAR 100 36 —
GLCX Petty Cash Extension File GLCX029 InstalmentNo Instalment Number INT 3 — — +
GLCY Petty Cash Transaction File GLCY015 XactionText Transaction Line Text NVARCHAR 100 36 —
GLCY Petty Cash Transaction File GLCY028 LinkCode Link Code NCHAR 8 5 —
GLCY Petty Cash Transaction File GLCY041 XactionTextOCU Transaction Text Line Currency NVARCHAR 100 36 —
GLF1 Financial Reporting Report Definition GLF1001 ReportNumber Report Number INT 6 — — +
GLF1 Financial Reporting Report Definition GLF1002 DataSetName DataSet Name NVARCHAR 100 — — +
GLF1 Financial Reporting Report Definition GLF1003 RowSetNumber RowSet Number INT 6 — — +
GLF1 Financial Reporting Report Definition GLF1004 ColumnSetNumber ColumnSet Number INT 6 — — +
GLF1 Financial Reporting Report Definition GLF1005 IsSystem Is System INT 1 — — +
GLF2 Financial Reporting RowSet GLF2001 RowSetNumber RowSet Number INT 6 — — +
GLF2 Financial Reporting RowSet GLF2002 IsSystem Is System INT 1 — — +
GLF3 Financial Reporting Row GLF3001 RowSetNumber RowSet Number INT 6 — — +
GLF3 Financial Reporting Row GLF3002 RowNumber Row Number INT 6 — — +
GLF3 Financial Reporting Row GLF3003 ParentRowNumber Parent Row Number INT 6 — — +
GLF3 Financial Reporting Row GLF3004 SortOrder Sort Order INT 6 — — +
GLF3 Financial Reporting Row GLF3005 Hidden Hidden NVARCHAR 1 — — +
GLF3 Financial Reporting Row GLF3006 IsSystem Is System INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4001 RowSetNumber RowSet Number INT 6 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4002 RowNumber Row Number INT 6 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4003 Sign Sign INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4004 AccountOperator Account Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4005 AccountExpression Account Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4006 AccountExpression2 Account Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4007 Segment1Operator Segment1 Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4008 Segment1Expression Segment1 Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4009 Segment1Expression2 Segment1 Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4010 Segment2Operator Segment2 Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4011 Segment2Expression Segment2 Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4012 Segment2Expression2 Segment2 Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4013 Segment3Operator Segment3 Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4014 Segment3Expression Segment3 Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4015 Segment3Expression2 Segment3 Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4016 Segment4Operator Segment4 Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4017 Segment4Expression Segment4 Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4018 Segment4Expression2 Segment4 Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4019 Segment5Operator Segment5 Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4020 Segment5Expression Segment5 Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4021 Segment5Expression2 Segment5 Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4022 Segment6Operator Segment6 Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4023 Segment6Expression Segment6 Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4024 Segment6Expression2 Segment6 Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4025 Segment7Operator Segment7 Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4026 Segment7Expression Segment7 Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4027 Segment7Expression2 Segment7 Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4028 Segment8Operator Segment8 Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4029 Segment8Expression Segment8 Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4030 Segment8Expression2 Segment8 Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4031 Segment9Operator Segment9 Operator INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4032 Segment9Expression Segment9 Expression NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4033 Segment9Expression2 Segment9 Expression 2 NVARCHAR 12 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4034 BalanceTypeSource Balance Type Source INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4035 BalanceType Balance Type INT 1 — — +
GLF4 Financial Reporting Leaf Row Properties GLF4036 IsSystem Is System INT 1 — — +
GLF5 Financial Reporting ColumnSet GLF5001 ColumnSetNumber ColumnSet Number INT 6 — — +
GLF5 Financial Reporting ColumnSet GLF5002 IsSystem Is System INT 1 — — +
GLF6 Financial Reporting Column GLF6001 ColumnSetNumber ColumnSet Number INT 6 — — +
GLF6 Financial Reporting Column GLF6002 ColumnNumber Column Number INT 6 — — +
GLF6 Financial Reporting Column GLF6003 SortOrder Sort Order INT 6 — — +
GLF6 Financial Reporting Column GLF6004 DataSetColumnName DataSet Column Name NVARCHAR 100 — — +
GLF6 Financial Reporting Column GLF6005 Year Year INT 1 — — +
GLF6 Financial Reporting Column GLF6006 TransactionType Transaction Type INT 1 — — +
GLF6 Financial Reporting Column GLF6007 BudgetAlternative Budget Alternative INT 1 — — +
GLF6 Financial Reporting Column GLF6008 TimeSpan Time Span INT 2 — — +
GLF6 Financial Reporting Column GLF6009 AmountType Amount Type INT 2 — — +
GLF6 Financial Reporting Column GLF6010 IsSystem Is System INT 1 — — +
GLF7 Accounting Dimension Categories GLF7001 DimensionNumber Dimension Number INT 1 — — +
GLF7 Accounting Dimension Categories GLF7002 CategoryNumber Category Number INT 6 — — +
GLF7 Accounting Dimension Categories GLF7003 ParentCategoryNumber Parent Category Number INT 6 — — +
GLF7 Accounting Dimension Categories GLF7004 SortOrder Sort Order INT 6 — — +
GLF8 Accounting Dimension Categories Leaf Properties GLF8001 DimensionNumber Dimension Number INT 1 — — +
GLF8 Accounting Dimension Categories Leaf Properties GLF8002 CategoryNumber Category Number INT 6 — — +
GLF8 Accounting Dimension Categories Leaf Properties GLF8003 Operator Operator INT 1 — — +
GLF8 Accounting Dimension Categories Leaf Properties GLF8004 Expression1 Expression 1 NVARCHAR 12 — — +
GLF8 Accounting Dimension Categories Leaf Properties GLF8005 Expression2 Expression 2 NVARCHAR 12 — — +
GLFA Financial Reporting Report Definition Descriptions GLFA001 ReportNumber Report Number INT 6 — — +
GLFA Financial Reporting Report Definition Descriptions GLFA002 LanCode LanCode NCHAR 3 — — +
GLFA Financial Reporting Report Definition Descriptions GLFA003 Description Description NVARCHAR 250 — — +
GLFA Financial Reporting Report Definition Descriptions GLFA004 IsSystem Is System INT 1 — — +
GLFB Financial Reporting RowSet Descriptions GLFB001 RowSetNumber RowSet Number INT 6 — — +
GLFB Financial Reporting RowSet Descriptions GLFB002 LanCode LanCode NCHAR 3 — — +
GLFB Financial Reporting RowSet Descriptions GLFB003 Description Description NVARCHAR 250 — — +
GLFB Financial Reporting RowSet Descriptions GLFB004 IsSystem Is System INT 1 — — +
GLFC Financial Reporting Row Descriptions GLFC001 RowSetNumber RowSet Number INT 6 — — +
GLFC Financial Reporting Row Descriptions GLFC002 RowNumber Row Number INT 6 — — +
GLFC Financial Reporting Row Descriptions GLFC003 LanCode LanCode NCHAR 3 — — +
GLFC Financial Reporting Row Descriptions GLFC004 Description Description NVARCHAR 250 — — +
GLFC Financial Reporting Row Descriptions GLFC005 IsSystem Is System INT 1 — — +
GLFD Financial Reporting ColumnSet Descriptions GLFD001 ColumnSetNumber ColumnSet Number INT 6 — — +
GLFD Financial Reporting ColumnSet Descriptions GLFD002 LanCode LanCode NCHAR 3 — — +
GLFD Financial Reporting ColumnSet Descriptions GLFD003 Description Description NVARCHAR 250 — — +
GLFD Financial Reporting ColumnSet Descriptions GLFD004 IsSystem Is System INT 1 — — +
GLFE Financial Reporting Column Descriptions GLFE001 ColumnSetNumber ColumnSet Number INT 6 — — +
GLFE Financial Reporting Column Descriptions GLFE002 ColumnNumber Column Number INT 6 — — +
GLFE Financial Reporting Column Descriptions GLFE003 LanCode LanCode NCHAR 3 — — +
GLFE Financial Reporting Column Descriptions GLFE004 Description Description NVARCHAR 250 — — +
GLFE Financial Reporting Column Descriptions GLFE005 IsSystem Is System INT 1 — — +
GLFF Accounting Dimension Categories Descriptions GLFF001 DimensionNumber Dimension Number INT 1 — — +
GLFF Accounting Dimension Categories Descriptions GLFF002 CategoryNumber Category Number INT 6 — — +
GLFF Accounting Dimension Categories Descriptions GLFF003 LanCode LanCode NCHAR 3 — — +
GLFF Accounting Dimension Categories Descriptions GLFF004 Description Description NVARCHAR 250 — — +
GLGL GL Consolidation GLGL012 TransText Transaction Line Text NVARCHAR 100 36 —
GLGL GL Consolidation GLGL014 Code2 Document Number NVARCHAR 25 23 —
GLGL GL Consolidation GLGL025 LinkCode Link Code NCHAR 8 5 —
GLGL GL Consolidation GLGL038 TransTxtOCU Transaction Text Line Currency NVARCHAR 100 36 —
GLRH Revenue Recognition History WIP Journal GLRH011 TransactionText TransactionText NVARCHAR 100 36 —
GLRH Revenue Recognition History WIP Journal GLRH024 LinkCode LinkCode NCHAR 8 5 —
GLRH Revenue Recognition History WIP Journal GLRH037 TransactionTextOCU TransactionTextOCU NVARCHAR 100 36 —
GLRJ Revenue Recognition Day Book Journal GLRJ011 Trantext Trantext NVARCHAR 100 36 —
GLRJ Revenue Recognition Day Book Journal GLRJ024 Linkcode Linkcode NCHAR 8 5 —
GLRJ Revenue Recognition Day Book Journal GLRJ037 Trantxtocu Trantxtocu NVARCHAR 100 36 —
GLXX Wrk. Acc.Spec. GLXX007 TransactText TransactText NVARCHAR 100 36 —
MP56 MPC Parameters MP56176 NoDecRepRuntime Number of Decimals, Reported Runtime INT 1 — — +
MP56 MPC Parameters MP56177 ReleaseWOAfterchange Release WO After Change NCHAR 1 — — +
MP56 MPC Parameters MP56178 Plan Disconnected MtrlFirstOp Plan disconnected material at first operation NCHAR 1 — — +
MP60 Tmp.Actual cost MP60007 RunTime RunTime NUMERIC 20 8 9 8 —
MP60 Tmp.Actual cost MP60010 TimeDiffer TimeDiffer NUMERIC 20 8 11 8 —
MP67 WO Routings MP67035 IssuedRuntime Issued Run Time NUMERIC 20 8 10 8 —
MP67 WO Routings MP67098 AccessoryRunTime Accessory Run Time NUMERIC 20 8 — — +
MP75 Production Statistics MP75017 RunTime Run Time NUMERIC 20 8 10 8 —
MP75 Production Statistics MP75018 PlanRunTime Run Time Planned NUMERIC 20 8 10 8 —
MP86 C.order -> WO 2 MP86030 AccessoryOperation Accessory Operation NCHAR 3 — — +
MP92 MRP Mtrl. MP92061 RequestedDate Requested Date DATETIME 8 — — +
MP93 MPS Mtrl. MP93054 RequestedDate Requested Date DATETIME 8 — — +
MP9C WIP Transact. II MP9C011 Trantext Transaction Line Text NVARCHAR 100 36 —
MP9C WIP Transact. II MP9C024 Linkcode Link Code NCHAR 8 5 —
MP9C WIP Transact. II MP9C037 Trantxtocu Transaction Text Line Currency NVARCHAR 100 36 —
OR01 Order Head OR01072 CustPONo Customer Purchase Order Number NVARCHAR 30 20 —
OR01 Order Head OR01245 TaxRegDate Tax Registration Date DATETIME 8 — — +
OR01 Order Head OR01246 Contribution Contribution to consolidated invoice NUMERIC 20 8 — — +
OR03 Sales Order Lines OR03143 ExtendedUDF1 Extended User defined field 1 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03144 ExtendedUDF2 Extended User defined field 2 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03145 ExtendedUDF3 Extended User defined field 3 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03146 ExtendedUDF4 Extended User defined field 4 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03147 ExtendedUDF5 Extended User defined field 5 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03148 ExtendedUDF6 Extended User defined field 6 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03149 ExtendedUDF7 Extended User defined field 7 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03150 ExtendedUDF8 Extended User defined field 8 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03151 ExtendedUDF9 Extended User defined field 9 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03152 ExtendedUDF10 Extended User defined field 10 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03153 ExtendedUDF11 Extended User defined field 11 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03154 ExtendedUDF12 Extended User defined field 12 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03155 ExtendedUDF13 Extended User defined field 13 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03156 ExtendedUDF14 Extended User defined field 14 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03157 ExtendedUDF15 Extended User defined field 15 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03158 ExtendedUDF16 Extended User defined field 16 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03159 ExtendedUDF17 Extended User defined field 17 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03160 ExtendedUDF18 Extended User defined field 18 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03161 ExtendedUDF19 Extended User defined field 19 NVARCHAR 150 — — +
OR03 Sales Order Lines OR03162 ExtendedUDF20 Extended User defined field 20 NVARCHAR 150 — — +
OR04 Delivery Addresses OR04027 TaxRegistrationNo Tax Registration No NVARCHAR 20 — — +
OR05 Order Parameters OR05175 DefValidPeriodQuot Default validity period for quotations INT 3 — — +
OR05 Order Parameters OR05176 FreightTaxCode Freight Tax Code INT 2 — — +
OR05 Order Parameters OR05177 ControlStockReturn Control Stock Return NCHAR 1 — — +
OR12 Order History      (Compressed) OR12019 CustPurcOrNo Customer Purchase Order Number NVARCHAR 30 20 —
OR20 HI. Order Head OR20072 CustPONo Customer Purchase Order Number NVARCHAR 30 20 —
OR20 HI. Order Head OR20245 TaxRegDate Tax Registration Date DATETIME 8 — — +
OR20 HI. Order Head OR20246 Contribution Contribution to consolidated invoice NUMERIC 20 8 — — +
OR21 History Sales Order Lines OR21143 ExtendedUDF1 Extended User defined field 1 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21144 ExtendedUDF2 Extended User defined field 2 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21145 ExtendedUDF3 Extended User defined field 3 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21146 ExtendedUDF4 Extended User defined field 4 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21147 ExtendedUDF5 Extended User defined field 5 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21148 ExtendedUDF6 Extended User defined field 6 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21149 ExtendedUDF7 Extended User defined field 7 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21150 ExtendedUDF8 Extended User defined field 8 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21151 ExtendedUDF9 Extended User defined field 9 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21152 ExtendedUDF10 Extended User defined field 10 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21153 ExtendedUDF11 Extended User defined field 11 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21154 ExtendedUDF12 Extended User defined field 12 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21155 ExtendedUDF13 Extended User defined field 13 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21156 ExtendedUDF14 Extended User defined field 14 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21157 ExtendedUDF15 Extended User defined field 15 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21158 ExtendedUDF16 Extended User defined field 16 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21159 ExtendedUDF17 Extended User defined field 17 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21160 ExtendedUDF18 Extended User defined field 18 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21161 ExtendedUDF19 Extended User defined field 19 NVARCHAR 150 — — +
OR21 History Sales Order Lines OR21162 ExtendedUDF20 Extended User defined field 20 NVARCHAR 150 — — +
OR22 HI. Delivery Addresses OR22027 TaxRegistrationNo Tax Registration No NVARCHAR 20 — — +
OR40 Sales Order Header  Historical Versions OR40072 CustPONo Customer Purchase Order Number NVARCHAR 30 20 —
OR40 Sales Order Header  Historical Versions OR40245 TaxRegDate Tax Registration Date DATETIME 8 — — +
OR40 Sales Order Header  Historical Versions OR40246 Contribution Contribution to consolidated invoice NUMERIC 20 8 — — +
OR41 Sales Order Lines Historical Versions OR41143 ExtendedUDF1 Extended User defined field 1 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41144 ExtendedUDF2 Extended User defined field 2 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41145 ExtendedUDF3 Extended User defined field 3 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41146 ExtendedUDF4 Extended User defined field 4 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41147 ExtendedUDF5 Extended User defined field 5 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41148 ExtendedUDF6 Extended User defined field 6 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41149 ExtendedUDF7 Extended User defined field 7 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41150 ExtendedUDF8 Extended User defined field 8 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41151 ExtendedUDF9 Extended User defined field 9 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41152 ExtendedUDF10 Extended User defined field 10 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41153 ExtendedUDF11 Extended User defined field 11 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41154 ExtendedUDF12 Extended User defined field 12 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41155 ExtendedUDF13 Extended User defined field 13 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41156 ExtendedUDF14 Extended User defined field 14 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41157 ExtendedUDF15 Extended User defined field 15 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41158 ExtendedUDF16 Extended User defined field 16 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41159 ExtendedUDF17 Extended User defined field 17 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41160 ExtendedUDF18 Extended User defined field 18 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41161 ExtendedUDF19 Extended User defined field 19 NVARCHAR 150 — — +
OR41 Sales Order Lines Historical Versions OR41162 ExtendedUDF20 Extended User defined field 20 NVARCHAR 150 — — +
OR43 Sales Order Delivery Address Historical Versions OR43027 TaxRegistrationNo Tax Registration No NVARCHAR 20 — — +
ORT1 Sales Order Tax Transactions ORT1067 HMRCPeriodKey HMRC Period Key NVARCHAR 4 — — +
PA03 PA03 Wage Types PA03002 Description Description NVARCHAR 256 25 —
PA03 PA03 Wage Types PA03003 Explanation Explanation NVARCHAR 256 25 —
PA03 PA03 Wage Types PA03012 Prompt1 Question 1 — Label NVARCHAR 256 15 —
PA03 PA03 Wage Types PA03013 Prompt2 Question 2 — Label NVARCHAR 256 15 —
PA17 PA17 Payroll Trans PA17011 Trantext Transaction Line Text NVARCHAR 100 36 —
PA17 PA17 Payroll Trans PA17024 Linkcode In Closing Period NCHAR 8 5 —
PA17 PA17 Payroll Trans PA17037 Trantxtocu Transaction Text (Line Currency) NVARCHAR 100 36 —
PC01 Purchase Order Head PC01058 CustomerPoNumber Customer Purchase Order Number NVARCHAR 30 20 —
PC01 Purchase Order Head PC01109 PaymentFlag Payment Flag NCHAR 1 — — +
PC03 Purchase Order Lines PC03119 DeliveryBlock Delivery Block INT 1 — — +
PC05 Purchase Order Parameters PC05114 DeliveryBlock Delivery Block INT 1 — — +
PC41 Purchase Order Head History PC41058 CustomerPoNumber Customer Purchase Order Number NVARCHAR 30 20 —
PC41 Purchase Order Head History PC41109 PaymentFlag Payment Flag NCHAR 1 — — +
PC42 Purchase Order Lines History PC42119 DeliveryBlock Delivery Block INT 1 — — +
PCD7 Customs Declaration Taxes PCD7076 HMRCPeriodKey HMRC Period Key NVARCHAR 4 — — +
PCT1 PC VAT Transactions PCT1073 HMRCPeriodKey HMRC Period Key NVARCHAR 4 — — +
PCXX P.Ord.Inv.Entry PCXX013 PwoData12 PwoData12 NVARCHAR 100 36 —
PL01 Suppliers PL01155 Anonymized Anonymized NCHAR 1 — — +
PL04 Invoice Journal PL04011 Trantext Transaction Line Text NVARCHAR 100 36 —
PL04 Invoice Journal PL04024 Linkcode In Closing Period NCHAR 8 5 —
PL04 Invoice Journal PL04037 TranTextLineCurr Transaction Text (Line Currency) NVARCHAR 100 36 —
PL05 Payment Journal PL05011 Trantext Transaction Line Text NVARCHAR 100 36 —
PL05 Payment Journal PL05024 Linkcode In Closing Period NCHAR 8 5 —
PL05 Payment Journal PL05037 Trantxtocu Transaction Text (Line Currency) NVARCHAR 100 36 —
PL08 Purchase Parameters PL08046 Late Assignment Of Transaction Number Late Assignment Of Transaction Number NCHAR 1 — — +
PL08 Purchase Parameters PL08047 DefaultSuppLCStatus Default Supplier Life Cycle Status NCHAR 1 — — +
PL08 Purchase Parameters PL08048 DefaultCentralBankCode Default Central Bank Code NCHAR 4 — — +
PL10 Payment Ledger PL10003 LineNo Line Number NVARCHAR 6 2 —
PL17 VAT Transactions PL17073 HMRCPeriodKey HMRC Period Key NVARCHAR 4 — — +
PL19 Standard Suppliers PL19155 Anonymized Anonymized NCHAR 1 — — +
PL21 Purchase Ledger PL21003 LineNo Line Number NVARCHAR 6 2 —
PL22 Payment Terms PL PL22022 EndOfMonthSwitch End Of Month Switch NVARCHAR 1 — — +
PL22 Payment Terms PL PL22023 DaysAfterEndOfMonth Days After End Of Month INT 4 — — +
PL30 Check Register PL30010 TransText Transaction Text NVARCHAR 100 36 —
PL40 Prepayment Allocation Lines PL40001 OrderNo Order Number NCHAR 10 — — +
PL40 Prepayment Allocation Lines PL40002 LineNo Line Number NCHAR 6 — — +
PL40 Prepayment Allocation Lines PL40003 SupplierCode Supplier Code NVARCHAR 10 — — +
PL40 Prepayment Allocation Lines PL40004 PrepaymInvNo Prepayment Invoice Number NVARCHAR 25 — — +
PL40 Prepayment Allocation Lines PL40005 AllocAmntPCU Allocated Amount PCU NUMERIC 20 8 — — +
PL40 Prepayment Allocation Lines PL40006 AllocAmntOCU Allocated Amount OCU NUMERIC 20 8 — — +
PL40 Prepayment Allocation Lines PL40007 PCUCode Payment Currency Code INT 2 — — +
PL40 Prepayment Allocation Lines PL40008 PCUExchangeRate1 PCU Exchange Rate 1 NUMERIC 10 8 — — +
PL40 Prepayment Allocation Lines PL40009 PCUExchAlgorithm PCU Exchange Algorithm NCHAR 3 — — +
PL40 Prepayment Allocation Lines PL40010 PCUExchangeRate2 PCU Exchange Rate 2 NUMERIC 10 8 — — +
PL40 Prepayment Allocation Lines PL40011 OCUCode Order Currency Code INT 2 — — +
PL40 Prepayment Allocation Lines PL40012 OCUExchangeRate1 OCU Exchange Rate 1 NUMERIC 10 8 — — +
PL40 Prepayment Allocation Lines PL40013 OCUExchAlgorithm OCU Exchange Algorithm NCHAR 3 — — +
PL40 Prepayment Allocation Lines PL40014 OCUExchangeRate2 OCU Exchange Rate 2 NUMERIC 10 8 — — +
PL40 Prepayment Allocation Lines PL40015 Status Status NCHAR 1 — — +
PL40 Prepayment Allocation Lines PL40016 Remark Remark NVARCHAR 40 — — +
PL41 Prepayment Tax Lines PL41001 OrderNo Order Number NCHAR 10 — — +
PL41 Prepayment Tax Lines PL41002 LineNo Line Number NCHAR 6 — — +
PL41 Prepayment Tax Lines PL41003 TaxBaseLineNo Tax Base Line Number NCHAR 6 — — +
PL41 Prepayment Tax Lines PL41004 OrderLineNo Order Line Number NCHAR 6 — — +
PL41 Prepayment Tax Lines PL41005 TaxCode Tax Code NCHAR 6 — — +
PL41 Prepayment Tax Lines PL41006 GrossTaxBasePCU Gross Tax Base PCU NUMERIC 20 8 — — +
PL41 Prepayment Tax Lines PL41007 NetTaxBasePCU Net Tax Base PCU NUMERIC 20 8 — — +
PL41 Prepayment Tax Lines PL41008 TaxAmntPCU Tax Amount PCU NUMERIC 20 8 — — +
PL41 Prepayment Tax Lines PL41009 GrossTaxBaseLCU Gross Tax Base LCU NUMERIC 20 8 — — +
PL41 Prepayment Tax Lines PL41010 NetTaxBaseLCU Net Tax Base LCU NUMERIC 20 8 — — +
PL41 Prepayment Tax Lines PL41011 TaxAmntLCU Tax Amount LCU NUMERIC 20 8 — — +
PL43 Prepayment Deductions PL43001 OrderNo Order Number NCHAR 10 — — +
PL43 Prepayment Deductions PL43002 LineNo Line Number NCHAR 6 — — +
PL43 Prepayment Deductions PL43003 TaxBaseLineNo Tax Base Line Number NCHAR 6 — — +
PL43 Prepayment Deductions PL43004 PurchaseInvoiceNo Purchase Invoice Number NVARCHAR 25 — — +
PL43 Prepayment Deductions PL43005 DeductAmountPCU Deducted Amount PCU NUMERIC 20 8 — — +
PL43 Prepayment Deductions PL43006 DeductTaxAmntPCU Deducted Tax Amount PCU NUMERIC 20 8 — — +
PL43 Prepayment Deductions PL43007 DeductAmountICU Deducted Amount ICU NUMERIC 20 8 — — +
PL43 Prepayment Deductions PL43008 DeductTaxAmntICU Deducted Tax Amount ICU NUMERIC 20 8 — — +
PL43 Prepayment Deductions PL43009 DeductAmountLCU Deducted Amount LCU NUMERIC 20 8 — — +
PL43 Prepayment Deductions PL43010 DeductTaxAmntLCU Deducted Tax Amount LCU NUMERIC 20 8 — — +
PL95 Russian VAT wrk PL95002 LineNo LineNo NCHAR 8 4 —
PLH4 Recharge Invoice Accounts Payable transaction lines PLH4026 LinkCode In Closing Period NCHAR 8 5 —
PLH6 Inter-Company Transaction Entry PLH6024 LinkCode In Closing Period NCHAR 8 5 —
PLXX PLXX Work File PLXX003 PaymentNo PaymentNo NVARCHAR 7 3 —
PN19 PN19 Bal.Rep.Work PN19006 AdditionInfo AdditionInfo NCHAR 6 5 —
PN20 PN Invvoices/Notes Cross Reference PN20003 PaymNo Payment Number NVARCHAR 6 2 —
PR01 Main Project File PR01106 CustomPONo Customer Purchase Order Number NVARCHAR 30 20 —
PR32 Project/GL Transaction File PR32011 Trantext Transaction Line Text NVARCHAR 100 36 —
PR32 Project/GL Transaction File PR32024 Linkcode Link Code NCHAR 8 5 —
PR32 Project/GL Transaction File PR32037 Trantxtocu Transaction Text Line Currency NVARCHAR 100 36 —
PR41 Transaction Journal PR41010 Text Text NVARCHAR 100 35 —
PR45 Invoice Statistics Head PR45027 CustPOno Customer Purchase Order Number NVARCHAR 30 20 —
PRGL Project History WIP Journal PRGL011 TransactionText TransactionText NVARCHAR 100 36 —
PRGL Project History WIP Journal PRGL024 LinkCode LinkCode NCHAR 8 5 —
PRGL Project History WIP Journal PRGL037 TransactionTextOCU TransactionTextOCU NVARCHAR 100 36 —
PRXX Tr.Entries wrk. PRXX012 Text Text NVARCHAR 100 35 —
SC01 Stock Item File SC01267 Deactivated Deactivated NCHAR 1 — — +
SC10 Stock Parameters 1 SC10131 BEDateinGLJournal BE Date in GL Journal INT 1 — — +
SC10 Stock Parameters 1 SC10132 LongDescLan Long Description Language NVARCHAR 3 — — +
SC10 Stock Parameters 1 SC10133 DateonTT05 Date on Stock Transaction type 05 INT 1 — — +
SC25 GL Transactions SC25011 Trantext Transaction Line Text NVARCHAR 100 36 —
SC25 GL Transactions SC25024 Linkcode In Closing Period NCHAR 8 5 —
SC25 GL Transactions SC25037 Trantxtocu Transaction Text Line Currency NVARCHAR 100 36 —
SC25 GL Transactions SC25041 BEDate BE-Date DATETIME 8 — — +
SC25 GL Transactions SC25042 OrderNumber Order Number NVARCHAR 10 — — +
SC25 GL Transactions SC25043 CostType Cost Type NCHAR 2 — — +
SC25 GL Transactions SC25044 Source Transcation Souce NCHAR 1 — — +
SC37 Standard Stock Items SC37267 Deactivated Deactivated NCHAR 1 — — +
SC38 Standard Item Discounts SC38001 StockCode Stock Code NVARCHAR 35 1 —
SC38 Standard Item Discounts SC38002 DiscountLevel1Quantity Discount Level 1, Quantity NUMERIC 12 8 45 —
SC38 Standard Item Discounts SC38003 DiscountLevel1Discount Discount Level 1, Discount NUMERIC 6 8 35 —
SC38 Standard Item Discounts SC38004 DiscountLevel1Price Discount Level 1, Price NUMERIC 20 8 25 —
SC38 Standard Item Discounts SC38005 DiscountLevel2Quantity Discount Level 2, Quantity NUMERIC 12 8 25 —
SC38 Standard Item Discounts SC38006 DiscountLevel2Discount Discount Level 2, Discount NUMERIC 6 8 20 —
SC38 Standard Item Discounts SC38007 DiscountLevel2Price Discount Level 2, Price NUMERIC 20 8 2 —
SC38 Standard Item Discounts SC38008 DiscountLevel3Quantity Discount Level 3, Quantity NUMERIC 12 8 20 8 —
SC38 Standard Item Discounts SC38010 DiscountLevel3Price Discount Level 3, Price NUMERIC 20 8 8 —
SC38 Standard Item Discounts SC38011 DiscountLevel4Quantity Discount Level 4, Quantity NUMERIC 12 8 8 —
SC38 Standard Item Discounts SC38012 DiscountLevel4Discount Discount Level 4, Discount NUMERIC 6 8 12 —
SC38 Standard Item Discounts SC38013 DiscountLevel4Price Discount Level 4, Price NUMERIC 20 8 3 —
SC38 Standard Item Discounts SC38015 DiscountLevel5Discount Discount Level 5, Discount NUMERIC 6 8 12 8 —
SC38 Standard Item Discounts SC38016 DiscountLevel5Price Discount Level 5, Price NUMERIC 20 8 6 8 —
SC38 Standard Item Discounts SC38017 DiscountLevel6Quantity Discount Level 6, Quantity NUMERIC 12 8 20 8 —
SC38 Standard Item Discounts SC38018 DiscountLevel6Discount Discount Level 6, Discount NUMERIC 6 8 12 8 —
SC38 Standard Item Discounts SC38019 DiscountLevel6Price Discount Level 6, Price NUMERIC 20 8 6 8 —
SC38 Standard Item Discounts SC38020 DiscountLevel7Quantity Discount Level 7, Quantity NUMERIC 12 8 20 8 —
SC38 Standard Item Discounts SC38021 DiscountLevel7Discount Discount Level 7, Discount NUMERIC 6 8 12 8 —
SC38 Standard Item Discounts SC38022 DiscountLevel7Price Discount Level 7, Price NUMERIC 20 8 6 8 —
SC38 Standard Item Discounts SC38023 DiscountLevel8Quantity Discount Level 8, Quantity NUMERIC 12 8 20 8 —
SC38 Standard Item Discounts SC38024 DiscountLevel8Discount Discount Level 8, Discount NUMERIC 6 8 12 8 —
SC38 Standard Item Discounts SC38025 DiscountLevel8Price Discount Level 8, Price NUMERIC 20 8 6 8 —
SC63 BoxLine SC63019 CustomerPO Customer Purchase Order Number NVARCHAR 30 20 —
SCGL HI. GL Transactions SCGL011 Trantext Transaction Line Text NVARCHAR 100 36 —
SCGL HI. GL Transactions SCGL024 Linkcode In Closing Period NCHAR 8 5 —
SCGL HI. GL Transactions SCGL037 Trantxtocu Transaction Text Line Currency NVARCHAR 100 36 —
SCGL HI. GL Transactions SCGL041 BEDate BE-Date DATETIME 8 — — +
SCGL HI. GL Transactions SCGL042 SupplierCustomer Supplier or Customer NVARCHAR 10 — — +
SCP5 Discount per Stock Code SCP5001 StockCode Stock Code NVARCHAR 35 — — +
SCP5 Discount per Stock Code SCP5002 DiscountLevel1Quantity Discount Level 1, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5003 DiscountLevel1Discount Discount Level 1, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5004 DiscountLevel1Price Discount Level 1, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5005 DiscountLevel2Quantity Discount Level 2, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5006 DiscountLevel2Discount Discount Level 2, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5007 DiscountLevel2Price Discount Level 2, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5008 DiscountLevel3Quantity Discount Level 3, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5009 DiscountLevel3Discount Discount Level 3, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5010 DiscountLevel3Price Discount Level 3, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5011 DiscountLevel4Quantity Discount Level 4, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5012 DiscountLevel4Discount Discount Level 4, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5013 DiscountLevel4Price Discount Level 4, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5014 DiscountLevel5Quantity Discount Level 5, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5015 DiscountLevel5Discount Discount Level 5, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5016 DiscountLevel5Price Discount Level 5, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5017 DiscountLevel6Quantity Discount Level 6, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5018 DiscountLevel6Discount Discount Level 6, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5019 DiscountLevel6Price Discount Level 6, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5020 DiscountLevel7Quantity Discount Level 7, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5021 DiscountLevel7Discount Discount Level 7, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5022 DiscountLevel7Price Discount Level 7, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5023 DiscountLevel8Quantity Discount Level 8, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5024 DiscountLevel8Discount Discount Level 8, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5025 DiscountLevel8Price Discount Level 8, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6001 StockCode Stock Code NVARCHAR 35 — — +
SCP6 Price and Discount per Stock code — Customer SCP6002 CustomerCode Customer Code NVARCHAR 10 — — +
SCP6 Price and Discount per Stock code — Customer SCP6003 CustomerStockCode Customer Stock Code NVARCHAR 35 — — +
SCP6 Price and Discount per Stock code — Customer SCP6004 CustomerDescription1 Customer Description 1 NVARCHAR 25 — — +
SCP6 Price and Discount per Stock code — Customer SCP6005 CustomerDescription2 Customer Description 2 NVARCHAR 25 — — +
SCP6 Price and Discount per Stock code — Customer SCP6006 Remark Remark NVARCHAR 20 — — +
SCP6 Price and Discount per Stock code — Customer SCP6007 CurrencyCode Currency Code INT 2 — — +
SCP6 Price and Discount per Stock code — Customer SCP6008 Price Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6009 Discount Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6010 ValidfromDate Valid from Date DATETIME 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6011 ValidtoDate Valid to Date DATETIME 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6012 YearlyBudget Yearly Budget NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6013 BudgetProfile Budget Profile INT 1 — — +
SCP6 Price and Discount per Stock code — Customer SCP6014 Spare Spare NVARCHAR 10 — — +
SCP6 Price and Discount per Stock code — Customer SCP6015 DiscountLevel1Quantity Discount Level 1, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6016 DiscountLevel1Discount Discount Level 1, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6017 DiscountLevel1Price Discount Level 1, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6018 DiscountLevel2Quantity Discount Level 2, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6019 DiscountLevel2Discount Discount Level 2, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6020 DiscountLevel2Price Discount Level 2, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6021 DiscountLevel3Quantity Discount Level 3, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6022 DiscountLevel3Discount Discount Level 3, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6023 DiscountLevel3Price Discount Level 3, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6024 DiscountLevel4Quantity Discount Level 4, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6025 DiscountLevel4Discount Discount Level 4, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6026 DiscountLevel4Price Discount Level 4, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6027 DiscountLevel5Quantity Discount Level 5, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6028 DiscountLevel5Discount Discount Level 5, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6029 DiscountLevel5Price Discount Level 5, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6030 DiscountLevel6Quantity Discount Level 6, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6031 DiscountLevel6Discount Discount Level 6, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6032 DiscountLevel6Price Discount Level 6, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6033 DiscountLevel7Quantity Discount Level 7, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6034 DiscountLevel7Discount Discount Level 7, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6035 DiscountLevel7Price Discount Level 7, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6036 DiscountLevel8Quantity Discount Level 8, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6037 DiscountLevel8Discount Discount Level 8, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6038 DiscountLevel8Price Discount Level 8, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7001 StockCode Stock Code NVARCHAR 35 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7002 SupplierCode Supplier Code NVARCHAR 10 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7003 SupplierStockCode Supplier Stock Code NVARCHAR 35 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7004 SupplierDescription1 Supplier Description 1 NVARCHAR 25 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7005 SupplierDescription2 Supplier Description 2 NVARCHAR 25 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7006 Remark Remark NVARCHAR 20 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7007 CurrencyCode Currency Code INT 2 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7008 Price Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7009 Discount Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7010 ValidfromDate Valid from Date DATETIME 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7011 ValidtoDate Valid to Date DATETIME 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7012 ReOrderLevel Re-Order Level NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7013 DeliveryTime Delivery Time INT 3 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7014 OptimalPurchaseQuantity Optimal Purchase Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7015 DiscountLevel1Quantity Discount Level 1, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7016 DiscountLevel1Discount Discount Level 1, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7017 DiscountLevel1Price Discount Level 1, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7018 DiscountLevel2Quantity Discount Level 2, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7019 DiscountLevel2Discount Discount Level 2, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7020 DiscountLevel2Price Discount Level 2, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7021 DiscountLevel3Quantity Discount Level 3, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7022 DiscountLevel3Discount Discount Level 3, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7023 DiscountLevel3Price Discount Level 3, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7024 DiscountLevel4Quantity Discount Level 4, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7025 DiscountLevel4Discount Discount Level 4, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7026 DiscountLevel4Price Discount Level 4, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7027 DiscountLevel5Quantity Discount Level 5, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7028 DiscountLevel5Discount Discount Level 5, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7029 DiscountLevel5Price Discount Level 5, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7030 DiscountLevel6Quantity Discount Level 6, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7031 DiscountLevel6Discount Discount Level 6, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7032 DiscountLevel6Price Discount Level 6, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7033 DiscountLevel7Quantity Discount Level 7, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7034 DiscountLevel7Discount Discount Level 7, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7035 DiscountLevel7Price Discount Level 7, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7036 DiscountLevel8Quantity Discount Level 8, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7037 DiscountLevel8Discount Discount Level 8, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7038 DiscountLevel8Price Discount Level 8, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7039 DeliveryTimeUnit Delivery Time Unit INT 1 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7040 PriceMultiple Price Multiple NUMERIC 10 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7041 Multiple for MRPSRPandMPS Multiple for MRP, SRP and MPS NUMERIC 12 8 — — +
SL01 Customer File SL01006 Reference1 Reference 1 NVARCHAR 35 20 —
SL01 Customer File SL01007 Reference2 Reference 2 NVARCHAR 35 20 —
SL01 Customer File SL01008 Reference3 Reference 3 NVARCHAR 35 20 —
SL01 Customer File SL01009 Reference4 Reference 4 NVARCHAR 35 20 —
SL03 Sales Ledger SL03137 TaxRegDate Tax Registration Date DATETIME 8 — — +
SL03 Sales Ledger SL03138 TaxRegNo Tax Registration No NVARCHAR 9 — — +
SL04 Invoice Journal SL04011 Trantext Transaction Line Text NVARCHAR 100 36 —
SL04 Invoice Journal SL04024 Linkcode In Closing Period NCHAR 8 5 —
SL04 Invoice Journal SL04037 Trantxtocu Transaction Text (Line Currency) NVARCHAR 100 36 —
SL05 Payment Journal SL05011 Trantext Transaction Line Text NVARCHAR 100 36 —
SL05 Payment Journal SL05024 Linkcode In Closing Period NCHAR 8 5 —
SL05 Payment Journal SL05037 Trantxtocu Transaction Text Payment Currency NVARCHAR 100 36 —
SL08 Sales Ledger Parameters SL08137 Late Assignment Of Transaction Number Late Assignment Of Transaction Number NCHAR 1 — — +
SL08 Sales Ledger Parameters SL08138 DefaultInvoiceSplit Default Invoice Split INT 1 — — +
SL08 Sales Ledger Parameters SL08139 ExportCodeGCCVAT Export code GCC VAT implementing states INT 1 — — +
SL14 Delivery Addresses SL14030 TaxRegistrationNo Tax Registration No NVARCHAR 20 — — +
SL14 Delivery Addresses SL14031 DeliveryMethod Delivery Method NCHAR 2 — — +
SL17 VAT Transactions SL17067 HMRCPeriodKey HMRC Period Key NVARCHAR 4 — — +
SL18 Invoice Consolidation SL18032 DelTaxRegistrationNo Delivery Tax Registration No NVARCHAR 20 — — +
SL19 Standard Customers SL19006 Reference1 Reference 1 NVARCHAR 35 20 —
SL19 Standard Customers SL19007 Reference2 Reference 2 NVARCHAR 35 20 —
SL19 Standard Customers SL19008 Reference3 Reference 3 NVARCHAR 35 20 —
SL19 Standard Customers SL19009 Reference4 Reference 4 NVARCHAR 35 20 —
SL21 Sales Ledger Payments SL21003 LineNumber Line Number NVARCHAR 6 2 —
SL29 Invoice Consolidation History SL29032 DelTaxRegistrationNo Delivery Tax Registration No NVARCHAR 20 — — +
SL31 Prepayment Allocation Lines SL31031 TaxRegDate Tax Registration Date DATETIME 8 — — +
SL45 Extended Bank Info SL45033 TaxPaymCurrInvPoint Tax/vat Payment Currency — Invoice Point INT 2 — — +
SL45 Extended Bank Info SL45034 TaxPaymCurrPaymPoint Tax/vat Payment Currency — Payment Point INT 2 — — +
SL45 Extended Bank Info SL45035 GLTaxPaymAcc GL tax/vat payment account NVARCHAR 12 — — +
SLE5 Sales Ledger Payment Provisional SLE5011 TransacText TransacText NVARCHAR 100 36 —
SLE5 Sales Ledger Payment Provisional SLE5024 Linkcode Linkcode NCHAR 8 5 —
SLE5 Sales Ledger Payment Provisional SLE5037 TransTxtOCU TransTxtOCU NVARCHAR 100 36 —
SLH1 Invoice Header History SLH1062 EmailFrom Email From NVARCHAR 200 — — +
SLH1 Invoice Header History SLH1063 FileName File Name NVARCHAR 250 — — +
SLH1 Invoice Header History SLH1064 PaperCopiesToPrint Paper copies to print INT 4 — — +
SLH1 Invoice Header History SLH1065 NumberOfXMLSendings Number of XML sendings INT 4 — — +
SLH1 Invoice Header History SLH1066 LatestXMLSending Latest XML sending timestamp DATETIME 17 — — +
SLH1 Invoice Header History SLH1067 LatestReprint Latest reprint timestamp DATETIME 17 — — +
SLH1 Invoice Header History SLH1068 CustPONum Customer PO number NVARCHAR 30 — — +
SLH1 Invoice Header History SLH1069 DocumentID Document ID INT 2 — — +
SLH1 Invoice Header History SLH1070 TaxRegDate Tax Registration Date DATETIME 8 — — +
SLH1 Invoice Header History SLH1071 CreditReason Credit Reason NVARCHAR 50 — — +
SLH1 Invoice Header History SLH1072 OriginalInvoice Original Invoice NVARCHAR 15 — — +
SLH2 Invoice Issuer/Recipient  History SLH2053 EndpointID PEPPOL Endpoint ID NVARCHAR 25 — — +
SLH2 Invoice Issuer/Recipient  History SLH2054 EndpointSchemeID PEPPOL EndpointScheme ID INT 4 — — +
SLH2 Invoice Issuer/Recipient  History SLH2055 ExportCode Export Code INT 1 — — +
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4026 LinkCode In Closing Period NCHAR 8 5 —
SLH6 Invoice Lines Details History SLH6072 NetLineDiscountOCU Net Line Discount OCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6073 NetLineDiscountLCU Net Line Discount LCU NUMERIC 20 8 — — +
SLI3 Payment Term Instalments SL SLI3027 InvPointCurrTax Invoice Point Currency (tax/vat) INT 2 — — +
SLI3 Payment Term Instalments SL SLI3028 PaymPointCurrTax Payment Point Currency (tax/vat) INT 2 — — +
SLI3 Payment Term Instalments SL SLI3029 TaxAmntPaymPointCurr Tax/vat Amount Payment in Point Currency NUMERIC 20 8 — — +
SLI3 Payment Term Instalments SL SLI3030 Paid Tax Amnt Paym Point Curr Paid Tax Amount in Payment Point Currency NUMERIC 20 8 — — +
SLI3 Payment Term Instalments SL SLI3031 GLTaxPaymAcc GL tax/vat payment account NVARCHAR 12 — — +
SLXX Customer Statement work file SLXX004 PaymentNo PaymentNo NVARCHAR 7 3 —
SLXZ Customer Statement by Date work file SLXZ003 woref woref NCHAR 7 3 —
SM01 Service Order Master File SM01005 CustomerPONo Customer Purchase Order Number NVARCHAR 30 20 —
SM04 Service Order Invoice Customer File SM04133 CreditReason Credit Reason NVARCHAR 50 — — +
SM11 Service Contract Master File I/O SM11040 CustPONo Customer Purchase Order Number NVARCHAR 30 20 —
SM13 Service Contract Line File I/O SM13119 QuantityPerMultiple Quantity Per Multiple NUMERIC 12 8 — — +
SM31 WIP Transaction Journal SM31011 Trantext Transaction Line Text NVARCHAR 100 36 —
SM31 WIP Transaction Journal SM31024 Linkcode Link Code NCHAR 8 5 —
SM31 WIP Transaction Journal SM31037 Trantxtocu Transaction Text Line Currency NVARCHAR 100 36 —
SM33 WIP Transaction Journal SM33009 TranText Transaction Text NCHAR 100 25 —
SM33 WIP Transaction Journal SM33015 TranTextOCU Transaction Text OCU NCHAR 100 25 —
SM33 WIP Transaction Journal SM33028 LinkCode Link Code NCHAR 8 5 —
SM41 Service Order Master History File SM41005 CustomerPONo Customer Purchase Order Number NVARCHAR 30 20 —
SM48 Service Order Invoice Customer File History SM48133 CreditReason Credit Reason NVARCHAR 50 — — +
SM69 Contract Codes SM69139 Apply ATP For Sales Contracts Apply ATP For Sales Contracts NCHAR 1 — — +
ST25 Lease Statistics ST25014 CustomerPONumber Customer PO Number NVARCHAR 30 20 —
SY29 VAT Codes SY29045 TaxTypeSTE Tax Type linked to STE tax NCHAR 6 — — +
SY47 Business Destinations SY47003 DocumentID Document ID NCHAR 3 2 —
SY55 Cheque Transactions SY55011 TransactionText Transaction Line Text NVARCHAR 100 36 —
SY55 Cheque Transactions SY55024 LinkCode Link Code NCHAR 8 5 —
SY55 Cheque Transactions SY55037 XactionTextOCU Transaction Text Line Currency NVARCHAR 100 36 —
SY80 Customer Site Address File I/O SY80013 Reference Reference NVARCHAR 35 25 —
SYES Dynamic email setup SYES002 SourceTO Source TO INT 2 1 —
SYES Dynamic email setup SYES003 SourceCC Source CC INT 2 1 —
SYES Dynamic email setup SYES004 SourceBCC Source BCC INT 2 1 —
SYIC Invoice Consolidation Criteria Fields SYIC001 TargetInvoice Target Invoice INT 1 — — +
SYIC Invoice Consolidation Criteria Fields SYIC002 ConsKeyFld Consolidation Key Field NVARCHAR 7 — — +
SYIC Invoice Consolidation Criteria Fields SYIC003 SortOrder Sort Order INT 3 — — +
SYIF Invoice Consolidation Common Value Fields SYIF001 TargetInvoice Target Invoice INT 1 — — +
SYIF Invoice Consolidation Common Value Fields SYIF002 CommonValueFld Common Value Field NVARCHAR 7 — — +
SYIF Invoice Consolidation Common Value Fields SYIF003 SelectionFld Selection Field NVARCHAR 7 — — +
SYIF Invoice Consolidation Common Value Fields SYIF004 Condition Condition NCHAR 1 — — +
SYIJ Invoicing jobs interconnection table SYIJ001 SessionID Session ID NVARCHAR 42 — — +
SYIJ Invoicing jobs interconnection table SYIJ002 RecordType Record Type INT 1 — — +
SYIJ Invoicing jobs interconnection table SYIJ003 Status Status INT 1 — — +
SYIJ Invoicing jobs interconnection table SYIJ004 WorkItemType Work Item Type INT 2 — — +
SYIJ Invoicing jobs interconnection table SYIJ005 WorkItemID Work Item ID NVARCHAR 50 — — +
SYIJ Invoicing jobs interconnection table SYIJ006 TimeStamp Time Stamp DATETIME 17 — — +
SYIJ Invoicing jobs interconnection table SYIJ007 Message Message NVARCHAR 250 — — +
SYIJ Invoicing jobs interconnection table SYIJ008 GUID GUID NVARCHAR 38 — — +
SYPF Print Queue Filters SYPF001 FilterName Filter Name NVARCHAR 50 — — +
SYPF Print Queue Filters SYPF002 FilterDescription Filter Description NVARCHAR 150 — — +
SYPF Print Queue Filters SYPF003 FilterBody Filter Body NVARCHAR 4000 — — +
SYPQ Print Job Queue Table SYPQ008 Status Status INT 1 — — +
SYPQ Print Job Queue Table SYPQ009 Scheduled Scheduled NCHAR 1 — — +
SYPQ Print Job Queue Table SYPQ010 Parameters Parameters NVARCHAR 4000 — — +
SYPQ Print Job Queue Table SYPQ011 Result Result NVARCHAR 4000 — — +
SYPQ Print Job Queue Table SYPQ012 JobRequestID Job Request ID NVARCHAR 36 — — +
SYPQ Print Job Queue Table SYPQ013 StatusDateTime Status DateTime DATETIME 17 — — +
SYPQ Print Job Queue Table SYPQ014 ParentCounter Parent Counter NVARCHAR 10 — — +
SYPQ Print Job Queue Table SYPQ015 MessageGroupID Resulting Message Group ID NVARCHAR 42 — — +
SYTB Tax Box Links SYTB001 TaxBoxCode Tax Box Code NCHAR 6 — — +
SYTB Tax Box Links SYTB002 TaxCode Tax Code NCHAR 2 — — +
SYTB Tax Box Links SYTB003 Module Module INT 1 — — +
SYTB Tax Box Links SYTB004 AmountType Amount Type INT 2 — — +