Uploading to the ACLOB table.

Question

Hi, 
 
 I was wondering of anyone has experience of uploading to the ACLOB table. We want to utilise the comments section in GESBPC and GESBPR for uploading Special Instructions on GESBPR and uploading Historical Sales Ledger / Credit Control comments to GESBPC. 
 I can see that these attach themselves via the ACLOB table, and then differentiated by CO_BPC and CO_BPR in the CODBLB_0 field. 
 Has anyone ever used this approach or something similair in terms of templates etc? 
 Version 12 - Patch 18 
 Many Thanks

Julien Patureau · Answer

Hi Craig, Text (so Clob) are managed in the standard template by using field prefixe with * + number. For instance BPC import template allows you to enter Order text using the field *71 and *72. The invoice text can be imported using *81 and *82. Are you trying to upload the standard Clob text ? If yes, just use the standard import template. Here is the extract of the Online help about the BPC import template: " 
 Import of plain texts into the customer file ( BPCUSTOMER table) 
 A "command text" and an "invoice text" may be imported into the template, using the global variable GIMP (by defining the areas *71...). 
 
 GIMP(71..78) is used to import a text that will be printed on the acknowledgments sent to the customer. It is possible to import a text of 8*100 characters i.e. 800 characters. 
 GIMP(81..88) is used to import a text that will be printed on the invoices sent to the customer. 
 
 "

Sage X3

Uploading to the ACLOB table.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING