| 1. |
CompnyName |
NVarchar (100) |
Company Name |
|
| 2. |
CompnyAddr |
NVarchar (254) |
Address |
|
| 3. |
Country |
NVarchar (3) |
Country |
|
| 4. |
PrintHeadr |
NVarchar (100) |
Printing Header |
|
| 5. |
Phone1 |
NVarchar (50) |
Telephone Number 1 |
|
| 6. |
Phone2 |
NVarchar (50) |
Telephone Number 2 |
|
| 7. |
Fax |
NVarchar (50) |
Fax Number |
|
| 8. |
E_Mail |
NVarchar (100) |
E-Mail |
|
| 9. |
Manager |
NVarchar (100) |
Managing Director |
|
| 10. |
CompType |
NVarchar (1) |
Chart of Accounts Template |
|
| 11. |
MainCurncy |
NVarchar (3) |
Local Currency |
|
| 12. |
SysCurrncy |
NVarchar (3) |
System Currency |
|
| 13. |
DispPosDeb |
NVarchar (1) |
Open Balance with Minus Sign |
|
| 14. |
DefLengthU |
Smallint |
Standard Unit of Length |
|
| 15. |
DefWeightU |
Smallint |
Default Weight UoM |
|
| 16. |
DfltVendPM |
NVarchar (15) |
Default Payt Method for Vendor |
|
| 17. |
DirectRate |
NVarchar (1) |
Direct/Indirect Rate |
|
| 18. |
MinAmnt347 |
Decimal (21, 6) |
Minimum Amount for 347 Report |
|
| 19. |
AutoITW |
NVarchar (1) |
Set Items - Warehouses |
|
| 20. |
BankCountr |
NVarchar (3) |
Bank Country |
|
| 21. |
TaxIdNum |
NVarchar (32) |
Federal Tax ID |
|
| 22. |
RevOffice |
NVarchar (100) |
Tax Office |
|
| 23. |
FreeZoneNo |
NVarchar (32) |
Additional ID Number |
|
| 24. |
DdctFileNo |
NVarchar (50) |
Deduction File No. |
|
| 25. |
VatCharge |
NVarchar (1) |
Tax Collection |
|
| 26. |
PayOutVat |
NVarchar (1) |
Tax Definition |
|
| 27. |
VatPrcnt |
Decimal (21, 6) |
Tax Rate |
|
| 28. |
DpsitPrcnt |
Decimal (21, 6) |
Advances on Corp. Income Tax % |
|
| 29. |
IncomeTax |
Decimal (21, 6) |
Withholding Tax % |
|
| 30. |
VendorDdct |
NVarchar (1) |
Withholding Tax |
|
| 31. |
CustmrDdct |
NVarchar (1) |
Customer's Deduction at Source |
|
| 32. |
DdctPercnt |
Decimal (21, 6) |
Withholding Tax Deduction % |
|
| 33. |
DdctExpire |
Time Stamp |
Withholding Tax Ded. in % - Ex |
|
| 34. |
DdctOffice |
NVarchar (100) |
Withholding Tax Deduction - Of |
|
| 35. |
EURepSqntl |
Integer |
Sequential Number of EU Sales |
|
| 36. |
BoxRptSeq |
Integer |
Box Report Sequential Number |
|
| 37. |
WTLiable |
NVarchar (1) |
WTax Liable |
|
| 38. |
DfltCustPM |
NVarchar (15) |
Default Payt Method for Cust. |
|
| 39. |
AllowFuPos |
NVarchar (1) |
Allow Future Posting Date |
|
| 40. |
UseProdWip |
NVarchar (1) |
Use Product WIP Account |
|
| 41. |
CurrPeriod |
NVarchar (10) |
Free7 |
|
| 42. |
XmlPath |
NClob |
XML File Path |
|
| 43. |
DflBnkKey |
Integer |
Default Bank Key |
|
| 44. |
BSInstled |
NVarchar (1) |
Bank Statement Installed |
|
| 45. |
UseShpdGd |
NVarchar (1) |
Use Shipped Goods Account |
|
| 46. |
UseExtRpt |
NVarchar (1) |
Use Extended Reporting |
|
| 47. |
ERpPerType |
NVarchar (1) |
Period Type for Report Generation |
|
| 48. |
DfSVatExmp |
NVarchar (8) |
Sales Tax Group for Exempt |
|
| 49. |
DfPVatExmp |
NVarchar (8) |
Purchases Tax Group for Exempt |
|
| 50. |
Manager1 |
NVarchar (100) |
General Manager |
|
| 51. |
Manager1F |
NVarchar (100) |
General Manager (For. Lang.) |
|
| 52. |
CCMask |
NVarchar (1) |
Mask Credit Card Number |
|
| 53. |
ObligLimit |
NVarchar (1) |
Commitment Restriction |
|
| 54. |
CreditLimt |
NVarchar (1) |
Credit Restriction |
|
| 55. |
SalesLimit |
NVarchar (1) |
Restrict Sales |
|
| 56. |
DlnLimit |
NVarchar (1) |
Restrict Deliv. Notes (PO) |
|
| 57. |
OrderLimit |
NVarchar (1) |
Restrict Orders |
|
| 58. |
AddDlnBlnc |
NVarchar (1) |
Consider Del. Notes in Sales Restriction |
|
| 59. |
CreditDpst |
NVarchar (1) |
Credit Deposit Type |
|
| 60. |
MultiLang |
NVarchar (1) |
Multi-Language Support Enabled |
|
| 61. |
DbVers |
Integer |
Database Version |
|
| 62. |
ApplVers |
Integer |
Application Version |
|
| 63. |
DflWebSite |
NClob |
Default for Web Site |
|
| 64. |
DflFTPSite |
NClob |
Default for FTP Site |
|
| 65. |
UseTax |
NVarchar (1) |
Use Tax |
|
| 66. |
RevisionPo |
NVarchar (1) |
Split PO |
|
| 67. |
Reindex |
NVarchar (1) |
Rebuild Indexes |
|
| 68. |
DllPath |
NClob |
Path to Validation DLL |
|
| 69. |
TaxIdValid |
NVarchar (1) |
Tax ID Mandatory Validation |
|
| 70. |
PchName |
NVarchar (20) |
Alternate Name for Purchase |
|
| 71. |
RpcName |
NVarchar (20) |
Alternate Name for A/P Credit |
|
| 72. |
PdnName |
NVarchar (20) |
Alternate Name for Goods Rcpt |
|
| 73. |
RpdName |
NVarchar (20) |
Alternate Name for Gds Return |
|
| 74. |
PorName |
NVarchar (20) |
Alternate Name for Purchase |
|
| 75. |
LevelWarn |
NVarchar (1) |
Alert Type for Whse Inventory |
|
| 76. |
CrdCommUse |
NVarchar (1) |
Set Commission by Customer |
|
| 77. |
ItmCommUse |
NVarchar (1) |
Set Commission by Item |
|
| 78. |
SlpCommUse |
NVarchar (1) |
Set Commission by Sales Empl. |
|
| 79. |
DfCustTerm |
Smallint |
Default Payment Term for Cust. |
|
| 80. |
DfVendTerm |
Smallint |
Default Payment Term for Vend. |
|
| 81. |
SaleProfit |
NVarchar (1) |
Calc. Gross Profit per Trans. |
|
| 82. |
CostPrcLst |
Smallint |
Price List for Reval. Price |
|
| 83. |
GrossBySal |
NVarchar (1) |
Gross Profit After Sale |
|
| 84. |
TreePricOn |
NVarchar (1) |
Display Price for Parent Only |
|
| 85. |
AddVat |
NVarchar (1) |
Calc. Tax in Sales Quotation |
|
| 86. |
BaseFld |
NVarchar (1) |
Base Field |
|
| 87. |
ClosedQuot |
NVarchar (1) |
Allow Closed Sales Quotations |
|
| 88. |
UseCode |
NVarchar (1) |
User Conversion Code |
|
| 89. |
Code1 |
NVarchar (8) |
CODE1 |
|
| 90. |
Code2 |
NVarchar (8) |
CODE2 |
|
| 91. |
Code3 |
NVarchar (8) |
CODE3 |
|
| 92. |
Code4 |
NVarchar (8) |
CODE4 |
|
| 93. |
Color |
Smallint |
Company Color |
|
| 94. |
SumDec |
Smallint |
Totals Accuracy |
|
| 95. |
QtyDec |
Smallint |
Accuracy of Quantities |
|
| 96. |
PriceDec |
Smallint |
Price Accuracy |
|
| 97. |
RateDec |
Smallint |
Rate Accuracy |
|
| 98. |
PercentDec |
Smallint |
Percentage Rate Accuracy |
|
| 99. |
MeasureDec |
Smallint |
Measuring Accuracy for Units |
|
| 100. |
DdAutoRun |
NVarchar (1) |
DD Auto Run |
|
| 101. |
DdNextDue |
Time Stamp |
DD Next Due Date |
|
| 102. |
DdHour |
Smallint |
DD Hour |
|
| 103. |
CmpnyAddrF |
NVarchar (254) |
Address in Foreign Language |
|
| 104. |
DflTaxCode |
NVarchar (8) |
Default Tax Code |
|
| 105. |
PrintHdrF |
NVarchar (100) |
Letter Header in Foreign Lang. |
|
| 106. |
Phone1F |
NVarchar (50) |
Tel. No. 1 (Foreign Language) |
|
| 107. |
Phone2F |
NVarchar (50) |
Tel. No. 2 (Foreign Language) |
|
| 108. |
FaxF |
NVarchar (50) |
Fax Number (Foreign Lang.) |
|
| 109. |
ManagerF |
NVarchar (100) |
Managing Director (For. Lang.) |
|
| 110. |
TimeFormat |
NVarchar (1) |
Time Template |
|
| 111. |
CigCup |
NVarchar (1) |
Cig and Cup Warning |
|
| 112. |
DateFormat |
NVarchar (1) |
Date Template |
|
| 113. |
DateSep |
NVarchar (1) |
Date Separator |
|
| 114. |
FcNoBlnc |
NVarchar (1) |
FC Checking Account |
|
| 115. |
ChangeRdr |
NVarchar (1) |
Changed Existing Orders |
|
| 116. |
MultiCurr |
NVarchar (1) |
All Currencies Check |
|
| 117. |
PickParDlv |
NVarchar (1) |
Partial Deliv. Pick and Pack |
|
| 118. |
MaxTaxIncr |
Decimal (21, 6) |
Maximum Increase of Tax Amount |
|
| 119. |
ISRType |
Smallint |
ISR Type |
|
| 120. |
MaxTaxDecr |
Decimal (21, 6) |
Maximum Decrease of Tax Amount |
|
| 121. |
RoundRmrk |
NVarchar (1) |
Display Rounding Remark |
|
| 122. |
ISRBillerI |
NVarchar (9) |
ISR Biller ID |
|
| 123. |
UpdStamp |
Integer |
Update Stamp |
|
| 124. |
SysCNoEdit |
NVarchar (1) |
Block System Currency Editing |
|
| 125. |
RefDNoEdit |
NVarchar (1) |
Block Updating of Posting Date |
|
| 126. |
DfltWhs |
NVarchar (8) |
Default Warehouse |
|
| 127. |
TaxDNoEdit |
NVarchar (1) |
Free |
|
| 128. |
DfSVatItem |
NVarchar (8) |
Tax Definition |
|
| 129. |
DfSVatServ |
NVarchar (8) |
Tax Definition |
|
| 130. |
DfPVatItem |
NVarchar (8) |
Tax Group for Purchase Item |
|
| 131. |
DfPVatServ |
NVarchar (8) |
Tax Group for Service Purchase |
|
| 132. |
DoBudget |
NVarchar (1) |
Calculate Budget |
|
| 133. |
CustIdNum |
NVarchar (6) |
Customer ID Number |
|
| 134. |
BgtBlock |
NVarchar (1) |
Block Budget |
|
| 135. |
BgtWarning |
NVarchar (1) |
Budget Alert |
|
| 136. |
BdgtPORDoc |
NVarchar (1) |
Block Purchase Orders |
|
| 137. |
BdgtAcctng |
NVarchar (1) |
Block Bookkeeping |
|
| 138. |
BdgtDflt |
Integer |
Default Budget Cost Assmt Mthd |
|
| 139. |
ContInvnt |
NVarchar (1) |
Perpetual Inventory Management |
|
| 140. |
InvntSystm |
NVarchar (1) |
Perpetual Inventory System |
|
| 141. |
ApplicIFRS |
NVarchar (1) |
Application of IFRS |
|
| 142. |
StartYear |
Smallint |
Starting in Fiscal Year |
|
| 143. |
According |
Smallint |
Report According To |
|
| 144. |
MltpBrnchs |
NVarchar (1) |
Enable Multiple Branches |
|
| 145. |
EnblSrvTax |
NVarchar (1) |
Enable Service Tax |
|
| 146. |
DftRCN |
Integer |
Default for Retail Chains |
|
| 147. |
RoundVat |
NVarchar (1) |
Round Tax Amounts |
|
| 148. |
BdgtPDNDoc |
NVarchar (1) |
Block Deliv. Notes for Purch. |
|
| 149. |
IRSFileNo |
NVarchar (9) |
File Number in Income Tax |
|
| 150. |
DeferrTax |
NVarchar (1) |
Deferred Tax |
|
| 151. |
DflIntrst |
Decimal (21, 6) |
Min. Default Interest Amount |
|
| 152. |
DfltSlp |
Smallint |
Sales Employee |
|
| 153. |
DflCrCard |
Smallint |
Default Credit Card |
|
| 154. |
DflBnkCode |
NVarchar (30) |
Default Bank No. |
|
| 155. |
DflBnkAcct |
NVarchar (50) |
Default Bank Account |
|
| 156. |
DflBranch |
NVarchar (50) |
Default Branch |
|
| 157. |
UsePaSys |
NVarchar (1) |
Use PA System |
|
| 158. |
Serv_Usr |
NVarchar (20) |
Service Code |
|
| 159. |
Serv_Pass |
NVarchar (20) |
Service Password |
|
| 160. |
ParamPath |
NClob |
Param. Folder Path |
|
| 161. |
ExcelPath |
NClob |
Excel Folder Path |
|
| 162. |
TaxIdNum2 |
NVarchar (32) |
Federal Tax ID 2 |
|
| 163. |
TaxIdNum3 |
NVarchar (32) |
Federal Tax ID 3 |
|
| 164. |
DecSep |
NVarchar (1) |
Decimal Separator |
|
| 165. |
ThousSep |
NVarchar (1) |
Thousandths Separator |
|
| 166. |
CurOnRight |
NVarchar (1) |
Display Currency on the Right |
|
| 167. |
WarnByWhs |
NVarchar (1) |
Alert by Warehouse |
|
| 168. |
DflBnkAcKy |
Integer |
Default Bank Account Number |
|
| 169. |
PriceSys |
NVarchar (1) |
Price System |
|
| 170. |
DftPVL |
Integer |
Preferred Vendor Credit |
|
| 171. |
useDdctTrc |
NVarchar (1) |
WTax Deduction Hierarchy |
|
| 172. |
useDocWrf |
NVarchar (1) |
Doc. Confirmation |
|
| 173. |
BtchStatus |
NVarchar (1) |
Default for Batch Status |
|
| 174. |
OrderBatch |
NVarchar (1) |
Manage Orders in Batches |
|
| 175. |
GLMethod |
NVarchar (1) |
Set G/L Account By |
|
| 176. |
SetSriUniq |
NVarchar (1) |
Set Unique Serial No. |
|
| 177. |
SriUniqFld |
NVarchar (1) |
Unique Serial No. |
|
| 178. |
MaxHistory |
Integer |
Max. History |
|
| 179. |
TaxRateDet |
NVarchar (1) |
Tax Rate Determination |
|
| 180. |
RefreshQty |
NVarchar (1) |
Refresh in Whse Qty in DI |
|
| 181. |
StockNoBas |
NVarchar (1) |
Stock No. Base |
|
| 182. |
MaxCntRows |
Integer |
Allowed Max Rows in Counting |
|
| 183. |
CentPmtInc |
NVarchar (1) |
Enable Incom. Centralized Payt |
|
| 184. |
CentPmtOut |
NVarchar (1) |
Enable Outg. Centralized Payt |
|
| 185. |
ChCtrAPAct |
NVarchar (1) |
Change Def. Recon. A/P Accts |
|
| 186. |
ChCtrARAct |
NVarchar (1) |
Change Def. Recon. A/R Accts |
|
| 187. |
PACUsrName |
NVarchar (100) |
PAC User Name |
|
| 188. |
PACPasswrd |
NVarchar (100) |
PAC Password |
|
| 189. |
CaredType |
NVarchar (2) |
BP Type Code |
|
| 190. |
PBSNumber |
NVarchar (8) |
PBS Number |
|
| 191. |
PBSGroupNo |
NVarchar (5) |
PBS Group Number |
|
| 192. |
OrgNumber |
NVarchar (100) |
Organization Number |
|
| 193. |
ActSep |
NVarchar (1) |
Account Segments Separator |
|
| 194. |
DspBokpWin |
NVarchar (1) |
Display Bookkeeping Window |
|
| 195. |
SHandleWT |
NVarchar (1) |
Withholding Tax |
|
| 196. |
SDfltWT |
NVarchar (4) |
Default Withholding Tax Code |
|
| 197. |
IncresGlAc |
NVarchar (15) |
G/L Increase Account |
|
| 198. |
PHandleWT |
NVarchar (1) |
Withholding Tax |
|
| 199. |
PDfltWT |
NVarchar (4) |
Default Withholding Tax Code |
|
| 200. |
ExWTLiabl |
NVarchar (1) |
WTax-Liable Expense |
|
| 201. |
free84 |
NVarchar (1) |
Free84 |
|
| 202. |
AllowPostZ |
NVarchar (1) |
Allow Inb. Pstng W/o a Price |
|
| 203. |
PostDiffR |
Decimal (21, 6) |
Display in Red Greater Than % |
|
| 204. |
EnableRO |
NVarchar (1) |
Enable Release Only Snb in Pst |
|
| 205. |
UalLastDel |
Time Stamp |
Last Delete Date on Table OUAL |
|
| 206. |
UalKeepDay |
Integer |
Days for keeping data on OUAL |
|
| 207. |
NegAmount |
NVarchar (1) |
Use Negative Amounts |
|
| 208. |
EnbDocOpt |
NVarchar (1) |
Enable Document Optimization |
|
| 209. |
HldCode |
NVarchar (20) |
Holiday Name |
|
| 210. |
AlphaDoc |
NVarchar (1) |
Use Alphanum. ID for Document |
|
| 211. |
EDocURL2 |
NVarchar (254) |
|
|
| 212. |
EnPriceMod |
NVarchar (1) |
|
|
| 213. |
TaaSEnable |
NVarchar (1) |
|
|
| 214. |
TaaSUser |
NVarchar (50) |
|
|
| 215. |
OrderBlock |
NVarchar (1) |
Order Block |
|
| 216. |
RoundMthd |
NVarchar (1) |
Rounding Method |
|
| 217. |
AdrsFromWH |
NVarchar (1) |
Use Whse Address in A/P Docs. |
|
| 218. |
OrderParty |
NVarchar (30) |
Ordering Party |
|
| 219. |
CrtfcateNO |
NVarchar (20) |
Certificate No. |
|
| 220. |
ExpireDate |
Time Stamp |
Expiration Date |
|
| 221. |
NINum |
NVarchar (20) |
National Insurance No. |
|
| 222. |
TaaSPass |
NVarchar (20) |
|
|
| 223. |
TaaSAutURL |
NVarchar (250) |
|
|
| 224. |
CfwAsnMust |
NVarchar (1) |
CFW Assignment Mandatory [Y/N] |
|
| 225. |
CfwInDflt |
Integer |
Incoming Payment Dflt CFW Item |
|
| 226. |
CfwOutDflt |
Integer |
Outgoing Payment Dflt CFW Item |
|
| 227. |
TaaSURL |
NVarchar (250) |
|
|
| 228. |
TaaSSaleAc |
NVarchar (15) |
|
|
| 229. |
TaxRegime |
NVarchar (100) |
Tax Regime |
|
| 230. |
AliasName |
NClob |
Alias Name |
|
| 231. |
DftJPELine |
NVarchar (1) |
Default Line For Local Area |
|
| 232. |
RdrConfrmd |
NVarchar (1) |
Sales Order Confirmed |
|
| 233. |
PorConfrmd |
NVarchar (1) |
Purchase Order Confirmed |
|
| 234. |
TaaSPurcAc |
NVarchar (15) |
|
|
| 235. |
AdvImagePr |
NVarchar (1) |
|
|
| 236. |
ChfAcc |
Integer |
Chief Accountant |
|
| 237. |
TaxMethod |
NVarchar (1) |
Taxation Method |
|
| 238. |
CEO |
Integer |
CEO |
|
| 239. |
WllPprDsp |
Smallint |
|
|
| 240. |
WallPaper |
NClob |
|
|
| 241. |
RndToTDec |
NVarchar (1) |
Round VAT to Tenths |
|
| 242. |
SDfltITWT |
NVarchar (4) |
Default Income Tax WTax Code |
|
| 243. |
PDfltITWT |
NVarchar (4) |
Default Income Tax WTax Code |
|
| 244. |
CheckFiles |
NVarchar (1) |
|
|
| 245. |
DsplyRates |
NVarchar (1) |
|
|
| 246. |
DfActCurr |
NVarchar (1) |
Default Account Currency |
|
| 247. |
defTaxVend |
NVarchar (1) |
Deferred Tax for Vendors |
|
| 248. |
RcrFlag |
NVarchar (1) |
|
|
| 249. |
RclFlag |
NVarchar (1) |
|
|
| 250. |
ContactLog |
NVarchar (1) |
|
|
| 251. |
ShowNewMsg |
NVarchar (1) |
|
|
| 252. |
OpenCdt |
NVarchar (1) |
|
|
| 253. |
AutoVat |
NVarchar (1) |
Automatic VAT Row Creation In |
|
| 254. |
ConsumeFCT |
NVarchar (1) |
Consumption Forecast |
|
| 255. |
ConsumeMtd |
NVarchar (1) |
Consumption Method |
|
| 256. |
DaysBack |
Integer |
Days Backward |
|
| 257. |
DaysFwrd |
Integer |
Days Forward |
|
| 258. |
IsPAPrn |
NVarchar (1) |
Panama Printer Connected |
|
| 259. |
ShowNewTsk |
NVarchar (1) |
|
|
| 260. |
TaxCodeCst |
NVarchar (8) |
Default Tax Code (New Custs.) |
|
| 261. |
TaxCodeVnd |
NVarchar (8) |
Default Tax Code (New Vendors) |
|
| 262. |
State |
NVarchar (3) |
Status |
|
| 263. |
CharMonth |
Integer |
Number of Characters in Month |
|
| 264. |
free83 |
NVarchar (1) |
Free83 |
|
| 265. |
ScreenLock |
Smallint |
|
|
| 266. |
OpenCredit |
NVarchar (1) |
|
|
| 267. |
OpenDps |
NVarchar (1) |
|
|
| 268. |
AltBOEPost |
NVarchar (1) |
Active Alternative BOE Post |
|
| 269. |
LDiscTotal |
NVarchar (1) |
Calc. Row Disc. from Tot. Pr. |
|
| 270. |
Code |
Integer |
|
|
| 271. |
DfltDunTrm |
NVarchar (25) |
Default Dunning Terms |
|
| 272. |
Profession |
NVarchar (50) |
Profession |
|
| 273. |
AlertPolFr |
Smallint |
|
|
| 274. |
DfltCDP |
Smallint |
Default Closing Date Procedure |
|
| 275. |
LogInstanc |
Integer |
Log Instance |
|
| 276. |
UpdateDate |
Time Stamp |
Date of Update |
|
| 277. |
UserSign |
Smallint |
User Signature |
|
| 278. |
DflBCACode |
NVarchar (3) |
Default Bank Charges Alloc. |
|
| 279. |
IgrAllCash |
NVarchar (1) |
Ignore All Cash Flow Relevant |
|
| 280. |
TaxPayerRf |
NVarchar (32) |
Unique Taxpayer Ref. (UTR) |
|
| 281. |
EmployerRf |
NVarchar (32) |
Employer's Reference |
|
| 282. |
PStatAutCh |
NVarchar (1) |
Period Status Automatic Change |
|
| 283. |
PStatDelay |
Smallint |
Period Status Change Delay |
|
| 284. |
RepBusType |
NVarchar (2) |
Reporting Business Type |
|
| 285. |
RepBusOthr |
NVarchar (32) |
Reporting Business Type Desc. |
|
| 286. |
BrachNum |
NVarchar (4) |
Branch Number |
|
| 287. |
BuisnesDsc |
NVarchar (50) |
Business Description |
|
| 288. |
ReptMethod |
NVarchar (2) |
Reporting Method |
|
| 289. |
AcctMethod |
NVarchar (2) |
Accounting Method |
|
| 290. |
Bookpitype |
NVarchar (2) |
Bookkeeping Type |
|
| 291. |
ActSoftNam |
NVarchar (100) |
Accounting Software Name |
|
| 292. |
OpnClsRmrk |
NVarchar (1) |
Copy Opening/Closing Remarks |
|
| 293. |
TaxRndRule |
NVarchar (1) |
Default Tax Rounding Rule |
|
| 294. |
NegTax |
NVarchar (1) |
Allow Negative Tax Amt in Rpt |
|
| 295. |
ZeroLine |
NVarchar (1) |
Allow Zero Row in JE |
|
| 296. |
GBOpenFile |
NVarchar (1) |
Open GBI File After Export |
|
| 297. |
GBIntface |
NVarchar (1) |
GB Data Interface Enable |
|
| 298. |
DfltCDPV |
Smallint |
Default A/P Closing Date Proc. |
|
| 299. |
OnHldPert |
Decimal (21, 6) |
Capital Goods On Hold Percent. |
|
| 300. |
WTRndRule |
NVarchar (1) |
Default WTax Rounding Rule |
|
| 301. |
GPPrcntSrv |
Decimal (21, 6) |
Default GP % in Service Doc. |
|
| 302. |
DspFrznBP |
NVarchar (1) |
Display Inactive BPs in Rpt |
|
| 303. |
DspFrznITM |
NVarchar (1) |
Display Inactive Items in Rpt |
|
| 304. |
WTAccumAmt |
Decimal (21, 6) |
Accum. Amount for WTax on AP |
|
| 305. |
NewDPRCus |
NVarchar (1) |
Hide Dpm Invoice |
|
| 306. |
ServNature |
NVarchar (1) |
Service Nature |
|
| 307. |
PickLimit |
NVarchar (1) |
Restrict Pick List |
|
| 308. |
WTAccAmtAR |
Decimal (21, 6) |
Accum. Amount for WTax on AR |
|
| 309. |
UseProdPL |
NVarchar (1) |
Use Production P&L Accounts |
|
| 310. |
QueryDec |
Smallint |
Calculated Query Accuracy |
|
| 311. |
ExRtDefTax |
NVarchar (1) |
Exchange Rate on Deferred Tax |
|
| 312. |
BoletoPath |
NClob |
Boleto Path |
|
| 313. |
UserSign2 |
Smallint |
Updating User |
|
| 314. |
MMLastImpD |
Time Stamp |
Last Import File Date |
|
| 315. |
CpyExhRate |
NVarchar (1) |
Copy Exchange Rate in Copy To |
|
| 316. |
MapService |
Integer |
Map Service |
|
| 317. |
ODWFreq |
Integer |
Open Doc. Refresh Frequency |
|
| 318. |
GTSOutPath |
NClob |
GTS Outbound Path |
|
| 319. |
UseMltDims |
NVarchar (1) |
Use Multidimensions |
|
| 320. |
MDStyle |
NVarchar (1) |
Multidimensions Display Style |
|
| 321. |
GTSInPath |
NClob |
GTS Inbound Path |
|
| 322. |
GTSSep |
NVarchar (10) |
GTS Separator |
|
| 323. |
GTSDftChk |
Integer |
GTS Default Checker |
|
| 324. |
GTSDftPye |
Integer |
GTS Default Payee |
|
| 325. |
GTSMaxAmt |
Decimal (21, 6) |
GTS Max. Amount |
|
| 326. |
RspOverAmt |
NVarchar (1) |
Response to Exceeding Amount |
|
| 327. |
DRBlock1 |
NVarchar (1) |
Distribution Rule: Block 1 |
|
| 328. |
DRBlock2 |
NVarchar (1) |
Distribution Rule: Block 2 |
|
| 329. |
DRBlock3 |
NVarchar (1) |
Distribution Rule: Block 3 |
|
| 330. |
DRBlock4 |
NVarchar (1) |
Distribution Rule: Block 4 |
|
| 331. |
DRBlock5 |
NVarchar (1) |
Distribution Rule: Block 5 |
|
| 332. |
PrjBlock |
NVarchar (1) |
Project Block |
|
| 333. |
SimReport |
NVarchar (1) |
Simulation Report |
|
| 334. |
SnapShotId |
Integer |
Snapshot ID |
|
| 335. |
BackOrder |
NVarchar (1) |
Pick and Pack Back Order |
|
| 336. |
HQLocation |
NVarchar (1) |
Headquarters Location |
|
| 337. |
DigCrtPath |
NClob |
Digital Certificate Path |
|
| 338. |
DflWTS |
Smallint |
Default E-Tax Web Site |
|
| 339. |
EnbApprDI |
NVarchar (1) |
Enable DI Approval Procedure |
|
| 340. |
ChBPSerie |
NVarchar (1) |
Verify Non-manual BP Series |
|
| 341. |
ChItmSerie |
NVarchar (1) |
Verify Non-manual ITM Series |
|
| 342. |
ETRTaxOffi |
Integer |
ETR Tax Office |
|
| 343. |
ETRTaxPers |
NVarchar (1) |
ETR Tax Person Type |
|
| 344. |
EDocExpFrm |
Integer |
Electronic Doc. Export Format |
|
| 345. |
PCN874RTyp |
NVarchar (1) |
PCN874 Report Type |
|
| 346. |
BTWDecProv |
NVarchar (3) |
BTW Declaration Provider |
|
| 347. |
BTWDcPrvID |
NVarchar (100) |
BTW Declaration Provider ID |
|
| 348. |
BTWName |
NVarchar (100) |
BTW Name |
|
| 349. |
BTWStreet |
NVarchar (100) |
BTW Street |
|
| 350. |
BTWCity |
NVarchar (100) |
BTW City |
|
| 351. |
BTWZip |
NVarchar (30) |
BTW ZIP Code |
|
| 352. |
BTWPhone |
NVarchar (100) |
BTW Phone Number |
|
| 353. |
BTWOB |
Integer |
BTW OB ID |
|
| 354. |
BTWICP |
Integer |
BTW ICL ID |
|
| 355. |
BTWOBFmt |
Integer |
BTW OB Mapping Format |
|
| 356. |
BTWICPFmt |
Integer |
BTW ICP Mapping Format |
|
| 357. |
ETRPhoneNo |
NVarchar (20) |
ETR Telephone Number |
|
| 358. |
EDTestMode |
NVarchar (1) |
Electronic Document Test Mode |
|
| 359. |
EDocGenTyp |
NVarchar (1) |
El. Doc. Default Gen. Type |
|
| 360. |
EDocRptFmt |
Integer |
El. Document Report Format |
|
| 361. |
EDocPass |
NVarchar (100) |
|
|
| 362. |
EDProcess |
NVarchar (1) |
Electronic Document Process |
|
| 363. |
PAC |
NVarchar (20) |
PAC |
|
| 364. |
NotifAlert |
NVarchar (1) |
Notification by Alert |
|
| 365. |
NotifEmail |
NVarchar (1) |
Notification by E-Mail |
|
| 366. |
EDocUDQCat |
Integer |
Electronic Document UDQ Category |
|
| 367. |
EOutputPth |
NClob |
Ouput Directory for Electronic Documents |
|
| 368. |
EDelDocFrm |
Integer |
Electronic Delivery Doc. Export Format |
|
| 369. |
EDocPmnFmt |
Integer |
|
|
| 370. |
EDocURL1 |
NVarchar (254) |
|
|
| 371. |
ETRFaxNo |
NVarchar (20) |
ETR Fax Number |
|
| 372. |
ETRMgrPhn |
NVarchar (20) |
ETR Manager's Phone Number |
|
| 373. |
EDFormat |
Integer |
Electronic Document Format |
|
| 374. |
AIDFormat |
Integer |
Annual Invoice Decl. Format |
|
| 375. |
CrtLineRFQ |
NVarchar (1) |
Create Online Quotation |
|
| 376. |
DflJET |
NVarchar (60) |
Default JE Type |
|
| 377. |
OnlyPaidIn |
NVarchar (1) |
Display Only Paid Reserve Inv. |
|
| 378. |
PDDEnabled |
NVarchar (1) |
Payments Due Date Enabled |
|
| 379. |
MaxDays4DD |
Integer |
Max. Allowed Range for Due Dte |
|
| 380. |
AutoAddUoM |
NVarchar (1) |
Auto. Add UoMs to Items |
|
| 381. |
AutoAddPkg |
NVarchar (1) |
Auto. Add Pkgs to Items |
|
| 382. |
BinActivat |
NVarchar (1) |
Has Whse Bin Activated [Y/N] |
|
| 383. |
IssuePriBy |
Smallint |
Issue Primarily By SnB or Bin |
|
| 384. |
InstFixAst |
NVarchar (1) |
Enable Fixed Assets |
|
| 385. |
DeprecCalc |
NVarchar (1) |
Depreciation Calculation |
|
| 386. |
FixAstMod |
NVarchar (1) |
Fixed Asset Mode |
|
| 387. |
SopPath |
NClob |
Solution Packager Exe. Path |
|
| 388. |
NewAcctDe |
NVarchar (1) |
New G/L Account Determination |
|
| 389. |
ClnZeroPln |
NVarchar (1) |
Clean Zero Price Row in ITM1 |
|
| 390. |
CmdDisBoth |
NVarchar (1) |
Display Both Related Docs. |
|
| 391. |
CnclMaxDay |
Integer |
Max. No. of Days For Cancel |
|
| 392. |
AttachPath |
NClob |
Attachments Path |
|
| 393. |
ConfigPath |
NClob |
Configuration Path |
|
| 394. |
WrkshtPath |
NClob |
Worksheet Path |
|
| 395. |
ICDifExPe1 |
Decimal (21, 6) |
Single Count Variance (%) |
|
| 396. |
ICDifExPe2 |
Decimal (21, 6) |
Multiple Count Max. Variance (%) |
|
| 397. |
ClsZoDiffR |
NVarchar (1) |
Close Rows Cont. Zero Diff. |
|
| 398. |
ClsNoConfi |
NVarchar (1) |
Close Without Confirmation |
|
| 399. |
DTWPath |
NClob |
DTW Exe. Path |
|
| 400. |
DfltByEml |
NVarchar (1) |
Default by E-Mail |
|
| 401. |
CreditDay1 |
Smallint |
|
|
| 402. |
INVOBPrice |
NVarchar (1) |
Inventory OB Price Zero |
|
| 403. |
SplitFBSh |
NVarchar (1) |
Split Asset Balance Sheet Acct |
|
| 404. |
NotifyRqr |
NVarchar (1) |
Notify Requester |
|
| 405. |
DeactivFA |
NVarchar (1) |
Deactivate Asset When End Life |
|
| 406. |
CshDctFA |
NVarchar (1) |
CM for Payment Cash Discount |
|
| 407. |
SendAlert |
NVarchar (1) |
Send Internal Message |
|
| 408. |
BdgtPRQDOC |
NVarchar (1) |
Block Purchase Request |
|
| 409. |
IsReuseNum |
NVarchar (1) |
Enable Document Number Reuse |
|
| 410. |
IsReuseNFN |
NVarchar (1) |
Enable Nota Fiscal No. Reuse |
|
| 411. |
SIPLReport |
NVarchar (1) |
Show Inactive PL in Reports |
|
| 412. |
SIPLDoc |
NVarchar (1) |
Show Inactive PL in Docs |
|
| 413. |
SIPLSeting |
NVarchar (1) |
Show Inactive PL in Settings |
|
| 414. |
PriceProcM |
NVarchar (1) |
On Change UoM Conversion Rules |
|
| 415. |
ChkQtyINV |
NVarchar (1) |
Enable Check Quantity in INV |
|
| 416. |
EnbAdvATP |
NVarchar (1) |
Enable Advanced ATP |
|
| 417. |
EnblCase |
NVarchar (1) |
Enable Case Sensitivity |
|
| 418. |
EnbSupplC |
NVarchar (1) |
Enable Supplementary Code |
|
| 419. |
MBAOnPer |
NVarchar (1) |
Allow Multiple BAs for Period |
|
| 420. |
MBAOnAP |
NVarchar (1) |
Block Multiple BAs for AP Doc. |
|
| 421. |
MBAOnAR |
NVarchar (1) |
Block Multiple BAs for AR Doc. |
|
| 422. |
ApyBsActSP |
NVarchar (1) |
Apply Active Special Prices |
|
| 423. |
ApyBsActPV |
NVarchar (1) |
Apply Active Period and Volume |
|
| 424. |
ApyBsActPL |
NVarchar (1) |
Apply Active Price Lists |
|
| 425. |
IsUpdNstdB |
NVarchar (1) |
Update Non-Std Based Prices |
|
| 426. |
SnBDfltSB |
NVarchar (1) |
SnB Default Eval. System SB |
|
| 427. |
OneBOneRec |
NVarchar (1) |
One Batch One Receipt |
|
| 428. |
ReptCurrcy |
NVarchar (2) |
R6111 Report Currency |
|
| 429. |
ICDifExPe3 |
Decimal (21, 6) |
Multiple Count Vldt. Variance (%) |
|
| 430. |
INCSingToV |
NVarchar (1) |
Copy Single Counter to Validt. |
|
| 431. |
POrCByINC |
NVarchar (1) |
Posting or Create Date by INC |
|
| 432. |
EnbNegPym |
NVarchar (1) |
Enable Negative Payment |
|
| 433. |
SirenNo |
NVarchar (9) |
Siren Number |
|
| 434. |
SEPACredID |
NVarchar (35) |
SEPA Creditor ID |
|
| 435. |
InstitCode |
NVarchar (2) |
Institution Code |
|
| 436. |
ECDFormat |
Integer |
ECD File Format |
|
| 437. |
ApyDRinPEC |
NVarchar (1) |
Apply DR in Period End Closing |
|
| 438. |
ApyPRinPEC |
NVarchar (1) |
Apply PJ in Period End Closing |
|
| 439. |
TaxPyerSta |
NVarchar (2) |
TAX_PAYER_STATUS |
|
| 440. |
MaxINVRptR |
Integer |
Allowed Rows in INC Trans Rpt |
|
| 441. |
DftResWhs |
NVarchar (8) |
Default Resource Warehouse |
|
| 442. |
AutoResWhs |
NVarchar (1) |
Auto Add All Warehouses to New Resources |
|
| 443. |
InActRpt |
NVarchar (1) |
Inactive Reports |
|
| 444. |
InActMkt |
NVarchar (1) |
Inactive Marketing Documents |
|
| 445. |
InActPln |
NVarchar (1) |
Inactive Price Lists |
|
| 446. |
StartFrom |
NVarchar (1) |
Start From |
|
| 447. |
Months |
Smallint |
Months |
|
| 448. |
Days |
Smallint |
Days |
|
| 449. |
JEInFATran |
NVarchar (1) |
Always Create JE in Transfer |
|
| 450. |
TPLId |
Smallint |
UI Template ID |
|
| 451. |
TxtSrch |
NVarchar (1) |
Text Search |
|
| 452. |
ApyIBtoACT |
NVarchar (1) |
Apply IBAN Vldt. to Bank Acct |
|
| 453. |
JeUnGroup |
NVarchar (1) |
Journal Entry Lines Ungrouping |
|
| 454. |
IgnoreAdde |
NVarchar (1) |
Impresión de documento sin Addenda |
|
| 455. |
EnterAsTab |
NVarchar (1) |
|
|
| 456. |
MouseOnly |
NVarchar (1) |
|
|
| 457. |
PrjMngmnt |
NVarchar (1) |
|
|
| 458. |
ElectrDocs |
NVarchar (1) |
|
|
| 459. |
DotAsSep |
NVarchar (1) |
|
|
| 460. |
DoMngMth |
NVarchar (11) |
|
|
| 461. |
AlwBPNOwn |
NVarchar (1) |
|
|
| 462. |
EmptyPKL |
NVarchar (1) |
|
|
| 463. |
ExcNInvItm |
NVarchar (1) |
|
|
| 464. |
PayRefCalc |
Smallint |
|
|
| 465. |
MultiSched |
NVarchar (1) |
|
|
| 466. |
CloseWipV |
NVarchar (1) |
|
|
| 467. |
onHldLimt |
Decimal (21, 6) |
|
|
| 468. |
EnbApUpDoc |
NVarchar (1) |
|
|
| 469. |
EnbApUpDft |
NVarchar (1) |
|
|
| 470. |
EnPacking |
NVarchar (1) |
|
|
| 471. |
BlockZeroQ |
NVarchar (1) |
|
|
| 472. |
NegStoLv |
NVarchar (1) |
|
|
| 473. |
EnUpdBAPln |
NVarchar (1) |
|
|
| 474. |
BAOpPOR |
NVarchar (1) |
|
|
| 475. |
BAOpPDN |
NVarchar (1) |
|
|
| 476. |
BAOpAcctng |
NVarchar (1) |
|
|
| 477. |
AssgnOBAAP |
NVarchar (1) |
|
|
| 478. |
AssngOBAAR |
NVarchar (1) |
|
|
| 479. |
ApyToNewBP |
NVarchar (1) |
|
|
| 480. |
PrrConfrmd |
NVarchar (1) |
|
|
| 481. |
RrrConfrmd |
NVarchar (1) |
|
|
| 482. |
DflSeries |
Integer |
|
|
| 483. |
EnblLC |
NVarchar (1) |
|
|
| 484. |
DflAcct |
NVarchar (210) |
|
|
| 485. |
SmtpServer |
NVarchar (100) |
|
|
| 486. |
SmtpPort |
NVarchar (10) |
|
|
| 487. |
SmtpName |
NVarchar (100) |
|
|
| 488. |
SmtpPasswd |
NVarchar (254) |
|
|
| 489. |
SmtpEncode |
NVarchar (100) |
|
|
| 490. |
SmtpAuthen |
NVarchar (100) |
|
|
| 491. |
TlsEncryp |
NVarchar (1) |
|
|
| 492. |
HtmlDirect |
NVarchar (1) |
|
|
| 493. |
IncSubject |
NVarchar (1) |
|
|
| 494. |
TenLevel |
NVarchar (1) |
|
|
| 495. |
CreditDay2 |
Smallint |
|
|
| 496. |
CdtPrvDays |
Integer |
|
|
| 497. |
AuImpRates |
NVarchar (1) |
|
|
| 498. |
ValidateBa |
NVarchar (1) |
|
|
| 499. |
ManRemark |
NVarchar (1) |
|
|
| 500. |
ManRmkType |
NVarchar (1) |
|
|
| 501. |
ManRmkAlt |
NVarchar (1) |
|
|
| 502. |
TermsPath |
NClob |
|
|
| 503. |
EDocWSFrm |
Integer |
|
|
| 504. |
DspBUoM |
NVarchar (1) |
|
|
| 505. |
EDocSName |
NVarchar (200) |
|
|
| 506. |
EDocSEMail |
NVarchar (200) |
|
|
| 507. |
CpyRulToTx |
NVarchar (1) |
|
|
| 508. |
BpNoLock |
NVarchar (1) |
|
|
| 509. |
SearchUrl |
NVarchar (254) |
|
|
| 510. |
ExpDocLoc |
NVarchar (1) |
|
|
| 511. |
TenantId |
NVarchar (100) |
|
|
| 512. |
IntegUrl |
NVarchar (254) |
|
|
| 513. |
EnableMTD |
NVarchar (1) |
|
|
| 514. |
PublicComp |
NVarchar (1) |
|
|
| 515. |
EnableEWB |
NVarchar (1) |
|
|
| 516. |
TspEntry |
Integer |
|
|
| 517. |
TspLine |
Integer |
|
|
| 518. |
EwbGenType |
NVarchar (1) |
|
|
| 519. |
VolumeLic |
NVarchar (1) |
|
|
| 520. |
Threshold |
Decimal (21, 6) |
|
|
| 521. |
EnAuthUpt |
NVarchar (1) |
|
|
| 522. |
DfSVatExG |
NVarchar (8) |
|
|
| 523. |
DfSVatExL |
NVarchar (8) |
|
|
| 524. |
EnUpdBpAdr |
NVarchar (1) |
|
|
| 525. |
PAutoDueDt |
NVarchar (1) |
|
|
| 526. |
PDuDtMonth |
Smallint |
|
|
| 527. |
DriDownBOM |
NVarchar (1) |
|
|
| 528. |
EnExtTax |
NVarchar (1) |
|
|
| 529. |
DfDateFct |
Integer |
|
|
| 530. |
DfDateUnit |
NVarchar (1) |
|
|
| 531. |
EnMutiBP |
NVarchar (1) |
|
|
| 532. |
AddBPToEC |
NVarchar (1) |
|
|
| 533. |
EnAutoRsz |
NVarchar (1) |
|
|
| 534. |
QRMinSize |
Integer |
|
|
| 535. |
QRMaxSize |
Integer |
|
|
| 536. |
QRScale |
Integer |
|
|
| 537. |
QRExpDays |
Integer |
|
|
| 538. |
QRExpir |
NVarchar (1) |
|
|
| 539. |
QRCorrLvl |
NVarchar (1) |
|
|
| 540. |
TaxCatVer |
NVarchar (20) |
|
|
| 541. |
EffPriDisc |
NVarchar (1) |
|
|
| 542. |
CpyBaseAtc |
NVarchar (1) |
|
|
| 543. |
ItmDupBCD |
NVarchar (1) |
|
|
| 544. |
AllowUpdat |
NVarchar (1) |
|
|
| 545. |
BlkNegJLin |
NVarchar (1) |
|
|
| 546. |
EnARWTLnMX |
NVarchar (1) |
|
|
| 547. |
PoARPayCat |
NVarchar (1) |
|
|
| 548. |
AplyARExhR |
NVarchar (1) |
|
|
| 549. |
EnAPWTLnMX |
NVarchar (1) |
|
|
| 550. |
PoAPPayCat |
NVarchar (1) |
|
|
| 551. |
AplyAPExhR |
NVarchar (1) |
|
|
| 552. |
DispCtInBP |
NVarchar (1) |
|
|
| 553. |
UseDfltPL |
NVarchar (1) |
|
|
| 554. |
DfltCustPL |
Smallint |
|
|
| 555. |
DfltVendPL |
Smallint |
|
|
| 556. |
EORINumber |
NVarchar (17) |
|
|
| 557. |
SkipRutChk |
NVarchar (1) |
|
|
| 558. |
EnbUQAudit |
NVarchar (1) |
|
|
| 559. |
CpyBomAtc |
NVarchar (1) |
|
|
| 560. |
DnOvrwrAtc |
NVarchar (1) |
|
|
| 561. |
IsTAForMI |
NVarchar (1) |
|
|
| 562. |
AutoTAAppr |
NVarchar (1) |
|
|
| 563. |
BlockAtt |
NVarchar (1) |
|
|