Изменение полей в таблицах БД 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 LateAssignmentOfTransactionNumber 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 PlanDisconnectedMtrlFirstOp 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 LateAssignmentOfTransactionNumber 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 MultipleforMRPSRPandMPS 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 LateAssignmentOfTransactionNumber 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 PaidTaxAmntPaymPointCurr 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 ApplyATPForSalesContracts 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 +