Apicosoft

ERP iScala Database Structure
iScala Supprort & Customization

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Read More Contact Us
Epicor Service Connect

Integration with any third-party services. Customize internal workflows.

Read More Contact Us
Reporting

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
Tables
Name Description Dependences Example
sca_trg_Audit_SL01 Audit trigger for SL01 table Company sca_trg_Audit_SL010100
sca_trg_Audit_SL03 Audit trigger for SL03 table Company sca_trg_Audit_SL030100
sca_trg_Audit_SL08 Audit trigger for SL08 table Company Year sca_trg_Audit_SL080112
sca_trg_Audit_SL14 Audit trigger for SL14 table Company sca_trg_Audit_SL140100
sca_trg_Audit_SL45 Audit trigger for SL45 table Company sca_trg_Audit_SL450100
sca_trg_Audit_SLM0 Audit trigger for SLM0 table Company sca_trg_Audit_SLM00100
SL01 Customer File Company SL010100
SL03 Sales Ledger Invoices Company SL030100
SL04 Sales Ledger Invoice Journal Company Year SL040112
SL05 Sales Ledger Payment Journal Company Year SL050112
SL07 Interest Charged Company SL070100
SL08 Sales Ledger Parameters Company Year SL080112
SL09 Automatic Accounting SL Company Year SL090112
SL10 Payment Ledger (not used) Company SL100100
SL11 Payment Ledger Proposal Company SL110100
SL12 Customer Payment Proposal Header Company SL120100
SL14 Customer Delivery Addresses Company SL140100
SL15 Customer Commissions Company SL150100
SL16 Due Commissions Company SL160100
SL17 VAT Transactions Company SL170100
SL18 Invoice Consolidation Company SL180100
SL19 Customer Templates Company SL190100
SL21 Sales Ledger Payments Company SL210100
SL22 Payment Terms SL Company SL220100
SL23 Payment Terms Descriptions Company SL230100
SL24 Sales Statement Tax Variance File Company SL240100
SL25 Sales Statement Proposal Lines Company SL250100
SL26 Sales Statement Proposal References Table Company SL260100
SL27 Sales Statement Company SL270100
SL28 Billing Proposal Company SL280100
SL29 Invoice Consolidation History Company SL290100
SL30 Company SL300100
SL31 Company SL310100
SL32 Company SL320100
SL33 Company SL330100
SL34 Company SL340100
SL35 Company SL350100
SL36 Link Prepayment/Advance Invoices to SO Company SL360100
SL39 Delivery Tax Allocation Lines Company SL390100
SL40 Payment Methods Company SL400100
SL45 Extended Bank Info Company SL450100
SL46 Invoice Template Header Company SL460100
SL47 Invoice Template Lines Company SL470100
SL48 Invoice Template Field definitions Company SL480100
SL97 Work File for Ledger Statement SL970000
SL98 Work File for EC Tax Reports SL980000
SLA1 SL account exceptions for revaluation procedure Company SLA10100
SLB1 Company SLB10100
SLB4 Tax Note Description Company SLB40100
SLB5 Company SLB50100
SLC1 Credit Check permission levels Company SLC10100
SLCM Company SLCM0100
SLCS Credit Control Status Configuration Company SLCS0100
SLD1 Payment Ledger Proposal History Company SLD10100
SLD2 Customer Payment Proposal Header History Company SLD20100
SLD3 Payment Proposal Header 2 History Company SLD30100
SLDD Payment Proposal Header 2 Company SLDD0100
SLDS Company SLDS0100
SLE0 Drafts Company SLE00100
SLE1 Remittance Header Company SLE10100
SLE2 Remittance Details Company SLE20100
SLE3 Bank/Agent Company SLE30100
SLE4 Draft Transactions Company SLE40100
SLE5 Sales Ledger Payment Provisional Company Year SLE50112
SLE7 Extended Payment Company SLE70100
SLE8 Advanced Sales Ledger Parameters Company Year SLE80112
SLE9 Advanced Automatic Accounting Codes Company Year SLE90112
SLER Remittance Work File Company SLER0100
SLF1 Exposed Customer Company SLF10100
SLH1 Invoice Header History Company SLH10100
SLH2 Invoice Issuer/Recipient History Company SLH20100
SLH3 Recharge Invoice Accounts Receivable Header SLH30000
SLH4 Recharge Invoice Accounts Receivable Transaction Lines SLH40000
SLH5 Company SLH50100
SLH6 Invoice Lines Details History Company SLH60100
SLH7 Invoice Texts Linked to Generic Invoices Company SLH70100
SLH8 Invoice Bank Info Company SLH80100
SLI1 Payment Term Instalments SL Header Company SLI10100
SLI2 Payment Term Instalments SL Lines Company SLI20100
SLI3 Payment Term Instalments SL Company SLI30100
SLI9 RIBA Payment proposals Company SLI90100
SLIN Invoice Based Intrastat SL Company SLIN0100
SLL1 Customer Tax Exemptions Company SLL10100
SLL2 Customer Payment Balances Company SLL20100
SLM0 Company SLM00100
SLMH Company SLMH0100
SLR4 SL Reversed Transaction Company Year SLR40112
SLT7 Company SLT70100
SLUL Advanced credit control utilized amounts Company SLUL0100
SLXX Customer Statement work file SLXX0000
SLXY Customer ABC and Frequency Analysis work file SLXY0000
SLXZ Customer Statement by Date work file SLXZ0000
SYSM Report 347 format parameters Company SYSM0100

