icDomain | character | Parameter for the domaincode |
icSupplier | character | Parameter for the supplier. |
icSupplierFrom | character | Filteing parameter: supplier from. |
icSupplierTo | character | Filtering parameter: supplier to. |
icSite | character | Parameter: Site Code. |
icSiteFrom | character | Filtering parameter: Site From |
icSiteTo | character | Filtering parameter: Site To. |
icReceiver | character | Parameter: Receiver number. |
icReceiverFrom | character | Filtering Parameter: Reciever number from. |
icReceiverTo | character | Filtering parameter: receiver number to. |
itReceiptDate | date | Parameter: receipt date. |
itReceiptDateFrom | date | Filtering parameter: receipt date from. |
itReceiptDateTo | date | Filtering parameter: receipt date to. |
icLegalDoc | character | Parameter: legal document. |
icLegalDocFrom | character | Filtering parameter: legal document from. |
icLegalDocTo | character | Filtering parameter: Legal document to. |
itEffDate | date | Parameter: Effective Issue Date |
itEffDateFrom | date | Filtering parameter: effective issue date. |
itEffDateTo | date | Filtering parameter: effective issue date. |
field name | data type | db field | description |
---|---|---|---|
tclgd_doc_type | character | lgd_mstr.lgd_doc_type | Doc Type |
tclgd_domain | character | lgd_mstr.lgd_domain | Domain |
ttlgd_effdate | date | lgd_mstr.lgd_effdate | Effective Date |
tclgd_inv_nbr | character | lgd_mstr.lgd_inv_nbr | Invoice Number |
tclgd_nbr | character | lgd_mstr.lgd_nbr | Legal Doc Nbr |
tllgd_posted | logical | lgd_mstr.lgd_posted | Posted |
tclgd_ship | character | lgd_mstr.lgd_ship | Ship-To |
tclgd_shipper_id | character | lgd_mstr.lgd_shipper_id | Shipper ID |
tclgd_shipto_site | character | lgd_mstr.lgd_shipto_site | Ship-to Site |
tilgdd_line | integer | lgdd_det.lgdd_line | Line |
tclgdd_order | character | lgdd_det.lgdd_order | Order |
tilgdd_order_line | integer | lgdd_det.lgdd_order_line | Line |
tcpo_project1 | character | po_mstr.po_project | Project |
tipvo_cinvoice_id | integer | pvo_mstr.pvo_cinvoice_id | Invoice ID |
tcpvo_curr | character | pvo_mstr.pvo_curr | Currency |
tipvo_ers_opt | integer | pvo_mstr.pvo_ers_opt | ERS Option |
tipvo_ers_price_lst_opt | integer | pvo_mstr.pvo_ers_price_lst_opt | ERS Price List Option |
tipvo_ers_status | integer | pvo_mstr.pvo_ers_status | ERS Status |
tcpvo_external_ref | character | pvo_mstr.pvo_external_ref | External Reference |
tipvo_id | integer | pvo_mstr.pvo_id | Pending Voucher ID |
tcpvo_internal_ref | character | pvo_mstr.pvo_internal_ref | Internal Reference |
tcpvo_internal_ref_type | character | pvo_mstr.pvo_internal_ref_type | Internal Reference Type |
tcpvo_lc_charge | character | pvo_mstr.pvo_lc_charge | Logistics Charge Code |
tcpvo_part | character | pvo_mstr.pvo_part | Item Number |
tcpvo_shipto | character | pvo_mstr.pvo_shipto | Ship-To |
tcpvo_supplier | character | pvo_mstr.pvo_supplier | Supplier |
ttpvo_trans_date | date | pvo_mstr.pvo_trans_date | Transaction Date |
tipvod_id_line | integer | pvod_det.pvod_id_line | Line |
tdpvod_trans_qty | decimal | pvod_det.pvod_trans_qty | Transaction Qty |