cancel
Showing results for 
Search instead for 
Did you mean: 

Attachment Field in a sales order

Alejandro_Ruiz
Participant
0 Kudos

Good Afternoon

Can you help me telling me that functionality meets the Attachment field in a sales order, because when files attached annexes the sales order form is the field is updated.

Best Regards

Alejandro Ruiz

Accepted Solutions (0)

Answers (2)

Answers (2)

Alejandro_Ruiz
Participant
0 Kudos

Good Morning

Marcelo thanks for your help but still do not understand the functionality of the Attachment field in the sales order form.

I appreciate your cooperation

Luis Alejandro Ruiz

Former Member
0 Kudos

Luis, ¿que es exactamente a lo que te refieres con funcionalidad?

¿Lo que te dice Marcelo no es lo que requieres de informacion ?

El campo attachment en la orden de venta liga al campo ORDR.AtcEntry para poderlo relacionar con el resto de la informacion se requiere ligarlo al campo ATC1.AbsEntry y de ahi podemos ligarlo con todo el resto de la informacion que puso Marcelo y que pego aquí abajo.

TABLA ORDR - Sales Order

ORDR.AtcEntry = Atc1.AbsEntry <<<<< CAMPO LLAVE >>>>>>

Atc1.trgtPath                                  <<<<<CAMPO QUE GUARDA LA RUTA DEL ARCHIVO>>>>>

Atc1.FileName                              <<<<<<<<<CAMPO QUE GUARDA EL NOMBRE DEL ARCHIVO>>>>>

Atc1.Date                                       <<<<<<<<<<<CAMPO QUE GUARDA LA FECHA DEL ARCHIVO>>>>>

---------------------------------

Ahora, el campo en efecto se actualiza al momento de que anexas un archivo, se actualizara con un numero; por ejemplo 2132156 y este se guardara en ORDR.AtcEntry y se creara una nueva entrada en ATC1.AbsEntry con el mismo numero 2132156 y las subsecuentes Atc1.trgtPath, Atc1.FileName, Atc1.Date

espero te sirva, saludos

Alejandro_Ruiz
Participant
0 Kudos

good Days

Thanks Alberto for your information this is very useful, but I have a question to make a select on the table ORDR Attachment field always shows empty and have attached documents that we do not know when this field is updated by the application.

I appreciate your cooperation

Alejandro Ruiz

Former Member
0 Kudos

Luis try this query

SELECT docentry, docnum, cardcode, cardname, AtcEntry

from ORDR

where AtcEntry != ''

If there are some attachments in any of your sales orders then it should appear at the right row of the query.

Hope it helps you,

Alejandro_Ruiz
Participant
0 Kudos

Good Morning

Thanks for the explanation and the function is quite clear AtcEntry field, but the field to which I refer is "Attachment" ORDR table, does that field is traditionally used at what time?

I appreciate your cooperation

Alejandro Ruiz

Former Member
0 Kudos

Hi Alejandro, the field attachment at ORDR table its not clearly refered in SDK its mentioned only as ATTACHMENT its Text 16 leght ?¿ NFI

Former Member
0 Kudos

Alejandro,

Please check in (comprobar) SDK:

OQUT - Sales Quotation

OQUT.AtcEntry = Atc1.AbsEntry

Atc1.trgtPath

Atc1.FileName

Atc1.Date

ORDR - Sales Order

ORDR.AtcEntry = Atc1.AbsEntry

Atc1.trgtPath

Atc1.FileName

Atc1.Date

Regards (Saludos),

Marcelo Silva Santos