Fields
PK Table Name Description Type Length Precision Note
1 SL19 SL19001 CustomerCode STRING 10 10 0 Customer Code
SL19 SL19002 CustomerName VSTRING 35 35 0 Customer Name
SL19 SL19003 AddressLine1 VSTRING 35 35 0 Address Line 1
SL19 SL19004 AddressLine2 VSTRING 35 35 0 Address Line 2
SL19 SL19005 AddressLine3 VSTRING 35 35 0 Address Line 3
SL19 SL19006 Reference1 VSTRING 35 35 0 Reference 1
SL19 SL19007 Reference2 VSTRING 35 35 0 Reference 2
SL19 SL19008 Reference3 VSTRING 35 35 0 Reference 3
SL19 SL19009 Reference4 VSTRING 35 35 0 Reference 4
SL19 SL19010 Category VSTRING 4 4 0 Customer Category
SL19 SL19011 TelephoneNo VSTRING 20 20 0 Telephone Number
SL19 SL19012 TelexNo VSTRING 10 10 0 Telex Number
SL19 SL19013 TelefaxNo VSTRING 20 20 0 Telefax Number
SL19 SL19014 ReminderBlck VSTRING 1 1 0 Reminder Block
SL19 SL19015 ChargeInterest VSTRING 1 1 0 Charge Interest
SL19 SL19016 IntLatPayment X_NUMERIC 6 14 8 Interest Late Payment
SL19 SL19017 AccString ACCSTR 120 120 0 Accounting String
SL19 SL19018 HighCredLimit VSTRING 20 20 0 Highest Credit Limit (Local Currency) This is the highest credit limit that has bee n given to the customer, this is normally automatically updated by the system.
SL19 SL19019 PriceListPrj VSTRING 2 2 0 Price List Project
SL19 SL19020 Spare VSTRING 19 19 0 (obsolete)
SL19 SL19021 SalesTaxCode VSTRING 20 20 0 Tax Registration Number
SL19 SL19022 CurrencyCode VSTRING 2 2 0 Currency Code
SL19 SL19023 LanguageCode VSTRING 3 3 0 Language
SL19 SL19024 PaymentTerm VSTRING 2 2 0 Payment Terms
SL19 SL19025 AutogiroCust VSTRING 1 1 0 Autogiro Customer
SL19 SL19026 DeliveryTerms VSTRING 2 2 0 Delivery Terms
SL19 SL19027 DeliveryWay VSTRING 2 2 0 Delivery Way
SL19 SL19028 MergeInvoice VSTRING 1 1 0 Consolidated Invoice
SL19 SL19029 PriceList VSTRING 2 2 0 Price List
SL19 SL19030 ImpExpCustomer VSTRING 1 1 0 Export Code
SL19 SL19031 ExtenTaxHand VSTRING 1 1 0 Extended Tax Handling Only used in US (country code 1) and indicates if external application for tax handling shall be used for the customer.
SL19 SL19032 AccCodeSales VSTRING 2 2 0 Accounting Code
SL19 SL19033 FrequencyCode VSTRING 1 1 0 Frequency Code
SL19 SL19034 ABCCode VSTRING 1 1 0 ABC Code
SL19 SL19035 SalesMan VSTRING 3 3 0 Salesman
SL19 SL19036 DiscountCode VSTRING 3 3 0 Discount Code
SL19 SL19037 CreditLimit MONEY 20 28 8 Credit Limit (Local Currency)
SL19 SL19038 Balance MONEY 20 28 8 Balance (Local Currency)
SL19 SL19039 SalePrevYear MONEY 20 28 8 Sales Previous Year (Local Currency)
SL19 SL19040 SalesYTD MONEY 20 28 8 Sales YTD (Local Currency)
SL19 SL19041 SalesPeriod MONEY 20 28 8 Sales Period (Local Currency)
SL19 SL19042 ProfPrevYear MONEY 20 28 8 Profit Previous Year (Local Currency)
SL19 SL19043 ProfitYTD MONEY 20 28 8 Profit YTD (Local Currency)
SL19 SL19044 ProfitPeriod MONEY 20 28 8 Profit Period (Local Currency)
SL19 SL19045 Budget MONEY 20 28 8 Budget (Local Currency)
SL19 SL19046 NoofInvYTD INTEGER 6 0 0 Number of Invoices YTD
SL19 SL19047 ChrgInterYTD MONEY 20 28 8 Charged Interest YTD (Local Currency)
SL19 SL19048 TotDayDuePay INTEGER 6 0 0 Total Days Due Payment
SL19 SL19049 NoOfInvoices VSTRING 4 4 0 Number of Invoices
SL19 SL19050 LastInvDate DATE 8 0 0 Last Invoice Date
SL19 SL19051 LastPaymDate DATE 8 0 0 Last Payment Date
SL19 SL19052 Remark1 VSTRING 25 25 0 Internal Note 1
SL19 SL19053 Remark2 VSTRING 25 25 0 Internal Note 2
SL19 SL19054 AlphaSrchKey VSTRING 35 35 0 Customer Search Key
SL19 SL19055 ReminderNo VSTRING 3 3 0 Number of Reminders
SL19 SL19056 MainCustCode VSTRING 10 10 0 Main Customer Code
SL19 SL19057 OrdNotShiLoC MONEY 20 28 8 Ordered Not Shipped (Local Currency)
SL19 SL19058 ShiNotInvLoC MONEY 20 28 8 Shipped Not Invoiced (Local Currency)
SL19 SL19059 CollectCust VSTRING 1 1 0 Collection Customer
SL19 SL19060 ShipmentBlck VSTRING 1 1 0 Delivery Block
SL19 SL19061 InvPrinted VSTRING 1 1 0 Number of Invoices Printed
SL19 SL19062 SalePrevYear1 MONEY 20 28 8 Sales Previous Year - 1 (Local Currency)
SL19 SL19063 ProfPrevYear1 MONEY 20 28 8 Profit Previous Year - 1 (Local Currency)
SL19 SL19064 OrderPerioNo VSTRING 2 2 0 Number of Orders Period
SL19 SL19065 OrderYTDNo VSTRING 3 3 0 Number of Orders YTD
SL19 SL19066 MarketingSupport VSTRING 9 9 0 Marketing Support (Local Currency)
SL19 SL19067 InterActFlag VSTRING 1 1 0 Internal Action Flag
SL19 SL19068 CreditCode VSTRING 1 1 0 Credit Code User defined code that can be used as selection term on customer reports.
SL19 SL19069 District VSTRING 2 2 0 Customer District
SL19 SL19070 AdvertCode VSTRING 2 2 0 Customer Advertising Area
SL19 SL19071 AreaCode VSTRING 4 4 0 Customer Area Code
SL19 SL19072 SNICode VSTRING 5 5 0 Customer Trade Code
SL19 SL19073 InvoicingFee VSTRING 1 1 0 Invoicing Fee (Local Currency)
SL19 SL19074 DistributFee VSTRING 1 1 0 Distribution Fee Code
SL19 SL19075 AutoDelivBlck VSTRING 1 1 0 Automatic Delivery Block This fields is normally update by the function for automatic credit hold.
1 - Documents can't be printed, deliveries can't be done
0 - No restrictions
SL19 SL19076 ServicePriority INTEGER 1 0 0 Customer Priority
SL19 SL19077 PriLisSerOrd VSTRING 2 2 0 Price List Service Order
SL19 SL19078 ContainerNo VSTRING 13 13 0 Container Number
SL19 SL19079 DelivAddrNo VSTRING 35 35 0 EDI Delivery Address Number
SL19 SL19080 Bonus X_NUMERIC 5 13 8 Bonus Percent
SL19 SL19081 AllocBonusYTD MONEY 20 28 8 Allocated Bonus YTD (Local Currency)
SL19 SL19082 EarSetDisYTD MONEY 20 28 8 Early Settlement Discounts YTD (Local Currency)
SL19 SL19083 ZipCode VSTRING 10 10 0 Zip Code
SL19 SL19084 Technician VSTRING 10 10 0 Technician
SL19 SL19085 DocumentLayout VSTRING 1 1 0 Document Layout
SL19 SL19086 AccrualCode VSTRING 2 2 0 Accrual Code
SL19 SL19087 ComisionCode VSTRING 2 2 0 Commission Code
SL19 SL19088 SalesNextYTD MONEY 20 28 8 Sales Next YTD (Local Currency)
SL19 SL19089 SalesNextPer MONEY 20 28 8 Sales Next Period (Local Currency)
SL19 SL19090 ProfNextYTD MONEY 20 28 8 Profit Next YTD (Local Currency)
SL19 SL19091 ProfNextPer MONEY 20 28 8 Profit Next Period (Local Currency)
SL19 SL19092 FiscalCode VSTRING 16 16 0 Fiscal Registration Code
SL19 SL19093 BankCode VSTRING 10 10 0 Bank Code
SL19 SL19094 BankAccntNo VSTRING 34 34 0 Bank Account Number
SL19 SL19095 TypeOfOrganiz VSTRING 1 1 0 Type of Organization
SL19 SL19096 IncOnTaxRep VSTRING 1 1 0 Include in Tax Reports
SL19 SL19097 CashMetSalTax VSTRING 1 1 0 Cash Method in Sales Tax Reports
SL19 SL19098 DefWarehNo VSTRING 6 6 0 Default Warehouse
SL19 SL19099 AddrLine4 VSTRING 35 35 0 Address Line 4
SL19 SL19100 CommonWarehNo VSTRING 6 6 0 Common Warehouse
SL19 SL19101 PartDelivCode VSTRING 1 1 0 No Backorders 0 - Backorders and partial deliveries are allowed
1 - Backorders are not allowed, order can only take place if the whole order can be shipped at once.
SL19 SL19102 PaymentLedger VSTRING 1 1 0 Payment Ledger
SL19 SL19103 Forwarder VSTRING 4 4 0 Forwarder
SL19 SL19104 CountryCode VSTRING 3 3 0 Country Code
SL19 SL19105 MandatoryPO VSTRING 1 1 0 Mandatory Purchase Order Number
SL19 SL19106 BlanketPONum VSTRING 10 10 0 Blanket Purchase Order Number
SL19 SL19107 TaxLiabilityFlag VSTRING 2 2 0 Tax Liability Flag Yes (1) – Tax is debited to customer, No (0) – Tax is not debted to customer.
SL19 SL19108 VATCode2 VSTRING 2 2 0 VAT Code 2
SL19 SL19109 CompleteName VSTRING 200 200 0 Complete Customer Name
SL19 SL19110 NoOfReminders VSTRING 1 1 0 Number of Reminders The maximum number of reminders that shall be printed per invoice for the customer.
SL19 SL19111 NomLedgerAC VSTRING 12 12 0 Pre-payment Account
SL19 SL19112 WayOfPayment STRING 2 2 0 Way of Payment 0 - No automatic payments
1 - Transfer to payment ledger (standard)
2 - German collection method 1
3 - German collection method 2
4 - PN/PDC domestic payments
5 - PN/PDC foreign payments
SL19 SL19113 TaxJurisdictionCode STRING 1 1 0 Tax Jurisdiction Only used in US (country code 1) when integrating with external tax handling application.
SL19 SL19114 EDIContractSwitch SWITCH 1 1 0 Electronic Partner 0 - The customer is not an electronic partner and printed documents are used when communicating with the customer.
1 - The customer is an electronic partner and electronic documents are primary used when communicating with the customer.
SL19 SL19115 BlockOrderAccept SWITCH 1 1 0 Block Order Acceptance
SL19 SL19116 BillingCode STRING 4 4 0 Billing Terms
SL19 SL19117 DueDateMeth STRING 1 1 0 Due date Method
SL19 SL19118 TaxRoundMeth STRING 1 1 0 Tax Rounding Method 0 - Standard scala rounding
1 - Round-up to decimal in currency
2 - Round-down to decimal in currency
3 - Normal rounding
SL19 SL19119 TaxCalcMeth STRING 1 1 0 Tax Calculation Method 0 - By order line
1 - By order total
SL19 SL19120 OtherTaxLiability INTEGER 1 0 0 Other Tax Liabilities 0 - Extra tax defined for stock item will not be charged to the customer
1 - Extra tax defined for stock items will be charged to the customer
SL19 SL19121 DueDateBasedOn INTEGER 1 0 0 Due Date Base On
SL19 SL19122 TaxRecalculation INTEGER 1 0 0 Tax Recalculation Allowed
SL19 SL19123 TaxRecalPLAccount VSTRING 12 12 0 Tax Recalculation P&L account
SL19 SL19124 LifeCycleStatus INTEGER 1 0 0 Life Cycle Status
SL19 SL19125 SupplierCode VSTRING 10 10 0 Supplier Code The code that is used by the customer to identify us as supplier.
SL19 SL19126 PriReschedule STRING 10 10 0 Ordering Priority ATP Rescheduling
SL19 SL19127 AccLineSplit SWITCH 1 1 0 Accept Order Line Split ATP
SL19 SL19128 AccOrderSplit SWITCH 1 1 0 Accept Order Split ATP
SL19 SL19129 GlobalID VSTRING 25 25 0 Global ID
SL19 SL19130 IBANactivation INTEGER 1 0 0 IBAN Activation
SL19 SL19131 DiscountSchemeCode INTEGER 9 0 0 Discount Scheme Code
SL19 SL19132 Advancedgroupdiscountstartdate DATE 8 0 0 Group Discount Start Date
SL19 SL19133 TimeIntervalValue INTEGER 2 0 0 Group Discount Time Interval
SL19 SL19134 TimeIntervalUnits INTEGER 1 0 0 Group Discount Time Interval Unit 0 - Days
1 - Weeks
2 - Month
3 - Years
SL19 SL19135 BatchPricingFlag SWITCH 1 1 0 Use Batch Pricing
SL19 SL19136 FlagIncludeQuotation INTEGER 1 0 0 Include Quotations
SL19 SL19137 ContractPriceList STRING 2 2 0 Price List Contract
SL19 SL19138 CalendarColRef INTEGER 9 0 0 Calendar Collection
SL19 SL19139 TaxCode STRING 2 2 0 Customer Tax Code
SL19 SL19140 AllowSurchDistrib SWITCH 1 1 0 Allowance/Surcharge Distribution
SL19 SL19141 InvoiceIssuer STRING 6 6 0 Invoice Issuer Code
SL19 SL19142 InvoiceCategory SWITCH 1 1 0 Invoice Category
SL19 SL19143 TaxLiability STRING 6 6 0 Tax Liability Code
SL19 SL19144 EntityType VSTRING 10 10 0 Entity Type
SL19 SL19145 Spare VSTRING 18 18 0 Spare
SL19 SL19146 SubstRegNo VSTRING 20 20 0 Substitution Registration Number
SL19 SL19147 MunicRegNo VSTRING 20 20 0 Municipal Registration Number
SL19 SL19148 StateRegNo VSTRING 20 20 0 State Registration Number
SL19 SL19149 CustActType VSTRING 10 10 0 Customer Activity Type
SL19 SL19150 OperationType VSTRING 10 10 0 Operation Type
SL19 SL19151 FinOperationCode VSTRING 10 10 0 Financial Operation Code
SL19 SL19152 CityCode VSTRING 10 10 0 City Code
SL19 SL19153 CustGroup VSTRING 2 2 0 Customer Group Code
SL19 SL19154 FreightPayer VSTRING 1 1 0 Freight Payer
SL19 SL19155 CollectionPeriod VSTRING 2 2 0 Collection Period (Brazil)
SL19 SL19156 LTMGroup STRING 6 6 0 LTM Group
SL19 SL19157 DropShipment STRING 1 1 0 Drop Shipment Flag
SL19 SL19158 DelNoteSort INTEGER 4 0 0 Delivery Note, sort
SL19 SL19159 AutoprintDN VSTRING 1 1 0 Auto print DN
SL19 SL19160 AutosendDN VSTRING 1 1 0 Auto send DN
SL19 SL19161 NeedBackOrder STRING 1 1 0 Need back-order
SL19 SL19162 DelNotePrinting INTEGER 1 0 0 Delivery note printing
SL19 SL19163 InvPrinting INTEGER 1 0 0 Invoice printing
SL19 SL19164 TaxIDType STRING 2 2 0 TaxIDType
SL19 SL19165 ResponsibilityType STRING 2 2 0 ResponsibilityType
SL19 SL19166 Harbour VSTRING 4 4 0 Harbour
SL19 SL19167 Bundesland VSTRING 2 2 0 Bundesland
SL19 SL19168 StatManner VSTRING 6 6 0 StatManner
SL19 SL19169 CurrIdentNumber VSTRING 2 2 0 CurrIdentNumber
SL19 SL19170 ECDepartment VSTRING 2 2 0 ECDepartment
SL19 SL19171 Regime VSTRING 2 2 0 Regime
SL19 SL19172 AutoPrintInvoice VSTRING 1 1 0 Auto print Invoice
SL19 SL19173 AutoSendInvoice VSTRING 1 1 0 Auto send Invoice
SL19 SL19174 FixPaymentDay1 INTEGER 2 0 0 Fix Payment Day 1
SL19 SL19175 FixPaymentDay2 INTEGER 2 0 0 Fix Payment Day 2
SL19 SL19176 FixPaymentDay3 INTEGER 2 0 0 Fix Payment Day 3
SL19 SL19177 PaymntExcludMonth INTEGER 2 0 0 Paymnt Exclud Month
SL19 SL19178 ReleaseForDN VSTRING 1 1 0 Release For DN
SL19 SL19179 ExtendedCommissionCode STRING 2 2 0 Extended Commission Code
SL19 SL19180 TaxType VSTRING 6 6 0 Tax Type This field should contain the tax (VAT) type.
SL19 SL19181 TaxSurcharge SWITCH 1 1 0 Tax Surcharge
SL19 SL19182 MergeRIBA SWITCH 1 1 0 Merge RIBA
SL19 SL19183 PaymentAddressCode VSTRING 2 2 0 Payment Address Code
SL19 SL19184 InvoiceAddressCode VSTRING 2 2 0 Invoice Address Code
SL19 SL19185 InvoiceSentAddressCode VSTRING 2 2 0 Invoice Sent Address Code
SL19 SL19186 ExcContrCode VSTRING 25 25 0 Excise Control Code Excise Control Code
SL19 SL19187 ExcRegNo VSTRING 25 25 0 Excise Registration Number Excise Registration Number
SL19 SL19188 ExciseDivision VSTRING 25 25 0 Excise Division Excise Division
SL19 SL19189 DAForConsolidatedOR VSTRING 2 2 0 DA for Consolidated Sales Orders
SL19 SL19190 RegionCode VSTRING 10 10 0 Region Code GEO unit
SL19 SL19191 StateProvinceCode VSTRING 10 10 0 State/Province Code GEo unit
SL19 SL19192 CountyCode VSTRING 10 10 0 County Code GEO unit
SL19 SL19193 EmailAddress VSTRING 200 200 0 Email address
SL19 SL19194 AddressLine5 VSTRING 35 35 0 Address Line 5
SL19 SL19195 AddressLine6 VSTRING 35 35 0 Address Line 6
SL19 SL19196 AddressLine7 VSTRING 35 35 0 Address Line 7
SL19 SL19197 ConsolidationModeForLeaseContracts VSTRING 1 1 0 Consolidation Mode for Lease Contracts
SL19 SL19198 ExtUserDefFld1 VSTRING 150 150 0 Ext. User defined field 1
SL19 SL19199 ExtUserDefFld2 VSTRING 150 150 0 Ext. User defined field 2
SL19 SL19200 ExtUserDefFld3 VSTRING 150 150 0 Ext. User defined field 3
SL19 SL19201 ExtUserDefFld4 VSTRING 150 150 0 Ext. User defined field 4
SL19 SL19202 ExtUserDefFld5 VSTRING 150 150 0 Ext. User defined field 5
SL19 SL19203 ExtUserDefFld6 VSTRING 150 150 0 Ext. User defined field 6
SL19 SL19204 ExtUserDefFld7 VSTRING 150 150 0 Ext. User defined field 7
SL19 SL19205 ExtUserDefFld8 VSTRING 150 150 0 Ext. User defined field 8
SL19 SL19206 ExtUserDefFld9 VSTRING 150 150 0 Ext. User defined field 9
SL19 SL19207 ExtUserDefFld10 VSTRING 150 150 0 Ext. User defined field 10
SL19 SL19208 ExtUserDefFld11 VSTRING 150 150 0 Ext. User defined field 11
SL19 SL19209 ExtUserDefFld12 VSTRING 150 150 0 Ext. User defined field 12
SL19 SL19210 ExtUserDefFld13 VSTRING 150 150 0 Ext. User defined field 13
SL19 SL19211 ExtUserDefFld14 VSTRING 150 150 0 Ext. User defined field 14
SL19 SL19212 ExtUserDefFld15 VSTRING 150 150 0 Ext. User defined field 15
SL19 SL19213 ExtUserDefFld16 VSTRING 150 150 0 Ext. User defined field 16
SL19 SL19214 ExtUserDefFld17 VSTRING 150 150 0 Ext. User defined field 17
SL19 SL19215 ExtUserDefFld18 VSTRING 150 150 0 Ext. User defined field 18
SL19 SL19216 ExtUserDefFld19 VSTRING 150 150 0 Ext. User defined field 19
SL19 SL19217 ExtUserDefFld20 VSTRING 150 150 0 Ext. User defined field 20
SL19 SL19218 PartialDeliveryPlanning VSTRING 1 1 0 Partial Delivery Planning 0 – allowed
1 – prohibited
SL19 SL19219 LicenseFlag SWITCH 1 1 0 License Flag
SL19 SL19220 LicensedFrom DATE 8 0 0 Licensed From
SL19 SL19221 LicensedTo DATE 8 0 0 Licensed To
SL19 SL19222 PartDelOnCreditCheck SWITCH 1 1 0 Partial delivery on credit check
SL19 SL19223 TaxesOnOrderedNotShippedLCU MONEY 20 28 8 Taxes on Ordered Not Shipped amount (LCU)
SL19 SL19224 AddOrderCostsLCU MONEY 20 28 8 Additional costs on order (LCU)
SL19 SL19225 TaxesOnAddOrderCostsLCU MONEY 20 28 8 Taxes on additional order costs (LCU)
SL19 SL19226 AmtAllocNotShippedLCU MONEY 20 28 8 Allocated not shipped amount (LCU)
SL19 SL19227 TaxesOnAllocNotShippedLCU MONEY 20 28 8 Taxes on allocated not shipped amount (LCU)
SL19 SL19228 TaxesOnShippedNotInvoicedLCU MONEY 20 28 8 Taxes on shipped not invoiced amount (LCU)
SL19 SL19229 AddShippedCostsLCU MONEY 20 28 8 Additional costs on order (shipped; LCU)
SL19 SL19230 TaxesOnAddShippedCostsLCU MONEY 20 28 8 Taxes on additional costs on order (shipped; LCU)
SL19 SL19231 Longitude X_NUMERIC 28 36 8 Longitude
SL19 SL19232 Latitude X_NUMERIC 28 36 8 Latitude
SL19 SL19233 Altitude X_NUMERIC 28 36 8 Altitude
SL19 SL19234 PrepaymCrCh MONEY 20 28 8 Prepayments for Credit Check
SL19 SL19235 ExternalID VSTRING 36 36 0 External ID
SL19 SL19236 SUFARMA VSTRING 10 10 0 SUFARMA
SL19 SL19237 SpecialICMSregimeBrazil VSTRING 50 50 0 Special ICMS regime – Brazil
SL19 SL19238 SpareBrazil STRING 1 1 0 Spare (Brazil)
SL19 SL19239 SpesometroForms VSTRING 12 12 0 Spesometro Forms
SL19 SL19240 PostalGiroAC VSTRING 15 15 0 Postal Giro A/C
SL19 SL19241 BankGiroAC VSTRING 15 15 0 Bank Giro A/C
SL19 SL19242 CreditPayWay STRING 2 2 0 Credit Pay Way
SL19 SL19243 PO3Subtype STRING 2 2 0 PO3 Sub type
SL19 SL19244 SWIFTAddress VSTRING 12 12 0 SWIFT Address
SL19 SL19245 WHTaxesOnOrderedNotShippedLCU MONEY 20 28 8 WH Taxes On Ordered Not Shipped LCU
SL19 SL19246 WHTaxesOnAddOrderCostsLCU MONEY 20 28 8 WH Taxes On Add Order Costs LCU
SL19 SL19247 WHTaxesOnAllocNotShippedLCU MONEY 20 28 8 WH Taxes On Alloc Not Shipped LCU
SL19 SL19248 WHTaxesOnShippedNotInvoicedLCU MONEY 20 28 8 WH Taxes On Shipped Not Invoiced LCU
SL19 SL19249 WHTaxesOnAddShippedCostsLCU MONEY 20 28 8 WH Taxes On Add Shipped Costs LCU
SL19 SL19250 OverdueTolerancePeriod INTEGER 3 0 0 Overdue tolerance period
SL19 SL19251 OverdueTotalToleranceAmnt MONEY 20 28 8 Overdue total tolerance amount
SL19 SL19252 OverdueInvoiceToleranceAmnt MONEY 20 28 8 Overdue invoice tolerance amount
SL19 SL19253 CreditControlStatus INTEGER 2 0 0 Credit control status
SL19 SL19254 TaxReasonCode STRING 3 3 0 Tax Reason Code
SL19 SL19255 SplitPayment STRING 1 1 0 Split Payments
SL19 SL19256 BankCode2 VSTRING 10 10 0 Bank Code 2
SL19 SL19257 BankAccount2 VSTRING 34 34 0 Bank Account 2
SL19 SL19258 BlockNewOrders SWITCH 1 1 0 Block New Orders
SL19 SL19259 Anonymized SWITCH 1 1 0 Anonymized