API tools faq
paste
Advertisement
Guest User

Sage Line 50 v19 database tables and rows

a guest
Feb 26th, 2014
1,608
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 69.94 KB | None | 0 0
raw download clone embed print report
  1. Array
  2. (
  3. [COMPANY] => Array
  4. (
  5. [0] => COMPANYID
  6. [1] => PROTX_VENDOR
  7. [2] => CASH_REGISTER_BANK
  8. [3] => CASH_REGISTER_SALES_NOM
  9. [4] => CASH_REGISTER_TAXCODE
  10. [5] => CASH_REGISTER_DISCREPENCIES_NOM
  11. [6] => CASH_REGISTER_TAX_INCLUSIVE_FLAG
  12. [7] => QUOTES_TO_ORDERS
  13. [8] => PROTX_USERID
  14. [9] => PROTX_PASSWORD
  15. [10] => PROTX_LAST_SYNC_DATE
  16. [11] => PROTX_ENABLED
  17. [12] => FLAT_RATE_VAT_PERCENT
  18. [13] => NAME
  19. [14] => ADDRESS_1
  20. [15] => ADDRESS_2
  21. [16] => ADDRESS_3
  22. [17] => ADDRESS_4
  23. [18] => ADDRESS_5
  24. [19] => C_ADDRESS_1
  25. [20] => C_ADDRESS_2
  26. [21] => C_ADDRESS_3
  27. [22] => C_ADDRESS_4
  28. [23] => C_ADDRESS_5
  29. [24] => L_NAME
  30. [25] => L_ADDRESS_1
  31. [26] => L_ADDRESS_2
  32. [27] => L_ADDRESS_3
  33. [28] => L_ADDRESS_4
  34. [29] => L_ADDRESS_5
  35. [30] => TELEPHONE
  36. [31] => FAX
  37. [32] => E_MAIL
  38. [33] => WEB_ADDRESS
  39. [34] => CREDIT_REF
  40. [35] => DEL_NAME
  41. [36] => DEL_ADDRESS_1
  42. [37] => DEL_ADDRESS_2
  43. [38] => DEL_ADDRESS_3
  44. [39] => DEL_ADDRESS_4
  45. [40] => DEL_ADDRESS_5
  46. [41] => DEL_TELEPHONE
  47. [42] => DEL_FAX
  48. [43] => DEL_E_MAIL
  49. [44] => DEL_WEB_ADDRESS
  50. [45] => VAT_REG_NUMBER
  51. [46] => START_MONTH
  52. [47] => FINANCIAL_YEAR
  53. [48] => DEFAULT_CHART
  54. [49] => DEFAULT_CREDIT_BUREAU
  55. [50] => END_OF_REPORT
  56. [51] => ADDRESS_LABEL_1
  57. [52] => ADDRESS_LABEL_2
  58. [53] => ADDRESS_LABEL_3
  59. [54] => ADDRESS_LABEL_4
  60. [55] => ADDRESS_LABEL_5
  61. [56] => SALES_LABEL_1
  62. [57] => SALES_LABEL_2
  63. [58] => SALES_LABEL_3
  64. [59] => PURCHASE_LABEL_1
  65. [60] => PURCHASE_LABEL_2
  66. [61] => PURCHASE_LABEL_3
  67. [62] => STOCK_LABEL_1
  68. [63] => STOCK_LABEL_2
  69. [64] => STOCK_LABEL_3
  70. [65] => STOCKCATEGORY_LABEL
  71. [66] => DEPARTMENTS_LABEL
  72. [67] => FIXEDASSETS_LABEL
  73. [68] => STOCK_DISCOUNT_A
  74. [69] => STOCK_DISCOUNT_B
  75. [70] => STOCK_DISCOUNT_C
  76. [71] => STOCK_DISCOUNT_D
  77. [72] => STOCK_DISCOUNT_E
  78. [73] => NOM_DEBTORS
  79. [74] => NOM_CREDITORS
  80. [75] => NOM_TAX_SALES
  81. [76] => NOM_TAX_PURCHASE
  82. [77] => NOM_DISCOUNT_SALES
  83. [78] => NOM_DISCOUNT_PURCHASE
  84. [79] => NOM_DEFAULT_BANK
  85. [80] => NOM_DEFAULT_SALES
  86. [81] => NOM_RETAINED_EARNINGS
  87. [82] => NOM_CREDIT_CHARGES
  88. [83] => NOM_BAD_DEBTS
  89. [84] => NOM_ACCRUALS
  90. [85] => NOM_PREPAYMENTS
  91. [86] => NOM_MISPOSTINGS
  92. [87] => NOM_SUSPENSE
  93. [88] => PAYMENT_DUE_SALES
  94. [89] => PAYMENT_DUE_PURCHASE
  95. [90] => NON_VAT_TAX_CODE
  96. [91] => VAT_CASH
  97. [92] => SALES_AGE_BY_MONTH
  98. [93] => SALES_AGED_PERIOD_1
  99. [94] => SALES_AGED_PERIOD_2
  100. [95] => SALES_AGED_PERIOD_3
  101. [96] => SALES_AGED_PERIOD_4
  102. [97] => PURCHASE_AGE_BY_MONTH
  103. [98] => PURCHASE_AGED_PERIOD_1
  104. [99] => PURCHASE_AGED_PERIOD_2
  105. [100] => PURCHASE_AGED_PERIOD_3
  106. [101] => PURCHASE_AGED_PERIOD_4
  107. [102] => SALES_AMOUNT_SOLD_1
  108. [103] => SALES_AMOUNT_SOLD_2
  109. [104] => SALES_AMOUNT_SOLD_3
  110. [105] => SALES_AMOUNT_SOLD_4
  111. [106] => SALES_AMOUNT_SOLD_5
  112. [107] => SALES_AMOUNT_SOLD_6
  113. [108] => SALES_AMOUNT_SOLD_7
  114. [109] => SALES_AMOUNT_SOLD_8
  115. [110] => SALES_AMOUNT_SOLD_9
  116. [111] => SALES_AMOUNT_SOLD_10
  117. [112] => SALES_ADD_DISC_1
  118. [113] => SALES_ADD_DISC_2
  119. [114] => SALES_ADD_DISC_3
  120. [115] => SALES_ADD_DISC_4
  121. [116] => SALES_ADD_DISC_5
  122. [117] => SALES_ADD_DISC_6
  123. [118] => SALES_ADD_DISC_7
  124. [119] => SALES_ADD_DISC_8
  125. [120] => SALES_ADD_DISC_9
  126. [121] => SALES_ADD_DISC_10
  127. [122] => ALLOW_NEGATIVE_STOCK
  128. [123] => INVOICE_DISC_UNIT_PRICE
  129. [124] => SOP_CARRIAGE_NET
  130. [125] => SOP_CARRIAGE_NOM_CODE
  131. [126] => SOP_CARRIAGE_TAX_CODE
  132. [127] => SOP_CARRIAGE_DEPT
  133. [128] => SOP_GLOBAL_DETAILS
  134. [129] => SOP_GLOBAL_NOM_CODE
  135. [130] => SOP_GLOBAL_TAX_CODE
  136. [131] => SOP_GLOBAL_DEPT
  137. [132] => POP_CARRIAGE_NET
  138. [133] => POP_CARRIAGE_NOM_CODE
  139. [134] => POP_CARRIAGE_TAX_CODE
  140. [135] => POP_CARRIAGE_DEPT
  141. [136] => POP_GLOBAL_DETAILS
  142. [137] => POP_GLOBAL_NOM_CODE
  143. [138] => POP_GLOBAL_TAX_CODE
  144. [139] => POP_GLOBAL_DEPT
  145. [140] => NO_DISCOUNT_PRICE_LIST
  146. [141] => QTY_DECIMAL_PLACE
  147. [142] => UNIT_DECIMAL_PLACE
  148. [143] => BUDGETING_METHOD
  149. [144] => DEFAULT_BUDGETING_CHART
  150. [145] => CHARITYTAXREF
  151. [146] => DUNS_NUMBER
  152. [147] => CC_LETTER_1
  153. [148] => CC_LETTER_2
  154. [149] => CC_LETTER_3
  155. [150] => CLOSED_LEDGER_DATE_ENABLED
  156. [151] => CLOSED_LEDGER_CHECK_DATE
  157. [152] => COUNTRY_CODE
  158. [153] => RECORD_CREATE_DATE
  159. [154] => RECORD_MODIFY_DATE
  160. [155] => RECORD_DELETED
  161. )
  162.  
  163. [PERIOD] => Array
  164. (
  165. [0] => PERIOD
  166. [1] => DESCRIPTION
  167. )
  168.  
  169. [SALES_LEDGER] => Array
  170. (
  171. )
  172.  
  173. [PURCHASE_LEDGER] => Array
  174. (
  175. )
  176.  
  177. [NOMINAL_LEDGER] => Array
  178. (
  179. )
  180.  
  181. [AUDIT_HEADER] => Array
  182. (
  183. )
  184.  
  185. [AUDIT_SPLIT] => Array
  186. (
  187. [0] => TRAN_NUMBER
  188. [1] => TYPE
  189. [2] => DATE
  190. [3] => ACCOUNT_REF
  191. [4] => NOMINAL_CODE
  192. [5] => BANK_CODE
  193. [6] => INV_REF
  194. [7] => USER_NAME
  195. [8] => DETAILS
  196. [9] => EXTRA_REF
  197. [10] => DISPUTED
  198. [11] => STMT_TEXT
  199. [12] => BANK_FLAG
  200. [13] => VAT_FLAG
  201. [14] => PAID_FLAG
  202. [15] => PAID_STATUS
  203. [16] => DEPT_NUMBER
  204. [17] => DEPT_NAME
  205. [18] => TAX_CODE
  206. [19] => DELETED_FLAG
  207. [20] => NET_AMOUNT
  208. [21] => TAX_AMOUNT
  209. [22] => GROSS_AMOUNT
  210. [23] => AMOUNT_PAID
  211. [24] => PAYMENT
  212. [25] => OUTSTANDING
  213. [26] => FOREIGN_NET_AMOUNT
  214. [27] => FOREIGN_TAX_AMOUNT
  215. [28] => FOREIGN_GROSS_AMOUNT
  216. [29] => FOREIGN_AMOUNT_PAID
  217. [30] => AGED_BALANCE
  218. [31] => AGED_FUTURE
  219. [32] => AGED_CURRENT
  220. [33] => AGED_30
  221. [34] => AGED_60
  222. [35] => AGED_90
  223. [36] => AGED_OLDER
  224. [37] => AGED_CUM_CURRENT
  225. [38] => AGED_CUM_30
  226. [39] => AGED_CUM_60
  227. [40] => AGED_CUM_90
  228. [41] => FOREIGN_AGED_BALANCE
  229. [42] => FOREIGN_AGED_FUTURE
  230. [43] => FOREIGN_AGED_CURRENT
  231. [44] => FOREIGN_AGED_30
  232. [45] => FOREIGN_AGED_60
  233. [46] => FOREIGN_AGED_90
  234. [47] => FOREIGN_AGED_OLDER
  235. [48] => FOREIGN_AGED_CUM_CURRENT
  236. [49] => FOREIGN_AGED_CUM_30
  237. [50] => FOREIGN_AGED_CUM_60
  238. [51] => FOREIGN_AGED_CUM_90
  239. [52] => SPLIT_NUMBER
  240. [53] => HEADER_NUMBER
  241. [54] => VAT_FLAG_CODE
  242. [55] => DATE_FLAG
  243. [56] => DATE_ENTERED
  244. [57] => VAT_RECONCILED_DATE
  245. [58] => DISPUTE_CODE
  246. [59] => FUND_ID
  247. [60] => VAT_LEDGER_RETURN_ID
  248. [61] => RECORD_CREATE_DATE
  249. [62] => RECORD_MODIFY_DATE
  250. [63] => RECORD_DELETED
  251. )
  252.  
  253. [AUDIT_HISTORY_HEADER] => Array
  254. (
  255. [0] => TRAN_NUMBER
  256. [1] => ITEM_COUNT
  257. [2] => TYPE
  258. [3] => DATE
  259. [4] => ACCOUNT_REF
  260. [5] => SALES_PURCHASE_REF
  261. [6] => BANK_CODE
  262. [7] => INV_REF
  263. [8] => USER_NAME
  264. [9] => DETAILS
  265. [10] => DUE_DATE
  266. [11] => LAST_CHARGE_DATE
  267. [12] => FINANCE_CHARGE
  268. [13] => INTEREST_RATE
  269. [14] => ELECTRONIC_TRANS
  270. [15] => DISPUTED
  271. [16] => PAID_FLAG
  272. [17] => PAID_STATUS
  273. [18] => DELETED_FLAG
  274. [19] => NET_AMOUNT
  275. [20] => TAX_AMOUNT
  276. [21] => GROSS_AMOUNT
  277. [22] => BANK_AMOUNT
  278. [23] => AMOUNT_PAID
  279. [24] => FOREIGN_NET_AMOUNT
  280. [25] => FOREIGN_TAX_AMOUNT
  281. [26] => FOREIGN_GROSS_AMOUNT
  282. [27] => FOREIGN_AMOUNT_PAID
  283. [28] => FOREIGN_BANK_AMOUNT
  284. [29] => CURRENCY
  285. [30] => CURRENCY_TYPE
  286. [31] => EURO_GROSS
  287. [32] => EURO_RATE
  288. [33] => FOREIGN_RATE
  289. [34] => BANK_FLAG
  290. [35] => HEADER_NUMBER
  291. [36] => DATE_ENTERED
  292. [37] => DATE_BANK_RECONCILED
  293. [38] => CATE_ID
  294. [39] => CIS_RECONCILED
  295. [40] => RECORD_CREATE_DATE
  296. [41] => RECORD_MODIFY_DATE
  297. [42] => RECORD_DELETED
  298. )
  299.  
  300. [AUDIT_HISTORY_SPLIT] => Array
  301. (
  302. [0] => TRAN_NUMBER
  303. [1] => TYPE
  304. [2] => DATE
  305. [3] => NOMINAL_CODE
  306. [4] => USER_NAME
  307. [5] => DETAILS
  308. [6] => EXTRA_REF
  309. [7] => DISPUTED
  310. [8] => VAT_FLAG
  311. [9] => PAID_FLAG
  312. [10] => PAID_STATUS
  313. [11] => DEPT_NUMBER
  314. [12] => DEPT_NAME
  315. [13] => TAX_CODE
  316. [14] => DELETED_FLAG
  317. [15] => NET_AMOUNT
  318. [16] => TAX_AMOUNT
  319. [17] => GROSS_AMOUNT
  320. [18] => AMOUNT_PAID
  321. [19] => FOREIGN_NET_AMOUNT
  322. [20] => FOREIGN_TAX_AMOUNT
  323. [21] => FOREIGN_GROSS_AMOUNT
  324. [22] => FOREIGN_AMOUNT_PAID
  325. [23] => SPLIT_NUMBER
  326. [24] => HEADER_NUMBER
  327. [25] => VAT_FLAG_CODE
  328. [26] => DATE_ENTERED
  329. [27] => VAT_RECONCILED_DATE
  330. [28] => RECORD_CREATE_DATE
  331. [29] => RECORD_MODIFY_DATE
  332. [30] => RECORD_DELETED
  333. )
  334.  
  335. [AUDIT_HISTORY_JOURNAL] => Array
  336. (
  337. [0] => TRAN_NUMBER
  338. [1] => TYPE
  339. [2] => DATE
  340. [3] => NOMINAL_CODE
  341. [4] => USER_NAME
  342. [5] => DETAILS
  343. [6] => EXTRA_REF
  344. [7] => DISPUTED
  345. [8] => VAT_FLAG
  346. [9] => PAID_FLAG
  347. [10] => PAID_STATUS
  348. [11] => DEPT_NUMBER
  349. [12] => DEPT_NAME
  350. [13] => TAX_CODE
  351. [14] => DELETED_FLAG
  352. [15] => AMOUNT
  353. [16] => FOREIGN_AMOUNT
  354. [17] => SPLIT_NUMBER
  355. [18] => HEADER_NUMBER
  356. [19] => VAT_FLAG_CODE
  357. [20] => DATE_ENTERED
  358. [21] => VAT_RECONCILED_DATE
  359. [22] => RECORD_CREATE_DATE
  360. [23] => RECORD_MODIFY_DATE
  361. [24] => RECORD_DELETED
  362. )
  363.  
  364. [AUDIT_HISTORY_USAGE] => Array
  365. (
  366. [0] => TYPE
  367. [1] => USAGE_NUMBER
  368. [2] => SPLIT_NUMBER
  369. [3] => SPLIT_CROSSREF
  370. [4] => REFERENCE
  371. [5] => DETAILS
  372. [6] => USER_NAME
  373. [7] => DATE
  374. [8] => AMOUNT
  375. [9] => FOREIGN_AMOUNT
  376. [10] => DELETED_FLAG
  377. [11] => CIS_VAT
  378. [12] => RECORD_CREATE_DATE
  379. [13] => RECORD_MODIFY_DATE
  380. [14] => RECORD_DELETED
  381. )
  382.  
  383. [AUDIT_JOURNAL] => Array
  384. (
  385. [0] => TRAN_NUMBER
  386. [1] => TYPE
  387. [2] => DATE
  388. [3] => ACCOUNT_REF
  389. [4] => NOMINAL_CODE
  390. [5] => BANK_CODE
  391. [6] => INV_REF
  392. [7] => USER_NAME
  393. [8] => DETAILS
  394. [9] => EXTRA_REF
  395. [10] => DISPUTED
  396. [11] => STMT_TEXT
  397. [12] => BANK_FLAG
  398. [13] => VAT_FLAG
  399. [14] => PAID_FLAG
  400. [15] => PAID_STATUS
  401. [16] => DEPT_NUMBER
  402. [17] => DEPT_NAME
  403. [18] => TAX_CODE
  404. [19] => DELETED_FLAG
  405. [20] => AMOUNT
  406. [21] => FOREIGN_AMOUNT
  407. [22] => SPLIT_NUMBER
  408. [23] => HEADER_NUMBER
  409. [24] => VAT_FLAG_CODE
  410. [25] => DATE_FLAG
  411. [26] => DATE_ENTERED
  412. [27] => VAT_RECONCILED_DATE
  413. [28] => DISPUTE_CODE
  414. [29] => FUND_ID
  415. [30] => VAT_LEDGER_RETURN_ID
  416. [31] => RECORD_CREATE_DATE
  417. [32] => RECORD_MODIFY_DATE
  418. [33] => RECORD_DELETED
  419. )
  420.  
  421. [AUDIT_VAT] => Array
  422. (
  423. [0] => TRAN_NUMBER
  424. [1] => TYPE
  425. [2] => DATE
  426. [3] => ACCOUNT_REF
  427. [4] => NOMINAL_CODE
  428. [5] => BANK_CODE
  429. [6] => INV_REF
  430. [7] => USER_NAME
  431. [8] => DETAILS
  432. [9] => EXTRA_REF
  433. [10] => DISPUTED
  434. [11] => STMT_TEXT
  435. [12] => BANK_FLAG
  436. [13] => VAT_FLAG
  437. [14] => PAID_FLAG
  438. [15] => PAID_STATUS
  439. [16] => DEPT_NUMBER
  440. [17] => DEPT_NAME
  441. [18] => TAX_CODE
  442. [19] => DELETED_FLAG
  443. [20] => AMOUNT
  444. [21] => AMOUNT_INVOICE
  445. [22] => AMOUNT_CREDIT
  446. [23] => AMOUNT_BANK
  447. [24] => AMOUNT_JOURNAL
  448. [25] => VAT_BOX
  449. [26] => VAT_TRAN
  450. [27] => VAT_TRAN_NAME
  451. [28] => VAT_INCLUDE
  452. [29] => SPLIT_NUMBER
  453. [30] => HEADER_NUMBER
  454. [31] => VAT_FLAG_CODE
  455. [32] => DATE_FLAG
  456. [33] => DATE_ENTERED
  457. [34] => VAT_RECONCILED_DATE
  458. [35] => DISPUTE_CODE
  459. [36] => FUND_ID
  460. [37] => VAT_LEDGER_RETURN_ID
  461. [38] => RECORD_CREATE_DATE
  462. [39] => RECORD_MODIFY_DATE
  463. [40] => RECORD_DELETED
  464. [41] => TRAN_NUMBER
  465. [42] => TYPE
  466. [43] => DATE
  467. [44] => ACCOUNT_REF
  468. [45] => NOMINAL_CODE
  469. [46] => BANK_CODE
  470. [47] => INV_REF
  471. [48] => USER_NAME
  472. [49] => DETAILS
  473. [50] => EXTRA_REF
  474. [51] => DISPUTED
  475. [52] => STMT_TEXT
  476. [53] => BANK_FLAG
  477. [54] => VAT_FLAG
  478. [55] => PAID_FLAG
  479. [56] => PAID_STATUS
  480. [57] => DEPT_NUMBER
  481. [58] => DEPT_NAME
  482. [59] => TAX_CODE
  483. [60] => DELETED_FLAG
  484. [61] => AMOUNT
  485. [62] => AMOUNT_INVOICE
  486. [63] => AMOUNT_CREDIT
  487. [64] => AMOUNT_BANK
  488. [65] => AMOUNT_JOURNAL
  489. [66] => VAT_BOX
  490. [67] => VAT_TRAN
  491. [68] => VAT_TRAN_NAME
  492. [69] => VAT_INCLUDE
  493. [70] => SPLIT_NUMBER
  494. [71] => HEADER_NUMBER
  495. [72] => VAT_FLAG_CODE
  496. [73] => DATE_FLAG
  497. [74] => DATE_ENTERED
  498. [75] => VAT_RECONCILED_DATE
  499. [76] => DISPUTE_CODE
  500. [77] => FUND_ID
  501. [78] => VAT_LEDGER_RETURN_ID
  502. [79] => RECORD_CREATE_DATE
  503. [80] => RECORD_MODIFY_DATE
  504. [81] => RECORD_DELETED
  505. )
  506.  
  507. [AUDIT_USAGE] => Array
  508. (
  509. [0] => TYPE
  510. [1] => USAGE_NUMBER
  511. [2] => SPLIT_NUMBER
  512. [3] => SPLIT_CROSSREF
  513. [4] => REFERENCE
  514. [5] => DETAILS
  515. [6] => USER_NAME
  516. [7] => DATE
  517. [8] => AMOUNT
  518. [9] => FOREIGN_AMOUNT
  519. [10] => DELETED_FLAG
  520. [11] => CIS_VAT
  521. [12] => RECORD_CREATE_DATE
  522. [13] => RECORD_MODIFY_DATE
  523. [14] => RECORD_DELETED
  524. )
  525.  
  526. [DEPARTMENT] => Array
  527. (
  528. [0] => NUMBER
  529. [1] => NAME
  530. [2] => REFERENCE
  531. [3] => RECORD_CREATE_DATE
  532. [4] => RECORD_MODIFY_DATE
  533. [5] => RECORD_DELETED
  534. )
  535.  
  536. [BANK] => Array
  537. (
  538. )
  539.  
  540. [STOCK] => Array
  541. (
  542. [0] => STOCK_CODE
  543. [1] => DESCRIPTION
  544. [2] => UNIT_OF_SALE
  545. [3] => NOMINAL_CODE
  546. [4] => PURCHASE_REF
  547. [5] => SUPPLIER_PART_NUMBER
  548. [6] => LOCATION
  549. [7] => COMMODITY_CODE
  550. [8] => SALES_PRICE
  551. [9] => WEB_DESCRIPTION
  552. [10] => WEB_DETAILS
  553. [11] => WEB_CATEGORY_1
  554. [12] => WEB_CATEGORY_2
  555. [13] => WEB_CATEGORY_3
  556. [14] => WEB_IMAGE_FILE
  557. [15] => WEB_PUBLISH
  558. [16] => WEB_SPECIAL
  559. [17] => INTRASTAT_COMM_CODE
  560. [18] => INTRASTAT_IMPORT_DUTY_CODE
  561. [19] => IGNORE_STK_LVL_FLAG
  562. [20] => DEPT_NUMBER
  563. [21] => DEPT_NAME
  564. [22] => TAX_CODE
  565. [23] => ASSEMBLY_LEVEL
  566. [24] => LINK_LEVEL
  567. [25] => STOCK_CAT
  568. [26] => STOCK_CAT_NAME
  569. [27] => STOCK_TAKE_DATE
  570. [28] => LAST_PURCHASE_PRICE
  571. [29] => LAST_DISC_PURCHASE_PRICE
  572. [30] => AVERAGE_COST_PRICE
  573. [31] => QTY_IN_STOCK
  574. [32] => QTY_ON_ORDER
  575. [33] => QTY_ALLOCATED
  576. [34] => QTY_LAST_ORDER
  577. [35] => QTY_REORDER
  578. [36] => QTY_REORDER_LEVEL
  579. [37] => QTY_LAST_STOCK_TAKE
  580. [38] => QTY_MAKEUP
  581. [39] => LAST_SALE_DATE
  582. [40] => LAST_PURCHASE_DATE
  583. [41] => UNIT_WEIGHT
  584. [42] => HAS_NO_COMPONENT
  585. [43] => HAS_BOM
  586. [44] => BARCODE
  587. [45] => COMPONENT_CODE_1
  588. [46] => COMPONENT_CODE_2
  589. [47] => COMPONENT_CODE_3
  590. [48] => COMPONENT_CODE_4
  591. [49] => COMPONENT_CODE_5
  592. [50] => COMPONENT_CODE_6
  593. [51] => COMPONENT_CODE_7
  594. [52] => COMPONENT_CODE_8
  595. [53] => COMPONENT_CODE_9
  596. [54] => COMPONENT_CODE_10
  597. [55] => COMPONENT_CODE_11
  598. [56] => COMPONENT_CODE_12
  599. [57] => COMPONENT_CODE_13
  600. [58] => COMPONENT_CODE_14
  601. [59] => COMPONENT_CODE_15
  602. [60] => COMPONENT_CODE_16
  603. [61] => COMPONENT_CODE_17
  604. [62] => COMPONENT_CODE_18
  605. [63] => COMPONENT_CODE_19
  606. [64] => COMPONENT_CODE_20
  607. [65] => COMPONENT_CODE_21
  608. [66] => COMPONENT_CODE_22
  609. [67] => COMPONENT_CODE_23
  610. [68] => COMPONENT_CODE_24
  611. [69] => COMPONENT_CODE_25
  612. [70] => COMPONENT_CODE_26
  613. [71] => COMPONENT_CODE_27
  614. [72] => COMPONENT_CODE_28
  615. [73] => COMPONENT_CODE_29
  616. [74] => COMPONENT_CODE_30
  617. [75] => COMPONENT_CODE_31
  618. [76] => COMPONENT_CODE_32
  619. [77] => COMPONENT_CODE_33
  620. [78] => COMPONENT_CODE_34
  621. [79] => COMPONENT_CODE_35
  622. [80] => COMPONENT_CODE_36
  623. [81] => COMPONENT_CODE_37
  624. [82] => COMPONENT_CODE_38
  625. [83] => COMPONENT_CODE_39
  626. [84] => COMPONENT_CODE_40
  627. [85] => COMPONENT_CODE_41
  628. [86] => COMPONENT_CODE_42
  629. [87] => COMPONENT_CODE_43
  630. [88] => COMPONENT_CODE_44
  631. [89] => COMPONENT_CODE_45
  632. [90] => COMPONENT_CODE_46
  633. [91] => COMPONENT_CODE_47
  634. [92] => COMPONENT_CODE_48
  635. [93] => COMPONENT_CODE_49
  636. [94] => COMPONENT_CODE_50
  637. [95] => COMPONENT_QTY_1
  638. [96] => COMPONENT_QTY_2
  639. [97] => COMPONENT_QTY_3
  640. [98] => COMPONENT_QTY_4
  641. [99] => COMPONENT_QTY_5
  642. [100] => COMPONENT_QTY_6
  643. [101] => COMPONENT_QTY_7
  644. [102] => COMPONENT_QTY_8
  645. [103] => COMPONENT_QTY_9
  646. [104] => COMPONENT_QTY_10
  647. [105] => COMPONENT_QTY_11
  648. [106] => COMPONENT_QTY_12
  649. [107] => COMPONENT_QTY_13
  650. [108] => COMPONENT_QTY_14
  651. [109] => COMPONENT_QTY_15
  652. [110] => COMPONENT_QTY_16
  653. [111] => COMPONENT_QTY_17
  654. [112] => COMPONENT_QTY_18
  655. [113] => COMPONENT_QTY_19
  656. [114] => COMPONENT_QTY_20
  657. [115] => COMPONENT_QTY_21
  658. [116] => COMPONENT_QTY_22
  659. [117] => COMPONENT_QTY_23
  660. [118] => COMPONENT_QTY_24
  661. [119] => COMPONENT_QTY_25
  662. [120] => COMPONENT_QTY_26
  663. [121] => COMPONENT_QTY_27
  664. [122] => COMPONENT_QTY_28
  665. [123] => COMPONENT_QTY_29
  666. [124] => COMPONENT_QTY_30
  667. [125] => COMPONENT_QTY_31
  668. [126] => COMPONENT_QTY_32
  669. [127] => COMPONENT_QTY_33
  670. [128] => COMPONENT_QTY_34
  671. [129] => COMPONENT_QTY_35
  672. [130] => COMPONENT_QTY_36
  673. [131] => COMPONENT_QTY_37
  674. [132] => COMPONENT_QTY_38
  675. [133] => COMPONENT_QTY_39
  676. [134] => COMPONENT_QTY_40
  677. [135] => COMPONENT_QTY_41
  678. [136] => COMPONENT_QTY_42
  679. [137] => COMPONENT_QTY_43
  680. [138] => COMPONENT_QTY_44
  681. [139] => COMPONENT_QTY_45
  682. [140] => COMPONENT_QTY_46
  683. [141] => COMPONENT_QTY_47
  684. [142] => COMPONENT_QTY_48
  685. [143] => COMPONENT_QTY_49
  686. [144] => COMPONENT_QTY_50
  687. [145] => QTY_SOLD_BF
  688. [146] => QTY_SOLD_MTH1
  689. [147] => QTY_SOLD_MTH2
  690. [148] => QTY_SOLD_MTH3
  691. [149] => QTY_SOLD_MTH4
  692. [150] => QTY_SOLD_MTH5
  693. [151] => QTY_SOLD_MTH6
  694. [152] => QTY_SOLD_MTH7
  695. [153] => QTY_SOLD_MTH8
  696. [154] => QTY_SOLD_MTH9
  697. [155] => QTY_SOLD_MTH10
  698. [156] => QTY_SOLD_MTH11
  699. [157] => QTY_SOLD_MTH12
  700. [158] => QTY_SOLD_FUTURE
  701. [159] => SALES_BF
  702. [160] => SALES_MTH1
  703. [161] => SALES_MTH2
  704. [162] => SALES_MTH3
  705. [163] => SALES_MTH4
  706. [164] => SALES_MTH5
  707. [165] => SALES_MTH6
  708. [166] => SALES_MTH7
  709. [167] => SALES_MTH8
  710. [168] => SALES_MTH9
  711. [169] => SALES_MTH10
  712. [170] => SALES_MTH11
  713. [171] => SALES_MTH12
  714. [172] => SALES_FUTURE
  715. [173] => COST_BF
  716. [174] => COST_MTH1
  717. [175] => COST_MTH2
  718. [176] => COST_MTH3
  719. [177] => COST_MTH4
  720. [178] => COST_MTH5
  721. [179] => COST_MTH6
  722. [180] => COST_MTH7
  723. [181] => COST_MTH8
  724. [182] => COST_MTH9
  725. [183] => COST_MTH10
  726. [184] => COST_MTH11
  727. [185] => COST_MTH12
  728. [186] => COST_FUTURE
  729. [187] => THIS_RECORD
  730. [188] => BUDGET_QTY_SOLD_BF
  731. [189] => BUDGET_QTY_SOLD_MTH1
  732. [190] => BUDGET_QTY_SOLD_MTH2
  733. [191] => BUDGET_QTY_SOLD_MTH3
  734. [192] => BUDGET_QTY_SOLD_MTH4
  735. [193] => BUDGET_QTY_SOLD_MTH5
  736. [194] => BUDGET_QTY_SOLD_MTH6
  737. [195] => BUDGET_QTY_SOLD_MTH7
  738. [196] => BUDGET_QTY_SOLD_MTH8
  739. [197] => BUDGET_QTY_SOLD_MTH9
  740. [198] => BUDGET_QTY_SOLD_MTH10
  741. [199] => BUDGET_QTY_SOLD_MTH11
  742. [200] => BUDGET_QTY_SOLD_MTH12
  743. [201] => BUDGET_QTY_SOLD_FUTURE
  744. [202] => BUDGET_SALES_BF
  745. [203] => BUDGET_SALES_MTH1
  746. [204] => BUDGET_SALES_MTH2
  747. [205] => BUDGET_SALES_MTH3
  748. [206] => BUDGET_SALES_MTH4
  749. [207] => BUDGET_SALES_MTH5
  750. [208] => BUDGET_SALES_MTH6
  751. [209] => BUDGET_SALES_MTH7
  752. [210] => BUDGET_SALES_MTH8
  753. [211] => BUDGET_SALES_MTH9
  754. [212] => BUDGET_SALES_MTH10
  755. [213] => BUDGET_SALES_MTH11
  756. [214] => BUDGET_SALES_MTH12
  757. [215] => BUDGET_SALES_FUTURE
  758. [216] => PRIOR_YR_QTY_SOLD_BF
  759. [217] => PRIOR_YR_QTY_SOLD_MTH1
  760. [218] => PRIOR_YR_QTY_SOLD_MTH2
  761. [219] => PRIOR_YR_QTY_SOLD_MTH3
  762. [220] => PRIOR_YR_QTY_SOLD_MTH4
  763. [221] => PRIOR_YR_QTY_SOLD_MTH5
  764. [222] => PRIOR_YR_QTY_SOLD_MTH6
  765. [223] => PRIOR_YR_QTY_SOLD_MTH7
  766. [224] => PRIOR_YR_QTY_SOLD_MTH8
  767. [225] => PRIOR_YR_QTY_SOLD_MTH9
  768. [226] => PRIOR_YR_QTY_SOLD_MTH10
  769. [227] => PRIOR_YR_QTY_SOLD_MTH11
  770. [228] => PRIOR_YR_QTY_SOLD_MTH12
  771. [229] => PRIOR_YR_QTY_SOLD_FUTURE
  772. [230] => PRIOR_YR_SALES_BF
  773. [231] => PRIOR_YR_SALES_MTH1
  774. [232] => PRIOR_YR_SALES_MTH2
  775. [233] => PRIOR_YR_SALES_MTH3
  776. [234] => PRIOR_YR_SALES_MTH4
  777. [235] => PRIOR_YR_SALES_MTH5
  778. [236] => PRIOR_YR_SALES_MTH6
  779. [237] => PRIOR_YR_SALES_MTH7
  780. [238] => PRIOR_YR_SALES_MTH8
  781. [239] => PRIOR_YR_SALES_MTH9
  782. [240] => PRIOR_YR_SALES_MTH10
  783. [241] => PRIOR_YR_SALES_MTH11
  784. [242] => PRIOR_YR_SALES_MTH12
  785. [243] => PRIOR_YR_SALES_FUTURE
  786. [244] => PRIOR_YR_COST_BF
  787. [245] => PRIOR_YR_COST_MTH1
  788. [246] => PRIOR_YR_COST_MTH2
  789. [247] => PRIOR_YR_COST_MTH3
  790. [248] => PRIOR_YR_COST_MTH4
  791. [249] => PRIOR_YR_COST_MTH5
  792. [250] => PRIOR_YR_COST_MTH6
  793. [251] => PRIOR_YR_COST_MTH7
  794. [252] => PRIOR_YR_COST_MTH8
  795. [253] => PRIOR_YR_COST_MTH9
  796. [254] => PRIOR_YR_COST_MTH10
  797. [255] => PRIOR_YR_COST_MTH11
  798. [256] => PRIOR_YR_COST_MTH12
  799. [257] => PRIOR_YR_COST_FUTURE
  800. [258] => DISC_A_LEVEL_1_QTY
  801. [259] => DISC_A_LEVEL_2_QTY
  802. [260] => DISC_A_LEVEL_3_QTY
  803. [261] => DISC_A_LEVEL_4_QTY
  804. [262] => DISC_A_LEVEL_5_QTY
  805. [263] => DISC_A_LEVEL_6_QTY
  806. [264] => DISC_A_LEVEL_7_QTY
  807. [265] => DISC_A_LEVEL_8_QTY
  808. [266] => DISC_A_LEVEL_9_QTY
  809. [267] => DISC_A_LEVEL_10_QTY
  810. [268] => DISC_A_LEVEL_1_RATE
  811. [269] => DISC_A_LEVEL_2_RATE
  812. [270] => DISC_A_LEVEL_3_RATE
  813. [271] => DISC_A_LEVEL_4_RATE
  814. [272] => DISC_A_LEVEL_5_RATE
  815. [273] => DISC_A_LEVEL_6_RATE
  816. [274] => DISC_A_LEVEL_7_RATE
  817. [275] => DISC_A_LEVEL_8_RATE
  818. [276] => DISC_A_LEVEL_9_RATE
  819. [277] => DISC_A_LEVEL_10_RATE
  820. [278] => DISC_B_LEVEL_1_QTY
  821. [279] => DISC_B_LEVEL_2_QTY
  822. [280] => DISC_B_LEVEL_3_QTY
  823. [281] => DISC_B_LEVEL_4_QTY
  824. [282] => DISC_B_LEVEL_5_QTY
  825. [283] => DISC_B_LEVEL_6_QTY
  826. [284] => DISC_B_LEVEL_7_QTY
  827. [285] => DISC_B_LEVEL_8_QTY
  828. [286] => DISC_B_LEVEL_9_QTY
  829. [287] => DISC_B_LEVEL_10_QTY
  830. [288] => DISC_B_LEVEL_1_RATE
  831. [289] => DISC_B_LEVEL_2_RATE
  832. [290] => DISC_B_LEVEL_3_RATE
  833. [291] => DISC_B_LEVEL_4_RATE
  834. [292] => DISC_B_LEVEL_5_RATE
  835. [293] => DISC_B_LEVEL_6_RATE
  836. [294] => DISC_B_LEVEL_7_RATE
  837. [295] => DISC_B_LEVEL_8_RATE
  838. [296] => DISC_B_LEVEL_9_RATE
  839. [297] => DISC_B_LEVEL_10_RATE
  840. [298] => DISC_C_LEVEL_1_QTY
  841. [299] => DISC_C_LEVEL_2_QTY
  842. [300] => DISC_C_LEVEL_3_QTY
  843. [301] => DISC_C_LEVEL_4_QTY
  844. [302] => DISC_C_LEVEL_5_QTY
  845. [303] => DISC_C_LEVEL_6_QTY
  846. [304] => DISC_C_LEVEL_7_QTY
  847. [305] => DISC_C_LEVEL_8_QTY
  848. [306] => DISC_C_LEVEL_9_QTY
  849. [307] => DISC_C_LEVEL_10_QTY
  850. [308] => DISC_C_LEVEL_1_RATE
  851. [309] => DISC_C_LEVEL_2_RATE
  852. [310] => DISC_C_LEVEL_3_RATE
  853. [311] => DISC_C_LEVEL_4_RATE
  854. [312] => DISC_C_LEVEL_5_RATE
  855. [313] => DISC_C_LEVEL_6_RATE
  856. [314] => DISC_C_LEVEL_7_RATE
  857. [315] => DISC_C_LEVEL_8_RATE
  858. [316] => DISC_C_LEVEL_9_RATE
  859. [317] => DISC_C_LEVEL_10_RATE
  860. [318] => DISC_D_LEVEL_1_QTY
  861. [319] => DISC_D_LEVEL_2_QTY
  862. [320] => DISC_D_LEVEL_3_QTY
  863. [321] => DISC_D_LEVEL_4_QTY
  864. [322] => DISC_D_LEVEL_5_QTY
  865. [323] => DISC_D_LEVEL_6_QTY
  866. [324] => DISC_D_LEVEL_7_QTY
  867. [325] => DISC_D_LEVEL_8_QTY
  868. [326] => DISC_D_LEVEL_9_QTY
  869. [327] => DISC_D_LEVEL_10_QTY
  870. [328] => DISC_D_LEVEL_1_RATE
  871. [329] => DISC_D_LEVEL_2_RATE
  872. [330] => DISC_D_LEVEL_3_RATE
  873. [331] => DISC_D_LEVEL_4_RATE
  874. [332] => DISC_D_LEVEL_5_RATE
  875. [333] => DISC_D_LEVEL_6_RATE
  876. [334] => DISC_D_LEVEL_7_RATE
  877. [335] => DISC_D_LEVEL_8_RATE
  878. [336] => DISC_D_LEVEL_9_RATE
  879. [337] => DISC_D_LEVEL_10_RATE
  880. [338] => DISC_E_LEVEL_1_QTY
  881. [339] => DISC_E_LEVEL_2_QTY
  882. [340] => DISC_E_LEVEL_3_QTY
  883. [341] => DISC_E_LEVEL_4_QTY
  884. [342] => DISC_E_LEVEL_5_QTY
  885. [343] => DISC_E_LEVEL_6_QTY
  886. [344] => DISC_E_LEVEL_7_QTY
  887. [345] => DISC_E_LEVEL_8_QTY
  888. [346] => DISC_E_LEVEL_9_QTY
  889. [347] => DISC_E_LEVEL_10_QTY
  890. [348] => DISC_E_LEVEL_1_RATE
  891. [349] => DISC_E_LEVEL_2_RATE
  892. [350] => DISC_E_LEVEL_3_RATE
  893. [351] => DISC_E_LEVEL_4_RATE
  894. [352] => DISC_E_LEVEL_5_RATE
  895. [353] => DISC_E_LEVEL_6_RATE
  896. [354] => DISC_E_LEVEL_7_RATE
  897. [355] => DISC_E_LEVEL_8_RATE
  898. [356] => DISC_E_LEVEL_9_RATE
  899. [357] => DISC_E_LEVEL_10_RATE
  900. [358] => PURCHASE_NOMINAL_CODE
  901. [359] => RECORD_CREATE_DATE
  902. [360] => RECORD_MODIFY_DATE
  903. [361] => RECORD_DELETED
  904. )
  905.  
  906. [STOCK_TRAN] => Array
  907. (
  908. [0] => TRAN_NUMBER
  909. [1] => STOCK_CODE
  910. [2] => TYPE
  911. [3] => DATE
  912. [4] => REFERENCE
  913. [5] => REFERENCE_NUMERIC
  914. [6] => DETAILS
  915. [7] => QUANTITY
  916. [8] => COST_PRICE
  917. [9] => SALES_PRICE
  918. [10] => QTY_USED
  919. [11] => ISP_REFERENCE
  920. [12] => RECORD_CREATE_DATE
  921. [13] => RECORD_MODIFY_DATE
  922. [14] => RECORD_DELETED
  923. )
  924.  
  925. [STOCK_CAT] => Array
  926. (
  927. [0] => NUMBER
  928. [1] => NAME
  929. )
  930.  
  931. [STOCK_COMP] => Array
  932. (
  933. [0] => ASSEMBLY_CODE
  934. [1] => COMPONENT_CODE
  935. [2] => COMPONENT_CODE_INDENT
  936. [3] => COMPONENT_QTY
  937. [4] => COMPONENT_LEVEL
  938. [5] => RECORD_CREATE_DATE
  939. [6] => RECORD_MODIFY_DATE
  940. [7] => RECORD_DELETED
  941. )
  942.  
  943. [INVOICE] => Array
  944. (
  945. )
  946.  
  947. [SALES_ORDER] => Array
  948. (
  949. )
  950.  
  951. [PURCHASE_ORDER] => Array
  952. (
  953. )
  954.  
  955. [RECURRING] => Array
  956. (
  957. [0] => UNIQUE_ID
  958. [1] => TYPE
  959. [2] => NOMINAL_CODE
  960. [3] => BANK_CODE
  961. [4] => REFERENCE
  962. [5] => DETAILS
  963. [6] => SUSPEND_POSTING
  964. [7] => NET_AMOUNT
  965. [8] => TAX_AMOUNT
  966. [9] => DATE_LAST_POSTING
  967. [10] => DAY_OF_POSTING
  968. [11] => DEPT_NUMBER
  969. [12] => DEPT_NAME
  970. [13] => REQUIRED_POSTINGS
  971. [14] => POSTINGS_MADE
  972. [15] => POSTED_NET
  973. [16] => POSTED_TAX
  974. [17] => RECORD_CREATE_DATE
  975. [18] => RECORD_MODIFY_DATE
  976. [19] => RECORD_DELETED
  977. )
  978.  
  979. [FIXED_ASSET] => Array
  980. (
  981. )
  982.  
  983. [FIXED_ASSET_CAT] => Array
  984. (
  985. [0] => NUMBER
  986. [1] => NAME
  987. )
  988.  
  989. [PREPAYMENT] => Array
  990. (
  991. [0] => NAME
  992. [1] => NOMINAL_CODE_1
  993. [2] => NOMINAL_CODE_2
  994. [3] => AMOUNT
  995. [4] => MONTHS_TO_POST
  996. [5] => MONTHS_POSTED
  997. [6] => DEPT_NUMBER
  998. [7] => DEPT_NAME
  999. [8] => RECORD_CREATE_DATE
  1000. [9] => RECORD_MODIFY_DATE
  1001. [10] => RECORD_DELETED
  1002. )
  1003.  
  1004. [ACCRUAL] => Array
  1005. (
  1006. [0] => NAME
  1007. [1] => NOMINAL_CODE_1
  1008. [2] => NOMINAL_CODE_2
  1009. [3] => AMOUNT
  1010. [4] => MONTHS_TO_POST
  1011. [5] => MONTHS_POSTED
  1012. [6] => DEPT_NUMBER
  1013. [7] => DEPT_NAME
  1014. [8] => RECORD_CREATE_DATE
  1015. [9] => RECORD_MODIFY_DATE
  1016. [10] => RECORD_DELETED
  1017. )
  1018.  
  1019. [INVOICE_ITEM] => Array
  1020. (
  1021. [0] => INVOICE_NUMBER
  1022. [1] => ITEM_NUMBER
  1023. [2] => JOB_NUMBER
  1024. [3] => SERVICE_FLAG
  1025. [4] => DESCRIPTION
  1026. [5] => TEXT
  1027. [6] => STOCK_CODE
  1028. [7] => COMMENT_1
  1029. [8] => COMMENT_2
  1030. [9] => UNIT_OF_SALE
  1031. [10] => QUANTITY
  1032. [11] => FOREIGN_UNIT_PRICE
  1033. [12] => FOREIGN_DISCOUNT_AMOUNT
  1034. [13] => UNIT_PRICE
  1035. [14] => DISCOUNT_AMOUNT
  1036. [15] => DISCOUNT_RATE
  1037. [16] => DELIVERY_DATE
  1038. [17] => NOMINAL_CODE
  1039. [18] => DEPT_NUMBER
  1040. [19] => DEPT_NAME
  1041. [20] => TAX_CODE_ID
  1042. [21] => TAX_CODE
  1043. [22] => ADD_DISC_RATE
  1044. [23] => TAX_RATE
  1045. [24] => FULL_NET_AMOUNT
  1046. [25] => NET_AMOUNT
  1047. [26] => TAX_AMOUNT
  1048. [27] => GROSS_AMOUNT
  1049. [28] => FOREIGN_FULL_NET_AMOUNT
  1050. [29] => FOREIGN_NET_AMOUNT
  1051. [30] => FOREIGN_TAX_AMOUNT
  1052. [31] => FOREIGN_GROSS_AMOUNT
  1053. [32] => EXT_ORDER_REF
  1054. [33] => EXT_ORDER_LINE_REF
  1055. [34] => PROJECT_ID
  1056. [35] => ITEMID
  1057. [36] => NEGOTIATION_DISC_NET
  1058. [37] => NEGOTIATION_DISC_NET_BASE
  1059. [38] => GENERATED_MESSAGE
  1060. [39] => EC_VAT_DESCRIPTION_ID
  1061. [40] => RECORD_CREATE_DATE
  1062. [41] => RECORD_MODIFY_DATE
  1063. [42] => RECORD_DELETED
  1064. )
  1065.  
  1066. [SOP_ITEM] => Array
  1067. (
  1068. [0] => ORDER_NUMBER
  1069. [1] => ITEM_NUMBER
  1070. [2] => JOB_NUMBER
  1071. [3] => SERVICE_FLAG
  1072. [4] => DESCRIPTION
  1073. [5] => TEXT
  1074. [6] => STOCK_CODE
  1075. [7] => COMMENT_1
  1076. [8] => COMMENT_2
  1077. [9] => UNIT_OF_SALE
  1078. [10] => QTY_ORDER
  1079. [11] => QTY_ALLOCATED
  1080. [12] => QTY_DELIVERED
  1081. [13] => QTY_DESPATCH
  1082. [14] => QTY_LAST_DESPATCH
  1083. [15] => FOREIGN_UNIT_PRICE
  1084. [16] => FOREIGN_DISCOUNT_AMOUNT
  1085. [17] => UNIT_PRICE
  1086. [18] => DISCOUNT_AMOUNT
  1087. [19] => DISCOUNT_RATE
  1088. [20] => DELIVERY_DATE
  1089. [21] => NOMINAL_CODE
  1090. [22] => DEPT_NUMBER
  1091. [23] => DEPT_NAME
  1092. [24] => TAX_CODE_ID
  1093. [25] => TAX_CODE
  1094. [26] => ADD_DISC_RATE
  1095. [27] => TAX_RATE
  1096. [28] => FULL_NET_AMOUNT
  1097. [29] => NET_AMOUNT
  1098. [30] => TAX_AMOUNT
  1099. [31] => GROSS_AMOUNT
  1100. [32] => FOREIGN_FULL_NET_AMOUNT
  1101. [33] => FOREIGN_NET_AMOUNT
  1102. [34] => FOREIGN_TAX_AMOUNT
  1103. [35] => FOREIGN_GROSS_AMOUNT
  1104. [36] => EXT_ORDER_REF
  1105. [37] => EXT_ORDER_LINE_REF
  1106. [38] => PROJECT_ID
  1107. [39] => THIS_RECORD
  1108. [40] => POP_ITEM_ID
  1109. [41] => DUE_DATE
  1110. [42] => ITEMID
  1111. [43] => NEGOTIATION_DISC_NET
  1112. [44] => NEGOTIATION_DISC_NET_BASE
  1113. [45] => GENERATED_MESSAGE
  1114. [46] => RECORD_CREATE_DATE
  1115. [47] => RECORD_MODIFY_DATE
  1116. [48] => RECORD_DELETED
  1117. )
  1118.  
  1119. [POP_ITEM] => Array
  1120. (
  1121. [0] => ORDER_NUMBER
  1122. [1] => ITEM_NUMBER
  1123. [2] => JOB_NUMBER
  1124. [3] => SERVICE_FLAG
  1125. [4] => DESCRIPTION
  1126. [5] => TEXT
  1127. [6] => STOCK_CODE
  1128. [7] => COMMENT_1
  1129. [8] => COMMENT_2
  1130. [9] => UNIT_OF_SALE
  1131. [10] => QTY_ORDER
  1132. [11] => QTY_ALLOCATED
  1133. [12] => QTY_DELIVERED
  1134. [13] => QTY_DESPATCH
  1135. [14] => QTY_LAST_DESPATCH
  1136. [15] => FOREIGN_UNIT_PRICE
  1137. [16] => FOREIGN_DISCOUNT_AMOUNT
  1138. [17] => UNIT_PRICE
  1139. [18] => DISCOUNT_AMOUNT
  1140. [19] => DISCOUNT_RATE
  1141. [20] => DELIVERY_DATE
  1142. [21] => NOMINAL_CODE
  1143. [22] => DEPT_NUMBER
  1144. [23] => DEPT_NAME
  1145. [24] => TAX_CODE_ID
  1146. [25] => TAX_CODE
  1147. [26] => ADD_DISC_RATE
  1148. [27] => TAX_RATE
  1149. [28] => FULL_NET_AMOUNT
  1150. [29] => NET_AMOUNT
  1151. [30] => TAX_AMOUNT
  1152. [31] => GROSS_AMOUNT
  1153. [32] => FOREIGN_FULL_NET_AMOUNT
  1154. [33] => FOREIGN_NET_AMOUNT
  1155. [34] => FOREIGN_TAX_AMOUNT
  1156. [35] => FOREIGN_GROSS_AMOUNT
  1157. [36] => THIS_RECORD
  1158. [37] => POP_ITEM_ID
  1159. [38] => QTY_ALLOCATED_TO_PROJECT
  1160. [39] => QTY_ISSUED_TO_PROJECT
  1161. [40] => DUE_DATE
  1162. [41] => QTY_COMMITTED_TO_PROJECT
  1163. [42] => PROJECT_REF
  1164. [43] => PROJECT_NAME
  1165. [44] => COST_CODE_REF
  1166. [45] => ITEMID
  1167. [46] => GENERATED_MESSAGE
  1168. [47] => QTY_INVOICED
  1169. [48] => RECORD_CREATE_DATE
  1170. [49] => RECORD_MODIFY_DATE
  1171. [50] => RECORD_DELETED
  1172. )
  1173.  
  1174. [SALES_DEL_ADDR] => Array
  1175. (
  1176. [0] => REFERENCE
  1177. [1] => ACCOUNT_REF
  1178. [2] => ADDRESS_REF
  1179. [3] => DESCRIPTION
  1180. [4] => NAME
  1181. [5] => ADDRESS_1
  1182. [6] => ADDRESS_2
  1183. [7] => ADDRESS_3
  1184. [8] => ADDRESS_4
  1185. [9] => ADDRESS_5
  1186. [10] => TELEPHONE
  1187. [11] => FAX
  1188. [12] => E_MAIL
  1189. [13] => CONTACT_NAME
  1190. [14] => TAX_CODE
  1191. [15] => COUNTRY_CODE
  1192. [16] => VAT_REG_NUMBER
  1193. [17] => TELEPHONE_2
  1194. [18] => ADDRESS_TYPE_NAME
  1195. [19] => ADDRESS_TYPE
  1196. [20] => CONTACT_ROLE
  1197. [21] => NOTES
  1198. [22] => RECORD_CREATE_DATE
  1199. [23] => RECORD_MODIFY_DATE
  1200. [24] => RECORD_DELETED
  1201. )
  1202.  
  1203. [PURCHASE_DEL_ADDR] => Array
  1204. (
  1205. [0] => REFERENCE
  1206. [1] => ACCOUNT_REF
  1207. [2] => ADDRESS_REF
  1208. [3] => DESCRIPTION
  1209. [4] => NAME
  1210. [5] => ADDRESS_1
  1211. [6] => ADDRESS_2
  1212. [7] => ADDRESS_3
  1213. [8] => ADDRESS_4
  1214. [9] => ADDRESS_5
  1215. [10] => TELEPHONE
  1216. [11] => FAX
  1217. [12] => E_MAIL
  1218. [13] => CONTACT_NAME
  1219. [14] => TAX_CODE
  1220. [15] => COUNTRY_CODE
  1221. [16] => VAT_REG_NUMBER
  1222. [17] => TELEPHONE_2
  1223. [18] => ADDRESS_TYPE_NAME
  1224. [19] => ADDRESS_TYPE
  1225. [20] => CONTACT_ROLE
  1226. [21] => NOTES
  1227. [22] => RECORD_CREATE_DATE
  1228. [23] => RECORD_MODIFY_DATE
  1229. [24] => RECORD_DELETED
  1230. )
  1231.  
  1232. [COMPANY_DEL_ADDR] => Array
  1233. (
  1234. [0] => REFERENCE
  1235. [1] => ADDRESS_REF
  1236. [2] => DESCRIPTION
  1237. [3] => NAME
  1238. [4] => ADDRESS_1
  1239. [5] => ADDRESS_2
  1240. [6] => ADDRESS_3
  1241. [7] => ADDRESS_4
  1242. [8] => ADDRESS_5
  1243. [9] => TELEPHONE
  1244. [10] => FAX
  1245. [11] => E_MAIL
  1246. [12] => CONTACT_NAME
  1247. [13] => TAX_CODE
  1248. [14] => COUNTRY_CODE
  1249. [15] => VAT_REG_NUMBER
  1250. [16] => TELEPHONE_2
  1251. [17] => ADDRESS_TYPE_NAME
  1252. [18] => ADDRESS_TYPE
  1253. [19] => CONTACT_ROLE
  1254. [20] => NOTES
  1255. [21] => RECORD_CREATE_DATE
  1256. [22] => RECORD_MODIFY_DATE
  1257. [23] => RECORD_DELETED
  1258. )
  1259.  
  1260. [PRICE] => Array
  1261. (
  1262. [0] => PRICE_ID
  1263. [1] => TYPE
  1264. [2] => PRICING_REF
  1265. [3] => STOCK_CODE
  1266. [4] => CALC_METHOD
  1267. [5] => CALC_VALUE
  1268. [6] => STORED_PRICE
  1269. [7] => ROUNDER_METHOD
  1270. [8] => ROUNDER_DIRECTION
  1271. [9] => ROUNDER_MULTIPLE_OF
  1272. [10] => ROUNDER_ADJUSTMENT
  1273. [11] => RECORD_CREATE_DATE
  1274. [12] => RECORD_MODIFY_DATE
  1275. [13] => RECORD_DELETED
  1276. )
  1277.  
  1278. [PRICE_LIST] => Array
  1279. (
  1280. [0] => TYPE
  1281. [1] => PRICING_REF
  1282. [2] => NAME
  1283. [3] => CURRENCY
  1284. [4] => HAS_STATIC_PRICES
  1285. [5] => RECORD_CREATE_DATE
  1286. [6] => RECORD_MODIFY_DATE
  1287. [7] => RECORD_DELETED
  1288. )
  1289.  
  1290. [GRN_ITEM] => Array
  1291. (
  1292. [0] => GRN_NUMBER
  1293. [1] => ITEM_NUMBER
  1294. [2] => ORDER_NUMBER
  1295. [3] => ORDER_ITEM
  1296. [4] => ACCOUNT_REF
  1297. [5] => SUPPLIER_GRN_NUMBER
  1298. [6] => STOCK_CODE
  1299. [7] => DESCRIPTION
  1300. [8] => DATE
  1301. [9] => QTY_RECEIVED
  1302. [10] => QTY_ON_ORDER
  1303. [11] => RECORD_CREATE_DATE
  1304. [12] => RECORD_MODIFY_DATE
  1305. [13] => RECORD_DELETED
  1306. )
  1307.  
  1308. [GDN_ITEM] => Array
  1309. (
  1310. [0] => UNIQUE_ID
  1311. [1] => GDN_NUMBER
  1312. [2] => ITEM_NUMBER
  1313. [3] => ORDER_NUMBER
  1314. [4] => ORDER_ITEM
  1315. [5] => ACCOUNT_REF
  1316. [6] => CUSTOMER_GDN_NUMBER
  1317. [7] => STOCK_CODE
  1318. [8] => DESCRIPTION
  1319. [9] => DATE
  1320. [10] => QTY_DESPATCHED
  1321. [11] => QTY_ON_ORDER
  1322. [12] => PRINTED_FLAG
  1323. [13] => RECORD_CREATE_DATE
  1324. [14] => RECORD_MODIFY_DATE
  1325. [15] => RECORD_DELETED
  1326. )
  1327.  
  1328. [PROJECT] => Array
  1329. (
  1330. [0] => REFERENCE
  1331. [1] => NAME
  1332. [2] => DESCRIPTION
  1333. [3] => STATUS_ID
  1334. [4] => START_DATE
  1335. [5] => END_DATE
  1336. [6] => CUSTOMER_REF
  1337. [7] => ORDER_NUMBER
  1338. [8] => ANALYSIS_1
  1339. [9] => ANALYSIS_2
  1340. [10] => ANALYSIS_3
  1341. [11] => ADDRESS_1
  1342. [12] => ADDRESS_2
  1343. [13] => ADDRESS_3
  1344. [14] => ADDRESS_4
  1345. [15] => ADDRESS_5
  1346. [16] => CONTACT_NAME
  1347. [17] => TELEPHONE
  1348. [18] => FAX
  1349. [19] => E_MAIL
  1350. [20] => COUNTRY_CODE
  1351. [21] => TOTAL_BILLED
  1352. [22] => BILLED_NET
  1353. [23] => BILLED_TAX
  1354. [24] => OUTSTANDING_TO_BILL
  1355. [25] => PRICE_QUOTED
  1356. [26] => PROFIT_TO_DATE
  1357. [27] => TOTAL_COST
  1358. [28] => TOTAL_BUDGET
  1359. [29] => VARIANCE
  1360. [30] => LAST_BILLED_DATE
  1361. [31] => LAST_COST_DATE
  1362. [32] => PROJECT_ID
  1363. [33] => PARENT_PROJECT_NO
  1364. [34] => CHILD_POSITION
  1365. [35] => COMMITTED_COST
  1366. [36] => RECORD_CREATE_DATE
  1367. [37] => RECORD_MODIFY_DATE
  1368. [38] => RECORD_DELETED
  1369. )
  1370.  
  1371. [PROJECT_TRAN] => Array
  1372. (
  1373. [0] => PROJECT_TRAN_ID
  1374. [1] => AUDIT_TRAIL_ID
  1375. [2] => STOCK_TRAIL_ID
  1376. [3] => PROJECT_ID
  1377. [4] => COST_CODE_ID
  1378. [5] => REVENUE_CODE_ID
  1379. [6] => POP_ITEM_ID
  1380. [7] => STOCK_ALLOCATION_ID
  1381. [8] => DATE
  1382. [9] => RECORD_CREATE_DATE
  1383. [10] => RECORD_MODIFY_DATE
  1384. [11] => RECORD_DELETED
  1385. )
  1386.  
  1387. [PROJECT_ONLY_TRAN] => Array
  1388. (
  1389. [0] => PROJECT_TRAN_ID
  1390. [1] => TYPE
  1391. [2] => ACCOUNT_REF
  1392. [3] => NOMINAL_CODE
  1393. [4] => REFERENCE
  1394. [5] => EXTRA_REF
  1395. [6] => DETAILS
  1396. [7] => RESOURCE_ID
  1397. [8] => QUANTITY
  1398. [9] => RATE
  1399. [10] => TAX_AMOUNT
  1400. [11] => TAX_CODE
  1401. [12] => DEPT_NUMBER
  1402. [13] => DEPT_NAME
  1403. [14] => RECORD_CREATE_DATE
  1404. [15] => RECORD_MODIFY_DATE
  1405. [16] => RECORD_DELETED
  1406. )
  1407.  
  1408. [PROJECT_STATUS] => Array
  1409. (
  1410. )
  1411.  
  1412. [PROJECT_RESOURCE] => Array
  1413. (
  1414. [0] => RESOURCE_ID
  1415. [1] => REFERENCE
  1416. [2] => NAME
  1417. [3] => UNIT
  1418. [4] => DEFAULT_COST_CODE_ID
  1419. [5] => RATE
  1420. [6] => RECORD_CREATE_DATE
  1421. [7] => RECORD_MODIFY_DATE
  1422. [8] => RECORD_DELETED
  1423. )
  1424.  
  1425. [PROJECT_RESOURCE_TYPE] => Array
  1426. (
  1427. [0] => TYPE_ID
  1428. [1] => NAME
  1429. [2] => RECORD_CREATE_DATE
  1430. [3] => RECORD_MODIFY_DATE
  1431. [4] => RECORD_DELETED
  1432. )
  1433.  
  1434. [PROJECT_COST_CODE] => Array
  1435. (
  1436. [0] => COST_CODE_ID
  1437. [1] => REFERENCE
  1438. [2] => DESCRIPTION
  1439. [3] => COST_TYPE_ID
  1440. [4] => RECORD_CREATE_DATE
  1441. [5] => RECORD_MODIFY_DATE
  1442. [6] => RECORD_DELETED
  1443. )
  1444.  
  1445. [PROJECT_REVENUE_CODE] => Array
  1446. (
  1447. [0] => REVENUE_CODE_ID
  1448. [1] => REFERENCE
  1449. [2] => DESCRIPTION
  1450. [3] => RECORD_CREATE_DATE
  1451. [4] => RECORD_MODIFY_DATE
  1452. [5] => RECORD_DELETED
  1453. )
  1454.  
  1455. [PROJECT_COST_TYPE] => Array
  1456. (
  1457. [0] => COST_TYPE_ID
  1458. [1] => NAME
  1459. [2] => IS_DEFAULT
  1460. [3] => RECORD_CREATE_DATE
  1461. [4] => RECORD_MODIFY_DATE
  1462. [5] => RECORD_DELETED
  1463. )
  1464.  
  1465. [PROJECT_RELATIONSHIP] => Array
  1466. (
  1467. [0] => ANCESTOR_ID
  1468. [1] => DESCENDENT_ID
  1469. [2] => GENERATION_GAP
  1470. [3] => RECORD_CREATE_DATE
  1471. [4] => RECORD_MODIFY_DATE
  1472. [5] => RECORD_DELETED
  1473. )
  1474.  
  1475. [PROJECT_BUDGET] => Array
  1476. (
  1477. [0] => PROJECT_ID
  1478. [1] => COST_CODE_ID
  1479. [2] => AMOUNT
  1480. [3] => RECORD_CREATE_DATE
  1481. [4] => RECORD_MODIFY_DATE
  1482. [5] => RECORD_DELETED
  1483. )
  1484.  
  1485. [CLEAR_AUDIT_TRAIL_EVENT] => Array
  1486. (
  1487. [0] => CATE_ID
  1488. [1] => DATE
  1489. [2] => USER_NAME
  1490. [3] => LOCATION_TYPE
  1491. [4] => LOCATION
  1492. [5] => RECORD_CREATE_DATE
  1493. [6] => RECORD_MODIFY_DATE
  1494. [7] => RECORD_DELETED
  1495. )
  1496.  
  1497. [CLEARED_TRAN_RANGE] => Array
  1498. (
  1499. [0] => CATE_ID
  1500. [1] => START_TRAN_NUMBER
  1501. [2] => END_TRAN_NUMBER
  1502. [3] => RECORD_CREATE_DATE
  1503. [4] => RECORD_MODIFY_DATE
  1504. [5] => RECORD_DELETED
  1505. )
  1506.  
  1507. [INTRASTAT] => Array
  1508. (
  1509. [0] => ORDER_NUMBER
  1510. [1] => ACCOUNT_REF
  1511. [2] => STOCK_CODE
  1512. [3] => DESCRIPTION
  1513. [4] => DATE
  1514. [5] => NOTC
  1515. [6] => COUNTRY_CODE
  1516. [7] => COMMODITY_CODE
  1517. [8] => DELIVERY_STATUS
  1518. [9] => DELIVERY_TERMS
  1519. [10] => QUANTITY
  1520. [11] => QTY_ORDERED
  1521. [12] => QTY_DELIVERED
  1522. [13] => QTY_TO_CONFIRM
  1523. [14] => UNIT
  1524. [15] => NET_MASS
  1525. [16] => GOODS_VALUE
  1526. [17] => COUNTRY_OF_ORIGIN
  1527. [18] => TRANSPORT
  1528. [19] => RECORD_CREATE_DATE
  1529. [20] => RECORD_MODIFY_DATE
  1530. [21] => RECORD_DELETED
  1531. )
  1532.  
  1533. [COUNTRY_CODE] => Array
  1534. (
  1535. [0] => CODE
  1536. [1] => NAME
  1537. [2] => EU_MEMBER
  1538. [3] => RECORD_CREATE_DATE
  1539. [4] => RECORD_MODIFY_DATE
  1540. [5] => RECORD_DELETED
  1541. )
  1542.  
  1543. [DISPUTE_REASON] => Array
  1544. (
  1545. [0] => CODE
  1546. [1] => DETAILS
  1547. )
  1548.  
  1549. [BANK_STATEMENT] => Array
  1550. (
  1551. [0] => ACCOUNT_REF
  1552. [1] => STATEMENT_REF
  1553. [2] => CLOSING_BALANCE
  1554. [3] => OPENING_BALANCE
  1555. [4] => AMOUNT_IN
  1556. [5] => AMOUNT_OUT
  1557. [6] => INTEREST
  1558. [7] => INTEREST_ID
  1559. [8] => INTEREST_NOM_CODE
  1560. [9] => CHARGES
  1561. [10] => CHARGES_ID
  1562. [11] => CHARGES_NOM_CODE
  1563. [12] => STATEMENT_DATE
  1564. [13] => INTEREST_DATE
  1565. [14] => CHARGES_DATE
  1566. [15] => RECONCILIATION_DATE
  1567. [16] => RECORD_CREATE_DATE
  1568. [17] => RECORD_MODIFY_DATE
  1569. [18] => RECORD_DELETED
  1570. )
  1571.  
  1572. [BANK_STATEMENT_LINE] => Array
  1573. (
  1574. [0] => ACCOUNT_REF
  1575. [1] => ITEM_NUMBER
  1576. [2] => TRAN_NUMBER
  1577. [3] => AMOUNT
  1578. [4] => RECORD_CREATE_DATE
  1579. [5] => RECORD_MODIFY_DATE
  1580. [6] => RECORD_DELETED
  1581. )
  1582.  
  1583. [FUND] => Array
  1584. (
  1585. [0] => FUND_ID
  1586. [1] => FUND_TYPE_ID
  1587. [2] => DESCRIPTION
  1588. [3] => CONTACT_NAME
  1589. [4] => HELD_BY
  1590. [5] => ACCOUNT_REF
  1591. [6] => BALANCE
  1592. [7] => OPENING_BALANCE
  1593. [8] => RECORD_CREATE_DATE
  1594. [9] => RECORD_MODIFY_DATE
  1595. [10] => RECORD_DELETED
  1596. )
  1597.  
  1598. [FUND_TYPE] => Array
  1599. (
  1600. [0] => FUND_TYPE_ID
  1601. [1] => DESCRIPTION
  1602. [2] => RECORD_CREATE_DATE
  1603. [3] => RECORD_MODIFY_DATE
  1604. [4] => RECORD_DELETED
  1605. )
  1606.  
  1607. [SOFA_CATEGORY] => Array
  1608. (
  1609. [0] => SOFA_ID
  1610. [1] => DESCRIPTION
  1611. [2] => RECORD_CREATE_DATE
  1612. [3] => RECORD_MODIFY_DATE
  1613. [4] => RECORD_DELETED
  1614. )
  1615.  
  1616. [STOCK_ALLOCATION] => Array
  1617. (
  1618. [0] => STOCK_ALLOCATION_ID
  1619. [1] => PROJECT_ID
  1620. [2] => COST_CODE_ID
  1621. [3] => STOCK_CODE
  1622. [4] => DETAILS
  1623. [5] => REFERENCE
  1624. [6] => DATE
  1625. [7] => QTY_ALLOCATED
  1626. [8] => QTY_ISSUED
  1627. [9] => COST_PRICE
  1628. [10] => RECORD_CREATE_DATE
  1629. [11] => RECORD_MODIFY_DATE
  1630. [12] => RECORD_DELETED
  1631. )
  1632.  
  1633. [CREDIT_BUREAU] => Array
  1634. (
  1635. )
  1636.  
  1637. [CHART_LIST] => Array
  1638. (
  1639. )
  1640.  
  1641. [CAT_TITLE] => Array
  1642. (
  1643. )
  1644.  
  1645. [CATEGORY] => Array
  1646. (
  1647. )
  1648.  
  1649. [TAX_CODE] => Array
  1650. (
  1651. [0] => TAX_CODE
  1652. [1] => TAX_CODE_ID
  1653. [2] => DESCRIPTION
  1654. [3] => TAX_RATE
  1655. [4] => VAT_INCLUDE
  1656. [5] => EURO_SALES
  1657. [6] => EURO_PURCHASE
  1658. [7] => RELATED_CODE
  1659. [8] => RELATED_RATE
  1660. [9] => IS_REVERSECHARGE
  1661. )
  1662.  
  1663. [UPDATE_LEDGER] => Array
  1664. (
  1665. [0] => INVOICE_NUMBER
  1666. [1] => TRAN_NUMBER
  1667. [2] => TYPE
  1668. [3] => DATE
  1669. [4] => ACCOUNT_REF
  1670. [5] => NOMINAL_CODE
  1671. [6] => DESCRIPTION
  1672. [7] => ERROR
  1673. [8] => STOCK_CODE
  1674. [9] => QUANTITY
  1675. [10] => NET_AMOUNT
  1676. [11] => TAX_AMOUNT
  1677. [12] => GROSS_AMOUNT
  1678. [13] => CARR_GROSS
  1679. )
  1680.  
  1681. [CURRENCY] => Array
  1682. (
  1683. [0] => NUMBER
  1684. [1] => CODE
  1685. [2] => SYMBOL
  1686. [3] => NAME
  1687. [4] => EMU_MEMBER
  1688. [5] => BASE_CURRENCY
  1689. [6] => RATE
  1690. [7] => MAJOR_CURRENCY_UNIT
  1691. [8] => MINOR_CURRENCY_UNIT
  1692. [9] => RECORD_CREATE_DATE
  1693. [10] => RECORD_MODIFY_DATE
  1694. [11] => RECORD_DELETED
  1695. )
  1696.  
  1697. [VAT_SUMMARY] => Array
  1698. (
  1699. [0] => VAT_BOX
  1700. [1] => VAT_BOX_NAME
  1701. [2] => TAX_CODE
  1702. [3] => AMOUNT_INVOICE
  1703. [4] => AMOUNT_CREDIT
  1704. [5] => AMOUNT_BANK
  1705. [6] => AMOUNT_JOURNAL
  1706. [7] => AMOUNT_REFUND
  1707. [8] => AMOUNT_DISCOUNT
  1708. [9] => HEADING_INVOICE
  1709. [10] => HEADING_CREDIT
  1710. [11] => HEADING_BANK
  1711. [12] => HEADING_JOURNAL
  1712. [13] => HEADING_REFUND
  1713. )
  1714.  
  1715. [VAT_RETURN] => Array
  1716. (
  1717. [0] => VAT_BOX
  1718. [1] => VAT_BOX_NAME
  1719. [2] => COUNT_ALL
  1720. [3] => COUNT_EARLIER
  1721. [4] => COUNT_RECON
  1722. [5] => COUNT_UNRECON
  1723. [6] => AMOUNT
  1724. )
  1725.  
  1726. [RTD_SUMMARY] => Array
  1727. (
  1728. [0] => VAT_BOX
  1729. [1] => VAT_BOX_NAME
  1730. [2] => TAX_CODE
  1731. [3] => AMOUNT_INVOICE
  1732. [4] => AMOUNT_CREDIT
  1733. [5] => AMOUNT_BANK
  1734. [6] => AMOUNT_JOURNAL
  1735. [7] => AMOUNT_REFUND
  1736. [8] => AMOUNT_DISCOUNT
  1737. [9] => HEADING_INVOICE
  1738. [10] => HEADING_CREDIT
  1739. [11] => HEADING_BANK
  1740. [12] => HEADING_JOURNAL
  1741. [13] => HEADING_REFUND
  1742. )
  1743.  
  1744. [FINANCIAL_BUDGET] => Array
  1745. (
  1746. [0] => ACCOUNT_REF
  1747. [1] => ANALYSIS_ID
  1748. [2] => YEAR
  1749. [3] => BUDGET
  1750. [4] => PERIOD
  1751. [5] => ACTUAL
  1752. [6] => CLEARED_ACTUAL
  1753. [7] => CATEGORY
  1754. [8] => RECORD_CREATE_DATE
  1755. [9] => RECORD_MODIFY_DATE
  1756. [10] => RECORD_DELETED
  1757. )
  1758.  
  1759. [CIS_RETURN] => Array
  1760. (
  1761. [0] => RETURN_ID
  1762. [1] => CONTRACTOR_UTR
  1763. [2] => ACCOUNTS_OFFICE_REFERENCE_NUMBER
  1764. [3] => MONTH_ENDING
  1765. [4] => EMPLOYMENT_STATUS_DECLARATION
  1766. [5] => SUBCONTRACTOR_VERIFICATION_DECLARATION
  1767. [6] => INACTIVITY_INDICATOR
  1768. [7] => RECORD_CREATE_DATE
  1769. [8] => RECORD_MODIFY_DATE
  1770. [9] => RECORD_DELETED
  1771. )
  1772.  
  1773. [CIS_RETURNED_TRANSACTION] => Array
  1774. (
  1775. [0] => TRANSACTION_ID
  1776. [1] => RETURN_ID
  1777. [2] => RECORD_CREATE_DATE
  1778. [3] => RECORD_MODIFY_DATE
  1779. [4] => RECORD_DELETED
  1780. )
  1781.  
  1782. [CIS_SETTINGS] => Array
  1783. (
  1784. [0] => IS_CONTRACTOR
  1785. [1] => IS_SUBCONTRACTOR
  1786. [2] => UNIQUE_TAX_REFERENCE
  1787. [3] => ACCOUNTS_OFFICE_REFERENCE_NUMBER
  1788. [4] => IS_INACTIVE
  1789. [5] => NEXT_PERIOD_END
  1790. [6] => STANDARD_RATE
  1791. [7] => HIGHER_RATE
  1792. [8] => CONTROL_NOMINAL
  1793. [9] => LABOUR_NOMINAL
  1794. [10] => MATERIALS_NOMINAL
  1795. [11] => OTHER_TAXABLE_NOMINAL
  1796. [12] => OTHER_NONTAXABLE_NOMINAL
  1797. [13] => TAX_LIABILITY_NOMINAL
  1798. [14] => IS_ENABLED
  1799. [15] => RECORD_CREATE_DATE
  1800. [16] => RECORD_MODIFY_DATE
  1801. [17] => RECORD_DELETED
  1802. )
  1803.  
  1804. [CIS_SUBCONTRACTOR] => Array
  1805. (
  1806. [0] => SUPPLIER_REFN
  1807. [1] => COMPANY_TYPE
  1808. [2] => COMPANY_TYPE_CODE
  1809. [3] => UNIQUE_TAX_REFERENCE
  1810. [4] => TRADING_NAME
  1811. [5] => LEGAL_NAME
  1812. [6] => USE_LEGAL_NAME
  1813. [7] => FIRST_NAME
  1814. [8] => MIDDLE_NAME
  1815. [9] => LAST_NAME
  1816. [10] => PARTNERSHIP_UNIQUE_TAX_REFERENCE
  1817. [11] => PARTNERSHIP_NAME
  1818. [12] => COMPANY_REGISTRATION_NAME
  1819. [13] => NATIONAL_INSURANCE_NUMBER
  1820. [14] => VERIFICATION_REFERENCE_NUMBER
  1821. [15] => VERIFICATION_STATUS
  1822. [16] => VERIFICATION_STATUS_CODE
  1823. [17] => LAST_VERIFIED
  1824. [18] => PAYMENT_FREQUENCY
  1825. [19] => PAYMENT_FREQUENCY_CODE
  1826. [20] => EMAIL_STATEMENTS
  1827. [21] => PAY_THIRD_PARTY
  1828. [22] => THIRD_PARTY
  1829. [23] => RECORD_CREATE_DATE
  1830. [24] => RECORD_MODIFY_DATE
  1831. [25] => RECORD_DELETED
  1832. )
  1833.  
  1834. [CIS_SUBCONTRACTOR_LEGACY] => Array
  1835. (
  1836. [0] => SUPPLER_REFN
  1837. [1] => CIS_TYPE
  1838. [2] => CIS_TYPE_CODE
  1839. [3] => CIS_NUMBER
  1840. [4] => CARD_TYPE
  1841. [5] => CARD_TYPE_CODE
  1842. [6] => VALID_FROM
  1843. [7] => VALID_TO
  1844. [8] => RECORD_CREATE_DATE
  1845. [9] => RECORD_MODIFY_DATE
  1846. [10] => RECORD_DELETED
  1847. )
  1848.  
  1849. [CIS_SUBCONTRACTOR_RETURN] => Array
  1850. (
  1851. [0] => RETURN_ID
  1852. [1] => SUPPLIER_REFN
  1853. [2] => UNIQUE_TAX_REFERENCE
  1854. [3] => TRADING_NAME
  1855. [4] => FIRST_NAME
  1856. [5] => MIDDLE_NAME
  1857. [6] => LAST_NAME
  1858. [7] => COMPANY_REGISTRATION_NUMBER
  1859. [8] => NATIONAL_INSURANCE_NUMBER
  1860. [9] => VERIFICATION_REFERENCE_NUMBER
  1861. [10] => TOTAL_PAYMENTS_MADE
  1862. [11] => COST_OF_MATERIALS
  1863. [12] => AMOUNT_DEDUCTED
  1864. [13] => UNMATCHED_RATE
  1865. [14] => RECORD_CREATE_DATE
  1866. [15] => RECORD_MODIFY_DATE
  1867. [16] => RECORD_DELETED
  1868. )
  1869.  
  1870. [CIS_SUBCONTRACTOR_TAX_HISTORY] => Array
  1871. (
  1872. [0] => SUPPLIER_REFN
  1873. [1] => TAX_TREATMENT
  1874. [2] => TAX_TREATMENT_CODE
  1875. [3] => START_DATE
  1876. [4] => RECORD_CREATE_DATE
  1877. [5] => RECORD_MODIFY_DATE
  1878. [6] => RECORD_DELETED
  1879. )
  1880.  
  1881. [ESUBMISSION_SETTINGS] => Array
  1882. (
  1883. [0] => USER_ID
  1884. [1] => EMPLOYER_REFERENCE
  1885. [2] => IS_AGENT
  1886. [3] => SUB_FAMILY
  1887. [4] => RECORD_CREATE_DATE
  1888. [5] => RECORD_MODIFY_DATE
  1889. [6] => RECORD_DELETED
  1890. )
  1891.  
  1892. [PROTX_PAYMENT] => Array
  1893. (
  1894. [0] => VENDOR_TX_CODE
  1895. [1] => VPS_TX_ID
  1896. [2] => TX_AUTH_NUMBER
  1897. [3] => AMOUNT
  1898. [4] => ACCOUNT
  1899. [5] => PAYMENT_DATE
  1900. [6] => PAYMENT_TYPE
  1901. [7] => TRANSACTION_TYPE
  1902. [8] => RECORD_CREATE_DATE
  1903. [9] => RECORD_MODIFY_DATE
  1904. [10] => RECORD_DELETED
  1905. )
  1906.  
  1907. [ECSALES_HEADER] => Array
  1908. (
  1909. [0] => DATE_FROM
  1910. [1] => DATE_TO
  1911. [2] => VAT_NUMBER
  1912. [3] => TAX_BRANCH_ID
  1913. [4] => QUARTER
  1914. [5] => NAME
  1915. [6] => ADDRESS_1
  1916. [7] => ADDRESS_2
  1917. [8] => ADDRESS_3
  1918. [9] => ADDRESS_4
  1919. [10] => ADDRESS_5
  1920. [11] => ATTEMPTS
  1921. [12] => ACKNOWLEDGED
  1922. [13] => LINES
  1923. [14] => SALES
  1924. [15] => REFERENCE
  1925. [16] => TIMESTAMP
  1926. [17] => DUE_DATE
  1927. )
  1928.  
  1929. [ECSALES_SPLIT] => Array
  1930. (
  1931. [0] => TYPE
  1932. [1] => ID
  1933. [2] => NOMINAL_CODE
  1934. [3] => DATE
  1935. [4] => REF
  1936. [5] => DETAILS
  1937. [6] => NET
  1938. [7] => TRIANGULATED
  1939. [8] => COUNTRY_CODE
  1940. [9] => VAT_NUMBER
  1941. [10] => ACCOUNT_REF
  1942. [11] => INDICATOR
  1943. )
  1944.  
  1945. [ECSALES_FILL] => Array
  1946. (
  1947. [0] => COUNTRY_CODE
  1948. [1] => VAT_NUMBER
  1949. [2] => NET
  1950. [3] => PENCE
  1951. [4] => INDICATOR
  1952. [5] => SUBMISSION
  1953. [6] => ACCOUNT_REF
  1954. [7] => COLLECTION_KEY
  1955. [8] => SUBMISSION_ATTEMPTS
  1956. [9] => SUBMISSION_ACKNOWLEDGED
  1957. [10] => SUBMISSION_ERRORS
  1958. )
  1959.  
  1960. [VAT_DETAILS] => Array
  1961. (
  1962. [0] => VAT_BOX
  1963. [1] => VAT_BOX_NAME
  1964. [2] => TAX_CODE
  1965. [3] => TRANSACTION_ID
  1966. [4] => TRANSACTION_TYPE
  1967. [5] => ACCOUNT
  1968. [6] => NOMINAL
  1969. [7] => REF
  1970. [8] => DATE
  1971. [9] => DETAILS
  1972. [10] => AMOUNT
  1973. [11] => VAT_FLAG_CODE
  1974. [12] => VAT_TRAN_NAME
  1975. )
  1976.  
  1977. [VAT_ADJUSTMENT] => Array
  1978. (
  1979. [0] => VAT_BOX
  1980. [1] => REASON
  1981. [2] => VALUE
  1982. )
  1983.  
  1984. [VAT_RETURN_RECEIPT] => Array
  1985. (
  1986. [0] => UNIQUE_ID
  1987. [1] => RECEIPT_TYPE
  1988. [2] => VAT_AMOUNT
  1989. [3] => PERIOD_START
  1990. [4] => PERIOD_END
  1991. [5] => CURRENCY_SYMBOL
  1992. [6] => DUE_DATE
  1993. [7] => HMRC_REFERENCE
  1994. [8] => RECEIPT_TIMESTAMP
  1995. [9] => PAYMENT_DATE
  1996. [10] => DIRECTDEBIT_STATUS
  1997. [11] => NARRATIVE
  1998. [12] => EXTRAINFO
  1999. [13] => RECORD_CREATE_DATE
  2000. [14] => RECORD_MODIFY_DATE
  2001. [15] => RECORD_DELETED
  2002. )
  2003.  
  2004. [VAT_REV_CHARGE_HEADER] => Array
  2005. (
  2006. [0] => DATE_FROM
  2007. [1] => DATE_TO
  2008. [2] => VAT_NUMBER
  2009. [3] => NAME
  2010. [4] => ADDRESS_1
  2011. [5] => ADDRESS_2
  2012. [6] => ADDRESS_3
  2013. )
  2014.  
  2015. [VAT_REV_CHARGE_RETURN] => Array
  2016. (
  2017. [0] => CUSTOMER_REF
  2018. [1] => VAT_NUMBER
  2019. [2] => MONTH_1
  2020. [3] => MONTH_2
  2021. [4] => MONTH_3
  2022. [5] => MONTH_4
  2023. [6] => MONTH_5
  2024. [7] => MONTH_6
  2025. [8] => MONTH_7
  2026. [9] => MONTH_8
  2027. [10] => MONTH_9
  2028. [11] => MONTH_10
  2029. [12] => MONTH_11
  2030. [13] => MONTH_12
  2031. )
  2032.  
  2033. [VAT_REV_CHARGE_DETAIL] => Array
  2034. (
  2035. [0] => CUSTOMER_REF
  2036. [1] => VAT_NUMBER
  2037. [2] => TRANS_NO
  2038. [3] => TRAN_TYPE
  2039. [4] => NOMINAL_REF
  2040. [5] => DATE
  2041. [6] => AMOUNT
  2042. )
  2043.  
  2044. [CALENDAR_EVENT] => Array
  2045. (
  2046. [0] => UNIQUE_ID
  2047. [1] => OCCURRENCE_TYPE
  2048. [2] => RECURRENCE_PATTERN_ID
  2049. [3] => IS_DELETED_OCCURRENCE
  2050. [4] => ORIGINAL_START_TIME
  2051. [5] => ORIGINAL_END_TIME
  2052. [6] => IS_ALL_DAY_EVENT
  2053. [7] => HAS_REMINDER
  2054. [8] => REMINDER_MINUTES_BEFORE_START
  2055. [9] => NEXTREMINDERTIME
  2056. [10] => CREATION_TIME
  2057. [11] => LAST_MODIFICATION_TIME
  2058. [12] => START_TIME
  2059. [13] => END_TIME
  2060. [14] => BUSY_STATUS
  2061. [15] => IMPORTANCE
  2062. [16] => LABEL_ID
  2063. [17] => SUBJECT
  2064. [18] => LOCATION
  2065. [19] => USERNAME
  2066. [20] => OFFSET
  2067. [21] => ACCOUNT
  2068. [22] => ACCOUNTTYPE
  2069. [23] => CONTACT
  2070. [24] => IS_COMPLETED
  2071. [25] => RECORD_CREATE_DATE
  2072. [26] => RECORD_MODIFY_DATE
  2073. [27] => RECORD_DELETED
  2074. )
  2075.  
  2076. [CALENDAR_EVENT_LABEL] => Array
  2077. (
  2078. [0] => UNIQUE_ID
  2079. [1] => NAME
  2080. [2] => COLOR
  2081. [3] => READ_ONLY
  2082. [4] => RECORD_CREATE_DATE
  2083. [5] => RECORD_MODIFY_DATE
  2084. [6] => RECORD_DELETED
  2085. [7] => UNIQUE_ID
  2086. [8] => NAME
  2087. [9] => COLOR
  2088. [10] => READ_ONLY
  2089. [11] => RECORD_CREATE_DATE
  2090. [12] => RECORD_MODIFY_DATE
  2091. [13] => RECORD_DELETED
  2092. )
  2093.  
  2094. [CALENDAR_EVENT_LOCATION] => Array
  2095. (
  2096. [0] => LOCATION
  2097. [1] => POSITION_IN_LIST
  2098. [2] => RECORD_CREATE_DATE
  2099. [3] => RECORD_MODIFY_DATE
  2100. [4] => RECORD_DELETED
  2101. )
  2102.  
  2103. [CALENDAR_RECURRENCE_PATTERN] => Array
  2104. (
  2105. [0] => UNIQUE_ID
  2106. [1] => START_TIME
  2107. [2] => DURATION_IN_MINUTES
  2108. [3] => RECURRENCE_PERIOD
  2109. [4] => DAILY_WEEKDAYS_ONLY
  2110. [5] => DAILY_INTERVAL_IN_DAYS
  2111. [6] => WEEKLY_INTERVAL_IN_WEEKS
  2112. [7] => WEEKLY_DAYS_OF_WEEK
  2113. [8] => MONTHLY_INTERVAL_IN_MONTHS
  2114. [9] => MONTHLY_DAY_OF_MONTH
  2115. [10] => MONTHLY_NTH_INTERVAL_IN_MONTHS
  2116. [11] => MONTHLY_NTH_DAY_OCCURRENCE
  2117. [12] => MONTHLY_NTH_DAY_OF_WEEK
  2118. [13] => YEARLY_MONTH_OF_YEAR
  2119. [14] => YEARLY_DAY_OF_MONTH
  2120. [15] => YEARLY_NTH_DAY_OCCURRENCE
  2121. [16] => YEARLY_NTH_DAY_OF_WEEK
  2122. [17] => YEARLY_NTH_MONTH_OF_YEAR
  2123. [18] => START_DATE
  2124. [19] => END_TYPE
  2125. [20] => END_DATE
  2126. [21] => TOTAL_OCCURRENCES
  2127. [22] => RECORD_CREATE_DATE
  2128. [23] => RECORD_MODIFY_DATE
  2129. [24] => RECORD_DELETED
  2130. )
  2131.  
  2132. [CONTACT_HISTORY] => Array
  2133. (
  2134. [0] => UNIQUE_ID
  2135. [1] => SAL_PUR
  2136. [2] => REFN
  2137. [3] => MAJOR_TYPE
  2138. [4] => CONTACT_TYPE
  2139. [5] => CONTACT_DATE
  2140. [6] => CONTACT
  2141. [7] => TELEPHONE
  2142. [8] => STYLE
  2143. [9] => LOCATION
  2144. [10] => USERNAME
  2145. [11] => OUTCOME
  2146. [12] => PROMISED_PAYMENT
  2147. [13] => PROMISED_PAYMENT_DATE
  2148. [14] => FOLLOW_UP_DATE
  2149. [15] => OFFSET
  2150. [16] => BALANCE
  2151. [17] => START
  2152. [18] => END
  2153. [19] => DURATION
  2154. [20] => FOLLOW_UP_EVENT_ID
  2155. [21] => SUBJECT
  2156. [22] => ADDRESS1
  2157. [23] => ADDRESS2
  2158. [24] => ADDRESS3
  2159. [25] => ADDRESS4
  2160. [26] => ADDRESS5
  2161. [27] => FOLLOW_UP_TIME
  2162. [28] => NOTES1
  2163. [29] => NOTES2
  2164. [30] => NOTES3
  2165. [31] => RECORD_CREATE_DATE
  2166. [32] => RECORD_MODIFY_DATE
  2167. [33] => RECORD_DELETED
  2168. )
  2169.  
  2170. [LETTER_TYPE] => Array
  2171. (
  2172. [0] => UNIQUE_ID
  2173. [1] => LETTER_TYPE
  2174. [2] => DESCRIPTION
  2175. [3] => USED_FOR_CUSTOMERS
  2176. [4] => USED_FOR_SUPPLIERS
  2177. [5] => RECORD_CREATE_DATE
  2178. [6] => RECORD_MODIFY_DATE
  2179. [7] => RECORD_DELETED
  2180. )
  2181.  
  2182. [COMMUNICATION_ADDRESS] => Array
  2183. (
  2184. [0] => ACCOUNT_TYPE
  2185. [1] => ACCOUNT_REF
  2186. [2] => LETTER_TYPE_ID
  2187. [3] => ADDRESS_REF
  2188. [4] => ADDRESS_ID
  2189. [5] => PREFERRED_EMAIL
  2190. [6] => RECORD_CREATE_DATE
  2191. [7] => RECORD_MODIFY_DATE
  2192. [8] => RECORD_DELETED
  2193. )
  2194.  
  2195. [EC_VAT_DESCRIPTION] => Array
  2196. (
  2197. [0] => UNIQUE_ID
  2198. [1] => DESCRIPTION
  2199. [2] => RECORD_CREATE_DATE
  2200. [3] => RECORD_MODIFY_DATE
  2201. [4] => RECORD_DELETED
  2202. )
  2203.  
  2204. [CONTACT_HISTORY_CONTACT_MAJOR_TYPE] => Array
  2205. (
  2206. [0] => UNIQUE_ID
  2207. [1] => CONTACT_MAJOR_TYPE
  2208. [2] => DESCRIPTION
  2209. [3] => RECORD_CREATE_DATE
  2210. [4] => RECORD_MODIFY_DATE
  2211. [5] => RECORD_DELETED
  2212. )
  2213.  
  2214. [CONTACT_HISTORY_CONTACT_TYPE] => Array
  2215. (
  2216. [0] => UNIQUE_ID
  2217. [1] => CONTACT_TYPE
  2218. [2] => DESCRIPTION
  2219. [3] => CONTACT_MAJOR_TYPE
  2220. [4] => RECORD_CREATE_DATE
  2221. [5] => RECORD_MODIFY_DATE
  2222. [6] => RECORD_DELETED
  2223. )
  2224.  
  2225. [CONTACT_HISTORY_CONTACT_OUTCOME] => Array
  2226. (
  2227. [0] => UNIQUE_ID
  2228. [1] => OUTCOME_TYPE
  2229. [2] => DESCRIPTION
  2230. [3] => RECORD_CREATE_DATE
  2231. [4] => RECORD_MODIFY_DATE
  2232. [5] => RECORD_DELETED
  2233. )
  2234.  
  2235. [DELETED_RECORDS] => Array
  2236. (
  2237. [0] => TABLE_ID
  2238. [1] => FOREIGN_REF
  2239. [2] => DELETION_DATE_TIME
  2240. [3] => FOREIGN_REF_TYPE
  2241. [4] => RECORD_CREATE_DATE
  2242. [5] => RECORD_MODIFY_DATE
  2243. [6] => RECORD_DELETED
  2244. )
  2245.  
  2246. [PAYMENT_METHOD] => Array
  2247. (
  2248. [0] => UNIQUE_ID
  2249. [1] => DESCRIPTION
  2250. [2] => ONLINE
  2251. [3] => READONLY
  2252. [4] => RECORD_CREATE_DATE
  2253. [5] => RECORD_MODIFY_DATE
  2254. [6] => RECORD_DELETED
  2255. )
  2256.  
  2257. [REMITTANCE] => Array
  2258. (
  2259. [0] => URN
  2260. [1] => BANK_CODE
  2261. [2] => ACCOUNT_REF
  2262. [3] => NAME
  2263. [4] => ADDRESS_1
  2264. [5] => ADDRESS_2
  2265. [6] => ADDRESS_3
  2266. [7] => ADDRESS_4
  2267. [8] => ADDRESS_5
  2268. [9] => C_ADDRESS_1
  2269. [10] => C_ADDRESS_2
  2270. [11] => C_ADDRESS_3
  2271. [12] => C_ADDRESS_4
  2272. [13] => C_ADDRESS_5
  2273. [14] => TELEPHONE
  2274. [15] => FAX
  2275. [16] => CHEQUE
  2276. [17] => DATE
  2277. [18] => TYPE
  2278. [19] => INVOICE_DATE
  2279. [20] => INV_REF
  2280. [21] => EXTRA_REF
  2281. [22] => DETAILS
  2282. [23] => TAX_CODE
  2283. [24] => NET_AMOUNT
  2284. [25] => TAX_AMOUNT
  2285. [26] => GROSS_AMOUNT
  2286. [27] => PAYMENT
  2287. [28] => FOREIGN_RATE
  2288. [29] => CURRENCY
  2289. [30] => PRINTED_FLAG
  2290. [31] => PAID_FLAG
  2291. [32] => LAST_LINE
  2292. [33] => RECORD_CREATE_DATE
  2293. [34] => RECORD_MODIFY_DATE
  2294. [35] => RECORD_DELETED
  2295. )
  2296.  
  2297. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!